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.
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.
How to get CREATIVE! by John Cleese
No slides needed, this was way back in 1991!
This is especially relevant these days because we get so little “think” and “alone” time.
Where it all began
A great talk by Dan Bricklin the co-developer of Visicalc – the first desktop spreadsheet.
He talks about how game changing spreadsheets were for the desktop computer.
Discover where he was when the idea came to him and how he visualised it.
Decisions he made back then are still with us today.
When you copy a formula in Excel, any relative references (those without dollar signs) may change depending on where you paste the formula. If you would like to copy a formula and not have the relative references change you have two options.