“But as one’s reach is amplified, so too is one’s vision. Now that the users can grasp much more of the computer material, they can also better see what they need.” This is a quote from a paper written by Alan Kay which we will come back to later in this post. I have begun reflecting […]
I get this question quite often, and I went over to Quora to see how other Excel experts and analysts are providing advice to newbies on how to learn Excel. If you are curious, my answers to Excel questions have been viewed more than 400,000 times. This shows that people are still using a tool […]
The last time I wrote about Modeloff was in 2013, the first international financial modeling competition I attended when KeyCuts just started. The result of the Modeloff competition in 2013 were a series of blog posts detailing some of the questions asked during the competition and the ways to solve the problems. Check out this […]
You’ve probably had to convert text to columns before in Excel. Usually in one cell, you’ll have a long line of text that is separated by commas, semicolons, or some other delimiter and all you’re trying to do is get each value into its own column. Something along the lines of this: This is probably […]
Helping some students at Columbia with an Excel exercise and though I’d post the exercise here since it brings up some interesting concepts around calculate trends and changes in values. This specific exercise is on how to calculate average trends in Excel and how to project future values based on these trends. So assume you […]
Excel is one of those interesting tools where the more you use it, the more nuances and idiosyncrasies you notice about the software. Most users of Excel might only touch 1% of the features available in Excel, but as you peel back the layers, you start to see the core of Excel and what the […]
The summer is coming to a close, and we have some really awesome blog posts coming up that will blow your data-driven/Excel minds! We’re going to be reviewing an awesome tool someone sent us that shows you how to remember shortcuts, and a new tool to help you ladies out there plan your bachelorette parties. […]
It’s the middle of the summer, you’re trapped in that subway car that doesn’t have air conditioning, and all you can hope for is that your co-workers don’t notice you’ve sweated through your brand new dress shirt. You might have casual Fridays, or even Summer Fridays (all you agency folks out there), but that doesn’t […]
Hope your summer is off to a great start! Whether you just graduated from school or getting ready for your summer vacation, we hope you keep your Excel skills–and more broadly–your analytical skills up to speed. We discovered a really cool site called MBA Excel which shows a bunch of tips and tricks in Excel. […]
The modern-day white collar worker is easily distracted. I don’t care if you work in advertising, finance, or the public sector. If you are sitting in front of a computer a majority of the day and have a smartphone, you will not be productive. Checking Facebook/Instagram/Buzzfeed is unavoidable in the case you miss out on the […]
Excel for the Real World I studentThis was a great class! I haven’t worked with excel in years and it was a great refresher course.
