Kursprogramm des HS17:

Das Programm für das Herbstsemester 2017 ist ab Anfang August online. Eine Anmeldung ist ab dem 01.09.2017 möglich.



Bitte beachten Sie vor Ihrer Kursanmeldung unsere Allgemeine Teilnahmebedingungen. Vielen Dank!


Zum Abmelden von Kursen gehen Sie bitte auf Ihre Teilnehmenden-Homepage .



Kontakt:

kurssekretariat@id.uzh.ch


MS Excel 2016: Data Analysis and Data Visualization (Windows)

This course is intended for people who want to deepen their Excel skills.

In this course, you will learn how to use the most important functions and tools for your data analysis and to display the results optimally. In practice-oriented examples, you gain knowledge of how you can analyze your data using a pivot table in seconds. In addition, you are able to distinguish between different types of diagrams and to design diagrams for the presentation of your analysis.

Content
  • Setting Up Tables (Screen and Print)
  • Arranging data (sorting and filtering)
  • Consolidate data (including duplicates)
  • Import data from external sources (text files, Access)
  • Data analysis with functions (database and statistics)
  • Grouping and compiling the data with pivot tables
  • Visualize the data through diagrams (different types, design, templates)
  • Present forecasts with trend lines
  • Working with Sparklines

Voraussetzungen

You are able to start Excel, manage documents, enter text, and shape the font image.

Teilnehmende

Students and employees of the University of Zurich

Kursunterlagen

Bemerkungen

Please bring a USB stick with you to take home the created course work. The course is based on MS-Office version 2016 (Windows). The course language is English. However, the course instructor is able to answer questions that are asked in German.

Durchführung

Kurs WEC 2
Freie Plätze:5
Dauer:1 Tag(e) / 6 Stunde(n)
Kursleitende:David Gabathuler
Teilnehmerzahl:Min: 7
Max: 24
Ort:Windows-Schulungsraum der Informatikdienste, Rämistrasse 74, Zentrum (rechter Nebeneingang, Erdgeschoss, Tramhaltestelle «Kantonsschule» Nr. 5 oder 9)
RAI-E-131
Datum/Zeit:
Freitag, 6. Oktober 201709:00 - 16:00
Veranstaltungs-Infos als ICS Feed