This is the first episode of Dear Analyst, a podcast about Excel, data analysis, software, and everything in between. In this episode, I talk about the Copy and Paste Special Values feature in Excel, and why it’s not a good habit to get into when it comes to structuring the data in your Excel files. […]
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 […]
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 […]
FROM THE BLOG Why You Should Stop Doing Manual Spreadsheet Work Be furious that you have to do any type of manual work in a spreadsheet. Take pride in knowing you can eliminate your job. Read more PRODUCTIVITY HACK The Most Basic Bare Bones CRM Tool While we are big fans of using Google […]
Copying and pasting from one cell to another? Sorting through data trying to find the signal from the noise? Up-level this and go through your entire day when you’re sitting at your desk doing “work.” Creating calendar invites, copying and pasting from Excel into PowerPoint, formatting a spreadsheet until it’s perfect. These are things people generally consider to […]
FROM THE BLOG What Does It Mean To Be Busy? We’re back on the blog with a story digging a little deeper into why we lke to be “busy.” This post was inspired by Tim Kreider’s lazy manifesto on Tim Ferriss’ podcast. “I’m the most ambitious lazy person you’ll ever meet.” Read more […]
We hope that your summers are wrapping up nicely and that you have been extremely productive at your jobs! Due to the great support for our brand, we have decided to expand beyond Microsoft Excel. KeyCuts will now be offering keyboard covers for Adobe InDesign, Photoshop and Illustrator. Whether you are a creative, or know a […]
Excel for the Real World I studentVery good class, the teacher explained everything with simple to follow instructions, you can confidently operate Excel after this course!
