WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login

Canvas is not supported in your browser.

Excel Advanced Training (14 Courses, 19+ Projects)

This Online Advanced Excel Course is a bundle of 14 courses with 125+ hours of video tutorials and Lifetime Access.

We will go step by step and teach you advanced excel like no one does. Topics include Advanced Charts and SmartArt Graphics, Date and Time Functions, Power Pivot, Statistical Tools, Microsoft Excel Simulations, Power Excel, Excel Reports, Building Dynamic Heat Map, Financial Functions, Microsoft Excel Dashboard, Creation of Basic CRM using VBA

BESTSELLER
4.7 (598 ratings)

 

1

Microsoft Excel 2016 – Advanced

2

Microsoft Excel Charts & SmartArt Graphics

3

Mastering

4

Microsoft Excel Date & Time

5

Power Pivot in Microsoft Excel 2016

+

View All Courses & Projects

Offer ends in: Only seats are left with this price


TAKE THIS BUNDLE
Offer

* One Time Payment & Get Lifetime Access
Home » Excel Advanced Training (14 Courses, 19+ Projects)

What you get in this Excel Advanced Training?

Online Classes
Technical Support
Mobile App Access
Case Studies

Advanced Excel Training Online Course Overview

CoursesNo. of Hours
Microsoft Excel 2016 - Advanced5h 11m
Advanced Excel 2016 - Some Important Features3h 26m
Mastering Microsoft Excel Date and Time2h 54m
Pivot Table for Beginners1h 28m
Pivot Tables Hands-on!2h 22m
Project - Analysis with Pivot Tables4h 6m
Power Pivot in Microsoft Excel 20163h 34m
Power Pivot and DAX 20190h 55m
Power Excel Training5h 27m
Microsoft Excel Reports8h 35m
Microsoft Excel Charts and SmartArt Graphics6h 52m
Financial Functions In Excel - Microsoft Excel 2013 Course2h 4m
Statistical Tools in Microsoft Excel1h 14m
Project - Microsoft Excel Simulations Training2h 18m
Project - Building Dynamic Heat Map in Microsoft Excel 20161h 17m
Comprehensive VBA and Macros Training11h 8m
Project - Creation of Basic CRM by using Microsoft Excel VBA and SQL Express3h 56m
Project on VBA Macros - Automation using Loop0h 49m
Project on Excel VBA - Attendance Register using Microsoft Excel VBA2h 7m
Project - Sales Productivity Dashboard6h 57m
Project - Advanced Sales Productivity Dashboard7h 17m
Project - Creating Sales Dashboard using Microsoft Excel1h 35m
Project - HR Dashboard using Excel6h 5m
Project - Advanced HR Dashboard7h 8m
Project - Interactive Dashboards using Microsoft Excel VBA2h 2m
Project on VBA - Project Management Tool with TreeView and ListView2h 25m
Project - Creating Interactive Dashboards using VBA2h 25m
Project on VBA Macros - Create a Login-Logout Tracker3h 4m
Project on Excel VBA - Restaurant Billing System using Microsoft Excel VBA3h 6m
Macros and VBAs Features and Concepts6h 06m
Project on VBA - Project Schedule Indexes2h 57m
Project on VBA - Financial Modeling using VBA3h 9m
Project - Microsoft Excel Dashboard Training6h 1m

Course Advanced Excel Training Course Online
Deal This is a 14 Excel Training course bundle. You will get access to all 14 Excel courses at once.
Hours 125+ Video Hours
Core Coverage Excel 2016 – Advanced, Charts and SmartArt Graphics, Date and Time Functions, Power Pivot, Statistical Tools, Microsoft Excel Simulations, Power Excel, Excel Reports, Building Dynamic Heat Map, Financial Functions, Microsoft Excel Dashboard, Creation of Basic CRM using VBA
Excel Templates Included? Excel templates that were used are provided as a download
Course Validity Lifetime Access. You can view the Advanced Excel Training online course any number of times
Eligibility No eligibility as such. You should have keen interest in learning Excel
Pre-Requisites None.
What do you get? Certificate of Excellence for each of the 14 courses
Certification Type Course Completion Certificates
Verifiable Certificates? Yes, these are verifiable certificates. This means that you will be provided with a unique URL/Link which you can include in your resume/LinkedIn profile for online verification.
Type of Training Video Course – Self-Paced Learning
Software Required Excel (Windows)
System Requirement 1 GB RAM or higher
Other Requirement Speaker / Headphone

Advanced Excel Online Course Curriculum

To give you a brief overview of what you would learn in this Advanced Excel course online, here are the key lessons described below.

