I'm a student
I'm an educator
Request full copy

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

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

  • Joan Lambert
  • Curtis Frye

eTextbook

$37.99

  • Available for purchase from all major ebook resellers, including InformIT.com.
  • To request a review copy, click on the "Request a Review Copy" button.
$36.79

  • A print text (hardcover or paperback) 
  • 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
  • Easy lessons for essential tasks
  • Filled with helpful screen shots
  • Skill-building practice files
The software Excel 365 will be covered extensively, with some reference to the other programs in the base Office 365 family of programs. The author intends to use the current interpretation of the Step by Step series approach that he has used since Microsoft Excel 2002 Step by Step.

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

Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people seeking certification of their computer skills or who simply want to get things done efficiently. She has written more than 50 books about Windows, Office, and SharePoint technologies, including dozens of Step by Step books and five generations of Microsoft Office Specialist certification study guides. Students who use the GO! with Microsoft Office textbook products may overhear her cheerfully demonstrating Office features in the videos that accompany the series.


A native of the Pacific Northwest, Joan has had the good fortune to live in many parts of the world. She currently resides with her family—one daughter, two dogs, two cats, and seven chickens—in the Beehive State, where she enjoys the majestic mountain views every day…from her office chair.

Need help? Get in touch

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 16KB) 

Pearson eTextbook: What’s on the inside just might surprise you

They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle. 

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars