YouTube on MSN

Scan function in Excel (one of the hardest to learn)

Learn how to effectively use the SCAN function in Excel to enhance your formula-building skills. This tutorial presents four ...

One Basic Excel Formula Generates Auto-Updating Visual Dashboards

Discover how to replace traditional Excel chart objects with clean, customizable in-cell visualizations using a single ...
YouTube on MSN

I mastered Excel's GROUPBY & PIVOTBY functions!

Learn how to use Excel's new GROUPBY and PIVOTBY functions through five real-world examples, ranging from easy to hard. This ...
TechRepublic

Tech news you may have missed Oct. 28–Nov. 3

New Microsoft 365 deployment tools, making OneDrive work on your iPhone, and a new Cranefly backdoor lead the top news for this week. In another week of intense world news, you may have missed these ...
TechRepublic

How to use the new TEXTAFTER() and TEXTBEFORE() functions in Microsoft Excel

Microsoft Excel’s new text functions make working with strings a breeze. A common task is to parse or find characters within a delimited string in Microsoft Excel. Fortunately, Excel has several ...