Excel 2016 Level 1 - The Computer Workshop Inc.

Excel 2016 Level 1

The Computer Workshop, Inc.

800-639-3535

training@

Lesson Notes

Microsoft Excel 2016

Level 1

Course Number: 0200-100-16-W Course Release Number: 2.0

Software Release Number: 2016

10/01/2018

Developed by: Brian Ireson

Suzanne Hixon Thelma Tippie

Edited by: Marissa Kain Catherine Destadio

Published by: RoundTown Publishing 5131 Post Road, Suite 102

Dublin, Ohio 43017

for

The Computer Workshop, Inc. 5131 Post Road, Suite 102 Dublin, Ohio 43017 (614) 798-9505

Copyright ? 2018 by RoundTown Publishing. No reproduction or transmittal of any part of this publication, in any form or by any means, mechanical or electronic, including photocopying, recording, storage in an information retrieval system, or otherwise, is permitted without the prior consent of RoundTown Publishing.

Disclaimer: Round Town Publishing produced this manual with great care to make it of good quality and accurate, and therefore, provides no warranties for this publication whatsoever, including, but not limited to, the implied warranties of merchantability or fitness for specific uses. Changes may be made to this document without notice.

Trademark Notices: The Computer Workshop, Inc. and The Computer Workshop logo are registered trademarks of The Computer Workshop, Inc. [Microsoft], [Windows], [PowerPoint], [Excel], [Word], and [Access] are registered trademarks of Microsoft Corporation. [Photoshop] and [InDesign] are a registered trademark of Adobe. All other product names and services identified throughout this book are trademarks or registered trademarks of their respective companies. All NASA information was obtained from public resources. Using any of these trade names is for editorial purposes only and in no way is intended to convey endorsement or other affiliation with this manual.

Preface

Contents

Page iv

Contents.........................................................................................iv Using this Manual..................................................................... viii Conventions.................................................................................. ix

Lesson 1: Getting Started

About Excel.................................................................................... 3 Starting Excel................................................................................. 4

Using the Shortcut on the Desktop ...................................... 4 Using the Taskbar.................................................................... 4 Using the Start Menu.............................................................. 4 Using the Search...................................................................... 4 Excel Elements............................................................................... 6 Interface Elements................................................................... 6 Worksheet Elements............................................................... 8 The Ribbon..................................................................................... 9 The Ribbon Tabs...................................................................... 9 Using the Ribbon................................................................... 11 Mini Toolbar and Shortcut Menu............................................. 12 Using a Mini Toolbar and Shortcut Menu......................... 12 Quick Access Toolbar (QAT)..................................................... 14 Customizing the Ribbon............................................................ 17 Creating a Custom Tab......................................................... 17 Opening and Viewing Workbooks........................................... 20 Opening an Existing Workbook......................................... 20 Opening a Recent Workbook.............................................. 21 Opening Multiple Workbooks............................................ 21 Opening a Workbook from Earlier Excel Versions ......... 22 Viewing Opened Workbooks.............................................. 22 Protected View ..................................................................... 22 Cursor Movement....................................................................... 25 Using the Keyboard.............................................................. 25 Using the Mouse................................................................... 25 Selecting Cells.............................................................................. 26 Selecting a Single Cell........................................................... 26 Selecting a Cell Range.......................................................... 26 Selecting a Row or Column................................................. 27 Selecting a Range of Rows or Columns............................. 27 Selecting a Range of Adjacent Data.................................... 28 Selecting Noncontiguous Ranges....................................... 28 Selecting an Entire Worksheet............................................ 28 Saving A Workbook.................................................................... 31 File Names and Extensions.................................................. 31 File Formats............................................................................ 31 Saving a New Workbook/Renaming an Existing

Microsoft Excel 2016: Level 1, Rel. 2.0, 10/01/2018

Contents,

continued

Preface

Workbook............................................................................... 32 Saving an Existing Workbook............................................. 32 Workbook Conversion and Compatibility.............................. 34 Compatibility Checker......................................................... 34 Converting a Workbook from an Earlier Version of Excel. 34 Closing a Workbook................................................................... 36

Lesson 2: Creating a Workbook

Creating a Workbook................................................................. 41 Document Properties.................................................................. 42

The Four Types of Document Properties.......................... 42 Accessing the Document Properties................................... 43 Custom Properties......................................................................... 47 Viewing and Creating Custom Properties........................ 47 Searching for Files Using Properties........................................ 51 Entering Information.................................................................. 53 Auto Fill........................................................................................ 54 Custom Lists................................................................................ 57 Flash Fill....................................................................................... 62 Editing Cells................................................................................. 64 Entering Numbers....................................................................... 66

Lesson 3: Introduction to Formulas

Creating a Formula..................................................................... 71 Creating a Function Formula.................................................... 74 AutoSum....................................................................................... 78 Formula Errors............................................................................ 81 Cell Addressing........................................................................... 82 Inspecting Documents................................................................ 85

Inspecting the Document..................................................... 85

Lesson 4: Formatting a Worksheet

Inserting Rows and Columns.................................................... 91 Inserting Cells.............................................................................. 92 Deleting Rows, Columns, & Cells............................................ 95 Undo and Redo........................................................................... 96 Changing Column Width.......................................................... 98 Changing Row Height................................................................ 99 Font Formatting......................................................................... 102 Aligning Text............................................................................. 105 Cell Formatting.......................................................................... 110 Formatting Numbers ............................................................... 114 Moving Cells.............................................................................. 122

Microsoft Excel 2016: Level 1, Rel. 2.0, 10/01/2018

Page v

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download