Chat with us, powered by LiveChat
Skill Assess Learn Verify Improvement

Excel 2019 Basic

Complete Course to Display Score

Excel Fundamentals demo

Understand the Excel Screen Click To Try Not Started Not Started Not Started
Create Workbooks Not Started Not Started Not Started
Navigate Worksheets Not Started Not Started Not Started
Open Workbooks Not Started Not Started Not Started
Save Workbooks Not Started Not Started Not Started
AutoRecover Not Started Not Started Not Started
The Quick Access Toolbar Not Started Not Started Not Started
Print Not Started Not Started Not Started
Help Not Started Not Started Not Started
Close and Exit Not Started Not Started Not Started

Edit a Workbook lock Subscribe to unlock

Select Cells and Ranges
Edit Cell Data
Cut, Copy, and Paste
Undo, Redo, Repeat
More Pasting Options
Insert and Move Cells
Delete Cells
Check Spelling
Find and Replace Text
Hide Columns and Rows
Document Properties

Basic Formulas lock Subscribe to unlock

Formula Basics
AutoFill
Sums and Averages
MIN and MAX
COUNT

Basic Formatting lock Subscribe to unlock

Format Text
Align and Merge Cells
Format Numbers and Dates
Borders and Background Colors
Copy Formatting
Row Heights and Column Widths

Insert Objects lock Subscribe to unlock

Images
Shapes
Hyperlinks
Object Properties and Alt Text

Manage Worksheets lock Subscribe to unlock

View Worksheets
Multiple Windows
Move and Copy Worksheets
Insert, Rename, and Delete Worksheets
Freeze Rows and Columns
Hide Worksheets and Gridlines

Excel 2019 Intermediate

Complete Course to Display Score

Charts lock Subscribe to unlock

Create Charts
Move and Resize
Chart Types
Layout and Style
Titles and Legends
Gridlines, Labels, and Data Tables
Chart Elements
Modify Chart Data
Filter Charts
Trendlines
Dual-Axis Charts
Chart Templates
Sparklines

Print and Distribute lock Subscribe to unlock

Page Size and Scale
Print Area and Page Breaks
Print Titles, Gridlines, and Headings
Headers and Footers
Margins and Orientation
Inspect for Issues

Intermediate Formulas lock Subscribe to unlock

Reference External Worksheets
Absolute and Relative References
Order of Operations
Cell and Range Names
Insert Functions
CONCAT Function
PMT Function
Display Formulas
Date Formulas

Manage Data lock Subscribe to unlock

Quick Analysis
Outline and Subtotal
Data Validation
Flash Fill
Import and Export Data

Tables lock Subscribe to unlock

Insert a Table
Sort Data
Filter Data
Add Rows and Columns
Table Styles
Remove Duplicates
Slicers
Structured References

Intermediate Formatting lock Subscribe to unlock

Apply Conditional Formatting
Apply and Remove Cell Styles
Create and Modify Cell Styles
Find and Replace Formatting
Apply a Theme

Collaboration lock Subscribe to unlock

Cell Comments
Share Workbooks
Co-author Workbooks
Version History
Protect a Worksheet
Protect Workbook Structure
Password Protection

Excel 2019 Advanced

Complete Course to Display Score

PivotTables lock Subscribe to unlock

Create PivotTables
Add Multiple PivotTable Fields
Change a PivotTable's Calculation
Add Calculated Fields
The GETPIVOTDATA Function
Filter PivotTables
Timelines
PivotTable Layout
Group Values
Refresh a PivotTable
Format a PivotTable

PivotCharts lock Subscribe to unlock

Create PivotCharts
PivotChart Options
PivotChart Styles
Drill-Down Data

Troubleshoot Formulas lock Subscribe to unlock

Formula Errors
The Watch Window
Evaluate Formulas

Advanced Formatting lock Subscribe to unlock

Customize Conditional Formatting
Conditional Formatting with Formulas
Manage Conditional Formatting
International Currency and Formats
Body and Heading Options
Color Formats
Custom Themes
Form Controls
Save Form Templates

Advanced Formulas lock Subscribe to unlock

IF Function
Nested Functions
AND, OR, and NOT Functions
SUMIF, AVERAGEIF, and COUNTIF Functions
VLOOKUP
HLOOKUP
INDEX and MATCH
UPPER, LOWER, and PROPER
RIGHT, LEFT, and MID
Formula Calculation Options

Analyze Data lock Subscribe to unlock

Goal Seek
Scenario Manager
Consolidate Data

Macros lock Subscribe to unlock

Enable Macros
Create Macros
Modify Macros
Copy Macros

Trusted by Over 3,000 Organizations

client-image

We love the 12-15 minute learning modules. They allow our learners to begin using the newly acquired skills right away.

client-image

My students LOVE the courses I made with CustomGuide! I am immensely pleased with the product and have saved really hundreds of hours of design time. I’m learning so much myself in putting this all together that I’m much more productive.

client-image

The toughest part [in training] is creating the material, which CustomGuide has done for us. Employees have found the courses easy to follow and, most importantly, they were able to use what they learned immediately.

  • customer-logo
  • customer-logo
  • customer-logo
  • customer-logo
  • customer-logo
  • customer-logo
  • customer-logo
  • customer-logo