What is an Excel table? An Excel Table is not just any range of data with headings, but a specific Excel object that unlocks additional properties. […]
When trying to sum values with conditions, SUMIFS has always been our go-to function. However, when there are too many conditions, going on adding criteria, selecting […]
POWER BI which includes Power Query, PowerPivot and Power View solves all the problem. This can be used to systematically transform and consolidate financial […]
This video shows the amazing uses of CTRL+Shift shortcuts which reduces a great amount of time and improves speed. Now change numbers to other formats with […]