20 Online Courses
Verifiable Certificate of Completion
Microsoft Excel 2016 - Beginners4h 18m
Microsoft Excel 2016 - Advanced5h 11m
Mastering Microsoft Excel Date and Time2h 54m
Pivot Tables for Microsoft Excel 201620m
Power Excel Training5h 27m
Skills you will master
- Excel 2016
- Advanced Excel
- Pivot Tables
- Charts and Graphs
- Data Functions
- What if Analysis
- Dynamic Range
- Financial Functions
- Data simulation
- Chart Simulation
- Data Validation
- Monte Carlo Simulation
- Database creation
- Tab Creation
- Index Creation
Online Excel Course
This Excel Course includes 20 Excel courses with 80+ 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.
Knowledge of Microsoft Excel is a must in today’s time. No matter what profession you are in, if you don’t know Excel, you would miss out on analysis, generating reports, projecting trends, and also creating graphs & charts for your presentations.
Excel is much more than just working on a spreadsheet. And that’s why you should do a course that will teach you everything you need to know at a basic level.
- About Excel Course
- Excel Course Curriculum
- Certificate of Completion
- Pre-requisites to Excel Course
- Sample Preview of this Excel Course
- Target Audience for this Excel Course
- Online Excel Course FAQs – General Questions
- Career Benefits of this Excel Course
- Online Excel Course Review / Testimonials
About Excel Course
|Course Name||Online Excel Course Bundle|
|Deal||You get access to all the 20 courses. You do not need to purchase each course separately.|
|Hours||80+ 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 20 courses|
|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 –
|Serial No.||Course Name||Course Description|
|1||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.|
|2||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.|
|3||Mastering Microsoft Excel Date & 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.|
|4||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.|
|5||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.|
|6||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.|
|7||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.|
|8||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.|
|9||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.|
|10||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.|
|11||Financial Functions in Excel – Microsoft Excel 2013||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.|
|12||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.|
|13||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.|
|14||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.|
|15||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.|
|16||Comprehensive and VBA 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.|
|17||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.|
|18||Creating a 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.|
|19||HR Dashboard & Analytics – Beginners||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.|
|20||HR Dashboard & Analytics – Advanced||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 here –
- 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
Pre-requisites to Excel Course
- 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.
Target Audience for this Excel Course
- 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)
Career Benefits of this Excel Course
- 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.
Excel Data Analysis Course Testimonials
Power Pivots in Excel Course
Excel stimulation technique.
Power Excel Tools