Byron Employment

Byron Employment. Over 144,188 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $350.00

Course Overview

Do you need to:

  • Import or export data using text files
  • Parse and "clean" imported data
  • Compare text values and combine text using concatenation
  • Display text values using number formats
  • Manipulate data within text strings
  • Use the data and time functions to calculate values

This course is designed to provide tools and functions to assist you to manage and manipulate text, dates and times. Knowledge of these tolls and functions can increase efficiency and provide you with improved methods for managing imported data and reorganising data stored within an Excel workbook.

Aim

This course contains employability skills and aims to provide a forum in which to further develope the skills and knowledge required to take advantage of the power of Excel formulas and functions.

Prerequisites

A sound knowledge of the topics covered in our Intermediate Excel – Formulas and Functions or similar experience.

Delivery

Classroom

Duration

1 day

Locations

  • Public Schedule - Adelaide, Brisbane, Canberra, Melbourne, Perth and Sydney
  • Group Bookings - all States and Territories across Australia

Topics

Key topics covered on this course include:

  • Understanding text files and using Text Import Wizard to import and export data
  • Parsing, splitting and transposing data and understanding character codes
  • Comparing text strings using formulas and text functions
  • Creating an aray formula to compare text values
  • Counting within a string including counting specific character and
  • Joining values and inserting special characters
  • Formatting a text string using number, date or currency formats
  • Extracting characters from within a text string
  • Using the date and time functions to calculate and format dates and times
  • Using text tools as such spell checker, find and replace and removing duplicate rows

Learning Outcomes

At the completion of this course you should have the skills and knowledge to:

  • Understand the structure of the main text file types
  • Use the Text Import Wizard to import and export data from text files
  • Parse, split and transpose data
  • Use the text functions to clean up imported data from text files and web pages 
  • Use functions to compare text strings
  • Use functions within array formulas to compare text values
  • Join text strings, values and special characters using concatenation 
  • Format a text string using number, date or currency formats
  • Perform calculations using date and time values
  • Use the date and time functions to perform more complex calculations 
  • Clean data using the text and data tools

 

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 6162 2929
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 6162 2929 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search