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 instead of copying and pasting the same data on different...
Make Budgets in Excel with Expenditure Limit – Budget Ceiling using Data Validation ...
Budgets help control the expenditures even before they actually incur. The concept of budget is to provide a ceiling or cap to expenditures so that departments or cost centers don't exceed a certain limit.
If...
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...
Adding specific Prefix to All cells or Specific cells in Excel – 3 Methods...
A dear friend of mine contacted me early in the morning and the length of his message was evident that he has tried his best to get his head round the problem but in...
Excel Pivot Tables – Grouping Dates by Week Within Months, Quarters or Years –...
Earlier we learned about grouping and ungrouping time related information very easily using excel pivot tables. It saves huge amount of time in preparing summary pivot table reports with different dimensions of time.
However, we...
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...
Create Project Timeline Charts in Excel – [How To] + Free Template
Today we are learning how to create project timelines or project timeline charts in Excel. One can say that timeline charts are simpler versions of gantt chart as they usually don't involve activity's stage...
Dynamic Financial Scenario Analysis using Excel
No denying that Excel is one of the best things happened to financial analysis world. Excel makes financial modeling and reports for decision making possible in all sorts of way. Excel is as able...
Calculating Depreciation of assets in Excel – How to
In accounting world depreciation is one key calculation to be done for every period to make the reports and is also an important part of financial management decision making process in some cases. However,...
Break-even + Target profit analysis with Excel Goal Seek – How To
Break-even point is simply the point of activity where entity is making no profit or loss. Therefore, break-even analysis in simple words help determine that what value of certain variable (or variables) under given...