Learn Microsoft Excel for Data Analysis: Zero to Hero

Master Microsoft Excel to Excel in the industry of Data Analytics

Last updated 02/2023
6 Hours
19 Lectures
English

Created by Dr. Satyajit Pattnaik, Analytics

Video Poster
play
Preview this course
₹999.00 ₹1,999.00
Access the full course for lifetime, just add to cart and buy the course at one of lowest in the market
0
 
43
learners
Description

From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level.

In only six hours of videos, provided to you in multiple separate video lectures so that no one online video is too long, you will learn all of the following about Microsoft Excel:

  • Learn how to navigate around Excel
  • Learn basic, conditional & custom formatting
  • Learn various Datetime, Statistical & Mathematical functions in Excel
  • Learn how to perform Data Analysis in Excel
  • Learn about What-If tools
  • Learn VLOOKUP & HLOOKUP functions

This class is guaranteed to teach you Microsoft Excel.

Try this course for yourself and see how quickly and easily you too can learn Microsoft Excel.

 

Course Content
18 sections • 19 lectures
Pre-defined functions
Datetime functions
Datetime functions
String functions
Mathematical functions
Lookup Hlookup,Vlookup
Logical Error Functions
Statistical Functions
Images in Excel
Excel Formatting
Custom Formatting
Conditional Formatting
Charts in Excel
Data Analysis using Excel
Pivot Tables
Dashboarding in Excel
Others
What If Tools Scenario Manager, Goal Seek
This course includes:
  • 6 Hours of on-demand video
  • Full Lifetime Access
  • Access on mobile and TV
  • Assignments
  • Certificate of completion
Instructor
Dr. Satyajit Pattnaik Lead Data Consultant, PALO IT
Avatar
  • 4.7 Instructor Rating
  • 935,480 Reviews
  • 3,072,339 Students
  • 7 Courses