- 1. What is VBA, basic concepts.
- 2. Debugger (Debugger)
- 3. Working with sheets (Sheets)
- 4. Working with cells (Ranges)
- 5. Properties (Properties)
- 6.1. Data types (Variables)
- 6.2. Data Types (Continued)
- 7.1. Conditions (Conditions)
- 7.2. Terms (Continued)
- 8.1. Loops (Loops)
- 8.2. Cycles (Continued)
- 9. Procedures and functions
- 10. Dialog boxes
- 11.1. Workbook Events
- 11.2. Worksheet Events
- 12.1. User forms
- 12.2. Controls (Controls)
- 12.3. Controls (Continued)
- 12.4. Controls (Exercises)
- 13.1. Arrays (Arrays)
- 13.2. Arrays (Continued)
- 13.3. Arrays (Exercises)
- 14.1. Using Excel functions
- 14.2. Creating a custom function
- 1. SQL language, basic concepts.
- 2. Data selection (SELECT)
- 3. Sorting data (ORDER BY)
- 4. Data filtering (WHERE)
- 5. Using metacharacters (LIKE)
- 6. Calculated (calculated) fields
- 7. Data processing functions
- 8. Grouping data (GROUP BY)
- 9. Subqueries
- 10. Joining tables (INNER JOIN)
- 11. OUTER JOIN
- 12. Combined queries (UNION)
- 13. Adding data (INSERT INTO)
- 14. Creating tables (CREATE TABLE)
- Import of exchange rates from the NBU website
- Sum written in English
- Unpivot tables (Unpivot)
- Function
Google Translate - Camel Case Function
- Snake Case Function
- Kebab Case Function
- Break Case Function
- Sentence Case Function
- Title Case Function
Fuzzy Lookup Function- GETSUBSTR function
- Professional extension "YLC Utilities"
- How to create a Python macro
- How to write a function in Python
The YLC Utilities menu in LO Calc
The YLC Utilities menu in Excel
