In this course you will be taught with baaic excel and VBA concepts which can help you in becoming VBA master.

No Prerequisite required

Everyone interested in learning Excel and VBA concepts can join this course.

Course Content:

1. An Introduction to Excel 

2. Intermediate Level Excel

3.Advanced Excel

4. Excel VBA and macros training

Below are just a few of the topics that you will master:

• Creating effective spreadsheets
• Managing large sets of data
• Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more)
• Create dynamic report with Excel PivotTables
• Unlock the power and versatility of Microsoft Excel's AddIn, PowerPivot
• Audit Excel Worksheet formulas to ensure clean formulas
• Automate your day to day Excel tasks by mastering the power of Macros and VBA

What am I going to get from this course?

• Master Microsoft Excel from Beginner 
• Build a solid understanding on the Basics of Microsoft Excel
• Learn the most common Excel functions used in the Office
• Power of Microsoft Excel by automating your day to day tasks through Macros and VBA
• Maintain large sets of Excel data in a list or table
• Create dynamic reports by mastering one of the most popular tools, PivotTables

Post training you will be provided with 4 projects to become well versed in VBA concepts.