Expert excel macropráce

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

I need a professional who can help me remove 10 spam listings from Google Maps. Your main aim should be to ensure a clean, accurate and effective Google Maps experience for users. Requirements: - Ability to efficiently identify listings as spam based on incorrect information, fake reviews and breaking of guidelines. - Experience in Google Maps edits and removals. - Strong attention to detail to ensure spam listings are effectively identified and removed. - Clear and concise communication skills. Additional Information: - You will be provided with a list of the spam listings. - We will expect the listings to be removed permanently and efficiently, without any negative repercussions to our standing on Google Maps. Please only apply if you have a strong background in Google Maps editin...

I'm in need of a schema markup expert with a high level of proficiency to implement necessary markup for my water treatment business - uswater. The project involves targeting approximately 60-70 cities for 5 different water treatment services. The website I'm working on is built on WordPress. Key Details: - I require schema markup for 5 different water treatment services, namely water filtration, water softening, water purification, legionella testing & management. - The focus is on 60-70 cities, although the range may widen based on the most cost-effective approach. Ideal Skills & Experience: - Proficiency in implementing schema markup, particularly for local SEO purposes. - Extensive experience with WordPress, as the website is built on this platform. - A deep ...

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

I'm in urgent need of a seasoned fundraiser to help raise $100,000 for a non-profit organization. Your assistance will be invaluable in helping us reach our goal. Key Responsibilities: - Crowdfunding Campaign: You'll be in charge of creating and managing an online crowdfunding campaign. This will involve setting up the campaign, engaging with potential donors, and ensuring that the campaign stays on track. - Grant Writing: You should also have a proven track record in grant writing. You will be responsible for identifying suitable grant opportunities, crafting compelling proposals, and submitting them within deadlines. Ideal Skills and Experience: - Extensive experience in both online crowdfunding and grant writing, preferably within the non-profit sector. - Strong communicatio...

I'm searching for a skilled writer with open water and pool expertise to create authoritative blogs focused on the sport and its link to wellness. Your role will involve crafting engaging content that provides our swimming network with valuable insights and advice on all things swimming. The chosen candidate will have a specific focus on: - Techniques and skills - Safety tips - Equipment reviews - Open water swimming - Swimming tourism - Pool coaching - Swimming community wellness - Detailed understanding of pool strokes, open water, and marathon swimming - Write engaging, informative blogs on all aspects of swimming (mostly related to our Swimming Adventures) - Ensure content accuracy - Engage with swimmers by addressing common concerns and questions - Their proven swimming backg...

Hello, I need a developer with a lot of experience in JavaSCRIPT EXPERT, Python and Socketweb - with the ability to create and solve problems with easy understanding of codes The rest of the details will be given to the correct developer

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

I'm seeking a skilled and experienced SEO expert to help me achieve my goal of increasing the traffic to my website, with a focus on national customers. Key Responsibilities: - Analyze our existing SEO strategies and suggest improvements to increase organic traffic. - Optimize our website's content and structure for search engines. - Implement on-page and off-page SEO techniques to enhance the site's visibility. - Use SEO tools to track the progress of our SEO strategies. - Provide regular reports on the performance of our SEO efforts. The ideal candidate should have: - Proven experience in successfully boosting website traffic. - A deep understanding of SEO techniques and best practices. - Strong analytical skills for data-driven decision-making. - Excellent commu...

Hello, I need a developer with a lot of experience in Java, Python and Socketweb - with the ability to create and solve problems with easy understanding of codes The rest of the details will be given to the correct developer

...is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Mac...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

...banner disclosure, and misconfigured CORS. Requirements: - Identify and rectify improper error handling, ensuring that user-friendly error messages are displayed and errors are logged for debugging purposes. - Address server banner disclosure, to enhance the security of the application. - Modify CORS configuration to prevent misconfigurations and enhance security measures. I am looking for an expert who is well-versed in AWS, particularly in working with applications. The ideal freelancer for this job should have: - A thorough understanding of AWS services and its integration with Next.js. - Proficiency in addressing security vulnerabilities, in particular server banner disclosure and CORS misconfiguration. - Excellent troubleshooting skills, to quickly identify and rectify...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

