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

Published by Microsoft Press (December 7, 2021) © 2022

  • Joan Lambert
  • Curtis Frye
Products list
$37.99
Buy nowOpens in a new tab
Sold by InformIT and ebook resellers
  • Available for purchase from all major ebook resellers, including InformIT.com
Products list
$36.79

Price Reduced From: $45.99

Details

  • A print text
  • Free shipping
  • Also available for purchase as an ebook from all major ebook resellers, including InformIT.com

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

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

Need help? Get in touch