Microsoft Excel instructor Mike Morris has designed his three live-online courses through the University of Delaware Division of Professional and Continuing Studies (UD PCS) to meet the needs of his students. As a result, participants in Microsoft Excel Advanced Concepts (Thursdays, Oct. 13-Nov. 10) 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,” Morris said. “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 UD PCS Microsoft Excel Essentials (Tuesdays, Sept. 6-Oct. 4) and Microsoft Excel Advanced Reporting and Analytics (Wednesdays, Nov. 16-Dec. 21) 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 providing 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.