Excel for Data Analysis
4.3 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
29 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel for Data Analysis to your Wishlist.

Add to Wishlist

Excel for Data Analysis

An introductory course to Excel 2013
4.3 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
29 students enrolled
Created by JP EXCEL
Last updated 6/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand the structure of an excel formula
  • Use formulas to summarize information in a report
  • Built and modify pie and column charts
  • Transform a set of data in an organized report using graphs and formulas
  • Reduce your time reapiting reports using the copying procedures
View Curriculum
Requirements
  • Excel software
Description

Every single enterprise generate numerical information almost every day. This kind of information is a valuable map as of the enterprise as of the market where the business belongs to, but only less than 20% of it ,is analyzed and use to made decisions.

The most popular software to analyze numerical information is Excel. This software has huge capabilities to transform data in readable information.

If you want to start to learn and use excel in your work or you are already using excel but you don´t use excel formulas to make your job, this course is for you.

At the end of this course you will be able to:

  • Understand the structure of the most important excel formulas used to summarize and analyze information.
  • Make a report using excel formulas and including pie and columns charts on it.
  • Repeat the same report in a short time using the copying procedures, reducing your time on this routines.

This course has been structured in five chapter and 22 lessons, in which there are an explanation of the topic and at least one example will be develop to improve your comprehension of each proposed topic.

Who is the target audience?
  • This is a course for people who want to start to use excel in your job or people who is already using excel but don't write formulas to make reports and wants to start to do it.
  • People who already know how to use excel formulas and can modify different kind of charts in their daily excel job, shouldn't take this course
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Basic Tools
2 Lectures 07:03
Cells Format
04:51

Use of Filters
02:12
+
Copy and Paste
2 Lectures 05:50
Copy and Paste 1
02:22

Copy and Paste 2
03:28
+
Functions
14 Lectures 35:59
IF FIRST PART
02:34

IF FUNCTION SECOND PART
02:40

And
02:16

Or
02:21


Max and Min
01:29

Average
01:26

Vlookup
03:29

Count
01:23

Countif
02:40

Countifs
02:30

Sum
00:58

Sumif
04:36

Sumifs
04:36
About the Instructor
JP EXCEL
4.3 Average rating
2 Reviews
29 Students
1 Course
MATHEMATICIAN

Hi my name is Jean Paul, I am a mathematician and I am a teacher. I work in Procredit bank where I started to develop my skills in excel. I design some measurement tools and i improved other ones. Then I designed a course fore some specific people in the bank. after that course I could see how people could reduce their time doing difficult task using excel formulas correctly. In this moment I have decided to share my knowledge with more people because most of the universities doesn't teach about the use of this strong and beautiful tool. I know that there are a lot of thinks I have to improve in this course because this way to teach is for me new. So I expect of all of you a feedback and all suggestions will be welcome. If you have an additional question or requirement please let me know. I have a lot of experience as in excel and as a teacher so I am sure that I can, and it will be a privilege for me, support your learning process.

Enjoy your course!!.

Jean Paul.