- 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
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
Code | Referents | Dates | Available seats | Place | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
There are currently no open courses |