Creating, editing, and copying formulasUsing functionsUsing the AutoSum button and built-in functionInserting functionsUsing relative, fixed, and mixed cell referencesUsing names in formulas and validating cell entriesLooking at useful functionsHandy math and trig functionsHandy logical functionsHandy text functionsHandy date and time functionsHandy lookup and reference functionsHandy financial functionsWorking with text in ExcelCombining text from multiple cells into one stringRemoving extra spacesCopying cells containing formulas and pasting only their resulting valuesChanging the case of textRestricting cell entriesKey points