Skip to content

Topics Projects Practice Functions Blog

Upgrade Sign in

Loading…

Course

Excel Mastery Path

0/109

1.Intro to Excel15m
2.Cells, Rows, Columns and the Interface15m
3.Entering and Editing Data15m
4.Relative vs Absolute References ($, F4)15m
5.Fill Right & Fill Down15m
6.AutoSum15m
7.True & False15m
8.Number Formatting Shortcuts15m

9.Intro to Shortcuts15m
10.Arrow Keys15m
11.Cell Selection Shortcuts15m
12.Larger Cell Selections15m
13.Row and Column Selections15m
14.Cell Selection Shortcuts 215m
15.Larger Cell Selections 215m
16.Cell Selection Skill Summary20m
17.Text Formatting Shortcuts15m
18.Cut, Copy, Paste15m
19.Data Shortcuts15m

20.SUM Function15m
21.COUNT Function15m
22.Intro to SUMIF15m
23.Wildcard Characters15m
24.SUMIF & Sum Range15m
25.SUMIFS Function15m
26.SUM Functions Skill Summary20m
27.SUMIF Practice20m
28.SUMIFS Practice20m
29.COUNTIF Function15m
30.COUNTIFS Function15m
31.COUNT Practice20m
32.Other Count Functions (COUNTA, COUNTBLANK)15m
33.COUNT Skill Summary20m
34.Debugging SUM Functions15m

35.IF Function15m
36.AND, OR, XOR Functions15m
37.IS Functions15m
38.IFS Function15m
39.SWITCH Function15m
40.IF Combinations15m
41.IFERROR & IFNA Functions15m

42.VLOOKUP Function15m
43.VLOOKUP Function 215m
44.VLOOKUP Practice20m
45.More VLOOKUP Practice20m
46.VLOOKUP Approximate Match15m
47.HLOOKUP Function15m
48.HLOOKUP Function 215m
49.XLOOKUP Function15m
50.XLOOKUP Function 215m
51.XLOOKUP & Wildcards15m
52.MATCH Function15m
53.MATCH Practice20m
54.INDEX Function15m
55.INDEX MATCH Lookup15m
56.INDEX MATCH Practice20m
57.Index Match Skill Summary20m

58.LEN, LEFT, and RIGHT Functions15m
59.MID Function15m
60.LEN, LEFT, RIGHT, MID Practice20m
61.FIND Function15m
62.SEARCH Function15m
63.CONCAT Function15m
64.TEXTJOIN Function15m
Practice
65.UPPER, LOWER, and PROPER Functions15m
66.SUBSTITUTE Function15m
67.TEXTBEFORE & TEXTAFTER15m
68.TRIM & CLEAN Functions15m
69.Flash Fill15m

70.AVERAGE Function15m
71.MIN, MAX, LARGE, SMALL Functions15m
72.MIN, MAX, LARGE, SMALL Practice20m
73.MEDIAN Function15m
74.MODE Function15m
75.FLOOR & CEILING Functions15m
76.ODD and EVEN Functions15m
77.ROUND, ROUNDUP, ROUNDDOWN15m
78.SUMPRODUCT Function15m

79.DATE Function15m
80.TODAY Function15m
81.DATEDIF Function15m
82.DAYS Function15m
83.DATE Functions Skill Summary20m
84.EDATE, EOMONTH, WORKDAY15m
85.WEEKDAY and NETWORKDAYS15m

86.Worksheets15m
87.Excel Tables and Structured References15m
88.Table Filters15m
89.Pivot Tables 115m
90.Pivot Tables 215m
91.Tables Skill Summary20m
92.Conditional Formatting15m
93.Sorting and Custom Sort15m
94.Remove Duplicates & Find/Replace15m
95.Data Validation & Dropdown Lists15m
96.Named Ranges15m
97.Charts Basics15m
98.Charts 2: Multi-Series and PivotCharts15m

99.UNIQUE Function15m
100.FILTER Function15m
101.FILTER with Multiple Conditions15m
102.SORT & SEQUENCE Functions15m
103.XMATCH and INDEX/XMATCH15m
104.LET Function15m
105.LAMBDA Function15m
106.AVERAGEIFS, MAXIFS and MINIFS15m
107.RANK and PERCENTILE15m
108.Financial Functions: PMT, NPV, IRR15m
109.Loan Planning: FV, PV, NPER, RATE15m

110.Real Estate Analysis120m
111.Hospital Administration120m

Topics/Text Functions

TEXTJOIN Function

Freebeginner 15 min4 tasks0/60 pts

TEXTJOIN joins many cells using one delimiter, and can skip empty cells. Set ignore_empty to TRUE to avoid stray separators.

Syntax

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Example: =TEXTJOIN(", ",TRUE,A2:C2) joins the row with commas and drops blanks.

Common mistakes

Setting ignore_empty to FALSE and ending up with ", ," in the result.
Forgetting the space inside the delimiter.

CONCAT Function UPPER, LOWER, and PROPER Functions

Read the lesson, then try it yourself in a live spreadsheet.