Badly Formatted Data

• Unknown
• 1200
• 1.200 points

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.

Beverage Sales

• Advanced
• 1600
• 1.600 points

Drill down your sales data using an alternative lookup method.

Beverage Sales

• Advanced
• 1600
• 1.600 points

Drill down your sales data using an alternative lookup method.

Joining data strings using CONCATENATE

• Beginner
• 250
• 250 points

New Employee ID Badge

• Intermediate
• 1300
• 1.300 points

Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...

New Employee ID Badge

• Intermediate
• 1300
• 1.300 points

Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...

New Text Functions

• Intermediate
• 600
• 600 points

Combine text strings using TEXTJOIN() and CONCAT().

Practice: Customer

• Unknown
• 800
• 800 points

Practice your text functions skills.

Practice: Mail Address

• Beginner
• 500
• 500 points

Practice your text functions skills.

Practice: Separation and merge

• Unknown
• 500
• 500 points

Practice your text functions skills.

Staff Data

• Advanced
• 1900
• 1.900 points

Getting some information with VLOOKUP on "Employee Data"

Staff Data

• Advanced
• 1900
• 1.900 points

Getting some information with VLOOKUP on "Employee Data"