Excel 2019 for Windows: Getting Started
Course: 22 Minutes

Finding & opening the application
Exploring the application
Using the zoom function
Using the view modes
Moving between documents

Excel 2019 for Windows: Creating & Saving Workbooks
Course: 1 Hour, 4 Minutes

Creating & opening a document
Using document templates
Managing your worksheets
Saving your document
Saving your document as a PDF
Recovering unsaved documents
Inserting headers & footers
Setting your print area
Adjusting your print page layout
Printing your document
Checking for compatibility issues
Editing your document properties
Checking for personal information in your document
Creating an accessible document
Protecting your document

Excel 2019 for Windows: Inserting & Manipulating Data
Course: 1 Hour, 3 Minutes

Selecting cells
Inputting data
Inserting special characters
Editing multiple worksheets simultaneously
Deleting items in your spreadsheet
Undoing & redoing actions
Creating automatic data series
Using the Flash Fill feature
Inserting dropdown menus
Using the spell check tool
Configuring spell check & AutoCorrect options
Transferring data
Copying & pasting data
Moving data from one worksheet to another
Using the Paste Special tools
Transposing a data range
Consolidating your data

Excel 2019 for Windows: Formatting Data
Course: 49 Minutes

Setting your data type
Formatting your data
Aligning your data
Using colors
Changing your cell style
Using document themes
Using formulas to modify your text case
Creating a title
Formatting a title
Creating a table
Resizing columns & rows
Inserting columns & rows
Inserting borders
Transferring format styles

Excel 2019 for Windows: Illustrating Documents
Course: 31 Minutes

Inserting an image
Inserting a screenshot
Editing an image
Inserting shapes
Inserting icons
Inserting a hyperlink
Using Smart Lookup

Excel 2019 for Windows: Using Basic Formulas
Course: 52 Minutes

Inserting a formula using the function library
Performing simple calculations
Using automated formulas in a table
Creating automated cumulative totals
Inserting subtotals
Counting cells in a range
Ranking a value
Rounding a number
Using replacement formulas
Converting number types
Factorizing the results of a division
Creating random values

Excel 2019 for Windows: Sharing & Collaborating on a Document
Course: 26 Minutes

Sending your document via email
Sharing your workbook via a link
Managing link access & permissions
Saving your documents to OneDrive
Managing a workbook's version history
Commenting on a document
Following & tracking document changes