graphic1

 

Start Microsoft Excel.
When the Welcome screen appears, open a new, blank workbook.

What Do You See from the top of the screen?

Is there a Home Ribbon? And the Insert, Page Layout, Formulas, Data. Review and View Ribbons as well? Yes.

Then you are ready to go.

When in Doubt, Look it Up

Every job has something that you need to look up. In automotive design there are lists and more lists of parts, part numbers, sizes and tolerances. In medical and dental care, there are lists of procedure codes. You can use Microsoft Excel to look up the right answer. In our little company, Charlotte's Website, we need to calculate the commission for our sales representatives. The spreadsheet should compare the sales amount to the numbers in a Bonus table. The key to this formula is creating and naming a Lookup Table. This lesson will demonstrate Vlookup and HLookup Tables.