Excel 2013 Data Analyst Intermediate Training

Learn awesome data analysis with this online Excel course
4.2 (32 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,090 students enrolled
$20
Take This Course
  • Lectures 18
  • Contents Video: 1.5 hours
    Other: 4 mins
  • 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

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

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

Curriculum

Section 1: Getting started
Course overview
Preview
04:21
Working files
Article
Section 2: Data analysis basics
Getting visual with conditional formating
10:45
Using subtotals for summarizing data
06:31
Using data validation
07:51
Section tasks
Article
Section 3: Using pivot tables
The Pivot Table concept
03:50
Building a Pivot Table
06:24
Fine tuning the Pivot
12:52
Slicers and timelines
Preview
07:34
Section tasks
Article
Section 4: Using charts
Excel Chart types
11:31
Adding data to a Chart
Preview
07:05
Chart customization
09:23
Pivot Charts
05:35
Sparklines
03:51
Section tasks
Article
Section 5: Closing the course
Course summary
Article
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. I work as a trainer and consultant in a very cool Romanian company (ROMCOM) and I am focused mainly on the technical and technology side.

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 now in a Swiss-Romanian consultancy 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. About this topic I also started a blog called freshcomputerskills.

Ready to start learning?
Take This Course