What The Func?!

Undoubtedly you have called a function a formula and a formula a function; it’s just the nature of the Excel-lingo beast. That stops now. I want you to see functions for what they truly are: computer programming. You may feel like you are not yet ready to call yourself a computer programmer – but you are. And I […]

Read more "What The Func?!"

500 Days of SUM(SUMIFS())

This is not an Excel Lesson… This is a Lesson About Excel. Let’s start at the beginning… Download Workbook Day 1 Function: SUM Describe It: Add all the numbers within a range of cells. Syntax: =SUM(number1,number2,…) number1 can be anything from a single cell to a range of adjacent cells number2 and so on can be anything from […]

Read more "500 Days of SUM(SUMIFS())"

Wait a Minute Doc. Are You Telling Me That You Built a Time Machine Out of a Spreadsheet?

“I don’t know what you’re making me do and I have no idea when I will ever use this.“ Good. That means you’re on the right track, because I need you to look past the obvious and start concentrating on the possibilities. Let’s consider this idea: 50% of Excel’s abilities have to do with inputting text and numbers. The other 50% have to […]

Read more "Wait a Minute Doc. Are You Telling Me That You Built a Time Machine Out of a Spreadsheet?"