Home Tution at Student's place or at my place Training at institute in Indirapuram-GZB

Topics Covered

Basic MS Excel : Working with Excel Advance MS Excel : Vlookup, Hlookup, Match, Index, Rank, If, nested if, Pivot table, Charts, Arrays, Formulation in MS Excel with Advance Data Analysis techniques Macro: Recording, Interpreting VBA of recorded Macro VBA : Writing VBA Code and Automation using VBA, Macro on Excel MS Access : Basic MS Access , MS Access as relational database, Queries design and development

Who should attend

MIS Professional, Analyst, Financial Reporting professional, Data Analyst, Student, Data Interpretation, Professionals who are using MS Excel and interested to have knowledge of Macro, VBA and Advance Excel.

Pre-requisites

Basic Excel Course : No Pre-requisite Advance Excel : working knowledge of spreadsheet Macro and VBA : Working knowledge of Excel

What you need to bring

Laptop (not mandatory))"

Key Takeaways

Knowledge with practical experience Tips and Tricks of Excel, Macro, VBA