The Excel Expert Blog

Tracking Training Records in Excel

Excel Path – Step by Step

01 – Starting Excel from the beginning

One of my key ideas for this year is to create a section in my newsletter specifically for Excel newbies - so that people who are new to Excel can use it as a way to get stuck in and start understanding the terminology. If that is you, I would suggest starting by...

Faster Filtering with Filter()

Filter() is one of the new dynamic array functions in Excel. So what does that mean? If you have used Excel you will know that generally it has made like a single celled organism - create your formula in ONE cell and then copy it down or across. The new range of...

Case Studies – How To

Put away the calendar and use a formula

In this tutorial I am going to show you how to calculate the difference in hours/days/working days between two sets of dates. Put away our calendar/s and learn how to use these formulas instead. You can download the completed file here You can view the video here...

How to analyse Case time duration in Excel

I was recently asked by a participant in a class for some help with analysing case time duration - basically what was the average time duration from the opening of a support case to it being closed off and what time band it fell into. This required the use of the ever...

Creating a calendar in Excel –

In this video I want to show you how you would set up a calendar to use in Excel. We will be using the Text() function to extract days and months and then Conditional Formatting to show up the different types of leave. You can download the completed file here. You can...

Cleaning up emails

What happens if you get a list of names and emails from a colleague/customer but they are in a format that you can't use e.g. someone has CC'd you on the email but you need to have them in proper cleaned up format... In this video I use a file from my one of my...

Excel – General

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Random

Five clever ways to become an Excel whisperer…

One - Learn how to enter data into Excel A big big chunk of working effectively with Excel is getting your data set up right. So basically that means, if you have repeating data e.g. training records, invoices, transaction, they should be entered as a single big...

Personal

OLYMPICS, FAILURE AND RYAN LOCHTE

I'vwe been watching the Olympics sporadically over the last week or so. The big battle has been in the pool amongst the swimmers. Now I have to say I'm no swimmer. I didn't learn as a child and while I did try it again, my instructor - try as she did - was unable to...

AFTER THE OVERWHELM | COMES THE SURPRISE

Last week, I blogged about how I was going to play music with a group for the first time and how I felt terrified and overwhelmed... Well, I showed up. There was one other oboe player - a 13 year old (also called Anne) who was rather more advanced than me but who was...