Microsoft Excel
Excel's New List Feature: Filter and Count Multiple Items in One Cell
Excel can now hold a list of items in one cell. Create lists with Ctrl+J, filter by a single name, and summarize them with FLATTEN, UNIQUE, SORT, and COUNTIF.
Microsoft Excel
Hands-on Excel Training for UGA Terry College Executive MBA Students
A full day of hands-on Excel with the UGA Terry College Executive MBA class, from essential skills to break-even analysis and the three financial statements.
Microsoft Excel
Copilot Vision in Excel: Talk to Copilot and Share Your Screen
Copilot Chat can see your screen and hear you at the same time. Start a voice chat, share your Excel window, and ask for highest, lowest, totals, averages and rankings out loud — no typing, no formulas.
Microsoft Excel
Excel PivotTables: How to Use Defer Layout Update
Working with a large data set? Turn on Defer Layout Update in the PivotTable Fields pane, arrange every field you need, and apply all the changes at once with a single click on Update.
Microsoft Excel
Excel COPILOT Function Is Going Away: Can Copilot Dynamic Action Button Replace It?
The COPILOT function retires on September 14, 2026. I ran three real data tasks — sentiment ratings, ZIP code extraction, and address cleanup — through both the function and the Copilot Dynamic Action Button (DAB) in Excel to see what you actually lose.
Microsoft Excel
Excel FILTER with UNIQUE and TRANSPOSE: Build Dynamic Lists
Turn a flat list of names and departments into a column per department that updates on its own. UNIQUE pulls the distinct departments, TRANSPOSE turns them into headers, and FILTER drops the right names underneath each one.
Microsoft Excel
Excel XLOOKUP: Why Tables Are Better Than Ranges for Lookups
The same XLOOKUP built two ways: against a plain range with absolute references, then against named tables with structured references. See why the table version survives new data without an edit.
Microsoft Excel
Excel FILTER Function: Filter and Sort Data with Ease
The FILTER function spills back only the rows that match a condition. Three worked examples: filter by quantity, combine SORT with FILTER for sorted results, and build a between filter with two conditions.
Microsoft Excel
Summarize Text Columns in Excel with Copilot to Categorize Survey Responses
Copilot in Excel can now read a column of free-text answers — survey responses, feedback, help desk tickets — and summarize it into clean categories with a live count. Here is the exact prompt and workflow.
Microsoft Excel
Excel Formula Completion with IF Functions: Commissions, Grades, and Copilot
I test Excel Formula Completion on real IF functions - a commission formula with absolute references and a nested IF for letter grades. Here's how Copilot did.
Microsoft Excel
Excel COPILOT Function: Advanced Prompts with Real Examples
Push the Excel COPILOT function with five advanced prompts on a real sales dataset — regional totals, ranking, category comparisons, and finding the top improver by dollars and by percentage — plus how to verify every answer.
Microsoft Excel
Dollar Cost Averaging vs. Lump Sum Investing: A Side-by-Side Excel Comparison
Two people can put the exact same amount of money into the market and still end up with different numbers of shares — and different returns when they sell. That comes down to how the money goes in. The two methods are lump sum investing and dollar cost averaging, and I