Link web based data into Microsoft Excel

This video explains how to link web based data into Microsoft Excel.  The tutorial demonstrates how to link to a web based data using the Data tab.  The tutor then cleans the data with the Power Query Editor.  The final part of the video is to create a vlookup to extract one line of information at a time.  Feature used are : Power Query Editior, Get data, and vlookup.

If you want to support me, check this out: Patreon: itseasy

Most popular video at the moment: Power Pivot How to create Relationships using Pow...
Play list for this video: How to create basic macros in Microso...

#itseasytraining
#webdata
#excelcourse

Classroom based courses can be arranged at https://www.itseasy.co.uk/

Courses are available through Microsoft Teams, Online and Face to face in the UK

Online courses at https://itseasytraining.teachable.com/

Udemy Courses https://www.udemy.com/user/stephen-sa...

Training Guide Books

Excel for New Managers
https://www.amazon.co.uk/Excel-New-Ma...

Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Pr...

Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Vi...

Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics  https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv

• #howto_style
• #itseasytraining1st
• #link_web_based_data_into_microsoft_excel
• #how_to_link_web_based_data_into_microsoft_excel
• #how_to_link_to_a_web_based_data
• #create_a_vlookup_to_extract_one_line_of_information
• #how_to_clean_data_in_power_query
• #how_to_link_to_external_data_in_excel
• #get_external_data_in_excel
• #use_vlookup_to_get_data
• #link_to_an_external_source_in_excel
• #microsoft_excel_data_links
• #microsoft_excel_web_links
• #linking_to_the_web
• #edit_web_based_data
• #website_links_in_excel