|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
|
| Training Providers
| Regions
| Training Search
| Advertise Training Seminars
| Login
|
||||||||||||||||||||||||
Training Provided by 2e2Objectives: After completing this course, you will know how to: Navigate large worksheets effectively by using magnification, frozen panes, and split panes; and control the printing of large worksheets. Navigate, manage, and print multiple worksheets; link workbooks by using 3-D formulas; and summarise data by using the Consolidate command. Change the View, General, and Calculation settings of Excel; and customise toolbars and menus. Add borders and shading; apply special formats; create, apply, and modify styles; and change the orientation of cells. Sort lists by columns; and filter lists based on complex criteria. Format data points; create combination charts and trend lines; and add and format graphic elements. Embed and link objects in a worksheet; and allow several users to work with the same data by sharing, merging, and tracking changes. Use auditing features; add comments and text boxes; and protect a worksheet or part of a worksheet. Use the VLOOKUP function to find a value in a worksheet list; use the MATCH function to find the relative position of a value in a range; use the INDEX function to find the value of a cell at a given position within a range. Use IF functions to determine an outcome based on criteria.Prerequisites: This course is designed for students who have completed the Excel Fundamentals Course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software. Target Audience: Anyone wishing to use Excel to organise data and perform more complex calculations Training Avaliability and Delivery
Related Keywords: microsoft excel 2007 2003 2000 desktop applications office spreadsheet Training Program DetailsCourse Content:
Working with Large Worksheets Viewing Options Hiding and Displaying Data Printing Large Worksheets Working with Multiple Worksheets Using Multiple Worksheets Linking Worksheets by Using 3-D Formulas Managing Workbooks Data Consolidation Linking across Applications Formulae Sumif and Countif Round and Integer Lookups and Named Ranges Logical Statements And & Or Index and Match Subtotal Function Is Functions Text and Date Advanced Charting Chart Formatting Options Creating Combination Charts Using Graphic Elements List Management Introducing Lists Sorting and Filtering Lists Advanced Filtering Custom Lists Text to Columns Custom Views Advanced Formatting Borders and Shading Using Special Number Formats Working with Dates Working with Styles Conditional Formatting Other Advanced Formatting Notation and Auditing Comments and Text Boxes Auditing Features Data Validation Protection Workgroup Collaboration Customising Excel Changing Options Customising Toolbars and Menu About 2e2 - Training Provider
2e2 - 2e2 is a training provider focussing on the end-user, providing courses in the following areas:
Desktop Applications training (e.g. Microsoft Office)
Unified Communications training (e.g. IP Telephony)
Service Management (including ITIL)
Web Development
Training Room Hire
We deliver public courses in London, Leeds and Birmingham and have...
More Microsoft Office Training from 2e2
| ||||||||||||||||||||||||
Custom Search
| ||||||||||||||||||||||||
| Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links | ||
|
| ||
| Training-Classes.com by Skillbox® 07/23/08 Copyright 1998-2008 skillbox, inc. All rights reserved |
 |
|
| Are you a Microsoft training provider? |
| You could be on this page today - for FREE! |
