MS Excel for intermediate users

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

Addressing

• What is relative addressing (e.g., =A1+B1)

• What is absolute addressing (e.g., =$A$1+$B$1)

• Mixed addressing (e.g., =A$1+$B1)

• Creating a table with calculations (e.g., calculating VAT, discounts, surcharges)

• Copying formulas and tracking changes in addressing

• Exercise: calculating prices with VAT, product discounts, currency conversion

Simple filters and sorting

• Difference between filtering and sorting

• Types of sorting: ascending/descending, by text, numbers, dates

• Using automatic filters

• Filtering by value, condition, color

• Sorting data by one or more columns

Conditional formatting

• Highlighting values above a certain threshold

• Color scales, data bars, icons

• Custom rules (e.g., =A1>100)

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