Skip to main content

pelatihan.orgLearn. Practice. Grow.

Sign in Sign up

pelatihan.org

Learn web development with a clear roadmap, code practice, and quizzes with instant feedback.

Catalog Sign in Subscription

Excel Course: 102 Lessons + Quizzes — pelatihan.org

Home/Catalog/Excel

ExcelAll levels

Excel

Learn Excel online with 102 structured lessons, code examples, and 510 quiz questions.

102 lessons 9 chapters 510 questions

Curriculum

9 chapters · 102 lessons

View full curriculum

Click a lesson to preview its summary and key points for free.

01

Excel Tutorial

17 lessons

01Excel HOME 02Excel Introduction 03Excel Get Started 04Excel Overview 05Excel Syntax

All-course subscription

$5.00 / 30 days

Access every course, lesson, and quiz. Progress is saved automatically.

Sign in to start

102 lesson materials

510 questions

Access all 47 courses

Renew anytime

08Excel Move Cells

09Excel Add Cells

10Excel Delete Cells

11Excel Undo Redo

12Excel Formulas

13Excel Relative Reference

14Excel Absolute Reference

15Excel Arithmetic Operators

16Excel Parentheses

17Excel Functions

02

Excel Data Analysis

11 lessons

01Excel Sort 02Excel Filter 03Excel Tables 04Excel Conditional Format 05Excel Highlight Cell Rules 06Excel Top Bottom Rules 07Excel Data Bars 08Excel Color Scales 09Excel Icon Sets 10Excel Manage Rules (CF)11Excel Charts

03

Excel Formatting

8 lessons

01Excel Formatting 02Excel Format Painter 03Excel Format Colors 04Excel Format Fonts 05Excel Format Borders 06Excel Format Numbers 07Excel Format Grids 08Excel Format Settings

04

Excel PivotTables

7 lessons

01Excel PivotTable Intro 02Excel Create PivotTable 03Excel PivotTable Values 04Excel PivotTable Filter 05Excel PivotTable Group 06Excel Calculated Field 07Excel PivotChart

05

Excel Case

2 lessons

01Case: Poke Mart 02Case: Poke Mart, Styling

06

Excel Functions

50 lessons

01AND 02AVERAGE 03AVERAGEIF 04AVERAGEIFS 05CONCAT 06COUNT 07COUNTA 08COUNTBLANK 09COUNTIF 10COUNTIFS 11DATEDIF 12FILTER 13HLOOKUP 14IF 15IFERROR 16IFS 17INDEX 18INDEX MATCH 19LEFT 20LEN 21LOWER 22MATCH 23MAX 24MEDIAN 25MID 26MIN 27MODE 28NETWORKDAYS 29NPV 30OR 31PROPER 32RAND 33RIGHT 34ROUND 35SORT 36STDEV.P 37STDEV.S 38SUBSTITUTE 39SUM 40SUMIF 41SUMIFS 42SUMPRODUCT 43TEXTJOIN 44TODAY 45TRIM 46UNIQUE 47UPPER 48VLOOKUP 49XLOOKUP 50XOR

07

Excel How To

4 lessons

01Convert Time to Seconds 02Difference Between Times 03NPV (Net Present Value)04Remove Duplicates

08

Excel Examples

3 lessons

01Excel Syllabus 02Excel Study Plan 03Excel Training