Microsoft Excel Step by Step (Office 2021 and Microsoft 365), 1st edition

Introduction

Part 1: Create and format workbooks

1          Set up a workbook

2          Work with data and Excel tables

3          Perform calculations on data

4          Change workbook appearance

Part 2: Analyze and present data

5          Manage worksheet data

6          Reorder and summarize data

7          Combine data from multiple sources

8          Analyze alternative data sets

9          Create charts and graphics. 207

10        Create PivotTables and PivotCharts

Part 3: Collaborate and share in Excel

11        Print worksheets and charts

12        Automate tasks and input

13        Work with other Microsoft 365 apps

14        Collaborate with colleagues

Part 4: Perform advanced analysis

15        Perform business intelligence analysis

16        Create forecasts and visualizations