S. No. Course Name No. of Courses Course Description
1 Microsoft Excel 2016 – Advanced 1 In this first Advanced Excel training course, you will learn about the fundamentals of what Microsoft Excel 2016 is all about. Since this is an advanced course, you’ll not only learn about the basics, but also the formulas, charts, graphs at an advanced level. This module will help you understand the rest of the course easily.
2 Microsoft Excel Charts and SmartArt Graphics 1 In this Advanced Excel course, you will learn about excel charts and SmartArt Graphics. In this course, you will learn each step in one module. While you learn, make sure that you apply what you’ve been learning.
3 Mastering Microsoft Excel Date and Time 1 As the title suggests, in this Advanced Excel training course online, you will learn about the excel date and time. You will learn how to go to Formulas. Then from Formulas, you will go to Functions. And then select Date & Time in Excel and select NOW. And click OK.
4 Power Pivot in Microsoft Excel 2016 1 In this module, you will learn about the Power Pivot in Microsoft Excel 2016. You will learn much more in detail in this module. But to give you a brief overview, you need to go to File, and then Options and then Add-Ins. Then in the manage box, click on the Com Add-Ins and click Go. Then you need to look at the Microsoft Office Power Pivot Box and check it and click OK.
5 Statistical Tools in Microsoft Excel 1 In this Advanced Excel training course online, you will learn about the statistical tools you would need to use in Microsoft Excel 2016. would need to use. From data analysis to regression analysis, you would learn everything in this module. Look, every time Microsoft Office launches a new version, it has some added functionalities. Doing this course will help you learn how you can apply statistical tools in Microsoft Excel 2016.
6 Microsoft Excel Simulations Training 1 In this module, you will learn to create a model by using the programming language and writing code in it.
7 Power Excel Training 1 In this Advanced Excel training course online, you will discover the most sophisticated analytical tool the MS Excel has, i.e. the power excel training. By using these lessons in the module, you will be able to make sense of the data and derive the meaning for the right decision making.
8 Microsoft Excel Reports 1 How would you make reports? Well, in this module, we will teach you exactly how you can create reports using Microsoft Excel.
9 Building Dynamic Heat Map in Microsoft Excel 2016 1 As the name suggests, in this module, you will learn how you would be able to build a dynamic heat map using MS Excel 2016. It will allow you to use conditional formatting and also help you compare the data visually by picking colors.
10 Financial Functions In Excel – Microsoft Excel Course 1 Financial functions are important, right? Many of you will say a resounding yes. Well, in this module, you will learn the entire financial functions of MS Excel course.
11 Microsoft Excel Dashboard Training 5 In this dashboard training, you will learn about creating a sales dashboard, preparing interactive dashboards, and building HR dashboards & analytics at beginner & advanced level.
12 Creation of Basic CRM by using Microsoft Excel VBA and SQL Express 1 Ask any small business owner? She would be able to tell you the importance of CRM? What if you can create a basic CRM using the Microsoft Excel VBA and SQL Express? Well, in this module, you will learn to do exactly that.
Total Courses –14

Advanced Excel Course Certification

Advanced-Excel-Training

Prerequisites

  • Basic knowledge of Excel: As you can guess, this is the first thing you should have. Without the basic knowledge in Excel, you won’t be able to do this course. This Advanced Excel Course online is specifically designed for advanced individuals/business owners/students who have already mastered the fundamentals of MS Excel.
  • Interest to learn Excel at the advanced level: Let’s say that you don’t need to use Excel at an advanced level in your professional field. Would you be interested to learn an advanced Excel Course? Most probably not. That’s why it’s important that you’re curious and interested to learn Excel at an advanced level.

Target Audience

  • Students who need to use Excel comprehensively: Let’s say that you’re pursuing a course in Finance and you need advanced excel to create complex financial models. This Advanced Excel course, then, would be the perfect one for you. Once you do this Advance Excel Training, you don’t need to go through any additional material to learn advanced excel. This is the best course you would ever get your hands on.
  • Professionals who need to use Excel extensively: If you need to use Excel at an advanced level, this advanced excel training is a must-learn for you. You will not get a course like this in the market.

Who Shouldn’t do this Course?

  • If you don’t have any knowledge of Excel: If this is you, you shouldn’t do this advanced excel course. First, you need to know the basics of MS Excel to be able to extract the maximum value out of it.
  • If you’re not interested at all in learning Excel: Not all professionals/students need to learn Excel, right? If this is you, skip this advanced excel training because you won’t be able to get the value out of this course if you aren’t interested at all in the first place.

Advanced Excel Online Course FAQs

Why should I do this Advanced Excel Course?

Because you won’t get any better course in Advanced Excel than this. This will not only teach you the nitty-gritty of advanced Excel, but it will also teach you the tools and methods to build models, create simulation training, and a lot more.

If I don’t have any knowledge of Excel, should I do this Advanced Excel Course?

