Microsoft Excel 2016 – Level 2

Students using versions 2007 through 2013 will be able to take this course, as the basic structure is the same, with no significant differences to version 2016. This course teaches students how to apply basic skill sets in addition to learning intermediate to advanced functions to manage and audit numerical reports. Students will work with various functions to perform specific types of calculations, customize charts, work with pictures or shapes in a worksheet, customize formatting for specific types of data, and look at various features for managing different types of lists, using a table or database format.
Skills covered:
• converting your data into charts
• customizing charts
• using new types of functions and formulas, including math and trigonometry, statistical, financial, logical, date and time, text, and information functions
• using the Formula Error Checker
• formatting
• custom formatting
• hiding rows and columns
• creating and editing a database
• sorting and subtotalling a database, applying AutoFilters to a database
• data validation
• worksheet protection
• workbook protection
• auditing worksheets
• installing hyperlinks
• working with existing templates, or creating your own templates.

Prerequisite: Computer Basics Level 2 and Excel Level 1 or equivalent.

Cost includes manual.

A Certificate will be issued upon course completion.

Offering 1
Mondays, 9:30 am-12:30 pm Nov 4-Dec 9
FVCE Computer Lab
(no class Nov 11)

Offering 2
Thursdays, 1:30-4:30 pm Nov 7-Dec 5
FVCE Computer Lab

Offering 3
Tuesdays, 6:30-9:30 pm Nov 12-Dec 10
FVCE Computer Lab

Offering 4
Sundays, 9:30am to 3:00pm Nov 24 to Dec 8
FVCE Computer Lab

Course Number: CO09
Instructor: Hank Boven
Semester: Fall 2019
Classroom: FVCE Computer Lab
Start Day:
Course Price: $274.99
Number of Sessions: 5

Total course price before 5% GST:

$274.99 CADSign up now