Functions
- CUBEVALUE – get directly values from Power Pivot data model
- Extract text after the last instance of some character
- How to merge texts in Excel
- IF – one IF nested in another IF
- Merging of selected strings – something like CONCATENATEIFS, if it existed
- NOW – automatically updated time
- The FILTER function using something like “IN” operator – selection of items presented in some list
- IF function in detail
- VLOOKUP – function to connect two tables
- IFS – select from multiple options
- Percentages and their calculation in Excel