New way of filtering reports – Slicers!

image All of us use the Filter area in Pivot Tables.Do you know there is a more powerful way available since 5 years?

Learn it and use it.

Estimated reading time 10 min

Continue reading

Posted in Analytics, BI, Excel, Pivot Tables | Tagged , , , , | Leave a comment

Knowledge Pack – Grouping Data (Text, Numbers and Dates)

image Analytics is all about summarizing and grouping.Numbers are grouped into bins, text is categorized and dates are compressed into months, quarters and years.This series covers various quick and powerful methods to perform sophisticated grouping in seconds.

Estimated reading time 10 min

Continue reading

Posted in Analytics, BI, Big data, Excel, Pivot Tables, VLOOKUP | Tagged , , , , , , | Leave a comment

How to open files quickly – Part 2

image Yes. We don’t know how to open files! This is the second part.Read the first part first.

Estimated reading time 4 min

Continue reading

Posted in Efficiency, Office, Office 365 | Tagged , , , | 2 Comments

How to record demos and presentations as videos without using a video camera

image Creating software demo videos is easy. It is called a screencast.

Good quality training material using this method.

Video camera is NOT needed.

Here is how I do it.

Estimated reading time 10 min

Continue reading

Posted in Video | Tagged , , | Leave a comment

Have you noticed Recent File List (MRU) options?

image This list shows few recently opened documents. But if you right click there, many more useful things are available…It is also a good example of how we can discover our needs from available features.Read on and get amazed!

Estimated reading time 7 min

Continue reading

Posted in Efficiency, Office, Office 365 | Tagged , , | 2 Comments

How not to alter sample files used in Demos

image If you use sample files and deliver demos or training sessions, this article is for you.

Often we open the demo file and it is saved with changes. This article shows you how to NEVER let that happen.

Estimated reading time 3 min

Continue reading

Posted in Office | Tagged | 1 Comment

Grouping with Date – Time Data using Pivot

image Grouping is turning out to be a loooong series!But this looks like the last article in the series. How to handle the TIME portion of dates.Summarize without time. Or summarize by components of time.

Estimated reading time 12 min
Potential Time Saving enormous

Continue reading

Posted in Analytics, BI, Excel, Pivot Tables | Tagged , , , , , | 8 Comments