Only candidates from bangladesh are required. We are looking for a guy who knows below all things with respect to Shopify drop shipping -)Product sourcing -)Product hunting -)staff and ads -)Drop shipping

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I'm looking for a proficient Matlab programmer with expertise in chemical engineering simulations to develop a comprehensive model for a Plug Flow Reactor (PFR). My goal is to analyze the conversion of reactants, product yield, and overall reactor efficiency, focusing on temperature and pressure as critical parameters. Key Project Deliverables: - Establish the PFR model in Matlab. - Integrate temperature and pressure variables using 2-D pseudo homogeneous model. - Calculate reactant conversion, yield, and efficiency. Ideal Candidate: - Proficient in Matlab coding. - Solid background in chemical engineering, specifically reactor design and modeling. - Understanding of PFR kinetics and mass-energy balances. - Ability to interpret simulation results for optimization. I am eager to co...

Create an executable scraper in Python that can extract the SKU (product) list from the following Indonesian online grocery apps: - Astro - Sayurbox - Segari The scraper must be IP-block tolerant, meaning if the scraper gets blocked, execution can be continued from the point where the last row of data was successfully extracted. Scraper Functions Function: list_category_tree Input: competitor_name(astro | sayurbox | segari), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from google maps API), category ...

I am looking for a skilled individual to revise my R Easy Demand System. Although details weren't specified regarding the exact areas of the system that necessitate revision, the successful candidate will be expected to do a comprehensive examination of the system and propose areas of improvement. Moreover, they will then be responsible for implementing these changes. DELIVERABLES The job will consist of the following: 1. Revise the script to make sure it works, and the estimates are consistent with the Stata estimates (I have the estimates for comparison). 2. Add the script to an existing R package (). I have cloned that package at It will be updated to become easi2. The easi package currently uses 3sls for the estimation stage. The revise version should have an option to choose...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...

I'm looking for a skilled digital marketer who can help me with my social media marketing efforts, specifically on Facebook and Instagram. The primary goals are to increase our brand's presence and ultimately drive more leads and sales. Key Responsibilities: - Develop and execute a comprehensive social media strategy for my business - Create engaging content that resonates with our target audience - Manage and monitor our social media accounts on Facebook and Instagram - Increase our brand's visibility and reach on both platforms - Drive more leads and sales through the social media channels Ideal Candidate: - 3-5 years of proven experience in social media marketing, particularly on Facebook and Instagram - A keen understanding of how to increase brand awareness and genera...

Hi Freelancers, I need a Facebook expert who can find Bilingual people for jobs. You need to reach, search & post job within your network,. Please share following: 1. How many friends / followers you have in your network? 2. Do you have a page? 3. Please share your profile. Please note that no paid advertisement involve in this project. Please start your proposal with "FB Expert". Thank You.

We are seeking an experienced email marketing professional to join our growing real estate company. The ideal candidate will have a proven track record of executing successful email campaigns with extremely low bounce rates and high open/click-through rates. Key Responsibilities: - Develop and execu...industry - Expertise in using email marketing platforms and tools to maximize deliverability and engagement - Strong copywriting and content creation skills - Excellent analytical and data interpretation abilities - Ability to work independently and meet deadlines - Proven track record of achieving high open rates, low bounce rates, and strong conversions If you have the skills and experience to excel in this role, please contact us today. We look forward to hearing from qualified c...

I need someone proficient in C# to help create a Remote Administration Tool (RAT). This tool will primarily offer remote desktop access. A user-friendly graphical user interface (GUI) is a must, with a clear and clean design that's simple to navigate. It should be tailored specifically for a Windows operating system. Ideal Skills: - Strong background in C# - Experience in creating GUI - Expertise in remote desktop functionalities Experience: - Developing RATs - Working with Windows OS - Designing intuitive GUIs

I need an apk security expert I hope there are no vulnerabilities in the database in my apk. Other people keep trying to hack my database

I am in need of a skilled Linux and Bash Script expert to help me with my current project. Although I haven't specified exact tasks or goals, I am seeking assistance in the following areas: - Linux installation and configuration - Bash scripting and automation - Troubleshooting and debugging I expect the successful freelancer to have a deep understanding of Linux systems and be proficient in Bash scripting. Your past work and experience in similar projects will be valuable. Please detail how you can assist and your approach in your application. Thank you.

