Course Outline

1 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
  • Topic A: Use Links and External References
  • Topic B: Use 3-D References
  • Topic C: Consolidate Data
2 - SHARING AND PROTECTING WORKBOOKS
  • Topic A: Collaborate on a Workbook
  • Topic B: Protect Worksheets and Workbooks
3 - AUTOMATING WORKBOOK FUNCTIONALITY
  • Topic A: Apply Data Validation
  • Topic B: Search for Invalid Data and Formulas with Errors
  • Topic C: Work with Macros
4 - USING LOOKUP FUNCTIONS AND FORMULA AUDITING
  • Topic A: Use Lookup Functions
  • Topic B: Trace Cells
  • Topic C: Watch and Evaluate Formulas
5 - FORECASTING DATA
  • Topic A: Determine Potential Outcomes Using Data Tables
  • Topic B: Determine Potential Outcomes Using Scenarios
  • Topic C: Use the Goal Seek Feature
  • Topic D: Forecast Data Trends
6 - CREATING SPARKLINES AND MAPPING DATA
  • Topic A: Create Sparklines
  • Topic B: Map Data

Requirements

To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2019. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment. To meet these prerequisites, students can take the following courses, or should possess the equivalent skill level:

Microsoft® Office Excel® 2019: Basic

Microsoft® Office Excel® 2019: Intermediate

  7 Hours
 

Testimonials (10)

Related Courses

Microsoft Office Excel - intermediate level

  14 Hours

Related Categories