DigiT&L Futures - Excel Training

DIGIT&L FUTURES (Excel Skills) will provide support for existing workers in the transport and logistics industry (across all sectors) to upskill and build knowledge and competency in understanding Microsoft Excel (different levels of training available). Training will be delivered across a number of locations by TAFE Queensland.

Training places will be offered in existing courses offered by TAFE Queensland. Limited funded places will be offered in each location and a minimum number of participants will be required for a course to proceed.

This program is open to existing employees within the Transport & Logistics industry,including Road Transport, Passenger Transport, Logistics, Maritime, Rail and Aviation. To be eligible, you are:
  • aged 15 years of age or over, and no longer at school
  • permanently residing in Queensland
  • not an employee of government departments or agencies
  • not an apprentice or trainee
What you can learn:

 

 Beginners’ Excel

 

    • The Excel Screen
    • Workbook, Spreadsheet, Ribbon, Quick Access, Status Bar
    • Working with columns and rows
    • Data types and formats
    • Formulas and operator symbols
    • Basic Functions and syntax
    • Formatting Cells and Options
    • Print Options
    • Basic Charts
    • Sorting and Filtering

 

 

 Intermediate Excel

    • Templates
    • Auto Fill
    • Functions
    • Absolute referencing
    • Advanced printing
    • IF function
    • Absolute referencing
    • VLOOKUP function
    • Protecting data

 

 

 Advanced Excel

 

    • Working with Multiple worksheets
    • Importing data
    • Linking data
    • Complex Functions
    • Styles
    • Conditional Formatting
    • Tables
    • Pivot Tables
    • Macros

See below for course dates. For more information, contact lisa@qta.com.au or ebony@qta.com.au

DigiT&L Futures Excel Training Dates

 Your Say TLSC

Visit the online platform that lets you get involved and have your say about what really matters in your industry.


Connect with us

Industry Training

Industry News

Subscribe to the VET 4 T&L Newsletter

* indicates required

RELATED SKILLING & TRAINING PROJECTS

Content © 2015 Queensland Trucking Association Ltd

Powered by Wild Apricot Membership Software