How-To Geek on MSN

How to Use the UNIQUE Function in Microsoft Excel

Microsoft Excel's UNIQUE function does exactly as its name suggests—it extracts unique values from an array. In other words, ...
MUO on MSN

Old Excel functions you should stop using (and what to replace them with)

VLOOKUP has been the go-to function for looking up data in Excel for years, but it comes with limitations. You can only ...

How to combine two columns in Excel using formulas, and keep all of their data

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two ...

How to alphabetize data in an Excel spreadsheet by column or row, and by using shortcuts

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" ...
Digital Phablet

Top Excel Shortcut Keys You Must Know

Essential Shortcut Keys to Boost Your Productivity in 2025 In today’s fast-paced digital work environment, mastering Excel ...
Fast Company

This startup is bringing AI to an Excel-style spreadsheet

Spreadsheet apps like Microsoft Excel and Google Sheets are used worldwide to organize and analyze data, but getting the right information into them isn’t always straightforward. Businesses often need ...
The Age

Excelling at Excel: The spreadsheet world cup is anything but boring

Add articles to your saved list and come back to them any time. Forget slam dunks, penalty shootouts or gold medals. The most nerve-racking competition you’ve never heard of involves cells, formulas ...
ZDNet

Excel's new Copilot function turns your prompts into formulas - how to try it

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...
The Verge

Microsoft Excel adds Copilot AI to help fill in spreadsheet cells

The new ‘COPILOT’ function uses AI to generate summaries, tags, tables, and more based on a group of cells. The new ‘COPILOT’ function uses AI to generate summaries, tags, tables, and more based on a ...
GeekWire

Excel + AI: Microsoft brings new ‘COPILOT’ function directly into spreadsheet cells

Microsoft Excel’s new COPILOT function lets users generate, summarize, and analyze data directly in spreadsheet cells using plain-language prompts. (Microsoft Image) Microsoft is building generative ...
JournalofAccountancy

How to use Excel’s AGGREGATE Function

Q. Could you explain how the AGGREGATE function works in Excel? A. AGGREGATE is possibly the most versatile function in Excel. Think of it as an advanced version of the SUBTOTAL function that offers ...
Geeky Gadgets

Master Excel’s GROUPBY Function and Boost Your Data Analysis

Analyzing large datasets in Excel can often feel overwhelming, but using dynamic summaries with drill-down capabilities can significantly enhance your workflow. Whether you’re tracking sales, managing ...