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....
Understanding Custom Views in Excel
Excel is all about flexibility. With all the built in features there is just endless possibilities the way you can use this marvelous application software. But Excel extends the flexibility even further through custom...
Running Totals and Running Balance with Excel Pivot Tables – How To
Last time when I discussed how to do running totals and running balance using Excel many different ways were discussed but one was left for today which is doing running totals and running balance...
Conditional SUM with Excel SUMPRODUCT function – Intro + Examples
One of our dear member at our Excel facebook page Mr. Zeeshan Sarwar shared a problem in which he wanted to sum only those invoices amounts against which "paid on" date is mentioned.
Putting it...
Preparing Fixed Asset (CapEx) forecast model in Excel – Depreciation & NBV Calculations
In any financial model (forecasts or variance analysis) the idea is to derive expectations where business will end up if particular set of assumptions (scenario) prevails. These are basically calculations that help the decision...
Excel Pivot Tables – Grouping Data by Date and Time
Where reporting is about numbers and analysis, the big part of it is also about time. And to best understand the situation you sometime have to want information specific to certain time period or grouped for...
Variance Analysis in Excel – Making better Budget Vs Actual charts
Either it is about daily life or business, we almost all the time in our minds comparing the actual results with our plans. Though we can talk numbers and percentages but the way charts...
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...