what’s the coolest Excel trick you know? by Alison Green on December 5, 2013 A reader writes: From reading the comments on AAM, it seems many of your readers are Excel gurus. I use Excel a lot at work but feel like I’m only scratching the surface of what the software can do. I’m familiar with basic formulas (think =SUM and =AVERAGE) and recently learned how to subtotal and reference other worksheets, but what are some other tricks that readers find most useful? I’m so glad you asked this, because I notice all the Excel experts here too and I want to know what they know. We had a post early last year about how to get Excel skills, but I like this better: Readers, tell us the Excel tricks you find most helpful! You may also like:what’s your best tip for staying organized?the best “ask the readers” posts in 2013ask the readers: what are you really good at?