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...
One minute Excel Tutorial – Watch Window
Accountants and analysts around the world does one amazing job and that is they give the meaning to mammoth data by processing it using...
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...
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...
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...
Building a reference to specific Worksheet based on Cell value using Formula
Most of the time businesses are managed using specialized software but when it comes to a final touch in reporting the data is exported...
Using SUMIF function with Dates in Excel
I was in the middle of making an accounting project where I had to use SUMIF. This wonderful function that everyone must know especially...
ACCA Online Classes December 2013 Announcement and Quick Excel Tip on Duplicating Excel Worksheets
This time around the post is a mix plate. Some of you were worried that how come key strokes are silent on Excel for...
Inserting symbols in Excel using text input
Sometimes our information is incomplete without the use of symbols. Inserting symbols that are accessible on keyboard are easy to punch in however, it...
Dynamic Financial Scenario Analysis using Excel
No denying that Excel is one of the best things happened to financial analysis world. Excel makes financial modeling and reports for decision making...