MrExcel's Favorite Excel Tips and Tricks (2 CPE)

When:  Feb 23, 2023 from 11:00 AM to 01:00 PM (CT)
Associated with  Minneapolis Chapter
Join us on Thursday, February 23rd from 11am-1pm for a presentation by Mr. Excel.  Our chapter hosted Bill Jelen in person back in 2019.  Minnesotans traversed through snow that Saturday morning getting to/from our H.B. Fuller venue.  This will be a complementary webinar offered over an extended lunch hour during the business day.  No shoveling necessary to participate.

Earn up to 2 CPE.  Given how much us Accounting & Finance professionals use Excel, this should be quite an informative presentation.  As an added bonus, each attendee will receive an electronic copy of Mr. Excel's latest book Boosting Excel

Registration is now live:
https://event.on24.com/wcc/r/4099358/2963D7D5F7A227F37C9782394FCA8782

Overview

Title: Minneapolis Chapter: MrExcel's Favorite Excel Tips and Tricks

Date: Thursday, February 23, 2023

Time: 11:00 AM Central Standard Time

Duration: 2 hours

Summary

Spend two hours virtually with Bill Jelen from MrExcel.com He will cover new and exciting topics in Excel, plus his favorite power Excel techniques. Everyone who attends can download the PDF of Bill’s latest book: MrExcel 2022: Boosting Excel. This book is over 275 pages and covers 100+ Excel techniques.

Topics in the two hour virtual session will include:

  • Summarizing data with Pivot Tables, Subtotals, and faster Filtering
  • 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
  • Learn the benefits of XLOOKUP over VLOOKUP
  • Artificial Intelligence in Excel
  • Learn the new spillable functions that allow you to SORT and FILTER with a formula.
  • See new functions such as TEXTSPLIT, and IMAGE

Bill JelenBill Jelen
Mr. Excel


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 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.

Event Image