Excel ALTernate ‘Powercut’ – One key to rule ALL shortcut keys
Ranking up in Excel world is not easy but definitely there are steps you can take to become an Excel head and one of such steps is to remember shortcuts. Well you have no...
Making Aging Analysis Reports using Excel Pivot Tables – How To
Last time when I discussed preparing aging analysis in Excel, I used formula approach to do it. I used the combination of IF and TODAY functions and then used conditional formatting and sparklines to...
Variance Analysis in Excel – Making better Budget Vs Actual charts
Either it is about daily life or business, we almost all the time in our minds comparing the actual results with our plans. Though we can talk numbers and percentages but the way charts...
40+ Excel navigational shortcuts to make accounting job super efficient
With the advent of user interface we are able to use mouse and other input devices. But when it comes to speed, efficiency and productivity keyboard is still EXCELlent above anything else i.e. K...
Payroll calculator with Piece Work wage payments in Excel – How to Series
In every organization small or big we have to process salaries and wages also known as payroll. And this process is carried out sometimes on monthly basis or weekly and sometimes on daily basis...
How to Highlight Blank Cells in Excel using Conditional Formatting [Quick Tip]
With huge data pinpointing blank cells is near to impossible. Sometimes back we learnt how to fill blank cells with zero using Go-To special feature in Excel. But what if we only want to...
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....
Payroll calculation in Excel – Straight Piecework Wage System – How To
This Excel tutorial is part of:
Payroll calculator with Piece Work wage payments in Excel - How to Series
To access complete list of payroll calculation tutorials for piece work wage system visit this page.
Straight Piecework Wage...
Payroll calculation in Excel – Piecework with Guaranteed wage – 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.
Payroll calculations under...
10+ ways to SUM Top N values in Excel data range – Ready to...
We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel newbie to pro everyone uses SUM formula. We have recently...