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. By teaching participants how to work effectively in Microsoft Excel and overcome common obstacles we can create a program that is sustainable long after the training is over. 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:
BASICS
The components of Excel
The Excel screen
Navigating in Excel
SELECTING DATA
Use Zoom Control to view your data
Select Non Adjacent cells for quicker formatting
Select one or more Columns and Rows
Select a Large Range of cells
Learn several methods of Cut, Copy & Paste
Use Drag & Drop to quickly move data in your worksheet
FORMATTING WORKSHEETS
Insert one or more Rows and Columns
Resize Columns and Rows to best fit your data
Change the format of your data
FORMULAS
Create Formulas
Learn the difference between Relative & Absolute Addressing
Use AutoSum to quickly add your figures
Use AutoFill to save time
PRINTING WORKSHEETS
Preview the output of your workbook
Use Headers and Footers for a more professional look
WORKING WITH LARGE SPREADSHEETS
Freeze Panes to help keep your data in the right place
Split a Worksheet to see different parts of your data at the same time
Outcomes: Participant will have will have clear understanding of basics of Excel.
Instruction will be hands-on.
Hours: 3 to 4 hours
For Large Groups 7 hours may be required.
Full Day Training option:
Becoming self sufficient and more efficient.
