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

Creating a Dashboard in Excel

In this blog post I want to walk you through the creation of a dashboard in Excel. We will be using Slicers, dropdown lists, pivot tables and the lesser known function - GetPivotData. Oh and we might throw in a chart or two and traffic lights for extra zest...let's...

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...