Introduction to Exploratory Data Analysis using Excel
This course takes the participants through the data analysis flow: from ingesting and transforming data, to basic analysis and visualization, using Microsoft Excel, reviewing the basic principles around Exploratory Data Analysis and Statistics, applied to univariate and bivariate data exploration.
Content
- What is Exploratory Data Analysis
- Overview of Key Excel features useful for EDA
- Describing data and relationship between variables (univariate analyses and bivariate analyses)
- The Data Analysis Flow - Start the Data Analysis flow: Ingest
- Your data is not perfect: Transform
- What does the data tell you: Analyse
- Use cases and case studies
Learning Outcomes
- Learn the principles of EDA, univariate and bivariate data exploration
- Learn to use EXCEL as part of the data analysis cycle
- Excel for data ingestion
- EXCEL for split-apply-combine actions (data segmentation, conditional operations and summarization)
- EXCEL for basic statistics/data metrics functions
- Learn when to use and how to prepare key visualizations : scatter plots, bar plots, histograms, and cumulative frequency plots
Training Method
Classroom delivery with hands-on application via use cases in highly interactive sessions.
Organised By
Digital Learning Hub Luxembourg
Certification
Participation OnlyPrerequisites
Basic knowledge of Excel: such as opening/closing files, basic formatting of cells, use of basic formulas, copy/pasting in Excel
Planning and location
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
ESCO Occupations
Your trainer(s) for this course
Luis EMILIANI
Hi! I am Luis Emiliani. I have worked with Excel for 25 years now, automating reports and processes, developing scenario analyses and in general working with data in Excel. Over time I have picked a few tricks, which I plan to share with you in our sessions!