Excel Advanced Training (14 Courses, 23+ Projects)
This Excel Advanced Course includes 14 courses, 23 Projects with 133+ 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. This course is dedicated for you to learn Advanced Excel Functions, Pivot Tables, VBA & Macros, Dashboard creation etc.
Microsoft Excel 2016 - Advanced
Advanced Excel 2016 - Some Important Features
Mastering Microsoft Excel Date and Time
Pivot Table for Beginners
Pivot Tables Hands-on!
What you get in this Excel Advanced Training?
Mobile App Access
About Excel Advanced Course
|Course||No. of Hours|
|Microsoft Excel 2016 - Advanced||5h 11m|
|Advanced Excel 2016 - Some Important Features||3h 26m|
|Mastering Microsoft Excel Date and Time||2h 54m|
|Pivot Table for Beginners||1h 29m|
|Pivot Tables Hands-on!||2h 22m|
|Project - Analysis with Pivot Tables||4h 6m|
|Power Pivot in Microsoft Excel 2016||3h 34m|
|Power Pivot and DAX 2019||32m|
|Power Excel Training||5h 27m|
|Microsoft Excel Reports||8h 35m|
|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|
|Comprehensive VBA and Macros Training||10h 46m|
|Project - Creation of Basic CRM by using Microsoft Excel VBA and SQL Express||3h 56m|
|Project on VBA Macros - Automation using Loop||29m|
|Project on Excel VBA - Attendance Register using Microsoft Excel VBA||2h 7m|
|Project - Sales Productivity Dashboard||7h 2m|
|Project - Advanced Sales Productivity Dashboard||7h 22m|
|Project - Creating Sales Dashboard using Microsoft Excel||1h 35m|
|Project - HR Dashboard using Excel||6h 5m|
|Project - Advanced HR Dashboard||7h 8m|
|Project - Interactive Dashboards using Microsoft Excel VBA||2h 4m|
|Project on VBA - Project Management Tool with TreeView and ListView||2h 25m|
|Project - Creating Interactive Dashboards using VBA||2h 25m|
|Project on VBA Macros - Create a Login-Logout Tracker||3h 4m|
|Project on Excel VBA - Restaurant Billing System using Microsoft Excel VBA||3h 5m|
|Macros and VBAs Features and Concepts||6h 06m|
|Project on VBA - Project Schedule Indexes||2h 57m|
|Project on VBA - Financial Modeling using VBA||3h 9m|
|Project - Microsoft Excel Dashboard Training||6h 1m|
|Project - Case Paper using Excel VBA and Macros||2h 54m|
|Working with Pivot Tables Presentation||4h 12m|
|Pivot Table Project - Problem Handling and Automation||1h 15m|
|Pivot Table Case Study - Performance Ratings of Employees||1h 12m|
|Course Name||Online Excel Advanced Course Bundle|
|Deal||You get access to all the 14 courses, 23 Projects. You do not need to purchase each course separately.|
|Hours||133+ 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 who is serious about mastering Microsoft Excel|
|Pre-Requisites||Basic Excel Knowledge|
|What do you get?||Certificate of Completion for each of the 14 courses, 23 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 Advanced Course Curriculum
In this course, you will learn everything you need to know about the functions and formulas of advanced excel –
Microsoft Excel 2016 - Advanced
We will start this Excel Advanced 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.
Advanced Excel 2016 - Some Important Features
This module will focus on the important features (advanced) that you need to learn. We will start with a brief introduction. And then, we will take you through the shortcuts, excel controls, cell comments, named ranges, and at last the excel advanced formulas. The entire training module will take you 2 hours 25 minutes and you need to watch 19 videos in total.
Mastering Microsoft Excel Date and Time
This Excel Advanced 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 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 Advanced Course 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 module will take you around 5 hours 27 minutes and you need to watch 47 videos.
Microsoft Excel Reports
This Excel Advanced Course 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.
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 Advanced Course, we will start with a brief overview. 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
In this Excel Advanced Course, 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.
Comprehensive VBA and Macros Training
This module 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 - Creation of Basic CRM by using Microsoft Excel VBA and SQL Express
In this Excel Advanced Course module, we will give a brief overview of the CRM using Powerpoint. Then, we will give you a basic demo of running CRM, VBA learning process & access DB, VBA coding, and the admin module. This entire module will take you around 3 hours 56 minutes and you need to watch 30 videos in total.
Project on VBA Macros - Automation using Loop
This is an introductory module on the automation using MS Excel VBA. We will start this module with the introduction - the next loop and the next statement. And then, we will take you through"Do Loop Until Statement’, nested loop, and finally,"While Wend Statement’. This entire module will take you around 29 minutes and you need to watch 5 videos in total.
Project on Excel VBA - Attendance Register using Microsoft Excel VBA
This Excel Advanced Course module is dedicated to creating an attendance register. We will start with a brief introduction and then, we will talk about how you can create a project interface, generate student ID in attendance register, and finally will talk about display date and save mark. You need to invest around 2 hours 7 minutes and you need to watch 24 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 Advanced 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 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