Count Specific Weekday or Weekdays within Data range containing Dates
Often we have to deal with dates as they form integral part of almost every data set. But what if you want to count specific weekdays within a large range of dates? This is...
Multi level or Multi column sort in Excel – How To
Before in Excel tips we learnt about Custom Lists feature in Excel and how to use it to sort and have custom autofill series. In our example we sorted the sales data using our...
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....
Making Aging Analysis Reports Using Excel – How To
Aging analysis is helping accountants since ages and is one of those reports that are prepared mostly in Excel to track both receivables and payables. So today we are learning how to conduct aging...
Calculate number of Workdays in Excel using formula
Few days back I scribbled about calculating days between two dates and there I discussed DAYS360 formula method and one other common sense method to find out the number of days between two dates....
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...
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...
Conditional Charts in Excel – Workaround + How To
Last time we learnt how to make simple dial charts. There is so much to be discussed as basics to Excel charting but without little fun and doing out of ordinary is what everyone...
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...
Excel Tutorial – Ctrl P is Power in Control (Printing)
Yeah I know even a child with rock bottom skills know how to print. But Excel's print is not just a Ctrl + P. Its this and much more. One of the nuisance often...