Free Excel Webinar with CE credits available!

Join MrExcel for a FREE interactive webinar covering the latest in Excel tips and techniques that can save you HOURS of work. CE credits will be available as well!
Table of Contents
(0:00) Welcome to the Excel webinar & agenda
(4:15) Excel Picture in cells instead of on top of cells
(5:17) Using IMAGE function in Excel
(6:34) Create a Reference from IMAGE function in Excel
(7:14) WRAPROWS function in Excel with images
(8:04) Filtering images using Alt Text
(10:43) What if images are on local hard drive?
(11:30) Insert Picture in Excel and Place in Cells
(12:05) Replace Alt Text for Excel Images to enable sorting and filtering
(12:45) XLOOKUP in Excel to return an image
(14:00) XLOOKUP an image to return the title
(16:52) Apple Watch Challenge - Time to Stand!
(17:05) Supernatural VR in the headset
(17:34) Displaying images in Excel Pivot Table
(18:45) VBA Macro to add Alt Text to many images in Excel
(19:15) Excel Labs add-in to create LAMBDA from an existing system of subformulas
(20:00) The Add-Ins icon recently moved in Excel
(26:13) Poll question How Often Do You Use Pivot Tables?
(27:29) Create your first pivot table in Excel
(28:32) Why Excel pivot tables are intimidating
(29:40) Changing Number Format in Pivot Tables in Excel
(30:00) Rearranging fields in a pivot table
(31:17) Pivot Table row fields in separate columns
(32:05) Repeat Item Labels in Pivot Tables
(33:00) Excel Feature Request to the Excel Team
(33:38) Changing Pivot Table Defaults in Excel
(35:00) Rolling up daily dates in an Excel pivot table to months and years
(36:10) Year-over-Year report in an Excel pivot table
(36:40) Why does Excel use GETPIVOTDATA in your formulas?
(37:20) Spin the Wheel using Rob Collie's workbook
(38:00) PERCENTOF function in Excel for Percentage of Total
(40:30) Copilot in Excel
(41:05) Using Copilot in Excel to Add Formulas
(43:58) Analyze Data in Excel uses Machine Learning
(46:00) Excel Ask a Question About Your Data
(46:50) Poll: Will Artificial Intelligence Eliminate Your Job?
(47:48) Sneak Peak: Bill-GPT with Excel Knowledge
(51:35) Supernatural VR Air Table to find songs from eighties
(52:26) Using Chat-GPT when accuracy is not really important
(53:00) Excel Labs.GenerativeAI function to call Chat-GPT from Excel formula
(54:00) Excel Pivot Table on a Map
(56:27) Build-up of houses in Merritt Island Florida 1961-1995
(59:54) GROUPBY function in Excel to pivot with a formula
(63:00) Wrap-Up

[@canaveenkumar7062]

You are our (finance professionals) hero seriously Bill ❤

[@roywilson9580]

Great video, thanks! Wish I could have joined you live.

[@canirmalchoudhary8173]

This is super exciting and insightful session. 👌👌👍👍

[@Mohamed-xt1fp]

Awaiting the bill GPT where we can get the reliable answer from the expert.

[@johndurran614]

Another excellent video

[@ExcelWithChris]

I tried the xlookup with pictures. Works perfectly but when file is in Sharepoint and you open file online in Excel, the first one you do it updates the pic. After that nothing happens. The pic does not update.

[@robertdseals1]

I didn't get the credits. Are they still in the works or who should I contact?

[@MrXL]

Check your e-mail on Wednesday March 27 around 12:10PM. It might go to spam. The subject line is CPE Certificate for Robert D Seals". It should come from a @jelen.onmicrosoft.com address.

[@markpodesta4605]

Don't worry Bill, AI won't put you out of a job!😀