My free Excel webinars are back

All webinars are not the same

I recently ran my first public webinar in nearly a year – Materials Link and streaming Video below.

I run free and paid Excel training webinars. Watch a recording or come along to a free session and see if you like them.

My aim is to make my live training webinars as enjoyable, useful and practical as possible, which means

  • no PowerPoint slides EVER
  • zero marketing or up selling – just Excel training
  • no recorded content – its all live and interactive – comments and questions can be sent via a chat box
  • detailed instruction manuals – yes, even the free sessions have a detailed pdf manual
  • the free session recordings are always available – no time limits on watching
  • paid recordings can also be downloaded
  • annual attendance listing for CPD purposes when you attend a live session (sent out late January each year)
  • you must record your own CPD when you watch a recording (like the one below)

Download Materials

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.

Creating a table of all combinations in Excel [Video]

Power Query solution

Let’s assume you have three state codes and four department codes and you want to create a table of all the possible 12 combinations (3 x 4). How do you do it so that it is flexible? i.e. if you add a new state or department it must be easy to update the combination table.

Copying a Date Down a Long List in Excel

Two techniques make it quick and easy

There are a number of mouse and keyboard shortcuts for copying. But there is one type of copy that can be frustrating. Copying dates can be challenging because, in general, Excel wants to increment them, not copy them. There is a simple technique to instruct Excel to copy a date.

Handling DR and CR at the end of numbers in Excel

Sorting out debits and credits

Some systems add DR and CR to the end of numbers when they export into Excel. This renders the values useless for normal calculations. You can use data cleansing techniques to remove the characters using formulas or Power Query. There is one function however that can perform calculations on these types of entries.