Page 9 - Ms Excel Note and Workbook
P. 9
Sorting Data ............................................................................................................................ 110
Filtering Data .......................................................................................................................... 111
Summarizing Data .................................................................................................................. 111
Formatting Data as a Table .................................................................................................... 112
Visualizing Data with Charts ................................................................................................... 112
Adding Conditional Formatting .............................................................................................. 113
Using Find and Replace .......................................................................................................... 113
11 WORKING WITH DATA......................................................................................................... 114
Types of Sorting ...................................................................................................................... 114
Custom Sorting ....................................................................................................................... 118
Sorting Levels ......................................................................................................................... 121
Filtering Data .......................................................................................................................... 123
12 TABLES ................................................................................................................................ 134
Format Data as a Table .......................................................................................................... 134
Modifying Tables .................................................................................................................... 135
To change the table style: ...................................................................................................... 136
13 CHARTS ............................................................................................................................... 139
Chart and Layout Style ........................................................................................................... 140
Other Chart Options ............................................................................................................... 143
14 INSPECTING & PROTECTING WORKBOOKS ........................................................................... 146
Document Inspector............................................................................................................... 146
Protecting Your Workbook ..................................................................................................... 148
15 INTRO TO PIVOTTABLES....................................................................................................... 149
Using PivotTables to Answer Questions ................................................................................ 149
Create a PivotTable: ............................................................................................................... 150
Pivoting Data .......................................................................................................................... 153
16 DOING MORE WITH PIVOT TABLES ...................................................................................... 156
Filters ...................................................................................................................................... 156
Slicers ..................................................................................................................................... 158
PivotCharts ............................................................................................................................. 160
17 EXERCISE ............................................................................................................................. 162
18 REFERENCE ......................................................................................................................... 169