Sign-In
Cart
Excel 365 - Pivot Tables & Charts: A Quickstudy Laminated Reference Guide
Other
Currently unavailable to order
Please enter your email and a message will be sent to you when this product becomes available on our website.
ISBN10: 1423246160
ISBN13: 9781423246169
Publisher: Quickstudy Reference Guides
Published: Nov 1 2020
Pages: 6
Weight: 0.35
Height: 0.10 Width: 8.30 Depth: 11.00
Language: English
ISBN13: 9781423246169
Publisher: Quickstudy Reference Guides
Published: Nov 1 2020
Pages: 6
Weight: 0.35
Height: 0.10 Width: 8.30 Depth: 11.00
Language: English
Quick and easy 6-page laminated guide focuses on creating and using pivot tables efficiently and effectively in Excel. Whether you are a beginner or experienced user, pivot tables offer flexibility while doubling down on Excel's power. Curtis Frye, author of multiple books on Excel, creator of many LinkedIn Learning videos and an experienced corporate trainer uses his experience and knowledge to cover the most relevant use of pivot tables at different levels of complexity. As a corporate trainer, seeing what beginners need to start using pivot tables and what those with some pivot table skills can do to harness more power brings value to this targeted reference at an unbeatable price. Look for Excel 365 and Excel 365 Tips and Tricks QuickStudy guides to have a solid power-user reference set.
Introducing PivotTables
- Glossary
- Creating & Pivoting PivotTables
- Arrange Data for Use in a PivotTable
- Create a PivotTable from an Excel Table, Data List or from External Data
- Create a Recommended PivotTable
- Refresh PivotTable Data, Update Cell References that Provide Data to a PivotTable
- Pivot a PivotTable, Defer PivotTable Updates
- Managing PivotTables
- Show or Hide the Field List, Expand & Contract Buttons, Field Headers
- Select an Entire PivotTable, Move it, Copy a Configuration, Delete a PivotTable
- Summarizing PivotTable Data
- Show or Hide Subtotals, Grand Totals
- Change the Data Field Summary Operation
- Change How PivotTable Data Values Are Displayed
- Summarize More than One Data Field
- Create, Edit, Delete a Calculated Field
- Use PivotTable Data in a Formula
- Display Data Source Rows
- Create an Excel table from a PivotTable
- Sorting & Filtering PivotTable Data
- Sort a Column of PivotTable Data into Ascending or Descending Order
- Custom Lists
- Filter a PivotTable Field by Selection, Rule, Using a Search Filter
- Slicers
- Filter a PivotTable Using Report Filter Fields
- Create Individual PivotTables Using Report Filter Values
- Clear a PivotTable Filter Using the Field List Pane
- Clear a Filter Using the Row or Column Labels, Clear All Filters
- Defining Sets of Values
- Define a Set Based on Row Items, on Column Items
- Display a Set in the Rows or Columns Area
- Edit a Set, Delete a Set
- Formatting PivotTables
- Apply a PivotTable Style
- Apply a PivotTable Style & Remove Existing Formatting
- Apply or Remove Headers & Banding
- Create a PivotTable Style
- Apply a Custom PivotTable Style
- Change the Data Field Number Format
- Change the PivotTable Layout
- Control Whether PivotTable Lables Are Repeated at the Top of Each Printed Page
- Determine How to Handle Blank Rows
- Creating & Manipulating PivotCharts
- Create a New PivotChart/from an Existing PivotTable
- Pivot a PivotChart
- Filter a PivotChart by Selection/by Rule
- Apply a Style to a PivotChart
- Change a PivotChart's Layout/Chart Type
- Add a Trendline to a PivotChart
- Move a PivotChart to Another Worksheet/to a Chart Sheet
- Apply a Quick Layout to a PivotChart
- Add or Remove a PivotChart Element
- Apply a PivotChart Style, Change the Color Scheme
- Format a PivotChart Data Series, Format One Value in a PivotChart Data Series
- Add an Annotation to a PivotChart, Format a PivotChart Annotation
- Printing PivotTables
- Print a PivotTable, Print Headers at the Top of Each Printed Page
- Print Each Item on Its Own Page, Print a PivotChart
- Enabling & Adding Tables to the Data Model
- Create a Relationship between Two Tables
- Create a PivotTable Using the Data Model
- Work with a PivotTable Created Using the Data Model
- Edit a Table Relationship, Deactivate, Activate, Delete a Relationship
- Filtering PivotTables Using Timelines
- Create a Timeline
- Filter a PivotTable Using a Timeline
- Format a Timeline
- Clear a Timeline Filter
- Remove a Timeline
Also in
Applications
Microsoft 365 Excel All-In-One for Dummies
Alexander, Michael
Kusleika, Dick
Ringstrom, David H.
Paperback
$42.74
The Definitive Guide to Dax: Business Intelligence for Microsoft Power Bi, SQL Server Analysis Services, and Excel
Ferrari, Alberto
Russo, Marco
Paperback
$71.99
Excel Formulas: Quickstudy Laminated Study Guide (Quickstudy Computer)
Jensen, Krista
Hales, John
Other
$5.65
Designing Machine Learning Systems: An Iterative Process for Production-Ready Applications
Huyen, Chip
Paperback
$62.69
Me, My Customer, and AI: The New Rules of Entrepreneurship
Thorne, Nicholas
Werdelin, Henrik
Hardcover
$24.70
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Cetinkaya-Rundel, Mine
Wickham, Hadley
Grolemund, Garrett
Paperback
$75.99
Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Bruce, Peter
Bruce, Andrew
Gedeck, Peter
Paperback
$75.99
Cloud Finops: Collaborative, Real-Time Cloud Value Decision Making
Storment, J. R.
Fuller, Mike
Paperback
$75.99
Between You and AI: Unlock the Power of Human Skills to Thrive in an Ai-Driven World
Iorio, Andrea
Hardcover
$26.60
Dark Web: A Comprehensive Guide to Its Mechanics and Risks (The Insidious Happenings Lurking Right Beneath Our Internet Haven)
McClendon, Adolfo
Paperback
$18.95
Deep Learning for Biology: Harness AI to Solve Real-World Biology Problems
Latysheva, Natasha
Ravarani, Charles
Paperback
$66.49
Social Science Research Design and Statistics: A Practitioner's Guide to Research Methods and IBM SPSS Analysis
Ponton, Michael K.
Rovai, Alfred P.
Baker, Jason D.
Paperback
$43.43
An Introduction to Statistical Learning: With Applications in R
Witten, Daniela
Hastie, Trevor
James, Gareth
Paperback
$90.99
Power Query Beyond The User Interface: Solving Advanced Data Cleaning Problems Using M
Chhabra, Chandeep
Paperback
$34.95
Building Rocketships: Product Management for High-Growth Companies
Udezue, Oji
Udezue, Ezinne
Paperback
$17.09
Microsoft 365 Copilot Adoption: A Practical Guide for Business Leaders and Consultants
Smith, Megan
Smith, Mark
Paperback
$41.99
Microsoft Copilot Studio Step by Step: Customizing Copilot and Creating Agents
Crosbie, Lisa
Paperback
$71.99
How to Measure Anything in Project Management
Bang Leed, Andreas
Budzier, Alexander
Hubbard, Douglas W.
Hardcover
$57.00
Dark Web: A Complete Guide to the Dark Web True Tales (The Addictive Input down able Gripping Crime Thriller of Mystery and Suspense)
Guerrero, Theodore
Paperback
$18.95
Planning and Control Using Oracle Primavera P6 Versions 18 to 23 PPM Professional
Harris, Paul E.
Paperback
$130.80
Building Event-Driven Microservices: Leveraging Organizational Data at Scale
Bellemare, Adam
Paperback
$66.49
Materials Management with SAP S/4hana: Business Processes and Configuration
Murray, Martin
Akhtar, Jawad
Hardcover
$85.45
Data Visualization with Microsoft Power Bi: How to Design Savvy Dashboards
Kolokolov, Alex
Zelensky, Maxim
Paperback
$56.99
Fundamentals of Microsoft Fabric: Designing End-To-End Analytics Solutions
ILIC, Nikola
Weissman, Ben
Paperback
$56.99
Databricks Certified Data Engineer Associate Study Guide: In-Depth Guidance and Practice
Alhussein, Derar
Paperback
$75.99
Planning and Control Using Oracle Primavera P6 Versions 8 to 21 PPM Professional
Harris, Paul E.
Paperback
$114.00
Take Back Your Life!: Using Microsoft Office Outlook to Get Organized and Stay Organized
McGhee, Sally
Paperback
$29.94
MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Excel Associate Exam Mo-200
Butow, Eric
Paperback
$23.75
The SaaS Email Marketing Playbook: Convert Leads, Increase Customer Retention, and Close More Recurring Revenue With Email
Garbugli, Étienne
Paperback
$23.74
Microsoft 365 and SharePoint Online Cookbook - Second Edition: A complete guide to Microsoft Office 365 apps including SharePoint, Power Platform, Cop
Ghatak, Sudeep
Chamberlain, Nate
Mahajan, Gaurav
Paperback
$39.99
Ingeniería de Requisitos: Software Orientado al Negocio
Vazquez, Carlos Eduardo
Siqueira Simões, Guilherme
Paperback
$18.61
Enterprise Architecture with Sap: Planning, Management, and Transformation
Das, Anup
Klee, Peter
Reichel, Johannes
Paperback
$85.45
Microsoft Excel VBA and Macros: Your Guide to Efficient Automation
Jelen, Bill
Syrstad, Tracy
Paperback
$65.99
Numerical Recipes: The Art of Scientific Computing
Teukolsky, Saul A.
Vetterling, William T.
Press, William H.
Hardcover
$175.56
Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI
Ehrenmueller-Jensen, Markus
Paperback
$66.49
Generative AI for Software Development: Building Software Faster and More Effectively
Pereira, Sergio
Paperback
$66.49
Dark Web: Everything You Didn't Know About Dark Web (Know All Everything You Need About Exploiting the Dark Web)
Slaton, Cynthia
Paperback
$18.95
3D Data Science with Python: Building Accurate Digital Environments with 3D Point Cloud Workflows
Poux, Florent
Paperback
$75.99
Master Your Data with Power Query in Excel and Power Bi: Leveraging Power Query to Get & Transform Your Task Flow
Escobar, Miguel
Puls, Ken
Paperback
$33.20
Mastering QuickBooks(R) 2025 - Sixth Edition: Bookkeeping for small businesses with US QuickBooks(R) Online
Shelton, Crystalynn
Paperback
$37.49
ITIL(R) 4 Create, Deliver and Support (CDS): Your companion to the ITIL 4 Managing Professional CDS certification
Agutter, Claire
Paperback
$59.99
Python Machine Learning By Example - Fourth Edition: Unlock machine learning best practices with real-world use cases
Liu, Yuxi (Hayden)
Paperback
$57.49
Microsoft Power BI Cookbook - Third Edition: Convert raw data into business insights with updated techniques, use cases, and best practices
Deckler, Greg
Powell, Brett
Paperback
$74.99
Quantitative Methods for the Social Sciences: A Practical Introduction with Examples in R
Stockemer, Daniel
Bordeleau, Jean-Nicolas
Hardcover
$74.99
The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Cotgreave, Andy
Wexler, Steve
Shaffer, Jeffrey
Paperback
$49.35
Power Pivot and Power Bi: The Excel User's Guide to Dax, Power Query, Power Bi & Power Pivot in Excel 2010-2016
Singh, Avichal
Collie, Rob
Paperback
$29.40
Warehouse Management with SAP S/4hana: Embedded and Decentralized Ewm
Sachan, Namita
Jain, Aman
Hardcover
$94.95
Numerical Python: Scientific Computing and Data Science Applications with Numpy, Scipy and Matplotlib
Johansson, Robert
Paperback
$33.24
Collect, Combine, and Transform Data Using Power Query in Power Bi and Excel
Maslyuk, Daniil
Raviv, Gil
Paperback
$59.99
The Developer's Playbook for Large Language Model Security: Building Secure AI Applications
Wilson, Steve
Paperback
$75.99
Microsoft Power BI Quick Start Guide - Third Edition: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more
Pearson, Mitchell
Ostrowsky, Erin
Knight, Devin
Paperback
$49.99
SAP S/4hana Financial Accounting Certification Guide: Application Associate Exam
Pougkas, Stefanos
Paperback
$75.95
Microsoft Excel in Easy Steps: Illustrated Using Excel in Microsoft 365
Price, Michael
McGrath, Mike
Paperback
$18.04
No B.S. Guide to Successful Marketing Automation: The Ultimate No Holds Barred Guide to Using Technology, Automation, and Artificial Intelligence in M
Shah, Parthiv
Kennedy, Dan S.
Paperback
$23.74
Understanding Google Docs - 2025 Edition: The Full Color Guide to Document Creation, Formatting, and Collaboration
Wilson, Kevin
Paperback
$31.24
React and React Native - Fifth Edition: Build cross-platform JavaScript and TypeScript apps for the web, desktop, and mobile
Sakhniuk, Mikhail
Boduch, Adam
Paperback
$54.99
Essential Math for AI: Next-Level Mathematics for Efficient and Successful AI Systems
Nelson, Hala
Paperback
$75.99
Microsoft Power Automate Cookbook: Automating Business Processes Easily, Intuitively, and Quickly
Najjar, Ahmad
Paperback
$75.99
Reimagining Collaboration: Slack, Microsoft Teams, Zoom, and the Post-COVID World of Work
Simon, Phil
Paperback
$18.95
Autonomous Minds: How Agentic AI Predicts and Learns to Enable Productivity and Empowerment
Campos Zabala, Francisco Javier
Paperback
$28.50
Tableau Certified Data Analyst Study Guide: Learn the Core Concepts and Techniques Necessary to Ace the Exam
Gardner, Christopher
Paperback
$56.99
Information Architecture: For the Web and Beyond
Arango, Jorge
Rosenfeld, Louis
Morville, Peter
Paperback
$61.74
The AI Selling Revolution: The Ultimate Guide to Unlocking AI-Powered Strategies for Winning Sales
Sim, Lionel
Paperback
$16.74
Learning Tableau 2025 - Sixth Edition: Leverage Tableau's newest features to revolutionize your data storytelling with AI-enhanced insights
Milligan, Joshua N.
Paperback
$74.99
How AI Ate the World: A Brief History of Artificial Intelligence - And Its Long Future
Stokel-Walker, Chris
Paperback
$20.00
Excel 2023: A Comprehensive Guide to become an Expert on Excel 2023 With All-in-One Approach
Wright, Leonardo L.
Paperback
$18.95
FrameMaker - Working with Content (2020 Release): Updated for 2020 Release (8.5"x11")
Sullivan, Matt R.
Paperback
$72.49
Data Science at the Command Line: Obtain, Scrub, Explore, and Model Data with UNIX Power Tools
Janssens, Jeroen
Paperback
$62.69
The Transformative Magic of M Code in Power Query Excel & Power Bi: A Beginner's Guide to Mastering the Art of Data Metamorphosis to Get Just the Data
Girvin, Mike Excelisfun
Paperback
$33.20
SAP Activate Project Management Certification Guide: Certified Associate Exam
Viswanathan, Jeyaganesh
Lal, Aditya
Paperback
$75.95
Machine Learning Design Patterns: Solutions to Common Challenges in Data Preparation, Model Building, and MLOps
Robinson, Sara
Munn, Michael
Lakshmanan, Valliappa
Paperback
$62.69
Machine Learning Production Systems: Engineering Machine Learning Models and Pipelines
Hapke, Hannes
Caveness, Emily
Crowe, Robert
Paperback
$75.99
Version Control with Git: Powerful Tools and Techniques for Collaborative Software Development
Loeliger, Jon
Ponuthorai, Prem Kumar
Paperback
$62.69
EXCEL Formulas and Functions 2024: 140 Most Popular Shortcuts and Tricks For Beginners to Experts
Rader, Steven M.
Paperback
$11.99
Cloud Integration with SAP Integration Suite: The Comprehensive Guide
Singh, Shashank
Singh, Swati
Bilay, John Mutumba
Hardcover
$85.45
Building LLM Powered Applications: Create intelligent apps and agents with large language models
Alto, Valentina
Paperback
$62.49
Software Wasteland: How the Application-Centric Mindset is Hobbling our Enterprises
McComb, Dave
Paperback
$23.70