sumproduct formula

Splitting Costs With Friends Just Got Easier In A Spreadsheet [+Template]

How many times have you gone on a group trip with friends, and figure out the costs at the end of the trip? Maybe one person pays for the hotel, one person pays for the rental car, and someone else pays for the dinners. Or maybe one person pays for everything, making splitting costs much […]

Never Do Tedious Worksheet Tasks Again With Excel VBA

The moment you discover VBA in Excel, you will never want to do another formatting or data manipulation task in Excel. When we first discovered how to use VBA, it was like getting fed ground beef after you tasted filet mignon: you just can’t go back once you have tasted heaven. Many people think VBA is meant for programmers, and […]

Still Not Sure About Skillshare’s Intro To Excel Class? Read Reviews from Current Students!

***2018 UPDATE*** New class launched in 2018 called Beyond Excel 1: Productivity Tools for For Lean Startups, Entrepreneurs, and Freelancers.  I released online Excel class on Skillshare, and the feedback has been pretty positive from students taking the course. The common thread we see through all the comments and reviews is that the pace of the course […]

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

Learn Excel Online At Your Own Pace With Skillshare

Looking to learn Excel online? We recently partnered with Skillshare and created a 3-part series on the basics of Excel featuring Al, our founder. You have probably heard about all these online education platforms pop up like Udactiy, Coursera, EdX, etc. We believe that online training and development is the new way people young and old can learn new […]

The Best Of The 2014 Accounting Technology Show NYC

We had a chance to check out the 2014 Accounting Technology Show & Conference (6th annual show) at the Pennsylvania Hotel in NYC last week. I know what you’re thinking, how interesting could a conference be about accounting and technology, and what does it have to do with Excel? If you work in a medium to […]

Excel Formula Final Question #4 from Modeloff 2013 Released with Explanation (4 of 4)

The long awaited final question from Modeloff 2013 is here! Sorry for keeping you all waiting so long, KeyCuts has been going through some really awesome developments and we have not had a lot of time to blog. Our goal is to increase our blogging to once a week so expect awesome stories around Excel, analysis, […]

Modeloff 2013 Excel Challenge #3 Follow Up Explanation

Sometimes when an Excel expert provides you with advice, it makes sense to write it down somewhere and share it with people you know will find this advice useful. This is exactly what this post is about. As a follow up to Challenge #3 we posted last week, Dan Mayoh (the creator of the challenge) provided […]