Dicover three basic math functions in Excel

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

About-Launch-ExcelWelcome to Launch Excel
If this is your first time to LaunchExcel.com - Welcome to Launch Excel. My name is Victor and I'm the Chief Teaching Officer of Launch Excel, a website I started to help you learn how to use Microsoft Excel more effectively. Check out my welcome page created specially for you: Click here to view Welcome Page

One Response to Dicover three basic math functions in Excel
  1. […] 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. […]