Microsoft Excel for Data Analysis
Self-paced video training — 7 modules, 27 lessons. Work through it at your own pace — every lesson is real recorded training, not slide-reading.
▶INSIDE THE COURSE · 27 LESSONSABOUT THIS COURSE
In this intermediate course, students will learn how to utilize Microsoft Excel for effective data analysis. The curriculum covers essential Excel functions, conditional formatting, and includes hands-on projects that involve creating databases, extracting data, and generating simulations. By the end of the course, students will be able to create dashboards and evaluate results, applying their skills to real-world data analysis scenarios.
CURRICULUM
7 modules, in order.
01Introduction2 LESSONS
an overview of the course content and objectives.
an introduction to the concept of data analysis.
02The Basics of Excel2 LESSONS
essential functions in Excel that are important for data analysis.
how to apply conditional formatting in Excel.
03Project 1 Project analysis7 LESSONS
steps to create a database for project analysis.
how to define objectives for your data analysis project.
methods for extracting basic data in your project.
continuing the extraction of basic data for analysis.
techniques for extracting advanced data for deeper insights.
how to create the first part of a data dashboard.
completing the creation of a dashboard for data visualization.
04Project 2 evaluation of a stock5 LESSONS
importing data and creating a database for stock evaluation.
how to define the goals for stock analysis.
extraction methods for data in stock evaluation.
creating simulations based on extracted stock data.
how to create a dashboard and evaluate the results of stock analysis.
05Project 3 Create a basic movie suggestion program4 LESSONS
creating a database tailored for a single user in a movie suggestion app.
defining the objectives for the movie suggestion application.
extracting data and analyzing results for the movie suggestion app.
how to create a dashboard for the movie suggestion app.
06Project 4 Creation of a HR management APP6 LESSONS
creating a database for the HR management application.
defining the goals for the HR management app.
initial steps in creating the HR management application.
continuing the development of the HR management app.
finalizing the creation of the HR management application.
this lesson covers the final steps in creating the HR management app.
07Conclusion1 LESSONS
this lesson summarizes the key points covered in the course.
CURATED BY
Selected from experienced educators' training libraries and kept whole — modules, worked examples and walkthroughs exactly as taught.
GOOD TO KNOW
Lessons stream in the browser and remember where you stopped.
Watch on two devices at once — phone, tablet or desktop.
Download buttons are disabled; delivery is encrypted and authenticated per request.
$59 · ONE PAYMENT
Own every lesson, for life.
One payment unlocks all 27 lessons instantly — start with lesson one the moment you check out.