How-To Geek on MSN

How to use the REPT function in Excel to create text-based progress bars

Build stable, high-performance dashboards using REPT formulas and UNICHAR symbols instead of conditional formatting.
How-To Geek on MSN

How to use the BYROW function in Microsoft Excel

BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

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.

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

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.