websites

Hi All, Can you please share some good websites which you've come across to learn Power Query? I'm finding a lot of excel websites, but they hardly cover Power Query. I currently own the following books: 1: M for Data Monkey and 2: Collect, Combine, and Collect, Combine, and Transform Data...

Hello everyone. Is is possible to make macro that can go down list of websites on excel file in Column A and determine if website has a blog and then in Column B script will write Yes or No ?

Hello! I have data in three columns: A,B,C and each columns has several rows with numbers. I want to return all the A numbers that match: B= 4 or 3 AND C = 5 Any idea? I have been browsing through several websites but most at horrible in explaining bit by bit the formulas. Thanks!

I am looking for sample statistical data for a school project for creating a 3D Map using Excel's 2016 feature. I have research multiple websites, for example, crime in 2018 in the US. To create the 3D Map it requires the state, or country in the data in order to map it. Can you recommend...

Hi Guys, I need help. I want to use Web Query in my Excel Sheet to show the Gross Sales of the movies that I am looking for. Information about the movies are in columns A and B. Column A contains the title, column B has the year when the movie was released. Column C to E will displayed the...

Hi all, I have a list of websites in Excel, in column A1:A1100. I would like a macro to find the email addresses on these websites, copy them, and paste them into B1:B1100. Is it possible? Your help would be highly appreciated.

hey guys i need to convert some scanned pdf files to excel. These are complex file containing tables and whatnot so they can't be converted with these simple online websites. It would be a big help if Anyone could point me to right direction

HI, I have been searching the internet for help, but have been unable to find any. I am looking to automate copying information from an excel worksheet into an existing sharepoint list. is this possible? if yes does any one have any instructions or links to websites that provide any...

Hello Everyone! I have built a vehicle sales commissions & vehicle Inventory File on excel. I'm wondering if their is a website that is available to import ALL vehicle info. that I then can use a Index & Match formula by using the vehicle vin. to access ALL the other vehicle information. Does...

Hi! I would like to extract contact information (such as company name, address and city) from multiple websites into an excel sheet. :confused: Can anyone help me do that? Or maybe recommend a software that can do that for me? Thank you!