Microsoft Excel 365: Basics
In this course, you will learn how to use Microsoft Excel to edit, sort, filter and analyse your data in tables and lists. You will learn how to display tables and figures according to your own requirements. You will also optimise the view of extensive tables for screen and print. You will know how to calculate figures and how to use various functions. You will be able to visualise your figures in a meaningful way using diagram functions. Finally, you will also learn how to protect your data in Excel.
General information
| Duration | 12 hours |
|---|
- Customise basic Excel settings
- Manage tables and folders
- Entering and manipulating data
- Automatic filling of data series
- Formatting cells and number formats
- Simple calculations using formulas and functions
- Absolute and relative cell references
- Simple grouping, sorting and filtering of data
- First visualisations (conditional formatting, chart function)
- Optimising tables for screen and print
- Protecting cell contents
Microsoft365 account of the University of Zurich.
Students and employees of the University of Zurich.
Excel for Windows is used in this course. Participation with a Mac is generally possible, as the functions shown are almost identical. However, the presentation may differ.
Dates
| Code | Referents | Dates | Available seats | Place | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are currently no open courses | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||