We're dividing assets into fractions. We have .sol files related to smart contracts (ERC20 on Ethereum with a bridge on Gnosis). We're in search of an expert who can review these files and determine their functionality for deployment. Should this collaboration proceed smoothly, we're open to establishing a long-term partnership for technical support.

I'm seeking a finance specialist with experience in recapitalization efforts. Key tasks for this project include: - **Valuation Analysis**: I need someone who can perform a thorough valuation analysis based on the financial data available. - **Debt-to-Equity Ratio Calculation**: The ideal candidate will be able to calculate the current debt-to-equity ratio and provide recommendations for improvement. - **Return on Investment Analysis**: A comprehensive ROI analysis is necessary to evaluate the potential outcome of the recapitalization effort. I have all the relevant financial data in hand, so the focus will be on the calculations and recommendations based on this data. The primary goal of this recapitalization effort is to restructure the company. The perfect candidate for this pr...

I need a Zendesk expert who can set up our existing Salesforce system to work in perfect harmony with Zendesk, ensuring that all customer service tools and features operate seamlessly for our insurance agency. Key Requirements: - I already have a Salesforce system in place. Your task will be to fully integrate Zendesk's features for customer service in this system. - I require an advanced level of customization for the Zendesk integration. This includes setting up comprehensive features like analytics and reporting. - The integration should cover specific Salesforce features like: - Customer data and records - Case management - Utilization of Zendesk's AI Your past experience with a similar project, particularly in the insurance industry, is essential. Please prov...

Here is a brief of my requirement. What I want is when I am creating a collection page, the way I can actually sort the product is either through best selling item, product title, highest price or lowest price, new best oldest and manually. Now we have thousands of product in a collection at the moment hundreds of them. What we want to do is instead of the regular product filter which is available on Shopify, we want to have a custom one with the logic on the basis of either row as or basis on the conversion rate. So we can actually connect this with the Google sheet or we can actually have an identifier in terms of how the product would change their, how would product would look on the collection page in terms of where they are on the collection page basis of an identifier.

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

I'm seeking a talented freelancer who's skilled with Adobe Illustrator and has a proven track record of editing existing graphics. Your primary task will be enhancing my marketing materials and social media content and making sure they look professional and polished. Key responsibilities: - Editing existing graphics and enhancing design details - Ensuring the final graphics are high-quality and clean - Familiarity with Adobe Illustrator is a must The project involves reviewing and improving the design elements of the existing materials, which are primarily marketing and social media graphics. Ideal skills and experience: - Excellent command of Adobe Illustrator - Proven experience in graphic design and editing - Strong attention to detail - Ability to follow guidelines and i...

I'm looking for a talented marketing and sales professional to help promote my business and drive sales. Your experience is key here. Key requirements: - Develop and implement a solid marketing strategy - Drive sales through effective tactics - Monitor and analyze performance data Please include your past experience and successes in similar roles. Your detailed project proposals will be highly regarded.

I am seeking an expert with proficient skills and experience in Artificial Intelligence, Machine Learning, and Data Analysis for the purpose of publishing my research paper in the Expert Systems with Applications Journal. My work utilizes Deep Learning to address Suspicious Action Detection from Surveillance Videos. The ideal candidate should have superb understanding of Behavior Recognition, a technique pivotal to my paper. In this task, the set objectives include: * Editing and proofreading the paper meticulously * Ensuring the subject matter is communicated clearly and effectively * Submitting the paper to the Expert Systems with Applications Journal * Ensuring all the Journal's publishing guidelines are followed diligently Applicants are invited to submit ...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

I require a professional in SEO to enhance my website's visibility and overall performance. The main focus will be on on-page and off-page optimization, as well as conducting comprehensive keyword research and analysis. Key responsibilities: - Implement on-page and off-page optimization strategies to improve search engine rankings and increase website traffic. - Conduct in-depth keyword research to identify high-traffic, relevant terms. - Analyze and refine existing content to align with SEO best practices and maximize visibility. The urgency of the project requires the selected freelancer to be highly experienced, proactive, and capable of delivering results within a short timeframe. Previous success in boosting online sales through SEO is a definite advantage.

