Dicover three basic math functions in Excel

 In Excel Formulas

In this 12 minute video I cover three math functions – SUM() COUNT() and AVERAGE(). These are pretty fundamental building blocks that you’ll use often in spreadsheet calculations and building spreadsheet models.

If you have any trouble watching the Youtube video embedded above, you can view it directly on Youtube by clicking here. This will open in a new window and show the HD version by default (720p) – if you have a slower connection you may want to view the video in standard mode by clicking here.


Mind Map: Excel Formula Basics (Sum, Count, Average)

I created a mind map to summarize the contents of the video – for a full size version that will open in a new browser window click on the picture below.

Mind Map - Sum, Count, Average

Click on picture for larger version


What do you think of the video format?

This is my first video with an embedded Mind Map – the purpose of this was to give some context and set the scene to help beginners learn Excel faster. I’d like to know what you think of the video and what thoughts you have about using Mind Maps to learn Excel, so send in your comments using the comment section below. If you like the format please tell me and I will make more videos like this! Thanks – Victor 🙂


Learn more Excel Formulas – fast!

I based this video on material found in the Excel Formula 1 e-book, and if you are interested in picking up a copy of this e-book click on this link.

Bear in mind that I will get a commission from Chandoo.org if you purchase a copy of the Formula-1 e-book but the only reason I’m promoting it is that I think it can offer good value to Excel users who are just starting out and want a fast introduction to common Excel formulas.

The author Chandoo is a well-known Excel expert who was awarded Most Valued Professional (MVP) status by Microsoft for the help he has provided to the Excel community online, and he has written the e-book in a friendly informal style that makes it accessible if you don’t want to wade through more technical explanations.

Excel Formula-1 e-book

To find out more about the Excel Formula-1 e-book from Chandoo, click on the picture

Victor Chan
Victor has been using Excel intensively since 2002. He is a Chartered Accountant (Fellow of the ICAEW) and has an MEng in Manufacturing Engineering from the University of Cambridge. He is on a mission to help you learn Excel and VBA with practical video tutorials and awesome online courses.
Join over 9,000 subscribers

GET BETTER AT EXCEL

Recommended Posts
Comments
pingbacks / trackbacks
  • […] In this 6 minute video I show you how to quickly name cell ranges with a powerful keyboard shortcut, and also show you how to use three math functions – SUMIF(), COUNTIF() and AVERAGEIF(). These are good building blocks that you’ll use in spreadsheet calculations and building spreadsheet models – I covered their friends SUM(), COUNT() and AVERAGEIF() in an earlier post that you can read by clicking here. […]

Contact Us

Please send us an email and we'll get back to you, asap.

Not readable? Change text.