The Excel Expert Blog
Tracking Training Records in Excel
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Path – Step by Step
Easily get the weekday name from a date | Unleashing the power of text ()
Quickly get the name of the day from a date So you have a list of dates but for analysis purposes you need to be able to show the days of the week as another column. Of course you could spend many happy hours locating a calendar on Google and manually extracting them...
Conditional Formatting | Creating a rota that formats according to time
I recently got asked an interesting question via my YouTube channel from someone who wanted to set up a rota using Excel. However he wanted the rota to be coloured according to start time and end time so he could easily see how many people were on duty. So I decided...
Creating an Excel hyperlink – Part 02 | Linking to other files – using named ranges
In a previous post, I covered some of the basics of using hyperlinks to link to other documents but today I'm going to show you how to link to specific cells (or if you are feeling a bit adventurous :-)) to some named ranges. Also note that you can hyperlink to...
Quickly format, filter and formulate your list | Using Tables in Excel
Tables in Excel One of my new favourite features in the "new" Excel is Tables. When you convert your list to a table you quickly do the following: Apply slick formatting Apply filters Enter a formula once and see it whiz down the rest of the column...
INTRODUCTION TO PIVOT TABLES | PIVOTPOWER PREMIUM ADD-IN
Well, I have you enjoyed this series on pivot tables (you can start again at one and work your way through two, three, four, five, six, seven and eight any time you want to. However, today I just wanted to let you know about an excellent Add-in developed by Debra...
Case Studies – How To
Calculating a Location Allowance – with conditions
In this video I show you how to calculate a location allowance but only when certain conditions are met - the Ref number has to be higher than a certain figure and it's only paid when the employee is from one of four departments. However it also has to be adjusted 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...
Remove unwanted spaces using Trim() and combine multiple entries – 3 ways
Like many of my blog posts this came from a request from an attendee at one of my classes. She wanted to get a better understanding of how to clean up unwanted spaces in Excel - that's the Trim() function. She also wanted to learn how to combine multiple entries so I...
Exclude text from your conditional formatting for numbers
One of my main sources for these blog posts are questions I get from my subscribers and class participants. Recently I had one of my participants ask for help. He had applied conditional formatting to numbers - the idea would be that if the number was greater than a...
IF NOT – Use IFS/Nested If to show correct VAT rate based on country and product type
In this blog post I walk you through a number of different ways to tackle a question. I had a user who had to identify the correct rate for something based on country of origin and product type. You can download the completed file here. Watch the video here to see how...
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
KEEP GOING… | AFTER THE OVERWHELM
A while back I wrote a post about combatting overwhelm in which I spoke of my terror of participating in a musical playday. Just so you know I kept going and I've stayed on track with the oboe lessons (because I knew at some deep level, the deepest and best part of me...
QUICK ACCESS TOOLBAR AND KEEPING FREQUENTLY USED DOCUMENTS WHERE YOU CAN EASILY OPEN THEM
Today, I'm going to look at two of the new handy features that apply to both Excel 2007 and 2010. These are first of all the Quick Access Toolbar and I'm going to show you how to customise this - so that you can have all the commands that you use most frequently on...
QUICKLY ENTER DATA INTO MULTIPLE CELLS
I came across a trick in Chandoo.org about quickly entering data into multiple cells. For example, if you have a rota and you need to enter a name in multiple locations, this trick is really useful. View the video below to see how it's done. [flowplayer...
LEARNING TO LOVE EXCEL
This blog entry is not a tutorial per se. I found myself reflecting on my tag line and thinking about it. One of the things I would like for you - dear reader - is to experience love for Excel. Yes, I know that sounds seriously woo-woo but I mean that in the sense of...
Personal
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.