My Top 10 personal favourite Excel keyboard shortcuts
Everybody has preferences and likeness towards Excel keyboard shortcuts and I am no exception. So here is my personal top 10 list of Excel keyboard shortcuts that help me immensely when going through my...
Multiple Column Data Validation Lists in Excel – How To
Today we are learning how to make dynamic multi columnar data validation lists in Excel that helps display much more data in the drop down list and are far superior and flexible than usual...
Conditional COUNT in Excel: Count cells meeting multiple criteria + Data Cleanup Tip
We have been provided with a top secret data of one lab situated at the very center of the earth. A team of vigilant individuals take readings of different parameters to monitor the temperature...
Instantly Paste list of Defined Named Ranges in Excel workbook – Quick Tip
Excel's "Named ranges" feature is love at first sight! And whoever knows how they work would agree and must be loving them every bit. And the case with us humans is that whatever we...
Making dynamic Chart of Accounts, Journal + Ledgers in Excel – How To
Excel is one of the favourite tools for accountants and for everyone else who has anything to do with accounting information. It is a tool of choice when it comes to data extraction and...
Calculate Moving Average in Excel – How To
One of the ways to predict future is by observing where past is leaning. Trend analysis helps in forecasting the future based on past data. However, such data has the effects of different types...