October 7, 2021
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. […]
April 19, 2021
If we want to delete alternate rows from a data set, then the following steps can be performed to make our task easier instead of deleting […]
November 19, 2019
While MS Excel can be a great tool to automate your work, save loads of time and make your work flexible, there are certain things that […]
November 5, 2019
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 […]
October 23, 2019
The Spike is a Microsoft Word function which allows you to remove two or more items (such as text or graphics) from non-adjacent locations in a […]
October 4, 2019
Flash fill is an awesome tool which magically fills data once it identifies a pattern. The tool justifies its name by executing a task that would […]
October 2, 2019
You think you know MS Word? Annoyed with formatting issues? MS Word can be an annoyance but a lot can be accomplished when used to its […]
June 17, 2019
POWER BI which includes Power Query, PowerPivot and Power View solves all the problem. This can be used to systematically transform and consolidate financial […]
November 28, 2018
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 […]
June 17, 2019
POWER BI which includes Power Query, PowerPivot and Power View solves all the problem. This can be used to systematically transform and consolidate financial […]
November 28, 2018
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 […]