Spreadsheets Advanced QQI/FETAC L6 Lir Business Services & Training Centre Ltd.
Price: AED 1,510

    Course details

    ECDL / ICDL Advanced Spreadsheets is a high-level certification programme which presents candidates with the opportunity to bring their spreadsheet skills to an expert level. This allows them to use the full potential of the spreadsheet application to produce, for example, higher quality management information. Successful completion of this module will enable candidates to master the more advanced functions of spreadsheet applications, enabling them to produce more sophisticated reports, and to perform complex mathematical and statistical calculations, thus saving time and improving productivity in the completion of tasks.

    Learning outcomes

    1. Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets.

    2. Use functions such as those associated with logical, statistical, financial and mathematical operations.

    3. Create charts and apply advanced chart formatting features.

    4. Work with tables and lists to analyse, filter and sort data.

    5. Create and use scenarios.

    6. Validate and audit spreadsheet data.

    7. Enhance productivity by working with named cell ranges, macros and templates.

    8. Use linking, embedding and importing features to integrate data.

    9. Collaborate on and review spreadsheets.

    10. Apply spreadsheet security features.

    Updated on 08 November, 2015

    About Lir Business Services & Training Centre Ltd.

    Established in Mullingar, Co. Westmeath, Ireland in 1988, initially as a local Professional Secretarial Service provider and rapidly expanded its services to include an IT and Soft Skills Training Centre, Full Colour Printing/Promotion Section and Career Development. 
    registered with QQI (the statutory awarding body for further education and training in Ireland) to offer programmes leading to QQI Awards on the National Framework of Qualifications (Level 5 and 6)
    • registered with ICS Skills as an ECDL Training Centre.
    • registered Sage Training Centre
    • registered Thesaurus Payroll Training Centre
    See all Lir Business Services & Training Centre Ltd. courses
    Are you from Lir Business Services & Training Centre Ltd. ? Claim your course!
    Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or