Eric Butow - MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide

ISBN: 978‐1‐119‐71849‐9

ISBN: 978‐1‐119‐71851‐2 (ebk.)

ISBN: 978‐1‐119‐71850‐5 (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 Sections 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 per‐copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750‐8400, fax (978) 646‐8600. 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 http://www.wiley.com/go/permissions.

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. Neither the publisher nor author 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 to obtain technical support, please contact our Customer Care Department within the U.S. at (877) 762‐2974, outside the U.S. at (317) 572‐3993 or fax (317) 572‐4002.

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: 2021938302

TRADEMARKS: WILEY and the Wiley logo are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United States and other countries, and may not be used without written permission. Microsoft is a registered 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.

Cover Image: © Getty Images Inc./Jeremy Woodhouse

Cover Design: Wiley

To my family and friends

I have many people to thank, starting with my literary agent, Matt Wagner. He connected me with Sybex to write this book and managed our relationship well. Next, I want to give a shout out to my excellent editing team: Gary Schwartz, Barath Kumar Rajasekaran, Christine O'Connor, and Senior Acquisitions Editor Kenyon Brown.

And, as always, I want to thank my family and friends for their everlasting support. I couldn't write this book without them.

—Eric Butow

Eric Butowis the owner of Butow Communications Group (BCG) in Jackson, California. BCG offers website development, online marketing, and technical writing services. Eric is a native Californian who started working with his friend's Apple II Plus and Radio Shack TRS‐80 Model III in 1980 when he lived in Fresno, California. He learned about programming, graphic design, and desktop publishing in the Fresno PC Users Group in his professional career, and when he started BCG in 1994.

Eric has written 40 other technical books as an author, co‐author or, in one case, as a ghostwriter. Most of Eric's works were written for the general book market, but some were written for specific clients including HP and F5 Networks. Two of his books have been translated into Chinese and Italian. Eric's most recent books are Programming Interviews for Dummies (For Dummies, 2019) with John Sonmez, Ultimate Guide to Social Media Marketing (Entrepreneur Press, 2020) with Herman, Liu, Robinson, and Allton, and Instagram for Business for Dummies Second Edition (For Dummies, 2021) with Jennifer Herman and Corey Walker.

Upon his graduation from California State University, Fresno in 1996 with a master's degree in communication, Eric moved to Roseville, California, where he lived for 13 years. Eric continued to build his business and worked as a technical writer for a wide variety of businesses from startups to large companies including Intel, Wells Fargo Wachovia, TASQ Technology, Cisco Systems, and Hewlett‐Packard. Many of those clients required their technical writers to know Microsoft PowerPoint, which Eric has used since the early 1990s. From 1997–1999, during his off‐time, Eric produced 30 issues of Sacra Blue , the award‐winning monthly magazine of the Sacramento PC Users Group.

When Eric isn't working in (and on) his business or writing books, you can find him enjoying time with friends, walking around the historic Gold Rush town of Jackson, and helping his mother manage her infant and toddler daycare business.

Kristen Merrittis an experienced technical editor who has reviewed books for several publishers, including Wiley and Microsoft Press. Kristen spent 12 years in technical sales, and she is currently employed as a digital marketer.

Welcome to this book about becoming a Microsoft Certified Office Specialist for the Microsoft 365 suite of productivity applications to which you can subscribe. You can also use this book with the one‐time purchase version of Office, which Microsoft calls Office 2019.

Microsoft 365 allows you to use different versions on many platforms, including Windows, macOS, iOS, iPadOS, and Android. You can even use the free online version of Microsoft 365. This book, however, talks about using the most popular version of Microsoft 365 on the most popular operating system, which happens to be the Word, Excel, and PowerPoint applications in Microsoft 365 running on Windows 10.

You may already know about a lot of Word, Excel, and PowerPoint features by working with it, but no matter if you use Word, Excel, and PowerPoint for your regular documentation tasks, or if you're new to the application, you'll learn a lot about the power that Word, Excel, and PowerPoint gives you to create all kinds of documents.

If you want to prepare to take one or all the Microsoft Office Specialist exams, which will help you become a certified specialist in Word, Excel, and/or PowerPoint, and hopefully increase your stature, marketability, and income, then this is the book for you. Even if you're not going to take the exam, but you want to learn how to use Word, Excel, and PowerPoint more effectively, this book will show you how to get the most out of using Word, Excel, and PowerPoint based on features that Microsoft believes are important for you to know.

What you learn in this book hews to the topics in the Microsoft Office Specialist exams, because this book is designed to help you learn about the topics in the exam and pass it on the first try.

After you finish reading the book and complete all the exercises, you'll have an in‐depth understanding of Word, Excel, and PowerPoint that you can use to become more productive at work and at home (or in your home office).