Using Excel for Exploratory Data Analysis (S-IT0072)

Wie lange dauert die Weiterbildung?

8,00 Stunde(n)

1 jour

In welcher/n Sprache(n) wird die Weiterbildung angeboten?

Wann findet der nächste Termin statt?

Wer bietet diese Weiterbildung an?

Le Luxembourg Lifelong Learning Centre (LLLC), le centre de formation continue de la Chambre des salariés, dispose d'une large gamme de formations continues qui s’adressent à tout un chacun. Son offre de formation a pour objet de doter les apprenants pour autant que possible du savoir-faire approprié pour maîtriser un environnement de travail, des processus et des technologies, voire des aptitudes sociales, en constante évolution, et ce pour sécuriser au maximum leurs parcours professionnels. Le LLLC propose une panoplie importante de formations: des cours du soir; des séminaires, qui peuvent être adaptés sur mesure selon les besoins des entreprises; des formations universitaires; des formations spécialisées; des formations pour seniors; des certifications professionnelles.

Mehr sehen

Der Inhalt dieser Seite ist nicht auf Deutsch verfügbar

An wen richtet sich die Weiterbildung?

Individuals who want to learn the principles of exploratory data analysis and how to apply Excel’s features for data exploration.

Welche Voraussetzungen müssen erfüllt sein?

To extract the most from the course, students should have good grasp of Excel’s features such as inserting formulas, fixed and moveable referencing, inserting and customizing charts, applying conditional formatting using formulas, and data validation principles. Additionally, good understanding of operations such as percentages, proportions, raising to a power, averages and the use of logical operators (greater than, less than, not equal to) is required.

Welche Ziele werden verfolgt bzw. welche Kompetenzen sollen erworben werden?

Describe the purpose and principles of Exploratory Data Analysis and learn the main descriptive statistics.
Learn the principles and functions used to subset data in Excel (logical indexing and conditional selection, FILTER) and for implementing conditional aggregations using direct methods (SUMIF, AVERAGEIF, MINIF).
Learn to expand Excel’s capabilities using LET functions.
Create visualizations to summarize data and identify trends: histograms, scatter plots, bar charts, box-plots.

Wie sieht der Inhalt der Weiterbildung aus?

This course provides you with the tools to conduct exploratory data analysis (EDA) using advanced excel functions and statistical charts. After completing the course, participants will be able to use Excel effectively to derive insights from their data and to communicate their observations effectively using charts in Excel.

Exploratory data analysis, descriptive statistics, and Excel’s functions to compute measures of tendency and spread.
Logical operations and developing conditional decision making (IF,SWITCH and the conditional aggregation functions).
Filtering arrays and selecting data using logical indexing.
Use the data analysis toolpak add-in for correlation and histogram analysis, and use native charts such as scatter, bar charts and box-plots for data spread visualisation.