TRAINING COURSE CATALOG

Mastering Excel 2019: Managing Worksheets, Part 1

Manage your worksheets including adding, removing, and renaming. This content is also translated in Spanish.

English (US)

5 Minutes

Mastering Excel 2019: Managing Worksheets, Part 2

Reorder, copy, and color-code your worksheets. This content is also translated in Spanish.

English (US)

8 Minutes

Mastering Excel 2019: Navigating the Interface

Navigate the interface and move around using both the mouse and the keyboard. This content is also translated in Spanish.

English (US)

9 Minutes

Mastering Excel 2019: Printing Workbooks

Access Print Preview and modify basic Print Settings. This content is also translated in Spanish.

English (US)

4 Minutes

Mastering Excel 2019: Searching and Replacing

Quickly find, replace, and select specific data or cells in your worksheets. This content is also translated in Spanish.

English (US)

8 Minutes

Mastering Excel 2019: Selecting Data

Quickly move around and select cells in Excel using your keyboard. This content is also translated in Spanish.

English (US)

9 Minutes

Mastering Excel 2019: Setting the Page Layout

Modify Page Layout settings for printing to do things like set only a particular area to print (Set Print Area) or repeat certain rows and columns on every page (Set Print Titles). This content is also translated in Spanish.

English (US)

7 Minutes

Mastering Excel 2019: Using Absolute References

Address common formula issues by adding absolute references and fixing common errors. This content is also translated in Spanish.

English (US)

10 Minutes

Mastering Excel 2019: Customizing Number Formats

Apply more advanced number formats like for phone numbers or social security numbers, including creating your own custom number format. This content is also translated in Spanish.

English (US)

8 Minutes

Mastering Excel 2019: Customizing the Quick Access Toolbar

Customize the Quick Access Toolbar with your favorite and most used commands. This content is also translated in Spanish.

English (US)

6 Minutes

Mastering Excel 2019: Customizing the Ribbon

Quickly access the commands you need by creating Custom Groups and adding your own Tabs. This content is also translated in Spanish.

English (US)

7 Minutes

Mastering Excel 2019: Entering Cell Data

Enter data into your spreadsheet and use Copy, Paste, Undo, Redo, and Clear. This content is also translated in Spanish.

English (US)

6 Minutes

Mastering Excel 2019: Inserting and Deleting Cells

Insert and remove rows and columns and adjust heights and widths. This content is also translated in Spanish.

English (US)

9 Minutes

Mastering Excel 2019: Inserting Functions

Insert basic functions into your formulas using multiple methods. This content is also translated in Spanish.

English (US)

8 Minutes

Mastering Excel 2019: Inserting Hyperlinks

Insert hyperlinks into your worksheets that link to other files or to websites. This content is also translated in Spanish.

English (US)

6 Minutes

Mastering Excel 2019: Inserting Page Breaks

Control how your pages print using Page Breaks and Scaling. This content is also translated in Spanish.

English (US)

9 Minutes

Mastering Excel 2019: Introduction

Understand the scope of the course. This content is also translated in Spanish.

English (US)

2 Minutes

Mastering Excel 2019: Managing Workbook Properties

Track important information about a workbook by viewing and adding Workbook Properties. This content is also translated in Spanish.

English (US)

4 Minutes

Mastering Excel 2019: Applying Number Formats

Apply number formatting and describe how Excel applies formatting to cells, not data. This content is also translated in Spanish.

English (US)

7 Minutes

Mastering Excel 2019: Applying Text Formats

Format your text including different fonts, font styles, and colors, and format cell borders. This content is also translated in Spanish.

English (US)

9 Minutes

Mastering Excel 2019: Applying Themes

Create consistent formatting across workbooks using Themes. This content is also translated in Spanish.

English (US)

4 Minutes

Mastering Excel 2019: Configuring Headers and Footers, Part 1

Add headers and footers to your worksheet including dynamic field codes for things like date or file path. This content is also translated in Spanish.

English (US)

5 Minutes

Mastering Excel 2019: Configuring Headers and Footers, Part 2

Configure Headers and Footers from the Page Setup Dialog Box and set your worksheet to have a different Header and Footer on the first page. This content is also translated in Spanish.

English (US)

4 Minutes

Mastering Excel 2019: Copying Formulas and Functions

Reuse formulas by copying them into different cells. This content is also translated in Spanish.

English (US)

7 Minutes