Ready to talk like a real Excel geek and impress potential employers? Check out my new course, “Hired with Excel: What Every Analyst Needs to Know.” Get started at the link. I’ve noticed over time how a handful of my posts get a bit of traffic daily. One of these has been tips on how […]
I love using Excel because it’s so flexible and adaptable. There’s no better vehicle for quick, easy data analysis. Chandoo of chandoo.org often emphasizes the importance of playfulness and interaction when building solutions in Excel. A good analyst knows how to combine disparate functions and features in Excel to engineer new solutions. This takes a creative […]
An increasing number of jobs require quantitative aptitude. Where to begin? Get hired… start with Excel. This PDF is a preview of a course I developed specifically for job seekers and others hoping to advance their career through Excel. Download below. Like what you see? Check out my course. With over two hours of video […]
Ctrl + 5 applies a strikethrough line to selected cells in Excel. This can be useful if you are collaborating with colleagues on a list-type project and want to clearly show when projects have been completed, for example.
Another quick formatting tip: Ctrl + Shift + _ will erase all border formatting from selected cells in Excel.