My first thank you messages were directed to people who helped me learn Excel.
This, my fifth Thank You, goes out to the organisation that has helped me share what I had learned with others.
Thank You CPA Australia for publishing my first Excel article, way back in May 2002. Thank you for agreeing to do a regular Excel article in late 2002. The Excel Yourself series started out with a Q & A format.
Initially the questions were based on questions I answered during training sessions. Then I started to receive questions from CPA’s from around the world. I still receive questions, but the quantity has dropped off due to Google and the many excellent online Excel forums.
As at May 2018 there have been 170 Excel Yourself articles plus 8 feature articles. Articles now appear online and each has a companion video and many have companion files.
Over the years I have also worked with CPA Australia in creating and presenting training sessions for conferences and running training sessions in regional areas. I have recently done a few podcasts, plus I have written extra posts and done videos for the INTHEBLACK website.
Thank you CPA Australia for providing a platform to help me share my Excel skills with Australian accountants from around the world.
It all started from that first article all those years ago. By the way the first article was about the Ctrl key and its shortcuts – see image below.
Over the years I have had many requests to help people insert blank rows between entries is a list. Apparently it is for an input routine that requires blanks. My normal solution is a macro because it automates the process, but there is a manual technique that is quick and easy.
Thank you Bill Jelen
Recently I learned about the passing of Chip Pearson an Excel legend.
He was so generous with his content and I had thanked him for his contributions years back but it got me thinking about thanking others who had helped me along the way.
The fourth on my Thank You list is Bill Jelen (aka Mr Excel).
Through the Mr Excel website Bill has directly and indirectly helped more people than probably anyone else in Excel. The site
I have used the site’s forum to solve many problems over the years.
The forum has many Excel experts answering questions and solving problems from people from around the world.
Bill has written many books covering most of Excel’s topics.
I own a few of his books and have read many more. He tells it like it is and is not afraid to say if he disagrees with changes made to Excel.
Thank you Bill for being so generous with the your knowledge and for your huge contribution to the Excel community.
My career is better for having read your books and used your website – thank you.
The Step chart is not a standard Excel chart but it is a useful way to display values over time. You have probably seen a step chart but you may not have known what it was called. It sort of looks like the city skyline or something you would create on an Etch-a-Sketch.
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.
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.
Let’s assume you have a large table that you are filtering. Based on the current filter you want to work out the earliest date and the latest date. You may be surprised to learn the SUBTOTAL function can help you.