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 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.
Are you ready to take the next step in your Excel education? Do you want to graduate from being a user to being a POWER USER? Are you looking to become the “go to” person for Excel in your office? Then our Excel Level 3 course is for you.
Learn about some of Excel’s most powerful tools. Work with macros to automate repetitive tasks. Perform in-depth analysis of your data with pivot tables and visualize that analysis with pivot charts. Compare potential budgets with the scenario manager. Learn to use goal seek and solver to perform “what-if” analysis, which allows you to manipulate your raw data to achieve a required predetermined result.
• Creating and modifying pivot tables and pivot charts
• Using advanced ‘what if’ utilities, such as goal seek, scenario manager, and solver
• Recording and running macros
• Excel properties options
• Custom toolbars
• Sharing workbooks including tracking changes
• Data validation
• Cell comments
• Consolidating or summarizing data
• Using ‘paste special’ to create different types of data
• Importing data
• Linking Excel data to other worksheets
• Applying conditional formatting
• Adding Sparklines to your data
• Organizing the presentation of data with Outlines.
Prerequisite: Computer Basics Level 2 and Excel Level 2 or equivalent.
Cost includes manual.
A Certificate will be issued upon course completion.
Offering 1F: Mondays, Jan 4 to 25 2021, 9:30am to 12:30pm, FVCE computer lab #204 – 20621 Logan Ave Langley
Offering 2F: Mondays, Jan 4 to 25 2021, 6:30pm to 9:30pm, FVCE computer lab #204 – 20621 Logan Ave Langley
Offering 3F: Sundays, Jan 10 to 17 2021, (2 weeks only) 9:30am to 3:00pm, FVCE computer lab, #204-20621 Logan Ave Langley
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.
|Start Time:||9:30 am OR 6:30pm|
|End Time:||Varies by start time|
|Number of Sessions:||4|