Microsoft Excel - Learn MS EXCEL For DATA Analysis
4.1 (1,250 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
66,245 students enrolled

Microsoft Excel - Learn MS EXCEL For DATA Analysis

Excel: learn how Excel can be used for data analysis by creating excel project-excel app-other excel tools
4.1 (1,250 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
66,245 students enrolled
Created by Yassin Marco
Last updated 4/2020
English
English [Auto]
Current price: $41.99 Original price: $59.99 Discount: 30% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn to write down basic excel formulas
  • Understand how to think outside of the box to create powerful excel projects
  • Learn how to make basic data analysis with Excel
  • Learn how to work with massive amount of data
Requirements
  • Having microsoft excel
  • Having a minimum of knowledge about this app
Description

If you want to learn how to use Excel to be able to perform different task, this course is definitely for you!!

Excel is one of the most popular apps used today and is a very important asset to know to survive in the business world. My goal with this course is really help you better understand how this app works and how it can be properly used for data analysis and other things. Also this course will give you the opportunity to exercise your knowledge with four major projects that will be done.

Who this course is for:
  • People interested to get new skills
  • People who want to learn Excel by creating projects themselves
Course content
Expand all 27 lectures 04:48:24
+ The Bases of Excel
2 lectures 30:50
Excel important functions to know
20:01
Condition formating
10:49
+ Project 1: Project analysis
7 lectures 01:44:58
Creating our data base
27:57
Defining our goals
08:23
Extraction of basic data (part 1)
18:19
Extraction of basic data (part 2)
08:33
Extraction of advanced Data
15:41
Creation of a dashboard part 1
12:21
Creation of a dashboard part 2
13:44
+ Project 2 evaluation of a stock
5 lectures 32:07
Importation and creation of a Data Base
03:25
Defining the goal of the analysis
04:33
Extraction of data
11:05
Generating a simulation with our results
07:34
Creation of a dashboard and results evaluation
05:30
+ Project 3: Create a basic movie suggestion program
4 lectures 35:33
Creation of a data base for 1 users
08:02
Defining the goal of the app
04:44
Extraction of data and results analysis
12:25
Dashboard creation
10:22
+ Project 4: Creation of a HR management APP
6 lectures 01:03:48
Creation a data base
05:22
Defining all the goals of the app
02:53
Creation of the app part 1
22:32
Creation of the app part 2
06:29
Creation of the App part 3
16:15
Creation of the App part 4
10:17