Excel Essential Training (Office 365/Microsoft 365)

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.

Introduction

• Getting started with Excel for Office 365

1. Getting Started with Excel

• 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

2. Entering Data

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

3. Formulas and Functions

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

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: Insert, delete, hide, and unhide
• Moving, copying, and inserting data
• Finding and replacing data

6. Printing

• Page Layout view and commands
• Using Page Break Preview and print setup options

7. Charts

• Creating charts
• Exploring chart types
• Working with Excel Ideas

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
• New data types coming to Excel for 365

11. Sharing Workbooks

• Protecting worksheets and workbooks
• Sharing workbooks
• Tracking changes

Conclusion

• Next steps