Introduction to MS Excel and Understanding Basic Working with it – Formatting Worksheet – Working with Formulas/Functions(Lookup and Reference Functions, Logical Function, Database Functions, Date and Time Functions, Information functions, Math and Trigonometry Functions, Statistical Functions, Text Functions)-Conditional Formatting – Connect to other Database – Data Sorting and Filtering – Pivot Tables & Charts.
VBA Programming
VBA Overview – VBA Programming Variables – Conditional Logic – String and String Functions – Programming Loops – Programming Arrays – Subs and Functions – Creating your first Macro – Excel VBA – Excel Objects – Excel Events – Excel VBA Error Handling – Excel VBA and User Forms – Connect with an External data – Work on automation project.