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
  • Comparison of two lists and finding differences
• IFS – select from multiple options
• Percentages and their calculation in Excel