1. EXCEL 2021 – LEVEL 2: INTERMEDIATE KNOWLEDGE

This module offers interactive training composed of 61 training videos, 61 practice exercises, and 5 additional information points.

1.1 Work with More Complex Tables

• Displaying multiple lines in a cell
• Absolute references in formulas
• Copying values, linked copies, and transposition
• Entering calculation functions
• System dates and date formats
• Simple conditions
• Custom formats
• Conditional formatting
• Managing conditional formatting
• Naming cell ranges
• Validation criteria
• Cell ranges in functions

1.2 Present Your Data with Charts

• Introduction to charts
• Creating and moving charts
• Managing charts
• Selecting chart elements
• Adding and deleting elements
• Formatting chart elements
• Editing chart text elements
• Legends and plot areas
• Printing and page setup for charts

1.3 Improve Chart Presentation

• Modifying data labels
• Data series and chart axes
• Managing series
• Chart type options
• Managing chart templates
• Creating 2D map charts
• Creating sparkline charts
• Managing sparkline charts

1.4 Enhance Your Tables

• Creating graphic objects
• Selecting and deleting objects
• Copying and moving objects
• Resizing graphic objects
• Editing text boxes
• Editing drawings
• Formatting drawing objects
• Inserting images
• Managing images
• Rotating and aligning objects
• Layering and grouping objects

1.5 Work with Data Lists

• Flash Fill
• Calculating subtotals
• Creating and managing data tables
• Formatting and sorting data tables
• Adding calculations to data tables
• AutoFilter
• Custom filters
• Blank values and duplicates
• Criteria ranges
• Using criteria ranges
• Filtering and copying rows with criteria ranges
• Statistics using criteria ranges
• Sorting and filtering functions

1.6 Create and Use Pivot Tables and Pivot Charts

• Introduction to pivot tables and pivot charts
• Creating pivot tables
• Modifying and adding calculations in pivot tables
• Changing the data source of a pivot table
• Selecting, copying, moving, and deleting within a pivot table
• Structure and printing of pivot tables
• Formatting pivot tables
• Filtering pivot tables
• Filtering with slicers
• Creating pivot tables from multiple tables
• Adding calculated fields or items
• Grouping data
• Creating pivot charts

2. EXCEL 2021 – LEVEL 3: ADVANCED KNOWLEDGE

This module offers interactive training composed of 39 training videos, 39 practice exercises, and 5 additional information points.

2.1 Improve Your Efficiency

• Data conversion
• Creating data series
• Custom views
• Cell comments/notes
• Error checking
• Formula evaluation
• Watch Window

2.2 Use Advanced Calculation Functions

• Lookup tables and search functions
• Text functions
• Time calculations
• Date calculations
• AND, OR, NOT conditions
• Nested conditions
• Conditional functions
• Array formulas
• Calculations during copies
• Consolidation
• Financial functions
• Two-variable data tables

2.3 Discover Advanced Features

• Goal Seek
• Solver
• Scenario Manager
• Hyperlinks
• Styles and templates
• Creating and customizing themes
• Creating and using templates
• Import/export and interoperability with Excel
• Modifying and deleting templates
• Exporting Excel data: PDF, XPS, email, and web pages
• Converting Excel files
• Importing data
• Refreshing and managing imported data
• Workbook properties

2.4 Share Securely

• Workbook protection
• Cell protection
• Workbook sharing
• Finalizing a workbook
• Creating forms
• Protecting and using forms

2.5 Learn Even More

• Macros
• File versioning and recovery
• Ribbon customization
• Spreadsheet best practices
• Workbook collaboration