Business Data Analytics in Excel

Sean Thompson

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
29 Videos (5h 10m)
    • Course Intro

      3:27
    • What is a Data Analyst?

      6:17
    • The Role of a Data Analyst

      12:08
    • The characteristics of a Data Analyst

      4:13
    • Thinking Like a Data Analyst

      13:16
    • Analyst Role Models

      8:45
    • Introduction

      8:03
    • Introduction to Excel

      27:58
    • Formatting in Excel

      24:28
    • Copy & Paste in Excel

      8:07
    • Sorting Data in Excel

      8:03
    • Naming Cells & Ranges in Excel

      11:37
    • Removing Duplicates in Excel

      2:59
    • Setting the Print Area & Freezing Panes

      12:08
    • Text to Columns

      10:19
    • Basic Formulas in Excel

      31:20
    • Intermediate Excel Introduction

      1:26
    • Intermediate Formulas in Excel

      2:45
    • If Statements

      6:20
    • Sum if Formula

      6:54
    • Count if Formula

      3:20
    • If or Statements

      5:16
    • If and Statements

      14:48
    • Lookup Formulas

      9:17
    • Hands on with Lookup Formulas

      11:39
    • Introduction to Pivot Tables

      5:02
    • Hands-on with Pivot Tables

      29:17
    • GetPivot Formula

      4:26
    • Hands-on with GetPivot

      16:29

About This Class

Learn Business Data Analytics Using Microsoft Excel including Pivot Tables, Vlookups and much more

The goal of the course is to build you into a Business Data Analyst from the ground up. We do this by giving you the necessary training through hands-on practical exercises. The Data Analyst Training Course will prepare you for real-world data analysis and analytics and put you a step ahead.

Whether you are starting out, or well into your career and looking for a change, this course is for you. This course is for those who are hungry to learn and enhance their value. Regardless of your background, your level of education or the industry you currently work – this course is for you.

--

Students

--

Projects

0

Reviews (0)

Hi, I’m Sean

I am a seasoned Analyst with several years experience in a variety of different industries including Healthcare, Technology, and Finance. I have a passion for teaching and empowering others, and one way I decided to do that is through the Analyst Training Course.

I am intellectually curious by nature, a music lover, car enthusiast, and pretty decent golfer.

So what qualifies me to teach this course?

7+ years of experience as an Analyst
10...

See full profile