Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel 2019 features.
Overview
Syllabus
Introduction
- 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
- Exploring data entry, editing, and AutoFill
- Working with dates and times
- Using Undo and Redo
- Using Save or Save As
- Using simple formulas
- Copying a formula into adjacent cells
- Using SUM and AVERAGE
- Exploring font styles and effects
- Applying borders and color backgrounds
- Adjusting row heights and column widths
- Rows and Columns
- Moving, copying, and inserting data
- Finding and replacing data
- Using the Page Layout view and commands
- Using Page Break Preview and Print Setup Options
- Creating charts
- Exploring chart types
- Freezing and unfreezing panes
- Splitting screens horizontally and vertically
- Renaming, inserting, and deleting sheets
- Moving, copying, and grouping sheets
- Sorting data
- Using filters
- Creating PivotTables
- Protecting worksheets and workbooks
- Sharing workbooks
- Tracking changes
- Next steps
Taught by
Dennis Taylor