MS ExExcel 2000 Advanced Training CourseMicrosoft Excel 2000 Advanced Training Course in London and the UK

Our Excel 2000 Advanced course will build on your current Excel skills. The Excel 2000 Advanced course will concentrate on Lookup Functions, Analysing lists using Pivot Tables, using What If Analysis and customizing Excel. Users attending this class must be able to demonstrate an Intermediate level of competence, or have attended our Intermediate course.

 

Excel 2000 Advanced Training CourseExcel 2000 Advanced Training Course Information

Audience: This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros

Course Duration

This is a 1 day Excel 2000 Advanced Course. Course starts at 09:30 and runs until 16:30

Excel 2000 Advanced Course Objectives: After the course, you will be able to:

Requirements: You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level.

Course Duration: This is a 1 day Excel 2000 Advanced Course. Course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This course can be run Onsite, at our Excel training Centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

 

Excel 2000 Advanced Training Course Contents

Lookup & Information Functions

  • Vertical Lookup (Vlookup)
  • Horizontal Lookup (Hlookup)
  • Match and Index
  • IsText, IsValue, IsDate , IsErr, Is Error, IsNa

Advanced List Management

  • Advanced Filters
  • Using List Features
  • Dynamic Lists

Pivot Tables

  • Using the Pivot Table Wizard
  • Changing the pivot table layout
  • Formatting
  • Grouping items
  • Inserting calculated fields
  • Pivot Table Options
  • Display and hide data in fields
  • Lay out reports directly on worksheet
  • Pivot Chart

What If Analysis

  • Scenarios
  • Goal Seek
  • Solver
  • Data Tables

Protecting & Sharing Files

  • Sharing a file
  • Tracking changes
  • Accepting or rejecting changes
  • Applying Data validation rules
  • Inserting comments

Introduction to Macros

  • Purpose of Macros
  • Recording macros
  • Where to save macros
  • Absolute and relative record
  • Running macros:
  • Custom buttons, menu items, keyboard shortcuts

 

Microsoft Training Courses

Adobe Courses

Mac Training Courses

Google Docs Courses

Evening Courses Excel 2000 Courses

What can I expect?

Training Course FormatsFormats / Locations

Course BookingHow to book your course

Course Cost Explained

Ms Office Courses are charged at a flat rate per day.

One to One - Charged at £450 per day

Group Onsite Training - Charged at £695 per day

Training at our training centre - Charged at £695 per day

MS Office Only

Technical Applications POA

Tips & Tricks

 

Get usefull tips and tricks with your favourite RSS Feed

 

Let us contact you. Simply select the button below and a member of our team will contact you back.

 

 


www Mouse