Paul McFedries - Teach Yourself VISUALLY Excel 365

Teach Yourself VISUALLY Excel 365 Copyright 2023 by John Wiley & Sons, Inc. All rights reserved. Published by John Wiley & Sons, Inc., Hoboken, New Jersey. Published simultaneously in Canada and the United Kingdom. ISBN: 978-1-119-93362-5 ISBN: 978-1-119-93363-2 (ebk.) ISBN: 978-1-119-93364-9 (ebk.) No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate percopy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 750-4470, or on the web at www.copyright.com . Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at www.wiley.com/go/permission .

Trademarks: Wiley, the Wiley logo, Visual, the Visual logo, Teach Yourself VISUALLY, Read Less - Learn More and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates. Excel 365 is a trademark of Microsoft Corporation. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book.

Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Further, readers should be aware that websites listed in this work may have changed or disappeared between when this work was written and when it is read. Neither the publisher nor authors shall be liable for any loss of profit or any other commercial damages, including but not limited to special, incidental, consequential, or other damages.

For general information on our other products and services or for technical support, please contact our Customer Care Department within the United States at (800) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002. If you believe youve found a mistake in this book, please bring it to our attention by emailing our reader support team at with the subject line Possible Book Errata Submission. Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic formats. For more information about Wiley products, visit our web site at www.wiley.com . Library of Congress Control Number: 2022939049 Cover images: 200degrees/Getty Images; Screenshot Courtesy of Paul McFedries Cover design: Wiley About the Author Paul McFedries is a full-time technical writer.

He has been authoring computer books since 1991 and has more than 100 books to his credit. Pauls books have sold more than 4 million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Microsoft 365, Teach Yourself VISUALLY Microsoft Windows 11, Microsoft Excel All-in-One For Dummies, and Microsoft Excel Data Analysis For Dummies, Fifth Edition. Paul invites you to drop by his personal website at www.paulmcfedries.com or follow him on Twitter @paulmcf or on Facebook at www.facebook.com/PaulMcFedries . Authors Acknowledgments It goes without saying that writers focus on text, and I certainly enjoyed focusing on the text that you will read in this book. However, this book is more than just the usual collection of words and phrases designed to educate and stimulate the mind.

A quick thumb through the pages will show you that this book is also chock-full of treats for the eye, including copious screenshots, beautiful colors, and sharp fonts. Those sure make for a beautiful book, and that beauty comes from a lot of hard work by the production team at Straive. Of course, what you read in this book must also be accurate, logically presented, and free of errors. Ensuring all of this was an excellent group of editors that I got to work with directly, including project manager Lynn Northrup, technical editor Joyce Nielsen, content refinement specialist Archana Pragash, copyeditor Elizabeth Welch, and managing editor Christine OConnor. Thanks to all of you for your exceptional competence and hard work. Thanks, as well, to associate publisher Jim Minatel for asking me to write this book.

How to Use This Book Who This Book Is For This book is for the reader who has never used this particular technology or software application. It is also for readers who want to expand their knowledge. The Conventions in This Book Steps This book uses a step-by-step format to guide you easily through each task. Numbered steps are actions you must do; bulleted steps clarify a point, step, or optional feature; and indented steps give you the result. Notes Notes give additional information special conditions that may occur during an operation, a situation that you want to avoid, or a cross-reference to a related area of the book. Tips Tips offer additional information, including warnings and shortcuts. Bold Bold type shows command names, options, and text or numbers you must type. Italics Italic type introduces and defines a new term.

In this chapter you get some background about Excel, learn how to access the desktop and online versions of the program, and take a tour of the programs features.