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