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
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
Grouping is turning out to be a loooong series! But this looks like the last article in the series. How to handle date time grouping using Pivot Table. Summarize without
We continue to explore Pivot Table Grouping. This time we work with grouping dates. If you do this manually, the method shown here is like a miracle for you. Estimated
We explore a very powerful and extremely useful approach to bin analysis using VLOOKUP. Estimated reading time 10 minEstimated time saving many hours (if you were doing this manually)This is
In the last article we saw how to use Calculated Fields. Now we will explore Calculated Items. Most people have never noticed them for 20 years. But WOW!! What a
Before you perform manual calculation, learn this option. This can save you hours of manual work. Estimated reading time 10 min
This article shows more details of publishing Excel reports from Excel to SharePoint. Frequently asked questions are also answered. Please read Part 1 and Part 2 of this article series
In this article we will learn the actual steps of delivering Excel reports: Create a report in Excel, Publish it in SharePoint and Share it with others. Please read the
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.
