Certificate Course in Advanced Excel
Upon completion of this course, the participant will be an expert in advanced Excel features including macro programming and functions. This course helps in promoting Excel professionals in advanced stage.
Introduction to MS Excel - Formatting Worksheet - Working with Formulas/Functions (Lookup and Reference, Logical, Database, Date and Time, Information, Math and Trigonometry, Statistical, Text) - Conditional Formatting - Connect to other Database - Data Sorting and Filtering - Pivot Tables & Charts.
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.