Let us welcome the new year 2021 by learning some new Excel functions. I am conducting this live event on Saturday, 16th Jan at 3 PM India time (UTC +5.30).
Excel VLOOKUP is a very common and popular function. It is now superseded with the XLOOKUP function. Still it’s popularity is not going down. This video (in English and Hindi)
You must read this article first: Grouping Text in Pivot Tables. This article explains how to combine multiple text items into a single group. This is used for classifying or
Now it is time to spell out exactly what to look for when creating good raw data (or repairing bad input data). Use this as a checklist to quickly classify
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
Date grouping using custom quarters or periods can be done using VLOOKUP. This is a very powerful and quick method for creating reports. Estimated reading time 7 min Potential time
Grouping in Pivot table is one method of spelling mistakes correction. Here is another option for correcting mistakes using VLOOKUP. Estimated reading time 10 min Estimated Time Saving many hours!
The problem Have you ever tried any of these? Calling an airline to change the booking Calling a helpdesk for some troubleshooting Calling your bank for some transaction (or similar
This time I wanted to try a new style of writing. I created a presentation instead of the usual document like style. Download presentation and view Download the presentation (300kb)
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.
