New Year '20 Offer
New Year '20 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 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 17m|
|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 –
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 coverage of lifesaving excel tools and functionalities. Learners will gain insight about numerous in-built tools and features in excel and their application in real life so as to gain better results.
Here is a highlight of the coverage of the project.
Learners will go through an intense training on MS Excel 2016 wherein they will learn about data functions, what-if-analysis, arrays, functions, text functions, pivot table, 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 pivot table and gain understanding on other advanced concepts relating to it such as data summarization in pivot table, pivot charts, its printing, macros, power pivot, DAX etc.
Session will be covered on power pivot in Excel 2016 where we will discuss about 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.
Tutorial will be there so as to discuss upon shortcuts in excel, excel functions, vertical lookups, financial functions and average if function.
Next subject area in the training will be excel charts and smart-art graphics. We will discuss about pictures and clip arts, excel charts and data table, pie charts and line charts etc.
Knowledge will be imparted on financial functions such as future value, investment valuation with multiple cash flows, calculating rate of return, analysis of loans and payments and bond valuation.
In the next session, learners will understand 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.
Tutorial will cover apt presentation method for pivot tables.
We will learn about problem handling and automation in excel through a project.
At last, we will undertake a case study on performance rating of employees using excel.
Project will be covered on pivot tables so as 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 on excel data simulation through a project.
There will be also be a project that will deal with building dynamic heat map in excel 2016.
We will undertake a project on creation of basic CRM using excel VBA and SQL express.
There will be a specific project so as to cover automation using excel VBA.
You will also learn about creation of HR attendance register with the help of excel VBA.
Project will be there subjected on creation of sales productivity dashboard.
At next step, project on creation of advanced sales productivity dashboard will be covered.
Learners will undergo training on creation of sales dashboard through a project.
Another project will be there to discuss about HR dashboard and its analysis.
In continuance of above project, an advanced project on HR dashboard will be conducted.
We will also get to know about interactive dashboards in excel.
Thereafter, we will understand about creation of basic project management tool using treeview and listviews.
Next will a project on creation of interactive dashboard using VBA.
A project will there to cover application of VBA macros.
Specific project will be conducted to discuss restaurant billing system using excel VBA.
A focused project will be conducted on project schedule indexes.
Another project will be there relating to financial modelling 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