Excel Essential Training (Office 365Microsoft 365)

01 - Introduction
- Getting started with Excel for Office 365

02 - 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

03 - Entering Data
- Exploring data entry, editing, and AutoFill
- Working with dates and times
- Using Undo and Redo
- Using Save or Save As

04 - Formulas and Functions
- Using simple formulas
- Copying a formula into adjacent cells
- Using SUM and AVERAGE
- XLOOKUP and lookup functions

05 - 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

07 - Printing
- Page Layout view and commands
- Using Page Break Preview and print setup options

08 - Charts
- Creating charts
- Exploring chart types
- Working with Excel Ideas

09 - Adjusting Worksheet Views
- Freezing and unfreezing panes
- Splitting screens horizontally and vertically

10 - Multiple Worksheets and Workbooks
- Renaming, inserting, and deleting sheets
- Moving, copying, and grouping sheets

11 - Data Management Features
- Sorting data
- Using filters
- Creating PivotTables
- New data types coming to Excel for 365

12 - Sharing Workbooks
- Protecting worksheets and workbooks
- Sharing workbooks
- Tracking changes

13 - Conclusion
- Next steps

—————
Subtitles
Full pack

More training courses

@freeTrainingCourse