BECOME AWESOME IN EXCEL!!! A complete Excel, Advanced Excel training with VBA Macro training for those people who are interested to go in MIS Department, like to work as Data Analyst, HRA Excecutive and Other anlytical positions. Free Job assistance and career Counseling

Topics Covered

EXCEL ===== Excel Formula If/Nested if condition condition formatting validation Name Range dynamic name range subtotal Vlookup/ Hlookup Pivot Table Graph Dynamic Graph Subtotal Data consolidation etc VBA ==== Basic Programming Concept Working Cells, Range, Sheets, Workbook Objects If and Nested If Condition Loops (For, While, Do While, Do Until) Recording/Editing Macros Difference between subs and Functions Array and For Each Loop FSO (File System object) Reading /Writing Text files Data consolidation Working with user form How to send mail through outlook How to create add-in Creation of own menu bar etc

Who should attend

Want to work as Mis Executive Data Analyst Business Analyst HRAExecutive

Pre-requisites

Basic Excel knowledge

What you need to bring

Pen and Notebook"

Key Takeaways

Skilled and confident in Excel and VBA.