Excel training online: all lessons

A

Getting Started and Basics

0/8

1

Intro to Excel

Freebeginner 15 min4 tasks

2

Cells, Rows, Columns and the Interface

Freebeginner 15 min3 tasks

3

Entering and Editing Data

Freebeginner 15 min5 tasks

4

Relative vs Absolute References ($, F4)

Freebeginner 15 min3 tasks

5

Fill Right & Fill Down

Freebeginner 15 min4 tasks

6

AutoSum

Freebeginner 15 min3 tasks

7

True & False

Freebeginner 15 min3 tasks

8

Number Formatting Shortcuts

Freebeginner 15 min3 tasks

B

Keyboard Shortcuts and Selection

0/11

9

Intro to Shortcuts

Freebeginner 15 min4 tasks

10

Arrow Keys

Freebeginner 15 min4 tasks

11

Cell Selection Shortcuts

Freebeginner 15 min4 tasks

12

Larger Cell Selections

Freebeginner 15 min4 tasks

13

Row and Column Selections

Freebeginner 15 min4 tasks

14

Cell Selection Shortcuts 2

Freebeginner 15 min4 tasks

15

Larger Cell Selections 2

Freebeginner 15 min4 tasks

16

Cell Selection Skill Summary

Freebeginner 20 min4 tasks

17

Text Formatting Shortcuts

Freebeginner 15 min3 tasks

18

Cut, Copy, Paste

Freebeginner 15 min4 tasks

19

Data Shortcuts

Freebeginner 15 min4 tasks

C

Sum and Count Functions

0/15

20

SUM Function

Freebeginner 15 min4 tasks

21

COUNT Function

Freebeginner 15 min3 tasks

22

Intro to SUMIF

Freebeginner 15 min5 tasks

23

Wildcard Characters

Freebeginner 15 min4 tasks

24

SUMIF & Sum Range

Freebeginner 15 min4 tasks

25

SUMIFS Function

Freebeginner 15 min4 tasks

26

SUM Functions Skill Summary

Freeintermediate 20 min4 tasks

27

SUMIF Practice

Freeintermediate 20 min4 tasks

28

SUMIFS Practice

Freeintermediate 20 min4 tasks

29

COUNTIF Function

Freebeginner 15 min4 tasks

30

COUNTIFS Function

Freebeginner 15 min4 tasks

31

COUNT Practice

Freeintermediate 20 min4 tasks

32

Other Count Functions (COUNTA, COUNTBLANK)

Freebeginner 15 min3 tasks

33

COUNT Skill Summary

Freeintermediate 20 min4 tasks

34

Debugging SUM Functions

Freebeginner 15 min3 tasks

D

Logical Functions

0/7

35

IF Function

Freebeginner 15 min4 tasks

36

AND, OR, XOR Functions

Freebeginner 15 min4 tasks

37

IS Functions

Freebeginner 15 min4 tasks

38

IFS Function

Freebeginner 15 min4 tasks

39

SWITCH Function

Freebeginner 15 min4 tasks

40

IF Combinations

Freeintermediate 15 min4 tasks

41

IFERROR & IFNA Functions

Freebeginner 15 min3 tasks

E

Lookup Functions

0/16

42

VLOOKUP Function

Freeintermediate 15 min4 tasks

43

VLOOKUP Function 2

Freeintermediate 15 min4 tasks

44

VLOOKUP Practice

Freeintermediate 20 min4 tasks

45

More VLOOKUP Practice

Freeintermediate 20 min3 tasks

46

VLOOKUP Approximate Match

Freeintermediate 15 min4 tasks

47

HLOOKUP Function

Freeintermediate 15 min4 tasks

48

HLOOKUP Function 2

Freeintermediate 15 min4 tasks

49

XLOOKUP Function

Freeintermediate 15 min3 tasks

50

XLOOKUP Function 2

Freeintermediate 15 min4 tasks

51

XLOOKUP & Wildcards

Freeintermediate 15 min4 tasks

52

MATCH Function

Freeintermediate 15 min4 tasks

53

MATCH Practice

Freeintermediate 20 min4 tasks

54

INDEX Function

Freeintermediate 15 min4 tasks

55

INDEX MATCH Lookup

Freeintermediate 15 min4 tasks

56

INDEX MATCH Practice

Freeintermediate 20 min4 tasks

57

Index Match Skill Summary

Freeintermediate 20 min4 tasks

F

Text Functions

0/12

58

LEN, LEFT, and RIGHT Functions

Freebeginner 15 min5 tasks

59

MID Function

Freebeginner 15 min4 tasks

60

LEN, LEFT, RIGHT, MID Practice

Freeintermediate 20 min4 tasks

61

FIND Function

Freebeginner 15 min4 tasks

62

SEARCH Function

Freebeginner 15 min4 tasks

63

CONCAT Function

Freebeginner 15 min4 tasks

64

TEXTJOIN Function

Freebeginner 15 min4 tasks

65

UPPER, LOWER, and PROPER Functions

Freebeginner 15 min4 tasks

66

SUBSTITUTE Function

Freebeginner 15 min4 tasks

67

TEXTBEFORE & TEXTAFTER

Freebeginner 15 min4 tasks

68

TRIM & CLEAN Functions

Freebeginner 15 min3 tasks

69

Flash Fill

Freebeginner 15 min4 tasks

G

Statistical and Math Functions

0/9

70

AVERAGE Function

Freebeginner 15 min3 tasks

71

MIN, MAX, LARGE, SMALL Functions

Freebeginner 15 min4 tasks

72

