This happens a lot. You export data into Excel and everything is in caps. It’s difficult to read and won’t go over well when you present. The PROPER function will convert your text into normal capitalization rules (first letter uppercase, following letters lowercase.). Tip: It’s a good idea to copy-paste values after completing this […]
Formatting a spreadsheet can be quite time-consuming. But like with many Excel tasks, knowing some keyboard shortcuts can really help. Alt + O,C,A will autofit the width of your selected column.
We are finally covering Excel content. I’ve discussed everything from what an analyst does to the good and the bad in Excel. Why the slow windup? It’s because being a good analyst is more about having the right mindset than memorizing every formula. Excel use follows the Pareto Rule — that is, 80% of your work will […]
This will be you as an analyst — headphones on, baffled by some spreadsheet your coworker just sent. This post is part of the Hired with Excel series. Read the previous post on the advantages of Excel here. The Bad Excel is dominant, but not invincible. Here are the three biggest downsides you should consider […]