They will call you MASTER after this!

Functions 8: SUMIF, COUNTIF & AVERAGEIF Time to learn: 30 minutes Do you need to get the breakdown of sums, averages or a count of your data?  Need to get them by SEPARATE CATEGORIES?  Needed it yesterday? This series of formulas has so many uses, it’s amazing. You’ll be able to get the sums, counts and averages of items by specifying criteria of your design! Let’s start with some data.  Here we have a list of students, with the following columns – Name, Age, School, Grade and Fee.  Now, let’s see what we can do. SUMIF/SUMIFS This function adds values together if they fulfil certain conditions that YOU specify! SUMIF will only add values based on 1 specified condition SUMIFS will add values based on more than 1 specified condition Here’s an example. Let’s try to find out how much in fees students from school X pay: =SUMIF(C:C,”X”,E:E) Like all formulas, begin with ‘=’ and then the function SUMIF, with the

read more They will call you MASTER after this!

Be an Excel star and own it like a boss!

Welcome to ExcelPunks! Ever since Uncle Bill dreamed of putting a computer in every home, his company’s programs have become as much a part of our lives as well…computers. Excel isn’t new to any of us, but haven’t you wondered if it could be used as more than just a piece of digital paper? Ever wondered if Excel could start working FOR you?  Making YOUR life easier?  Allowing you to spend more time developing your staff or talking to your kids, or maybe spending an extra hour with a loved one who doesn’t have much time? I know, we don’t normally think about things like that, but that’s the truth of how some of us see work.  We place work above our own lives and before we know it, life is over.  There must be a better way, shouldn’t there? Someone taught ME once and I’d like to pay that forward in my own little way. By teaching others how to use Excel to

read more Be an Excel star and own it like a boss!