UNIT 1. BASIC CONCEPTS

1. Interface elements
2. Entering and editing data
3. Formatting
4. Working with multiple sheets
5. Creating charts
6. Customizing
7. Help, an important resource

UNIT 2. DATA AND FORMULAS EDITING

1. Data types
2. Entering data
3. Cell references
4. Presentation

TEACHING UNIT 3. TABLES AND DATA LISTS

1. Starting data
2. Totaling and summarizing
3. Filtering and grouping data
4. Pivot tables
5. Data tables

DIDACTIC UNIT 4. DATA ANALYSIS

1. Setting up analysis tools
2. Tables with variables
3. Forecasting functions
4. Simulating scenarios
5. Pursuing objectives
6. The Solver tool
7. Other data analysis tools

DIDACTIC UNIT 5. DATABASES

1. Getting data
2. Editing databases
3. Database functions
4. XML mapping

UNIT 6. GRAPHICS AND DIAGRAMS

1. Generating graphs
2. Inserting mini-graphs
3. Customizing maxima and minima
4. Inserting shapes
5. Images
6. Graphic elements and interactivity
7. SmartArt

UNIT DIDACTIC 7. LOGIC FUNCTIONS

1. Logical relationships and values
2. Decision making
3. Nesting expressions and decisions
4. Conditional operations
5. Selecting values from a list

UNIT DIDACTIC 8. DATA SEARCH

1. Manipulating references
2. Searching and selecting data
3. Transposing tables

TEACHING UNIT 9. GROUP WORK

1. Sharing a book
2. Comments to data
3. Change control
4. Review tools

TEACHING UNIT 10. EXCEL CUSTOMIZATION

1. Parameters applicable to workbooks and sheets
2. Environment options
3. The Ribbon
4. Create your own tabs and groups

UNIT DIDACTIC 11. BUSINESS INTELLIGENCE WITH POWERBI

1. Business Intelligence in Excel
2. Powerbi tool

UNIT 12. POWER BI

1. Introduction to Power BI
2. Installing Power BI
3. Data Modeling
4. Data Visualization
5. Dashboards
6. Data Sharing