Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Java Programming
Print PageExcel 97: Introduction
Description:
Participants will learn worksheet basics. This is a first-step course in using Excel.
- Cost: Price on application
- Duration: 1 Day
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Participants should have PC experience. This is not an introduction to computers course.
Excel basics :
The paper spreadsheet
The Excel program
The workbook environment
The Excel program
The workbook environment
Entering data and navigating in a worksheet :
Entering and correcting data
Saving a file
Using formulas
Opening a second file
Navigation and movement techniques
Saving a file
Using formulas
Opening a second file
Navigation and movement techniques
Modifying a workbook :
Working with ranges
Working with functions
Editing cell contents
Working with functions
Editing cell contents
Moving and copying data :
Inserting rows and ranges
Moving data
Copying data
Absolute references
Using the Fill Series feature
Moving data
Copying data
Absolute references
Using the Fill Series feature
Formatting a worksheet :
Formatting a worksheet
Number formats and text alignment
Copying and pasting formats
Special and custom formatting
Number formats and text alignment
Copying and pasting formats
Special and custom formatting
Printing a worksheet :
Checking spelling
Using the Print Preview command
Printing a large worksheet
Additional print options
Using the Print Preview command
Printing a large worksheet
Additional print options
Introduction to the workbook environment :
Using a multiple-sheet workbook
Creating a chart
Outlining
Spreadsheet Solutions
Creating a chart
Outlining
Spreadsheet Solutions