This course introduces the user to the intermediate features of Microsoft Excel to attain proficiency as a competent Excel user.
This course is aimed at those wishing to gain the skill sets necessary for calculating data using functions and formulas to manipulate worksheets.
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.
To ensure your success, we recommend you first take the following course or have equivalent knowledge:
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.
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