Course Offerings

Intermediate Microsoft Excel 2016

Course ID: OST-3100YE
Overview
Course Outline
Requirements
Intended Audience
More Details

Harness the power of Excel and become a master user of this powerful program. You will learn how to create informative, eye-catching charts and graphs, and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX

Course Objectives

Learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands.

Learn how easy it is to create macros that let you manipulate data with the push of a button.

Discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.

Outline of instruction

Lesson 1 - Excel Charts and Graphs

Lesson 2 - More Excel Charts

Lesson 3 - AutoFilter and Sorting

Lesson 4 - Goal Seeking

Lesson 5 - PivotTables

Lesson 6 - Advanced PivotTables

Lesson 7 - Solver

Lesson 8 - Sparklines

Lesson 9 - Macros

Lesson 10 - Introduction to Functions

Lesson 11 - Math/Trig Functions

Lesson 12 - VLOOKUP, INDEX, and MATCH Functions

CEUs

2.4

Industry Standard, State or National Certification

Certification

None

Website

None

Certification Learning Outcomes/Requirements

CE or CU Articulation

Prerequisites

There are no prerequisites to take this course.

Text and Supplies Needed

Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.

Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
Adobe Acrobat Reader.
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance
• Students must successfully pass 10 quizzes with a minimum grade of 70% by the second quiz attempt.
• If all quizzes are not passed with 70 or better by the second attempt, the final exam score must be 70% or higher on the first attempt for successful completion.
• The Final Exam must be taken by the Wake Tech course end date.

Accreditation/Special Approval Requirements

N/A

Intended Audience

This hands-on course will provide skills using charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2016 functions.