Yellow highlights mark locations referred to in boxes.
Added explanation for using F4 button in absolute refer
In this tutorial, information is presented in blue
An Excel file usually consists of multiple pages
) that can be accessed by
clicking on tabs that appear at the bottom of the
Instructions are in purple boxes.
Click on the worksheet tabs from left to right to
follow the tutorials on each page.
Exercises are presented in red boxes.
You can also use Excel's built-in help function by
pressing F1. Depending on the Excel version and
configuration, this may require an internet
This tutorial was developed in Excel 2010. Not
all features and functions may work the same
way in earlier or Mac versions of Excel.