Helping you to enjoy (even love) Excel one cell at a time
In a class recently the subject of age calculation came up, which reminds me of when my son was young and would ask me how old I was. "19", I would say succinctly. He was at the age when he was learning basic maths. "So what would make you 12 when you had me.." "Yes,...read more
A common issue for many organisations is tracking time-in-lieu i.e. someone has a certain number of days/hours holidays(vacations) allocated but they can increase that by doing overtime and then taking time off - "in-lieu". While some organisations have a system in...read more
This is my first blog post of 2017. I have to say I do love the energy of a new year. My favourite time of the year are those days between the "two Christmases" i.e. 25th December and 6th January. There is no pressure. Just movies to be watched, sweets to be eaten,...read more
Debra Dalgleish (http://www.contextures.com) is one of my Excel heroines and the pivot table guru. She is someone whose work I regularly reference in class. I recently asked her to help me answer a question that regularly comes up in class when people ask about pivot...read more
Well, had a bit of a weird experience. I had written a full blog post on how to use Solver to identify what numbers make up a specific number. Let me give you a specific example. Many years ago - when I was working in an office - I'd have a difference in my bank...read more
Do you need to know how to analyse your Facebook data |Here’s how, using Power Query and Pivot Tables
In this blog post I'm going to show you how to use one of the new add-ins from Excel (Power Query) to quickly pull in your data from Facebook and then summarize it. Note that if you have found this useful that I cover both pivot tables and Power Query in my book Your...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!)