Free Excel Training and Courses
New Employee ID Badge

New Employee ID Badge

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



Learn By Doing

New Employee ID Badge

New Employee ID Badge

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



Learn By Doing

New Text Functions

New Text Functions

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



Learn By Doing

New Text Functions

New Text Functions

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



Learn By Doing

Beverage Sales

Beverage Sales

Drill down your sales data using an alternative lookup method.



Learn By Doing

Beverage Sales

Beverage Sales

Drill down your sales data using an alternative lookup method.



Learn By Doing

Practice: Separation and merge

Practice: Separation and merge

Practice your text functions skills.



Make Practice

Practice: Separation and merge

Practice: Separation and merge

Practice your text functions skills.



Make Practice

Staff Data

Staff Data

Getting some information with VLOOKUP on "Employee Data"



Learn By Doing

Staff Data

Staff Data

Getting some information with VLOOKUP on "Employee Data"



Learn By Doing

Badly Formatted Data

Badly Formatted Data

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



Learn By Doing

Badly Formatted Data

Badly Formatted Data

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



Learn By Doing

Practice: Mail Address

Practice: Mail Address

Practice your text functions skills.



Make Practice

Practice: Mail Address

Practice: Mail Address

Practice your text functions skills.



Make Practice

Practice: Customer

Practice: Customer

Practice your text functions skills.



Make Practice

Practice: Customer

Practice: Customer

Practice your text functions skills.



Make Practice

New Employee ID Badge

New Employee ID Badge

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



Learn By Doing

Practice: Separation and merge

Practice: Separation and merge

Practice your text functions skills.



Make Practice

Practice: Mail Address

Practice: Mail Address

Practice your text functions skills.



Make Practice

Practice: Customer

Practice: Customer

Practice your text functions skills.



Make Practice

New Text Functions

New Text Functions

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


Pro

Learn By Doing

Beverage Sales

Beverage Sales

Drill down your sales data using an alternative lookup method.


Pro

Learn By Doing

Staff Data

Staff Data

Getting some information with VLOOKUP on "Employee Data"


Pro

Learn By Doing

Badly Formatted Data

Badly Formatted Data

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


Pro

Learn By Doing