MS Excel: Using Images in Pivot Tables, a new added Feature by Microsoft
Вставка
- Опубліковано 6 вер 2024
- This video tutorial is about creating pivot tables with images in Microsoft Excel, a newly introduced feature. It walks you through the process step-by-step, starting with creating a new sheet for photos and adding images of salespeople next to their names. Then it explains how to use VLOOKUP function to bring those photos into the sales sheet. Finally, the video demonstrates how to create a pivot table report with photos included and resize the rows for better display.
#Excel #PivotTable #MicrosoftExcel #NewFeature #ImagesInPivotTable #ExcelTutorial #DataAnalysis #SalesReport #VLOOKUP #Productivity #ExcelTips #HowToExcel #Excel2023 #ExcelForBusiness
I used excel online for this exmaple, but excel desktop also has this feature. Turn on beta preview features on your excel 365, to use exciting new features by microsoft, including this one. Link to the excel file: 1drv.ms/x/s!Aow1k21mhHPGa1lnT0GRzC1TXgc?e=RDxvVN