This one comes from a friend who wants to know how to average out a score for each person from a list where scores are recorded multiple times for each person.
Subscribe for more Excel tips and get your free ebook on getting “Hired with Excel.”
In this video I demonstrate how to do this in Excel using the AVERAGEIF function. I also demonstrate how absolute references and the ROUND function can add to the utility of this worksheet.
Teachers — anything else? Your questions answered, free.
Given it’s back-to-school time, I’ve been asked a few Excel questions from teachers. This would make a wonderful course. So if you’ve got questions about using Excel — for grading, scheduling,