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.

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.

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.

Free Excel Webinar Recording – What If Techniques

Feedback score 92%

My free Excel webinar for September 2018 covered What If Techniques. Download the materials using the button below and watch the video.

Download Webinar Materials

Content applies to Excel 2010 and later versions. You will need to install the Solver Add-in – instructions in the manual and  video.

  • Goal Seek – simple what-if changes
  • Solver – advanced what-if analysis
  • Scenario Manager – handling different sets of inputs
  • Data Tables – single and double variable sensitivity analysis
  • NEW – Forecast sheet

Free Excel Webinar Recording – Conditional Formatting

Feedback score 94%

My free Excel webinar for August 2018 covered Conditional Formats. Download the materials using the button below and watch the video.

Download Webinar Materials

Content applies to Excel 2010 and later versions.

This session will take you through the basics, as well as an introduction to formula-based formats.

  • Data bars
  • Creating a progress bar using a Data bar
  • Colour scales – traffic light colours
  • Amending the default settings – getting the result you want
  • Icon sets – icons can be better for colour blind people
  • Cell-based rules – make the most of built-in features
  • Working with dates automatically
  • Formula-based rules – use formulas and functions to gain total control over conditions

Free Excel Webinar Recording – Copy and Paste Tips and Tricks

Feedback score 93%

My free Excel webinar for June 2018 covered Copy and Paste Tips and Tricks. Download the materials using the button below and watch the video.

Download Copy Paste materials

The session focuses on the Paste Special dialog plus a little known pasting feature that is great for dashboards.

It covers the hows and whys of

  •  Paste Values,  Paste Formulas,  Paste Formats
  •  Converting negative to positives
  •  Fixing Text numbers in-situ
  •  Applying a Factor to a range
  •  Paste Link – how and why to use it
  •  Transpose (switching rows to columns and visa-versa)
  •  Paste Picture Link (great for dashboards)

The session includes lots of keyboard shortcuts. As always, I shared a few other tips during 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.

Download Text Function 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.