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
Common requirement. With raw data and Pivot Tables. View or Filter. Here is how…
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.
Readable formulas in Excel tables are so nice, you will curse yourself for not noticing earlier (since 8 years!). Teach this to everyone around you – NOW! Show off
Yes. It is not only formulas which get copied when you extend a table. Everything gets copied. Read on to find out about Automatic copying and how much time you
Simple one. But deserves a separate article so that the world takes notice!
Most probably, you have been missing this Auto-copy feature for the last 8 years. Take 3 minutes to find out how it can simplify your life and increase accuracy.
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.
