Free Webinar Recording – Excel Formatting Tips

Feedback score 94% based on 70 responses

In October 2019 I re-ran my Formatting Tips session. The detailed pdf manual and example file can downloaded by using the button below.

Download Materials

This session covers:

  • a format to avoid and the one to use in its place
  • keyboard and mouse shortcuts
  • how to use and create customer number formats
  • about Styles and how they can make your formatting more consistent
  • that colours can be used to filter, sort and even find things in your sheets
  • how to stop zeroes displaying plus other general formatting tips
  • a quick demo of Flash Fill

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.

Handling Exceptions in Excel

Two ways to consider

When developing budgets and financial models you may need the same rate/value (say debtor days) for 10 months of the year but need to adjust it for 2 months. It is usually December and January as they tend to be a little different due to the Christmas / New Year period. Here’s a couple of ways to handle exceptions in Excel.

Free Excel Webinar Recording – Custom Number Formats

Feedback score 92%

In April 2019 I demonstrated many of Excel’s Custom Number Formats.

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.

Webinar Materials

In this brand new webinar we examine Custom Number Formats which hide away at the bottom of the Number Format tab. These custom made formats offer some useful techniques.

They can

  • display negatives in red and with brackets
  • format mobile phone numbers correctly
  • display numbers and text together and still perform calculations
  • hide zeroes
  • display rounded numbers to thousands and millions
  • display the day of the week
  • create customised dates
  • be saved and be available in new sheets and files using a Template
  • be saved as a Style

See examples and demonstrations of many different custom number formats and learn how to create your own.

As always I will share a few other tips.

Free Excel Webinar Recording – Mastering Form Controls

Feedback score 92%

In March 2019 I demonstrated how to use some of Excel’s Form Controls.

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.

Webinar Materials

Learn how to build better spreadsheet interfaces using form controls like check boxes, scroll bars, option buttons and combo boxes.

Form controls can reduce the number of input errors; simplify and speed up input plus add structure to a file.

Discover the function that you need to use to get the most out of these controls.

Find out a few tips and tricks to make creating and using form controls easier.

As always there are a few more tips and tricks shared in the session.

Free Excel Webinar Recording – Format As Table Features

Feedback score 93%

In February 2019 I demonstrated how to use the Format as Table feature in Excel, including some advanced techniques.

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.

Webinar Materials

Many of Excel’s features and functions work seamlessly with formatted tables. They can help you improve the structure and reliability of your spreadsheet files.

Formatted tables can allow you to create powerful reports like those in a relational databases.

Topics covered

  • advantages and limitations of formatted tables
  • keyboard shortcuts
  • using formatted tables with formulas
  • solutions to some of the limitations of formatted tables
  • using range names with formatted tables
  • using formatted tables with data validations
  • creating a running total
  • using PivotTables
  • Relationships (Data tab)

As always there will are a few more tips and tricks shared in the session.

Free Excel Webinar Recording – Budget Challenge

Feedback score 93%

In January 2019 I presented a webinar that examined a solution to a 4 dimension budget challenge. 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.

Webinar Materials

NOTE: This is not a beginner’s session.

This webinar is based on a budget scenario which you need to read before the session starts. It is only 3 pages long and included in the materials.

Topics covered include

  • using INDEX-MATCH (better alternative to VLOOKUP)
  • 3-D formulas and techniques to make using them easy
  • using a reporting template
  • validations
  • extracting sheet names
  • automating reports

As always there will are a few more tips and tricks shared in the session.

Free Excel Webinar Recording – Excel Yourself 2018

Feedback score 89%

In December 2018 I reviewed four of my articles from the INTHEBLACK magazine from 2018. 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.

Webinar Materials

Includes extra content not included in the magazine.

This year’s smorgasbord webinar includes

  • how to handle validations
  • dynamically highlighting the current row in a table (uses a macro)
  • centralising logic – how and why to do it – alternatives to the IF function
  • creating a slope chart (includes a macro to speed up the process)

As always there will be a few more tips and tricks shared in the session.

Free Excel Webinar Recording – Keyboard Shortcuts

Feedback score 93%

When I ran some face to face training sessions recently I was reminded how much people LOVE keyboard shortcuts. So I decided to update my keyboard shortcut webinar.

In October 2018 I shared lots of keyboard 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.

Webinar Materials

Using the mouse isn’t always the quickest way to perform tasks in Excel. Keyboard shortcuts can speed up your work and save you hunting through screens and dialogs. Some of the keyboard shortcuts you will learn in this session are:

  • wrap text and other useful formats
  • applying row and column grouping
  • selecting a table quickly
  • copying visible cells only
  • apply and remove Freeze Panes
  • returning after following a hyperlink
  • how to avoid an annoying feature of formula and reference dialogs when you press an arrow key to move around
  • get the most out of the Tab key

There will be lots of other shortcuts as well. Even if you prefer using the mouse you might learn a few useful new techniques.