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 the 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 – Text Functions explained and demonstrated

How to text safely in Excel

My free Excel webinar for May 2018 covered Text functions. Download the materials using the button below and watch the video.

You know how well Excel handles numbers, but not everyone knows that Excel has built-in functions and features to work with text as well. This session covers Excel’s text functions and features, in it you will learn

  • the different techniques to split text
  • techniques to extract text from text
  • how to easily join text
  • techniques for tweaking text for dates, numbers, upper and lower case
  • the formulas for extracting sheet and file names
  • two new Excel 2016 functions for combining text from ranges

As always, I will be sharing a few other tips during the session.

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 Text Function materials

 

Excel and Outliers

New functions make it easier to find them

Malcolm Gladwell’s book Outliers is a great read – I reviewed it here. Its premise is that some outliers (events that are far outside “normal” expectations) have causes and hence are worthy of investigation. Excel have some functions that can help identify outliers in your data.

Excel Formula to Extract the Domain

Using the SUBSTITUTE function

I recently read a blog post about using Excel for SEO (Search Engine Optimisation). It mentioned a function to extract a domain from a URL. The function was from Google docs, not Excel. So I wrote an Excel formula to extract the domain from their list of URLs.