Excel Pivot Tables Made Simple
A Step-by-Step Guide for Office ProfessionalsBy Ruth Callender
Length4h 23m
About this audiobook
You have the data. What you don't have is a fast, reliable way to turn it into something your manager can actually use. Excel Pivot Tables Made Simple is written for office professionals who need answers from spreadsheets without wrestling with features nobody explained. By the last page, you will build, customize, and automate pivot tables that turn raw data into clear, actionable reports, confidently and on your own. Inside, you will find plain steps for creating your first pivot table in minutes, guidance on the four areas of rows, columns, values, and filters, and practical chapters on grouping, sorting, slicers, calculated fields, and pivot charts. There is also a troubleshooting chapter for the problems that trip people up, plus real-world scenarios and a quick-reference playbook you can keep at your desk. If pivot tables have always felt like something other people understand, this book changes that. Start with chapter one tonight.
Audiobook details
GenreTechnology
Length4 hrs 23 mins
Narrated byListen with 1,000+ voices
FormateBook with Audio
Publish dateOct 13, 2026
LanguageEnglish
Table of contents
1Introduction
2Why Pivot Tables Will Change Your Workday
3Getting Your Data Ready for Pivot Tables
4Creating Your First Pivot Table in Minutes
5Mastering the Four Areas: Rows, Columns, Values, and Filters
Mostrar todos os capítulosVer menos
6Summarizing Numbers: Sum, Count, Average, and More
7Grouping and Sorting: Organize Your Data Your Way
8Filtering and Slicers: Focus on What Matters
9Formatting Your Pivot Table for Clear Reports
10Updating and Refreshing: Keeping Your Data Current
11Calculated Fields and Items: Custom Calculations
12Pivot Charts: Visualizing Your Data
13Common Problems and How to Fix Them
14Real-World Scenarios: Putting It All Together
15Pivot Tables Meet Power Query: Clean Once, Refresh Forever
16Building a Self-Updating Dashboard with Pivot Tables and Slicers
17Your Pivot Table Playbook: Quick Reference and Next Steps
18About the Author
Microsoft Teams Made SimpleRuth Callender4h 16m$11
The Plain-English Guide to Power BIRuth Callender4h 15m$25
The Plain-English Guide to Google SlidesRuth Callender4h 32m$6
Wix Website Made SimpleRuth Callender4h 18m$15
The Plain-English Guide to LibreOfficeRuth Callender4h 29m$8
The Plain-English Guide to Microsoft AccessRuth Callender3h 59m$15
The Plain-English Guide to AirtableRuth Callender4h 17m$7
The Plain-English Guide to AsanaRuth Callender4h 20m$7
The Plain-English Guide to Apple KeynoteRuth Callender3h 54m$7
Trello for Beginners Made SimpleRuth Callender4h 7m$7
The Plain-English Guide to QuickBooks OnlineRuth Callender4h 23m$15
WordPress for Beginners Made SimpleRuth Callender4h 28m$20
Excel VBA for BeginnersRuth Callender4h 3m$8
Dropbox for Beginners Made SimpleRuth Callender4h 24m$5
Excel Macros Made SimpleRuth Callender3h 56m$20
SharePoint for Beginners Made SimpleRuth Callender4h 20m$15
QuickBooks for Small Business OwnersRuth Callender4h 1m$15
Excel Dashboards Made SimpleRuth Callender4h 21m$20
Apple Numbers Made SimpleRuth Callender3h 59m$8
Outlook Calendar Made SimpleRuth Callender3h 54m$8
LiftoffEric Berger9h 4m4.6 (9.5K)$29 · $0.00
The Honey BusMeredith May9h 31m4.4 (16.6K)$25 · $0.00
Collected Writings of Nikola TeslaThomas Commerford Martin, Nikola Tesla19h 42m4.4 (2.8K)$1.99 · $0.00
Operation PedestalMax Hastings12h 29m4.4 (5.2K)$29 · $0.00
When the Heavens Went on SaleAshlee Vance18h 20m4.4 (3K)$40 · $0.00
Everybody Has a Podcast (Except You)Justin McElroy, Travis McElroy, Griffin McElroy5h 9m4.3 (2.3K)$24 · $0.00
Hands of TimeRebecca Struthers8h 8m4.4 (1.3K)$26 · $0.00
Never Lost AgainBill Kilday10h 1m4.4 (805)$29 · $0.00
How the Internet HappenedBrian McCullough13h 28m4.3 (2.7K)$23 · $0.00
Collected Writings of Nikola TeslaNikola Tesla, Thomas Commerford Martin21h 50m4.3 (1.7K)$1 · $0.00
Just AspireAjai Chowdhry9h 13m4.4 (260)$29 · $0.00
The Little Book of AliensAdam Frank8h 20m4.3 (1.3K)$26 · $0.00
The inventions, researches and writings of Nikola Tesla (Annotated)Thomas Commerford Martin16h 59m4.3 (1.3K)$2 · $0.00
KargilV.P. Malik15h 18m4.3 (2K)$24 · $0.00
Experiments with Alternating CurrentsNikola Tesla9h 16m4.3 (874)$1.99 · $0.00
Fire on the HorizonTom Shroder, John Konrad8h 23m4.3 (858)$26 · $0.00
The Smell of Kerosene (Annotated)National Aeronautics and Space Administration, Donald L. Mallick, Peter W. Merlin11h 32m4.3 (523)$2 · $0.00
The Boy Who Harnessed the WindWilliam Kamkwamba, Bryan Mealer10h 5m4.2 (78.9K)$29 · $0.00
Across the Airless WildsEarl Swift10h 8m4.3 (1.3K)$29 · $0.00
Console WarsBlake J. Harris20h 41m4.2 (13.7K)$46 · $0.00
You may also like
Our Oriental HeritageWill Durant50h 13m4.4 (5.9K)$30
The Plain-English Guide to CanvaMiles Draper4h 17m$8
Power Automate Made SimpleRuth Callender4h 26m$7
Wix Website Made SimpleRuth Callender4h 18m$15
CustomersBradley J Sugars8h 55m4.1 (58)Free
Travel words and phrases in FrenchJM Gardner1h 11m$7 · $0.00
Samsung Tablet Made SimpleWalter Hemsley4h 13m$8
Squarespace Made SimpleRuth Callender3h 59m$19
DigitalBradley J Sugars5h 11m4.8 (10)Free
ScaleBradley J Sugars3h 27m4.6 (52)Free
The Senior-Friendly Guide to iPadWalter Hemsley3h 43m$15
RecruitBradley J Sugars4h 6m4.3 (56)Free
The Plain-English Guide to AsanaRuth Callender4h 20m$7
Word for SeniorsWalter Hemsley3h 45m$5
Etsy Shop for Beginners Made SimpleRuth Callender3h 52m$8
Learn AI in 30 Days Made SimpleMiles Draper4h 10m$8
The AI Advantage for EcommerceMiles Draper4h 17m$14
The Greatest Works of Immanuel KantImmanuel Kant84h 15m4.4 (120)$1 · $0.00
The Foundations of Science: Science and Hypothesis, The Value of Science, Science and MethodHenri Poincaré23h 25m4.3 (81)$2 · $0.00
Rapid Spanish (Latin American), Vols. 1–3Earworms Learning3h 36m4.1 (171)$25