|
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: Use names to assign descriptive labels to cells; use financial functions to calculate values based on conditions. Use data tables to view the effects of multiple input values on a formula. Use the Subtotal command, the Subtotal function and database functions to summarise list data; and use data forms and validation to facilitate data entry in lists; and use data tables to project values. Create and use PivotTables to analyse and compare large amounts of data. Import data from and export data to external databases. Use Goal Seek and Solver to perform what-if analysis; and use custom scenarios, advance custom views and pivot tables to manage large worksheets. Run and record macros to automate complex or repetitive tasks. Publish a worksheet as an interactive Web page. Apply financial formulas and array formulas in Data Tables to determine outcomes.Prerequisites: This course is designed for students who have completed the Excel Intermediate 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 consolidate and expand their knowledge, to include some of the more complex functionality of Excel Training Avaliability and Delivery
Related Keywords: microsoft excel 2007 desktop applications office spreadsheet 2003 2000 Training Program DetailsCourse Content:
Advanced Formulas Using Names Decision-Making Financial Formulae Financial Functions Data Tables Advanced List Management Database Functions Data Forms and Validation Subtotal Function Group and Outline Listed Data Analytical Options Goal Seek And Solver Scenarios Views Reports Exporting And Importing Exporting & Importing Data Querying Access Databases Querying Web Databases Pivot Tables Creating A Pivot Table Rearranging Pivot Tables Formatting Pivot Tables Pivot Charts Group and Outline Pivots Apply Table Options Extract a Grouped Value Macros Recording And Running A Macro Editing VBA Code Function Procedures Advanced Web Topics Creating Interactive Web Spreadsheets Pivot Tables On The Web 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/20/08 Copyright 1998-2008 skillbox, inc. All rights reserved |
 |
|
| Are you a Microsoft training provider? |
| You could be on this page today - for FREE! |
