20+ Excel Table tricks to turbo charge your data
In my last article on tables Introduction to Excel Tables - Data beyond just formatting I discussed the basics. If you are new to excel or if you think that tables are meant for just...
Running totals and Running balance in Excel – How to
On daily basis accountants prepare day books and ledgers as regular part of accounting cycle. Usually students in the beginning learn to prepare accounts in T format. However, professional accountants maintain accounting books in...
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 that it will be code that you just get have...
Calculating number of days between two dates – Excel Function Vs Common Sense
Business and every aspect of our life is about time and we have to compute days most often. To handle this Excel does provide a solution for in shape of a dedicated formula DAYS360()....
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...
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...
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...
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...
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...
One minute Excel Tutorial – Remove Duplicates
Data entry is a cumbersome job and often key punch operator ends up recording the same data again. Or if the data has been collected at different sources and on consolidation many similar instances...