Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

Texte du rabat

With Microsoft Excel 365 Step by Step students will master the skills they need:

• Quickly set up workbooks, enter data, and format it for easier viewing
• Perform calculations and find and correct errors
• Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines
• Visualize data with 3D maps, funnel charts, and other powerful tools
• Import, process, summarize, and analyze huge datasets with Excel's improved PowerPivot and Power Query
• Build powerful data models and use them in business intelligence
• Look up just the tasks and lessons needed

Contenu

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