Live Interactive Webinar
HANDS-ON: Advanced Data Analytics in Excel
Price: $99
Subscriber price: $49Become a subscriber
Feb. 20, 2018 Tuesday
12:00 PM - 02:00 PM (Pacific)
2 Hours
Interactive Webinar
A unique webinar designed to interactively teach you a skill or concept with a hands-on approach

Interactive Webinar with live learning and hands-on practice
- Guided learning
- Ask questions and immediately get answers from the Instructor
- Understanding is built step-by-step
- Walk-throughs, repetition, and exercises are used
- Real-world examples and careful explanations
- Documents and material provided before the session
- Your webinar is recorded and available anytime for you to review and practice
Michael McDonald, Ph.D. President, Morning Investments
In this innovative two-hour session expert Michael McDonald brings a new approach to learning the fundamentals of analyzing data in Excel. Unlike traditional webinars where it can be hard to try out techniques as the instructor is teaching, this session will have purposeful breaks for you to try out techniques on your own.
Excel is a versatile tool that can be used for a lot of advanced data analysis projects – if you know how to use the various supplemental add-ons and features. This in-depth 2 hour webinar walks participants through the critical elements of performing advanced analysis in excel.
Throughout this event, every technique is carefully explained and demonstrated, first, on a PowerPoint slide with numbered steps, providing context, and then in Excel, at a ‘follow-along’ pace as you do the steps at the same time.
Interacting with the instructor is encouraged and one-on-one attention is given, just as in a live training session. This is the closest you can get to ‘live classroom’ instruction while not having to leave your place of work.
Topics to be covered include:
By the end of the webinar, participants will be equipped to perform complex analysis on a variety of types of data and draw inferences based on the data to make business decisions effectively.
Excel is a versatile tool that can be used for a lot of advanced data analysis projects – if you know how to use the various supplemental add-ons and features. This in-depth 2 hour webinar walks participants through the critical elements of performing advanced analysis in excel.
Throughout this event, every technique is carefully explained and demonstrated, first, on a PowerPoint slide with numbered steps, providing context, and then in Excel, at a ‘follow-along’ pace as you do the steps at the same time.
Interacting with the instructor is encouraged and one-on-one attention is given, just as in a live training session. This is the closest you can get to ‘live classroom’ instruction while not having to leave your place of work.
Topics to be covered include:
- How to gather and clean a compiled dataset from disparate sources
- How to identify and flag outliers in data
- How to compute correlations between variables
- How to turn non-numerical qualitative data into numerical data that can be effectively analyzed with statistics
- How to perform basic regressions in excel for use in finding hidden relationships between business decisions
- How to run t-tests and other statistics to make informed business decisions based on data
By the end of the webinar, participants will be equipped to perform complex analysis on a variety of types of data and draw inferences based on the data to make business decisions effectively.
Learning Objectives
After attending this event you will be able to:

Gather and clean a compiled dataset from disparate sources.

Identify and flag outliers in data.

Compute correlations between variables.

Turn non-numerical qualitative data into numerical data that can be effectively analyzed with statistics.

Perform basic regressions in excel for use in finding hidden relationships between business decisions.
Speakers

Michael McDonald, Ph.D.
President, Morning Investments
Michael is a finance professor at Fairfield University in Connecticut and is an associate with TRI Corporation, a training firm focused on cross functional and financial training doing work for Fortune 500 firms. He holds a PhD in finance from the University of Tennessee and his work has been quoted in the Wall Street Journal, CNN, Nasdaq.com, Bloomberg, Reuters, and many other outlets. Michael is the President of Morning Investments, a consulting firm headquartered in Connecticut. He consults extensively with organizations ranging form Fortune 500 companies and government agencies to start-up businesses on matters related to finance and investments. Michael has served also as an expert witness on finance related matters in legal disputes, and is an arbitrator with the Financial Industry National Regulatory Authority (FINRA).

Moderated by Jennifer Robbins
Illumeo Webinar Manager
Jennifer is a marketing specialist and the webinar manager for Illumeo. She has been a part of more than 200 webinar presentations, supporting our expert presenters and Illumeo users alike. When she’s not moderating webinars, she’s creating and managing marketing content.