Microsoft Excel Level 2 [SKT_MSEXL2]

OVERVIEW

This course introduces the user to the intermediate features of Microsoft Excel to attain proficiency as a competent Excel user.

OBJECTIVES

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.

AUDIENCE

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.

NEXT STEP

MSEXL4 - Microsoft Excel Level 4

MSEXVBAP1 - Microsoft Excel VBA Part 1

MSEXVBAP2 - Microsoft Excel VBA Part 2

CONTENT

• 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