When your spreadsheet has formulas piled on top of formulas, tracking and repairing errors would be agony if it weren’t for Excel’s Precedents and Dependents: cells that are referred to by a formula ...

If you are looking to improve your Microsoft Excel spreadsheet and data analysis skills you may be interested in this Advanced Excel Tips & Tricks tutorial from the team over at SSIT. Mastering ...

Ah, Excel. It’s been around since the ’80s, yet it can still stump many of us. There’s a lot to learn, from creating complex formulas to navigating pivot tables. So, where do you turn? You can buy a ...

Want to get more out of Excel? At Microsoft’s inaugural Data Insights Summit last month, several experts offered a slew of suggestions for getting the most out of Excel 2016. Here are 10 of the best. ...

Have you ever stared at a spreadsheet, struggling to make sense of percentage calculations that just don’t seem to add up? Whether it’s a confusing formula, a misstep with zero values, or an ...

Microsoft Excel has been the premier spreadsheet software for decades, since outdoing the once venerable Lotus 1-2-3, the first killer app for PCs in the 1980s. And Excel's dominance has yet to be ...

Q. I would like my employees to be more efficient with Excel. They are all at different Excel proficiency levels. Are there some quick tips I could share with them? A. There are so many tips that can ...

Excel isn’t the sexiest application in the world—it has an unfortunate association with the type of Milton-esque office drones we all wish we weren’t. All the same, you’re going to have to use at some ...

Back in 2013 John Gagnon wrote a very popular post detailing some of his favourite Excel tips and tricks. We thought we’d update the list of classic shortcuts with a few that reflect some new ...