Author Archives: admin

From 6 Hours to 6 Seconds

A perfect example of what can be accomplished with Excel was a monthly “Work center Hours by Division” report I had to complete. I downloaded data from our ERP system into Excel and then had to create totals by division … Continue reading

Posted in Uncategorized | Leave a comment

Fix a slow loading/saving Excel spreadsheet

Here is a trick that may solve the issue of an excel file that opens very slowly, or one that takes forever to save it. Obviously if the file has a tremendous amount of data it will open more slowly … Continue reading

Posted in Uncategorized | Leave a comment

I can improve your productivity

Some of the ways I can help improve your productivity & profits include: Automation of Existing Reports – Do you have a report that you spend hours and hours on every month? A report that takes your hours to complete … Continue reading

Posted in Uncategorized | Leave a comment

Car Loan Calculator

This free Microsoft Excel spreadsheet will calculate your car loan payment. This is a great tool to have for any car shopper. Never trust the dealer’s calculations! Download the Car Loan Calculator     

Posted in Uncategorized | Leave a comment

Blog

The IdeasThatExcel blog will provide you with Tips & hints for Excel.  I will also post updates for projects that I have made available or information about upcoming projects. Be sure to check in often.

Posted in Uncategorized | Leave a comment