- 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: 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
- Accessibility@UZH in the CMS
- Images for your Website
- CMS Introduction Magnolia
- Creating and Publishing Web Pages
- Basic Introduction to JavaScript
- UZH365: Task management with Microsoft Planner
- 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
- UZH365: Outlook Desktop Productivity Training
- UZH365: SharePoint Basics
- TOPdesk: Hands-on Essentials
- Data Science
- QGIS Desktop Basics
- 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
- R: Basic Introduction
- R: Crash Course in Statistics using R
- R: Reporting using Quarto & R Markdown
- R: tidyverse for Data Science
- UZH 365: Data Analysis and Visualisation with PowerBI
- Databases, Spreadsheet
- E-Learning
- Scientific Computing
- Text Processing & Publishing
- Knowledge Management
- UZH365: Digital Communication and Collaboration
- IT Courses from other Organisational Units of the UZH
MS Excel 365: Data Visualisation
Data is an indispensable part of the digital world of work. The effective visualisation of data is of great value to gain insights, identify trends, optimise decision-making processes and make complex information understandable for different audiences.
In this interactive course you will learn how to transform data into meaningful graphics and interactive dashboards using Microsoft Excel.
General information
| Duration | 4 hours |
|---|
- Prepare data for visualisation (tables and PivotTables).
- Visualise data with appropriate chart types (e.g. column, line, pie, bar charts, etc.)
- Adapt charts for better readability and more concise statements (e.g. axis titles, data labels, trend lines, etc.)
- Data visualisation with sparklines
- Visualise geodata or project data (e.g.: Gantt charts)
- Create meaningful, interactive dashboards (slicer, fliter, PivotCharts)
- Integration of visualisations in reports and presentations (e.g. in Word, PowerPoint, as a web part in SharePoint)
Participants will have the basics of spreadsheet analysis with Microsoft Excel (entering data, creating tables, formatting cells, simple formulas and functions) and have a basic understanding of data analysis (sorting, filtering, aggregating).
We recommend that you attend the course "MS Excel 365 - Transforming and Analysing Data with PowerQuery and PivotTables (WEP)" before attending this course or have otherwise familiarised yourself with transforming data.
We recommend that you attend the course "MS Excel 365 - Transforming and Analysing Data with PowerQuery and PivotTables (WEP)" before attending this course or have otherwise familiarised yourself with transforming data.
This course is aimed at all members of the University of Zurich who would like to specifically deepen their Excel knowledge in order to visualise data in a targeted manner.
Participants will be able to select the appropriate chart types for different data sets, create visualisations and communicate them in a targeted manner.
The learning content is taught interactively in a mixture of presentation, demonstration and practical exercise.
This course works with Microsoft Excel for Windows. Participation with the Excel version for Mac is possible in principle, but is made more difficult by the fact that not all functions are available and the menu display differs in places.
Dates