GeezerVison is showing www.w3schools.com — Excel Tutorial

Search field

W3Schools app iOS & Android Start the adventure

★ +1 Spaces Upgrade Paid Courses Spaces Upgrade Paid Courses

❮

❯

HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP C C++ C# AWS W3.CSS HOW TO BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA TYPESCRIPT ANGULAR ANGULARJS GIT POSTGRESQL MONGODB ASP AI R GO KOTLIN SWIFT SASS VUE GEN AI SCIPY CYBERSECURITY DATA SCIENCE INTRO TO PROGRAMMING HTML & CSS BASH RUST TOOLS

Excel Tutorial

Excel HOME Excel Introduction Excel Get Started Excel Overview Excel Syntax Excel Ranges Excel Fill

Filling Double Click to 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 Addition Excel Subtraction Excel Multiplication Excel Division

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

Tables Table Design Table Resizing Remove Duplicates Convert Table to Range Table Style

Excel Conditional Format Excel Highlight Cell Rules

Highlight Cell Rules HCR - Greater Than HCR - Less Than HCR - Between HCR - Equal To HCR - Text That Contains HCR - Date Occurring HCR - Unique Values

Excel Top Bottom Rules

Top Bottom Rules Above Below Average

Excel Data Bars Excel Color Scales Excel Icon Sets Excel Manage Rules (CF) Excel Charts

Charts Bar Charts Stacked Bar Charts Column Charts Stacked Column Charts Pie Charts Line Charts Stacked Line Charts 100% Stacked Line Charts Radar Charts Excel Charts Customization

Excel PivotTables

Excel PivotTable Intro Excel Create PivotTable Excel PivotTable Values Excel PivotTable Filter Excel PivotTable Group Excel Calculated Field Excel PivotChart

Excel Case

Case: Poke Mart Case: Poke Mart, Styling

Excel Functions

AND AVERAGE AVERAGEIF AVERAGEIFS CONCAT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS DATEDIF FILTER HLOOKUP IF IFERROR IFS INDEX INDEX MATCH LEFT LEN LOWER MATCH MAX MEDIAN MID MIN MODE NETWORKDAYS NPV OR PROPER RAND RIGHT ROUND SORT STDEV.P STDEV.S SUBSTITUTE SUM SUMIF SUMIFS SUMPRODUCT TEXTJOIN TODAY TRIM UNIQUE UPPER VLOOKUP XLOOKUP XOR

Excel How To

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

Excel Cert

Excel Certificate

Excel Examples

Excel Exercises Excel Syllabus Excel Study Plan Excel Training

Excel References

Excel Keyboard Shortcuts

Excel Tutorial

❮ Home Next ❯

Learn Excel

Excel is the world's most used spreadsheet program.

Excel is a powerful tool to use for mathematical functions.

Learn Excel now ❯

Become Excel Certified

Get certified with our Excel exam, includes a professionally curated study kit to guide you from beginner to exam-ready.

Get Certified ❯

Example of the W3Schools Excel certificate

Examples in Each Chapter

Our examples let you copy values into your own spreadsheet, or try them live in the browser:

Example

Try it Yourself »

Case Based Learning

We have created active learning activities, so you can test and build your knowledge. Making the learning experience more fun and engaging.

Solve Case »

Why Study Excel?

Excel is the world's most used spreadsheet program.

Example use areas:

Data analytics
Project management
Finance and accounting

Test Yourself With Exercises

Excel Exercise:

Complete the Excel formula:

1+1

Start the Exercise

Track Your Progress

Create a W3Schools account and get access to more features and learning materials:

View your completed tutorials, exercises, and quizzes
Keep an eye on your progress and daily streaks
Join the leaderboard and compete with others
Get your own avatar and unlock new skins
Create your own personal website

Note

This is an optional feature. You can study at W3Schools without creating an account.

❮ Home
w3schools.com Next ❯
Excel Introduction

★ +1

W3Schools Full Access - your next career move

REMOVE ADS

Learn more about Adventure Mode›

Free account

Track your progress

XP earned 0 Day streak 0 Spaces 0 League —

New

Learn in Adventure Mode W3Schools Adventure App

Coding fundamentals as bite-sized lessons and challenges.

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]

   

FORUM ABOUT CAMPUS

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, cookies and privacy policy.

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

GeezerVison

Excel Tutorial

Excel Formatting

Excel Data Analysis

Excel PivotTables

Excel Case

Excel Functions

Excel How To

Excel Cert

Excel Examples

Excel References

Excel Tutorial

Learn Excel

Become Excel Certified

Examples in Each Chapter

Example

Case Based Learning

Why Study Excel?

Test Yourself With Exercises

Excel Exercise:

Track Your Progress

Create a W3Schools account and get access to more features and learning materials:

Note

Track your progress

Learn in Adventure Mode W3Schools Adventure App

Contact Sales

Report Error

Top Tutorials

Top References

Top Examples

Get Certified