OBJECTIVE: -   

This is an advanced course which will helps you to give the basics   of excel and covers all  the enriched features in Microsoft excel 2016, including macros, pivot table, audit & analyze worksheets, use advance formulas & functions, work with multiple worksheets and workbooks etc. which in turn increases  productivity, improves efficiency by streaming the workflow thus  becomes a major asset  for  professional employees. 

COURSE DURATION :-

• 2 Months /72 Hrs.

COURSE OUTLINE

•  Introducing excel
•  Entering and editing worksheet data
•  Essential worksheet operations
•  Working with cells and ranges
•  Introducing tables
•  Worksheet formatting
•  Understanding excel files
•  Using and creating templates
•  Printing your work
•  Working with formulas/functions
•  Conditional formatting
•  Data sorting and filtering
•  Charts
•  Auditing
•  Pivot tables
•  Pivot charts
•  Working with data
•  What-if analysis
•  Exporting and importing
•  Reviewing a workbook/worksheet
•  Vba macro