Excel 2019 Essential Training

Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel 2019 features.

Introduction

• Getting started with Excel

1. Getting Started with Excel

• What is Excel used for?
• Using the Quick Access Toolbar and Ribbon menu
• Using shortcut menus and the mini toolbar
• Understanding workbooks and worksheets
• Using Excel Help

2. Entering Data

• Exploring data entry, editing, and AutoFill
• Working with dates and times
• Using Undo and Redo
• Using Save or Save As

3. Creating Formulas and Functions

• Using simple formulas
• Copying a formula into adjacent cells
• Using SUM and AVERAGE

4. Formatting

• Exploring font styles and effects
• Applying borders and color backgrounds
• Adjusting row heights and column widths

5. Adjusting Worksheet Layout and Data

• Rows and Columns
• Moving, copying, and inserting data
• Finding and replacing data

6. Printing

• Using the Page Layout view and commands
• Using Page Break Preview and Print Setup Options

7. Charts

• Creating charts
• Exploring chart types

8. Adjusting Worksheet Views

• Freezing and unfreezing panes
• Splitting screens horizontally and vertically

9. Multiple Worksheets and Workbooks

• Renaming, inserting, and deleting sheets
• Moving, copying, and grouping sheets

10. Data Management Features

• Sorting data
• Using filters
• Creating PivotTables

11. Security and Sharing

• Protecting worksheets and workbooks
• Sharing workbooks
• Tracking changes

Conclusion

• Next steps