Excel 2013 Data Analyst Intermediate Training

Learn awesome data analysis with this online Excel course
4.3 (35 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,098 students enrolled
Take This Course
  • Lectures 18
  • Length 1.5 hours
  • Skill Level Intermediate 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 12/2013 English

Course 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

What are the requirements?

  • Have Excel installed on your PC

What am I going to get from this course?

  • Conditional formatting
  • Subtotals
  • Data validation
  • Pivot tables
  • Slicers and timelines
  • Charts
  • PivotCharts
  • Sparklines

Who is the target audience?

  • Anyone with at least a basic level in Excel

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.


Section 1: Getting started
Course overview
Working files
Section 2: Data analysis basics
Getting visual with conditional formating
Using subtotals for summarizing data
Using data validation
Section tasks
Section 3: Using pivot tables
The Pivot Table concept
Building a Pivot Table
Fine tuning the Pivot
Slicers and timelines
Section tasks
Section 4: Using charts
Excel Chart types
Adding data to a Chart
Chart customization
Pivot Charts
Section tasks
Section 5: Closing the course
Course summary
11 questions

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Radu Popa, 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.

Ready to start learning?
Take This Course