Categories Pricing Corporate
Professional eBook

Pivot Tables Explained

Unleash this Excel Superpower and Convert your Data to Gold

0 Reviews
106
Language:  English
If you need to learn about Excel pivot tables this book is for you. It assumes no prior knowledge and takes you from novice to ninja with the help of files, clear explanations and practical examples.
Professional Plus subscription free for the first 30 days, then $8.99/mo
Access to this title on the bookboon platform
Description
Content

Pivot Tables is a key Excel skill. This book takes you from novice to ninja and ensures you have what you need from the start including understanding why you need to have clean data, how to add charts, slicers and conditional formatting to enhance your presentation. There is also a section on how to handle multiple data sets. If you need to learn about Excel pivot tables this book is for you. It assumes no prior knowledge and takes you from novice to ninja with the help of files, clear explanations and practical examples. There’s also some bad jokes, movie references and puns.

About the Author

The author is Anne Walsh, a freelance trainer based in Ireland, who has been working with Excel since it was Excel 5.0. She is a MOS Master Instructor and aims to put the fun in functions by making Excel accessible and enjoyable. She is the author of “Your Excel Survival Kit: Your guide to surviving and thriving in an Excel world” (2nd edition).

  • Author Biography
  1. What is a Pivot Table and why should you care?
    1. Overview of Pivot Tables
    2. What are they used for?
    3. What else is here?
    4. What are you going to learn from this book?
  2. Power Query – your data cleansing superpower
    1. Cleaning up blank unwanted columns, columns and unwanted totals
  3. Ingredients ready – let’s get cooking
    1. Let us begin with a Table
    2. Begin with “one that has been prepared earlier” i.e. a Recommended Pivot Table
    3. Let’s explore the structure of a pivot table
    4. Adding dates into the mix
    5. Adding a Timeline to our pivot table
    6. Keeping it all up to date
    7. Adding/removing Subtotals
    8. Adding/removing Grand Totals
    9. Amending Report Layout
    10. Playing with Pivot Table Design
    11. Experimenting with Style Options
    12. Conclusion
  4. Beyond the basics – doing a deeper dive into our Summarise/Calculation choices
    1. Using Summarize Values By
    2. Conclusion
  5. Using Show Values As – Getting even more out of our data
    1. % of Grand Total
    2. % of Column Total
    3. % of Row Total
    4. % of
    5. % of Parent Row Total
    6. % of Parent Column total
    7. % of Parent Total
    8. Difference From
    9. % Difference From
    10. Running Total in
    11. Rank – Smallest to Largest/Rank – Largest to Smallest
    12. Index
    13. Creating Custom Calculations
    14. GetPivotData – the strange lumpy formula that can be useful
    15. Add a pop of colour with some Conditional Formatting
    16. Conclusion
  6. Creating a pivot table from many data sources WITHOUT a formula
    1. Why would you use this?
    2. Creating Pivot Tables with multiple tables using the Data Model
    3. Using the data from one file and two sheets
    4. Let’s try getting the data from two files
    5. Meet PowerPivot – the Power behind the Pivot
    6. Get your measure/s ready
    7. Conclusion
  7. Conclusion
  8. Bibliography / References

About the Author
Anne

Anne Walsh

Anne Walsh is a freelance trainer (since the mid-90s) aka as The Excel Lady. She got this name when people would look at her and say, “you, you’re the Excel Lady!” She saw her first spreadsheet in the early 1990s and has been intrigued by them ever since, even though they only came in green or orange. She likes to say she puts the “fun in functions” and is excited by the potential of Power Query.