This class is now LIVESTREAMED! 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.)
You will need:
- A computer (Mac or PC), or an Android smartphone, or an Android tablet, or an iPad or iPhone. As long as it has a webcam and microphone, you’re good to go! (And YES, you can disable your camera for privacy!)
- NO special software
- 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 classrom. 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.
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.
• 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
• 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
Cost includes manual.
Offering 1a-2019: January 8, 9, 15, 22 & 29 2020, 6:30pm to 9:30pm, FVCE computer lab, Suite 204-20621 Logan Ave Langley
Offering 1: Tuesdays, 6:30pm to 9:30pm, Apr 14 to May 12 2020, via Livestreaming
Offering 1b: Mondays, 9:30am to 12:30pm, Apr 27 to June 1 2020 (no class May 18), via Livestreaming
Offering 1c: Mondays, 6:30pm to 9:30pm, Apr 27 to June 1 2020 (no class May 18), via Livestreaming
Offering 2: Wednesdays, 9:30am to 12:30pm, Apr 15 to May 13 2020, via Livestreaming
Offering 3: Sundays, 9:30am to 3pm, Apr 26 to May 10 2020, via Livestreaming
Offering 4: Thursdays, 6:30pm to 9:30pm, May 7 to Jun 4 2020, via Livestreamingy
Offering 5: Wednesdays, 1:30pm to 4:30pm, May 27 to Jun 24 2020, via Livestreaming
Offering 6: Monday June 8, Wednesday June 10, Monday June 15, Wednesday June 17, Monday June 22 , all at 6:30 pm – 9:30 pm, via Livestreaming
A Certificate will be issued upon course completion.
|Classroom:||Via Livestreaming on your computer at home|
|Start Date:||June 8, 2020|
|End Date:||June 22, 2020|
|Start Time:||6:30 pm|
|End Time:||9:30 pm|
|Number of Sessions:||5|
Click “Sign Up Now” below to see all course dates and times.
Total course price before 5% GST: