Webinar Feedback
Its great to get feedback like this. Webinars can be an effective alternative to face to face training.
Identify Milestone Years in Excel
Recently a client wanted help in summarising a large data list of employees. They wanted to identify the years of service in terms of 5, 10, 15 years and other milestone years based on a start date. (more…)
My free Excel webinars are back
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…
Excel Test For One of Two Conditions
In Excel it is quite common to test a cell for either a zero or a blank. If either of these two entries are found then you do a particular calculation. There is an easy way to handle this. (more…)
Amazon
Bless their algorithmic hearts, Amazon are still trying to sell me my book. It was released four years ago in April.
Excel Formula to Extract the Domain
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. (more…)
Selecting a column
To quickly select a column of data in a formatted table you have a couple of options. Keyboard Select a cell in the column and press Ctrl + Space Bar. This will select the column of data. If you want the heading too, press it again. You can also select multiple columns before using the shortcut. Mouse This technique can take practice if your headings are in row 1. If the heading starts in row 2 or below it is…
Checking Rounded Totals in Excel
Rounded values in Excel can pose a few issues. There is a formula you can use that can round a range of values and then SUM the results. This can be used as a check total for rounded values. (more…)