1Η επαλήθευση EdTech βρίσκεται σε εξέλιξη...
logo-issuer

Εκδόθηκε από SAA School of Management - Università degli Studi di Torino

SAA School of Management, Business School dell'Università degli Studi di Torino

Ημερομηνία κυκλοφορίας


05/12/2025

Ημερομηνία Λήξης


Ποτέ

Κωδικός σήματος


1086009

Ημερομηνία της εκδήλωσης:


Από 11/10/2024 ανά 10/12/2024

Διάρκεια:


20 h

Περιγραφή:


  1. Main features of Microsoft Excel; sheets, cells and their contents, referencing, naming cells and ranges, elementary operations, first excel embedded functions, connections between cells, arrays, tables, elementary linear algebra, charts. Logic tests for conditional works.
  2. Dynamic arrays (the latest big revolution of Excel which makes Excel closer and closer to a programming language, with an easier approach) and spill functions. Dynamic named ranges for more automatic tasks and more readable files.
  3. Some hints on some important Excel tools: Power Query to get and clean data from different sources, Pivot Tables for data analysis, Power Pivot Table for deeper data modeling


Κριτήρια έκδοσης:


Students must attend at least 4 out of 7 lessons.

Άλλες πληροφορίες:


Students will have to work on their own computers, replicating operations and working on tasks. Almost all the skills obtained can be used when working with Google Sheets or Microsoft PBI.