|In the previous article we saw the problem with importing CSV files.
Here is how the new Power Query can be used to clean the data while importing.
|We continue to explore Pivot Table Grouping. This time we work with dates.If you do this manually, the method shown here is like a miracle for you.
Estimated reading time 10 min
|We explore a very powerful and extremely useful approach to bin analysis using VLOOKUP.Estimated reading time 10 min
Estimated time saving many hours (if you were doing this manually)
|Let us explore numeric grouping in Pivot Table with the Ageing Analysis scenario.Estimated reading time 7 min
Estimated time saving – hours!