The Ultimate 2022 Pivot Tables & Dashboard in Excel Bundle for $19

The Ultimate 2022 Pivot Tables & Dashboard in Excel Bundle for $19
Check Out Now
Expires October 27, 2121 23:59 PST
Buy now and get 91% off

Pivot Tables for Beginners


KEY FEATURES

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.

PRODUCT 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

THE EXPERT

StreamSkill.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.

Advanced PivotTables


KEY FEATURES

In this Advanced PivotTables in Excel course, you'll learn how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. You'll get a PivotTable refresher and move on to some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting. This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function.

4.7/5 Instructor Rating: ★ ★ ★ ★
  • Access 48 lectures & 7.5 hours of content 24/7
  • Do a PivotTable (a quick refresher)
  • Combine data from multiple worksheets for a PivotTable
  • Group, ungroup & deal with errors
  • Format a PivotTable, including adjusting styles
  • Use the Value Field Settings
  • Learn Advanced Sorting & Filtering in PivotTables
  • Use Slicers, Timelines on multiple tables
  • Create a Calculated Field
  • Learn all about GETPIVOTDATA
  • Create a Pivot Chart & add sparklines and slicers
  • Use 3D Maps from a PivotTable
  • Update your data in a PivotTable & Pivot Chart
  • Learn all about Conditional Formatting in a PivotTable
  • Create a basic macro to refresh PivotTable data
Note: Software NOT included.

PRODUCT 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: advanced
  • Have questions on how digital purchases work? Learn more here

Requirements

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

THE EXPERT

StreamSkill.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.

Dashboards in Excel


KEY FEATURES

A dashboard is a great way to visualize your data. An interactive dashboard allows you to change what results you see at the click of a button. This in-depth course will prepare your data for analysis, some essential formulas you’ll need to help you create dashboards in Excel, Pivot Tables, Pivot Charts, Form Controls and so much more. It takes you through how to combine all those skills to create a Sales Dashboard and an HR Dashboard in two, end of course projects. If you need to analyze and present data in Excel, then this course will show you step-by-step how to create jaw-dropping Excel dashboards that leave people wondering how you became that good in Excel!

4.6/5 average rating: ★ ★ ★ ★
  • Access 77 lectures & 9.5 hours of content 24/7
  • Learn about Dashboard architecture & inspiration
  • Prepare data for analysis (cleaning data)
  • Learn useful formulas for creating dashboards in Excel
  • Create & edit Pivot Tables in Excel
  • Create Pivot Charts from Pivot Tables
  • Learn advanced chart techniques in Excel
  • Add interactive elements (form controls) into your dashboards
  • Create a Sales Dashboard from scratch
  • Create an HR Dashboard from scratch
Note: Software NOT included.

PRODUCT 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: advanced
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel

THE EXPERT

StreamSkill.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.



Check Out Now

Post a Comment

0 Comments