Microsoft Excel 2019 (Advance)

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Objectives:

• Create Subtotal Using the Subtotal Function
• Analyze data Using Pivot Tables
• Perform What If Analysis using:
  • Goal Seek
  • Solver
  • Input Table
  • Scenarios
• Use VLOOKUP function to extract data
• Nesting INDEX and MATCH Function
• Combining & Consolidating Data
• Summarizing & Analyzing with Pivot Table and Pivot Charts
• Record and Run a Macro

Outline:

• Module 1: Organize Summary And Details On Your Data
• Module 2: Planning, Forecasting & Projection Of Your Data
• Module 3: Retrieve, Compare Or Compiling Data With Functions
• Module 4: Present Data With Visual Report
• Module 5: Summarizing And Analyzing Data With Pivottable, Slicer And Pivotcharts
• Module 6: Navigating Large Workbooks
• Module 7: Automate Task With Macros
• Module 8: Prevent User Changes With Protection