|
Provided by: Seletel Informatique Excel 2002Excel |
 |
This series is intended as preparation for the Excel 2002 Microsoft Office User Specialist (MOS) Core Proficiency exam. It introduces Excel's newest enhancements such as task panes for New Documents, Clipboard, Search, and Insert Clip Art; the Ask a Question box; enhancements to Find and Replace; and additional options for pasting and for inserting columns and rows. These new features, along with the productivity tools of previous versions, are taught within the context of working with cells and files, page setup and printing, worksheets and workbooks, formulas and functions, and charts and objects.
|
|
||||||||||
Online
Certificate Program
Provided by Seletel Informatique
Excel 2002
1. WORKING WITH CELLS
Time: 4 hours
This course shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks.
OBJECTIVES:
* Enter cell data including text, numbers, and formulas
* Edit cell data
* Insert, delete, and move cells
* Find and replace cell data and formats
* Create hyperlinks
TOPICS:
* Entering Data
* Editing a Cell
* Editing Multiple Cells
* Replacing Values and AutoFilling
* Creating Hyperlinks
2. WORKING WITH FILES
Time: 3 hours
This course shows users how to locate, open, and save files in Excel 2002.
OBJECTIVES:
* Manage workbook files and folders
* Create workbooks using templates
* Save workbooks using different names and file formats
* Convert worksheets to Web pages
* View and edit comments
TOPICS:
* Opening Files
* Saving Files
* Files and the Internet
* Working with Comments
* Using the Office Assistant
3. FORMATTING WORKSHEETS
Time: 4 hours
This course shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet.
OBJECTIVES:
* Apply and modify cell formats
* Modify row and column settings
* Use automated tools to format worksheets
* Apply styles
TOPICS:
* Formatting Cells
* Adjusting Cells
* Formatting Numbers
* Adjusting Rows and Columns
* Using AutoFormatting and Styles
4. PAGE SETUP AND PRINTING
Time: 2 hours
This course shows users how to preview and print worksheets and workbooks, add headers, footers, and titles, and adjust page settings in Excel 2002 worksheets.
OBJECTIVES:
* Preview and print worksheets and workbooks
* Modify Page Setup options for worksheets
TOPICS:
* Previewing
* Printing
* Page Setup
* Headers, Footers, and Titles
5. WORKSHEETS AND WORKBOOKS
Time: 4 hours
This course shows users how to work with worksheet rows and columns, move between worksheets in a workbook, consolidate data, change the zoom setting, and check spelling in Excel 2002 worksheets.
OBJECTIVES:
* Modify row and column formats
* Modify worksheet names and positions
* Insert and delete worksheets
* Use 3-D references
* Check spelling
* Work with a subset of data by filtering lists
TOPICS:
* Working with Rows and Columns
* Working with Worksheets
* Linking Worksheets and Consolidating Data
* Zooming and Spell-Checking
* Using a Data Filter
6. FORMULAS AND FUNCTIONS
Time: 3 hours
This course shows users how to work with formulas and functions in Excel 2002 worksheets.
OBJECTIVES:
* Work with formulas
* Use references and AutoSum
* Enter Functions
* Use basic and date functions
* Use financial and logical functions
TOPICS:
* Working with Formulas
* Using References and AutoSum
* Entering Functions
* Using Basic and Date Functions
* Using Financial and Logical Functions
7. CHARTS AND OBJECTS
Time: 2 hours
This course shows users how to create, modify, and print charts, insert, move and delete pictures, and draw lines and shapes in Excel 2002 worksheets.
OBJECTIVES:
* Create, modify, position, and print charts
* Create, modify, and position objects
TOPICS:
* Creating Charts
* Modifying and Printing Charts
* Working with Objects
* Drawing Lines and Shapes
Time: 4 hours
This course shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks.
OBJECTIVES:
* Enter cell data including text, numbers, and formulas
* Edit cell data
* Insert, delete, and move cells
* Find and replace cell data and formats
* Create hyperlinks
TOPICS:
* Entering Data
* Editing a Cell
* Editing Multiple Cells
* Replacing Values and AutoFilling
* Creating Hyperlinks
2. WORKING WITH FILES
Time: 3 hours
This course shows users how to locate, open, and save files in Excel 2002.
OBJECTIVES:
* Manage workbook files and folders
* Create workbooks using templates
* Save workbooks using different names and file formats
* Convert worksheets to Web pages
* View and edit comments
TOPICS:
* Opening Files
* Saving Files
* Files and the Internet
* Working with Comments
* Using the Office Assistant
3. FORMATTING WORKSHEETS
Time: 4 hours
This course shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet.
OBJECTIVES:
* Apply and modify cell formats
* Modify row and column settings
* Use automated tools to format worksheets
* Apply styles
TOPICS:
* Formatting Cells
* Adjusting Cells
* Formatting Numbers
* Adjusting Rows and Columns
* Using AutoFormatting and Styles
4. PAGE SETUP AND PRINTING
Time: 2 hours
This course shows users how to preview and print worksheets and workbooks, add headers, footers, and titles, and adjust page settings in Excel 2002 worksheets.
OBJECTIVES:
* Preview and print worksheets and workbooks
* Modify Page Setup options for worksheets
TOPICS:
* Previewing
* Printing
* Page Setup
* Headers, Footers, and Titles
5. WORKSHEETS AND WORKBOOKS
Time: 4 hours
This course shows users how to work with worksheet rows and columns, move between worksheets in a workbook, consolidate data, change the zoom setting, and check spelling in Excel 2002 worksheets.
OBJECTIVES:
* Modify row and column formats
* Modify worksheet names and positions
* Insert and delete worksheets
* Use 3-D references
* Check spelling
* Work with a subset of data by filtering lists
TOPICS:
* Working with Rows and Columns
* Working with Worksheets
* Linking Worksheets and Consolidating Data
* Zooming and Spell-Checking
* Using a Data Filter
6. FORMULAS AND FUNCTIONS
Time: 3 hours
This course shows users how to work with formulas and functions in Excel 2002 worksheets.
OBJECTIVES:
* Work with formulas
* Use references and AutoSum
* Enter Functions
* Use basic and date functions
* Use financial and logical functions
TOPICS:
* Working with Formulas
* Using References and AutoSum
* Entering Functions
* Using Basic and Date Functions
* Using Financial and Logical Functions
7. CHARTS AND OBJECTS
Time: 2 hours
This course shows users how to create, modify, and print charts, insert, move and delete pictures, and draw lines and shapes in Excel 2002 worksheets.
OBJECTIVES:
* Create, modify, position, and print charts
* Create, modify, and position objects
TOPICS:
* Creating Charts
* Modifying and Printing Charts
* Working with Objects
* Drawing Lines and Shapes
About The Training Provider: Seletel Informatique
Seletel Informatique - Are you looking for a way to master skills that doesn't involve time-consuming classroom attendance? Are you looking for a way to train yourself at a lower cost? Need some qualifications for a job? Need to train your employees? Try our solution. When you register for an online course you will receive one year of unlimited access to your online computer training course.
High quality online...
