In this data validation drop down list, the most recently ordered products are at the top. The rest of the product names are below those, in alphabetical order. There's a…

How to create a fully interactive Project Dashboard with Excel – Tutorial In this article & video series, learn how to create a fully interactive Project Dashboard with Excel, as demonstrated on…

Sometimes, a MATCH formula returns an #N/A error, even if the value you're looking for is in the lookup table. The reason for that could be numbers that Excel sees…

FREE Live Event on 30th April, 2021 (Friday) Excel for Project Managers 4 focus areas Signup for the Event... RSVP Now The button will take you to YouTube. Just click…

If names are in Last, First order in an Excel workbook, use this MID formula to reverse them, in another cell. This short video shows the steps, and how the…

In this tutorial learn how to,Extract tabular data from one PDF to ExcelCombine and extract tables from multiple PDFS to Excel We will be using Excel 365 & Power Query to…

Written by Debra Dalgleish from Contextures Blog Do you sometimes get an Excel error that says "Cannot shift objects off sheet" or "Can't push objects off the sheet"? Why is…

IF is the most used Excel function out there. Here are 10 advanced IF tricks to take your formulas to next-level In this article, you will learn:Only one of, two out…

Written by Debra Dalgleish from Contextures Blog If you have a list of names or topics in Excel, here's how you can quickly create PowerPoint slides from that list. Unlike…

Live Event on 26th March, 2021 (Friday) Advanced Data Viz with Excel Signup for the Event... Name Email RSVP Don’t want to share your email? RSVP on YouTube instead. What…