How-To Geek on MSN

I always use Excel to create heat maps: Here's how you can too

Dynamically visualize your data.

15 Modern Excel Functions Worth Knowing in 2026 That Outclass Clunky Workflows

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...
How-To Geek on MSN

How to use R1C1 referencing style in Microsoft Excel

R1C1 coordinates provide a predictable map for auditing formulas and writing universal VBA macros.
JournalofAccountancy

Using Excel’s What-If Analysis with Data Table for data analysis

Q. You explained Excel’s Scenario Manager in your November 2024 Tech Q&A article and Goal Seek in your December 2024 Tech Q&A article. Can you please explain the final What-If Analysis tool: Data ...

8 New Excel Upgrades for 2026 : Smarter Formulas, Web Charts, Better Error Tips & More

Discover 8 2026 Excel updates, including AI formula creation and a year of change history, so your team works quicker with fewer mistakes.
JournalofAccountancy

How to use Excel’s UNIQUE Function

Q. Could you explain how the UNIQUE function works in Excel? A. Excel’s UNIQUE is a dynamic array function that can be an essential tool for data analysts and accountants. This function allows users ...
SlashGear

What Is The Lookup Function In Excel & How Do You Use It?

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...
PC World

Use Microsoft Excel data types to save unnecessary typing

If you’ve ever doing an assignment for work or study that requires you to display information about a country, you could manually search for it and type it out in Microsoft Excel, but that would be ...