CERTIFICATE COURSE IN ADVANCED EXCEL
COURSE COVERAGE
ADVANCED EXCEL:
Introduction To Ms Excel And Understanding Basic Working With It – Formatting Worksheet – Working With Formulas/functions (lookup And Reference Functions, Logical Functions, Database Functions, Date And Time Functions, Information Function, Mathand 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 Straing 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.