62 results for: pivot table

You Won’t Believe These Excel PIVOT TABLE Tips!

Discover 10 pro hacks that will make creating pivot tables easier. Learn how to customize layouts, create dynamic reports, conduct in-depth analysis.

How to Properly Handle Dates in Excel Pivot Tables

Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

How to Create a Pivot Table from Multiple Sheets in Excel

Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to “merge” the data and sometimes you have to “append” data from multiple sheets for your Pivot Table. Don’t use formulas! Instead use this method.

Excel Advanced Pivot Table Techniques for Serious Data Analysts

These 10 advanced Excel Pivot Table tips are going to help you analyze your data faster. PivotTables are one of Excel’s most important tools. Not everyone knows these Pivot Table tricks though. Make sure you do!

How to Create a Pivot Table Based on Multiple Sheets and Tables

This is a simple but advanced Pivot Table technique in Excel. If you’d like to create a Pivot Table based on multiple sheets or tables, you can easily do that by defining the relationship between the tables from the data tab. It just takes one click.

How to Combine Multiple Sheets Into One Pivot Table

Can you easily combine & clean data from multiple Excel sheets into a single table or Pivot Table? You can easily get this done in Excel with Get & Transform (aka Power Query). Check out the full post.

How to Create a Pivot Table in Excel

Learn how to use Excel Pivot Tables to quickly summarize your data and create meaningful reports. In 10 minutes, we cover everything you need to know about Pivot Tables.

Power Pivot, Data Modelling, DAX Course Cover

Master Excel Power Pivot & DAX (Beginner to Pro)

Transforming data into meaningful reports can feel like being in an Olympic event. It is hard!
Join the course and learn how to use Excel’s Power Pivot and Data Modelling tools to make reporting easy and fast.

3 Hidden Tips for Excel Power Pivot

These 3 hidden Excel Power Pivot tips will help you to: Copy your data model from one file to another, create a dedicated measures table and convert your pivot table data to formulas.

How to Transpose Multiple Header Rows to Columns in Excel – Advanced Unpivot Techniques

You can easily use Excel Power Query to transpose a data-set with multiple row headers from multiple columns to rows. Find out how in this quick tutorial.

Excel – Use Symbols in Pivot Slicers

Learn how you can use symbols instead of text in your Pivot slicers to create visually effective Excel dashboard reports.

Excel Pivot Chart with Slicers

In this tutorial you’ll find out to how to use Pivot Slicers in Excel and create Slicers for months based on dates. You’ll also learn how to create a dynamic Pivot Chart controlled by the slicer.

Free Guide!

The ONE Critical Excel Skill You Need

This free Excel guide will help you to:

  • Pinpoint the Excel skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill