Microsoft Excel 2016 – Level 3

Students using versions 2007 through 2013 will be able to take this course, as the basic structure is the same, with no significant differences to version 2016. 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. “What-If” allows you to manipulate your raw data   achieve a required predetermined result.
Skills covered:
• creating and modifying PivotTables or PivotCharts
• 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 1
Mondays, 9:30 am-12:30 pm Jan 6-27, 2020
FVCE Computer Lab

Offering 2
Tuesdays, 6:30-9:30 pm Jan 7-28, 2020
FVCE Computer Lab

Course Number: CO10
Instructor: Hank Boven
Semester: Spring 2020
Classroom: FVCE Computer Lab
Start Day:
Course Price: $254.99
Number of Sessions: 4

Total course price before 5% GST:

$254.99 CADSign up now