This full color book uses the Visual approach to cover the new features of Excel X and provide step-by-step instructions for readers who are entirely new to the subject. Inside readers will find tasks on topics such as; Excel X basics, workbook fundamentals, formatting worksheets and enhancing them with graphics, analyzing data and communicating results with charts and PivotTables. A more sophisticated interior appeals to a wide ranging audience who will appreciate the colorful images and easy to follow instructions. Excel X Simplified provides a friendly and comfortable option for visual learners new to Excel looking to get up and running with this robust spreadsheet application.
Chapter 1 Working with ExcelGetting to Know Excel 4
Start Excel 6
Tour the Excel Window 8
Work with the Excel Ribbon 9
Work with the Excel Galleries 10
Customize the Quick Access Toolbar 12
Customize the Ribbon 14
Change the View 16
Configure Excel Options 18
Add Excel to the Windows Taskbar 20
Quit Excel 21
Chapter 2 Entering Data
Learning the Layout of a Worksheet 24
Understanding the Types of Data You Can Use 25
Enter Text into a Cell 26
Enter a Number into a Cell 28
Enter a Date or Time into a Cell 30
Insert a Symbol 32
Edit Cell Data 34
Delete Data from a Cell 36
Chapter 3 Working with Ranges
Select a Range 40
Fill a Range with the Same Data 42
Fill a Range with a Series of Values 44
Flash Fill a Range 46
Move or Copy a Range 48
Insert a Row or Column 50
Insert a Cell or Range 52
Delete Data from a Range 54
Delete a Range 56
Hide a Row or Column 58
Freeze Rows or Columns 60
Merge Two or More Cells 62
Transpose Rows and Columns 64
Chapter 4 Working with Range Names
Understanding the Benefits of Using Range Names 68
Define a Range Name 70
Use Worksheet Text to Define a Range Name 72
Navigate a Workbook Using Range Names 74
Change a Range Name 76
Delete a Range Name 78
Chapter 5 Formatting Excel Ranges
Change the Font and Font Size 82
Apply Font Effects 84
Change the Font Color 86
Align Text Within a Cell 88
Center Text Across Multiple Columns 90
Rotate Text Within a Cell 92
Add a Background Color to a Range 94
Apply a Number Format 96
Change the Number of Decimal Places Displayed 98
Apply an AutoFormat to a Range 100
Apply a Conditional Format to a Range 102
Apply a Style to a Range 104
Change the Column Width 106
Change the Row Height 108
Wrap Text Within a Cell 110
Add Borders to a Range 112
Chapter 6 Building Formulas
Understanding Excel Formulas 116
Build a Formula 118
Understanding Excel Functions 120
Add a Function to a Formula 122
Add a Row or Column of Numbers 124
Build an AutoSum Formula 126
Add a Range Name to a Formula 128
Reference Another Worksheet Range in a Formula 130
Move or Copy a Formula 132
Chapter 7 Manipulating Worksheets
Navigate a Worksheet 136
Rename a Worksheet 137
Create a New Worksheet 138
Move a Worksheet 140
Copy a Worksheet 142
Delete a Worksheet 144
Change the Gridline Color 146
Toggle Worksheet Gridlines On and Off 148
Toggle Worksheet Headings On and Off 149
Chapter 8 Dealing with Workbooks
Create a New Blank Workbook 152
Create a New Workbook from a Template 154
Save a Workbook 156
Open a Workbook 157
Arrange Workbook Windows 158
Find Text in a Workbook 160
Replace Text in a Workbook 162
Chapter 9 Formatting Workbooks
Modify the Workbook Colors 166
Set the Workbook Fonts 168
Choose Workbook Effects 170
Apply a Workbook Theme 172
Add a Workbook Header 174
Add a Workbook Footer 176
Chapter 10 Working with Tables
Understanding Tables 180
Get to Know Table Features 181
Convert a Range to a Table 182
Select Table Data 184
Insert a Table Row 186
Insert a Table Column 187
Delete a Table Row 188
Delete a Table Column 189
Add a Column Subtotal 190
Convert a Table to a Range 192
Apply a Table Style 193
Build a Custom Table Style 194
Chapter 11 Analyzing Data
Sort a Range or Table 198
Filter a Range or Table 200
Set Data Validation Rules 202
Create a Data Table 204
Summarize Data with Subtotals 206
Group Related Data 208
Analyze Data with Goal Seek 210
Analyze Data with Scenarios 212
Remove Duplicate Values from a Range or Table 216
Chapter 12 Visualizing Data with Charts
Examine Chart Elements 220
Understanding Chart Types 221
Create a Chart 222
Create a Recommended Chart 224
Add Chart Titles 226
Add Data Labels 227
Position the Chart Legend 228
Display Chart Gridlines 229
Display a Data Table 230
Change the Chart Layout and Style 231
Select a Different Chart Type 232
Change the Chart Source Data 234
Move or Resize a Chart 236
Chapter 13 Collaborating with Others
Add a Comment to a Cell 240
Protect a Worksheet’s Data 242
Protect a Workbook’s Structure 244
Share a Workbook with Other Users 246
Track Workbook Changes 248
Accept or Reject Workbook Changes 250
Save a Workbook to Your SkyDrive 252
Send a Workbook as an E-Mail Attachment 254
Save Excel Data as a Web Page 256
Make a Workbook Compatible with Earlier Versions of Excel 258
Mark Up a Worksheet with a Digital Pen 260
Collaborate on a Workbook Online 262