The main objective is to provide users with advanced skills and knowledge in Excel, especially those focused on data extraction and processing, taking advantage of all the program's resources to increase efficiency and effectiveness in daily tasks.
Instructor: David Monsó Morera, Pitagora Group
Topics that are going to be addressed:
1. Working with data (Advanced)
· Working with tables (advanced)
· Understanding structured reference
· Using structured references in functions
· Advanced filter
2. Data consolidation
· Based on position
· Based on category
· Based on formula
· Using pivot tables
3. Advanced Pivot tables
· Pivot Tables (review)
· Advanced features and options in Pivot Tables
· Calculated fields
4. Import/Export data
· Loading data from several sources
· Export data in different file formats
· Create and deal with .csv files