Microsoft Excel 2010 : intermediate

Cover Page
......Page 1
Title Page
......Page 2
Half-Title Page
......Page 3
Copyright Page
......Page 5
Brief Contents......Page 7
Contents......Page 8
What’s New In This Edition......Page 12
Assignments......Page 13
SAM Projects......Page 14
Instructor Resources......Page 15
Author Acknowledgements......Page 16
Read This Before You Begin......Page 17
UNIT F: Managing
Workbook Data......Page 19
Viewing and Arranging Works......Page 20
Splitting the worksheet into multiple panes......Page 21
Protecting Worksheets and Workbooks......Page 22
Freezing rows and columns......Page 23
Saving Custom Views of a Worksheet......Page 24
Using Page Break Preview......Page 25
Adding a Worksheet Background......Page 26
Clipping Screens in Excel......Page 27
Preparing a Workbook for Distribution......Page 28
Sharing a workbook......Page 29
Returning to your document......Page 30
Using research tools......Page 31
Saving a Workbook for Distribution......Page 32
Understanding Excel file formats......Page 33
Adding a digital signature to a workbook......Page 34
Creating a workspace......Page 35
Practice......Page 36
UNIT G: Managing Data
Using Tables......Page 43
Planning a Table......Page 44
Creating and Formatting a Table......Page 46
Changing table style options......Page 47
Adding Table Data......Page 48
Selecting table elements......Page 49
Finding and Replacing Table Data......Page 50
Using Find and Select features......Page 51
Deleting Table Data......Page 52
Sorting a table using conditional formatting......Page 54
Specifying a custom sort order......Page 55
Using Formulas in a Table......Page 56
Using structured references......Page 57
Printing a Table......Page 58
Setting a print area......Page 59
Practice......Page 60
UNIT H: Analyzing Table Data......Page 67
Filtering a Table......Page 68
Creating a Custom Filter......Page 70
Using more than one rule when conditionally formatting data......Page 71
Filtering a Table with the Advanced Filter......Page 72
Using advanced conditional formatting options......Page 73
Extracting Table Data......Page 74
Understanding the criteria range and the copy-to location......Page 75
Finding records using the DGET function......Page 76
Using the HLOOKUP and MATCH functions......Page 77
Summarizing Table Data......Page 78
Restricting cell values and data length......Page 80
Adding input messages and error alerts......Page 81
Creating Subtotals......Page 82
Practice......Page 84
UNIT I: Automating
Worksheet Tasks......Page 91
Planning a Macro......Page 92
Enabling a Macro......Page 94
Disabling macros......Page 95
Recording a Macro......Page 96
Running a Macro......Page 98
Running a macro automatically......Page 99
Editing a Macro......Page 100
Adding comments to Visual Basic code......Page 101
Assigning Keyboard Shortcuts to Macros......Page 102
Using relative referencing when creating a macro......Page 103
Using the Personal Macro Work book......Page 104
Working with the Personal Macro Workbook......Page 105
Assigning a Macro to a Button......Page 106
Formatting a macro button......Page 107
Practice......Page 108
UNIT J: Enhancing Charts......Page 115
Customizing a Data Series......Page 116
Adding width and depth to data series......Page 117
Changing a Data Source and Adding Data Labels......Page 118
Moving, removing, and formatting legends......Page 119
Formatting the Axes ofa Chart......Page 120
Adding a Data Table toa Chart......Page 122
Using the Modeless Format dialog box......Page 123
Making 3-D charts easier to read......Page 124
Charting data accurately......Page 125
Adding WordArt to a worksheet......Page 126
Rotating chart labels......Page 127
Creating a chart template......Page 128
Identifying Data Trends......Page 130
Choosing the right trendline for your chart......Page 131
Practice......Page 132
UNIT K: Using What-if
Analysis......Page 139
Defining a What-if Analysis......Page 140
Tracking a What-if Analysis with Scenario Manager......Page 142
Merging scenarios......Page 143
Generating a Scenario Summary......Page 144
Projecting Figures Using a Data Table......Page 146
Creating a two-input data table......Page 147
Using Goal Seek......Page 148
Setting up a Complex What-if Analysis with Solver......Page 150
Running Solver and Summarizing Results......Page 152
Understanding Answer Reports......Page 153
Choosing the right tool for your data analysis......Page 154
Practice......Page 156
I......Page 163
T......Page 164
W......Page 165
D......Page 166
K......Page 167
R......Page 168
W......Page 169
Y......Page 170