Microsoft Excel 2013: Illustrated Brief

✍ Scribed by Elizabeth Eisner Reding

• Publisher: Cengage Learning
• Year: 2013
• Tongue: English
• Leaves: 165
• Edition: 1
• Category: Library

✦ Synopsis

Praised by instructors for its concise, focused approach and user-friendly format, the Illustrated Series engages both computer rookies and hot shots in mastering Microsoft Excel 2013 quickly and efficiently. Skills are accessible and easy-to-follow thanks to the Illustrated Series' hallmark 2-page layout, which allows students to see an entire task in one view. New Learning Outcomes outline the skills covered in each lesson, and larger full-color screens represent exactly what students should see on their own computers. Each unit begins with a brief overview of the principles of the lesson, and introduces a case study for further application.

✦ Table of Contents

Cover
......Page 1
Statement
......Page 3
Title Page
......Page 7
Copyright
......Page 8
Brief Contents......Page 9
Contents......Page 10
Preface......Page 14
New! Learning Outcomes......Page 16
Online Learning and Assessment Tools......Page 17
Instructor Resources......Page 18
Important Notes for Windows 7 Users......Page 19
Acknowledgements......Page 20
File You Will Need......Page 21
Understand the Office 2013 Suite......Page 22
Start an Office App......Page 24
Identify Office 2013 Screen Elements......Page 26
Create and Save a File......Page 28
Open a File and Save It with a New Name......Page 30
View and Print Your Work......Page 32
Get Help, Close a File, and Exit an App......Page 34
Practice......Page 36
Files You Will Need......Page 37
Understand Spreadsheet Software......Page 38
Identify Excel 2013 Window Components......Page 40
Understand Formulas......Page 42
Enter Labels and Values and Use the AutoSum Button......Page 44
Edit Cell Entries......Page 46
Enter and Edit a Simple Formula......Page 48
Switch Worksheet Views......Page 50
Choose Print Options......Page 52
Practice......Page 54
Files You Will Need......Page 61
Create a Complex Formula......Page 62
Insert a Function......Page 64
Type a Function......Page 66
Copy and Move Cell Entries......Page 68
Understand Relative and Absolute Cell References......Page 70
Copy Formulas with Relative Cell References......Page 72
Copy Formulas with Absolute Cell References......Page 74
Round a Value with a Function......Page 76
Practice......Page 78
Files You Will Need......Page 87
Format Values......Page 88
Change Font and Font Size......Page 90
Change Font Styles and Alignment......Page 92
Adjust the Column Width......Page 94
Insert and Delete Rows and Columns......Page 96
Apply Colors, Patterns, and Borders......Page 98
Apply Conditional Formatting......Page 100
Rename and Move a Worksheet......Page 102
Check Spelling......Page 104
Practice......Page 106
Files You Will Need......Page 115
Plan a Chart......Page 116
Create a Chart......Page 118
Move and Resize a Chart......Page 120
Change the Chart Design......Page 122
Change the Chart Format......Page 124
Format a Chart......Page 126
Annotate and Draw on a Chart......Page 128
Create a Pie Chart......Page 130
Practice......Page 132
Files You Will Need......Page 141
Understand Office 2013 in the Cloud......Page 142
Work Online......Page 144
Explore SkyDrive......Page 146
Manage Files on SkyDrive......Page 148
Share Files......Page 150
Explore Office Web Apps......Page 152
Team Project......Page 154
Glossary......Page 157
Index......Page 161