Home Page
82 Bankside
Bolton
BL5 2QH

Tel: 01204 36 37 38
Course Information
  • Word-processing
  • Spreadsheets
  • Presentations
  • Databases
  • Project
  • The Internet & E-mail
  • Course Details
    Excel

  • Intermediate I
  • Intermediate II
  • Advanced

  • Excel - Advanced

    Course Prerequisites:

    This course has been designed for experienced users of Microsoft Excel.

    It is expected that users have attended the Excel Introduction/Intermediate courses or are highly proficient with Excel.

    Course content:

    Review of basic/intermediate skills

    LOOKUP functions
    Using VLOOKUP and HLOOKUP

    Auditing Workbooks
    Auditing worksheets
    Using tracer arrows
    Finding worksheet errors

    Workbook and Worksheet Protection
    Protecting and Un-protecting Workbooks
    Protecting and Un-protecting Sheets
    Selective cell protection

    Linking Workbooks

    Creating and Customising PivotTables
    Creating a PivotTable
    Adding and removing fields
    Hiding and displaying field detail
    Using page fields
    Working with totals in a pivot table
    Formatting and editing PivotTables
    Sorting items in PivotTable fields

    Other Excel functions
    Database, Logical and Information functions

    Introduction to Macros
    Command and Function macros
    Recording and running Macros
    Assigning Macros to the Keyboard and Toolbar

    Working with Toolbars
    Moving and Sizing toolbars
    Customising Toolbars

    Interpreting and Analysing data using Excel tools
    Goal seeker
    Creating and removing outlines
    Creating and using Scenarios
    Consolidating data

    Duration - 1 day

    Note: - Topics in italics may not be covered - this is subject to the levels of delegates attending each course.

      Home | E-mail | Location Map | Booking Form
     
      Site maintained by chris@actraining.co.uk
      Last updated 1 January 2014, AcTraining