Excel Tips
At this week’s after school PD, we learned to use Excel to manipulate text and numbers with formulas and array formulas and look up information/fill in information automatically with VLOOKUP and LOOKUP. For manipulating text and numbers, use these formulas: CONCATENATE, CONCAT, “”&”” – combine two or more cells, strings, or numbers AVERAGE, MEDIAN, MODE, […]