Log in Try for free

Follow us

This website uses cookies

We use cookies to improve user experience. Choose which cookies you allow us to use. You can read more about our Cookie Policy in our privacy policy

See Cookies Details
Categories Corporate
Professional eBook

Pivot Tables Explained

Unleash this Excel Superpower and Convert your Data to Gold

by Anne Walsh
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 $6.99/mo
Access this book on our eReader, no adverts inside the book
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.

Click here to download the additional book files.

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
Write a review
About the Author
Anne

Anne Walsh

Discover Author
Related Content