image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

***I will teach you the exact same Excel data analysis skills that took me 10,000+ hours to master in a fraction of the time! ***
Where do I start?
That’s the question I had when I wanted to learn
how to analyze data in Excel
.
I had the basics of Excel down, but
I wanted to become an Excel data wizard!
I heard of these Excel data Jedis that could
conjure up magic
in every spreadsheet!
They could do things that I never thought possible.
I wanted to be one of them!
But I didn't know how or have a path to
achieve my goal.
So what did I do?
Well, that's a
great question
. I’m glad you asked.
You see,
the answer is quite boring.
I got a job.
Yup, a job.
That’s probably not the answer you were expecting!
But it's true!
But what happened next was so incredible.
With that job,
I spent thousands of hours in Excel
.
Every single day,
I started and ended my day inside an Excel spreadsheet
.
I learned to love those hours.
It became like a game to me. I took raw data, threw in some formulas, and
the outcome was pure magic
!
Now, please don't misunderstand me.
None of it was easy.
I had to work hard
.
But
every day I learned a little more and honed my Excel skills
.
Until one day,
I became the Excel wizard
I dreamed of becoming!
And that brings me to this course.
I want to teach you the
exact same skills I learned over those 1000’s of hours
in
one easy-to-follow
course.
Not sure I can make you an Excel data wizard?
Well, let’s hear what some of
my students
have to say.
“This course has helped me tremendously. I was very much a rookie at the start of the course and by the end my confidence has grown tremendously” - Mark S. ⭐️⭐️⭐️⭐️⭐️
“The course has opened up my thinking which I thought was blocked, This is very useful, Great teaching” - Olajumoke A. ⭐️⭐️⭐️⭐️⭐️
“Great course! Very concise, accurate and applicable. Can't wait to start my new role now, thanks!” - Peter J. ⭐️⭐️⭐️⭐️⭐️
“Very Detailed and helped me with my day to day work!” - Gretchen M. ⭐️⭐️⭐️⭐️⭐️
“Excellent explanation of concepts and key terms” - Vincent O. ⭐️⭐️⭐️⭐️⭐️
And these are just a few of the
hundreds of rave reviews
for the course!
So,
what’s included in the course
?
Again, another great question!
Here’s a breakdown:
✅ 5+ hours of great Excel data analysis content
✅ Hands-on data analysis exercises
✅ Before & after Excel files
✅ Quizzes to test your knowledge
That's a lot - right?!
Still not sure I can make you an Excel data wizard?
Well, I think I will, so
I guarantee it.
If you're not satisfied just ask for a
100% full refund, No questions asked.
I won’t be mad -
I promise!
Are you ready to become an
Excel data wizard?!
Who this course is for:
Anyone who wants to impress their co-workers with their Excel skills!
Anyone who wants to become an Excel data Wizard!
Anyone who wants to learn how to analyze data the right way

What you'll learn

Learn how to analyze data in Excel

How to use Pivot Tables, Lookups and other functions in a practical way

How to Analyze data in a way that leads to insights

Understand what a Data Analyst is and what they do on a daily basis

Hands-on data analysis with real data

Learn Analytical Thinking skills for everyday application

The traits of a good Data Analyst

The tools used by Data Analysts

Learn about Analyst Role models to follow

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Foundation
7
1.1-Introduction
1.2-What is a Data Analyst?
1.3-The role of a Data Analyst
1.4-The characteristics of a Data Analyst
1.5-Thinking like a Data Analyst
1.6-Analyst Role Models
1.7-Module 1 Quiz
2-Tools
10
2.1-Introduction
2.2-An Introduction to Excel
2.3-Formatting in Excel
2.4-Copying & pasting in Excel
2.5-Sorting Data in Excel
2.6-Naming cells and ranges in Excel
2.7-Removing duplicate data in Excel
2.8-Setting the print area
2.9-Basic Excel formulas
2.10-Module 2: Quiz #1
3-Formulas
10
3.1-Excel Shortcuts
3.2-Intermediate Excel
3.3-Intermediate Formulas
3.4-If Statements
3.5-Sum If Formula
3.6-Count if Formula
3.7-Nested If Statements: If or
3.8-Nested If Statements: If and
3.9-Look-up formulas
3.10-Hands-on with look-up formulas
4-Data Aggregation
4
4.1-Introduction to Pivot Tables
4.2-Hands-on with Pivot Tables
4.3-Get Pivot Formula
4.4-Hands-on with Get Pivot