Excel Drop Down List using Data Validation and Excel Tables that updates dynamically –...
Excel drop down lists are one easy way to keep your data error free and other benefit it is that it automates data entry to some extent. Data validation help us make such drop down lists easily.
For...
Excel Custom Shortcuts – Reaping real benefits of Quick Access Toolbar
Many excel beginners especially those who are using version 2007 and later a small bar which is by default placed above ribbon alongside the title bar and many recognize it for its UNDO button....
Formatting Numbers in Excel – Conditional Formatting Vs Custom Number Formatting
Accountants are always dealing with numbers. And its not always about highlighting positives. In some cases we have to make negative numbers standout and having a negative sign is just not enough. Similarly to...
Adding specific Prefix to All cells or Specific cells in Excel – 3 Methods...
A dear friend of mine contacted me early in the morning and the length of his message was evident that he has tried his best to get his head round the problem but in...
Multi level or Multi column sort in Excel – How To
Before in Excel tips we learnt about Custom Lists feature in Excel and how to use it to sort and have custom autofill series. In our example we sorted the sales data using our...
Payroll Calculation in Excel – Differential Piecework with Multiple Scales – How To
This Excel tutorial is part of:
Payroll calculator with Piece Work wage payments in Excel - How to
To access complete list of payroll calculation tutorials for piece work wage system visit this page.
Differential piece work...
Excel Pivot Table Slicers: Old Filters got Overhauled!
First things first, this post is strictly for those who have Excel 2010 or later installed. But is this a warning not to read this post if you have older versions? NO! The intention...
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...
Automating Data Entry using Data Validation in Excel
This is mainly a data entry tutorial and can be used in other scenarios as well. But as sales and price data is easily understood so I am using the same. Let me know...
Preparing Fixed Asset (CapEx) forecast model in Excel – Depreciation & NBV Calculations
In any financial model (forecasts or variance analysis) the idea is to derive expectations where business will end up if particular set of assumptions (scenario) prevails. These are basically calculations that help the decision...