MasterClass - Spreadsheet & Dashboard
| Responsible | 300codeBot |
|---|---|
| Last Update | 09/25/2026 |
| Members | 1 |
Masterclass
-
1.Introduction : 300code & Business Intelligence (empty)1Lessons ·
-
1. Introduction : 300code & Business IntelligenceNew
-
-
2. Spreadsheet Training (empty)13Lessons ·
-
2.0 Spreadsheet trainingNew
-
2.1 FundamentalsNew
-
2.2 Keyboard shortcuts & usabilityNew
-
2.3 Logical functionsNew
-
2.4 Text functionsNew
-
2.5 Search functions - Combining dataNew
-
2.6 Error handling functionsNew
-
2.7 Conditional aggregation functionsNew
-
2.8 Array functionsNew
-
2.9 Rounding functionsNew
-
2.10 Date and time functionsNew
-
2.11 Pivot tablesNew
-
2.12 Recap exercisesNew
-
-
3. Models & Fields (empty)1Lessons ·
-
3.0 Technical : Models & FieldsNew
-
-
4. Reporting in 300code (empty)9Lessons ·
-
4.1 How to report easily available data ?New
-
4.2 Structure your analysisNew
-
4.3 Data InsertionNew
-
4.4 Data Manipulation - IntroNew
-
4.5 FiltersNew
-
4.6 Graphs, Display & DashboardsNew
-
4.7 Data Manipulation - AdvancedNew
-
4.8 Performance & Data cleaningNew
-
4.9 Access rights & SharingNew
-
-
5. Use Cases (empty)2Lessons ·
-
Use case #1 : CRM Pipe analysisNew
-
Use case #2 : Cash Flow Forecast on subscriptionsNew
-
-
6. Quote Calculator (empty)2Lessons ·
-
6.0 Setup of the Quote CalculatorNew
-
Use Case 1 - TelNet TelecommunicationNew
-