I decided to start Ideas That Excel after working many years for small to mid-sized companies in the account and finance area. Over the years as I became more and more familiar with Excel and was always the company “Excel Guru”. I have worked with Excel for over 20 years.
I hope to provide you ideas and solutions to help you accomplish more through the use of Microsoft Excel.
Discovering how to Automate Excel…
At some point I learned that you could create Excel Macros where Excel would repeat your keystrokes. This was a great help at the time because I had a few reports that I had to complete each month that required a lot of “Find and Replace” of the data exported from our ERP system. This saved me quite a bit of time I knew there has to be a better way.
One day I was in in a bookstore (around 1998) and I happen to see some books about Excel. One book was called Excel VBA Programming For Dummies. As I flipped though the book, I learned that Excel Macros can be much more than just repeating key strokes but that in Excel you can actually create programs using a programming language called Visual Basic for Applications (VBA).
I began my career out of college as a Cost & Accounting Analyst. A few years later I was promoted to controller. I have since worked as a controller in a few different companies located in northeast Ohio.
Bachelor of Science in Accounting – University of Akron
Bachelor of Science in Finance- University of Akron
Institute of Management Accountants – Successfully passed all parts of the Certified Management Accounts (CMA) exam on my first attempt.