Instructor Mike Morris has designed his three live-online University of Delaware Division of Professional and Continuing Studies (UD PCS) courses to meet the needs of his students. As a result, participants in Microsoft Excel Advanced Concepts (Tuesdays, April 5-26) learn the 10 most important functions used in the workplace:

• CONCATENATE, SUBSTITUTE
• LEN, TRIM
• CELL, LEFT, MID, RIGHT
• UPPER, LOWER, PROPER
• MIN/MAX
• VLOOKUP/HLOOKUP
• INDEX/MATCH
• ROUND, ROUNDUP, ROUNDDOWN
• CONVERT, VALUE, TEXT
• Flash Fill, Auto Fill

“I have been working with Excel for many years and always seem to find that there are certain formulas and functions that people come to me with questions about,” said Morris. “The top 10 most important functions are the ones, no matter where you are working, you really need to learn and use.”

Morris, who holds the Microsoft Excel 2016 Expert Certification, also teaches the Microsoft Excel Essentials (Tuesdays, March 1-22) and Microsoft Excel Advanced Reporting and Analytics (returning in the fall) classes. Depending on their needs and familiarity with Excel, students can enroll in any or all of the three classes and benefit from the lessons.

“Excel skills are marketable across industries,” said Morris. “No matter what industry you work in, you are probably going to find yourself using Excel.”

After the material is presented in the hands-on courses, students are given the opportunity to apply the lessons by working on related exercises. Along with being given a reference guide summarizing the major topics and additional resources, Morris is happy to continue to provide assistance following the end of his classes.

For more information, visit the UD PCS Microsoft Excel webpage.