MS Excel – calculations and basic functions

MS Office course designed for employees of the University of South Bohemia. 

The difference between calculations using simple formulas and functions

• Formula syntax: begins with the = sign, e.g., =A1+B1

• Functions: predefined calculations with specific syntax, e.g., =SUM(A1:A10)

When to use a function instead of a formula

Calculations and working with percentages

• What is a percentage and how is it calculated

• Conversion between decimal numbers and percentages

• Rounding and number of decimal places

Basic functions

SUM, AVERAGE, MIN, MAX, COUNT, COUNT2, TODAY

Mgr. Vendula Mikolášková
This email address is being protected from spambots. You need JavaScript enabled to view it.