Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.
Excel - Getting Started with Autofill - MUST KNOW FEATURE
Posted by Chris Menard on 05/28/2023
Using AutoFill in Excel is one of Excel's most used features. To be proficient in Excel, you need to master AutoFill. In this video, we will look at using Autofill with Series, Columns, Number Patterns, Dates, and Text.
What is the Middle Class and Are You in the Middle Class?
Posted by Chris Menard on 05/13/2023
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.
Artificial Intelligence (AI) in Microsoft 365
Posted by Chris Menard on 04/13/2023
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.
Excel - Combine the SORT, UNIQUE, and COUNT functions
Posted on 01/27/2023
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.