Microsoft Excel Blog: Tutorials and How-Tos

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.

Excel - Convert Seconds to Minutes and Seconds - Watch Chris Work!

Frequently we have data in one format but need to convert it to another. Today's example is I have a column on seconds for the length of videos. I want to show minutes and seconds with a colon in between the minutes and seconds.

TOP 5 Excel Features Released in 2022

Microsoft keeps rolling out awesome new features for M365 users. Many of the new features hit Excel in 2022. This video covers my top five favorite features in Excel from 2022.

Getting Started With PivotTables - Live on 2-22-2023

Chris Menard, Microsoft Certified Trainer, will be LIVE on YouTube and LinkedIn on 2-22-2023 at 12:30 pm for Getting Started with PivotTables in Excel.

Excel - Turn on Multiple Filters in a PivotTable

Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on the PivotTable Option - Totals and Filters tab and check Allow multiple filters per field.

American Society of Administrative Professionals - Microsoft 365 - Popular topics from my November 2022 session

I presented a Microsoft 365 session to over 500 Administrative Professionals this past week. Here are videos of some of my most popular topics.

PivotTables - 3 Annoying Things FIXED!

PivotTables are one of the best features in Excel. PivotTables allow you to summarize, analyze and chart complex data. There are 3 annoying things in PivotTables that users always ask me about.