product-logo

    Excel: Analysing Data

    • Bechtle-Nr.EDU128423
    • Type trainingSeminar waarbij je persoonl. aanwezig moet zijn, Live online training
    • DoelgroepGevorderde gebruikers, Leerkrachten, Medewerkers Controlling, Office-gebruikers
    • Duur1 dag(en)

    Kies:

        € 420,99

        Brutoprijs: € 509,40 incl. € 88,41 btw

        1

        Alle informatie op een rij

        Type training

        Seminar waarbij je persoonl. aanwezig moet zijn, Live online training

        Duur

        1 dag(en)

        Vereisten:

        Good basic knowledge of using Excel e.g. Everything covered in the "Excel: Basics" course.

        Doel:

        You'll get to know Excel as a database tool. You'll search, sort and filter list data and learn how to organise lists into groups. Using PivotTables, you'll create dynamic analyses and statistical reports For Office 2013, 2016, 2019 and O365.

        Inhoud:
        • Importing and processing data
        • Using the sort feature
        • Filtering, selecting and extracting data
        • Functions to evaluate data and database lists
        • Mapping datasets and finding duplicates
        • Data tables
        • Subtotals and related functions
        • Creating and working with pivot tables
        • Creating and working with pivot charts
        • Filtering pivot tables using slicers
        Commentaar:

        This training consists of 2 modules that make up the standard content of in-person training, but which can also be booked as half-day webinars.