Excel for Data Analysis

An introductory course to Excel 2013
5.0 (1 rating) 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.
21 students enrolled
$20
Take This Course
  • Lectures 22
  • Contents Video: 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English

Course 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.

What are the requirements?

  • Excel software

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction
Preview
02:20
Excel Structure
Preview
01:46
Basic Operations
Preview
02:01
Excel Functions
Preview
03:01
Section 2: Basic Tools
Cells Format
04:51
Use of Filters
02:12
Section 3: Copy and Paste
Copy and Paste 1
02:22
Copy and Paste 2
03:28
Section 4: Functions
IF FIRST PART
02:34
IF FUNCTION SECOND PART
02:40
And
02:16
Or
02:21
Iferror
Preview
03:01
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

JP EXCEL, 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.

Ready to start learning?
Take This Course