Helping you to enjoy (even love) Excel one cell at a time
Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam - and the techniques I learned there made me realise I could have done this more effectively.. You can view Part one here (Steps one to three) Just a reminder about what deferred income is......read more
Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam - and the techniques I learned there made me realise I could have done this more effectively, but that will be for another post...:-) There are seven steps in this so I have published the first...read more
So one of the questions that comes up when I am helping customers with this is how do you calculate what percentage of your staff are compliant. In this scenario, I have set up 16 employees who each have to do a Health and Safety and Induction course. Some of them...read more
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
[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
September can be described as the new January and it's often a time when people decide to start something new or get stuck into something they have been thinking about learning. Dare I suggest that could be your Excel skills ?In this blog post I am offering 5 ideas...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!)