Excel 3 | Mission Computers

Excel Certificate, Level 3

TRAINING OBJECTIVES

Understanding the technology in any office environment is an important skill that helps improve employee performance. The goal of this training is to achieve long-term improvements in the way employees do their jobs. By teaching participants advanced features in Microsoft Excel they can easily report and extract data. This program is best suited for the companies that want to have their staff at (or around) the same level of competency while boosting their staff’s performance and confidence.

Level 3 Learning Module

In this module the agenda is as follows:

AUDITING WORKSHEETS
Locating Precedent and Dependant Cells
Tracing Precedents and Dependants
Removing Auditing Arrows

USING COMMENTS
SPLITTING CELL DATA
Parsing

INSERTING DYNAMIC DATES & TIMES
CONCATENATE
NO DUPLICATES
USING THE PASTE SPECIAL COMMAND
NESTED IF STATEMENTS

PROTECTING DATA
File
Workbook
Worksheet

USING BASIC ANALYSIS TOOLS
Performing “What If” analysis using Goal Seek
Working with Scenarios

PIVOT TABLES
Creating
Reorganizing
Updating
Summarizing

IMPORTING AND EXPORTING FILE

Outcomes: Participant will have will have an advanced understanding of Excel.

Instruction will be hands-on.
Hours: 3 to 4 hours
Large Groups may need 7 hours

Summary

Course Manuals or Notes are included with training.
Certificate of Completion given to each participant.
Connie Clark, instructor and facilitator for training.
Support on topics is included throughout the program.
Participants learning will be accessed and evaluated based on their hands-on experiences in the training.
Training can include client examples for exercises in learning.

BONUS