Microsoft Excel Masterclass for Data Analysis - 2023

Focused View

Jobshie Academy

1:29:50

199 View

1. Introduction

1. Introduction.mp4

02:10

2. MicroSoft Excel.mp4

01:19

3. Congratulations.mp4

02:52

4. Customization.mp4

08:26

2. Shortcuts

1. Shortcuts.mp4

02:18

3. Data Validation

1. Data Validation.mp4

03:59

4. Mathematics Operations

1. Mathematics Operations.mp4

09:40

5. Filters

1. Filters.mp4

04:46

2. Shorting.mp4

01:54

3. Grouping.mp4

04:49

6. Basic Functions

1. Functions.mp4

04:33

2. Minimum and Maximum Values.mp4

01:24

3. Average.mp4

02:09

4. Count.mp4

00:59

7. Numerical Functions

1. Is Numeric Function.mp4

01:24

2. RAND Function.mp4

02:41

3. Round Function.mp4

00:53

4. Median.mp4

00:51

5. Power.mp4

00:38

8. Textual Functions

1. Left Right and Mid Function.mp4

02:35

2. Find Function.mp4

03:30

9. Date Functions

1. Date Function.mp4

02:23

10. Conditions

1. IF Condition.mp4

02:24

2. IF ERROR Conditon.mp4

02:10

3. Nested IF Condition.mp4

02:38

11. Operators

1. AND.mp4

02:16

2. OR.mp4

01:32

12. Lookup Functions

1. VLOOKUP.mp4

03:02

13. Pivot Table

1. Pivot Table.mp4

05:02

14. Charts

1. Pie Chart.mp4

01:38

2. Column Chart.mp4

00:36

3. Line Chart.mp4

00:51

4. Other Charts.mp4

00:39

15. Certificate

1. Certificate.mp4

00:49

Description

Microsoft Excel Beginner to Professional. Includes Pivot Tables, Micros, NEW Formulas. Learn Excel for Data Analysis

What You'll Learn?

Powerful and dynamic Excel formulas
Automate your workflow with Excel
Advanced conditional, text, date, and lookup functions
Pivot tables and charts to visualize the data

Who is this for?

Excel users who want to learn how to write advanced formulas from scratch

Anyone hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level

Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

Excel users looking to build powerful analytical thinking and business intelligence skills

Anyone looking to pursue a career in analytics, data science or business intelligence

What You Need to Know?

Any excel software

More details

Description
Hello and welcome to the basic to advanced Microsoft excel course.

This course will deepen your understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways.

You will access project files, quizzes, homework exercises, and 1-on-1 expert support.

You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced-level topics.

After completing this course, you will be able to write powerful and dynamic Excel formulas from scratch, and you will be able to Automate your workflow with Excel.
Master unique tips & techniques that you won't find in ANY other course.

You will be able to write advanced conditional, text, date, and lookup functions. You will be able to create pivot tables and charts to visualize your data.

Who this course is for:

Excel users who want to learn how to write advanced formulas from scratch
Anyone hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level
Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
Excel users looking to build powerful analytical thinking and business intelligence skills
Anyone looking to pursue a career in analytics, data science or business intelligence

After completing this course, you will get a certificate of completion that you can use to showcase your newly gained skills to your colleagues through LinkedIn and potential employers.

So, what are you waiting for? Enroll now. I will see you in the class.

Who this course is for:
Excel users who want to learn how to write advanced formulas from scratch
Anyone hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level
Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
Excel users looking to build powerful analytical thinking and business intelligence skills
Anyone looking to pursue a career in analytics, data science or business intelligence

User Reviews

Rating

average 0

Total votes0

Focused display

I have working experience of Data Analysis of more than three years. I create videos on SQL, Big query, Data Science, Data Analysis, Python, Machine Learning, Deep Learning. There are more than 70000 Enrollments in my courses. My most popular course is: Data Analysis for Entry Level Job - Zero to Hero Skill Path

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.