What’s your favourite way to troubleshoot Excel formulas? Here are a few tips for current versions of Excel, and a preview of new features that are coming soon, for Excel…

Today, let’s learn how to make an impressive map chart with Excel. Something like this: Step 1: Set up your Data for the Map Chart You need geographical fields (district…

With the Find and Replace feature in Excel, you can look for specific characters, and replace them with different characters, or replace them with nothing. You can also use wildcard…

Microsoft Excel is a great tool for creating business dashboards. Recently, I made the below dashboard using Excel in just 5 steps. Step 1: Figure out what you need The…

Since you’re reading this blog, you probably love spreadsheets. And do you love word games too? If you do, keep reading for a couple of ways to have fun with…

Create a monthly Excel calendar, based on a few short formulas. Next, add formatting and a heading, and if you’re feeling fancy, show a list of the month’s holidays too!…

Excel formulas acting slow? Today lets talk about optimizing & speeding up Excel formulas. Use these tips & ideas to super-charge your sluggish workbook. Use the best practices & formula…

Recently I optimized a pretty long nested IF formula using a simple but elegant trick. I made it 80% shorter! In this article, let me explain the process and share the…

In this hands-on tutorial learn how to create a simple, elegant and functional to-do list to track your projects and tasks. Download FREE To-Do List Excel Template Don’t want to…

This step-by-step video shows how to unpivot data in Excel, using Power Query. This creates better source data that you can use to build flexible pivot tables. And it doesn’t…