Microsoft Excel Level 2

This course is aimed at those wishing to gain the skill sets necessary for calculating data using functions and formulas to manipulate worksheets, create and manipulate charts, carry out cell and range formatting, use templates and create and use named ranges.

By actively participating in this course, you will learn about the following:

• Set up and viewing options.

• Proofing and printing.

• Understand and use a variety of functions.

• Create a variety of formulas.

• Create and use Named Ranges.

• Perform cell formatting and worksheet manipulation.

• Create and manipulate charts.

• Use and create templates.

• Set up and viewing options

• Proofing and printing

• 3-D Reference

• Mixed References

• Mathematical functions

• Logical functions

• Statistical functions

• Text functions

• Named ranges

• Cell and range formatting

• Manipulating worksheets

• Charts

To ensure your success, we recommend you first take the following courses or have equivalent knowledge:

• Microsoft Excel Level 1

Software Requirements for Virtual Classroom

Delegates will need to have Microsoft Excel 2013, 2016, 2019 or 365 (desktop version) installed on their PC to participate in Virtual Classroom courses.  Delegates may notice differences in their software if using a MAC.

MSEXL4 - Microsoft Excel Level 4

MSEXVBAP1 - Microsoft Excel VBA Part 1

MSEXVBAP2 - Microsoft Excel VBA Part 2