Our certificate courses cover a wide range of topics and dozens of Excel techniques, from basic spreadsheet design concepts to advanced training in formulas and macros. The certificate's three areas - core classes, Data Analysis and Visualization, and electives - cover the basic Excel features. The choice of courses in each category lets you take those that apply to your experience level and job category. Together, these courses will allow you to use Excel to its full potential and make you more effective in setting up, formatting, and analyzing your data.
A series of certifications, or "stackable certificates," ultimately build up to a Chancellor's Certificate. Each "stackable certificate" includes a badge that you can share on your LinkedIn profile and in your email signature. The key difference is that the smaller certificates include specific skills in the subject matter area, while a Chancellor's Certificate communicates mastery over broad themes. When you complete the requirements for your Chancellor's Certificate, UMSL issues you a printed copy of your credential with the Chancellor's signature that you can proudly display to your colleagues and family.
You can learn the valuable skills that will help you:
- Save time by learning to properly set up and format spreadsheets, using effective design techniques. Beginning with a well-designed spreadsheet means easier data entry and fewer entry errors.
- Add visual impact to your data through charts and PivotTables. Take a spreadsheet full of numbers and convert it to easy-to-understand graphs and summary tables to share with others through reports or presentations.
- Learn formulas and built-in functions to quickly calculate your data and perform statistical analysis.
- Get an overview of your company's finances by combining multiple lists or tables from different departments into one consolidated table. Have Excel calculate the tables, creating a summary table.
- Increase your efficiency by creating macros to automate processes.
Courses are held monthly and may be taken online synchronously or in person at our training center in Des Peres, St. Louis County, Missouri. Employers and job centers may also request training held at an offsite location. Please contact info@cetc.umsl.edu for further information.