Conditionally Summing/Counting Data (SUMIF, COUNTIF). Being Precise using Rounding functions. Merging Text and Numbers with CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, and TRIM functions. Use DATE, YEAR, MONTH, DAY, TODAY, NOW, WEEKDAY, NETWORKDAYS date and time functions. Troubleshooting types of formula Errors. Using the Error Checker. Showing/Hiding Formulas, Evaluating Formulas, Selecting related cells, displaying cell relationships and removing relationship arrows.
Sorry, no classes are currently scheduled for this course. If you would like to be notified when this class will be offered again, click here: Notify Me
We proudly offer short-term class discounts for lifelong learners, full-time NPS and MPS employees, as well as valued service members, veterans, and their spouses. Learn about our short-term class discount program.