One Minute to Excel #8 – Incrementing a Long List of Dates
In this short video I cover how to increment dates in long ranges. It uses a little know dialog. https://vimeo.com/507886312
One Minute to Excel #7 – Copy Date down a Long Range
In this short video I cover how to insert dates in long ranges. Its simple and quick. https://vimeo.com/507884321
One Minute to Excel #6 – Add Subtotals Automatically
In this short video I cover how to insert automated subtotals. Its a built-in feature, that is easy to use. https://vimeo.com/495658266
One Minute To Excel #5 – Extracting Unique Entries
In previous videos I worked with duplicated entries. In this video I demonstrate how to extract unique entries from a list. Three different ways in 60 seconds. Off we go! https://vimeo.com/495654905
One Minute to Excel #4 – Copy Anything
Copying is a common task in Excel. This technique applies to most things in Excel form cells and range to charts, images and sheets. It also works in Word and PowerPoint. Have you used the mouse and keyboard together? It is time to start. Let's go. https://vimeo.com/495652208
One Minute to Excel #3 – Filling in the blanks
Imported data often has missing entries you need to populate. You can use Power Query, but that duplicates the table. This technique works on the existing table and is quick and easy to apply once mastered. Start the clock! https://vimeo.com/480678374
One Minute to Excel #2 – Identify Duplicates
In the previous video I removed duplicates, in this video we identify duplicates using Conditional Formatting. I identify the duplicates twice in a minute in this video. The clock is ticking. https://vimeo.com/480678280
One Minute to Excel #1 – Remove Duplicates
I have started a new series of short videos showcasing Excel's features that work in less than a minute. There is a countdown to see if I can do it. In this first one I remove duplicates in less than a minute. https://vimeo.com/438770400
Free Webinar Recording – Excel Format as Table Feature
In March 2020 I presented a session on Excel's Format as Table Feature. I covered it's advantages and how to use it to improve your Excel files. The detailed pdf manual and example file can be downloaded using the button below. Content is 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.…
Free Webinar Recording – Excel Budget Challenge Solution
In February 2020 I reviewed my solution to an Excel Budget Challenge from late 2018. This included some advanced Excel budget techniques. The detailed pdf manual and example file can be downloaded 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/391137790 This session includes a lot…
Free Webinar Recording – Date and Time Calculations
In January 2020 I looked at solving some of the frustrations date and time calculations can cause in Excel. The detailed pdf manual and example file can be downloaded 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/386635825 Discover the functions that handle different types of…
Free Webinar Recording – Excel Yourself 2019
In December 2019 I reviewed four of my articles from 2019 plus some new content. The detailed pdf manual and example file can be downloaded 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/379919236 This year’s webinar includes a new logic function IFS how to do…
Free Webinar Recording – Excel Chart Tips and Tricks
In November 2019 I re-ran my Excel Chart Tip sand Tricks session. The detailed pdf manual and example file can be downloaded 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/374068298 This webinar is focused on showing you how to create and modify charts in Excel…
Free Webinar Recording – Excel Formula and Function Tips
In October 2019 I re-ran my Excel Formula and Function Tips session. The detailed pdf manual and example file can be 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/366912862 This session covers lots of tips, tricks and techniques to speed up the formula…
Free Webinar Recording – Introduction to Power Query
In October 2019 I ran my Introduction to Power Query webinar for free (previously it was a paid session). I want to get this information out to as many people as possible. please share this resource with colleagues and your network. The detailed pdf manual and example file can be downloaded by using the button below. Content listed below the video. Download Materials Power Query allows you to automatically perform data cleansing routines on your data sources – no manual…
Free Webinar Recording – Excel Formatting Tips
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…
Free Webinar Recording – Interactive Excel Chart
In September 2019 I re-ran my very first webinar that was based on an August 2012 INTHEBLACK feature article. I have provided a detailed pdf manual and example files which you can download at the link below. This session covers using controls with charts to make the user experience easier tips for using controls on spreadsheets flexible formula techniques to make reports more dynamic a technique to stop figures plotting on charts using range names with controls and reports general…
Free Webinar Recording – Recorded Macros Tips Tricks and Traps
It is easy to create a recorded macro. It is not so easy to create a flexible and re-usable recorded macro. Click the materials Button below to download the pdf manual and example file. Learn the techniques that can allow you to record effective macros that can handle different ranges and changes to sheet names. Macros can speed up your work and reduce the time taken for tedious tasks, as well as adding functionality to Excel. This is the first…
Free Excel Webinar Recording – Financial Functions Part 2
In July 2019 I explained and demonstrated a number of Excel's financial functions - see below for more details. 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 Webinar Materials https://vimeo.com/349593208 In July 2019 following on from the response and feedback from my June webinar, I covered more financial functions. These are more related to comparing and…
Free Excel Webinar Recording – Financial Functions Part 1
In June 2019 I explained and demonstrated a number of Excel's financial functions - see below for more details. 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 Webinar Materials https://vimeo.com/341487244 These functions take three or more arguments, but there are a few things you need to know to use them correctly. Most involve loans or calculations…
Free Excel Webinar Recording – Dashboard #1 Guildelines & Techniques
In May 2019 I examined and demonstrated some guidelines and techniques for creating charts for dashboards. 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 Webinar Materials https://vimeo.com/334821126 In this session I focused on chart and dashboard guidelines plus some techniques used to create small charts for dashboards. I also looked at creating a bullet chart, which…
Free Excel Webinar Recording – Custom Number Formats
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. Download Webinar Materials https://vimeo.com/330698381 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…
Moving Images in Excel
When you are moving images, charts or other objects that float above the grid you can use the Shift key to make it easier.
(more…)
Free Excel Webinar Recording – Mastering Form Controls
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. Download Webinar Materials https://vimeo.com/322983267 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…
Free Excel Webinar Recording – Format As Table Features
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. Download Webinar Materials https://vimeo.com/316946174 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…
Free Excel Webinar Recording – Budget Challenge
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. Download Webinar Materials https://vimeo.com/313089374 NOTE: This is not a beginner’s session. This webinar is based on a budget scenario which you…
Free Excel Webinar Recording – Excel Yourself 2018
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. Download Webinar Materials https://vimeo.com/306102144 Includes extra content not included in the magazine. This year's smorgasbord webinar includes how to handle validations dynamically highlighting…
Free Excel Webinar Recording – Keyboard Shortcuts
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. Download…
Filling a large range in Excel with a series [Video]
Let’s assume you need to fill a vertical range with all the whole numbers from 1 to 100. There are lots of ways to do this, but I think the keyboard could be the quickest.
(more…)Free Excel Webinar Recording – What If Techniques
My free Excel webinar for September 2018 covered What If Techniques. 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. Download Webinar Materials https://vimeo.com/291843750 Content applies to Excel 2010 and later versions. You will need to install the Solver Add-in - instructions in the manual and video.…