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
Certification
Participation OnlyPrerequisites
Basic knowledge of Excel
Planning and location
09:00 - 17:00
09:00 - 16: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!