Microsoft Excel 365 Level 2

Description

This class is currently LIVESTREAMED!

For virtual classes, attend at the regularly-scheduled class time, from the comfort of your home computer. Livestreaming means you interact with a REAL Instructor, in real-time, from your computer. This is NOT pre-recorded content. (You must log in and attend at the time class is offered, this is not a “watch-when-you-like” option.)

For virtual classes, you will need:

A computer (PC) as long as it has a webcam and microphone, you’re good to go! (And YES, you can disable your camera for privacy!)

• Microsoft Office 365
• NO additional costs
• NO technical know-how or fancy tools

Livestreamed classes are just “click-and-enter”
Once you have registered, an email will be sent to you a few days before the class, with a link to click and enter the virtual classroom. Nothing to download, nothing to install. Your webcam and microphone can display your image and voice to the rest of the class, or you can choose to mute the microphone or turn off the camera. You will still be able to hear and see the Instructor.

Livestreamed classes are EXACTLY the same content as the in-person class
Get exactly the same handouts, same exercises, and same interaction with your Instructor, as if you were in the same room with them. Ask all your same questions, hear your fellow classmates, and see the same presentations. No compromises.

Class 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:

• Using new types of functions and formulas, including logical, date and time, text, and Lookup functions
• Converting your data into charts
• Customizing charts
• Auditing worksheets
• Using the Formula Error Checker
• Creating and editing a database
• Applying AutoFilters to a database
• Sorting a database
• Sub-totaling a database
• Convert Database to a Table
• Creating personalized Templates
• Worksheet protection
• Workbook protection

Offering 1WS25: Mondays, Apr 7 to May 12 2025, 9:30am to 12:30pm, via livestreaming (no class Apr 21)

Offering 2WS25: Mondays, Apr 7 to May 12 2025, 6:30 to 9:30pm, via livestreaming (no class Apr 21)

Offering 3WS25: Saturdays, May 3 to 24 2025, 9:30am to 3:00pm, FVCE Computer Lab #204 20621 Logan Ave Langley (no class May 17)

Instructor: Lori Dowhaniuk

Class Capacity: 14