Risk Mitigation in Microsoft Excel
This article is for CFOs, CEOs and other members of Senior Leadership Team. It requires just 10 minutes to read. But it will reduce your personal as well as organizational
This article is for CFOs, CEOs and other members of Senior Leadership Team. It requires just 10 minutes to read. But it will reduce your personal as well as organizational
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. Estimated reading
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
Let us explore numeric grouping in Pivot Table with the Ageing Analysis scenario. Estimated reading time 7 min Estimated time saving – hours!