PCMag editors select and review products independently. If you buy through affiliate links, we may earn commissions, which help support our testing.

10 Excellent Tips for Microsoft Excel 2010

Our team tests, rates, and reviews more than 1,500 products each year to help you make better buying decisions and get more from technology.

Our Expert
LOOK INSIDE PC LABS HOW WE TEST
65 EXPERTS
43 YEARS
41,500+ REVIEWS

Excel is, without a doubt, one of the most powerful, complex, and tricky desktop apps ever designed. Mastering Office 2010's spreadsheet app can take years; fortunately, we've got 10 very cool shortcuts to Excel mastery.

Our ongoing series of Tips for Microsoft Office 2010 has given little consideration to Excel 2010; that's because this giant, complex spreadsheet app is worth an entire collection of tips all to itself. With its cool new Sparklines displays and enhanced pivot table tools, Excel is a more powerful part of Office 2010 than ever. But our tips concentrate on the basics—you don't need to write complex formulas to take advantage of them, and, since basic functionality mostly hasn't changed, you can use most of our tips with older versions of the app, as well.

About Our Expert

Edward Mendelson

Edward Mendelson

My Experience

I've been writing about software and hardware for PCMag for more than 40 years, focusing on operating systems, office suites, and communication and utility apps. I've specialized in everything related to word and document processing, including format conversion, OCR, and PDF apps. In my spare time, I build apps for Macs and Windows PCs that make it easy to run legacy operating systems (such as old versions of macOS and Windows) and work with legacy documents.

I've also written about technology for non-technical publications, such as The New York Review of Books. Before joining PCMag, I reviewed music and sound equipment for audio magazines. In my other career, I'm the Lionel Trilling Professor in the Humanities at Columbia University and write books about modern literature.

The Technology I Use

For work, I use a Lenovo ThinkCentre M901s desktop (one at home, one in the office) and a Lenovo ThinkPad X13 laptop. For everything else, I use an M4 MacBook Air and an M4 MacBook Pro. I also have an iPad Air and a closet full of obsolete ThinkPads and Macs that I use for testing and nostalgia. I still use an iPhone 13 mini because it's the smallest iPhone that Apple still supports.

My speakers are a mix of Bang & Olufsen and Sonos models, driven by a mix of tube-based and solid-state electronics and a WiiM Pro streamer.

Read full bio