Excel - Level 2
The skills and knowledge acquired in Microsoft Excel - Level 2 enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and...

$380
- Brand
- Microsoft
- SKU:
- E16L2
- Duration:
- 1 Day
- Delivery:
- Virtual Classroom
Share this course
Excel - Level 2
We deliver this course in versions 2016, 2019, and 365
The skills and knowledge acquired in Microsoft Excel - Level 2 enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and pivoting data using Pivot Tables.
Audience
This course assumes the learner has the knowledge required to create, edit, and print simple worksheets. Understanding ranges and copying is also important.
Skills Covered
Upon successful completion of this course, you will be able to:
- create and use defined names in a workbook
- use logical functions to test whether a statement is true or false
- use the date and time functions to perform calculations
- use a range of text functions
- sort data in a list in a worksheet
- filter data in a table
- group cells and use outlines to manipulate the worksheet
- create summaries in your spreadsheets using subtotals
- create and work with tables
- apply conditional formatting to ranges in a worksheet
- create effective charts in Microsoft Excel
- 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
- create and edit a PivotChart
- construct and operate PivotTables using some of the more advanced techniques
- create and edit a PivotChart
- create more complex formulas and functions
- use advanced filters to analyse data in a list
- understand and use Excel's Quick Analysis tools