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 Office 365
- What is Excel used for?
- Using the Quick Access Toolbar and ribbon menu
- 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
- XLOOKUP and lookup functions
- Exploring font styles and effects
- Applying borders and color backgrounds
- Adjusting row heights and column widths
- 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
- Working with Excel Ideas
- 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
- New data types coming to Excel for 365
- Protecting worksheets and workbooks
- Sharing workbooks
- Tracking changes
- Next steps
Taught by
Dennis Taylor