Unknown Gems: Explode Pivot Table by each filter item
Suppose you have Products in Filter area and Pivot Table shows Regional Sales by Month. There are 5 products. You want five sheets for each product separately- this is called
Suppose you have Products in Filter area and Pivot Table shows Regional Sales by Month. There are 5 products. You want five sheets for each product separately- this is called
Usually we select ENTIRE column rather than the data column. That leads to many side effects including applying unnecessary formatting to millions of rows or thousands of columns. Tables make
Often we need to poll the audience during a presentation, lecture or workshop. Usually we manage by asking the audience to raise hands. It is at best approximate. A more
Every menu item has a keyboard shortcut. You don’t even have to remember it. Just press and release ALT key and it is visible. Type what you see. No need
Common requirement. With raw data and Pivot Tables. View or Filter. Here is how…
Yes. This LONG “short”cut actually works. Try it. In fact, just press Alt and choose the highlighted buttons in the Ribbon. All of them work. Just press and release Alt
Finally, here is a proven set of best practices to make your Excel usage simpler, faster and more accurate. Photo credit: Maurizio Mori / Foter / CC BY-NC
MOST IMPORTANT BENEFIT of Excel Tables. Spend 10 minutes. Read it.
Like column names, table names can also be used in formulas. Read the previous article to understand the context.
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
