Learn Excel VLOOKUP function to display data from multiple reports

Поділитися
Вставка
  • Опубліковано 12 лип 2024
  • Excel's VLOOKUP function is valuable when you export reports from, for example, Microsoft Intune in CSV format.
    Often, you need to combine data from other systems, and then VLOOKUP comes in and saves the day :)
    In this video, we show an example of a Microsoft Intune report data gets added to another report with the help of VLOOKUP.
    You don't need any previous experience with Excel functions/formulas; we go through the steps.
    Timeline
    00:00:00 Intro
    00:00:37 Scenario
    00:01:15 Export to CSV from Intune
    00:02:34 Work with the data in Excel
    00:03:58 VLOOKUP!
    00:10:00 Outro

КОМЕНТАРІ • 6