Advanced Excel Course
What you'll learn
Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
Automate, streamline, and completely revolutionize your workflow with Excel
Master unique tips & techniques that you won't find in ANY other course, guaranteed
Explore fun, interactive, and highly effective demos from a best-selling Excel instructor
Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
Write advanced conditional, text, date, and lookup functions, including XLOOKUP & Dynamic Arrays
Creo Parametric Course
What you'll learn
Understanding Creo Parametric concepts
Create and modify 2D sketches on datum planes.
Sketching geometry and using tools
Create part features using: extrude, revolve, blend, hole, shell and sweep functions.
Creating datum planes and datum axes
Create parametric relationships between features and modify features Laying out drawings and creating views
Comprehensive two part Design Project
Selecting and editing geometry, features, and models
Learn advance modelling process
Learning how to use the Creo Parametric interface
Generate and dimension a multi view orthographic drawing.
Annotate notes and text on drawings.
Build a 3D assembly.
Mechanism (Gear, Cam follower, Piston cylinder, Slider crank etc.)
Animation ( Snapshot)
Manufacturing (Use application vericut)
Basic simulation
Drawing view and BOM (Bill of material)
Control and modify the operating environmental settings.
Complete work accurately, with attention to detail. Assembling with connections
Create Engineering, Industrial Graphics & Design in 3D or 2D
Diploma in Financial Market Management Course
What you'll learn
A market maker's perspective
FX transaction process and pricing trades
Technical Analysis best practices that can be used in any market
Money management strategies - stop loss and take profit strategies
Direct and Indirect taxes
What you'll learn
Understanding Indian Income Tax in the most simple manner
Become an expert in computing Total Income and Tax Liability of various assessees
Learn how to easily memorise sections of income tax, and put them to use in case studies
Efficiently prepare yourself for Professional exams like CA, CMA, CS, MBA , MCom, BCom etc.
E-Accounting Institute in Delhi
What you'll learn
An Introduction to Accounting, The Double Entry Accounting System, & Recording Transactions using Debits and Credits
Analyze, use, and create from scratch financial statements including a balance sheet, income statement, statement of equity, and statement of cash flows
Use the concepts of the double entry accounting system
Record financial transactions using the accounting equation
Record financial transactions using debits and credits
Learn when and how to use accounting methods such a the accrual method and cash method
Apply the concepts related to the revenue recognition principle and the matching principle to recording transactions and reading financial statements
Record period end adjusting entries and be able to explain why adjusting entries are necessary is a well designed accounting system
Record merchandising transactions. Record transactions involving inventory
Track inventory using cost flow methods like FIFO, LIFO, and Weighted Average Methods
Create and use subsidiary ledgers like accounts receivable by customer and accounts payable by vendor subsidiary ledgers
Learn how to create and use special journals and how they can be part of an accounting system
Construct and interpret a bank reconciliation, one of the most critical internal controls
Be able to implement internal controls over cash
Value account receivable and record bad debt expense using either the allowance method or direct write off method
Calculate depreciation using different depreciation methods including straight line depreciation, double declining balance, & units of production depreciation
Record payroll transactions and calculate net pay and income tax withholding
Record transaction specific to partnerships including methods to allocate net income to the partners, adding a new partner, and a partner leaving or selling a partnership interest
Record transaction specific to a corporation including selling capital stock, selling preferred stock, buying treasury stock, issuing cash dividends, and issuing stock dividends
Record transactions related to the issuance of bonds
Record transactions related to notes payable. Learn to create an amortization table.
Construct a statement of cash flows using the direct method and indirect method. We go into more detail about best practices to construct a statement of cash flows than any other course we have seen
Excel VBA Macros Course
What you'll learn
By the end of this course, you will be confidently writing VBA macros which automate procedures in Microsoft Excel.
You will fully understand the purpose and syntax of each line of code that you write.
You will not simply be entering lines of code because you have been told they will produce a certain result.
You will gain a solid understanding of both the VBA and Excel object models which underly VBA programming.
Fundamental analysis Crash Course
What you'll learn
Understand the role of a Business Analyst
About tools and techniques you can use as a Business Analyst
Key concepts in Business Analysis
How to kick-start your career as a Business Analyst
How to gather, group, prioritize and validate requirements
Where to find job opportunities as a BA and how much a BA earns
How to continue learning about Business Analysis
Goods and Services Tax (GST) Course
What you'll learn
GST (Goods and Services Tax) in India
Supply under GST
Charge of GST
Exemptions from GST
Place of Supply - Definitions, Sections 10, 11, 12(i), 12(ii), 13
Time of Supply - Definitions, Sections 12, 13, 14
Value of Supply - Definitions, Provisions, Rules
Input Tax Credit - Definitions, Blocked Credits, Apportionment of Blocked Credits
Blocked Credit in Special Circumstances - Section 18
Distribution of Credit by ISD - Sections 20 & 21
Input Tax Credit - Section 16
Registration - Sections 22, 23, 24, 25, 26 to 30, Rules
Tax Invoice - Definitions, Section 31, e-Invoicing, Special Cases
Credit and Debit Notes
Accounts and Records
Electronic Way Bill
Payment of Tax - Definitions, Sections 49, 50
GST Returns
Import and Export under GST
Import of Goods & Services under GST
Registration and ITC in case of Import of Goods and Services
GST Refunds
Job Work
Assessment and Audit of GST
Inspection, Search, Seizure, Arrest
Demands and Recovery - Definitions, Sections 73, 74, 75, 76, 77, 78 to 84
Liability to pay in certain cases
Offences and Penalties under GST - Definitions, Sections 122, 123, 124, 130, 131, 138, Rules
Advance Ruling
Appeals and Revision
TDS and TCS for GST
Miscellaneous Provisions
- 1
- 2
