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
   4   5   6   7   8   9   10   11   12   13   14