Upon completion of this course, the participant will be an expert in advanced excel features including macro programming and functions.
BBA / MBA Students, / Data Analyst,BPOs,call centers professionals,data conversion technicians ,programmers.
This course helps in promoting excel professionals in advanced stage.
2 MONTHS
COURSE COVERAGE
COURSE COVERAGE
Introduction to MS Excel and Understanding Basic Working with It - formatting Worksheet - Working eith Formulas / functions ,Database functions ,Math and trigonometry functions, - Statistical functions,text functions - conditional formatting - connect to other database - data Sorting and filtering - pivote tables & charts.
VBA PROGRAMMING
VBA overview - VBA Programming Variables - Conditional logic - string functions - programming Loops - Programming arrays - Subs and Functions - creating your first Macro - Excel VBA - Excel Objects - Excels Events - Excel VBA Error Handiling - Excel VBA and User Forms - Connect with an external data - work on automations project
Advanced Excel
introduction to MS Excels and understanding Basic Working with it - working with formalas/functions (Lookup and reference,functions,logical functions,information functions,math and trigonometry functions,statistical functions,text functions) - conditional formatting - connet to other database - data sorting and filtering - pivot tables & charts.