Description
At Course Completion
After completing this course, students will be able to:
- use filling techniques
- 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
Prerequisites
Microsoft Excel 2016 – Level 2 assumes the learner has the knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and copying is also important.
