Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Checkout

Change country

Modal Close icon
Country selected Country selected
country flag Germany
Country selected
country flag Slovakia
Country selected
country flag Canada
Country selected
country flag Brazil
Country selected
country flag Singapore
Country selected
country flag Hungary
Country selected
country flag Philippines
Country selected
country flag Mexico
Country selected
country flag Thailand
Country selected
country flag Ukraine
Country selected
country flag Luxembourg
Country selected
country flag Estonia
Country selected
country flag Lithuania
Country selected
country flag Norway
Country selected
country flag Chile
Country selected
country flag United States
Country selected
country flag Great Britain
Country selected
country flag India
Country selected
country flag Spain
Country selected
country flag South Korea
Country selected
country flag Ecuador
Country selected
country flag Colombia
Country selected
country flag Taiwan
Country selected
country flag Switzerland
Country selected
country flag Indonesia
Country selected
country flag Cyprus
Country selected
country flag Denmark
Country selected
country flag Finland
Country selected
country flag Poland
Country selected
country flag Malta
Country selected
country flag Czechia
Country selected
country flag New Zealand
Country selected
country flag Austria
Country selected
country flag Turkey
Country selected
country flag France
Country selected
country flag Sweden
Country selected
country flag Italy
Country selected
country flag Egypt
Country selected
country flag Belgium
Country selected
country flag Portugal
Country selected
country flag Slovenia
Country selected
country flag Ireland
Country selected
country flag Romania
Country selected
country flag Greece
Country selected
country flag Argentina
Country selected
country flag Malaysia
Country selected
country flag South Africa
Country selected
country flag Netherlands
Country selected
country flag Bulgaria
Country selected
country flag Latvia
Country selected
country flag Australia
Country selected
country flag Japan
Country selected
country flag Russia
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Home > Data > Data Analysis > Excel Charts and Pivot Tables
Excel Charts and Pivot Tables
Excel Charts and Pivot Tables

Excel Charts and Pivot Tables: Master Data Visualization with Excel's Charting and Pivot Table Tools

Arrow left icon
Profile Icon Skillshub Ltd
Arrow right icon
Can$126.99
Video Sep 2024 41mins 1st Edition
Video
Can$126.99
Subscription
Free Trial
Arrow left icon
Profile Icon Skillshub Ltd
Arrow right icon
Can$126.99
Video Sep 2024 41mins 1st Edition
Video
Can$126.99
Subscription
Free Trial
Video
Can$126.99
Subscription
Free Trial

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Table of content icon View table of contents

Key benefits

  • Comprehensive guide to Excel charts and pivot tables
  • In-depth tutorials on creating and customizing various chart types
  • Advanced pivot table techniques for efficient data analysis

Description

Dive into Excel with our expertly crafted course, designed to take you from beginner to advanced proficiency in data visualization and analysis. You'll start with creating various chart types like column, line, pie, bar, area, and scatter plots, with step-by-step instructions for effective data representation. Advanced techniques such as trendlines, error bars, and combination charts are covered, enabling clear presentations of complex data. Transitioning to pivot tables, you'll master inserting and manipulating tables, creating and customizing pivot tables, and using pivot charts for enhanced presentation. Learn to group pivot table items, create multi-level pivot tables, and generate frequency distributions for thorough data analysis. Discover interactive tools like slicers and methods to keep your pivot tables updated with changing data. By the course's end, you'll adeptly transform large datasets into actionable insights, essential for tracking KPIs, analyzing sales data, or managing projects. Enhance your data analysis capabilities with Excel's powerful charting and pivot table features, making data-driven decisions with confidence.

Who is this book for?

This course is ideal for technical professionals who work with data regularly and seek to improve their Excel skills. Prerequisites include basic knowledge of Excel and a fundamental understanding of data analysis concepts.

What you will learn

  • Create and customize various Excel charts
  • Manage data series and chart elements effectively
  • Utilize advanced chart features for enhanced visualization
  • Insert and manipulate tables and pivot tables
  • Perform complex data analysis using pivot tables
  • Generate pivot charts and use slicers for interactive data presentation

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Sep 03, 2024
Length: 41mins
Edition : 1st
Language : English
ISBN-13 : 9781836646518
Category :
Data
Concepts :
Data Analysis
Tools :
Excel

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want

Product Details

Publication date : Sep 03, 2024
Length: 41mins
Edition : 1st
Language : English
ISBN-13 : 9781836646518
Category :
Data
Concepts :
Data Analysis
Tools :
Excel

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just Can$6 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just Can$6 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

