Webinar Recordings

What’s New in Excel with MrExcel

What’s New in Excel with MrExcel

Experience the Latest Features

On-Demand Webinar

Discover the new features in Microsoft Excel. There are new formula functions and improvements to pivot tables that Bill Jelen, ‘MrExcel’, demonstrated during the webinar.

This webinar covered:

  • Save your favorite pivot table settings in the new pivot table defaults dialog
  • New powerful formulas where one formula can spill an entire range of results
  • New calculation functions SORT, FILTER, UNIQUE
  • How XLOOKUP runs circles around INDEX/MATCH or VLOOKUP
  • Retrieve exchange rates, stock prices, or weather history using Data Types
  • Show all changes made in the last 60 days to your workbook: who, where, when.
  • A dozen other minor features such as Unselecting cells, Unhide multiple worksheets, stop Excel from nagging about CSV files.

Meet the Presenter

MrExcel from MrExcel.com

Bill Jelen – MrExcel

Bill is the host of MrExcel.com and the author of 64 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and 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.

Furthermore, Jelen has produced over 2,400 episodes of his Excel video podcast ‘Learn Excel from MrExcel’. 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.

Previous Webinars Hosted by MrExcel

Watch the webinar >

Tips to Perk up your Excel Workbooks with MrExcel.
More4apps and MrExcel Partner to bring you Date & Time Formats in Excel.

Watch the webinar >


Date & Time Formats in Excel: Automate Formulas for Budgets, Price Lists, and More

Get the brochure >

Date & Time Formats in Excel: Automate Formulas for Budgets, Price Lists, and More

Keep an eye on our events page for upcoming MrExcel webinars, browse our Resource Library for additional materials or connect with an expert today!

Connect with an expert

connect with your excel experts