ProfessionalExcel.com In the office, Excel is a way of life… not just a tool

About

I created ProfessionalExcel.com in 2009 with the intention of publishing a few tools that I develop along the way, and also to give tips to help the Excel community. In June 2011 I finally got round to migrating the site to WordPress so that I could convert the site into a Blog, which will allow me to add content quickly and much more regularly.

My career to date has involved roles in both transport asset management and financial derivatives sectors. I have been developing Excel applications and tools (ranging from complex analytical spreadsheets, up to standalone Excel applications and add-ins) for a number of years. Along the way I've picked up bits a pieces that should be useful to Excel novices up to budding Excel developers.

Many people underestimate the power of Excel and it's ability to provide rapid, reliable and highly automated applications. In a world that has always focused on the old time adage "Time is money", automating a process ultimately saves money.

However, Excel application development is not just about automating processes; It's about gathering, processing and displaying data in the most efficient and effective way. I enjoy the challenge of presenting data in a visually pleasing user interface that is intuitive and that meets the objective of the analysis.

Here's some of the expertise I've picked up over the years...