VLOOKUP INDEX MATCH RANK AVERAGE SMALL LARGE LOOKUP ROUND COUNTIFS SUMIFS FIND DATE and many more. The result appears in cell E1. To see how altering one of the formula values alters the result change the data in cell C1 from 3 to 6 and press Enter on your keyboard.
Click Evaluate multiple times.
This course is for you if you know that you need to get started learning Excel but have just been too busy or felt too overwhelmed by the idea of studying. If you are using the example create a formula in cell G5 that multiplies the cost of napkins by the quantity needed to calculate the total cost. Click the Date_Text field in the dialog box click the corresponding cell on the spreadsheet then click OK and copy down. The process usually starts by typing an equal sign followed by the name of an Excel function.