How to compare two lists in Excel

Recently I got asked by a colleague to help her identify compare two lists of providers in Excel. In one list there was a list of providers available in May. In the other she had a list of providers available in January. She wanted to identify what providers were in...

read more

10 tips to help you work faster in Excel

[ordered_list style="lower-roman"] Table it! If you have large data sets, convert them to a table. This means that if you scroll down to the bottom, the headings will remain visible at the top Hide! :Hide the columns/rows you don’t need. Top row visible: Freeze the...

read more

The Excel Lady – for when you feel rude about Excel

First of all welcome to the site. If you are here you are probably looking for help with Microsoft Excel. This site is full of Excel tutorials and hints and tips.

In this website you will find help with Excel that is specifically aimed at solving YOUR Excel problems.  A lot of the tutorials I give here are inspired by questions I get in class so if you have a specific question – sign up for the shortcuts (see box over on your right – they are free, and unlike Hotel California, you can check out any time ????and let me know how I can help..

We’ve all spent lots of time feeling frustrated by Excel and thinking there has to be a better way.

In this website I want to demystify it for you, help you understand the power and ease of some of he that functionality you see other whizs using.  All the blog posts here include a video and examples in the excel sheet. 

I want you to start ENJOYING using Excel (yes, it’s possible!)

Sign up to get your free training records tutorial and template

We respect your email privacy