Calculating weighted average is the bread and butter of most teachers. You need to be able to provide students with grades that are weighted differently for homework, tests, and quizzes when using a…
Excel Functions
Weighted Average Template
SUMIF Function
SUMIF function is the perfect tool for business owners looking to keep track of their sales. While adding large sums of multiple items instantly is useful for a number of situations, this tutorial…
PROPER Function
Aesthetic is another important element of creating professional-looking Excel templates and many people seem to forget that. One simple and easy formula that can help with a very common mistake is the PROPER…
COUNT Total and Remaining
Counting the totals and remainders for a list of items can in hand in a variety of situations. The COUNT Total and Remaining template is the perfect tool to help you organize and…
COUNT Matches Between Columns
If you’re tracking multiple lists of items and what to see if there are any matches across multiple columns, it can be quite the pain to search through them all. The COUNT function…
COUNT Cells Between Dates
The COUNT function in Excel is fundamental and this method of using it will allow you to count between cells according to a specific range of dates. This is perfect if you want…