either

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.