Microsoft Excel Training Level 1

Microsoft Excel, a spreadsheet developed by Microsoft, on computer screen.

This is a beginners’ course, designed for anyone with no prior knowledge or experience using Microsoft Excel, although a basic understanding of computers and the Windows operating system environment is an advantage.

The course, provided by Glass Rock Solutions, can be completed as virtual online or in-person (face-to-face) training.

The course aims to give participants a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

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

  • navigate your way around Microsoft Excel 2016
  • create and work with a new workbook
  • open and navigate within workbooks and worksheets
  • make changes to data in a workbook
  • understand and work with ranges in a worksheet
  • copy and paste data in Excel
  • use the fill operations available to fill a data series
  • move the contents of cells and ranges within and between workbooks
  • understand, create and work with formulas and functions
  • understand and use formula cell referencing
  • use font formatting techniques
  • align the contents of cells in a number of ways
  • understand and use the number formatting features in Excel
  • format rows and columns in a worksheet
  • work with elements that make up the structure of a worksheet
  • sort data in a list in a worksheet
  • filter data in a table
  • print your workbook data
  • create effective charts in Microsoft Excel
  • obtain help for Excel whenever you need it
  • understand points to consider to avoid problems in your worksheets

After completing this course, participants are encouraged to undertake Microsoft Excel 2016 – Level 2 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

    “Wonderful couple of days. Learnt a lot that will stay with me throughout my career.”

    Jackie, Henkel

    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.