Рет қаралды 3,836
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