LIVE on Friday, 25 June – 2021 Make a Sales Dashboard in Power BI Getting started & using Power BI in just one hour What is in this event? Overview…

Excel text functions are useful for cleaning up text / alphanumeric values, extracting parts of cell and presenting combined results in output pages. In this article, learn the most important…

Your Excel file worked perfectly yesterday, but when you entered new data today, the totals didn't update. Why did the formulas suddenly stop calculating, and how can you fix them?…

Do you love the formatted, named tables in Excel, and use them as much as possible? Or, do you hate tables, and avoid them at any cost? Here are some…

FREE Live Event on 28th May, 2021 (Friday) Getting Started with Power Pivot & DAX 15 useful measures Signup for the Event... RSVP Now Add to Calendar The RSVP button…

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…