## Take the Excel Name Fix Challenge

Last week, in my Contextures Newsletter, I posted an Excel Name Fix challenge. There was a short list of names, which needed to be fixed. Then we needed to count how many were fixed....

## Excel Freeze All Worksheets Macro

If you’re working with a large worksheet in Excel, it usually helps if you freeze the cells at the top and/or the left side of the sheet. That way, your headings are always visible,...

## Fix Excel Conditional Formatting Duplicate Rules

Conditional formatting is a great way to highlight specific data, but did you know that it can automatically create new rules on its own? I’ll show you how that happens, and an easy way...

## Excel RANK IF Formula Example

Excel has a RANK function, so you can calculate where each number stands in a list of numbers. There isn’t a RANKIF function though, if you need to rank based on criteria. Someone asked...

## Popup List of Excel Sheets

If you’re working in an Excel file with lots of worksheets, it can take a while to scroll to the ones that you need. Sometimes you can’t even remember where the sheets are, and...

## Impressive Dashboards with Google Sheets

Over the years, I’ve used Google Sheets a few times, and usually for basic tasks. Yesterday, I was surprised and impressed to see what it can do, thanks to Ben Collins. He builds interactive...

## Pivot Table Subtotal Problem in Excel 2016

If you using grouping, you might run into a pivot table subtotal problem in Excel 2016. There was a change in a recent update, so you might see this problem if you have an...

## Excel VLOOKUP Problem Numbers

Recently, someone asked me for help with VLOOKUP problem numbers: He had a list of 8-digit numbers. In the next column, there was a formula to get the first 3 numbers: =LEFT(A2,3) Based on...

## Excel Form Control Button Quirks

If you’re building an Excel workbook for other people to use, you can add form control buttons, so it’s easy for them to run macros. One of my sample files has Navigation Buttons on...

## Excel Dashboard Course Giveaway Winners

Last week we had a giveaway, with the grand prize of Excel TV’s online course – Excel Dashboard Pro. To enter, you had to add a comment to the blog post, with the hashtag...

## Excel Dashboard Course Giveaway

Are you an Excel Dashboard pro? If not, here’s a great opportunity to improve your skills. I’m having a giveaway, and a terrific new Excel dashboard course is the top prize. There are runner...

## How to Prevent Grouped Dates in Excel

As a teenager, group dates can be fun. If you have strict parents, that might be the only kind of dates they allow! But, in your Excel worksheets, it can be annoying when dates...