Using Touch is confusing? Solution: See the Touch!

image This article applies only to Windows touch devices.We often get confused while using Touch to perform actions on the screen.Sometimes the touch gestures don’t work as expected.Windows has a brilliant feature to help you.Estimated reading time 10 min.

Continue reading

Posted in Demo, Surface Pro | Tagged , , , | Leave a comment

Knowledge Pack: Data Analytics

image Data Analysis and Reports has been a major theme for my articles so far. 

Here is a collection of 51 articles, categorized and sorted in the recommended reading order.

 

Enjoy!

Continue reading

Posted in Analysis, Analytics, BI, Big data, Excel, Knowledge Pack, Pivot Tables | Tagged , , , , , , , | Leave a comment

Custom sorting in Pivot Table using Custom Lists

image This feature has been around for two decades.
It is high time you know it!

Decide the sort order once and use it lifelong.

 

Estimated reading time 10 min

Continue reading

Posted in Efficiency, Excel | Tagged , , , | Leave a comment

New way of filtering reports: Slicers – Part 2 (Filtering Filters)

image Please read the previous article first.Filters are not just for filtering. They also convey additional information.Very useful feature. Check this out.

Estimated reading time 10 min

Continue reading

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

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 , , , , | 1 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 , , , , , , | 1 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