If you haven't used Excel in a while, you may be surprised by how much it has changed. Whether you switched to Google Sheets, moved to open-source software, stayed with an older version, or simply stopped following updates, Microsoft has added features that could dramatically change how you work with spreadsheets.

For years, I accepted Excel's ribbon exactly as Microsoft designed it, even though I only used a fraction of its commands. After spending 10 minutes removing the clutter and reorganizing my favorite tools, I had a personalized workspace that sped up my workflow and stayed with me every time I opened Excel.

After years of using Excel, it's easy to fall into muscle memory. You click the same ribbon tabs, rely on the same shortcuts, and barely notice when Microsoft adds new tools. That's how I initially overlooked Focus Cell, a simple feature that solved one of my biggest frustrations when working in Excel.

Excel isn't known for being pretty, but the overlooked IMAGE function changes that. I'd used the IMAGE function before for simple visuals, but I wanted to see how far it could go. So I put it to the test by building a couple of interactive tools, and by the end, my spreadsheets felt more like apps than worksheets.

I used to spend far too much time building and debugging complex Excel formulas. Now, I can describe a problem to AI and get a working answer in seconds. But when I asked ChatGPT, Claude, and Gemini for the "best" Excel formula, they all gave me different answers.

I spent years fighting Excel's default behavior before realizing many of its biggest annoyances could be fixed in minutes. These buried settings changed the way I work and let me customize Excel to behave exactly how I want. Best of all, I only had to change them once, and Excel remembers my preferences every time I open the program.

Most of us use the same handful of Excel commands every day, overlooking features designed to make our spreadsheets easier to manage. This weekend, explore five hidden gems that can change the way you work with Excel.