Official Certification Course
Become a excel Developer
Master excel with our comprehensive, free interactive course. Pass the exam to earn your industry-recognized certificate. Includes interactive examples, quizzes, and a verifiable digital certificate upon completion.
excel
Course Syllabus
1Excel Tutorial
→
2Excel Exercises
→
3Excel Introduction
→
4Excel Get Started
→
5Excel Overview - Ribbon and Sheet
→
6Excel Syntax
→
7Excel Ranges
→
8Excel Fill
→
9Excel Double Click to Fill
→
10Excel Move Cells
→
11Excel Add Cells
→
12Excel Delete Cells
→
13Excel Undo and Redo
→
14Excel Formulas
→
15Excel Relative and Absolute References
→
16Excel Absolute References
→
17Excel Addition Operator
→
18Excel Subtraction Operator
→
19Excel Multiplication Operator
→
20Excel Division Operator
→
21Excel Parentheses
→
22Excel Functions
→
23Excel Formatting
→
24Excel Format Painter
→
25Excel Format Colors
→
26Excel Format Fonts
→
27Excel Format Borders
→
28Excel Format Numbers
→
29Excel Format Grids
→
30Excel Regional Format Settings
→
31Excel Data Analysis - Sort
→
32Excel Data Analysis - Filter
→
33Excel Tables
→
34Excel Tables
→
35Excel Tables
→
36Excel Tables
→
37Excel Tables
→
38Excel Tables
→
39Excel Conditional Formatting
→
40Excel Highlight Cell Rules
→
41Excel Highlight Cell Rules - Greater Than
→
42Excel Highlight Cell Rules - Less Than
→
43Excel Highlight Cell Rules - Between
→
44Excel Highlight Cell Rules - Equal To
→
45Excel Highlight Cell Rules - Text That Contains
→
46Excel Highlight Cell Rules - A Date Occurring
→
47Excel Highlight Cell Rules - Equal To
→
48Excel Conditional Formatting - Top/Bottom Rules
→
49Excel Above and Below Average Rules
→
50Excel Conditional Formatting - Data Bars
→
51Excel Conditional Formatting - Color Scales
→
52Excel Conditional Formatting - Icon Sets
→
53Excel Conditional Formatting - Manage Rules
→
54Excel Charts
→
55Excel Bar Charts
→
56Excel Stacked Bar Charts
→
57Excel Column Charts
→
58Excel Stacked Column Charts
→
59Pie Charts
→
60Excel Line Charts
→
61Excel Stacked Line Charts
→
62Excel 100% Stacked Line Charts
→
63Excel Radar Charts
→
64Excel Chart Customization
→
65Introduction Excel PivotTable
→
66Excel Case: Poke Mart Shop Cart
→
67Excel Case: Poke Mart Shop Cart, Styling
→
68Excel AND Function
→
69Excel AVERAGE Function
→
70Excel AVERAGEIF Function
→
71Excel AVERAGEIFS Function
→
72Excel CONCAT Function
→
73Excel COUNT Function
→
74Excel COUNTA Function
→
75Excel COUNTBLANK Function
→
76Excel COUNTIF Function
→
77Excel COUNTIFS Function
→
78Excel IF Function
→
79Excel IFS Function
→
80Excel LEFT Function
→
81Excel LOWER Function
→
82Excel MAX Function
→
83Excel MEDIAN Function
→
84Excel MIN Function
→
85Excel MODE Function
→
86Excel NPV Function
→
87Excel OR Function
→
88Excel RAND Function
→
89Excel RIGHT Function
→
90Excel STDEV.S Function
→
91Excel SUM Function
→
92Excel SUMIF Function
→
93Excel SUMIFS Function
→
94Excel TRIM Function
→
95Excel VLOOKUP Function
→
96Excel XOR Function
→
97How to Convert Time to Seconds using Excel
→
98How to Find the Difference Between Two Times Using Excel
→
99How to Calculate NPV Using Excel
→
100How to Remove Duplicates with Excel
→
101Excel Syllabus (Curriculum)
→
102Excel Study Plan
→
103W3Schools Excel Certificate
→
104Excel Training
→
105Excel Keyboard Shortcuts
→
106Exercise v3.0
→
107Excel Highlight Cell Rules - Text That Contains
→
Certificate of Completion
Pass the exam with 70% or higher to earn your official, verifiable certificate.
Exam Duration30 Mins
Questions20-30
Passing Score70%
Why learn excel?
- High demand in the job market
- Core technology for web development
- Foundation for advanced frameworks