Excel tips and tutorials
With Excel’s conditional formatting options, you can highlight cells based on their values, or add colour scales, icons and data bars to the cells. There are built-in rules to highlight top or bottom values, and you can also create your own rules, as shown below.
Continue reading “Highlight Top or Bottom Values in Excel List”
Did you make any New Year resolutions that involve eating better, or getting in shape? If so, there are a few free trackers on my Contextures website, to give you some Excel help in reaching your goals.
One of my Excel sample files has a data entry sheet, with buttons to add/update database records that are stored on a different sheet. I’ve just added a new version of the file, that helps you remember to save your changes.
December is only 2 days away, so it’s time for an Excel Advent Calendar! I’ve made two new versions this year, and they don’t use macros, just basic Excel features. Even if you don’t need an Advent calendar, take a look to see how they’re set up . You might find a use for these techniques in other projects.
Happy Thanksgiving, if you’re celebrating tomorrow! Here in Canada, we have Thanksgiving in early October, when we’re less likely to have weather-related travel problems. This will be a short post, with a links to a couple of Excel holiday planner tools.
To use VLOOKUP, the value you’re looking for has to be in the first column of the lookup range. But what if your lookup table has Scores in column 3, and you need a description from column 2? Here’s how you can do an Excel VLOOKUP to the left. Continue reading “Excel VLOOKUP to the Left”
Happy Halloween! Some people think that Excel is a bit scary, so I made an interactive workbook that lets you show the friendly side of Excel. Download my sample workbook, to see all the Excel Halloween tricks, and share it with your spreadsheet-fearing friends too! Continue reading “Excel Halloween Tricks”
If you’re planning a vacation trip, Excel can help. It’s a great place to keep your packing lists, and you can track your vacation spending too (if you really want to know the total!). I’ve just uploaded a new sample file that will show how far you’ll travel. Select cities, and formulas do a mileage lookup, with total distance from start to end.
Do you use Excel to keep track of software subscriptions, or domain registrations, or other things with an expiry date? It’s important to keep track of those dates, so here’s an example of how to monitor expiry dates in Excel, and see what needs to be renewed soon.
Aside from staring at them closely, how can you compare two cells in Excel? Here are a few functions and formulas that check the contents of two cells, to see if they are the same.
