Page 9 - Ms Excel Note and Workbook
P. 9
Sorting Data ............................................................................................................................ 148
Filtering Data .......................................................................................................................... 148
Summarizing Data .................................................................................................................. 149
Formatting Data as a Table .................................................................................................... 149
Visualizing Data with Charts ................................................................................................... 150
Adding Conditional Formatting .............................................................................................. 150
Using Find and Replace .......................................................................................................... 151
11 WORKING WITH DATA .................................................................................................................. 152
Types of Sorting ...................................................................................................................... 152
Custom Sorting ....................................................................................................................... 156
Sorting Levels ......................................................................................................................... 160
Filtering Data .......................................................................................................................... 162
12 TABLES ........................................................................................................................................... 176
Format Data as a Table .......................................................................................................... 176
Modifying Tables .................................................................................................................... 178
To change the table style: ...................................................................................................... 179
13 CHARTS .......................................................................................................................................... 184
Chart and Layout Style ........................................................................................................... 186
Other Chart Options ............................................................................................................... 189
14 INSPECTING & PROTECTING WORKBOOKS .................................................................................. 193
Document Inspector............................................................................................................... 193
Protecting Your Workbook ..................................................................................................... 195
15 INTRO TO PIVOTTABLES ................................................................................................................ 197
Using PivotTables to Answer Questions ................................................................................ 197
Create a PivotTable: ............................................................................................................... 198
Pivoting Data .......................................................................................................................... 202
16 DOING MORE WITH PIVOTTABLES ............................................................................................... 206
Filters ...................................................................................................................................... 206
Slicers ..................................................................................................................................... 208
PivotCharts ............................................................................................................................. 210
17 EXERCISE ........................................................................................................................................ 212
18 REFERENCE .................................................................................................................................... 220
