Skip to content

Excel formulas

From your first sum to lookups and dynamic arrays, typed into a live spreadsheet.

14 of 14 modules ready · 74 lessons · 244 exercises

    1. 1. LEN: count characters (0 of 3 done)
    2. 2. LEFT and RIGHT (0 of 3 done)
    3. 3. MID: text from the middle (0 of 3 done)
    4. 4. FIND and SEARCH (0 of 4 done)
    5. 5. Split names and emails (0 of 4 done)
    6. 6. Wildcards: * and ? (0 of 4 done)
    Module page
    1. 1. Join text with & and CONCAT (0 of 3 done)
    2. 2. TEXTJOIN: join with a separator (0 of 3 done)
    3. 3. UPPER, LOWER, PROPER (0 of 3 done)
    4. 4. TRIM: remove extra spaces (0 of 3 done)
    5. 5. SUBSTITUTE: replace text (0 of 3 done)
    6. 6. TEXTBEFORE and TEXTAFTER (0 of 4 done)
    Module page