EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Learn from Home Offer

limited Period offer Offer

Excel Training (23 Courses, 9+ Projects)

This Excel Course includes 23 courses, 9 Projects with 110+ 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. You will learn Excel Functions, Formula, Charts, and Graphs, Pivot tables, excel dashboard creation, simulations in Excel.

BESTSELLER
4.9 (11,788 ratings)

 

1

Microsoft Excel 2016 - Beginners

2

Microsoft Excel 2016 - Advanced

3

Mastering Microsoft Excel Date and Time

4

Pivot Table for Beginners

5

Project - Analysis with Pivot Tables

+

View All Courses & Projects

Offer ends in:


Learn from Home Offer

* One Time Payment & Get Lifetime Access
Home » Excel VBA » Excel VBA Courses » Excel Training (21 Courses, 9+ Projects)

What you get in this Excel Training?

Online Classes
Technical Support
Mobile App Access
Case Studies

About Excel Course

CourseNo. of Hours
Basic Excel Training 20196h 54m
Advanced Excel Training 20199h 41m
Advanced Excel 2019: Essentials for the Real World3h 25m
Microsoft Excel 2016 - Beginners4h
Microsoft Excel 2016 - Advanced5h 15m
Basic Microsoft Excel Training4h 8m
MS Excel 2010 Training Course: Advanced8h 37m
Microsoft Excel Basic Training | Excel 2013 Courses Online | Beginners4h 22m
Microsoft Excel 2013 - Advanced11h 06m
Advanced Excel Formulas1h 58m
Mastering Microsoft Excel Date and Time2h 54m
Shortcuts in Microsoft Excel25m
Pivot Table for Beginners1h 29m
Project - Analysis with Pivot Tables4h 6m
Advanced Excel2h 29m
Power Pivot in Microsoft Excel 20163h 34m
Power Excel Training5h 27m
Microsoft Excel Reports8h 35m
Graphs & Charts in Microsoft Excel 20133h 3m
Microsoft Excel Charts and SmartArt Graphics6h 52m
Financial Functions In Excel - Microsoft Excel 2013 Course2h 33m
Statistical Tools in Microsoft Excel1h 14m
Project - Microsoft Excel Simulations Training2h 18m
Project - Building Dynamic Heat Map in Microsoft Excel 20161h 17m
Microsoft Excel Solver Tutorial49m
Comprehensive VBA and Macros Training11h 8m
Project - Microsoft Excel Dashboard Training6h 1m
Project - Sales Productivity Dashboard6h 57m
Project - Creating Sales Dashboard using Microsoft Excel1h 35m
Project - HR Dashboard using Excel6h 5m
Project - Advanced HR Dashboard7h 8m
Working with Pivot Tables Presentation4h 12m

Course Name Online Excel Course Bundle
Deal You get access to all the 23 courses, 9 Projects. You do not need to purchase each course separately.
Hours 110+ Video Hours
Core Coverage You will learn Excel Functions, Formula, Charts, and Graphs, formatting, pivot tables, power pivot, power excel, excel dashboard creation, simulations, statistical tools, financial functions in excel
Course Validity Lifetime Access
Eligibility Anyone who is serious about mastering Microsoft Excel
Pre-Requisites None
What do you get? Certificate of Completion for each of the 23 courses, 9 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 Course Curriculum


Let’s look at what you will learn in this excel course briefly –

  • Goals
  • Objectives
  • Course Highlights
  • Project Highlights

Goals

The training is an all in one package covering important tools and features of various versions of MS Excel. The course will take you through lifesaving hacks relating to excel which will help you apply the same in your real life and thereby save your time and efforts.

Objectives

The course is based on numerous tools and functionalities of MS Excel. You will learn what are the various options that are in-built in excel and how to use them in order to get favorable results, in least time involved. Topics such as data entry, pivot tables, charts, macros, dashboards, etc. will be covered.

Course Highlights

Here is an insight of the learning areas of the course.

As a first step learners will enhance their understanding about basic concepts of MS Excel 2016 such as data entry, calculations, formulas, formatting, conditional formatting, graphs, pie charts, sorting and filter and so on.

