2 minute read
Excel expert teaches workplace skills
By Adam S. Kamras
Mike Morris
Advertisement
Microsoft® Excel Advanced Concepts course instructor
UD PCS Microsoft® Excel instructor Mike Morris designed his three courses to meet the needs of his students. As a result, participants in Microsoft® Excel Advanced Concepts learn the 10 most important functions used in the workplace.
“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 UD PCS Microsoft® Excel Essentials and Microsoft® Excel Advanced Reporting and Analytics 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 each session of the hands-on courses, students are given the opportunity to immediately apply the lessons by working on related exercises. For further reinforcement, additional, optional exercises are provided for independent practice. 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.
“Students can call me with questions after the course has been completed,” said Morris. “I live Excel all the time and am happy to help people out.”
10 most important microsoft® excel functions used in the workplace:
• CONCATENATE, SUBSTITUTE
• LEN, TRIM
• CELL, LEFT, MID
• UPPER, LOWER, PROPER
• MIN/MAX
• VLOOKUP/HLOOKUP
• INDEX/MATCH
• ROUND, ROUNDUP, ROUNDDOWN
• CONVERT, VALUE, TEXT
• Flash Fill, Auto Fill
_______________________________________________________________________________
