Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.
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.
Excel Import Data from the Web
Posted by Chris Menard on 01/18/2023
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.