We will then move on to clear our concepts about advanced excel functions of 2016 version such as data functions, what-if-analysis, text functions, auditing formulas, charts etc.

Training will further be conducted on MS Excel 2010. Topics that will be covered includes data entry, calculations, formulas, formatting, conditional formatting, graphs, shortcuts and so on.

Further, an advance training will be held for getting hold on advanced excel concepts of 2010 version such as formatting worksheet, paste special, logical functions, arithmetic functions, date functions, pivot tables and so on.

At next, learners will understand the basic concepts relating to MS Excel 2013, similar to those that were learnt about other excel versions.

Afterwards, advanced concepts relating to MS Excel 2013 will be discussed upon. Topics that will be covered includes useful excel functions, data functions, what-if-analysis, text functions, basic and advanced pivots and so on.

Learners will then master their skills regarding date and time functions in excel.

An understanding will be imparted on basic concepts of pivot tables.

Application of power pivot will be discussed in Excel 2016.

We will then undergo a training on Power Excel which will cover topics such as functions, pivot tables, date and time format, future value function and so on.

Training will be provided about creation of excel reports through the use of various shortcuts and functions.

Learning will be developed on graphs and charts in Excel version 2013. You will learn about basic charts, chart options, formatting, adjustments in charts, changing chart sources and so on.

A tutorial will be conducted about various aspects of excel charts and smart-art graphics and their various types.

Understanding will be gained on financial functions in Excel 2013. Concepts such as future value, valuation of investment using multiple cash flows, calculation of rate of return, bond valuation and so on.

Statistical tools will be explained so as to cover topics such as central tendency, dispersion, correlation and regression, histogram etc.

We will also learn the working of Excel solver, with the help of examples.

Learners will understand the application of VBA and macros using case studies.

Tutorial will cover proper presentation method for pivot tables.

Project Highlights

A project will be conducted on analysis of pivot tables, by coverage of relevant concepts such as formatting, sorting and filtering, grouping and analysis, macros, pivot charts etc.

Training will be provided on excel data simulation through a project.

Learners will also be subjected to a project that will deal with building dynamic heat map in excel 2016.

A comprehensive project will cover the concepts of excel dashboard such as formulas, formatting, filters etc.

Development of sales productivity dashboard will be taught with the help of a project so as to enable learners to create dashboards on their own.

We will also undertake a project to know about the creation of sales dashboard.

Next project will talk about creation of HR dashboard and its analysis.

For HR personnel, an advanced project will be there, so as to cover advanced HR dashboard and its analysis.


Certificate of Completion

Excel Course Certification


 

What is Excel and why it is important to learn?

No matter the profession you are in, you need to learn Excel.

From data analysis to the presentation of a data set, you can easily use Excel. Also, the easiest way to create a projection report or a graph is by using Excel.

You can be in finance, marketing, HR, analytics, you need to learn Excel to be an all-around professional.

Whenever employees are hired, it’s given that they know MS Excel. But truthfully, most people don’t take the time to learn and we would agree that the lack of comprehensive material is one of the reasons that people don’t try their hands-on Excel.

That’s why we created this comprehensive MS Excel course that will make you a complete professional.

We have covered just enough so that you are equipped to handle MS Excel on your own.
Do the course and practice and leave the rest to us.

What tangible skills will I learn from this Excel course?

You would learn a lot. We are just highlighting a few Microsoft Excel skills that you shall learn below-

MS Excel (Basic & Advanced): You will learn both the basics and advanced MS Excel in this course. We have just covered enough to get you going.

Statistical tools & Financial functions: Even if you’re from a different domain, you may find the statistical tools and the financial functions covered in this course handy.

Fundamental knowledge in Macros & VBA: You will learn a lot about how to create Macros and VBA so that you can use it in your own domain of work

Pre-requisites

Willingness to learn MS Excel: If you feel that you need to learn the nitty-gritty of MS Excel, this is the right course for you. Just for the sake of doing (without any motive or interest) won’t produce the best result even after doing this Excel course.

A basic sense of maths: You don’t need to know everything about mathematics. But a fundamental sense would definitely help.

