Free Excel Webinar Recording – What If Techniques

Post author:Neale Blackwood
Post published:28/09/2018
Post category:Data Tips & Tricks Videos
Post comments:0 Comments

My free Excel webinar for September 2018 covered What If Techniques. Download the materials using the button below and watch the video. CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. Download Webinar Materials https://vimeo.com/291843750 Content applies to Excel 2010 and later versions. You will need to install the Solver Add-in - instructions in the manual and video.…

Creating a Timeline Chart in Excel 2016

Post author:Neale Blackwood
Post published:25/09/2018
Post category:Charts Excel 2016 Excel Blog
Post comments:0 Comments

Timeline charts are an effective way to display events over time. You can use a new Excel 2016 feature to easily create a timeline chart. (more…)

Auto Format Formulas in Excel

Post author:Neale Blackwood
Post published:18/09/2018
Post category:Excel 2013 Excel 2016 Excel Blog
Post comments:0 Comments

Would you like to change the format of all your formula cells so they have a different fill colour or font? There is a way in Excel 2013 onwards.

(more…)

Horizontal or Vertical Progress Bar in Excel

Post author:Neale Blackwood
Post published:11/09/2018
Post category:Charts Excel Blog Tips & Tricks
Post comments:2 Comments

In a recent webinar on conditional formatting I was demonstrating how to create a horizontal progress bar using conditional formats when someone asked an interesting question about creating a vertical progress bar. It is possible and in this blog post I will explain both techniques.

(more…)

Range Names and Macros

Post author:Neale Blackwood
Post published:04/09/2018
Post category:Excel Blog Macros
Post comments:0 Comments

When you record a macro that refers to a particular cell or range on a particular sheet in Excel the range reference is hard coded into VBA (macro) code. Unfortunately this means if rows or columns are inserted or deleted in the reference range the code is not updated. There is an easy way to get around this.

(more…)