Microsoft Excel 2013: Illustrated Brief

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