Learn Advanced Excel for Data Analysis
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
04:28