Three Most Common Reasons for Restating Financial Statements I just finished reading an interesting article in the Wall Street Journal on financial reporting. Did you… Read More »3 Most Common Financial Reporting Errors
Gantt Chart using Excel A Gantt Chart is used in project scheduling. It takes each activity and provides a sideways bar to visually show when… Read More »Gantt Chart for Project Scheduling in Excel
FLASH FILL FEATURE Excel 2013 has a cool feature that will save a lot of time for those of you that are always using Text… Read More »Flash Fill – Leaves Text Functions in the Dust!
Computing the Periodic Payment for a Loan Excel Financial Function Computing the periodic payment is probably the most used Excel financial function simply because it… Read More »Computing a Loan Payment & Creating an Amortization Schedule
Using the Altman Z Score to Predict Bankruptcy – Guest Post by Joe Helstrom, CPA Background: The Altman Z score for bankruptcy… Read More »Using the Altman Z Score to Predict Bankruptcy
This is just a quick tip as Excel is not necessarily that date friendly. If you want to calculate an invoice date or a project… Read More »Using Workday to Calculate Invoice Dates
The IRS has revamped the tangible property regulations for the 2014 tax year. The new procedure allows small businesses to change a method of accounting… Read More »Repair Regulation Relief – Relief or Stomach Ache?
If you are setting up a spreadsheet for someone else to enter data this is a neat trick. You can use the Data Validation and… Read More »Preventing Duplicate Entries using Data Validation in Excel