Excel Macros & VBA for Excel Report Automation

Learn Macros Step by Step till Report Automation (End to End)

Created by: Ramzan Rajani
Microsoft Certified Trainer & Microsoft office Specialist

What Will I Learn?

• 1) Macros Recording & Running and will start with Basic Codings
• 2) You will learn how to Consolidate Multiple Sheets into one
• 3) Filtering Project : Where you will learn to create Seperate Sheet for each Filtered items with Simple Coding
• 4) You will also learn how to Implement IF Condition with Macros (VBA)
• 5) Consolidation Project : You will learn how to write the Code to Consolidate Multiple Sheets of Multiple Files

Requirements

• MS Excel 2010 & above version
• Basic Knowledge of Excel Formulas

Target audience

• Those interested in learning Excel Macros to Automate Regular reports
• Finance Professionals
• Marketing Executives
• Admin
• HR Professionals
• Project Co-ordinators
• Account Professionals