I'm in need of a skilled UIZARD expert, preferably based in Mumbai, for developing a mobile application. My aim is to have this project completed within a week. Key features for this app include: - User login/authentication - In-app purchases - Push notifications The app itself will be a sophisticated blend of Airbnb and Facebook, with an extensive set of features. Therefore, I'm seeking a professional with a robust understanding of these two platforms, and the capacity to deliver a high-quality, user-friendly final product on both iOS and Android & a web-app. A potential candidate would be someone with: - Prior experience in developing complex mobile apps - Proficiency in UIZARD - A strong background in UI/UX design - A track record of meeting tight deadlines - Pro...

...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and f...

Must understand I require an expert in financial statement analysis and forecasting. The project involves predicting financial trends over a three-year period. I only have cash flow statements available for analysis purposes. Key Responsibilities: - Analyzing cash flow statements - Preparing a three-year financial forecast based on the analysis - Highlight expected trends and give insights Ideal Skills: - Proven experience in financial statement analysis - Proficiency in financial forecasting - Expert ability to analyze and interpret cash flow statements - Keen attention to detail and accuracy - Excellent analytical, computational, and mathematical abilities.

I'm seeking a knowledgeable professional proficient in Azure Databricks, Azure Data Factory, and ADLS to assist with data manipulation and transformation tasks. In specific, you will be working with semi-structured data, particularly JSON and XML formats. Key tasks will include: - Filtering and cleaning of data - Converting the cleaned data into different formats Having previous experience with semi-structured data and being familiar with machine learning and AI integration will be highly regarded. I'm looking for an individual who can ensure efficiency and accuracy throughout the process. Let's make data work for us!

Brief for Digital Marketing Agency Services Company Overview: We are a small, family-run training provider based in the UK, specializing in professional development and educational services. Our goal is to double our turnover in the next 12 months. Learn more about us at https://debrastevens.co.uk. Project Objective: We are seeking a digital marketing agency that can partner with us on an ongoing basis to enhance our online presence and drive significant growth. The agency should have a strong background in SEO, PPC, content creation, and overall digital marketing strategy tailored to the training and development sector. Scope of Services Required: • SEO and Backlinking: Improve our search engine rankings and online visibility through effective SEO practices and quality backlink...

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

we need a Web Scraping expert for a long term. will give you 1 site a day. per site $15. It's all about scraping product data like product title, description, image link etc.

I'm looking for an experienced electrical engineer who specializes in power systems and is acquainted with local power regulations. Your task will be to: - Design a new power system in accordance with my specifications - Implement the said system while ensuring it adheres to local power regulations The ideal candidate must be familiar with practical applications of local power laws and must have prior experience in designing and implementing power systems. Your ability to ask the right questions before beginning the design should enable you to anticipate and mitigate potential regulatory hurdles, thereby reducing the risk of non-compliance. Your experience, precision, and regulatory knowledge will ensure the smooth completion of this crucial task.

I need someone to create social media profile on FB and Insta, manage the social media handles, generate leads for business, run webinars. One part is managing social media handles. Another part is create leads. The target audience are small & medium scale businessmen who are looking for branding solutions, business consultancy, brand consultancy. Businessmen who wants to make their brands big and noticeable which will bring growth on business. More details: Which digital marketing channels are you currently using? Social media, Search engine optimization (SEO) What are your primary marketing goals? Generate leads, Drive website traffic Who is your target audience for your digital marketing efforts? B2B (business to business)

Need someone for long term , ant software is fine

I need a marine expert to guide me through understanding the wind impact on a plastic barrier in a saltwater environment. The deliverable of this project is a proposal for the appropriate anchoring solution for this barrier. Key Requirements: - Understanding of wind impact on marine structures - Familiarity with anchoring solutions for marine barriers - Experience with plastic materials in saltwater environments Ideal skills and experience: - Marine engineering or a related field - Experience in working with barriers or similar marine structures - Familiarity with the behavior of plastic materials in saltwater - Previous projects involving wind impact assessment Your proposals should outline your experience in similar projects and how you would approach this task.