1. EXCEL 2021 – LEVEL 1: ESSENTIAL KNOWLEDGE

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

1.1 Discover Excel and Complete a Table

• Introduction to spreadsheets
• Opening a workbook
• Overview of the environment
• Navigating within a workbook
• Data entry assistance
• Entering data
• Selection, copying, and moving data
• Selecting and clearing cells
• Undoing and redoing actions
• Column width/row height
• File saving basics
• Saving a workbook
• Editing cell content
• Creating a new workbook

1.2 Perform Your First Calculations

• Entering formulas
• Sum and other simple calculations
• Percentage calculations
• Copying formulas to adjacent cells

1.3 Format Your Data

• Simple number formats
• Applying a theme
• Highlighting text
• Font and font size
• Cell content alignment
• Cell colors
• Cell borders

1.4 Print and Set Up Your Workbooks

• Page setup
• Print preview and printing
• Page breaks
• Print area
• Headers and footers
• Header and footer customization

1.5 Become More Efficient

• Using Excel Help
• Spell checking
• Find and replace
• Zoom display
• Inserting/deleting rows, columns, and cells
• Moving cells
• Copying to non-adjacent cells
• Quick formatting copy
• Merging cells
• Text orientation
• Cell styles
• Data sorting

1.6 Manage Worksheets and Data Display

• Worksheet names and tab colors
• Inserting, deleting, and adding sheet backgrounds
• Moving, copying, and hiding worksheets
• Freeze panes and split windows
• Repeating row/column titles when printing
• Hiding worksheet elements
• Grouping data with outlines

2. EXCEL 2021 – LEVEL 2: INTERMEDIATE KNOWLEDGE

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

2.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

2.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

2.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

2.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

2.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

2.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