Please join us on Thursday, June 6th for a virtual 4 CPE hour session covering the below topics and learning objectives. 

Topic: Powerful New Features in Microsoft Excel

Location: Virtual / Zoom

Presenter:  Bill Jelen

Overview: 

Join Bill Jelen from MrExcel.com for an online event covering powerful new tools in Microsoft Excel. Topics include the amazing new features for cleaning data while creating an audit trail of each step. Take a deep dive in pivot tables. Learn how to unlock secret pivot table features. Use new Dynamic Array Formulas to sort, filter, remove duplicates and create pivot table results that automatically update. See how XLOOKUP runs circles around VLOOKUP or INDEX/MATCH. Use the new Microsoft Labs tools to build powerful custom formulas without any VBA. Bill will reveal many awesome shortcuts and little-known tricks. Everyone who attends receives a PDF of Bill's latest book, MrExcel 2024 – Igniting Excel.

Learning Objectives:

• Learn how to use Power Query tools in Excel to clean data while producing an audit trail of the data
• Understand little-known tricks when creating pivot tables
• Use new dynamic array formulas to Sort, filter, remove duplicates, create pivot tables and text to columns.
• Understand how XLOOKUP is better than VLOOKUP in Excel
• Use the Microsoft Labs add-in to create a custom formula in Excel without using any VBA

Bio:

Bill Jelen is the host of MrExcel.com and the author of 67 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Microsoft Excel Inside Out. He was an ESPN commentator for the World Excel Championships, has made over 80 guest appearances on TV's Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He writes the Excel column for Strategic Finance magazine. He has produced over 2400 episodes of his video podcast Learn Excel from MrExcel. Bill will entertain you while showing you the powerful tricks in Excel. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for readers all over the world. Jelen joins us from Merritt Island, Florida.

Time & Date: Thursday, June 6th, 2024 from 10:00AM - 2:00PM CST

Program Level: Basic- No prerequisites or advanced preparation needed.

 Cost:

- Members $50

- Non-Members $75

**Please Note: The cost of this meeting, similar to other KC IIA meetings, is included when registering using a Subscription. 

 CPE: 4 credit hours

Thank you for being KC IIA members and following us.

**Grace Dorman - VP Programs**

Officers and Governors – Kansas City IIA Chapter