No more Power Query needed.

Once data is loaded into Excel, Copilot allows users to ask questions in natural language instead of building new formulas.

Have you ever found yourself wrestling with Excel, wishing it could just do *that one thing* to make your work easier? Maybe you’ve spent hours manually replacing text, trying to filter data with ...

Make Excel evaluate your data for you.

Microsoft adds IMPORTTEXT and IMPORTCSV to Excel, letting users pull text files directly into the grid with simple formulas.

In Microsoft Excel, there are a variety of categories of functions such as Math and Trigonometry, Statistical, Financial, Logical, Text, and more. A Text function changes how a number appears by ...

Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of functions like LEFT, RIGHT, MID, and FIND, leading to some confusing ...

Q. I read your August 2022 JofA article about changing the case of text in Excel to upper, lower, and proper, but some of my data comes in sentence form. Is there any way to convert those text strings ...

My approach to PPC is analytical. I realized early in my career that if I focused on developing my ability to manipulate and interpret performance data, the optimizations become obvious. Leaning into ...

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 ...