Rights Contact Login For More Details
More About This Title Excel 2010 Simplified
English
Excel can be a complex program, and Excel 2010 includes new features and functionalities that require users of older versions to re-learn the application. Whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide provides information you can use right away.
With an easy-to-read design, numbered steps illustrated with full-color screen shots, concise information, and helpful tips, Excel 2010 Simplified makes learning faster and easier than ever before.
Excel is the world's leading spreadsheet and data analysis tool; Excel 2010 includes numerous new features, a redesigned interface, a new focus on collaboration and application servers, and much moreIts complexity makes Excel a perfect subject for the step-by-step visual instruction in this guideNumbered steps illustrated with full-color screen shots teach dozens of Excel 2010 tasksCovers Excel basics, workbook fundamentals, formatting worksheets and enhancing them with graphics, analyzing data, communicating results with charts and PivotTables, and much moreA quick and easy way to get up to speed on Excel 2010 for both novice users and those upgrading from an earlier versionExcel 2010 Simplified tames this complicated application and gives you the skills to start using Excel with confidence.
English
English
1 Working with Excel
Getting to Know Excel 4
Start Excel 6
Tour the Excel Window 8
Work with Excel’s Ribbon 9
Work with Excel’s Galleries 10
Customize the Quick Access Toolbar 12
Customize the Ribbon 14
Work with Smart Tags 16
Change the View 18
Configure Excel Options 20
2 Entering and Editing Excel 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
3 Working with Excel Ranges
Select a Range 40
Fill a Range with the Same Data 42
Fill a Range with a Series of Values 44
Move or Copy a Range 46
Insert a Row or Column 48
Insert a Cell or Range 50
Delete Data from a Range 52
Delete a Range 54
Hide a Row or Column 56
Freeze Rows or Columns 58
Merge Two or More Cells 60
Transpose Rows and Columns 62
4 Working with Range Names
Define a Range Name 66
Use Worksheet Text to Define a Range Name 68
Navigate a Workbook Using Range Names 70
Change a Range Name 72
Delete a Range Name 74
5 Formatting Excel Ranges
Change the Font and Font Size 78
Apply Font Effects 80
Change the Font Color 82
Align Text Within a Cell 84
Center Text Across Multiple Columns 86
Rotate Text Within a Cell 88
Add a Background Color to a Range 90
Apply a Number Format 92
Change the Number of Decimal Places Displayed 94
Apply an AutoFormat to a Range 96
Apply a Conditional Format to a Range 98
Apply a Style to a Range .100
Change the Column Width 102
Change the Row Height 104
Wrap Text Within a Cell 106
Add Borders to a Range 108
6 Building Formulas and Functions
Understanding Excel Formulas 112
Build a Formula 114
Understanding Excel Functions 116
Add a Function to a Formula 118
Add a Row or Column of Numbers 120
Build an AutoSum Formula 122
Add a Range Name to a Formula 124
Reference Another Worksheet Range in a Formula 126
Move or Copy a Formula 128
7 Manipulating Excel Worksheets
Navigate a Worksheet 132
Rename a Worksheet 133
Create a New Worksheet 134
Move a Worksheet 136
Copy a Worksheet 138
Delete a Worksheet 140
Change the Gridline Color 142
Toggle Worksheet Gridlines On and Off 144
Toggle Worksheet Headings On and Off 145
8 Dealing with Excel Workbooks
Create a New Blank Workbook 148
Create a New Workbook from a Template 150
Save a Workbook 152
Open a Workbook 153
Arrange Workbook Windows 154
Find Text in a Workbook 156
Replace Text in a Workbook 158
9 Formatting Excel Workbooks
Modify the Workbook Colors 162
Set the Workbook Fonts 164
Choose Workbook Effects 166
Apply a Workbook Theme 168
10 Analyzing Excel Data
Sort a Range 172
Filter a Range 174
Set Data Validation Rules 176
Convert a Range to a Table 178
Create a Data Table 180
Summarize Data with Subtotals 182
11 Visualizing Data with Excel Charts
Examining Chart Elements 186
Understanding Chart Types 187
Create a Chart 188
Add Chart Titles 190
Add Data Labels 191
Position the Chart Legend 192
Display Chart Gridlines 193
Display a Data Table 194
Change the Chart Layout and Style 195
Select a Different Chart Type 196
12 Formatting Excel Charts
Format Chart Elements 200
Customize a Chart Element Background 202
Set a Chart Element’s Outline 204
Add Effects to a Chart Element 206
Apply a Style to a Chart Element 208
13 Collaborating with Other People
Add a Comment to a Cell 212
Protect a Worksheet’s Data 214
Protect a Workbook’s Structure and Windows 216
Share a Workbook with Other Users 218
Track Workbook Changes 220
Accept or Reject Workbook Changes 222
Send a Workbook as an E-Mail Attachment 224
Save Excel Data as a Web Page 226
Make a Workbook Compatible with Earlier Versions of Excel 228
Collaborate on a Workbook Online 230
