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

—————
Subnoscripts
Full pack

More training courses

@freeTrainingCourse

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