Excel for Businesses

Description

Week 1

Introduction, configuration and general handling of Excel
Basic functionality; menu; ribbon; cells; rows and columns; quick access bar; mouse use; keyboard preferences.
7 videos, 2 readings, 3 questionnaires

Week 2

Working with the spreadsheet
Data entry; cells, ranges, cell names; autocomplete; basic cell formatting: numbers, borders, colors. Inserting and deleting cells, rows and columns; structure of functions; main basic functions: autosum, average, maximum, minimum, conditional.
8 videos, 2 readings, 3 questionnaires

Week 3

Copy, paste and move cells
Copy options: simple, transposed, functions, values; absolute and relative references; moving cells; implications.
7 videos, 1 lecture, 2 questionnaires

Week 4

Analyzing information
Sorting information; multiple criteria; automatic filters; using different criteria; combining functions and filters; advanced filters; setting columns and rows.
8 videos, 1 lecture, 1 questionnaire