Microsoft Excel 2016 Level 2 Training Course

General Description

The skills and knowledge acquired in Microsoft Excel 2016 Level 2 are sufficient to be able to produce more effective and productive workbooks.

Outcomes

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

• Use a range of techniques to work with worksheets
• Use a range of find and replace techniques
• Apply a variety of page setup techniques
• Sort data in a list in a worksheet
• Filter data in a table
• Use the fill operations available to fill a data series
• Understand and use formula cell referencing
• Use data linking to create more efficient workbooks
• Create and use defined names in a workbook
• Use logical functions to test whether a statement is true or false
• Apply conditional formatting to ranges in a worksheet
• Use a range of elements and features to enhance charts
• Select and change the format of objects in a chart
• Understand and create simple PivotTables

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.