HSDAE

Pivot Table is designed to work with only one single source of data. If you have multiple sources of data with the same columns, you have to stack them manually to analyze all of them together. But if you use this Power Query function, you will not have to do the stacking. And it is […]

The normal Pivot Table COUNT function counts each row as one count. It does not have a unique or distinct COUNT function to help count repeated descriptions as one, e.g. no of customers. You need to turn this switch on to get the DISTINCT count to work for you in Pivot Table.

You can filter 2 or more Pivot Tables and Charts with one slicer. This newly added function allows you to create a Powerful and Interactive Dashboard without any macros and new software.

In the past, your Pivot Table is designed to present all your data from the earliest date to the latest date. Unless you delete the raw data, it is not easy to limit the report between 2 periods. But with Timeline, your Pivot Table report can now show the desired period for presentation. You don’t

With Slicer, you can create professional-looking buttons that help to filter your Pivot Table report easily. You can also visually see which are the filter being applied to your Pivot Table. It is a better option than seeing multiple selections in the dropdown list.

When you refresh the Pivot Table, the columns are likely to shift due to the difference in length for the description. This is likely to throw your audiences’ focus off the report. Find out how to disable autofit columns to give your audiences an undistracted experience in reading your report.

It might seem trivial but getting this wrong may send the wrong message to the reader. Find out the difference and avoid making this mistake.

This is a useful chart that I tried to avoid last time, because it is very tedious to create. But the new version of Excel has simplified the creation of this waterfall chart. It is now so simple that I would want to make full of it to impress my bosses.

Most Pivot Table users only learn how to create a basic Pivot Table. What they have missed out on are new features that will save them even more time in creating their Pivot Table reports. In this module, you will discover these upgrade functions and work towards a more productive workday using Pivot Table.

When you don’t know any worksheet functions or your formula becomes too complicated, this is the function you need to master. I believe this is created with AI technology. Even if the output is not perfect, you would have saved 80-90% of your time “massaging” your data.