VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton…

I add lots of screen shots to my Excel tutorials, so it’s easier to follow the steps. And if I’m explaining a formula, it’s helpful to show that on the…

Do you want to manage your staff’s allocations, shift schedules and view the results in a 4 week grid fashion (like below)? Then you are going to love my FREE…

Let’s say you have two dates in the cells D4 & D5 as above. You want to find out the duration in years, months & days between both. We can…

Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence,…

Here is a fabulous New Year gift to you. A free 2024 Calendar & Activity planner made entirely in Excel. This dynamic calendar workbook lets you: See the calendar for…

Do you use Excel to help with all of your holiday planning? It’s a great tool for shopping lists, holiday budgets, dinner preparation, and even holiday games! Holiday Dinner Planner…

Bill Jelen is one of my most favorite people on earth. That is why I wanted to have him as my first guest when I restarted the podcast. Even though…

There’s a built-in tool in Microsoft Excel that makes it easy to remove all the duplicate values from a list. You can remove duplicates based on the items in one…

How about a fun Excel challenge? I have data in below format in the table named trips I want to know which employees visited both USA & UK? How would…