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

    		•

    Special Course - Excel - Power User

    Course Prerequisites:

    This is an intensive course and is designed for existing users of Excel and assumes that users are familiar with basic formulas and the functions SUM, MIN, MAX, AVERAGE and COUNT. It is also assumed that users have used Excel regularly over a minimum period of 3 months.

    Course content:

    Review of basics

    The Excel Environment

    Entering and Formatting Dates and Values

    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 filtering

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

    Subtotals and Grand totals
    Creating and working with the Subtotal feature

    View and Report Manager
    Creating and using views
    Creating and printing reports

    Workbook Templates
    Creating and using Templates

    Analysing data using charts
    Enhancing charts
    Useful chart tips

    Miscellaneous
    Using names in formulas
    Using Relative and Absolute references
    Selecting Non-Contiguous Areas
    Using SUMIF and COUNTIF functions
    Working with tables and table 'rules'

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