Replace a formula with the value or final result – Super Easily
Formula and Excel is a bond not meant to break. Although formula do help us get the values we want. But often you find...
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...
How to change currency format in Excel? How to have Pakistani Rupees (Rs) currency...
In almost every office of the world when it comes to money accountants come to excel. Although excel can handle money matters but when...
Excel Most Wanted – Selection shortcut keys Mega collection
While working in Excel or any data related job selection is one job in itself. And even in Excel it is not easy when you making...
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...
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...
How to show 0 (digit) as text ZERO or Nil or anything in Excel
https://www.youtube.com/watch?v=75cCLEoKzSU
Excel is about measuring and calculating but it is not only just numbers it can also help you make the information more understandable and...
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...
Resume excel session with Save workspaces feature
In accounting world some work is repetitive and accountants have to open certain set of files almost on daily basis. Opening each file by...
Entering data on multiple Excel worksheets in one go
If you have several excel sheets to work on and all the sheets share exactly the same data with exactly the same format. Than...