11 cool things Copilot can do in Excel

As Microsoft ramps up Copilot’s capabilities in Excel, the AI tool is becoming genuinely useful for spreadsheet work.

Put Excel into Easy Mode by Implementing First Normal Form (1NF)

Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.
YouTube on MSN

Create an employee work schedule tracker in Excel

In this video, you'll learn how to create an automated employee work schedule in Excel. Key sections include: - Setting up ...
How-To Geek on MSN

How to add and use value tokens in Microsoft Excel

Bring your spreadsheets to life with visual value tokens that pull reputable, real-time data from Bing.

Make Excel Move Faster, Skip the Scroll : Sheet Lists, Bookmarks and Panels

Use Microsoft 365 View > Navigation to find, rename, or hide sheets in one place, keeping large workbooks tidy and easier to manage.

Microsoft Excel’s new import functions make handling numbers easier

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it easier to refresh and reuse frequently updated data inside a worksheet. The ...

Step-by-Step Guide to Plotting a Yield Curve in Excel

Learn to create a yield curve in Excel and understand its implications for interest rate forecasting. Follow our simple guide to plot your own financial data.
Investopedia

How to Easily Calculate Weighted Average in Excel

Claire Boyte-White is the lead writer for NapkinFinance.com, co-author of I Am Net Worthy, and an Investopedia contributor. Claire's expertise lies in corporate finance & accounting, mutual funds, ...