3.How do you extract data from Web pages with Power Query, Add data to a power query Excel Bangla
Please download working file from below link
https://drive.google.com/file/d/14LoY...
You can extract data from web pages using Power Query in Microsoft Excel. Here's how:
Go to the "Data" tab in the Excel ribbon, and click the "New Source" button in the "Get & Transform Data" group.
In the "Get Data" dialog box, select the "Web" option.
In the "From Web" dialog box, enter the URL of the web page that contains the data you want to extract, and click the "Load" button.
In the Power Query Editor, select the tables or data you want to extract from the web page, and click the "Load" button.
Your data will now be extracted and loaded into a new worksheet in the current Excel workbook. You can use the Power Query Editor to perform additional transformations on the extracted data, such as filtering, sorting, and merging columns.
Learn About Below Topic Content In This Channel
01) Microsoft Visual Basic ( Excel VBA, Macro)
02) Microsoft Excel Tutorial In Bangla
03) Microsoft Word Tutorial In Bangla
04) Microsoft Powerpoint Tutorial In Bangla
05) Computer Tips And Tricks In Bangla
COMMUNICATE WITH HASAN ACADEMY
[email protected]
#HasanAcademy #Power_Query #Power_Query_Bangla
Facebook page
/ hasanacademybanglatutorial
Subscribe link : / @hasanacademy779
Facebook group link : / 282270382269650
Facebook page link : / hasanacademybanglatutorial
Most popular video Link :
• Excel VBA Bangla Tutorial 48 : Data Entry ... • Excel VBA Bangla Tutorial 50 : Create Add ... • Excel tutorial Bangla 24 : Top 10 Used For... • Excel VBA Bangla Tutorial 54: Add- Employe... • Introduction to Pivot Tables-Charts-and-Da... • Excel VBA Bangla Tutorial 49 : Invoice | B...
Most of the people is think about that how I will learn .But they didn't get any idea & trustworthy source. Don't hesitated Hasan Academy with you. You will learn from here, Excel, Excel Chart, Pivot Table, Vlookup, Formula function