Free Webinar Recording – Excel Formatting Tips

Post author:Neale Blackwood
Post published:15/10/2019
Post category:Functions Tips & Tricks Videos
Post comments:0 Comments

In October 2019 I re-ran my Formatting Tips session. The detailed pdf manual and example file can downloaded by using the button below. Content listed below the video. Download Materials 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. https://vimeo.com/366395923 This session covers: a format to avoid and the one to use in its place keyboard and mouse…

Selecting the same cell in all the sheets

Post author:Neale Blackwood
Post published:16/04/2019
Post category:Excel Blog Tips & Tricks
Post comments:0 Comments

Let’s say you want the active cell to be A1 in all the sheets in a file before you save the file. There is an easy and quick way to do it. It doesn’t matter how many sheets are involved, but it does come with a warning. (more…)

Free Excel Webinar Recording – Mouse Shortcuts

Post author:Neale Blackwood
Post published:21/11/2018
Post category:Tips & Tricks Videos
Post comments:0 Comments

When I ran some face to face training sessions recently I was reminded how much people LOVE shortcuts. I did a keyboard shortcut webinar session in October 2018. In November 2018 I shared lots of mouse shortcuts. 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. [button…

VBA macros that run other macros

Post author:Neale Blackwood
Post published:13/01/2015
Post category:Excel Blog Macros Tips & Tricks
Post comments:0 Comments

When you become more advanced with macros and VBA programming (Visual Basic for Applications), you realise that you can create re-useable macros. (more…)

Printing in Excel

Post author:Neale Blackwood
Post published:09/07/2014
Post category:Excel Blog
Post comments:0 Comments

It is easy to print things from Word. It is not so easy in Excel. Excel has this huge grid and if you don’t tell Excel otherwise, it will print everything on the sheet, whether you want it to or not. (more…)

Excel and Hyperlinks

Post author:Neale Blackwood
Post published:02/07/2014
Post category:Excel 2003 Excel 2007 Excel 2010 Excel 2013 Excel Blog Macros Tips & Tricks
Post comments:0 Comments

Hyperlinks are a great tool as they allow you to speed up and simplify navigation within a file. Sometimes hyperlinks can be frustrating. See how to remove some of those frustrations below.

Selecting a cell with a hyperlink

(more…)

Excel Navigation Quick Tips

Post author:Neale Blackwood
Post published:25/05/2014
Post category:Excel Blog Tips & Tricks
Post comments:0 Comments

There are numerous keyboard and mouse shortcuts to navigate around your spreadsheet and file.

(more…)

Techniques to Paste Values in Excel

Post author:Neale Blackwood
Post published:17/04/2014
Post category:Excel 2003 Excel 2007 Excel 2010 Excel Blog
Post comments:0 Comments

Sometimes in Excel you need to paste just the values from copied cells. You don’t want the formulas. You may have created temporary formulas that you need to replace with their values. You may need to capture the current values, make some changes and then compare the new values with their old values to see the difference. (more…)

Handling Relative References in Excel [VIDEO]

Post author:Neale Blackwood
Post published:02/04/2014
Post category:Excel Blog Tips & Tricks Videos
Post comments:0 Comments

When you copy a formula in Excel, any relative references (those without dollar signs) may change depending on where you paste the formula. If you would like to copy a formula and not have the relative references change you have two options.

(more…)

Excel and Grouping

Post author:Neale Blackwood
Post published:13/02/2014
Post category:Charts Data Excel Blog Tips & Tricks
Post comments:0 Comments

The term grouping in Excel has many different meanings, probably more than any other term in Excel. (more…)

Getting dragging right in Excel

Post author:Neale Blackwood
Post published:24/01/2013
Post category:Excel Blog Tips & Tricks
Post comments:0 Comments

Ever tried using your right mouse button to click, hold and drag things around in Excel? You might be pleasantly surprised with the results. (more…)

Right Clicking in Excel

Post author:Neale Blackwood
Post published:03/01/2013
Post category:Excel Blog Tips & Tricks
Post comments:0 Comments

Right clicking in Excel offers many productivity benefits. If you don’t already right click try it, it’s fun to see all the options that are just a click away. (more…)