The Ultimate 2024 Pivot Tables & Dashboard in Excel Bundle

1 Review
111 Enrolled
3 Courses & 22.5 Hours
$27.99 CAD$55.00 CAD
You save 48%

What's Included

Pivot Tables for Beginners
  • Experience level required: Beginner
  • Access 64 lectures & 5.5 hours of content 24/7
  • Length of time users can access this course: Lifetime

Pivot Tables for Beginners

SS
Stream SkillStreamSkill.com
4.5/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business 10+ years and taught over 600,000 students in that time. We’ve created over 100 software training courses, 5,000+ video tutorials, and we’ve helped thousands of people across the world learn how to use Microsoft Office. We’ve now created Microsoft Excel courses for the last five versions and continue to help people get to grips with this essential tool.

Description

Pivot Tables is an essential Excel skill for jobs that involve analyzing and visualizing large amounts of data. Pivot Tables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating sets of data and letting you analyze data in a clear and effective way. This course will discuss the importance of cleaning your data before you can create your first Pivot Table. You will also learn how to create Pivot Charts and how to format your Pivot Tables and Charts.

4.6/5 average rating: ★ ★ ★ ★

  • Access 64 lectures & 5.5 hours of content 24/7
  • Clean & prepare your data
  • Create a Basic Pivot Table
  • Ue the Pivot Table Fields pane
  • Add Fields & Pivoting the Fields
  • Format Numbers in Pivot Table
  • Learn different ways to Summarize Data
  • Group Pivot Table Data
  • Use multiple Fields & Dimension
  • Learn the methods of Aggregation
  • Choose & lock the Report Layout
  • Apply Pivot Table styles
  • Sort data & use Filters
  • Create Pivot Charts based on Pivot Table data
  • Select the right Chart for your data
  • Apply Conditional Formatting
  • Add Slicers & Timelines to your dashboards
  • Add New Data to the original source dataset
  • Update Pivot Tables & Charts

Note: Software NOT included

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Intermediate knowledge of Microsoft Excels

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
1 Review
5/ 5
All reviews are from verified purchasers collected after purchase.
RS

Roger Stark

Verified Buyer

Very well layout course and easy to follow. I am glad to take this course. It gave me a true understanding of the pivot table concept to share data in many views with a click of the mouse. Well worth the money.

Nov 17, 2021
Your Cart
Your cart is empty. Continue Shopping!
Processing order...