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.

  • Microsoft Excel Associate Training: June 15, 22, 29, July 6, 13, 20
    Details and Registration 
  • Microsoft Excel Expert Training
  • Analytics in Excel

Continuing Education Units

A Certificate of Completion is provided with each course showing number of contact hours (instruction), and field of study as "Information Technology" for continuing education purposes. Most courses provides 12 contact hours and are equivalent to 1.2 CEU's.

The term CEU is not a trademarked term; therefore, any educational institution may use it to describe their courses. Professions and industries usually regulate their approved continuing education within their bylaws and not one institute or accrediting body has become a standard to accept in this regard. Professionals should always consult their Association or regulating body prior to embarking on continuing education and not assume a CEU will be accepted as part of their professional development.


6 online sessions with a live instructor  2:00 - 4:00 PM  June 15, 22, 29, July 6, 13, 29

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).

  • Time commitment 12-16 hours     
  • Certificate of Completion.
  • Attendees are prepared to take the MOS Excel Associate Certification Exam
  • Required class for “Data Analytics in Excel” Certificate of Competency

Online Course Fees: See registration page 

These trainings can also be customized and delivered at your location.


Analytics in Excel

This class is designed to move those with moderate level Excel skills (i.e. completed Associated and Expert courses) to the next level.  This class will focus on using Monte Carlo Simulations, and associated data management and visualization tools that managers find useful in supporting decision making.  The Monte Carlo simulation enables the expert user to create a model that captures probabilities and makes estimates of outcomes.  The work will build on and improve statistical and probability reasoning as a foundation for prediction. Our primary example will focus on predicting the value of a stock over time and making decisions based on multiple desired outcomes.  In addition, to this example, other relevant problems will be shared and explored.

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 2016 or later.  No Excel online.  Windows platform preferred, 

  • ·       Online: Four 3-hour classes over a four-week period (1X/week)
  • ·       Time Commitment:  12-16 hours
  • ·       Certificate of Completion.
  • ·       Required class for “Data Analytics in Excel” Certificate of Competency
ANALYTICS IN EXCEL: TOPICS COVERED

Session                  

Topics Covered

           

Introduction to Monte Carlo Simulation

Discuss identifying probability from an archival data set

Practice identifying probability from an archival data set

Create a new data set based on probability of occurrences in a former data set

Practice simulating stock prices

Practice simulating retirement account

2

Advanced Visualization and Data Management Part 1

Explore Templates in Excel

Download the Developer Tool Pack

Practice using graphical user interface tools

Discuss when tools are most useful

Use them to allow a user to create/modify visualizations

3

Advanced Visualization and Data Management Part 2

Practice using lookup functions to find observations in a data set

Embed functions behind graphical user interface tools

Use them to allow a user to create/modify visualizations

4

Decision Making Based on Simulations

Discuss a variety of decision outcome types

Identify using simulations and visualizations for each decision type

Create a sensitivity analysis around stock prices

Create a what if analysis around stock prices

4 online sessions

Online Course Fees: See registration page 

These trainings can also be customized and delivered at your location.


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 2016 or later.  No Excel online.  Windows platform preferred, although participants can use Apple OS computers (some actions will be different between the two systems).

  • Time commitment 12-16 hours     
  • Certificate of Completion.
  • Attendees are prepared to take the MOS Excel Associate Certification Exam
  • Required class for “Data Analytics in Excel” Certificate of Competency

4 online sessions

Online Course Fees: See registration page 

These trainings can also be customized and delivered at your location.

Replace with your text


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