Posted by: spreadsheetguy | January 31, 2012

Favorite Excel Formulae

There are some moments you never forget. For some, it might include their first kiss, their first date, their first day of college, the first day at work.

Well, here’s my quirky side coming out. I also remember my first experience using Excel’s logic formula, “IF.” I remember being in the office back in 2000 and having a colleague explain to me how the” IF” formula could change my spreadsheets from simple arithmetic projects to what seemed to me to be a thinking, living and reasoning friend.

Favorite Excel Formula - IF

“If this, than that.”
=IF(B1>0,”Yes”,”No”)

That was my Excel moment. Since that one epiphanic point in time, my spreadsheet experiences have never been the same. Soon thereafter, I discovered the CountIF and the SumIF formulae, as well as the AND and OR options.

No longer was Excel just a place to add, subtract, multiply and divide figures. It became a canvas of creativity. If I could imagine the path to solving a problem, I could create a formula to assist me.

All these possibilities did not even include Array Formulae, a discussion of which we’ll save for another day.

What about you? Do you have a favorite Excel Formula or remember the moment when Excel became for you something more than just a simple calculator? Please share your thoughts in the comments.

Best wishes,

Todd Christensen
CEO
TAWC Enterprises llc
TAWC Enterprises llc
TAWCent@gmail.com

Posted by: spreadsheetguy | January 13, 2012

Welcome!

Thank you for stopping by today. I look forward to sharing some great ways to make your work,  jobs and life more efficient through spreadsheets and spreadsheet ideas.

Here, you will also find discussions of spreadsheet resources and solutions that will help you as an entrepreneur, a small business, or as someone trying to organize their household finances or classroom projects. Whatever the task at hand, if it involves collecting, organizing or presenting data, this blog is for you.

Please feel free to leave me a message, comment on a post, and share a relevant link.

Have a great day!

Todd Christensen
CEO
TAWC Enterprises llc
TAWCent@gmail.com
www.TAWCenterprises.com

Categories