CCAE Certificate Course in Advanced Excel

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.