Advanced Excel
-
LevelIntermediate
-
Duration3 hours
-
CertificateCertificate of completion
About the course
Rated 4.93
by 643 learners
About the Guru
You would be taught by Advait, an Excel specialist. He has over 4 years of experience across industries like venture capital, finance and consulting.
Who is it for?
Students
Founders & entrepreneurs
Freelancers
Excel enthusiasts
Working professionals
Data analysts
Course outcomes
Handling Data
You would be able to format and handle data better.
Handle pivots
After completing this course you would be able to create pivots with all kind of data.
Data visualization and processing
Working with data would be a breeze, you'd be able to manage and add charts, custom charts and more.
Formulas
Applying dynamic formulas like Vlookup and Hlookup would be super easy for you.
Here's what you'll learn
Understanding the data set
-
Understanding the data set
15:11
Data visualization and processing
-
Data Validation
08:00 -
Data Visualization
18:46
Fetching and processing the data dynamically
-
Lookup function
13:54 -
Ranks and IF statement
27:11
Pivot Tables
-
Pivot charts and tables
14:21
Exercise
-
Practice exercise
08:33
Get certified
Official & Verified
Officially attested by SmrtGuru and the Guru.
Easily Shareable
Easily shareable on social media platforms and job boards.
Enchances Credibility
Showcase your skills with the certificate.
Certificate for display purpose only
Advanced Excel
About the course
Rated 4.93
by 643 learners
About the Guru
You would be taught by Advait, an Excel specialist. He has over 4 years of experience across industries like venture capital, finance and consulting.
Who's it for?
Freelancers
Working professionals
Students
Founders & entrepreneurs
Course outcomes
You would be able to format and handle data better.
By the end of this you'd be able to add charts, slicers & more.
Applying dynamic formulas like Vlookup & Hlookup would be super easy for you.
Here's what you'll learn
Understanding the data set
-
Understanding the data set
15:11
Data visualization and processing
-
Data Validation
08:00 -
Data Visualization
18:46
Fetching and processing the data dynamically
-
Lookup function
13:54 -
Ranks and IF statement
27:11
Pivot Tables
-
Pivot charts and tables
14:21
Exercise
-
Practice exercise
08:33
Get certified
Official & Verified
Officially attested by SmrtGuru and the Guru.
Easily Shareable
Easily shareable on social media platforms and job boards.
Enchances Credibility
Showcase your skills with the certificate.
Certificate for display purpose only
After completing this course you would be able to create pivots with all kind of data.