Microsoft Excel Training Level 2

Man using microsoft excel software at work

The skills and knowledge acquired in Microsoft Excel 2016 – Level 2 are designed to help users expand their knowledge and learn how to create more productive workbooks.

As prior knowledge to this course, participants should be able to confidently create, edit, print and chart simple worksheets. Understanding ranges and copying is also important.

This course covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking. It is provided by Glass Rock Solutions, as virtual online training or in-person (face-to-face) training.

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

  • use the fill operations available to fill a data series
  • use a range of techniques to work with worksheets
  • apply a variety of page setup techniques
  • apply borders to cells and ranges in a worksheet
  • use common worksheet functions
  • create more complex formulas and functions
  • create and use defined names in a workbook
  • apply a range of number formatting techniques to worksheet cells
  • apply conditional formatting to ranges in a worksheet
  • use goal seeking to determine the values required to reach a desired result
  • understand and use Excel’s Quick Analysis tools
  • create and work with tables
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart

After completing this course, participants are encouraged to undertake Microsoft Outlook 2016 – Level 3 training.

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

    “The three days have literally transformed the group. Confidence in facilitation skills has improved more than I thought was possible.”

    Alexis, AICD

    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.