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 Instructor Dates Available seats Venue
HS25-WEA-01 Stolz Barbara Fri 09 January 2026 (09:00am - 12:00pm)
Fri 16 January 2026 (09:00am - 12:00pm)
Fri 23 January 2026 (09:00am - 12:00pm)
Fri 30 January 2026 (09:00am - 12:00pm)
Online Course Register
FS26-WEA-02 Falone Francesco Wed 18 February 2026 (09:00am - 12:00pm)
Wed 25 February 2026 (09:00am - 12:00pm)
Wed 04 March 2026 (09:00am - 12:00pm)
Wed 11 March 2026 (09:00am - 12:00pm)
19 Universität Zürich Irchel Register
FS26-WEA-01 Stolz Barbara Fri 05 June 2026 (09:00am - 12:00pm)
Fri 12 June 2026 (09:00am - 12:00pm)
Fri 19 June 2026 (09:00am - 12:00pm)
Fri 26 June 2026 (09:00am - 12:00pm)
Universität Zürich Irchel Course registration begins on 1 February for the spring semester and on 1 September for the autumn semester.