The short answer to this is no. But if you can learn the basics quickly, this may not seem daunting to you. To do this course, we recommend a basic sense of the fundamentals.

Advanced Excel Training Course Online Demo Videos

  • Insert Function and Formula

    Insert Function and Formula

    10.44
  • Label positioning in pie chart

    Label positioning in pie chart

    4.54
  • Creating Goal Seek in Excel

    Creating Goal Seek in Excel

    5.22
  • Table Simulations

    Table Simulations

    7.19

Career Benefits

  • It will add immense value to your career: Yes, if you use Excel on a daily basis, this course may become the reason for getting a promotion. This course is powerful. But how much you can take away from this course is always dependent on how much you apply.
  • It will make you an Excel-ninja: Truly, it will make you someone who would master Excel. After this course, analyzing sets of data, building complex models, conducting analysis would be a piece of cake for you.

Course Reviews/Testimonials

Álvaro Chagas da Luz Neto

A complete course for those who want to master excel!

Even though Excel have some confusing/hard content to understand, this course is able to make it quite simple. It’s a nice content for people who knows the basics. First time I see a advanced excel course that offers Solvers and data analysis tools (other courses stop at Pivot)
Linked

 

Michael Akpawu

The most comprehensive online course on advanced excel. I have been exposed to advanced functions in excel and I am extremely happy my proficiency level in Microsoft Excel is advanced. This has been incredibly helpful to me as a portfolio analyst as I am able to complete excel related projects efficiently and effectively.
Linked

 

William Schulz

This course was very thorough and well structured. I learned a significant amount about the different functionalities in Excel and feel like I have at least a basic understanding of many if not all of the features in the program. With practice over time I hope to build on the foundation this course has provided me.
Linked

 

Jeppe Rosenborg

This course was very thorough and well structured. I learned a significant amount about the different functionalities in Excel and feel like I have at least a basic understanding of many if not all of the features in the program. With practice over time I hope to build on the foundation this course has provided me.
Linked

 

Fuad Aliyev

Great explanation of Excel in details. The course includes all types of graphs, calculations and other useful functions that any financial analytic will require in their daily job. I highly recommend this type of courses to anyone who wants to go on a career path as a financial analyst or financial advis
Linked
71 Shares
Share
Tweet
Share
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

OFFER FOR YOU

*Offer is valid only for next 20 min

Leaving so soon?

Get Additional 10% OFF on


Take this Bundle
Book Your One Instructor : One Learner Free Class
CoursesNo. of Hours
Microsoft Excel 2016 - Advanced5h 11m
Advanced Excel 2016 - Some Important Features3h 26m
Mastering Microsoft Excel Date and Time2h 54m
Pivot Table for Beginners1h 28m
Pivot Tables Hands-on!2h 22m
Project - Analysis with Pivot Tables4h 6m
Power Pivot in Microsoft Excel 20163h 34m
Power Pivot and DAX 20190h 55m
Power Excel Training5h 27m
Microsoft Excel Reports8h 35m
Microsoft Excel Charts and SmartArt Graphics6h 52m
Financial Functions In Excel - Microsoft Excel 2013 Course2h 4m
Statistical Tools in Microsoft Excel1h 14m
Project - Microsoft Excel Simulations Training2h 18m
Project - Building Dynamic Heat Map in Microsoft Excel 20161h 17m
Comprehensive VBA and Macros Training11h 8m
Project - Creation of Basic CRM by using Microsoft Excel VBA and SQL Express3h 56m
Project on VBA Macros - Automation using Loop0h 49m
Project on Excel VBA - Attendance Register using Microsoft Excel VBA2h 7m
Project - Sales Productivity Dashboard6h 57m
Project - Advanced Sales Productivity Dashboard7h 17m
Project - Creating Sales Dashboard using Microsoft Excel1h 35m
Project - HR Dashboard using Excel6h 5m
Project - Advanced HR Dashboard7h 8m
Project - Interactive Dashboards using Microsoft Excel VBA2h 2m
Project on VBA - Project Management Tool with TreeView and ListView2h 25m
Project - Creating Interactive Dashboards using VBA2h 25m
Project on VBA Macros - Create a Login-Logout Tracker3h 4m
Project on Excel VBA - Restaurant Billing System using Microsoft Excel VBA3h 6m
Macros and VBAs Features and Concepts6h 06m
Project on VBA - Project Schedule Indexes2h 57m
Project on VBA - Financial Modeling using VBA3h 9m
Project - Microsoft Excel Dashboard Training6h 1m
TAKE THIS BUNDLE
OFFER FOR YOU

*Offer is valid only for next 20 min

Leaving so soon?

Get Additional 10% OFF on



Take this Bundle
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More