Practical Data Analysis
Practical Data Analysis
Read more
Oct 2013 360 pages
Full star icon 3.6 (7)
eBook
eBook
  • eBook eBook Can$38.99
  • Paperback Paperback Can$69.99
Can$38.99 Can$55.99
Can$69.99
Python Data Analysis
Python Data Analysis
Read more
Oct 2014 348 pages
Full star icon 3.9 (16)
eBook
eBook
  • eBook eBook Can$38.99
  • Paperback Paperback Can$69.99
Can$38.99 Can$55.99
Can$69.99
Stars icon
Total Can$ 139.98
Practical Data Analysis
Can$69.99
Python Data Analysis
Can$69.99
Total Can$ 139.98 Stars icon

Table of Contents

2 Chapters
Data Analysis - Chart Chevron down icon Chevron up icon
Charts
Column Chart
Line Chart
Pie Chart
Bar Chart
Area Chart
Scatter Plot
Data Series
Axes
Chart Sheet
Trendline
Error Bars
Sparklines
Combination Chart
Gauge Chart
Data Analysis - Pivot Tables Chevron down icon Chevron up icon
Tables
Pivot Tables
Group Pivot Table Items
Multi-level Pivot Table
Frequency Distribution
Pivot Chart
Slicers
Update Pivot Table
Calculated Field/Item

Recommendations for you

Left arrow icon
Python Machine Learning By Example
Python Machine Learning By Example
Read more
Jul 2024 518 pages
Full star icon 4.9 (8)
eBook
eBook
  • eBook eBook Can$31.99
  • Paperback Paperback Can$58.99
Can$31.99 Can$46.99
Can$58.99
Unlocking Data with Generative AI and RAG
Unlocking Data with Generative AI and RAG
Read more
Sep 2024 346 pages
eBook
eBook
  • eBook eBook Can$27.99
  • Paperback Paperback Can$50.99
Can$27.99 Can$40.99
Can$50.99
Building LLM Powered Applications
Building LLM Powered Applications
Read more
May 2024 342 pages
Full star icon 4.2 (22)
eBook
eBook
  • eBook eBook Can$34.99
  • Paperback Paperback Can$63.99
Can$34.99 Can$50.99
Can$63.99
Python for Algorithmic Trading Cookbook
Python for Algorithmic Trading Cookbook
Read more
Aug 2024 404 pages
Full star icon 4.6 (15)
eBook
eBook
  • eBook eBook Can$41.99
  • Paperback Paperback Can$75.99
Can$41.99 Can$60.99
Can$75.99
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 4.4 (95)
eBook
eBook
  • eBook eBook Can$38.99
  • Paperback Paperback Can$69.99
Can$38.99 Can$55.99
Can$69.99
Artificial Intelligence Engines
Artificial Intelligence Engines
Read more
Nov 2024 217 pages
eBook
eBook
  • eBook eBook Can$8.99
Can$8.99 Can$12.99
AI Product Manager's Handbook
AI Product Manager's Handbook
Read more
Nov 2024 484 pages
eBook
eBook
  • eBook eBook Can$34.99
  • Paperback Paperback Can$63.99
Can$34.99 Can$50.99
Can$63.99
RAG-Driven Generative AI
RAG-Driven Generative AI
Read more
Sep 2024 334 pages
Full star icon 4.5 (13)
eBook
eBook
  • eBook eBook Can$32.99
  • Paperback Paperback Can$59.99
Can$32.99 Can$47.99
Can$59.99
Hands-On Reinforcement Learning with Python
Hands-On Reinforcement Learning with Python
Read more
Jun 2018 318 pages
Full star icon 2.6 (18)
eBook
eBook
  • eBook eBook Can$27.98
  • Paperback Paperback Can$49.99
Can$27.98 Can$39.99
Can$49.99
LLM Engineer's Handbook
LLM Engineer's Handbook
Read more
Oct 2024 522 pages
Full star icon 4.9 (14)
eBook
eBook
  • eBook eBook Can$60.79
  • Paperback Paperback Can$75.99
Can$60.79
Can$75.99
Right arrow icon

About the author

Profile icon Skillshub Ltd
Skillshub Ltd
LinkedIn icon
SkillsHub is a division of the prestigious MTD Training Group, a five-time award-winning organization that has trained employees from over 9,000 companies. Their expert training team meticulously develops off-the-shelf eLearning content, ensuring practical, actionable learning experiences. Unlike content created by techies or outsourced writers, their materials are designed for real-world application. SkillsHub also offers bespoke eLearning solutions tailored to meet specific requirements, providing a customized learning experience. They focus on designing brain-friendly sessions that foster practical skills and knowledge application, ensuring effective learning outcomes in the workplace.
Read more
See other products by Skillshub Ltd
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.