Excel 2013 Data Analyst Intermediate Training
3.9 (38 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.
1,107 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2013 Data Analyst Intermediate Training to your Wishlist.

Add to Wishlist

Excel 2013 Data Analyst Intermediate Training

Learn awesome data analysis with this online Excel course
3.9 (38 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.
1,107 students enrolled
Created by Radu Popa
Last updated 6/2014
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 5 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Conditional formatting
  • Subtotals
  • Data validation
  • Pivot tables
  • Slicers and timelines
  • Charts
  • PivotCharts
  • Sparklines
View Curriculum
Requirements
  • Have Excel installed on your PC
Description

Short and Concise - no fillers or fluff!

A big "thank you" to the course instructor for going straight into the point and showing me how each feature works while elaborating on the use of them in the real world. It was very easy to understand all the lessons which averages only about 5-8 minutes each.

Very good excel course!

The course is well structured, easy to follow, it has good content, nice visuals and practical examples. I recommend it!


Focused on data analysis

The Excel Data Analyst course is a course focused helping you take advantage of all MS Excel data analysis tools. It is not a generic course and this gives me the possibility to take the time and go into detail on the covered topics.

Learning Excel is not just about knowing Excel

This course should not be only about learning Excel because is not enough. It should be about taking advantage of all the Excel features to help you in your everyday professional and personal life. It should be about that report that you create that will blow people away and get you noticed or that family budget that will help you find out what drains your money away.

The course is split into 3 main sections.

  • Data analysis basics
  • Using pivot tables
  • Using charts

After each section we have a task list that will help you put the information into practice. All the working files will be available for later use.

In this 90 minutes training you will learn the following:

  • Conditional formatting
  • Subtotals
  • Data validation
  • Pivot tables
  • Slicers and timelines
  • Charts
  • Pivot charts
  • Sparklines
Who is the target audience?
  • Anyone with at least a basic level in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
18 Lectures
01:41:25
+
Getting started
2 Lectures 04:39

Working files
00:18
+
Data analysis basics
4 Lectures 25:54
Getting visual with conditional formating
10:45

Using subtotals for summarizing data
06:31

Using data validation
07:51

Section tasks
00:47
+
Using pivot tables
5 Lectures 30:57
The Pivot Table concept
03:50

Building a Pivot Table
06:24

Fine tuning the Pivot
12:52


Section tasks
00:17
+
Using charts
6 Lectures 37:44
Excel Chart types
11:31


Chart customization
09:23

Pivot Charts
05:35

Sparklines
03:51

Section tasks
00:19
+
Closing the course
1 Lecture 01:01
Course summary
01:01

Glad you made this far, please take the time to go through this brief quizz to check your knowledge.

Quiz
11 questions
About the Instructor
Radu Popa
3.5 Average rating
90 Reviews
3,363 Students
3 Courses
Technical trainer

Hello, my name is Radu and I live in Romania. That's a country in Europe :) 

I own a training and recruitment company and I blogging and online training is one of my passions. 

Even though I graduated a computer science faculty some during the last study years I decided I don't want to be a software developer but rather work in Human Resources. 4 years of volunteering experience in AIESEC got me very interested in working with people and helping them grow.

So far I have worked in 4 very different companies, a small Dutch-Romanian IT company, a multinational manufacturing corporation, a Romanian HR Consultancy company and in a Swiss-Romanian consultancy company. Now I work in my own company.

Even though I have worked as a HR professional in all these places, my computer science background made me always look for ways in which technology can help me do my work in a more efficient, better and maybe even fun way.