Advanced Excel Course: Dynamic Tables and Simulations



    Advanced Excel Course: Dynamic Tables and Simulations

    TUTORS Julio García -

    Course objectives

    Participants will gain advanced knowledge of Excel in areas of pivot tables and simulations

    Course content

    Unit 1. Fundamentals: Pivot tables

    • Concept of dynamic tables: advantages and uses
    • Creating a pivot table
    • Elements of a pivot table
    • Results management with pivot tables
    • Using filters with pivot tables
    • Getting averages
    • Preparation of reports
    • Statistics Generation
    • Creating dynamic charts

    Unit 2. Practical development of a dynamic table

    • Practical case: Creating a business plan
    • Structure of a pivot table
    • Data segmentation
    • Exporting PivotTables to Word and PowerPoint
    • Dynamic tables integrated into company management

    Unit 3. Practical applications of dynamic tables

    • Dynamic tables for Marketing departments
    • Dynamic tables for Operations departments
    • Dynamic tables for HR departments
    • Pivot tables for commercial departments

    Final evaluation

    Quality Questionnaire.

    Previous requirements

    To take this course, prior knowledge of basic and intermediate Excel is necessary.

    Software and Hardware Requirements

    • Hardware: Multimedia PC
    • Pentium IV or higher, 1 Gb of memory, sound card, speakers/headphones
    • Software:
    • Windows XP, Windows Vista or Windows 7
    • Browsers: Explorer 6,7 and 8 or Firefox 2 and 3
    • Java 1.5 or higher
    • Adobe Flash Player 7.0 or higher
    • Javascript enabled
    • Adobe Reader 8.0 or higher

    Target audiences

    This course is aimed at any type of student. However, due to its characteristics, it will be more useful for those who carry out a professional activity and have experience in using spreadsheets.

    | /

    Información relacionada a la formación

    Soporte siempre a tu lado

    Soporte de formación: Siempre a tu lado

    Formación presencial y telepresencial

    ¿Necesitas otra modalidad formativa?


    Bonificaciones para empresas