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.
In this module the agenda is as follows:
Locating Precedent and Dependant Cells
Tracing Precedents and Dependants
Removing Auditing Arrows
SPLITTING CELL DATA
INSERTING DYNAMIC DATES & TIMES
USING THE PASTE SPECIAL COMMAND
NESTED IF STATEMENTS
USING BASIC ANALYSIS TOOLS
Performing “What If” analysis using Goal Seek
Working with Scenarios
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
Becoming self sufficient and more efficient.