Target Audience

Students from any domain: If you’re a student, you can do this Excel course. It will teach you the functions, formulas you need to learn to get ahead in your job search/ employment.

Professionals from any domain/industry: If you’re a professional and you feel that you need to learn the nitty-gritty of MS Excel, this excel course may be the right one for you.

Excel Course FAQ’s- General Questions


Why should I do this Excel course?

Because this is the best course you would ever find on MS Excel. If you’re looking for learning Excel, your search ends here.

I’m not from the finance domain. Can I do this Excel course?

Yes. Anyone from any domain or industry can do this excel course if interested.

What would I get out of this Excel course?

A lot. Once you do this course, it’s given that you don’t need to worry about Excel again (provided you do the work on what you learn)

Sample Preview 


  • Accessing MS Excel

    Accessing MS Excel

    02:41
  • Cells in Excel

    Cells in Excel

    01:18
  • CHOOSE Function

    CHOOSE Function

    02:37
  • Logical Function - AND

    Logical Function - AND

    01:12
  • Text Function 1

    Text Function 1

    02:29
  • HR Dashboard Creation

    HR Dashboard Creation

    01:35

Career Benefits

You will be ahead of many of your peers: This excel course will help you stand out. You will be the go-to-guy for that presentation, that excel sheet, or that project report after doing this course.

You will be able to do much more than just data analysis: Yes, this excel course is not about just understanding functions & formulas. You will also learn about the tricks about creating reports and you will also learn VBA and Macros.

Testimonials


Fredric C - Excel Course

Testimonials

Power Pivots in Excel Course

Pivot table is a built in feature in excel. This excel course helped me how to add this feature. Understood how to import data, inserting functions, test connection, change column names, creating a pivot chart with various variables, difference between pivot table and power chart, how to create two pivot charts for the same data, how to create four pivot chats for the same data. Simply awesome course how to create pivot table.
Linked

Fredric C

 

Greg Kowalczyk - Excel Course

Testimonials

Useful course

I always wanted to learn Pivot tables as my job requires it. This excel course from eduCBA came in very handy. As far as I am concerned, euCBA courses are more useful to me than Pluralsight.com, Lynda.com or day courses, because eduCBA is far more affordable. Also, new courses are created daily which are very practical.
Linked

Greg Kowalczyk

 

avinash bawa - Excel Course

Testimonials

Excel stimulation technique.

It was joyful experience learning with you the core techniques of the excel so i must say you did a wonderful job on the relevant details.The stimulation work fine when all other things are working very well.Overall was a good learning experience, need to say that stuff which you did was good at all level.
Linked

avinash bawa

 

avinash bawa - Excel Course

Testimonials

Power Excel Tools

The course is focused mainly on pivot tables. If you have a large data set and you want to analyse it, Pivot table will come handy and is an extremely strong tool. The course is well designed and explains all the features and uses of pivot table in a nice way. I would like to recommend it for anyone looking to learn data analysis.
Linked

Ayush Sharma

 

    Find excel course in other Countries/Cities


  • Hyderabad
  • Gurgaon
  • Chennai
  • Bangalore
  • Dubai
  • Malaysia
  • London
  • Delhi
  • Singapore
  • Sydney
  • Delhi
  • Singapore
  • Mumbai
Footer
Follow us!
  • Refer and Earn
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedIN
  • EDUCBA InstagramEDUCBA Youtube
Company
  • About us
  • Alumni Speak
  • Contact Us
  • Sign Up
Work with us
  • Careers
  • Become an instructor
  • Become a partner
Resources
  • Blog
  • Live Online Training
  • Self-Paced Training
  • Corporate Training
  • ExamTurf
  • Verifiable Certificate
Popular Categories
  • Finance
  • Data Science
  • Software and Tech
  • Design and Drawing
  • Excel
  • Project Management
  • Marketing
  • Personal Development
  • Human Resource
