fbpx
Search
Close this search box.

All articles with 'Pivot Table' Tag

How to make a pivot table when you have data in multiple sheets [Tutorial]

Published on Sep 26, 2023 in Learn Excel, Pivot Tables & Charts, Power Query
How to make a pivot table when you have data in multiple sheets [Tutorial]

Recently I had to create a Pivot report from monthly data. But there is a twist. The data is spread across multiple sheets, one for each month. Let me explain how I built the pivot for that scenario.

Continue »

Selective Sub-totals in Pivot Tables [Quick Tip]

Published on May 2, 2017 in Excel Howtos, Pivot Tables & Charts
Selective Sub-totals in Pivot Tables [Quick Tip]

Recently I was creating a pivot report with multiple items in row labels area. I had to show sub-totals, but only for one of the fields. Something like above.

How to show selective sub-totals in Pivot Tables

Continue »

Apply Conditional Formatting using Slicers

Apply Conditional Formatting using Slicers

Have you ever wondered about applying different Spreadsheet Formats or Styles to reports which you may be send to different people and so the styling may be different for each recipient?

I haven’t, but in this post I will show how you can add it to your worksheets.

Continue »