If you have used Microsoft Excel for some time and need to learn more, this Perth based training program provides you with additional skills. Take your basic knowledge to the next level and learn how to improve your Microsoft Excel skills. This hands-on class lays the foundations for building a stronger, more advanced understanding of Microsoft Excel and will coach you to be confident with Microsoft Excel functions commonly used in the workplace. Learn how to identify ranges with names, use workbooks with multiple sheets, protect worksheets and files, link worksheets, audit files and create templates. Work interactively with functions such as IF and VLOOKUP. To benefit from this short course, you should be a confident user of Microsoft Excel.

Overview

This program provides you with further skills in Microsoft Excel. You will learn how to identify ranges with names, protect worksheets and files, apply functions, link worksheets, audit files and create templates.

Program Content

  • Review of basic worksheet development and charting
  • Relative and absolute cell referencing
  • Apply range names
  • Function
    • IF functions
    • VLOOKUP
  • Cell comments or notes
  • Worksheet auditing and protection
  • Link worksheets and workbooks
    • Copy and paste formulas and data between worksheets 
    • Format worksheets simultaneously 
    • Link information in different files
  • Create templates
  • Sort and filter
  • Data validation
  • Conditional formatting.

Learning Outcomes

Participants should be able to:

  • Develop worksheets using specialised features and command
  • Trace cells using worksheet auditing
  • Develop and modify multiple sheets
  • Link data from different files
  • Lock cells and protect an entire workbook
  • Create worksheet templates.
Program Number
933
Skill Level
Intermediate
Duration

2 Days

Time
Dates
    Location

    AIM WA Floreat

    * Minimum numbers are required for program to proceed

    Make a Booking
    NOT YET AN
    AIM WA MEMBER?
    DISCOVER THE BENEFITS  

    Similar Programs