Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
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
-
MMihir Negi
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.
-
ppriti pawar
very very nice course
-
AAjit Dolas
very specifically explain, excited to see next video
-
NNaren Satyam
Overall, It was great learning experience.