Microsoft Excel Level 2

Description

This class is now BOTH IN CLASS & LIVESTREAMED OPTIONS! See below for details of which offerings are live in a classroom setting, and which are virtual.

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 (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 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:
• 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 6F: Tuesdays, Jan 5 to Feb 2 2021, 1:30pm – 4:30pm, via Livestreaming ($13.00 fee for postage if needed to be mailed) Textbooks must be picked prior to the start of class.

Offering 7F: Thursdays, Jan 14 to Feb 11 2021, 6:30pm – 9:30pm, via Livestreaming ($13.00 fee for postage if needed to be mailed) Textbooks must be picked prior to the start of class.

Offering 1WS: Wednesdays, Mar 31 to Apr 28 2021, 9:30am to 12:30pm, via Livestreaming ($13.00 fee for postage if needed to be mailed) Textbook must be picked prior to the start of class.

Offering 2WS: Wednesdays, Mar 31 to Apr 28 2021, 6:30pm to 9:30pm, via Livestreaming ($13.00 fee for postage if needed to be mailed) Textbook must be picked prior to the start of class.

Offering 3WS: Mondays, Apr 19 to May 17 2021, 9:30am to 12:30pm, FVCE computer lab #204 – 20621 Logan Ave Langley

Offering 4WS: Mondays, Apr 19 to May 17 2021, 6:30pm to 9:30pm, FVCE computer lab #204 – 20621 Logan Ave Langley

Offering 5WS: Sundays, Apr 25 to May 9 2021, 9:30am to 3:00pm, FVCE computer lab #204 – 20621 Logan Ave Langley

Offering 6WS: Tuesdays, Jun 1 to 29 2021, 1:30pm to 4:30pm, via Livestreaming ($13.00 fee for postage if needed to be mailed) Textbook must be picked prior to the start of class.

Offering 7WS: Thurs, Wed, Thurs, Wed, Thurs, July 15, 21, 22, 28 & 29 2021, 6:30pm to 9:30pm, via Livestreaming ($13.00 fee for postage if needed to be mailed) Textbook must be picked prior to the start of class.

A Certificate will be issued upon course completion.

About Instructor Hank Boven
Hank has been working with Microsoft Office for 30 years, and has been an Instructor with Langley Continuing Education (and now FVCE) for 19 years. During that time Hank has taught
over 10,000 Students how to work with Microsoft Office. He makes extensive use of real-world scenarios to help his students better understand and apply the principles and skills they acquire in class. He has been called “The Mr. Rogers of Microsoft” by more than one student.

Hank holds numerous industry certifications from leading information technology companies such as Microsoft and CompTIA.