Return to pass home page | About pass | Request A Brochure | Contact Us | Sitemap   

     

Excel Expert Course Details

Excel Expert

  • Review Exercise

Auditing a Worksheet

  • Using Worksheet Auditing Tools
  • Data Entry Validation
  • Validating the Whole Worksheet
  • Auditing Data Dependency
  • Finding and Replacing Data

Working with Data Lists

  • Setting Up Lists
  • Sorting Lists
  • Filtering Lists
  • Using Forms

Data Management

  • Searching for Data with Advanced Filters
  • Compiling Consolidations
  • Summarising Data with Outlines
  • Querying a Database
  • Data Sources
  • Controlling Formatting and Layout
  • Refreshing External Data

BACK to Excel Expert

PivotTables

  • Creating a PivotTable
  • Modifying a PivotTable
  • Creating a PivotTable Chart
  • Creating Interactive PivotTables for the Web

Using Analysis Tools

  • Goal Seeking
  • Using Solver
  • The Scenario Manager
  • Scenario Summaries
  • Merging Scenarios

Collaborating with Workgroups

  • Applying Worksheet Protection
  • Password Protecting a File
  • Changing Workbook Properties
  • Adding Comments to the Worksheet
  • Shared Workbooks
  • Tracking Changes
  • Resolving Conflicts
  • Merging Workbooks
  • E-mailing Workbooks for Review

Regulatory & Legal Notices


Pass Training, London. Computer training, Accountancy training, Auditing and taxation courses, personal Development, and Business Development training courses in London UK
66 Wigmore Street, London, W1U 2SB (UK)
 Tel: 020 7284 4995   Fax: 020 7284 2966
 Email: info@pass.co.uk