Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI R GO KOTLIN SASS VUE GEN AI SCIPY CYBERSECURITY DATA SCIENCE

Excel Tutorial

Excel HOME Excel Introduction Excel Get Started Excel Overview Excel Syntax Excel Ranges Excel Fill Excel Move Cells Excel Add Cells Excel Delete Cells Excel Undo Redo Excel Formulas Excel Relative Reference Excel Absolute Reference Excel Arithmetic Operators Excel Parentheses Excel Functions

Excel Formatting

Excel Formatting Excel Format Painter Excel Format Colors Excel Format Fonts Excel Format Borders Excel Format Numbers Excel Format Grids Excel Format Settings

Excel Data Analysis

Excel Sort Excel Filter Excel Tables Excel Conditional Format Excel Highlight Cell Rules Excel Top Bottom Rules Excel Data Bars Excel Color Scales Excel Icon Sets Excel Manage Rules (CF) Excel Charts

Table Pivot

Table Pivot Intro

Excel Case

Case: Poke Mart Case: Poke Mart, Styling

Excel Functions

AND AVERAGE AVERAGEIF AVERAGEIFS CONCAT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS IF IFS LEFT LOWER MAX MEDIAN MIN MODE NPV OR RAND RIGHT STDEV.P STDEV.S SUM SUMIF SUMIFS TRIM VLOOKUP XOR

Excel How To

Convert Time to Seconds Difference Between Times NPV (Net Present Value) Remove Duplicates

Excel Examples

Excel Exercises Excel Syllabus Excel Study Plan Excel Certificate Excel Training

Excel References

Excel Keyboard Shortcuts


Excel Training


Introduction: Excel is a standard language for storing, manipulating and retrieving data in databases.

W3Schools offers an Excel training course that covers Excel foundations and more.

The course includes the W3Schools Certified Excel Practitioner certification.

The Excel training is relevant for companies and schools that want to certify their employees or students.

Organizations can track learner progress, get insights and manage everything from licenses to certificates with W3Schools Academy.

Remember that you can always learn for free on W3Schools with the Excel Tutorial.

Buy W3Schools Academy » Watch Demo »

*Academy is available for companies and schools only.


Track progress

Get analytics to track learner progress and results.

Self-paced

Flexible timelines and pacing to match busy schedules.

Globally Recognized

Certifications that are trusted by leading organizations worldwide


Excel Training with W3Schools

W3Schools has been training millions of learners since 1998.

Governments, schools, and organizations worldwide trust W3Schools to train employees and students.

W3Schools training materials and content have been well-proven over the years and are updated regularly.

With the W3Schools Academy pricing model, it is now one of the worlds most affordable quality Excel training options there is.

Learn About Academy »

Learning Outcomes

The Certificate Course includes all the training materials to pass the Certified Excel Practitoner certification exam.

No prerequisites are required to take the course.

The learners will be able to:

  • Master Excel interface and basic operations.
  • Learn Excel syntax and ranges.
  • Understand filling and cell manipulation techniques.
  • Work with formulas and references (relative/absolute).
  • Apply formatting and use Format Painter.
  • Master data analysis with sorting and filtering.
  • Create and customize tables.
  • Use conditional formatting and cell rules.
  • Create and customize various chart types (Bar, Column, Pie, Line).
  • Basics of PivotTables for data analysis.
  • Use Excel functions (AND, AVERAGE, COUNT, IF, SUM, etc.).
  • Apply Excel solutions to practical business cases.

If you are not a company or school, you can still buy the course for personal use.

Read more about W3Schools courses here: W3Schools Courses


Excel Certification

After completing the training modules the learner will take the end of pathway exam.

When the learner passes the exam, the learner will get the Certified Excel Practitoner certification.

The exam is a multiple choice exam with 60 questions and a duration of 60 minutes.

Image of a Excel Certificate:

The certificate does not expire and is valid for lifetime.

It is shareable and can be added to your CV or LinkedIn profile.

You can read more about the certificate here: Excel Certificate


Track Learner Progress

As an employer or a school you can track learner progress and results.

Assign courses to learners with ease and get them started in no time.

With W3Schools Academy you can manage everything from licenses to certificates.

It will give you everything you need to train your employees or students in different technologies.

Image of class overview in Academy:

You can read more about the Academy here: W3Schools Academy

Note: If you don't want to track progress, there is an option to give them access to the course without any management.


Interactive Learning

The course is designed to be interactive and fun to learn.

The learner will engage with different learning activities to keep them engaged.

This includes Excel exercises, quizzes and a final exam.

Stay engaged with hands-on coding challenges that help you practice and test what you've learned.

Image of one of the activity types in the course, a Excel Exercise:

Excel is best learned by doing, and this is why we have included a lot of exercises in the course.


Training Course Overview

Pricing Academy $5.99 / month per learner
Availability For companies and schools only
Course level Beginner
Time to complete 40 hours on average
Course Format Self-paced
Language English
Prerequisites None
Exam and Certification Included
Number of certificates 1
Certificate name Certified Excel Practitioner
Exam format Multiple choice
Certification skill level Intermediate (40%), Advanced (75%) and Professional (90%)
Certification Expiration Never

How to Get Started

  1. Purchase W3Schools Academy access for your organization
  2. Create a class and invite your learners
  3. Assign the Excel course to your class
  4. Monitor learner progress through the admin dashboard
  5. Review analytics and certification results

Are you ready to start training your employees today?

Buy Access to Academy Now »



×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
[email protected]

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
[email protected]

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookie and privacy policy.

Copyright 1999-2025 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.