Menu
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. Teaching participants how to work effectively in Microsoft Excel so that they can easily create the formulas, functions and reports they need. 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:
INTRODUCTION
Fundamental Short-Cuts
Review of Formulas
FUNCTIONS
Using built-in Function Wizards
Mathematical functions such as Round
Use Financial functions to calculate a loan payment
Logical functions using IF
Create formulas using Date & Time functions
Automatically display information from another spreadsheet using Table Lookups
MULTIPLE WORKSHEETS
Add data together using Paste Special
Linking worksheets within the same workbook Linking worksheets with another file.
CHARTS
Creating an embedded chart in a Worksheet
Moving & Sizing an embedded chart
Modifying your Chart quickly and easily
DATABASE FUNCTIONS
Custom Sorts
Filter out specific records using AutoFilter
Create instant Subtotals & Grand Totals
Outcomes: Participant will have will be able to create, manipulate and extract data easily with Microsoft Excel.
Instruction will be hands-on.
Hours: 3 to 4 hours
Large Groups may need 7 hours
Becoming self sufficient and more efficient.
