fbpx

Microsoft Excel Level 2

$279.99$284.99 CAD

Description

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 sub-totaling 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 

Cost includes manual.

Offering 4F22: Thursdays, Nov 17 to Dec 15 2022, 6:30pm to 9:30pm, via livestreaming  Microsoft Excel 365

Offering 5F22: Sundays, Jan 8 to 28 2023, 9:30am to 3:00pm, FVCE Computer Lab #204, 20621 Logan Ave Langley  NO CLASS Jan 22

Offering 1WS23: Wednesdays, Mar 22 to Apr 19 2023, 9:30am to 12:30pm, FVCE Computer Lab #204, 20621 Logan Ave Langley

Offering 2WS23: Wednesdays, Mar 22 to Apr 19 2023, 6:30pm to 9:30pm, via livestreaming Microsoft Excel 365

Offering 3WS23: Tuesdays, Apr 4 to May 2 2023, 6:30pm to 9:30pm, FVCE Computer Lab #204, 20621 Logan Ave Langley

Offering 4WS23: Sundays, May 7 to 28 2023, 9:30am to 3:00pm, FVCE Computer Lab #204, 20621 Logan Ave Langley (no class May 21)

Offering 5WS23: Thursdays, May 25 to Jun 22 2023, 9:30am to 12:30pm, FVCE Computer Lab #204, 20621 Logan Ave Langley

Offering 6WS23: Monday to Friday, Jun 12 to 16 2023, 1:30pm to 4:30pm, FVCE Computer Lab #204, 20621 Logan Ave Langley

A Certificate will be issued upon course completion.

About Instructor Lori Dowhaniuk

Bio to come!

Course Number: CO09
Instructor: Lori Dowhaniuk
Semester: Fall 2022
Classroom: BOTH Livestreamed and in-class options available
Start Date:
End Date:
Start Time:
End Time:
Class Capacity: 14
Course Price: $279.99
Number of Sessions: 5

Additional information

Offerings:

Offering 4F22: Thursdays, Nov 17 to Dec 15 2022, 6:30pm to 9:30pm, via livestreaming  Microsoft Excel 365, Offering 5F22: Sundays, Jan 8 to 28 2023, 9:30am to 3:00pm, FVCE Computer Lab #204, 20621 Logan Ave Langley NO CLASS Jan 22/23, Offering 1WS23: Wednesdays, Mar 22 to Apr 19 2023, 9:30am to 12:30pm, FVCE Computer Lab #204, 20621 Logan Ave Langley, Offering 2WS23: Wednesdays, Mar 22 to Apr 19 2023, 6:30pm to 9:30pm, via livestreaming Microsoft Excel 365, Offering 3WS23: Tuesdays, Apr 4 to May 2 2023, 6:30pm to 9:30pm, FVCE Computer Lab #204, 20621 Logan Ave Langley, Offering 4WS23: Sundays, May 7 to 28 2023, 9:30am to 3:00pm, FVCE Computer Lab #204, 20621 Logan Ave Langley (no class May 21), Offering 5WS23: Thursdays, May 25 to Jun 22 2023, 9:30am to 12:30pm, FVCE Computer Lab #204, 20621 Logan Ave Langley, Offering 6WS23: Monday to Friday, Jun 12 to 16 2023, 1:30pm to 4:30pm, FVCE Computer Lab #204, 20621 Logan Ave Langley