×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

Join Our Telegram Channel Now to Get Any New Free Courses : Click Here

MICROSOFT EXCEL FOR DATA ANALYSIS

Course Reviews

Track :

Computer Science
Course Presenter :

TUTORIAL

Lessons no : 26

For Free Certificate After Complete The Course

To Register in Course you have to watch at least 30 Second of any lesson

Join The Course Go To Community Download Course Content

What will you learn in this course?
  • Master data cleaning and manipulation techniques to prepare datasets for analysis using Excel tools and functions
  • Apply formulas, functions, and PivotTables to summarize and analyze large datasets efficiently in Excel
  • Create compelling data visualizations and charts to communicate insights clearly and effectively
  • Perform statistical analysis, including regression and correlation, to identify relationships within data sets
  • Utilize Excel's Data Analysis ToolPak and Solver for complex data modeling and optimization tasks
  • Leverage Power Query to automate data import, transformation, and refresh processes for dynamic analysis
  • Implement advanced Excel features to streamline data analysis workflows and improve accuracy
  • Interpret analytical results to make data-driven decisions in business, finance, and research contexts
  • Develop practical dashboards and reports that showcase key data insights for stakeholders
  • Enhance data analysis skills with real-world exercises and practical applications in Excel

How to Get The Certificate

  • You must have an account Register
  • Watch All Lessons
  • Watch at least 50% of Lesson Duration
  • you can follow your course progress From Your Profile
  • You can Register With Any Course For Free
  • The Certificate is free !
Lessons | 26
1Introduction MICROSOFT EXCEL LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL FOR BEGINNERS
00:09:31

1Introduction MICROSOFT EXCEL LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL FOR BEGINNERS
2 What is data analysis MICROSOFT EXCEL LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL FOR BEGINNERS
00:09:18

2 What is data analysis MICROSOFT EXCEL LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL FOR BEGINNERS
3 Excel important functions to know BASICS OF EXCEL LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL
00:20:02

3 Excel important functions to know BASICS OF EXCEL LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL
4 Condition formatting BASICS OF EXCEL LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL FOR BEGINNERS
00:10:50

4 Condition formatting BASICS OF EXCEL LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL FOR BEGINNERS
5 Creating our data base PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL
00:27:58

5 Creating our data base PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL
6 Defining our goals PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL
00:08:24

6 Defining our goals PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL
7 Extraction of basic data part 1 PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS
00:18:20

7 Extraction of basic data part 1 PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS
8 Extraction of basic data part 2 PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS
00:08:34

8 Extraction of basic data part 2 PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS
9 Extraction of advanced Data PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS
00:15:42

9 Extraction of advanced Data PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS
10 Creation of a dashboard part 1 PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS
00:12:22

10 Creation of a dashboard part 1 PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS
11 Creation of a dashboard part 2 PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS
00:13:45

11 Creation of a dashboard part 2 PROJECT 1 PROJECT ANALYSIS LEARN MS EXCEL FOR DATA ANALYSIS
12 Importation creation of a Data Base PROJECT 2 EVALUATION OF A STOCK MS EXCEL FOR DATA
00:03:26

12 Importation creation of a Data Base PROJECT 2 EVALUATION OF A STOCK MS EXCEL FOR DATA
13 Defining the goal of the analysis PROJECT 2 EVALUATION OF A STOCK MS EXCEL FOR DATA ANALYSIS
00:04:34

13 Defining the goal of the analysis PROJECT 2 EVALUATION OF A STOCK MS EXCEL FOR DATA ANALYSIS
14 Extraction of data PROJECT 2 EVALUATION OF A STOCK LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL
00:11:06

14 Extraction of data PROJECT 2 EVALUATION OF A STOCK LEARN MS EXCEL FOR DATA ANALYSIS TUTORIAL
15 Generating a simulation with our results PROJECT 2 EVALUATION OF A STOCK EXCEL FOR DATA ANALYSIS
00:07:35

15 Generating a simulation with our results PROJECT 2 EVALUATION OF A STOCK EXCEL FOR DATA ANALYSIS
16 Creation of a dashboard results evaluation PROJECT 2 EVALUATION OF A STOCK MS EXCEL COURSE
00:05:31

16 Creation of a dashboard results evaluation PROJECT 2 EVALUATION OF A STOCK MS EXCEL COURSE
17 Creation of a data base for one user 05 Project 3 Create a basic movie suggestion program EXCEL
00:08:02

17 Creation of a data base for one user 05 Project 3 Create a basic movie suggestion program EXCEL
18 Defining the goal of the app 05 Project 3 Create a basic movie suggestion program EXCEL COURSE
00:04:45