MIN, MAX, LARGE, SMALL Practice

Freeintermediate 20 min4 tasks

73

MEDIAN Function

Freebeginner 15 min4 tasks

74

MODE Function

Freebeginner 15 min4 tasks

75

FLOOR & CEILING Functions

Freebeginner 15 min4 tasks

76

ODD and EVEN Functions

Freebeginner 15 min4 tasks

77

ROUND, ROUNDUP, ROUNDDOWN

Freebeginner 15 min3 tasks

78

SUMPRODUCT Function

Freebeginner 15 min2 tasks

H

Date Functions

0/7

79

DATE Function

Freebeginner 15 min5 tasks

80

TODAY Function

Freebeginner 15 min4 tasks

81

DATEDIF Function

Freebeginner 15 min4 tasks

82

DAYS Function

Freebeginner 15 min4 tasks

83

DATE Functions Skill Summary

Freeintermediate 20 min4 tasks

84

EDATE, EOMONTH, WORKDAY

Freebeginner 15 min4 tasks

85

WEEKDAY and NETWORKDAYS

Freebeginner 15 min4 tasks

I

Tables, Pivots, Formatting and Data Tools

0/13

86

Worksheets

Premiumadvanced 15 min4 tasks

87

Excel Tables and Structured References

Premiumadvanced 15 min7 tasks

88

Table Filters

Premiumadvanced 15 min4 tasks

89

Pivot Tables 1

Premiumadvanced 15 min3 tasks

90

Pivot Tables 2

Premiumadvanced 15 min4 tasks

91

Tables Skill Summary

Premiumadvanced 20 min4 tasks

92

Conditional Formatting

Premiumadvanced 15 min4 tasks

93

Sorting and Custom Sort

Premiumadvanced 15 min4 tasks

94

Remove Duplicates & Find/Replace

Premiumadvanced 15 min4 tasks

95

Data Validation & Dropdown Lists

Premiumadvanced 15 min4 tasks

96

Named Ranges

Premiumadvanced 15 min4 tasks

97

Charts Basics

Premiumadvanced 15 min3 tasks

98

Charts 2: Multi-Series and PivotCharts

Premiumadvanced 15 min3 tasks

J

Dynamic Arrays and Advanced

0/11

99

UNIQUE Function

Premiumadvanced 15 min4 tasks

100

FILTER Function

Premiumadvanced 15 min4 tasks

101

FILTER with Multiple Conditions

Premiumadvanced 15 min4 tasks

102

SORT & SEQUENCE Functions

Premiumadvanced 15 min5 tasks

103

XMATCH and INDEX/XMATCH

Premiumadvanced 15 min4 tasks

104

LET Function

Premiumadvanced 15 min3 tasks

105

LAMBDA Function

Premiumadvanced 15 min4 tasks

106

AVERAGEIFS, MAXIFS and MINIFS

Premiumadvanced 15 min4 tasks

107

RANK and PERCENTILE

Premiumadvanced 15 min4 tasks

108

Financial Functions: PMT, NPV, IRR

Premiumadvanced 15 min4 tasks

109

Loan Planning: FV, PV, NPER, RATE

Premiumadvanced 15 min4 tasks

K

Real-World Projects

0/2

110

Real Estate Analysis

Premiumadvanced 120 mintasks coming soon

111

Hospital Administration

Premiumadvanced 120 mintasks coming soon

Pick a topic and start practising

Getting Started and Basics

Intro to Excel

Cells, Rows, Columns and the Interface

Entering and Editing Data

Relative vs Absolute References ($, F4)

Fill Right & Fill Down

AutoSum

True & False

Number Formatting Shortcuts

Keyboard Shortcuts and Selection

Intro to Shortcuts

Arrow Keys

Cell Selection Shortcuts

Larger Cell Selections

Row and Column Selections

Cell Selection Shortcuts 2

Larger Cell Selections 2

Cell Selection Skill Summary

Text Formatting Shortcuts

Cut, Copy, Paste

Data Shortcuts

Sum and Count Functions

SUM Function

COUNT Function

Intro to SUMIF

Wildcard Characters

SUMIF & Sum Range

SUMIFS Function

SUM Functions Skill Summary

SUMIF Practice

SUMIFS Practice

COUNTIF Function

COUNTIFS Function

COUNT Practice

Other Count Functions (COUNTA, COUNTBLANK)

COUNT Skill Summary

Debugging SUM Functions

Logical Functions

IF Function

AND, OR, XOR Functions

IS Functions

IFS Function

SWITCH Function

IF Combinations

IFERROR & IFNA Functions

Lookup Functions

VLOOKUP Function

VLOOKUP Function 2

VLOOKUP Practice

More VLOOKUP Practice

VLOOKUP Approximate Match

HLOOKUP Function

HLOOKUP Function 2

XLOOKUP Function

XLOOKUP Function 2

XLOOKUP & Wildcards

MATCH Function

MATCH Practice

INDEX Function

INDEX MATCH Lookup

INDEX MATCH Practice

Index Match Skill Summary

Text Functions

LEN, LEFT, and RIGHT Functions

MID Function

LEN, LEFT, RIGHT, MID Practice

FIND Function

SEARCH Function

CONCAT Function

TEXTJOIN Function

UPPER, LOWER, and PROPER Functions

SUBSTITUTE Function

TEXTBEFORE & TEXTAFTER

TRIM & CLEAN Functions

Flash Fill

Statistical and Math Functions

AVERAGE Function

MIN, MAX, LARGE, SMALL Functions

MIN, MAX, LARGE, SMALL Practice