Microsoft Excel 2016 Training – Level 3

Laptop computer displaying logo of Microsoft Excel

The skills and knowledge acquired in Microsoft Excel 2016 – Level 3 are for participants who are proficient with the software and have at least an intermediate level of experience.

This course expands on earlier training and teaches participants to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and PivotTables, macros and much more.

This course also includes some challenge exercises so that participants are able to use the sills they learn to gain proficiency.

This course is provided by Glass Rock Solutions either as virtual (online) training or face-to-face.

At the completion of this course, you should be able to:

  • modify Excel options
  • protect data in worksheets and workbooks
  • import data into Excel and export data from Excel
  • use data linking to create more efficient workbooks
  • group cells and use outlines to manipulate the worksheet
  • create summaries in your spreadsheets using subtotals
  • use the Data Consolidation feature to combine data from several workbooks into one
  • create, use and modify data tables
  • create and work with scenarios and the Scenario Manager
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • create and edit a PivotChart
  • use advanced filters to analyse data in a list
  • use a variety of data validation techniques
  • create and use a range of controls in a worksheet
  • share workbooks with other users
  • create recorded macros in Excel

Book now


Please fill out the form below and someone from our team will be in touch within the next 48 hours to get your training started.

    GLASS ROCK CLIENT TESTIMONIALS

    “She is the best trainer I have seen in 30 years”.

    Paul – HR Director NLA

    GLASS ROCK CLIENT STORIES

    Image

    Simone Heaperman - Landcom Program Manager

    When Simone Heaperman, the program manager, picked up the phone to speak with Preetie Shehkkar at Glass Rock Solutions, she had much to address and set right.

    Image

    Jane Hodgen - Tata Consultancy Services

    Tata Consultancy Services, a global technology leader with 450,000 employees worldwide, expect the best from anyone who works for them.

    Image

    Stuart Freer - University of New South Wales

    When Stuart Freer came to Australia, he was recruited as the Director, IT Service Delivery and Infrastructure, at the University of New South Wales.

    WE ARE HERE TO HELP
    CONTACT US TO FIND OUT HOW

      Glass Rock Consulting

      Melbourne Office
      Level 23, Collins Square Tower 5
      727 Collins Street,
      Melbourne Victoria 3008
      Sydney Office
      Australia Square, Level 33
      264 George Street,
      Sydney NSW 2000

      We acknowledge the First Australians as the traditional custodians of this continent. We pay our respect to the elders of the community, past, present and future.