Auldhouse Anywhere

Auldhouse Anywhere

Our range of Auldhouse Anywhere courses enable you to join live classroom training online – saving you time and money on travel.

Find out More
E-Learning

E-Learning

Discover the benefits of taking a course online at your own pace.

Find out More
Webinars

Webinars

Auldhouse deliver a number of vendor specific webinars. Webinars give you an effective training option with the freedom to attend from virtually anywhere.

Find out More

Microsoft Excel Working with Text Functions Webinar

Code:
WEXLT
Days:
1 Hour
Price:
$149 excl GST
Code:
WEXLT
Days:
1 Hour
Price:
$149 excl GST
CPD Eligible
1 cpd hour(s)
Overview:
Quite often you import data into Excel that then requires it to be cleansed or manipulated into the correct formats. Find out how to do this using TEXT functions such as LEFT, RIGHT, and MID to return characters from cells and CONCATENATE to join several text strings together. Convert text into UPPER, LOWER and PROPER case. Also discover the TRIM and CLEAN functions to remove extra spaces and non-printable characters. We also explore other functions we can apply to text.

60 minute Live Online Webinar plus 15 minute Q&A.

Download Course Outline
Course Outline (PDF)

Objectives:

After completing this course, students will have understanding of:

  • Uses of Text Functions
  • Functions to Convert between Upper & Lower Case
  • Functions to Remove Extra Characters
  • Cutting Up & Piecing Together Text Strings
  • Concatenate Function
  • Information Functions
  • Replacing / Substituting Parts of a Text String
  • Functions to Convert Excel Data Types
  • Nest a function within a function
  • Text to Columns
  • Flash Fill

 

 

Prerequisites:

Before attending this course students must be familiar with Excel.

Additional Information:

60 minute Live Online Webinar plus 15 minute Q&A.

Register now for this course

Please take special note of the course prerequisites as it is important that you meet these requirements before attending the course. If you have any questions about dates or locations please dont hesitate to make an enquiry contact us on 0800 835 835.

Webinar

No classes currently scheduled in your location?Enquire about this course

Interested in a private class? Enquire about a private class