Excel Training (18 Courses, 9+ Projects)
This Excel Course includes 18 courses, 9 Projects with 95+ hours of video tutorials and Lifetime access.
You will also get verifiable certificates (unique certification number and your unique URL) when you complete each of the courses. You will learn Excel Functions, Formula, Charts, and Graphs, Pivot tables, excel dashboard creation, simulations in Excel.
Microsoft Excel 2016 - Beginners
Microsoft Excel 2016 - Advanced
Mastering Microsoft Excel Date and Time
Pivot Table for Beginners
Project - Analysis with Pivot Tables
What you get in this Excel Training?
Mobile App Access
About Excel Course
|Course||No. of Hours|
|Microsoft Excel 2016 - Beginners||4h 03m|
|Microsoft Excel 2016 - Advanced||5h 11m|
|Basic Microsoft Excel Training||4h 8m|
|MS Excel 2010 Training Course: Advanced||8h 37m|
|Microsoft Excel Basic Training | Excel 2013 Courses Online | Beginners||4h 22m|
|Microsoft Excel 2013 - Advanced||11h 06m|
|Mastering Microsoft Excel Date and Time||2h 54m|
|Shortcuts in Microsoft Excel||25m|
|Pivot Table for Beginners||1h 29m|
|Project - Analysis with Pivot Tables||4h 6m|
|Power Pivot in Microsoft Excel 2016||3h 34m|
|Power Excel Training||5h 27m|
|Microsoft Excel Reports||8h 35m|
|Graphs & Charts in Microsoft Excel 2013||3h 3m|
|Microsoft Excel Charts and SmartArt Graphics||6h 52m|
|Financial Functions In Excel - Microsoft Excel 2013 Course||2h 4m|
|Statistical Tools in Microsoft Excel||1h 14m|
|Project - Microsoft Excel Simulations Training||2h 18m|
|Project - Building Dynamic Heat Map in Microsoft Excel 2016||1h 13m|
|Microsoft Excel Solver Tutorial||49m|
|Comprehensive VBA and Macros Training||10h 46m|
|Project - Microsoft Excel Dashboard Training||6h 1m|
|Project - Sales Productivity Dashboard||7h 2m|
|Project - Creating Sales Dashboard using Microsoft Excel||1h 35m|
|Project - HR Dashboard using Excel||6h 5m|
|Project - Advanced HR Dashboard||7h 8m|
|Working with Pivot Tables Presentation||4h 12m|
|Course Name||Online Excel Course Bundle|
|Deal||You get access to all the 18 courses, 9 Projects. You do not need to purchase each course separately.|
|Hours||95+ Video Hours|
|Core Coverage||You will learn Excel Functions, Formula, Charts, and Graphs, formatting, pivot tables, power pivot, power excel, excel dashboard creation, simulations, statistical tools, financial functions in excel|
|Course Validity||Lifetime Access|
|Eligibility||Anyone who is serious about mastering Microsoft Excel|
|What do you get?||Certificate of Completion for each of the 18 courses, 9 Projects|
|Certification Type||Course Completion Certificates|
|Verifiable Certificates?||Yes, you get verifiable certificates for each course with a unique link. These link can be included in your Resume/Linkedin profile to showcase your enhanced Excel skills|
|Type of Training||Video Course – Self Paced Learning|
|System Requirement||1 GB RAM or higher|
|Other Requirement||Speaker / Headphone|
Excel Course Curriculum
Let’s look at what you will learn in this excel course briefly –
Microsoft Excel 2016 - Beginners
This is the first module of this Excel course. First, we will start with a brief overview. Then, we will talk about the ribbons and quick access toolbar. Then, we will take a case study to show you excel works and next, we will talk about data entry, how you can populate the case study in excel. We will show you how calculations are done, how you can use various formulas, use formatting, what are percentages & absolute references, and if function etc. You will also learn about the pie charts, filter functions, shortcuts, and common errors. This entire module will take you around 4 hours and you need to watch 37 videos.
Microsoft Excel 2016 - Advanced
We will start this Excel course module with useful excel functions. Then, we will talk about the data functions, what-if-analysis, arrays, functions for working with text, pivot tables, auditing & troubleshooting formulas, advanced charts etc. This entire module will take you around 5 hours 13 minutes and you need to watch 47 videos.
Mastering Microsoft Excel Date and Time
This excel course module is focused on mastering MS Excel date and time. We will start with a brief introduction. And then, we will talk about the date & time value and function in detail. This entire module will take you around 2 hours 54 minutes and you need to watch 31 videos.
Pivot Tables for Microsoft Excel 2016
This entire excel module is dedicated to understanding the pivot tables for MS Excel 2016. You need to invest just 20 minutes to cover this module and you need to watch 3 videos.
Power Pivot in Microsoft Excel 2016
We will start this excel course module with a brief introduction and data import. Then, we will talk about the formatting, pivot chart example, pivot table example, and lastly, inserting slicer. You need to invest around 3 hours 34 minutes and you need to watch 21 videos in total.
Power Excel Training
We will begin with a brief introduction to the power excel training. Then, you will learn about function, pivot tables, evaluate, date format & time format, statement & VLoopUp, future value function, business & database information, data comparison & filter, and finally, pivot chart & power view. This entire excel course will take you around 5 hours 27 minutes and you need to watch 47 videos.
Shortcuts in Microsoft Excel
This excel course module just consists of 2 videos and you need to spend just 25 minutes to cover this entire module. It will teach you the shortcuts that will make your life easy while using MS Excel.
Microsoft Excel Reports
This module will take you through shortcut functions, excel functions, vertical lookups, financial function, and average-if function. This entire module will take you around 8 hours 35 minutes and you need to watch 56 videos.
Graphs & Charts in Microsoft Excel 2013
We will start this module with a brief introduction. Then, you will learn the chart concept, the basic chart, fine-tuning of charts, chart options, format tab, adjustment of specific chart types, changing chart sources, and specialized charts & graphs.. You will need to spend around 2 hours 42 minutes and you need to watch 24 videos in total.
Microsoft Excel Charts and SmartArt Graphics
As we always do, we will start this module with a brief introduction. Then, we will talk about the pictures, clip art, excel chart, data table, pie chart, bubble chart, aspects of scatter plot, tips, smart art etc. You need to spend around 6 hours 52 minutes and you need to watch 51 videos in total.
Financial Functions In Excel - Microsoft Excel 2013 Course
In this module, we will start with a brief overview. Then, we will learn about future value, SI, CI, PV, Nper rate, the value of an investment with multiple cash flows, calculating the rate of return, analyzing loans & payments, and bond valuation. This entire module will take around 2 hours 4 minutes and you need to watch 23 videos.
Statistical Tools in Microsoft Excel
You will learn about the statistical tools in MS Excel in this module. You will learn from descriptive statistics to data analysis, and also from the central tendency to descriptive statistics. You will also learn about the histogram using data analysis, moving averages using data analysis, and additional statistical tools in excel. The entire module will take you around 1 hour 14 minutes and you need to watch 12 videos in total.
Project - Microsoft Excel Simulations Training
In this excel course, we will start with a brief overview of excel simulations. And then, we will talk about data simulation, goal-seek, table simulations, data validation & macro filters, and finally, Monte Carlo simulations. This entire module will take you around 2 hours 18 minutes and you need to watch 19 videos in total.
Project - Building Dynamic Heat Map in Microsoft Excel 2016
We will start with a brief overview of the heat map and heat map example. Then, we will talk about how to use sales data, how to use a channel, and we would also show you the reference files. This module will take you around 1 hour 17 minutes and you need to watch 9 videos.
Microsoft Excel Solver Tutorial
We will start this excel course with a brief introduction. And then, we will talk about a solver example and a solver for simultaneous & minimizing shipping. This module will just take 49 minutes and you need to watch 7 videos in total.
Comprehensive VBA and Macros Training
This excel course starts with a brief introduction of VBA. Then, we will take you through"my first macro’, VBA environment, macros with if condition, data filter, charting using VBA, user form, and then, several case studies on various milestones. You need to spend 11 hours 12 minutes and you need to watch 95 videos in total.
Project - Microsoft Excel Dashboard Training
You will learn about the syllabus, creation, formulas, formatting, types of filters, graphs & formatting, demographics, compensation button, import access, export access, and conclusion. You need to invest 6 hours 9 minutes and you need to watch 55 videos in total.
Project - Creating Sales Dashboard using Microsoft Excel
You will learn about the excel dashboard, pivot table, pivot chart, slicer, and we will also show you a few reference files. This module will take you around 1 hour 35 minutes and you need to watch 13 videos.
Project - HR Dashboard using Excel
First, we will start with a reference file that will offer you a brief about the creation of HR dashboard & analytics. Then, gradually, you will learn about data introduction, index & tab designing, employee front face, the pivot data list, MOM headcount, departmental & location analysis, tenure wise analysis, age-wise analysis, employee demo & quality circles, timesheet late marks analysis, full & final analysis, training analysis, job rating analysis, HR update, and lastly a summary of all that you learn. The entire module will take you around 6 hours 5 minutes and you need to watch 42 videos in total.
Project - Advanced HR Dashboard
This is the last module of this excel course. In this module, we will also start with a brief overview of the advanced HR dashboard & analytics. Then, we will talk about data introduction, data index, page layout, HC analysis, data & animated macro chart, predictive attrition, Vlookup analysis, BGV analysis, leave analysis & grouping data, Bradford factor, FNF analysis & exit analysis, learning & development analysis, goal seek & payroll analysis, employee profile, HR update & HR update calendar, and finally the conclusion. The entire module will take you around 8 hours 17 minutes and you need to watch 62 videos.
Certificate of Completion
What is Excel and why it is important to learn?
No matter the profession you are in, you need to learn Excel.
From data analysis to the presentation of a data set, you can easily use Excel. Also, the easiest way to create a projection report or a graph is by using Excel.
You can be in finance, marketing, HR, analytics, you need to learn Excel to be an all-around professional.
Whenever employees are hired, it’s given that they know MS Excel. But truthfully, most people don’t take the time to learn and we would agree that the lack of comprehensive material is one of the reasons that people don’t try their hands-on Excel.
That’s why we created this comprehensive MS Excel course that will make you a complete professional.
We have covered just enough so that you are equipped to handle MS Excel on your own.
Do the course and practice and leave the rest to us.
What tangible skills will I learn from this Excel course?
You would learn a lot. We are just highlighting a few Microsoft Excel skills that you shall learn below-
- MS Excel (Basic & Advanced): You will learn both the basics and advanced MS Excel in this course. We have just covered enough to get you going.
- Statistical tools & Financial functions: Even if you’re from a different domain, you may find the statistical tools and the financial functions covered in this course handy.
- Fundamental knowledge in Macros & VBA: You will learn a lot about how to create Macros and VBA so that you can use it in your own domain of work
- Willingness to learn MS Excel: If you feel that you need to learn the nitty-gritty of MS Excel, this is the right course for you. Just for the sake of doing (without any motive or interest) won’t produce the best result even after doing this Excel course.
- A basic sense of maths: You don’t need to know everything about mathematics. But a fundamental sense would definitely help.
- Students from any domain: If you’re a student, you can do this Excel course. It will teach you the functions, formulas you need to learn to get ahead in your job search/ employment.
- Professionals from any domain/industry: If you’re a professional and you feel that you need to learn the nitty-gritty of MS Excel, this excel course may be the right one for you.
Excel Course FAQ’s- General Questions
Why should I do this Excel course?
Because this is the best course you would ever find on MS Excel. If you’re looking for learning Excel, your search ends here.
I’m not from the finance domain. Can I do this Excel course?
Yes. Anyone from any domain or industry can do this excel course if interested.
What would I get out of this Excel course?
A lot. Once you do this course, it’s given that you don’t need to worry about Excel again (provided you do the work on what you learn)
- You will be ahead of many of your peers: This excel course will help you stand out. You will be the go-to-guy for that presentation, that excel sheet, or that project report after doing this course.
- You will be able to do much more than just data analysis: Yes, this excel course is not about just understanding functions & formulas. You will also learn about the tricks about creating reports and you will also learn VBA and Macros.
Power Pivots in Excel Course
Excel stimulation technique.
Power Excel Tools