- Home
- Participant Homepage
- Course Offers
- Current Course Programme
- Operating Systems & Programming
- Digitale Selbstverteidigung: Einführung in die IT-Sicherheit für Anwender:innen
- Linux: Bash Workshop (TheAlternative.ch)
- Linux: Introduction to Open Source Software (TheAlternative.ch)
- Python: Machine Learning for Beginners
- Git: Continuous Integration und Deployment in GitLab@UZH
- Python: Basics
- Python: Automatisierung, Web-Scraping, Bildbearbeitung
- Python: Intermediate
- Microsoft Power Automate: Digitalisierung erster Prozesse
- Science IT: Linux Command Line
- Image Editing, Illustration and Presentation
- Collaboration, Social Media and Webpublishing
- CMS: Create accessible websites
- Social Media and Science Communication
- Images for your Website
- CMS Introduction Magnolia
- Creating and Publishing Web Pages
- Basic Introduction to JavaScript
- UZH365: Create an Intranet with SharePoint
- UZH365: Basics of collaboration in the cloud
- UZH365: Effective communication with teams Telephony
- UZH365: Microsoft Outlook (im Web) Grundlagen
- Microsoft Planner: Task management with Kanban
- UZH365: Outlook Desktop Productivity Training
- UZH365: SharePoint Basics
- TOPdesk: Hands-on Essentials
- Data Science
- QGIS: Spatial data analysis and map creation
- Python: Introduction to Natural Language Processing (NLP)
- Python: For the Digital Humanities
- Einführungskurs in das Statistikpaket SPSS
- Introduction to Programming with MATLAB
- Qualitative Datenanalyse mit MAXQDA
- Python: Data Analysis Essentials
- PowerBI Data Analysis and Visualisation
- R: Basic Introduction
- R: Crash Course in Statistics using R
- R: Reporting using Quarto & R Markdown
- R: tidyverse for Data Science
- Databases, Spreadsheet
- E-Learning & Examination
- Scientific Computing
- Text Processing & Publishing
- Knowledge Management
- UZH365: Digital Communication and Collaboration
- IT Courses from other Organisational Units of the UZH
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