Data & AI

Exploratory Data Analysis using Microsoft Excel

This course takes the participants through the data analysis workflow tasks: from ingesting, cleaning and transforming data, to basic data analysis and visualization, all using Microsoft Excel.

The course will cover logical functions for conditional decision-making, text processing functions for data cleaning, look-up functions to extract data from our dataset, and selection of charts based on the type of data and analysis desired.

After completing the course you will have the basic tools needed to use Excel to begin your data analysis journey and will have the foundation needed to further develop your knowledge of Excel.

Content

Introduction: What is Exploratory Data Analysis

Start the Data Analysis flow : Ingest
- Getting data from CSV or TXT files
- Getting data from images of tables
- Getting data from the web

Your data is not perfect : Transform
- Excel functions to detect missing data
- Deciding what to do: excel conditionals (IF / SWITCH / CHOOSE )
- Excel functions to transform data types (VALUE / TEXT )
- Extract text : LEFT/RIGHT/MID/FIND, TEXTSPLIT, TEXTAFTER
- Interpolation using FORECAST

What does the data tell you : Analyse
- Using Excel conditionals (SUMIF / COUNTIF)
- Using excel min/max/average/STD.DEV functions
- Using excel lookup functions (XLOOKUP, VLOOKUP, Index+Match combinations)

Building the data story : Visualize
- basic chart types: lines, bars, histograms, scatters.
- what to use when selecting a type of chart
- when chats are misleading

Learning Outcomes

After completing the course, the participants will be able to:

  • Understand and use the various options Excel provides to import data
  • Use excel functions to identify missing or incorrect data
  • Use conditionals to determine what data needs correcting and how to correct it
  • Use the available excel functions to compute basic data metrics and statistics
  • Use scatter plots, bar plots, histograms, or cumulative frequency plots to present insights about the data
Training Method

Classroom delivery coupled with use cases and interactive sessions.

Organised By
Digital Learning Hub Luxembourg
Digital Learning Hub Luxembourg
Certification
Participation Only
Prerequisites

Basic knowledge of Excel


Planning and location
Session 1
22/02/2025 - Saturday
09:00 - 17:00
Session 2
01/03/2025 - Saturday
09:00 - 16:00
Available Edition(s):

https://www.dlh.lu/web/image/product.template/1467/image_1920?unique=93ab901

This combination does not exist.

52.00 € 52.0 EUR 52.00 €

52.00 €

Not Available For Sale

Your trainer(s) for this course
Luis EMILIANI
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!