Excel – Formulas for working with text

Learn how to use Excel Text Functions to clean up imported text and manipulate how textual data is stored and displayed.

Snapshot

Duration: 90 minute

Level: Intermediate

Pre-requisites: Basic familiarity with Excel formulas

Version: Suitable for 2010, 2013, 2016 and Office 365

Learning outcomes

  • Understand when to use Text Functions
  • Use Text Functions to manipulate text based Excel data
  • Use Text Functions to ‘clean up’ imported text

Upcoming Sessions

Date Time (AEDT) Location Available Spaces Cost
14 September 2022 09:30 am - 11:00 am Online 5 $195.00
25 October 2022 12:00 pm - 01:30 pm Online 5 $195.00
7 November 2022 12:00 pm - 01:30 pm Online 5 $195.00
15 December 2022 02:30 pm - 04:00 pm Online 15 $195.00
24 January 2023 02:30 pm - 04:00 pm Online 15 $195.00
14 February 2023 09:30 am - 11:00 am Online 15 $195.00
14 March 2023 12:00 pm - 01:30 pm Online 15 $195.00