Excel 2019 Self-Paced Training

We are in the process of updating Excel self-paced training guides. If you would like to participate in reviewing these documents, download the exercise file(s) and then open the training guide link to go through the exercises. We encourage you to keep notes if you find errors or are confused by any steps; send your notes and comments to techwriters@umsystem.edu.

Training Guide	Exercise File(s)
NEW Quick Reference Guide: Sorting, Filtering, and Removing Duplicates QRG	Sort Filter Exercise Workbook
1: Introduction The Excel 2019 Workspace New Document Text and Values Formulas Saving, updating, and exporting Proofing and Finalizing Layout (to optimize printability) Additional printing options	Intro_Exercise_Workbook
2: Formatting Text Formatting - Keyboard Shortcuts - Ribbon - Mini Toolbar Number Formatting - Special Number Formats - Conditional Formatting Additional Formatting Options - AutoFill - Format Painter - Cell Styles	Formatting Exercise Workbook
3: Worksheets Insert/Delete Columns, Rows, Ranges Keys vs Commands Moving/Copying Cell Data Moving/Copying Formulas Absolute and Relative References Organizing Large Worksheets Printing Multiple Worksheets Multiple Workbooks Named Cells and Ranges Info and Protection	Source_Workbook Annual_Totals Exercise_Workbook_Unit1 Exercise_Workbook_Unit2 Exercise_Workbook_Unit3 Exercise_Workbook_Unit4
4: Functions Function Syntax Error Checking Function Arguments Logical Functions Conditional Functions Other Commonly Used Functions	Functions_Exercise_Workbook
5: Charts - 2019 Update in Progress.	Charts_Exercise_Workbook CoMoZooLogo.png Elephant-LadiesRoom.jpg
6: Analytics - 2019 Update in Progress.	Analytics_Exercise_Workbook Enable_and_Run_Macros Macros_Exercise_Workbook
7: Data Management and Importing - 2019 Update in Progress.	AdoptionData Concessions Data_Mgmt_Exercise_Workbook Export_Import
8: Pivot - 2019 Update in Progress.	PivotTables_Exercise_Workbook

If you would like help creating or maintaining documentation for your department, please email techwriters@umsystem.edu.

DoIT Technical Writers
Division of IT
University of Missouri