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…

Time for another homework. You got a spreadsheet of department budgets and need to write a formula to get budget for a given department, month combination. Homework Specifics: Assume your…

Written by Debra Dalgleish from Contextures Blog Is the Excel IF function underused, overused or too often abused? Or some combination of all three? This short video shows how to…

Here is an awesome way to enhance your website and impress clients. Embed an Excel calculator on your webpage. Check out below demo and if this is what you want, read on.…

Live event on Friday, 26 Feb – 2021 Dynamic Array Functions Folks… Come and join me for a live event on Excel Dynamic Array functions this Friday (26 Feb –…