MIS Training – Advance Excel + Macro + Access + SQL
A Management Information System (MIS) provides organizations with the information they …
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
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
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
Email Marketing Course
Email marketing continues to be the backbone of online businesses. …
What you'll learn
Build a simple and easy Email System in just 2 weeks! Then just do maintainence!
Learn Copywriting the fun and easy way
Refresh yourself with the most successful marketing strategies of 2021
Tons of Copy and Paste Templates to instantly sell your Products and Services
Tons of Resources - Most popular headlines, subject lines, power words, and more
What you'll learn
Run a Google Adwords Campaign that captures high-quality leads for your business or website
