Introduction to setting up Dashboards on XL ITAG Skillnet
Price: AED 151

    Course details

    You should be able to do the following before attending this course. This knowledge will be assumed and will not be covered on the course.

    • Create a pivot table
    • Use vlookups
    • Apply conditional formatting
    • Be familiar with the basics of Excel:
    • Using plus/minus/multiply/divide
    • Know how to fix a cell/row/column (using $$/F4 in formulas)

    What is covered in the course

    • How to set up your dashboard
    • Identifying what you want to measure
    • Create interactive pivot tables, complete with dropdown lists,slicers and charts.
    • Learn how to effectively use the GetPivotdata function.
    • Use Advanced capabilities of pivot tables.
    • Case studies – sales data and accounting data
    • The course content may vary slightly on the day depending on participants.
    Updated on 08 November, 2015

    About ITAG Skillnet

    ITAG Skillnet is a network of over 50 companies involved in the IT sector in the Galway area. The companies range from micro start-ups to local multi-nationals with a strong IT emphasis. The training network evolved from the promoter organisation, the Information Technology Association Galway (ITAG).

    ITAG Skillnet’s primary objective is to strengthen and develop the IT sector in Galway by improving competitiveness and reducing training costs, with investment in employees through tailored training and learning programmes. To date, ITAG Skillnet has trained over 2,000 employees from member companies.

    ITAG Skillnet is pleased to be able to offer a limited number of free places for jobseekers on some of Thrie programmes. Click the link to see if you are eligible to attend Eligibility criteria

    established in 1999 to support the development of workplace skills. The Training Networks Programme is a unique initiative and is funded from the National Training Fund through the Department of Education and Skills.

    See all ITAG Skillnet courses
    Are you from ITAG Skillnet ? 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?

    Didn't find what you were looking for ?

    or