Excel CHOOSECOLS, CHOOSEROWS, DROP, EXPAND and TAKE functions
Here, we will learn how to use the Excel dynamic array functions: CHOOSECOLS, CHOOSEROWS, DROP, EXPAND and TAKE.
Excel VALUE and NUMBERVALUE functions
Here, we will learn how to use the Excel text functions: VALUE and NUMBERVALUE.
Excel LOWER, UPPER, PROPER and EXACT functions
Here, we will learn how to use the Excel text functions: LOWER, UPPER, PROPER and EXACT.
Excel TEXT, DOLLAR and FIXED functions
Here, we will learn how to use the Excel text functions: TEXT, DOLLAR and FIXED.
Excel CONCATENATE, CONCAT and TEXTJOIN functions
Here, we will learn how to use the Excel text functions: CONCATENATE, CONCAT and TEXTJOIN.