MIS Training – Advance Excel + Macro + Access + SQL
What you'll learn
Advance Level Excel
Expertise in Using Text Function
Expertise in Using Logical Function
Expertise in Using Math Function
Expertise in Using Lookup & Reference Function
Expertise in Using Date and Time Function
Expertise in Using Pivot Table and Chart
Expertise in Power Pivot and Power Map
Expertise in Using What-If Analysis Tools
Many Others Excel Tools
MS Access Knowledge on Table, Form, Queries and Reports
SQL Queries
Macro Recording
Excel VBA Object Handling with practical Project
Excel VBA Variable with practical Project
Excel VBA IF & Case with practical Project
3 Types of Loop with practical Project
Create your own Function
Events in VBA
FSO in Excel VBA
Userform in Excel VBA
Automate Pivot and Outlook in Macro
Many More Macro Topics and Projects
Tally Prime Course in Delhi
What you'll learn
You will learn How to manage the Accounting of any Company with GST Independently
You will learn how to Manage Payroll with PF, ESI, EPF, Statutory Payment
You will learn how to compute TDS & extract TDS Reports
How to manage Accounting of Manufacturing Firm
Banking
You will learn how to Create MIS Reports for Managerial Level
How to create GST Computation & Reports in Tally.Erp9 with GST
You will learn how to manage the accounting of Goods Transport Agency(GTA) in Tally .Erp9 with GST
RCM - Reverse Charge Mechanism in Tally Erp9 with GST Training
You will learn how to manage the accounting of Composition Dealer under GST in Tally.Erp9 with GST Course
How to avail Input GST Credit
Import & Export Entries under GST
You will learn how to apply GST at Multiple Level
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
- 1
- 2
