Excel – Must-know formulas and functions → Text functions

Basic Math formulas 1
- Lecture1.1
  
  Basic Math formulas
  10 min
Autosum and relative references 1
- Lecture2.1
  
  Autosum and relative references
  10 min
Absolute references 1
- Lecture3.1
  
  Absolute references
  10 min
Range names 1
- Lecture4.1
  
  Range names
  10 min
Linking sheets and workbooks 1
- Lecture5.1
  
  Linking sheets and workbooks
  10 min
If, and, or, and the nested if functions 1
- Lecture6.1
  
  If, and, or, and the nested if functions
  20 min
Countif, Sumif, Averageif, Countifs, and Sumifs functions 1
- Lecture7.1
  
  Countif, Sumif, Averageif, Countifs, and Sumifs functions
  10 min
Vlookup and Hlookup functions 1
- Lecture8.1
  
  Vlookup and Hlookup functions
  20 min
Match and Index functions 1
- Lecture9.1
  
  Match and Index functions
  10 min
Date/time functions and calculations 1
- Lecture10.1
  
  Date/time functions and calculations
  15 min
Text functions 1
- Lecture11.1
  
  Text functions
  15 min
Tracking formulas 1
- Lecture12.1
  
  Tracking formulas
  10 min

Guardian Academy