• Views: 299
  • No comments

Book Category: Business and Job
Posted by quantum 12-04-2017, 08:53


Data Tables And Pivot Tables: Essential Excel Skills For Business

by Carl Nixon

Read Online
Data Tables And Pivot Tables: Essential Excel Skills For Business

If you are new to Excel Data and Pivot Tables they can seem daunting and scary. This easy to follow and fully illustrated guide by the internationally renowned Excel consultant, Carl Nixon, is designed to get you up to speed quickly and easily. You will be able to quickly and easily start producing your own Pivot Tables and Data Tables!

We also cover Excels What If analysis tools and the Excel Goal Seeker.

This easy to follow guide is split in to 2 sections and is fully illustrated. Accompanying spreadsheets are free to download from out website.

Data 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.

Pivot Tables.

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.

Rated:
Total votes: 1

Related Books:

  • Learn To Use Excel Data Tables In An Hour: An Easy To Follow, Illustrated I ...

    Learn To Use Excel Data Tables In An Hour: An Easy To Follow, Illustrated I ...
  • Learn To Use Excel's Solver In An Hour: An Easy To Follow, Illustrated Int ...

    Learn To Use Excel's Solver In An Hour: An Easy To Follow, Illustrated Int ...
  • Influence Charts: How To Easily Gain A Powerful Overview Of Your Excel Spre ...

    Influence Charts: How To Easily Gain A Powerful Overview Of Your Excel Spre ...
  • Richard Nixon: The Life

    Richard Nixon: The Life
  • Structured Spreadsheet Modelling And Implementation: A Methodology For Crea ...

    Structured Spreadsheet Modelling And Implementation: A Methodology For Crea ...
  • Kalman Filtering: With Real-time Applications

    Kalman Filtering: With Real-time Applications
  • How To Make A Website For Beginners: Learn How To Make Your Own Website Fro ...

    How To Make A Website For Beginners: Learn How To Make Your Own Website Fro ...
  • The Ultimate Guide On How To Gain Successful Business Using Twitter

    The Ultimate Guide On How To Gain Successful Business Using Twitter
  • Learn To Use Excel Data Tables In An Hour: An Easy To Follow, Illustrated I ...

    Learn To Use Excel Data Tables In An Hour: An Easy To Follow, Illustrated I ...
  • Dax Power Pivot & Data Modelling In Excel 2016

    Dax Power Pivot & Data Modelling In Excel 2016
  • Excel Pivot Tables & Introduction To Dashboards The Step-by-step Guide

    Excel Pivot Tables & Introduction To Dashboards The Step-by-step Guide
  • Learn To Use Pivot Tables In An Hour: An Easy To Follow, Illustrated Introd ...

    Learn To Use Pivot Tables In An Hour: An Easy To Follow, Illustrated Introd ...
  • High Impact Data Visualization In Excel With Power View, 3d Maps, Get & Tra ...

    High Impact Data Visualization In Excel With Power View, 3d Maps, Get & Tra ...
  • Adaptive Filtering: Algorithms and Practical Implementation, 4th edition

    Adaptive Filtering: Algorithms and Practical Implementation, 4th edition
  • Sell Your Own Damn Movie!

    Sell Your Own Damn Movie!