Home Page
82 Bankside

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

  • Intermediate I
  • Intermediate II
  • Advanced

  • Excel - Intermediate II

    Course Prerequisites:

    This course has been designed for users of Microsoft Excel and assumes a basic knowledge of Excel.

    It is expected that users have attended the Excel Intermediate I course or are proficient with Excel and have good mouse and keyboard skills.

    Course content:

    Review of Basics

    IF, DATE and TEXT functions
    Using the IF function
    Nesting IF functions
    Using DATE functions
    Using TEXT function

    Sorting and Querying Data
    Sorting data
    Filtering data
    Advanced filters
    Extracting Records

    Workbook Maintenance
    Arranging Workbooks
    Freezing Panes
    Copying Worksheets
    Using comments
    Using Go To Special
    Changing Excel defaults

    Working with Workbook styles
    Creating styles by example
    Modifying and deleting styles

    Naming Cells and Ranges
    Using names in formulas

    Subtotals and Grand totals
    Creating and working with the Subtotal feature

    View Manager
    Creating views
    Using views
    Deleting views Report Manager
    Creating reports
    Printing reports

    Workbook Templates
    Creating and using Templates

    Analysing data using charts
    Creating a chart
    Adding items to a chart
    Amending a Chart
    Changing the chart type
    Printing Charts

    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