Custom Search
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Microsoft Excel 2003 - level 2
Provided by: Last Minute Training

Microsoft Excel 2003 - level 2

Excel

 Last Minute Training
Training Provided by Last Minute Training Microsoft Excel is a powerful spreadsheet package for working with numerical data. It easily does calculations and allows you to manipulate, track and store the data. This session is designed to give those who are already familiar with the basics of Excel the opportunity to use more advanced techniques in their spreadsheets. In this session, participants will:

* apply intermediate formats and styles to worksheets
* use date, time and currency formats
* apply conditional formatting
* use statistical, financial and numerical functions
* work with lists and database functionality
* filter information
* customize and format charts
* add headers and footers for printing
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:intermediate
Duration:1 days
Training Presented in:English

Microsoft Excel 2003 - level 2 Seminar Schedule

October, 2008
Date   Location    
14th October, 2008   Calgary, AB   [Register]
14th October, 2008   Winnipeg, MB   [Register]
Microsoft Excel 2003 - level 2 Lesson 1: Creating and Applying Templates
Topic 1A: Create a Workbook from a Template
Topic 1B: Create a Custom Template
Topic 1C: Working with Comments
Topic 1D: Create a Hyperlink
Topic 1E: Use Web-based Research Tools

Lesson 2: Creating and Modifying Charts
Topic 2A: Create a Chart
Topic 2B: Format Chart Items
Topic 2C: Change the Chart Type
Topic 2D: Create a Diagram

Lesson 3: Working with Graphic Objects
Topic 3A: Insert Graphics
Topic 3B: Create AutoShapes
Topic 3C: Format Graphic Objects
Topic 3D: Change the Order of Graphic Objects
Topic 3E: Group Graphic Objects
Topic 3F: Move, Copy, and Resize Graphic Objects

Lesson 4: Calculating with Advanced Formulas
Topic 4A: Create and Apply a Name for a Range of Cells
Topic 4B: Calculate Across Worksheets
Topic 4C: Calculate with Date and Time Functions
Topic 4D: Calculate with Financial Functions
Topic 4E: Calculate with Statistical Functions
Topic 4F: Calculate with Lookup and Reference Functions
Topic 4G: Calculate with Logical Functions

Lesson 5: Sorting and Filtering Data
Topic 5A: Sort Data Lists
Topic 5B: Filter Data Lists
Topic 5C: Create and Apply Advanced Filters
Topic 5D: Calculate with Database Functions
Topic 5E: Add Subtotals to a Worksheet

Lesson 6: Using Excel with the Web
Topic 6A: Export Excel Data
Topic 6B: Publish a Worksheet to the Web
Topic 6C: Import Data from the Web
Topic 6D: Create a Web Query

Appendix A: Microsoft Office Specialist Program
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Click here for more information or to take this course
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Microsoft Excel 2003 - level 2
Advertise With Us
Do you offer microsoft excel training?
This page was last updated on sb5- 10/06/08 at 15:34:08 - 23:50:12