|
Description: Microsoft Office Excel contains powerful tools to help you analyze, manage, and share critical business data. Our latest version also lets you work more efficiently in teams, while helping to protect and control access to sensitive information.
Objectives
- Name and Reference Cells
- Protect Data
- Create Links
- Use Basic Excel Functions
- Create Charts
- Create Databases
- Work with Data Series
Outline
* Section 1 - Cell Names And References
o Understanding Cell Naming
o Name a Cell
o Naming a Range of Cells
o Using Names In a Formula
o Understanding Relative Cell References
o Understanding Absolute Cell References
o Understanding Mixed Cell References
* Section 2 - Protecting Data
o Protection Basics
o Protecting Worksheets
o Protecting A Workbook
* Section 3 - Creating Links
o Linking Basics
o Linking Worksheets
o Linking Workbooks
* Section 4 - Functions
o Function Basics
o Creating Functions
o The PMT Function
* Section 5 - Charts
o Charting Basics
o Creating a Chart
o Editing A Chart
o Moving And Resizing An Embedded Chart
o Adding and Deleting a Data Series
* Section 6 - Lists
o List Basics
o Creating a List
o Using a Data Form
o Finding Information with the Data Form
o Creating a Record using the Data Form
o Sorting Data
o Filtering Data
Pre-Requisites: Microsoft Excel 2002/2003 Level 1 or equivalent experience
Certificates offered: Certificate of completion
Duration Details: 1 day
8:30am - 4:30pm
Facility Location: On Track Computer Training Center
1600 - 650 West Georgia Street
Vancouver
British Columbia
Canada
V6B 4N7
| 