18 Defining the goal of the app 05 Project 3 Create a basic movie suggestion program EXCEL COURSE
19 Extraction of data results analysis 05 Project 3 Create a basic movie suggestion program
00:12:26

19 Extraction of data results analysis 05 Project 3 Create a basic movie suggestion program
20 Dashboard creation 05 Project 3 Create a basic movie suggestion program EXCEL FOR DATA ANALYSIS
00:10:23

20 Dashboard creation 05 Project 3 Create a basic movie suggestion program EXCEL FOR DATA ANALYSIS
21 Creation a data base Project 4 Creation of a HR management APP EXCEL FOR DATA ANALYSIS
00:05:22

21 Creation a data base Project 4 Creation of a HR management APP EXCEL FOR DATA ANALYSIS
22 Defining all the goals of the app Project 4 Creation of a HR management EXCEL FOR DATA ANALYSIS
00:02:53

22 Defining all the goals of the app Project 4 Creation of a HR management EXCEL FOR DATA ANALYSIS
23 Creation of the app part 1 Project 4 Creation of a HR management APP EXCEL FOR DATA ANALYSIS
00:22:33

23 Creation of the app part 1 Project 4 Creation of a HR management APP EXCEL FOR DATA ANALYSIS
24 Creation of the app part 2 Project 4 Creation of a HR management APP EXCEL FOR DATA ANALYSIS
00:06:30

24 Creation of the app part 2 Project 4 Creation of a HR management APP EXCEL FOR DATA ANALYSIS
25 Creation of the App part 3 Project 4 Creation of a HR management APP EXCEL FOR DATA ANALYSIS
00:16:16

25 Creation of the App part 3 Project 4 Creation of a HR management APP EXCEL FOR DATA ANALYSIS
26 Creation of the App part 4 Project 4 Creation of a HR management APP EXCEL FOR DATA ANALYSIS
00:10:18

26 Creation of the App part 4 Project 4 Creation of a HR management APP EXCEL FOR DATA ANALYSIS


We Appreciate Your Feedback

Excellent
2 Reviews
Good
1 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews
4.7
3 Reviews
Mudasiru Olamide Rokeeb

This is a great platform of learning <br /> <br /> Kudos to the tutor. 2025-09-05

wanjiku Fidelis

excellent 2024-07-18

Edris siraj mear

It wose good 2024-06-04

Show More Reviews

Our New Certified Courses Will Reach You in Our Telegram Channel
Join Our Telegram Channels to Get Best Free Courses

Join Now

Related Courses

Linear Algebra for Computer Scientists
7 Lessons

Linear Algebra for Computer Scientists

Insertion Sort
3 Lessons

Insertion Sort

Bubble Sort
4 Lessons

Bubble Sort

GCSE Computer Science
18 Lessons

GCSE Computer Science

Random Access Memory
7 Lessons

Random Access Memory

Binary Trees
4 Lessons

Binary Trees

Bitwise Operators
4 Lessons

Bitwise Operators

Introduction to Stacks Data Structures
17 Lessons

Introduction to Stacks Data Structures

Organization Theory Structure and Design
41 Lessons

Organization Theory Structure and Design

Handling Large Scale Unit Level Data
41 Lessons

Handling Large Scale Unit Level Data

Introduction to Machine Learning
19 Lessons

Introduction to Machine Learning

Applied Linear Algebra Vectors Matrices
54 Lessons

Applied Linear Algebra Vectors Matrices

Artificial Intelligence beginners
1 Lessons

Artificial Intelligence beginners

Machine Learning Autumn 2018
1 Lessons

Machine Learning Autumn 2018

Robotics and Autonomous Systems
15 Lessons

Robotics and Autonomous Systems

Natural Language Understanding
15 Lessons

Natural Language Understanding

MICROSOFT EXCEL - EXCEL FOR DATA ANALYSIS Course: In this course, you will delve into using Microsoft Excel as a powerful tool for data analysis. Learn essential techniques for data cleaning, data manipulation, and data visualization. Explore functions, formulas, and PivotTables to summarize and analyze large datasets. Gain insights into statistical analysis, regression, and correlation. Discover advanced features like Solver, Data Analysis ToolPak, and Power Query for more complex data analysis tasks. With practical examples and hands-on exercises, this course equips you with the skills to effectively analyze and visualize data using Microsoft Excel. Whether you're a beginner or seeking to enhance your data analysis abilities, this course provides a comprehensive guide to leveraging Excel for data analysis. TUTORIAL