TOP

- Input fractions in Excel
*How to input ordinary fractions in Excel.* - Alignment autoshapes
*How to align the autoshapes on the edges of cells.* - How to do an indent while entering text to the cell
*Make an indent while entering text to the cell in Excel.* - Changing the direction of data entry
*Changing the direction of data entry, when after pressing Enter, cursor move not to down, but to any other direction.* - Cell with secret
*How to hide the cell content without sheet protection.* - Hint during filling in data into cell
*Hint during filling in data into cell.* - How to insert macros in Excel
*How to insert macros in Excel.* - Merging of two columns with data
*How quickly merge data from two mutually non-overlapping columns with blank cells. Without any formulas, macros, etc. - only using mouse.* - Quick jump between worksheets
*How does quickly jump into required sheet in a workbook, if we have many sheets?* - Hotkeys in Excel
*Convenient table with hotkeys in Excel.* - Filling in blank cells in the list
*How quickly fill in blank cells in the column, inserting there values from higher cells.* - Fast input todays date (TODAY)
*Two quick ways to input today's date.* - Autofill of cells
*How to automatic fill in the cells.*

- 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 windows
- 11.1. Workbook events
- 11.2. Worksheet events
- 12.1. Custom forms
- 12.2. Controls (Controls)
- 12.3. Control elements (Continued)
- 12.4. Control elements (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. Data sorting (ORDER BY)
- 4. Data filtering (WHERE)
- 5. Use of metacharacters (LIKE)
- 6. Calculation (calculation) fields
- 7. Data processing functions
- 8. Data grouping (GROUP BY)
- 9. Sub-requests
- 10. Combination of tables (INNER JOIN)
- 11. OUTER JOIN
- 12. Combined requests (UNION)
- 13. Adding data (INSERT INTO)
- 14. Creating tables (CREATE TABLE)

- Import of currency rates from the NBU website
- Sum written in English
- Unpivottables (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- Function GETSUBSTR
- Free extension "YouLibreCalc"
- Professional Extension "YLC Utilities"