Category: Excel

Data Woes

Every business transaction creates data.  Ensuring easy and efficient transaction entry is on the top of everyone’s list when evaluating a new financial system.  However, information must not only get into a system it must get out again.  The main methods of retrieving data are canned reports, and dumping data into Excel for ad hoc analysis. The Dangers

Read More

Spreadsheet Best Practices

Many of us have worked with Excel spreadsheets for years and consider ourselves to be pretty good at them.  Then I ran across the website Best Practices Modeling website.  I learned a lot and I’ve been converting some of my more complicated models into the Best Practices system. My main takeaways are: Use separate, differently

Read More