Advanced Excel

This course is outlined in a way that it covers majority of enriched features in Microsoft Excel 2021, including Macros, Pivot tables, Audit and Analyze worksheets, Use Advance Formulas and Functions, work with multiple Worksheets and Workbooks, etc., which in turn increases productivity, improves efficiency by streamlining the workflow thus becomes a major asset for professional employees.

Course Outline:

• Introduction To MS Excel And Understanding Basic Working With It 
• 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