What do you think?
Rate this book
Data Tables and Pivot Tables: Essential Excel Skills for Business
The follow up to the best selling "Learn How to Use Pivot Tables In an Hour"!.
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.
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.
128 pages, Paperback
Published February 10, 2017
4 people are currently reading
7 people want to read
About the author
Carl Nixon
21 books43 followersCarl Nixon is a playwright, a short story writer and a novelist. He has written original plays and has adapted Lloyd Jones’ novel The Book of Fame and JM Coetzee's Disgrace.
Born in Christchurch, Nixon graduated with a Masters degree in Religious Studies from Canterbury University. He briefly taught secondary school English before leaving to teach in Japan for two years.
He has won numerous awards for his fiction, including winning and being nominated for key short story competitions.
Nixon was the Ursula Bethell/Creative New Zealand Writer in Residence at Canterbury University in 2006, where he completed his first novel, Rocking Horse Road. He has also written numerous plays for children.
2017 recipient of the Mansfield Menton Fellowship, with a sum of $35,000 to cover the time in Menton, France.
Born in Christchurch, Nixon graduated with a Masters degree in Religious Studies from Canterbury University. He briefly taught secondary school English before leaving to teach in Japan for two years.
He has won numerous awards for his fiction, including winning and being nominated for key short story competitions.
Nixon was the Ursula Bethell/Creative New Zealand Writer in Residence at Canterbury University in 2006, where he completed his first novel, Rocking Horse Road. He has also written numerous plays for children.
2017 recipient of the Mansfield Menton Fellowship, with a sum of $35,000 to cover the time in Menton, France.
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
No one has reviewed this book yet.