OBJECTIVE :

Upon completion of this course, the participant will be an expert in advanced Excel features including macro programming and functions.

TARGET AUDIENCE :

BBA, MBA Students, Data Analyst, Auditor, BPOs, Call centres professionals, Data conversion technicians, Programmers.

OVERVIEW :

This course helps in promoting Excel professionals in advanced stage.

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 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.