VLookup,Hlookup,Basic Excel functions, including SUM, AVERAGE, MIN, MAX, COUNT, and IF. Ability to use conditional formatting to automatically format cells. Knowledge of keyboard shortcuts to make work more efficient.