Analytics in Excel

Microsoft Data Analytics in Excel logo

The Center offers Excel classes that prepare students for the Microsoft Office Specialist (MOS) Excel Associate Certificate and Excel Expert Certificate exams.  There is also additional trainings focused on analytics methods in Excel.  Additional Excel for Analytics classes are being developed.


This course will cover the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects.   Participants who successfully finish the course will have been exposed to the skills needed to take the Microsoft Office Specialists Excel Associate Certificate test.   Class materials will be provided prior to the beginning of the course.

Prerequisite:

  • At least three to six months prior experience with Excel
  • A requisite level of comfort creating and formatting basic workbooks.
  • Ability to launch and Navigate around the Excel User Interface, including Ribbons
  • Open a Workbook
  • Enter data in a cell
  • Basic understanding of Functions (e.g. =SUM(A1:A15))

Software: Excel version 2010 or later.  No Excel online.  Windows platform preferred, although participants can use Apple OS computers (some actions will be different between the two systems).


Microsoft Office Specialist (MOS) Excel Expert Certificate Training

This course picks up from the MOS Excel Associate course and introduces advanced Excel functionality, including managing workbooks, managing and formatting data, advanced formulas and macros, advanced tables, including PivotTables and PivotCharts.  Participants who successfully finish the course will have been exposed to the skills needed to take the Microsoft Office Specialist Excel Expert Certificate test.   Class materials will be provided prior to the beginning of the course?

Prerequisite:

  • Completion of Excel Associate Certificate class required, or equivalent experience in a professional or academic setting
  • Managing tables and data
  • Working knowledge of functions
  • Basic charting

Software: Excel version 2010 or later.  No Excel online.  Windows platform preferred, although participants can use Apple OS computers (some actions will be different between the two systems).


Analytics in Excel (Coming in April 2021)

This class focuses on the use of Excel for data analytics. Practical use cases are introduced to illustrate concepts including exploratory data analysis and specific applications of descriptive and predictive analytics. Students will learn how to create regression models using the Data Analysis ToolPak in Excel. Students will learn how to formulate models for complicated decision-making scenarios that include uncertainty using Monte Carlo simulation. Use cases will include applications in marketing, operations and finance. Proper modeling form and interpretation of model outputs will be emphasized.

Prerequisite:

  • Completion of Microsoft Office Specialist (MOS) Excel Associate Certificate class required, or equivalent experience in a professional or academic setting
  • Preferred: Microsoft Office Specialist (MOS) Excel Expert Certificate Training 

Software: Excel version 2010 or later.  No Excel online.  Windows platform preferred.

Software: Excel version 2010 or later.  No Excel online.  Windows platform preferred, although participants can use Apple OS computers (some actions will be different between the two systems).

·       Online: Four 3-hour classes over a two-week period

·       Time Commitment:  12-16 hours

·       Certificate of Completion

·       Required class for “Data Analytics in Excel” Certificate of Competency


Testimonials

  • Learned what I needed for the workplace
  • Instructor was extremely knowledgable and very effective.  Super engaging for an otherwise boring topic
  • Great course for using Excel to visualize and dashboard data
  • Did a great job of checking for understanding, especially when covering complex material
  • I learned new things every minute of the class.  Well worth my time and money!

For more information about these classes, or for custom training classes, please contact
Headshot of Larry Porter

Larry Porter

Training , Marketing and Sponsorship Manager

513-556-4742