Speeding Up and Debugging Excel Formulas | Charles Williams
Details
**Please note the earlier than usual start time due to the time zone difference with our presenter.
SESSION TRACK:
Excel
SESSION OUTLINE:
Learn how to speed up and debug your Excel Formulas with Microsoft MVP, Charles Williams! There are three main steps in speeding up Excel workbooks:
- Identify and prioritize the bottlenecks.
- Work out why they are slow.
- Change them formulas to run faster.
Because there are no native Excel tools that help do this, Decision Models launched the first version of FastExcel profiler in 2001.
Although Excel does have some ancient tools for debugging formulas, modern Excel’s array formulas and Lambda formulas are increasingly hard to understand and validate. Lambda Explorer is a free Excel add-in designed to solve this problem.
This session will demonstrate speeding up workbooks and debugging formulas using some of the capabilities of Charles Williams’ FastExcel and Lambda Explorer add-ins.
SPEAKER PROFILE:
Charles Williams is a VBA and C++ developer focused on making Excel run faster and on plugging gaps in Excel capability with his add-ins. Charles founded the Decision Models consultancy in 1996 and has received Microsoft’s Most Valuable Professional award every year since 2009.
Connect with and follow Charles online at:
- Website: https://www.decisionmodels.com/FastExcelLambdaExplorer.htm
- LinkedIn: https://www.linkedin.com/in/charles-williams-62aa8217/
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).