EXCEL II

The main objective of the course is to provide users with advanced tools, especially focused on the use of complex functions and the processing and analysis of data, with special attention to the creation and use of pivot tables. 

Topics that are going to be addressed:

1. Excel syntax
· Relative vs absolute references (review) 
· Cell Formatting (advanced)  
 
2. Advanced calculations and functions
· Date 
· Text (advanced) 
· Logic (IF, AND, OR, IFERROR) 
· Mathematics / statistics 
· Search and reference: VLOOKUP / XLOOKUP 
 
3. Working with data
· Using Tables 
· Manage duplicates 
· Data validation 
· Conditional formatting (advanced) 

4. Pivot tables and Pivot charts
· Create and use Pivot Tables reports 
· Format and edit reports 
· Pivot charts 
 
Dates and hour: 22nd October 2024 (9:00-13:00h)
Instructor: David Monsó Morera, Pitagora Group
Location: Online
Maximum number of participants: 30
Application deadline: 14th October 2024

Registration HERE