Quickly fill Blank cells with the Value in the Cell Above
There are situations when you ask someone to punch data for you and they come up with one lazy idea to leave the cell blank if the same value is repeating in subsequent cells...
Dynamic Common Size and DuPont Analysis Financial Statements in Excel
What if you have to make few analysis together in Excel like common-size analysis, ratio analysis and duPont analysis, well this is what I did this weekend. And the best part is that it...
Hiding Gridlines in Excel – Learn the Right Ways
One of our facebook community member consulted for Excel help and sent me a sample file. In that I noticed in order to hide gridlines, that are visible by default, were "forced" to disappear...
FIFO Inventory Valuation in Excel using Data Tables – How To
Inventory can be valued in number of ways, FIFO, LIFO and AVCO being the most famous. To learn few more inventory valuation methods have a quick look at this: What are different inventory valuation methods?
Entities purchase...
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...
Remove leading Apostrophe (‘) in Excel Data from Numbers and Text – How To
This question is asked by one of the member at our facebook community. He was stuck in common problem. Leading apostrophes. This is often the case if data is extracted from a famous business...
Dealing with Telephone numbers in Excel – Dialing in the correct format
Many have the impression that Excel is a tool to do maths. But the ones who are using it on daily basis know that Excel is way beyond just calculation and helps you maintain...
Custom Autofill series and Custom sorting with Custom lists in Excel
If you are already using some of Excel's custom features then you probably are already in love with them. Few days back we discussed custom views option and how it can help us. Today...
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 user friendly. In calculations we often get a result 0...
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...