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
- IF function in detail
- IFS – select from multiple options
- Merging of selected strings – something like CONCATENATEIFS, if it existed
- NOW – automatically updated time
- Percentages and their calculation in Excel
- VLOOKUP – function to connect two tables