Pivot Tables: Easy Excel Essentials, #1
()
About this ebook
Pivot Tables are one of the most powerful tools in Excel. They allow you to easily take a large amount of data and summarize or analyze that data in mere moments.
If you don't know how to use Pivot Tables yet, you need to learn them.
And this guide will walk you through them step-by-step in an easy, clear, straight-forward manner.
The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, and 50 Useful Excel Functions. In that series, pivot tables are covered in Intermediate Excel.
M.L. Humphrey
Hi there Sci Fi fans, my name is Maurice Humphrey. I am a Vermont native, husband, father, grandfather, well over 60, Navy veteran, retired IBM engineer, retired printer repairman, Graduated: Goddard Jr. College, VT Technical College, and Trinity College. Over the years I've written technical articles, taught technical classes, and presented at technical conventions. I've been reading science fiction for over 50 years now. First books were "Journey to the Centre of the Earth" by Jules Verne and "The Stars Are Ours" by Andre Norton. I've read and collected many great stories, and a considerable amount of junk ones as well. I'd say by now that I probably have a good idea of what I consider a good story.
Other titles in Pivot Tables Series (6)
Pivot Tables: Easy Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsConditional Formatting: Easy Excel Essentials, #2 Rating: 0 out of 5 stars0 ratingsThe IF Functions: Easy Excel Essentials, #4 Rating: 0 out of 5 stars0 ratingsCharts: Easy Excel Essentials, #3 Rating: 0 out of 5 stars0 ratingsFormatting: Easy Excel Essentials, #5 Rating: 0 out of 5 stars0 ratingsPrinting: Easy Excel Essentials, #6 Rating: 0 out of 5 stars0 ratings
Read more from M.L. Humphrey
Excel Tips and Tricks Rating: 0 out of 5 stars0 ratingsAccess 2019 Beginner: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsPowerPoint Essentials Rating: 0 out of 5 stars0 ratingsAccess Essentials 2019 Rating: 0 out of 5 stars0 ratingsHow To Gather And Use Data For Business Analysis Rating: 0 out of 5 stars0 ratingsExcel 365 Essentials Rating: 0 out of 5 stars0 ratingsExcel 2019 Formulas and Functions Study Guide Rating: 0 out of 5 stars0 ratingsAccess 2019 Intermediate: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsMicrosoft Office for Beginners Rating: 0 out of 5 stars0 ratingsPowerPoint 365 Essentials: PowerPoint 365 Essentials Rating: 0 out of 5 stars0 ratingsMicrosoft Office 2019 Beginner Rating: 0 out of 5 stars0 ratingsWord Essentials Rating: 0 out of 5 stars0 ratingsPowerPoint Essentials 2019 Rating: 0 out of 5 stars0 ratingsWord 365 Essentials Rating: 0 out of 5 stars0 ratingsGateway Rating: 0 out of 5 stars0 ratingsExcel Essentials 2019 Rating: 0 out of 5 stars0 ratingsMicrosoft Office 365 for Beginners Rating: 0 out of 5 stars0 ratingsMy Grandfather's Spaceship Rating: 0 out of 5 stars0 ratingsWord Essentials 2019 Rating: 0 out of 5 stars0 ratings
Related to Pivot Tables
Titles in the series (6)
Pivot Tables: Easy Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsConditional Formatting: Easy Excel Essentials, #2 Rating: 0 out of 5 stars0 ratingsThe IF Functions: Easy Excel Essentials, #4 Rating: 0 out of 5 stars0 ratingsCharts: Easy Excel Essentials, #3 Rating: 0 out of 5 stars0 ratingsFormatting: Easy Excel Essentials, #5 Rating: 0 out of 5 stars0 ratingsPrinting: Easy Excel Essentials, #6 Rating: 0 out of 5 stars0 ratings
Related ebooks
Excel 2019 PivotTables: Easy Excel Essentials 2019, #1 Rating: 5 out of 5 stars5/5150 Most Poweful Excel Shortcuts: Secrets of Saving Time with MS Excel Rating: 3 out of 5 stars3/5Excel Dynamic Arrays Straight to the Point 2nd Edition Rating: 5 out of 5 stars5/5MrExcel XL: The 40 Greatest Excel Tips of All Time Rating: 4 out of 5 stars4/5Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel Rating: 4 out of 5 stars4/5Printing: Easy Excel Essentials, #6 Rating: 0 out of 5 stars0 ratingsMastering Excel Macros: Introduction: Mastering Excel Macros, #1 Rating: 4 out of 5 stars4/5Hidden Gems of Microsoft Excel Rating: 0 out of 5 stars0 ratingsMrExcel LX The Holy Grail of Excel Tips: Covers Excel Backwards and Forwards Rating: 0 out of 5 stars0 ratingsExcel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Cleaning Excel Data With Power Query Straight to the Point Rating: 5 out of 5 stars5/550 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5Excel 101: A Beginner's & Intermediate's Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time! Rating: 0 out of 5 stars0 ratingsExcel : The Complete Ultimate Comprehensive Step-By-Step Guide To Learn Excel Programming Rating: 0 out of 5 stars0 ratings101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5Excel 365 Pivot Tables: Easy Excel 365 Essentials, #4 Rating: 0 out of 5 stars0 ratingsTop Secrets Of Excel Dashboards: Save Your Time With MS Excel Rating: 5 out of 5 stars5/5The Ultimate Guide To Master Excel Features & Formulas. Become A Pro From Scratch in Just 7 Days With Step-By-Step Instructions Rating: 0 out of 5 stars0 ratingsExcel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5The Ultimate Excel VBA Master: A Complete, Step-by-Step Guide to Becoming Excel VBA Master from Scratch Rating: 0 out of 5 stars0 ratingsMrExcel LIVe: The 54 Greatest Excel Tips of All Time Rating: 5 out of 5 stars5/5Excel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables Rating: 5 out of 5 stars5/5MrExcel 2021: Unmasking Excel Rating: 0 out of 5 stars0 ratingsGuerilla Data Analysis Using Microsoft Excel Rating: 0 out of 5 stars0 ratingsIntermediate Excel: Excel Essentials, #2 Rating: 5 out of 5 stars5/5Formatting: Easy Excel Essentials, #5 Rating: 0 out of 5 stars0 ratings
Enterprise Applications For You
QuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsCreating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Excel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5Microsoft Teams For Dummies Rating: 0 out of 5 stars0 ratingsExcel 101: A Beginner's & Intermediate's Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time! Rating: 0 out of 5 stars0 ratingsExcel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Notion for Beginners: Notion for Work, Play, and Productivity Rating: 4 out of 5 stars4/5QuickBooks 2024 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsBitcoin For Dummies Rating: 4 out of 5 stars4/5Excel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables Rating: 5 out of 5 stars5/5QuickBooks Online For Dummies, 2025 Edition Rating: 5 out of 5 stars5/5NetSuite For Dummies Rating: 4 out of 5 stars4/5Excel All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsMicrosoft 365 Word For Dummies Rating: 0 out of 5 stars0 ratingsExcel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Microsoft Copilot For Dummies Rating: 0 out of 5 stars0 ratingsMicrosoft Word Guide for Success: Achieve Efficiency and Professional Results in Every Document [IV EDITION] Rating: 5 out of 5 stars5/5M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query Rating: 4 out of 5 stars4/5QuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsSharePoint For Dummies Rating: 0 out of 5 stars0 ratingsMicrosoft Excel Formulas: Master Microsoft Excel 2016 Formulas in 30 days Rating: 4 out of 5 stars4/5The AI Bible, Making Money with Artificial Intelligence: Real Case Studies and How-To's for Implementation Rating: 4 out of 5 stars4/5Scrivener For Dummies Rating: 4 out of 5 stars4/5Teach Yourself VISUALLY Microsoft 365 Rating: 0 out of 5 stars0 ratingsAccess 2019 For Dummies Rating: 0 out of 5 stars0 ratings
Reviews for Pivot Tables
0 ratings0 reviews
Book preview
Pivot Tables - M.L. Humphrey
Also by M.L. Humphrey
Easy Excel Essentials
Pivot Tables
Conditional Formatting
Charts
The IF Functions
Formatting
Printing
Excel Essentials
Excel for Beginners
Intermediate Excel
50 Useful Excel Functions
50 More Excel Functions
Excel Essentials Quiz Books
The Excel for Beginners Quiz Book
The Intermediate Excel Quiz Book
The 50 Useful Excel Functions Quiz Book
The 50 More Excel Functions Quiz Book
Pivot Tables
Easy Excel Essentials - Volume 1
M.L. Humphrey
Contents
Introduction
Pivot Tables
Conclusion
Appendix A: Basic Terminology
About the Author
Copyright
Introduction
In Excel for Beginners I covered the basics of working in Excel, including how to format in Excel and how to print. In Intermediate Excel I covered a number of intermediate-level topics such as pivot tables, charts, and conditional formatting. And in 50 Useful Excel Functions I covered fifty of the most useful functions you can use in Excel.
But I realize that some users will just want to know about a specific topic and not buy a guide that covers a variety of other topics that aren’t of interest to them.
So this series of guides is meant to address that need. Each guide in the series covers one specific topic such as pivot tables, conditional formatting, or charts.
I’m going to assume in these guides that you have a basic understanding of how to navigate