If you have used Microsoft Excel for some time and need to learn more, this program provides you with additional skills. Learn how to identify ranges with names, use workbooks with multiple sheets, protect worksheets and files, link worksheets, audit files and create templates. Work with functions such as IF and VLOOKUP. To benefit from this program you should be a confident user of 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