Buying for a Team? Gift This Course
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
4.2 (34 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,102 students enrolled
Created by Radu Popa
Last updated 6/2014
$10 $20 50% off
2 days left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 5 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Conditional formatting
Data validation
Pivot tables
Slicers and timelines
View Curriculum
  • Have Excel installed on your PC

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
Expand All 18 Lectures Collapse All 18 Lectures 01:41:25
Getting started
2 Lectures 04:39

Working files
Data analysis basics
4 Lectures 25:54
Getting visual with conditional formating

Using subtotals for summarizing data

Using data validation

Section tasks
Using pivot tables
5 Lectures 30:57
The Pivot Table concept

Building a Pivot Table

Fine tuning the Pivot

Section tasks
Using charts
6 Lectures 37:44
Excel Chart types

Chart customization

Pivot Charts


Section tasks
Closing the course
1 Lecture 01:01
Course summary

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

11 questions
About the Instructor
4.2 Average rating
78 Reviews
3,329 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.

Report Abuse