Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Microsoft Training Courses

Microsoft Excel 2007: Advanced Course (1 day)

Course Code: MEX07-21      Days: 1
Show all Microsoft Courses
Scheduled Dates
Locations filtered. Show all UK course locations.
Request availability or book by selecting a date:
Scotland
Glasgow
Glasgow (G2) 08/12/08 £ 215
Glasgow (G2) 09/02/09 £ 215
Glasgow (G2) 16/04/09 £ 215
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

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.

Audience

This course is designed for students who have completed the Excel 2007 Intermediate course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software

Course Outline

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


How to make a booking for the MEX07-21 course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership