Icons & text

  • Icon & text

    Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?

  • Icon & text

    Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?

  • Icon & text

    Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?

Course curriculum

    1. John's Welcome

    2. Oz's Welcome

    3. Course Introduction

    4. Connect with John & Oz

    5. MyExcelOnline Resources

    6. Terms & Conditions - Video Sharing Limitations

    1. DOWNLOADABLE EXCEL WORKBOOKS

    2. TEXT - Intro

    3. CLEAN - Intro

    4. CONCATENATE - Intro

    5. FIND - Intro

    6. LEFT - Intro

    7. RIGHT - Intro

    8. PROPER - Intro

    9. REPLACE - Intro

    10. REPLACE - Phone Area Codes

    11. REPLACE - Insert Hyphens in your Serial Number

    12. REPLACE - Extract Last Name

    13. REPLACE - Clear Everything Before the Hyphen

    14. Replace - Insert New Code within Old Part Numbers

    15. MID - Intro

    16. MID - Extract Numbers Between Hyphens

    17. MID - Extract Cell Contents into Separate Rows

    18. SUBSTITUTE - Intro

    19. SUBSTITUTE - Add Comma After The Surname

    20. SUBSTITUTE - Remove Second Hyphen

    21. SUBSTITUTE - Count Text Occurrences in a Cell

    22. SUBSTITUTE - Report Name

    23. TRIM - Intro

    24. TIP - Convert Formulas to Values

    25. TIP - Convert Text to Numbers

    26. Text Function Quiz

    1. DOWNLOADABLE EXCEL WORKBOOKS

    2. VLOOKUP FALSE - Intro

    3. VLOOKUP TRUE - Explained

    4. VLOOKUP TRUE - Categorizing Data

    5. MATCH - Intro

    1. DOWNLOADABLE EXCEL WORKBOOKS

    2. IF - Change Negative Values Using the IF function

    3. Comparing Lists

    4. Filling Holes

    5. Filling in City Holes

    6. Filling Many Holes in Data

    7. Formula Case Study Quiz

    1. Data Cleansing v Data Shaping

    2. Data Shaping and Flat Files

    3. Data Shaping & Flat Files Quiz

    1. DOWNLOADABLE EXCEL WORKBOOKS

    2. One Click Dates

    3. Regional Dates

    4. Remove Emails

    5. Split Full Names

    6. Text to Columns Quiz

About this course

  • $297.00
  • 208 lessons
  • 16.5 hours of video content

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.

Call to action

This is where you seal the deal. Sprinkle this section throughout you page to push prospects to purchase!