SWATuk

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

     

Excel Expert (Advanced Level 2) 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

Pass Training, London. Computer training, Accountancy training, Auditing and taxation courses, personal Development, and Business Development training courses in London UK
SWAT UK Block 2, Angel Square, London, EC1V 1NY (UK)
Tel: 0845 330 2772 Fax: 0845 450 0545
 Email: info@pass.co.uk