Excel Climate Change Infographic

There is a stack of information online about climate change.  Excel is a wonderful tool to display and change this sort of data.  I have made an infographic based on our changing climate with statistics from the web showing the current state of affairs, all things climate change.  This Excel inforgraphic displays people's views on climate change and the glaring reality which we face as a result of our actions.  Who would have thought that digging up or siphoning lots of carbon and releasing it back into the atmosphere would not have an affect on our planet's weather.

Read More

Excel VBA Autofilter on Multiple Criteria

Anyone who has followed my posts on Ozgrid or Chandoo forum will have noticed how frequently I use the autofilter in favour of any kind of loop.  I have been lead to believe that in some instances that arrays will perform faster than the humble autofilter however for brevity of code and swiftness I really like the simple elegance of the autofilter.  In the article Autofilter on Multiple Conditions I delved into the world of the filer using more than one criteria.

Read More