Free Excel Webinar with CE credits available! скачать в хорошем качестве

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