PDF free download | Data Tables And Pivot Tables Essential Excel Skills For Business essential Excel Business For Skills Book 2 by Carl Nixon

Contents of Data Tables and Pivot Tables

• Chapter 1 An Introduction to Data Tables
• Chapter 2 Creating a Data Table.
• Chapter 3 Sorting a Data Table.
• Chapter 4 Filtering a Data Table.
• Chapter 5 Summarising a Data Table.
• Chapter 6 Structured References.
• Chapter 7 What If Analysis with Data Tables.
• Chapter 8 Using the Goal Seeker.
• Chapter 9 Adding a Bit of Style.
• Chapter 10 An Introduction to Pivot Tables
• Chapter 11 Creating a Pivot Table.
• Chapter 12 Grouping Pivot Table Items.
• Chapter 13 Same Pivot Table, Different Look.
• Chapter 14 Multi Level Pivot Tables.
• Chapter 15 Frequency Distribution in Pivot Tables.
• Chapter 16 Charting with Pivot Charts.
• Chapter 17 Slicing Pivot Tables with Slicers.
• Chapter 18 Updating Pivot Tables.
• Chapter 19 Calculated Fields and Items.