Microsoft Excel Blog: Tutorials and How-Tos

Five Methods for Creating Running Totals in Excel

Excel is a powerful tool that offers various features to manipulate and analyze data efficiently. One of the useful functionalities it provides is the ability to create running totals, which can be essential for tracking cumulative sums over a period.

Removing Duplicates Using Power Query

We're going to take a look at removing duplicates using Power Query in Excel.

The 4 Percent Rule: Using Microsoft Excel to Plan for Retirement

Exploring the 4 percent rule through Microsoft Excel provides a hands-on approach to understanding how it might apply to your retirement planning.

Optimizing Microsoft Excel Files for Better Performance

Excel has a new feature called Check Performance. Check Performance will determine if your workbook is slow and optimize performance.

Excel - Using TextBefore and TextAfter Functions

Using Excel's TEXTBEFORE and TEXTAFTER together. TEXTBEORE and TEXTAFTER work like Flash Fill, the Left and Right functions, but they are easy to use and dynamic.

Mastering Conditional Formatting in Excel with Copilot: A Step-by-Step Guide

Mastering Excel is a critical skill for many professionals across various industries. Among the many features Excel offers, conditional formatting stands out for its ability to visually highlight important data. In this guide, we delve into the world of conditional formatting with the help of Excel's Copilot feature.

Copilot for Excel - Is it Accurate? 11 Tests Performed

Here's a detailed analysis of Microsoft Copilot in Excel. I delve into Copilot's functionalities with a series of tests, emphasizing its precision and capability in handling a variety of tasks within Excel.

Advanced Excel Conditional Formatting with Mixed and Absolute References

We use an advanced method of Conditional Formatting in Excel to identify numbers over a specific value. Unlike the conventional approach, I employ Mixed and Absolute References to enhance precision and flexibility.

March 14, 2024 - Beginner’s Guide to Microsoft Copilot

March 14, 2024 - Join our webinar to explore Microsoft Copilot for Microsoft 365. Discover how administrators can leverage its time-saving features across Word, Excel, PowerPoint, Outlook, and Teams.

Extract Emails from Outlook to Excel using Power Query

Step-by-step tutorial on using Power Query in Excel to extract and format email addresses from Outlook.

April 13, 2024 - Excel Training for MBA Students from the University of Georgia

I'm proud to announce I'll train the University of Georgia MBA students from the Terry College of Business in Excel on Saturday, April 13, 2024. Excel training will be hands-on.