This is going to sound incredibly nerdy, but there are few things I’m more impressed by than someone knowing their way around a spreadsheet. I think it’s because my own Excel skills have never been that great. I’m always having to google how to create options in a cell or ask someone why my percentage formula isn’t working. But that’s not surprising – like so many of us, I’ve never had Excel-specific training and haven’t spent any time sharpening my ability.
Today’s Work Smarter isn’t a solution to that (if your job requires you to be an Excel whiz, your workplace absolutely should be providing training), but a way to dip your toe into the spreadsheet game. Think of it as a low-effort way to learn some quick tricks that will wow your easily impressed colleagues.
First off, a keyboard shortcuts cheat sheet. I’ve listed a few that are worth knowing below, but I recommend bookmarking this image shared on X.
- Ctrl + A = select all contents of a worksheet
- Ctrl + space = select the entire row
- Ctrl + shift + % = turn a cell into the percentage format
- Alt + N + V = insert pivot table
- Ctrl + shift + & = apply a border around a cell
While using keyboard shortcuts is impressive (to me, at least), to really deepen your knowledge spend some time upskilling. LinkedIn Learning has multiple excellent courses on both Excel basics and more niche uses for the platform. One other option that’s worth considering: ask your workplace if they’d be up for buying a Microsoft Copilot license – that’ll give your Excel AI capabilities so you can automate all the faff.