Advanced Formulas in MS Excel
Lesson Goals Learn about naming and labeling cells and ranges of cells. Learn to use names and labels in formulas. Learn to create formulas that span multiple worksheets. Learn to use the conditional IF function and its variants in formulas. Learn to use the PMT function to calculate payments for loans. Learn to use the LOOKUP function. Learn to use the VLOOKUP function. Learn to use the HLOOKUP function. Learn to use the CONCAT function to join the contents of numerous cells. Learn to use the TRANSPOSE function. Learn to use the PROPER , UPPER , and LOWER functions to alter the casing of text. Learn to use the LEFT , RIGHT , and MID functions to return characters from the start or end of a string, or a specific number of text characters. Learn to use various date functions. Using Named Ranges in Formulas Some of the advantages to ...