Home

How to Chart data & use Excel's SUMIFS & AVERAGEIF functions

May 7, 2010 02:21 PM

Spreadsheet interface displaying data fields and entries.

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and use simple charts in MS Excel as well as see how to use Excel's SUMIFS & AVERAGEIFS functions. Specifically, this video covers the following topics:

1) Difference between a Line Chart and a Scatter Diagram Chart

2) Add trendline

3) SUMIFS function

4) AVERAGEIFS FUNCTION

5) PivotTable (Pivot Table) to add with multiple criteria

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.