Tutorialspoint

The complete Excel crash course for data analysis

A no-nonsense primer on everything you need to become a star Analyst, taught by an ex-BCG consultant and ex-Amazon PM

Course Description

Do you want to become known as the 'Superstar Analyst' on your team? Want to deliver rapid analysis and insights, but unsure where to start with the various formulas? Still, slowly clicking around in messy Excel workbooks?

Excel mastery is an upfront investment that will save you thousands of hours throughout your career. This was one of the best personal investments I ever made which was further honed as a BCG consultant and Amazon PM. I would like to pass my best learnings on.

Consultants, Business Analysts, Data Analysts, and Business Intelligence Engineers pride themselves on rapidly delivering beautiful, dynamic, and structured analysis. If you work in this field, mastering Excel is essential.

After this crash course, you will know exactly how to do that. We will walk through examples of all the important formulas a superstar analyst needs to know, and the little-known shortcuts to do it faster than anyone else.

By the end of this course, you will:

  1. Master all the important formulas in Excel that matter, without getting overwhelmed by less important details

  2. Know the best practices used by top analysis in consulting and Amazon

  3. Understand when and how to use each formula - you will shine in delivering workbooks that are beautiful and insightful, not just correct

Who this course is for:

  • This is a fast-paced, intermediate to advanced course. It is not recommended for those completely new to Excel

Goals

  • Navigate quickly around Excel (without using a mouse)

  • Clean data in preparation for data analysis

  • Use dynamic formulas to conduct detailed data analysis

  • Use beautiful and best-in-class formatting

  • Structure your workbook to be clear and auditable

Prerequisites

  • You should have a basic understanding of Excel or more to fully benefit from this course

Show More

Curriculum

Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
The complete Excel crash course for data analysis
This Course Includes
  • 1.5 hours
  • 40 Lectures
  • 1 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

sample certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate

Talk to us

1800-202-0515