This course introduces the user to the intermediate features of Microsoft Excel to attain proficiency as a competent Excel user.
TARGET 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.
COURSE PREREQUISITES:
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.
COURSE 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
COURSE OBJECTIVE:
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.
FOLLOW ON COURSES:
MSEXL3 – Microsoft Excel Level 3MSEXL4 – Microsoft Excel Level 4MSEXVBAP1 – Microsoft Excel VBA Part 1MSEXVBAP2 – Microsoft Excel VBA Part 2