Learn from Home Offer
Learn from Home Offer
MS Excel Advanced Course Bundle - 42 Courses in 1 | 15 Mock Tests
This Excel Advanced Course includes 42 courses with 146+ hours of video tutorials and Lifetime access and several mock tests for practice. You will also get verifiable certificates (unique certification number and your unique URL) when you complete each of the courses. This course is dedicated for you to learn Advanced Excel Functions, Pivot Tables, VBA & Macros, Dashboard creation etc.
* One Time Payment & Get Lifetime Access
What you get in this MS Excel Advanced Course Bundle - 42 Courses in 1 | 15 Mock Tests?
Course Completion Certificates
Mobile App Access
MS Excel Advanced Course Bundle at a Glance
|Courses||You get access to all the 42 courses, Projects. You do not need to purchase each course separately.|
|Hours||146+ Video Hours|
|Core Coverage||Advanced Excel Functions, Pivot Tables, Power Pivot, Excel Reports, Excel Charts and Graphs, Excel Simulations, VBA & Macros, Dashboard creation|
|Course Validity||Lifetime Access|
|Eligibility||Anyone serious about mastering Microsoft Excel|
|Pre-Requisites||Basic Excel Knowledge|
|What do you get?||Certificate of Completion for each of the 42 courses, 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|
MS Excel Advanced Course Bundle Curriculum
In this course, you will learn everything you need to know about the functions and formulas of advanced excel –
MODULE 1: MS Excel Pivot Tables and Charts
Courses No. of Hours Certificates Details Excel Advanced Overview 1m ✔ Learn Microsoft Excel from A-Z: Advanced Level 9h 21m ✔ Data Analysis with Pivot Tables 4h 58m ✔ Pivot Table for Beginners 1h 28m ✔ Pivot Tables Hands-on! 2h 3m ✔ Power Pivot in Microsoft Excel 2016 3h 31m ✔ Power Pivot and DAX 2019 32m ✔ Working with Pivot Tables Presentation 3h 7m ✔ Pivot Table Project - Problem Handling and Automation 1h 11m ✔ Pivot Table Case Study - Performance Ratings of Employees 1h 11m ✔ Test - Excel Mock Exam Test - Excel Assessment Exam
MODULE 2: VBA Macros & Excel Automation
Courses No. of Hours Certificates Details Comprehensive VBA and Macros Training 10h 43m ✔ Creation of Basic CRM using MS Excel & VBA 3h 49m ✔ Project on VBA Macros - Automation using Loop 28m ✔ Creating Attendance Register using MS Excel & VBA 3h 6m ✔ MS Excel Sales Productivity Dashboard 6h 41m ✔ MS Excel Sales Productivity Dashboard - Advanced 7h 39m ✔ MS Excel Sales Dashboard 1h 3m ✔ Project - Case Paper using Excel VBA and Macros 2h 51m ✔ Project on VBA - Project Schedule Indexes 2h 52m ✔ Project on VBA - Financial Modeling using VBA 3h 7m ✔ Macros and VBAs Features and Concepts 6h 39m ✔ Project on VBA Macros - Create a Login-Logout Tracker 3h 35m ✔ Test - Excel VBA Mini Quiz Test - Mini Quiz Excel VBA Test - Excel VBA Assessment Test
MODULE 3: Advanced Excel Formulas and Functions
Courses No. of Hours Certificates Details Microsoft Excel Charts and SmartArt Graphics 6h 45m ✔ Power Excel Training 5h 15m ✔ MS Excel Shortcuts 8h 22m ✔ Financial Functions In MS Excel 2h 36m ✔ Date and Time Functions Microsoft Excel Training 2h 37m ✔ Statistical Tools in Microsoft Excel 1h 11m ✔ Shortcuts in Microsoft Excel 24m ✔ Mastering Microsoft Excel Date and Time 2h 47m ✔ Test - Complete Excel Exam Test - Ultimate Excel Test Test - 2023 Excel Exam
MODULE 4: Dashboards Creation and Advanced Functions
Courses No. of Hours Certificates Details MS Excel HR Dashboard 5h 56m ✔ Advanced HR Dashboard with MS Excel 8h 15m ✔ Interactive Dashboards using VBA 1h 6m ✔ TreeView and ListView in VBA 2h 23m ✔ Interactive Sales Dashboards using MS Excel & VBA 2h 18m ✔ Project on Excel VBA - Restaurant Billing System using Microsoft Excel VBA 3h 1m ✔ MS Excel Dashboard Training 5h 45m ✔ Test - Excel Mock Exam Test - Excel Assessment Exam Test - Complete Excel Exam
MODULE 5: Revisiting MS Excel Formulas and Functions
Courses No. of Hours Certificates Details Advanced Excel Practicals: Essentials for the Real World 3h 25m ✔ Pivot Table Case Study - Performance Ratings of Employees 1h 11m ✔ Advanced Excel for Financial Analysis 5h 38m ✔ Advanced Excel 2016 - Some Important Features 3h 21m ✔ Mastering Microsoft Excel Date and Time 2h 47m ✔ Test - 2023 Excel Exam
MODULE 6: Mock Tests & Quizzes
Courses No. of Hours Certificates Details Test - Excel Mini Quiz Test - Mini Quiz Excel Test - Excel Assessment Test
This training is an extensive one taking into account advanced level features and tools of excel. Trainees will gain concept clarity regarding various features, tools as well as excel shortcuts which will help them gain efficiency in their excel related work.
The course is focused on the coverage of lifesaving excel tools and functionalities. Learners will gain insight into numerous in-built tools and features in Excel and their application in real life to gain better results.
Here is a highlight of the coverage of the project.
Learners will go through intense training on MS Excel 2016 wherein they will learn about data functions, what-if-analysis, arrays, functions, text functions, pivot tables, advanced charts, etc.
We will continue with the above session and learn about the remaining advanced concepts of excel such as shortcuts, excel controls, cell comments, named ranges and advanced formulas.
We will then focus our energies on data and time functions in excel.
A beginners’ session will be conducted for providing clarity on pivot tables, its features and its formatting.
Then we will resume the session on the pivot table and gain an understanding of other advanced concepts relating to it such as data summarization in the pivot table, pivot charts, printing, macros, power pivot, DAX, etc.
The session will be covered on power pivot in Excel 2016 where we will discuss pivot charts, pivot tables, pie charts and slicers.
Moving on with power pivot, we will get to know as to how to download and install it and organize and format data.
Training will be conducted on power excel. Topics such as functions, pivot tables, evaluation, date and time format, statement and vlookup, future value function and so on.
The tutorial will be there to discuss shortcuts in excel, excel functions, vertical lookups, financial functions and average if function.
The next subject area in the training will be excel charts and smart-art graphics. We will discuss pictures and clip arts, excel charts and data tables, pie charts and line charts, etc.
Knowledge will be imparted on financial functions such as future value, investment valuation with multiple cash flows, calculating the rate of return, analysis of loans and payments and bond valuation.
In the next session, learners will understand the working of statistical tools in excel such as central tendency, standard deviation, data analysis tools, correlation, and regression, etc.
Comprehensive training will be provided on VBA and macros in excel.
In the next session we will gain clarity on macros and VBAs features as well as concepts.
The tutorial will cover the apt presentation method for pivot tables.
We will learn about problem handling and automation to excel through a project.
At last, we will undertake a case study on the performance rating of employees using excel.
The project will be covered on pivot tables to cover important features such as axis and formatting, sorting and filtering, grouping and analysis, show field values as, pivot charts and macros.
Learners will gain insight into excel data simulation through a project.
There will also be a project that will deal with building dynamic heat maps in excel 2016.
We will undertake a project on the creation of basic CRM using excel VBA and SQL express.
There will be a specific project to cover automation using excel VBA.
You will also learn about the creation of an HR attendance register with the help of Excel VBA.
The project will be there subject to the creation of a sales productivity dashboard.
At the next step, the project on the creation of an advanced sales productivity dashboard will be covered.
Learners will undergo training on the creation of a sales dashboard through a project.
Another project will be there to discuss the HR dashboard and its analysis.
In continuance of the above project, an advanced project on the HR dashboard will be conducted.
We will also get to know about interactive dashboards in excel.
Thereafter, we will understand about the creation of a basic project management tool using Treeview and listviews.
Next will a project on the creation of an interactive dashboard using VBA.
A project will there to cover the application of VBA macros.
A specific project will be conducted to discuss the restaurant billing system using excel VBA.
A focused project will be conducted on project schedule indexes.
Another project will be there relating to financial modeling with the use of VBA.
Microsoft excel dashboard training will be conducted through a project.
Case paper creation will be discussed using VBA macros.
Certificate of Completion
What is Excel Advanced and why it is important to learn?
Once you complete the basic excel course, you can upgrade your skill level.
We agree that not all of you need to learn Excel Advanced Course. But if you’re interested or you feel that you need to upgrade your skill level and take your excel learning to the next level, this is just the perfect course for you.
In this advanced Excel course, you will learn additional features, formulas, automation, how to build an attendance register, how to deal with analytics, and a lot more.
And in this Excel Advanced Course, you will also learn VBA and Macro comprehensively.
So, if you think you need to upgrade your excel acumen or you feel you’re good to go with basic excel, try this training. It’s comprehensive, crisp, and the most convenient way to master MS Excel.
What tangible skills will I learn from this Excel Advanced course?
This is an advanced course in MS Excel. So, you would be learning a lot on the same and you will build many micro-skills. We’re highlighting some of them here –
- Microsoft Advanced Excel: This is so obvious. But this Excel Advanced Course isn’t only about the MS Excel Advanced course. It’s much more than just learning the nitty-gritty of how you can master MS Excel.
- VBA & Macro at an advanced level: What you won’t see in any other course is the VBA & Macro that too is at an advanced level. This course will not only teach you MS Excel like a pro, but it would also teach you how to create a CRM using VBA & Macro.
- Statistical Tools: You will learn the statistical tools you need to perform as a data analyst even when your profession doesn’t exactly need it. By learning this micro-skill, you will be ahead of most of your peers.
- Dashboards & Analytics: Along with all other micro-skills, you will also learn how to create basic dashboards and analytics and also upgrade yourself and create advanced analytics and dashboards.
- Willingness to upgrade MS Excel skills: Not everyone would like to do this course. Because for many just a basic level of MS Excel course is enough. But if you feel that your profession demands it and you’re willing to upgrade your skill, you’re more than welcome to do this Excel Advanced Course.
- Basic knowledge of MS Excel: Until you’ve had the basic knowledge of MS Excel, this course won’t be valuable to you. If you’re interested to do this course, first do the basic MS Excel course we have and then come back and complete this Excel Advanced Course.
- Students: Students from any domain can do this Excel Advanced Course. The only thing they need to think about is how relevant this course would be before they sign up.
- Professionals & entrepreneurs: If you’re a professional or an entrepreneur and you want to take your MS Excel skills to the next level, this is the best course in the market you would ever find.
Excel Advanced Course FAQ’s- General Questions
Why should I do this Excel Advanced course?
Because this is the best-advanced course on MS Excel you would ever find in the market.
Can I do this Excel Advanced course even if I’m not from finance?
Certainly yes. You can do this Excel Advanced Course if you find it relevant and useful to your professional or personal interest.
Can I skip the basics before doing this Excel Advanced course?
No. You shouldn’t skip the basic course. Do that first so that you can extract the best value out of this very course.
- You will be way ahead than your peers: After doing this Excel Advanced Course, you will become an unstoppable force in MS Excel. That’s why you would be way ahead than your colleagues.
- You will get promotions quickly: Data analysis matters. And if you can be a master, you will certainly see the tangible and the intangible benefits of it.
Alvaro Chagas da Luz Neto
Advanced Microsoft Excel
eduCBA Advanced Microsoft Excel Course
Advanced Excel 2016
Microsoft Excel Advanced