Microsoft Tutorials

Oct 28, 2024 - I'll be Speaking at the Administrative Professionals Conference on Excel Copilot: Data Analysis Simplified

I'll be speaking at ASAP's Administrative Professional Conference in Aurora, CO on October 28, 2024. My deep dive session will be on Excel Copilot: Data Analysis Simplified

Sep 28, 2024 - Excel Training for Executive MBA Students at the University of Georgia

I'll be speaking on September 28,2024 to the Executive MBA students from The University Of Georgia's Terry College of Business. We will cover many Excel topics including Financial Analysis in Excel.

Creating a Column Chart using S&P 500 data with Positive and Negative Colors in Excel

Imagine a scenario where you're analyzing the S&P 500 index's performance over several years. You'll likely encounter both positive and negative percentage changes. Distinguishing between these with just numbers can be dry and difficult to grasp immediately.

Optimizing Excel Formulas with Copilot: A Comprehensive Guide

Excel has always been a powerhouse for managing data, and with the introduction of Copilot, it's become even more powerful. Copilot

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.

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.