Udemy

Learn Microsoft Excel for Data Analysis: Zero to Hero

Enroll Now
  • 1,149 Students
  • Updated 6/2022
  • Certificate Available
4.2
(53 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 47 Minute(s)
Language
English
Taught by
Dr. Satyajit Pattnaik
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.2
(53 Ratings)
1 views

Course Overview

Learn Microsoft Excel for Data Analysis: Zero to Hero

Master Microsoft Excel to Excel in the industry of Data Analytics

This training provides you everything you need to know about Microsoft Excel.

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.


Recent Student Review from my other courses

  • "Really great into to Tableau! Having never used it before I feel much more confident now and looking forward to the advance course."

  • "I think the course covers everything you need to know to get started with playing around in Tableau. The actual test of your knowledge would be when you actually use this with real-time data and develop dashboards and presentations."

  • "This is what i truly needed ,thank you so much for making this course so easy."


Who this course is for:

  • This Microsoft Excel courses will take you through 3 levels of Microsoft Excel topics (Beginner, Intermediate, & Advanced)

  • If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

This course will help you understand various concepts of MS Excel that is required to perform Data Analysis.

Course Content

  • 18 section(s)
  • 18 lecture(s)
  • Section 1 Introduction
  • Section 2 Pre-defined functions
  • Section 3 Datetime functions
  • Section 4 String functions
  • Section 5 Mathematical functions
  • Section 6 Lookup (Hlookup,Vlookup)
  • Section 7 Logical _ Error Functions
  • Section 8 Statistical Functions
  • Section 9 Images in Excel
  • Section 10 Excel Formatting
  • Section 11 Custom Formatting
  • Section 12 Conditional Formatting
  • Section 13 Charts in Excel
  • Section 14 Data Analysis using Excel
  • Section 15 Pivot Tables
  • Section 16 Dashboarding in Excel
  • Section 17 Others
  • Section 18 What-If Tools - Scenario Manager, Goal Seek

What You’ll Learn

  • Master Microsoft Excel from Beginner to Advanced
  • Learn the most common Excel functions used in the Office
  • Maintain large sets of Excel data in a list or table
  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn how Excel helps in the journey of Data Analysis

Reviews

  • M
    Mihir Negi
    4.0

    The course is a gem for anyone looking to enhance their data analysis skills using Microsoft Excel. Throughout the course, the instructor is clear, concise, and incredibly engaging. The course content is well-structured, starting with the basics and gradually progressing to more advanced concepts. This made it easy for beginners like me to follow along and build a solid foundation before diving into more complex topics.

  • p
    priti pawar
    5.0

    very very nice course

  • A
    Ajit Dolas
    5.0

    very specifically explain, excited to see next video

  • N
    Naren Satyam
    5.0

    Overall, It was great learning experience.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed