Get up to speed with Microsoft Excel. Learn how to enter and organize data, build charts and PivotTables, sort data, and use other Excel features.
Overview
Syllabus
Introduction
- Getting started with Excel for Microsoft 365
- The future of Excel
- What is Excel used for?
- The Ribbon menu and the Quick Access Toolbar
- Shortcut menus and the Mini toolbar
- Understanding workbooks and worksheets
- Use Excel Help
- Accessibility features in Excel
- Exploring data entry, editing, and AutoFill
- Working with dates and times
- Using Undo and Redo
- Use Save or Save As
- Using simple formulas
- Copying a formula into adjacent cells
- Using SUM and AVERAGE
- XLOOKUP and lookup functions
- Exploring font styles and borders
- Color backgrounds
- Adjusting row heights and column widths
- Applying numeric formats
- Rows and columns: Insert, delete, hide, and unhide
- Moving, copying, and inserting data
- Finding and replacing data
- 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
- Opening, closing, and saving workbooks
- Sorting data
- Using filters
- Creating PivotTables
- Protecting worksheets and workbooks
- Sharing workbooks and tracking changes
- Continuing your Excel journey
Taught by
Curt Frye