Lambda Dynamic Array Formulas for Statistical Control Plots | Jon Peltier

SESSION TRACK:
Excel

SESSION OUTLINE:
Conventional Excel techniques for generating Statistical Process Control (SPC) charts required more helper columns than chart source data columns. With the advent of Dynamic Array formulas, intermediate calculations need not clutter up a worksheet. Microsoft MVP Jon Peltier will show us how conventional SPC formulas can be converted to simple Dynamic Arrays, and how these can be further combined into a single Lambda formula to make dynamic charts as follow-up data is added.

SPEAKER PROFILE:
Jon Peltier is a master of leveraging the power of Excel to produce and simplify complex solutions in engineering, finance, and marketing. His background includes Statistics, Total Quality, and Six Sigma, and he knows more about Excel charts than practically anyone. Jon has been a full time Excel developer since 2004, and has received Microsoft’s Most Valuable Professional award for Excel every year since 2001.

Connect with and follow Jon online at:

• Website: https://peltiertech.com
• Twitter: https://twitter.com/PeltierTech

TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time):

• 8:45am Teams Meeting opens to attendees to begin joining
• 9:00am-9:05am Welcome and meeting overview
• 9:05am-10:05am Feature Presentation
• 10:05am-10:10am Meeting Wrap-up

REGISTRATION:
This meet-up will be hosted on Microsoft Teams, and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the Teams Meeting link.

JOINING THE EVENT:
Attendees can join the Teams Meeting starting at 8:45am on the day of the event. The link will be visible only if you RSVP beforehand.

Once the event gets underway at 9:00am, we ask that attendees make sure they are on MUTE, so background noise and distractions are minimized.

During the presentation, attendees can type questions and comments into the chat area, which will be monitored by the event hosts. There will be time for Q&A at the end, where attendees can un-mute their mic and even share their video to ask questions.

**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.

A link to the recording will be posted here on the event page and on the Excelguru social media channels once it is available (usually a day or 2 after the event).