Popular All-in-one Bundle Courses
All In One Financial Analyst Bundle | All In One Data Science Bundle | All In One Software Development Bundle | All In One Excel VBA Bundle | All In One Design Bundle | All In One Project Management Bundle | All In One Personal Development Bundle | All In One Marketing Bundle |
Popular Finance Certification Courses
Investment Banking Course | Financial Modeling Course | Project Finance Training | Business Valuation Training | Accounting Course Bundle | Financial Analytics Training | Mergers & Acquisition Course | Finance For Non Finance Managers Course | Cryptocurrency Training | US GAAP Course | LBO Modeling Course | Hedge Funds Course | IFRS Training | Credit Risk Modeling Course | GST Training Program | Mutual Funds Training | Private Equity Training | Venture Capital Course | Fixed Income Course | Equity Research Training | Corporate Finance Training Bundle |
Popular Live Online Courses
Advanced Minitab Training | Tableau Desktop Training | PMP Certification Exam Prep Training | Data Science With Python | Machine Learning | Python GUI Training | Python Scripting | Java Programming | Ultimate .Net Training | Financial Modeling |
Trending Exam Prep Courses
CFA 1 | CFA 2 | FRM 1 | FRM 2 | CMA 1 | CMA 2 | PMP Training | PMI SP Training | PMI RMP Training | Scrum Master Training | Six Sigma Green Belt Prep Training | PMI ACP Training | CAPM Training | PgMP Training | CBAP Training |
Popular Data Science Certification Courses
Data Science with Python Certification Course | Machine Learning Training | Hadoop Training Program | R Programming Training | SAS Training | EViews Econometrics Training | Cloud Computing Training | AWS Training | SPSS Training Program | IoT Training | Tableau Training | Deep Learning Training | Apache Pig Training | Splunk Training Program | Azure Training | Pandas And NumPy Tutorial | Hive Training | SEO Training | Multisim Training | Minitab Training | Salesforce Training | MapReduce Training | MS SQL Training | TensorFlow Training | Informatica Training | Microsoft Power BI Training | Ansible Training | QlikView Training | OpenCV Training | Docker Training | DevOps Training | MATLAB Training |
Business Analytics Certification Courses
Business Analytics Training | Statistical Analysis Training | Data Visualization Training | Business Intelligence Training | Forecasting Models Course | Time Series Course | Fraud Analytics Course | Artificial Intelligence Training | Customer Analytics Training | Marketing Analytics Training | Time Series Analysis and Forecasting with Python | Time Series Analysis and Forecasting with Minitab | Time Series Analysis and Forecasting with Tableau | Time Series Analysis and Forecasting with R | Time Series Analysis and Forecasting with Excel | Time Series Analysis and Forecasting with SAS | Predictive Modeling with Python Course | Predictive Analytics Course | Predictive Modeling with SAS Enterprise Miner |
Popular Software and Development Courses
Python | iOS | VB.net | JavaScript | Selenium | Java | Android | C++ | Windows Forms | XML Training | Angular JS | Linux | Bootstrap | Swift Training | JDBC Training | Ruby On Rails | J2EE | WPF | HTML Training | Ionic 4 Tutorials | JQuery UI Course | Java Servlet | C Programming | Spring Boot Training Program | Red Hat Linux Training Program | Ubuntu Training Program | Spring Framework Training | ServiceNow | Joomla | ASP.net | Oracle | C# | ADO.net | JQuery | Ethical Hacking | Kali Linux | Cyber Security Training | Penetration Testing | Django | Windows 10 | SQL Training Program | CSS Training | TestNG | PLSQL | MongoDB | JUnit | Robotic Process Automation RPA Training | PHP Training | React JS Redux Training | PostgreSQL Course |
Popular Design and Drawing Courses
AutoCAD Training | SketchUp Course | SolidWorks Training | Unity Training | Unreal Engine Training | MonoGame Course | DirectX Training | Photoshop Training | Corel Draw Training | Illustrator Training | OpenGL Course |
Popular Film Editing and VFX Courses
After Effects Training | Cinema 4D Training | Pixelan VFX Tutorial | Boris FX Tutorial | Blackmagic Fusion Training | RealFlow Tutorial | Autodesk Combustion Training | Natron Tutorial | Nuke Training | Silhouette FX Tutorial | Sony Vegas Pro Tutorial | Adobe Premiere Pro Tutorial | DaVinci Resolve Training | NewBlueFX Tutorial | Lightworks Tutorial | Avid Media ComposerTraining | FL Studio Training | Melodyne Tutorial | Pro Tools Training | Audacity Training |
Top 3D Modeling and Animation Courses
Maya Training | Houdini Training | 3D Max Training | Blender Course | ZBrush Training | Cinema 4D Training | Mudbox Course |
Popular Excel and Office Productivity Courses
Excel Training | Excel Advanced Training | VBA Training | Excel Data Analysis Training | Excel For HR Training | Excel For Finance Training | Excel For Marketing Training | Pivot Table Training | Microsoft Access Training | MS Office Training | MS Office For MAC | Microsoft Word Training |
Top Business and Management Courses
Strategic Management Training | Marketing Training Program | Digital Marketing Training | CRM Training | Market Research Training | Content Marketing Course | Logistics And Supply Chain Training | Business Analysis Training | Retail Management Training | Content Development Training | Job Interview Training | Personality Development Course | Quality Management Training | Project Management Training Program | Agile Scrum Training | Primavera Training | Lean Management Training | Project Estimation Training | Project Cost Management Training | Project Planning Course |
Trending Resources
Blog | Python Tutorial | Java Tutorial | C sharp Tutorial | HTML Tutorial | JavaScript Tutorial | PHP Tutorial | Big Data Tutorial | Hadoop Tutorial | Machine Learning Tutorial | Artificial Intelligence Tutorial | DevOps Tutorial | Tableau Tutorial | Photoshop Tutorial | After Effects Tutorial | Illustrator Tutorial | AutoCAD Tutorial | 3ds Max Tutorial | CorelDraw Tutorial |
Apps
EDUCBA Android AppEDUCBA iOS App
  • Terms & Conditions
  • Disclaimer
  • Privacy Policy & Cookie Policy
  • Shipping Policy

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

