Excel Advanced Training
This Excel Advanced Course includes 41 courses with 145+ hours of video tutorials and One year 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.
BESTSELLER
* One Time Payment & Get One year access
Offer ends in:
What you'll get
- 145+ Hours
- 41 Courses
- Course Completion Certificates
- One year access
- Self-paced Courses
- Technical Support
- Mobile App Access
- Case Studies
Synopsis
Content
-
Section 1
Courses No. of Hours Certificates Details Microsoft Excel - Advanced 9h 21m ✔ Advanced Excel Practicals: Essentials for the Real World 3h 25m ✔ Advanced Excel for Financial Analysis 5h 38m ✔ Advanced Excel - Some Important Features 3h 21m ✔ Mastering Microsoft Excel Date and Time 2h 47m ✔ Advanced Excel Formulas 2h 26m ✔ -
Section 2
Courses No. of Hours Certificates Details Pivot Table for Beginners 1h 28m ✔ Pivot Tables Hands-on! 2h 3m ✔ Advanced Excel 2h 3m ✔ Data Analysis with Pivot Tables 4h 58m ✔ Power Pivot in Microsoft Excel 3h 31m ✔ Power Pivot and DAX 32m ✔ Power Excel Training 5h 12m ✔ -
Section 3
Courses No. of Hours Certificates Details MS Excel Shortcuts 8h 5m ✔ Microsoft Excel Charts and SmartArt Graphics 6h 4m ✔ Financial Functions In MS Excel 2h 36m ✔ Statistical Tools in Microsoft Excel 1h 11m ✔ MS Excel Simulations Training 2h 15m ✔ Project - Building Dynamic Heat Map in Microsoft Excel 1h 15m ✔ -
Section 4
Courses No. of Hours Certificates Details Comprehensive VBA and Macros Training 10h 45m ✔ 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 ✔ -
Section 5
Courses No. of Hours Certificates Details MS Excel HR Dashboard 5h 56m ✔ Advanced HR Dashboard with MS Excel 8h 11m ✔ Interactive Dashboards using VBA 1h 6m ✔ TreeView and ListView in VBA 2h 23m ✔ Interactive Sales Dashboards using MS Excel & VBA 2h 18m ✔ Project on VBA Macros - Create a Login-Logout Tracker 3h 35m ✔ Project on Excel VBA - Restaurant Billing System using Microsoft Excel VBA 3h 1m ✔ Macros and VBAs Features and Concepts 6h 39m ✔ Project on VBA - Project Schedule Indexes 2h 52m ✔ Project on VBA - Financial Modeling using VBA 3h 7m ✔ MS Excel Dashboard Training 5h 45m ✔ Project - Case Paper using Excel VBA and Macros 2h 51m ✔ 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 ✔
Course Ratings
* One Time Payment & Get One year access
Offer ends in:
Training 5 or more people?
Get your team access to 5,000+ top courses, learning paths, mock tests anytime, anywhere.
Drop an email at: [email protected]
I have learned a lot from your courses about Excel. I can say it is especially useful for people who lack in advanced Excel skills. Everything in videos are very clear and well-defined. I am very happy with the result, so thank you for providing us with the good quality of programs!
Gizem Ayvazoglu
Great course for someone like me who's been using Excel everyday but didn't know about data analysis tool available in it. I've always have to open JMP for analysis even just for simple charting and correlation plotting. Now I know I can do that in Excel too. Thanks! 🙂
Michelle Esber
This was very exceptional never even thought i could gather this much. Thanks for this great opportunity.
OYEWOLE, DIMEJI YEMI
This course was great to attend and learn about Excel's "Data Analytics" add-in function!
Sumari Hattingh Van Niekerk