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 14 contact hours and are equivalent to 1.4 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.

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.

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

4 online sessions

Online Course Fees: See registration page 

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

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.

• 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!