Key Facts

  • Starting
    6 Jun 2024
    Location
    Tooting
    Start Time
    18:15
    End Time
    20:45
    Duration
    5 Weeks
    Study Mode
    Part Time Day
    Days
    Thursday
    Start Date
    6 Jun 2024
    Level
    Short Course
    Code
    TICX016CL

    Fees

    19+ Fee
    Free

    Enrol

Excel Intermediate

Excel Intermediate

Print
Email

Keep me informed

This course builds on the Beginners' Excel course. This course provides a supportive environment for people who are comfortable with the fundamentals of Excel. The course focuses heavily on functions. You will learn how to use Microsoft Help to understand any function.

  • Entry Requirements


    Completion of the South Thames Beginners' Excel course. Or, you will need to be familiar with Excel fundamentals, for example data formats (number, text etc.), making simple formulae to add, subtract etc. and understand basic Excel navigation and terminology.

  • Course Content


    By the end of the course you'll be able to:

    Explain the structure and components of a function Use the following Excel functions: SUM, AVERAGE, MODE, MEDIAN, COUNT, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF Solve practical domestic and work-place problems using Excel Use Excel Help to understand how any Excel function works Learn more advanced Excel terminology Use filters and drop-down lists *You will practise answering a typical job interview Excel test.

  • Progression Next Steps


    Advanced Excel at South Thames College

  • Additional Information


    Your tutor will provide a booklet with explanations and exercises. You should bring pen, pencil and rubber.

  • Course Structure


    work. You are invited to ask questions at any time.

  • Assessment Details


    Your tutor will provide a mini-booklet with explanations and exercises for you to complete in class and take away. There will be a blend of computer-based exercises, theory, discussions, group and pair work. You are invited to ask questions at any time.