MasterClass - Spreadsheet & Dashboard
This course provides hands-on training on Odoo Spreadsheets.
You will work with a dedicated test database containing sample data and guided exercises designed to progressively build your skills, from fundamental concepts to advanced use cases.
The training is modular and includes optional prerequisite sections covering spreadsheet basics, Odoo technical concepts and database structure. These sections may be skipped if you already have the required background.
The core of the course focuses specifically on Odoo Spreadsheets, with increasingly complex use cases that equip you with the skills needed to design and build your own dashboards.
| 最后更新 | 2026/03/02 |
|---|---|
| 完成时间 | 2天 30分钟 |
| 成员 | 51080 |
MasterClass
高级
中级
-
1.Introduction : Odoo & Business Intelligence (空白)1课程 。 15分钟
-
预览
-
-
2. Spreadsheet Training (空白)13课程 。 11小时 45分钟
-
2.0 Spreadsheet training
-
2.1 Fundamentals
-
2.2 Keyboard shortcuts & usability
-
2.3 Logical functions
-
2.4 Text functions
-
2.5 Search functions - Combining data
-
2.6 Error handling functions
-
2.7 Conditional aggregation functions
-
2.8 Array functions
-
2.9 Rounding functions
-
2.10 Date and time functions
-
2.11 Pivot tables
-
2.12 Recap exercises
-
-
3. Models & Fields (空白)1课程 。 2小时 30分钟
-
3.0 Technical : Models & Fields
-
-
4. Reporting in Odoo (空白)9课程 。 1天 2小时
-
4.1 How to report easily available data ?
-
4.2 Structure your analysis
-
4.3 Data Insertion
-
4.4 Data Manipulation - Intro
-
4.5 Filters
-
4.6 Graphs, Display & Dashboards
-
4.7 Data Manipulation - Advanced
-
4.8 Performance & Data cleaning
-
4.9 Access rights & Sharing
-
-
5. Use Cases (空白)1课程 。 4小时
-
Use case #1 : CRM Pipe analysis
-
-
6. Quote Calculator (空白)2课程 。 4小时
-
6.0 Setup of the Quote Calculator
-
Use Case 1 - TelNet Telecommunication
-