Excel for Data Analysis
4.3 (2 ratings)
29 students enrolled
Wishlisted Wishlist

Excel for Data Analysis

An introductory course to Excel 2013
4.3 (2 ratings)
29 students enrolled
Created by JP EXCEL
Last updated 6/2015
English
Current price: \$10 Original price: \$20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
• 1 hour on-demand video
• 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
22 Lectures
58:00
+
Introduction
4 Lectures 09:08
+
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

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