|
Nexient Learning ~ Word Training, Excel Training, PowerPoint Training, Canada Wi Cancellation Policy
Description: Who should attend?
This course is intended for participants who are familiar with Excel 2000/2002/2003.
Performance Objectives
Upon completion of the course, participants will be able to accomplish the following:
- Organize, protect, and display data, using various tools
- Create linking formulas and use the IF function
- Set up multiple worksheets, use information from other sources through consolidation, and copy and paste links to combine information into one worksheet
- Create and modify charts to present data effectively, customize charts to enhance their appearance
- Create and apply styles to format worksheets consistently and quickly, use conditional formatting, comments, and text boxes to highlight and explain data
Course Outline
- Worksheet Organization
- Range Names
- Workbook Templates
- Worksheet Security
- Outlining
- Advanced Formulas
- Using the IF Function
- Linking Formulas
- Using Multiple Workbooks and Worksheets
- Working with Multiple Workbooks
- Setting Up Multiple Worksheets
- Using Multiple Worksheets
- Creating Links with Formulas
- Modifying and Restoring Links
- Consolidating Data
- Working with Charts
- Creating Charts
- Publishing Charts on the Web
- Changing Chart Data
- Modifying Chart Elements
- Creating Custom Charts
- Applying Formatting
- Creating Styles
- Working with Styles
- Using Conditional Formatting
- Annotating Worksheets
Pre-Requisites: Excel 2000/2002/2003 Level 1
Certificates offered: Certificate of completion
Duration Details: 1 Day
8:30am - 4:30pm
Facility Location: Nexient Vancouver
Bentall Tower Two - suite 400
555 Burrard Street
Vancouver
British Columbia
Canada
V7X 1M8
|
