Excel Advanced course
19 Online Courses
Verifiable Certificate of Completion
Microsoft Excel 2016 - Advanced5h 11m
Advanced Excel 2016 - Some Important Features2h 38m
Mastering Microsoft Excel Date and Time2h 54m
Pivot Tables for Microsoft Excel 201620m
Power Pivot in Microsoft Excel 20163h 34m
Skills you will master
- Advanced Excel
- Pivot Tables
- Charts and Graphs
- Data Functions
- Financial Functions
- Data simulation
- Chart Simulation
- Data Validation
- Statistical tools
- Power Pivot
- Sales Dashboard
- Excel Reports
Online Excel Advanced Course
This Excel Advanced Course includes 19 Excel courses with 75+ 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.
If you work in the finance domain or in an industry where every day you need to analyze data, prepare reports, look at projections, and present reports to the top-notch clients, you should learn Excel at an advanced level. This Excel Advanced Course will help you learn Advanced Excel Functions, Pivot Tables, Power Pivot, Excel Reports, Excel Charts and Graphs, Excel Simulations, VBA & Macros, Dashboard creation.
- About Excel Advanced Course
- Excel Advanced Course Curriculum
- Certificate of Completion
- Pre-requisites to Excel Advanced Course
- Sample Preview of this Excel Advanced Course
- Target Audience for this Excel Advanced Course
- Online Excel Advanced Course FAQs – General Questions
- Career Benefits of this Excel Advanced Course
- Online Excel Advanced Course Review / Testimonials
About Excel Advanced Course
|Course Name||Online Excel Advanced Course Bundle|
|Deal||You get access to all the 19 courses. You do not need to purchase each course separately.|
|Hours||75+ 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|
|What do you get?||Certificate of Completion for each of the 19 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 Advanced Course Curriculum
In this course, you will learn everything you need to know about the functions and formulas of advanced excel –
|Serial No.||Course Name||Course Description|
|1||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.|
|2||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.|
|3||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.|
|4||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.|
|5||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.|
|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 module will take you around 5 hours 27 minutes and you need to watch 47 videos.|
|7||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.|
|8||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.|
|9||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.|
|10||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.|
|11||Microsoft Excel Simulation 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.|
|12||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.|
|13||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.|
|14||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.|
|15||Automation using Microsoft Excel VBA||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.|
|16||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.|
|17||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.|
|18||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.|
|19||HR Dashboard & Analytics – Advanced||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.
Pre-requisites to Excel Advanced Course
- Willingness to upgrade MS Excel skill: 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.
Target Audience for 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 basic 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.
Career Benefits of this Excel Advanced 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.
Excel Advanced Course Testimonials
Alvaro Chagas da Luz Neto
Advanced Microsoft Excel
eduCBA Advanced Microsoft Excel Course
Advanced Excel 2016
Microsoft Excel Advanced