12.11.24 - 2 CPE with Mr. Excel + eBook (Igniting Excel)

We are excited to invite you to join us for

2 CPE WITH MR. EXCEL - IGNITING EXCEL

$30 IIA MEMBERS, $40 NON-IIA MEMBERS

JOIN US FOR THIS WEBINAR! PARTICIPANTS WILL RECEIVE AN E-BOOK COPY OF MR. EXCEL'S LATEST BOOK, IGNITING EXCEL, A $25 VALUE.

Topic: Igniting Excel

What's New in Excel
Spend an hour with Bill Jelen to learn new time-saving tricks in Excel. This session will focus on new features introduced to Excel in the last 3 years. Includes the benefits of XLOOKUP over VLOOKUP, Artificial Intelligence, Pivot Table improvements. Learn the new spillable functions that allow you to SORT and FILTER with a formula. See new functions such as TEXTSPLIT, TOCOL, and WRAPROWS.

Also:

Using AI to write Excel formulas with Copilot
Free add-in from Microsoft Labs to simplify complex formulas
What Python is and why is it in Excel
Creating a pivot table with a formula using PIVOTBY
Bill Jelen’s new most-used formula, GROUPBY

Data Analysis using Subtotals, Filtering, and Pivot Tables
You use Excel 40 hours a week, but do you really know how to unleash the power of Excel? Learn cool secrets and tricks lurking in Excel. Learn the ins and outs of Pivot Tables (from the guy who wrote the book on pivot tables!). Add thousands of subtotals in seconds. Learn faster ways to filter. Take a look at how the Power Query tools on Excel's Data tab can help you clean data faster and with a built-in audit trail. Everyone who attends will receive a PDF copy of Jelen's latest book, MrExcel 2024 Igniting Excel. Join Bill Jelen from MrExcel.com for a webinar covering his favorite time-saving tricks in Microsoft Excel.

Speaker Bios

Bill Jelen - aka Mr. Excel

Bill Jelen is the is the host of MrExcel.com and the author of 65 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel 2019 Inside Out. He 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 2,100 episodes of his daily 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.