Microsoft ® Office Excel 2016: ® Part 1

Description
Microsoft ® Office Excel 2016: ® Part 1

Please download to get full document.

View again

of 244
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information
Category:

Social Media

Publish on:

Views: 22 | Pages: 244

Extension: PDF | Download: 0

Share
Tags
Transcript
  STUDENT MANUAL Microsoft ®  OfficeExcel 2016: ® Part 1 ™  Microsoft ®  OfficeExcel ®  2016: Part1  Microsoft ®  Office Excel ®  2016: Part 1 Part Number: 091055Course Edition: 1.1 Acknowledgements PROJECT TEAM AuthorMedia DesignerContent Editor Jason NufrykBrian SullivanMichelle Farney Logical Operations wishes to thank the Logical Operations Instructor Community, and in particular Mickey Curry, Dawn Hunter,Gary Leenhouts, Carol Marion, and Elizabeth Robinson, for their instructional and technical expertise during the creation of thiscourse. Notices DISCLAIMER While Logical Operations, Inc. takes care to ensure the accuracy and quality of these materials, we cannot guarantee their accuracy, and all materials are provided without any warranty whatsoever, including, but not limited to, the implied warranties of merchantability or fitness for a particular purpose. The name used in the data files for this course is that of a fictitious company. Anyresemblance to current or future companies is purely coincidental. We do not believe we have used anyone's name in creating thiscourse, but if we have, please notify us and we will change the name in the next revision of the course. Logical Operations is anindependent provider of integrated training solutions for individuals, businesses, educational institutions, and government agencies.The use of screenshots, photographs of another entity's products, or another entity's product name or service in this book is for editorial purposes only. No such use should be construed to imply sponsorship or endorsement of the book by nor any affiliation of such entity with Logical Operations. This courseware may contain links to sites on the Internet that are owned and operated by thirdparties (the "External Sites"). Logical Operations is not responsible for the availability of, or the content located on or through, anyExternal Site. Please contact Logical Operations if you have any concerns regarding such links or External Sites. TRADEMARK NOTICES Logical Operations and the Logical Operations logo are trademarks of Logical Operations, Inc. and its affiliates.Microsoft ®  and Excel ®  are registered trademarks of Microsoft Corporation in the U.S. and other countries. The other Microsoftproducts and services discussed or described may be trademarks or registered trademarks of Microsoft Corporation. All other product and service names used may be common law or registered trademarks of their respective proprietors.Copyright ©  2016 Logical Operations, Inc. All rights reserved. Screenshots used for illustrative purposes are the property of thesoftware proprietor. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means,electronic or mechanical, including photocopying, recording, storage in an information retrieval system, or otherwise, withoutexpress written permission of Logical Operations, 3535 Winton Place, Rochester, NY 14623, 1-800-456-4677 in the United Statesand Canada, 1-585-350-7000 in all other countries. Logical Operations’ World Wide Web site is located at www.logicaloperations.com. This book conveys no rights in the software or other products about which it was written; all use or licensing of such software or other products is the responsibility of the user according to terms and conditions of the owner. Do not make illegal copies of booksor software. If you believe that this book, related materials, or any other Logical Operations materials are being reproduced or transmitted without permission, please call 1-800-456-4677 in the United States and Canada, 1-585-350-7000 in all other countries.  Microsoft® Office Excel®2016: Part 1 Lesson 1: Getting Started with Microsoft Office Excel2016........................................................................1 Topic A: Navigate the Excel User Interface......................................2Topic B: Use Excel Commands......................................................16Topic C: Create and Save a Basic Workbook..................................23Topic D: Enter Cell Data...............................................................31Topic E: Use Excel Help................................................................41 Lesson 2: Performing Calculations................................45 Topic A: Create Worksheet Formulas............................................46Topic B: Insert Functions..............................................................55Topic C: Reuse Formulas and Functions........................................67 Lesson 3: Modifying a Worksheet..................................79 Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows.......80Topic B: Search for and Replace Data............................................86Topic C: Use Proofing and Research Tools....................................94 Lesson 4: Formatting a Worksheet..............................101 Topic A: Apply Text Formats......................................................102  Topic B: Apply Number Formats...........................................................113Topic C: Align Cell Contents.................................................................118Topic D: Apply Styles and Themes........................................................123Topic E: Apply Basic Conditional Formatting.........................................132Topic F: Create and Use Templates.......................................................139 Lesson 5: Printing Workbooks.............................................143 Topic A: Preview and Print a Workbook.................................................144Topic B: Set Up the Page Layout............................................................151Topic C: Configure Headers and Footers...............................................159 Lesson 6: Managing Workbooks..........................................167 Topic A: Manage Worksheets................................................................168Topic B: Manage Workbook and Worksheet Views.................................174Topic C: Manage Workbook Properties.................................................182 Appendix A: Microsoft Office Excel 2016 Exam 77-727......................193Appendix B: Microsoft Office Excel 2016 Expert Exam 77–728............197Appendix C: Microsoft Excel 2016 Common Keyboard Shortcuts........201Appendix D: Adding Borders and Colors to Worksheets......................203 Topic A: Add Borders and Colors to Worksheets...................................204 Appendix E: Basic Excel Customization...............................................209 Topic A: Customize General Options and the Excel UI...........................210 Mastery Builders.................................................................................217Glossary.............................................................................................227Index..................................................................................................231 | Microsoft  ®   Office Excel  ®   2016: Part 1 | 
Related Search
Similar documents
View more...
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks