Excel for Business Majors: Basic Skills

Basic Excel Functions

SUM- adds cells
AVERAGE- averages cells
MIN - shows the minimum value
MAX- shows the maximum value
COUNT and COUNTA- counts the number of cells
LEFT and RIGHT and MID- choose part of a string in a cell to put in new cell
LEN- tells the number of characters is a cell
NETWORKDAYS- returns the number of working days between two dates
WORKDAY- returns a date a certain number of working days away from a date entered
ROUND, ROUNDUP, ROUNDDOWN- Rounds a number, can make rules to round up or down
TODAY- states today's date