CoursesNo. of Hours
Basic Excel Training 20196h 54m
Advanced Excel Training 20199h 41m
Advanced Excel 2019: Essentials for the Real World3h 25m
Microsoft Excel 2016 - Beginners4h
Microsoft Excel 2016 - Advanced5h 15m
Basic Microsoft Excel Training4h 8m
MS Excel 2010 Training Course: Advanced8h 37m
Microsoft Excel Basic Training | Excel 2013 Courses Online | Beginners4h 22m
Microsoft Excel 2013 - Advanced11h 06m
Advanced Excel Formulas1h 58m
Mastering Microsoft Excel Date and Time2h 54m
Shortcuts in Microsoft Excel0h 43m
Pivot Table for Beginners1h 29m
Project - Analysis with Pivot Tables4h 6m
Advanced Excel2h 29m
Power Pivot in Microsoft Excel 20163h 34m
Power Excel Training5h 27m
Microsoft Excel Reports8h 35m
Graphs & Charts in Microsoft Excel 20133h 3m
Microsoft Excel Charts and SmartArt Graphics6h 52m
Financial Functions In Excel - Microsoft Excel 2013 Course2h 33m
Statistical Tools in Microsoft Excel1h 14m
Project - Microsoft Excel Simulations Training2h 18m
Project - Building Dynamic Heat Map in Microsoft Excel 20161h 17m
Microsoft Excel Solver Tutorial1h 23m
Comprehensive VBA and Macros Training11h 8m
Project - Microsoft Excel Dashboard Training6h 1m
Project - Sales Productivity Dashboard6h 57m
Project - Creating Sales Dashboard using Microsoft Excel1h 35m
Project - HR Dashboard using Excel6h 5m
Project - Advanced HR Dashboard7h 8m
Working with Pivot Tables Presentation4h 12m
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

OFFER FOR YOU

*Offer is valid only for next 20 min

Leaving so soon?

Get Additional 10% OFF on



Enroll Now
OFFER FOR YOU

*Offer is valid only for next 20 min

Leaving so soon?

Get Additional 10% OFF on
₹1999 ₹1799.1

Enroll Now

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