Learn from Home Offer
Learn from Home Offer
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 38m|
|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 17m|
|Comprehensive VBA and Macros Training||11h 13m|
|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 8m|
|Project - Sales Productivity Dashboard||6h 57m|
|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||8h 28m|
|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 6m|
|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 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 –
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