Learn Advanced Excel for Data Analysis

Learn Advanced Excel for Data Analysis

Instructor: TechTutors 12 Apr, 2023
About The Course

Microsoft Excel is one of the most popular applications for data analysis. Equipped with built-in pivot tables, they are without a doubt the most sought-after analytic tool available. It is an all-in-one data management software that allows you to easily import, explore, clean, analyze, and visualize your data.

Excel is the world’s most popular data analysis tool. Companies and institutions worldwide use it to transform mountains of raw data into clear insights. Strong Excel skills can open new career paths, make you more employable in various industries, and save hours in your daily tasks.

In this course, you’ll develop employable data analyst skills, starting with the Excel basics, what it can do, and the data analysis steps you should follow.

This course will teach you how to prepare your data by extracting text, preparing date data, and which Excel formulas can help. You’ll learn to use ‘the most important function in Excel’, VLOOKUP, to combine data from different sources before testing your understanding in hands-on exercises.

These Excel skills, functions, and time-saving shortcuts can be applied to any industry, whether you’re looking to move to a career in data analysis, or looking to improve your skills in marketing, finance, HR, logistics, and more.

 

What Will You Learn?

How to use Excel as a Data Scientist

You will learn Excel Functions

You will learn Vlookups

Data Manipulation with Excel

Data Cleaning with Excel

Logical Functions

Pivot Tables

Dashboard

Projects

You can also check the course curriculum to see the full list of topics covered.

The Course Curriculam

Introduction To Excel
Introduction To Excel

  • Introduction To Excel
    04:28

Moving Around And Filtering On Excel
Moving Around And Filtering

Introdcution To Excel Tabs And Groups
Introdcution To Excel Tabs And Groups

Sorting And Freezing Panes On Excel
Sorting And Freezing Panes On Excel

Defines Names On Excel
Defines Names On Excel

How To Drop Down List On Excel
How To Drop Down List On Excel

Deleting Data Validation On Excel
Deleting Data Validation On Excel

Conditional Formatting On Excel
Conditional Formatting On Excel

How To Count Functions On Excel
How To Count Functions On Excel

Countifs, Sumifs, Averageifs
Countifs, Sumifs, Averageifs

Multiple Conditions, Countifs, Sumifs, Averageifs
Multiple Conditions, Countifs, Sumifs, Averageifs

Multiple Conditions, Countifs, Sumifs, Averageifs Part 2
Multiple Conditions, Countifs, Sumifs, Averageifs

Maximum And Minimum Ifs
Maximum And Minimum Ifs

VlookUp Part 1
VlookUp Part 1

VLookup Part 2
VLookup Part 2

Table Labels
Table Labels

Table Calculated Columns And Auto Expansion
Table Calculated Columns And Auto Expansion

Table Slicer
Table Slicer

Excel Functions Part 1
Excel Functions Part 1

Excel Functions Part 2
Excel Functions Part 2

Excel Date
Excel Date

Aggregate Functions On Excel
Aggregate Functions On Excel

Logical Functions On Excel Part 1
Logical Functions On Excel Part 1

Logical Functions On Excel Part 2
Logical Functions On Excel Part 2

Logical Functions On Excel Part 3
Logical Functions On Excel Part 3

Pivot Table Project On Excel
Pivot Table Project On Excel

Pivot Chat Project On Excel
Pivot Chat Project On Excel

DashBoard Project Part 1
DashBoard Project Part 1

Dasboard Project Part 2
Dasboard Project Part 2

Dashboard Project Part 3
Dashboard Project Part 3

ea2178b6860ee23672d9dba474946bef?s=96&d=mm&r=g

TechTutors

7 Courses 0 Student
dbf2ace780b689a398286c89529c637f?s=96&d=mm&r=g

Acadu

9 Courses 3 Students
No Review Yet
No Review Yet
Verified by MonsterInsights