PCMag on MSN

These 47 expert Excel tricks will transform you into a power user

Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.
MUO on MSN

I stopped copy-pasting data in Excel after I found this 'Unpivot' button

The "Unpivot" button inside Excel's Get Data feature is a hidden superpower. It can turn a tedious, error-prone task into smooth, automated workflows. No more copy-pasting, no more manual rearranging ...

17 New Excel Features for 2026 to Speed up Your Work

Discover 17 new Excel features and functions for 2026, so you track edits and data faster. Including auto-refreshing pivots ...

Learn What GROUPBY Can Really Do in Excel : From Smart Sorting to Percent of Totals

Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.

How to Easily Calculate Weighted Average in Excel

Learn how to calculate weighted averages using Excel for various financial metrics. Simplify complex calculations with our ...

Master Sharpe Ratio Calculation in Excel for Better Investing

Learn to calculate the Sharpe Ratio in Excel for insightful investment analysis. Our guide will help you assess risk versus ...