Microsoft Excel Blog: Tutorials and How-Tos

Excel Essential Skills - Rows & Columns and the EVIL Merge and Center

Excel Essential Skills you should know include AutoFit, Absolute Reference, Inserting and Deleting Rows and Columns, and why not to use Merge and Center.

Excel 3D Reference - easily reference data on another worksheet

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination.

What is the Middle Class and Are You in the Middle Class?

What is the middle class and are you in the middle class? To figure out if you are in the middle class, we need to know the median household income, how many people are in your household, and where you live.

Breakeven Analysis - Breakeven in Units and Breakeven in Sales

The Contribution Margin is a company's revenue minus its variable cost. You can use the Contribution Margin to find the Breakeven Point.

Excel - 3 Cool methods to extract text from the beginning of a text string

We frequently need to extract part of a text string in Microsoft Excel. We are going to extract the first part of a text string. Examples of text string parts you would extract include product numbers, employee IDs, and accounting numbers.

Excel - switch between relative, absolute, and mixed references

Excel has three cell references - Relative, Absolute, and Mixed. It is critical to understand when to use each reference in Excel.

Artificial Intelligence (AI) in Microsoft 365

Artificial Intelligence (AI) is in all Microsoft 365 apps - Excel, Word, Outlook, PowerPoint, Teams, and other M365 apps. In Excel, we have Analyze data on the Home tab and the ability to get data from a picture or screenshot.

Analyze Data Command in Excel - Ask questions about your data using AI

Need to quickly understand your data in Excel and ask questions about your data? Easy to do using Excel's Analyze Data command located on the Home tab in Excel. Analyze Data using Artificial Intelligence (AI).

Excel - Easily Break Up Data using Subtotals and Conditional Formatting

After sorting in Excel, we will look at two great methods for separating blocks of data or showing a clean separator between our groups.

Excel - Combine the SORT, UNIQUE, and COUNT functions

Excel has dynamic array functions. Two of the dynamic array function are SORT and UNIQUE. I will combine SORT and UNIQUE and also combine them with COUNT and the COUNTA functions. This came from a user that asked how many unique zip codes were in a spreadsheet.

Excel Sorting Tips with Chris Menard on January 24, 2023

Chris Menard will be live on YouTube and Linked showing Sorting Tips in Excel on January 24, 2023.

Excel Import Data from the Web

Excel allows you to pull data on a webpage into Excel. This is a great time-saving feature. Getting data from a webpage is done in Excel on the Data Tab using Get and Transform Data group, From Web command.