Excel_2019_Level_1.pdf

(5153 KB) Pobierz
Excel 2019
Level 1
The Computer Workshop, Inc.
800-639-3535
www.tcworkshop.com
training@tcworkshop.com
Lesson Notes
Microsoft Excel 2019 Level 1
Rel 1, 4/26/2019
Course Number: 0200-100-19-W
Course Release Number: 1
Software Release Number: 2019
April 26, 2019
Developed by:
Brian Ireson, Marissa Kain, Thelma C. Tippie
Edited by:
Suzanne Hixon, Thelma Tippie, and Jeffrey DeRamus
Published by:
The Computer Workshop, Inc.
5200 Upper Metro Place, Suite 140
Dublin, Ohio 43017
(614) 798-9505
dba
RoundTown Publishing
5200 Upper Metro Place, Suite 140
Dublin, Ohio 43017
Copyright © 2019 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], [Word for Windows],
and
[Works]
are registered trademarks of Microsoft Corporation.
[InDesign]
is a registered trademark of Adobe Systems
Incorporated. All other product names and services identified throughout this book are trademarks or registered
trademarks of their respective companies. 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.
Contents
Contents.........................................................................................ii
Using this Manual
.......................................................................vi
To Download Data Files
.......................................................vi
Conventions ................................................................................vii
Conventions Used in this Manual .....................................vii
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
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
Deselecting Cells
.................................................................. 28
Page ii
Excel 2019 Level 1, Rel 1, 4/26/2019
Saving A Workbook
................................................................... 31
File Names and Extensions
................................................. 31
File Formats
........................................................................... 31
Saving a New Workbook/Renaming an Existing
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
Excel 2019 Level 1, Rel 1, 4/26/2019
Page iii

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin