Advanced Excel

Description

This course aims to provide participants with a set of more in-depth knowledge of MS Excel.

Target Audience

All employees who wish to develop their skills in Excel.

Program Content

Module 1 – Pivot Tables and Charts
- General description of Pivot Tables
- General description of Pivot Charts
- Create a pivot table or chart from spreadsheet data
Module 2 – File Management
- Basic Concept of Databases
- Creating a Data List
- Using Forms
- Data Entry Validation
- Protect Cells, Sheets, and Workbooks
Module 3 – Hypothesis Analysis and Data Simulation
- Simulation Tables
- Scenarios
- Goal Seek
- Solver Function
Module 4 – Excel Macros and Add-ins:
- Power Query
- Inquire
- PowerPivot
Course evaluation and closure.

User-Level Computing

Location: Lisbon

Duration: 14 hours

Available Dates

In-person (classroom)

February 23 and 24

Videoconference

- Session 1 - March 16 (10 AM-12 PM), Session 2 - March 17 (9 AM-12 PM), Session 3 - March 18 (9 AM-12 PM), Session 4 - March 19 (9 AM-12 PM), Session 5 - March 20 (9 AM-12 PM)