Cindy Lewis - Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

Step by Step

(Office 2021 and Microsoft 365)

Joan Lambert

Curtis Frye

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

Published with the authorization of Microsoft Corporation by:

Pearson Education, Inc.

Copyright 2022 by Pearson Education, Inc.

All rights reserved. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions, request forms, and the appropriate contacts within the Pearson Education Global Rights & Permissions Department, please visit www.pearson.com/permissions.

No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.

ISBN-13: 978-0-13-756427-9

ISBN-10: 0-13-756427-9

Library of Congress Control Number: 2021949813

ScoutAutomatedPrintCode

Trademarks

Microsoft and the trademarks listed at http://www.microsoft.com on the Trademarks webpage are trademarks of the Microsoft group of companies. All other marks are property of their respective owners.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an as is basis. The author, the publisher, and Microsoft Corporation shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book or from the use of the programs accompanying it.

Special Sales

For information about buying this title in bulk quantities, or for special sales opportunities (which may include electronic versions; custom cover designs; and content particular to your business, training goals, marketing focus, or branding interests), please contact our corporate sales department at or (800) 382-3419.

For government sales inquiries, please contact .

For questions about sales outside the U.S., please contact .

Editor-in-Chief

Brett Bartow

Executive Editor

Loretta Yates

Sponsoring Editor

Charvi Arora

Development Editor

Kate Shoup

Managing Editor

Sandra Schroeder

Senior Project Editor

Tracey Croom

Project Editor/Copy Editor

Dan Foster

Technical Editor

Laura Acklen

Indexer

Valerie Haynes Perry

Proofreader

Susan Festa

Editorial Assistant

Cindy Teeters

Cover Designer

Twist Creative, Seattle

Compositor

Danielle Foster

Pearsons Commitment to Diversity, Equity, and Inclusion

Pearson is dedicated to creating bias-free content that reflects the diversity of all learners. We embrace the many dimensions of diversity, including but not limited to race, ethnicity, gender, socioeconomic status, ability, age, sexual orientation, and religious or political beliefs.

Education is a powerful force for equity and change in our world. It has the potential to deliver opportunities that improve lives and enable economic mobility. As we work with authors to create content for every product and service, we acknowledge our responsibility to demonstrate inclusivity and incorporate diverse scholarship so that everyone can achieve their potential through learning. As the worlds leading learning company, we have a duty to help drive change and live up to our purpose to help more people create a better life for themselves and to create a better world.

Our ambition is to purposefully contribute to a world where:

• Everyone has an equitable and lifelong opportunity to succeed through learning.

• Our educational products and services are inclusive and represent the rich diversity of learners.

• Our educational content accurately reflects the histories and experiences of the learners we serve.

• Our educational content prompts deeper discussions with learners and motivates them to expand their own learning (and worldview).

While we work hard to present unbiased content, we want to hear from you about any concerns or needs with this Pearson product so that we can investigate and address them.

Please contact us with concerns about any potential bias at https://www.pearson.com/report-bias.html.

Contents

Acknowledgments

Every book represents the combined efforts of many individuals. Curt Frye wrote the original versions of this book and provided a solid starting point for this edition. Im thankful to Loretta Yates for the opportunity to provide readers with information about Excel 2021 and Excel for Microsoft 365, and to Charvi Arora for keeping things on track. Kate Shoup and Laura Acklen provided valuable developmental and technical feedback. It was a pleasure to work once again with Dan Foster, who did so much more than simply copyedit this book and contributed greatly to the quality of the content. Thanks also to Danielle Foster for laying out the content, Scout Festa for proofreading it, and Valerie Haynes Perry for indexing it.

As always, many thanks and all my love to my divine daughter, Trinity Preppernau.

About the author

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 familyone daughter, two dogs, two cats, and seven chickensin the Beehive State, where she enjoys the majestic mountain views every dayfrom her office chair.

Introduction

Welcome! This Step by Step book has been designed so you can read it from the beginning to learn about Excel for Microsoft 365 (or Microsoft Excel 2021) and then build your skills as you learn to perform increasingly specialized procedures. Or, if you prefer, you can jump in wherever you need guidance for performing tasks. The how-to steps are delivered crisply and conciselyjust the facts. Youll also find informative graphics that support the instructional content.