Entering the Tutorial Data
The first step to using the AVERAGE IF function in Excel is to enter the data.
Enter the data into cells C1 to E11 of an Excel worksheet as seen in the image above.
Note: The tutorial instructions do not include formatting steps for the worksheet.
This will not interfere with completing the tutorial. Your worksheet will look different than the example shown, but the AVERAGE IF function will give you the same results.
Information on formatting options similar to those seen above is available in this Basic Excel Formatting Tutorial.
