Microsoft Tutorials

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.

Maximizing Efficiency in Teams Meetings with Copilot: A Comprehensive Guide

Copilot in Teams is designed to enhance your meeting experience by offering real-time assistance and summaries, ensuring you're always in the loop, even if you join late.

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.

Creating a PowerPoint Presentation with Microsoft Copilot

Microsoft Copilot is one of the latest features that has caught the attention of PowerPoint users. In this blog, we will explore the capabilities of Copilot and how it can help you create a PowerPoint presentation effortlessly.

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.