Tag Archives: productivity

Dear Analyst #79: How to finally AutoFit column widths in Excel for the Mac (and PC)

When you’re creating some dashboard or report, one of the most common formatting operations you’ll find yourself doing is expanding the column width to fit the text or numbers in a cell. You might also be expanding the row height to fit the size of the text, but I think it’s less common than expanding […]

Dear Analyst #76: Productivity hack for creating a Google Calendar event by sending yourself an email

Taking a slight detour off of the data analysis/spreadsheet path and getting into the world of productivity hacks with this episode. A productivity hack can mean different things, and in this case it’s a hack to improve your workflow at, you guessed it, work. This hack gives you the ability to create a Google Calendar […]

Productivity Apps to Help Your Team

Following the last post about productivity tools and cloud computing, I did some more research on productivity apps to help your team collaborate and work more effectively. The main criteria are that the app had to be 1) browser-based (reasons for this mentioned in the previous post) and 2) multi-user collaboration is allowed. Having been an early […]

Why You Should Stop Doing Manual Spreadsheet Work

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 […]

Interview With Terry Chen About Excel Productivity At Hearsay Social

We had an opportunity to interview new KeyCuts customer Terry Chen about her experience working at a super innovative company, Hearsay Social. Learn about Terry’s Excel experience, productivity tips and tricks, and of course her new keyboard cover. What is your favorite Excel keyboard shortcut? My favorite Excel keyboard shortcut is command + SHIFT + arrow keys. […]

How You Can Save 40+ Hours From Your Life With Excel Keyboard Shortcuts

People often wonder how much time you can actually save using Excel keyboard shortcuts versus using the mouse. We ran a basic experiment and discovered that the average analyst can save 10.79 minutes a day using keyboard shortcuts instead of doing things manually with the mouse! This may not sound like a lot, but over the course […]

5 Microsoft Excel Add-Ons to Boost Your Productivity

Microsoft Excel is considered one of the most useful tools in the workplace. Excel gurus use keyboard shortcuts as if they were playing a piano, and can make Excel do some really wild things using advanced formulas and VBA scripting. However, if Excel is used incorrectly, it can seriously take your productivity levels down. If you […]