Excel macro pull data internetงาน

I need a data expert who can perform inferential analysis on a dataset that is less than 1000 rows and columns. This task requires absolute proficiency in Excel, including functions and formulas associated with inferential statistics. Your ability to draw meaningful insights from raw data is essential. Skills Required: - Excel proficiency - Familiarity with inferential analysis - Ability to handle small to medium-sized datasets Experience preferred: - Previous experience in Excel-based inferential data analysis - Proven track record of data interpretation and insights extraction

I am on a quest for a proficient C# developer to finish up my partially built app. Key Areas for Implementation: - User Interface Design: This should reflect a clean, minimalist aesthetic without compromising functionality. - Charts & ...charts and reports functionality. - Strong background in software testing. A proven track record detailing similar completed tasks will be highly valuable. I look forward to a seamless and successful collaboration. I'd like to think that the app is simple. It's basically a form that a user fills in, I've started that part, and the biggest thing now is that I need to complete the admin panel to pull that form but I fear ive been hit with developer fatigue. So looking for some assistance in completing it. We can speak and a...

...developer with expertise in AppSheet, Excel, and ERP systems. Your task will be multifaceted, involving various aspects such as: - Data analysis and visualization - Spreadsheet automation - Developing an AppSheet app designed for ERP, focusing on billing, data collection, and data management The main functionalities I am looking for are: - Ability to generate and track invoices - Data entry and validation capabilities - Incorporation of Google Maps API - Budgeting features - Ability to export data to Excel A strong understanding of ERP systems, proficiency in AppSheet, and advanced Excel skills are essential to this role. Experience with Google Maps API is a significant advantage. You should be able to understand the essen...

...in need of an advanced Excel spreadsheet that will help track and output several key performance indicators (KPIs) on a monthly basis. The KPI dashboard should integrate the following parameters: - Sales pipeline - Revenue - Over $2,000,000 Per month - Overheads Average 3.75% of revenue for month - Gross profit 12 % - Projects on time >90 % - Defects closed <20 working days - Customer Satisfaction - Employee Productivity - Health and Safety The desired freelancer should have: - Proficient skills in Excel including pivot tables, charts, and formulas - Experience in creating KPI dashboards - Strong understanding of business metrics Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of interpretation of the ...

I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essenti...

We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!

I need a professional CAD expert to design a unique wooden trash receptacle. Attached is a simple sketch with the dimensions of each part. I only want to illustrate the bottom of the trash receptacle, NOT the white round top or the curved piece on top of the round white top. Just the base of it. Material is all Plywood 3/4" thick (curved exterior, toe kick, trash bin pull out door). I also need the side elevation done as well. I attached what the final product will look like when it's built, so you get an idea. But also included my rough sketch with the dimensions needed to illustrate in CAD. DESIGN REQUIREMENTS: - The trash receptacle will be made out of painted plywood. IDEAL CANDIDATE: - Must have experience designing furniture with CAD. - Knowledge of differ...

I am in need of an Excel specialist who can handle a large dataset of over 51,000 records. The data centers around employee contributions to political candidates. Specifically, I require detailed analysis on: - Contribution patterns - Candidate preferences - Employee demographics As an Excel expert, you should be proficient in working with pivot tables and be able to identify trends within large sets of data. Your experience managing, analyzing, and interpreting datasets should be well demonstrated. In addition, there is a particular interest in providing a thorough analysis of contributions based on political parties. This will help to understand better the political leanings within the dataset. To apply, please highlight your relevant experience. I look fo...

I urgently need proficient help with excel. The tasks to handle include but not limited to; - Data entry. - Data analysis using relevant tools. - Leverage advanced excel formulas and functions to streamline data processing. The data to handle resides within 1-5 sheets and contains both numeric and categorical data. Ideal skills for the job include; - Advanced proficiency in Excel. - Deep knowledge of data analysis methodologies. - Quick data entry skills. - Understanding of Excel functions and formulas. Experience in processing both numeric and categorical data on Excel is crucial.

I'm seeking a detail-oriented freelancer with strong skills in text data entry, Excel, and who is comfortable working with less than 500 pages of data. Key Requirements: - Proficiency in text data entry - Strong familiarity with Excel - Able to handle less than 500 pages of data The ideal freelancer should efficiently turn raw data into an organized Excel spreadsheet. Accuracy is vital in this job, as any mistake could lead to incorrect data analysis. Please provide evidence of your past experience in text data entry and working with Excel.

As a professional involved in the field of data analytics, I'm in need of an expert to develop advanced lab exercise materials for Excel, with a particular focus on Excel Macros, Array formulae, forecasting, countif, if statements, and all LOOKUPs. All exercises should come from dataset or data files KEY REQUIREMENTS: - The labs should cover 10 advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros an...

I'm in need of an expertly designed Excel spreadsheet that will serve as a dynamic sales reporting template. This tool will play a significant role in tracking and analyzing data related to various aspects of sales. The successful candidate in this role will incorporate tracking capabilities for variables such as: - Product sales - Revenue by customer - Customer % of revenue Furthermore, the spreadsheet should provide robust reporting on seasonality, current month vs prior year, and fiscal year to date (FYTD) vs the prior year. This comparative analysis is crucial in understanding trends and informing strategic decision making. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating dynamic reporting tools - Understanding of sales data...

This project entails creating a Power BI report that is linked to Excel spreadsheets for trend analysis purposes. The main user of this report will be the sales team. I'm seeking a professional with: - Expertise in Power BI and trend analysis - Proficiency in handling and linking Excel spreadsheets to Power BI - Familiarity with sales data and crafting useful reports for sales teams. Your primary objective will be to create a functional, insightful Power BI report, providing our sales team with meaningful trend analysis based on our historical data stored in Excel spreadsheets.

For Excel sheet data typing, you'd be looking for someone proficient in data entry and manipulation, preferably with experience in Excel. Here are the ideal skills and experience: Proficiency in Microsoft Excel Accurate and fast typing skills Attention to detail to ensure accurate data entry Familiarity with common data manipulation tasks in Excel such as formatting, sorting, and filtering Ability to handle large amounts of data efficiently Knowledge of basic formulas and functions in Excel for data analysis and manipulation Experience in working with different types of data formats and structures Strong organizational skills to manage and organize data effectively Ability to troubleshoot and r...

Need to upgrade my existing excel macro, very simple project

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

Unify TXT files into Excel. (This data is good) This is a data merge project. Merge data from 3 txt files into excel. This is NOT a simply copy paste. The data needs merged. The data from 2 of the files will become columns of data in the 'master file' (see below) Download 2 files from here: Download 1 file from here: Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

...need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid understanding of finance principles is necessary. Experience with develo...

We're in need of a proficient programmer proficient with Blazor C#. Our project currently has few runtime error that needs a fix. Specifics about when and where this error occurs will be provided after we've started. There are only two pages that needs your fixing. 1. location page Show Message that data has been edited, saved or delete. When user clicks on specific item data to be loaded in textbox Search is not working Export data to excel with formatting 2. Login page Issue with adding new user (password not getting captured) Add roles and claims (department) When user click on user form the table it should Edit user details including email address Only admin user to have right to Add/edit this page. Other user can only view the details. Search i...

I urgently require an adept designer with proficiency in graphic design, logo creation, and branding. Mastery in Adobe Illustrator will be beneficial to the successful completion of the project. Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organizat...Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organization. * Incorporate engaging animation effects. * Execute graphic design tasks including logo design and branding. Candidates with keen attention to detail, a commitment to meeting tight deadlines, and a background in corporate or formal PowerPoint presentation design will excel in this role. Immediate ability to start on the project is a ...

I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term collaboration.

I need a customized Google Sheets add-on that connects with the Facebook API to retrieve specific advertising data. Specifically, I'm interested in: - Retrieving leads, CPL, budget, total spend, and ad names The aim of the project is to automate the process of fetching these data, reducing manual efforts and time for users. Ideal freelancer should have: - Profound knowledge of Google Sheets Add-ons - Experience with Facebook's API - Understanding of Facebook Advertising metrics - Ability to deliver a clear, easy-to-use interface within Google Sheets. Success for this project means providing a tool that when installed, gives users the capability to pull the required fields from the Facebook API to Google Sheets seamlessly and accurately.

This job requires programming experience to create and design an app based on the attached PowerPoint where I have detailed each page of the app. The data needed for the app will be supplied in an Excel file. The bid is to create the app for both iPhone and Android. App programming and graphic design experience is mandatory for this project and will require more than a basic knowledge of app creation. The rough project should be completed in 1-2 months. Please review the PowerPoint as it has very detailed information and don't hesitate to ask any questions.

In need of a frontend developer profic...commitment and dedication of developers. We have the demo deployed via Vercel for testing live and any code committed will be via Pull Requests will be reviewed it for quality before merging. Key Duties: - Build Web/Mobile friendly pages - Home Page, Signin Signup, checkout. The home page contains a data table which uses SQL for backend queries to populate and interact. - Ensure compatibility with various browser types. Ideal Skills: - Strong proficiency in React, NextJS, and TailWind CSS. - Experience with Flask code. - We use Axiom library for API calls. Knowing it is a plus. - Experience with data table integration and SQL. - Familiarity with backend calls and data population. - Deep understanding of website optimiz...

macro based excel project with auto copy data and paste in chrome through selinium

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

Your report/dashboard should answer the following questions posed by the sales director of the client: 1. What is the total number of orders catered by the firm? There should be a date filter in the dashboard. 2. What is the revenue earned by the firm? 3. What is the total discounted value (base price - check out price) * number of orders? 4. What is the overall discount %? 5. What are the top 5 selling categories? 6. Does the operational area of the store influence number of orders? 7. Are emails & product features on the homepage an effective mode of promotion? 8. What will be the next 5 weeks forecasted weekly quantity sold for each center, city, and meal category (you may use a simple trend-based forecasting method)? You need to submit your PBIX file work as a zip.

I need a thorough data collection process to collect Ceramic & Porcelain Tiles Importers within Vietnam. This project requires: - Collection of contact information and company details. - The data needs to be organized in an Excel spreadsheet. - Include data for all importers, regardless of volume or frequency of importing. Ideal skills and experience for the job: - Strong data scraping and crawling capabilities. - Proven experience with swift and accurate data entry. - Proficiency in Excel.

I'm in need of a Python programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requir...programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requirements: - Extensive experience in Python and specifically Python libraries for web scraping. - Should deliver the extracted text content in an Excel file. Ideal Skills: - Experience in PDF scraping, especially text-based. - Strong Python programming skills. - Excel file formatting. This will involve working with mostly text-based PDFs and programming a Python script to scrape the text content, and subsequently placing that data into an Excel file. Experience with similar projects will be highly advantageous. The ...

Is a task require basic Excel skills with four tasks in total need it in 5-6 hours

I require a qualified specialist to generate sales leads for my green fertiliser project targeted at farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website codi...farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website coding in PHP - Creating engaging and informative web content and blogs - Using LinkedIn Sales Navigator for lead generation Your understanding of the farming world will be a great asset for this project. Delivery of the sales leads should be through an Excel spreadsheet, Emails, and my CRM platform. Past experience in a similar role, particularly within the agricultural industry, will be highly...

I am seeking a talented video creator to craft a 30-second video showcasing my iOS watch browser app. The video should exude an energetic and dynamic mood, creating excitement around the user experience. Key Aspects: - Illustrate a woman seamlessly browsing the internet using the app on her Apple Watch. - Highlight the incredible browsing experience the app provides. - Showcase how easy it is to access bookmarks. Ideal Skill Set & Experience: - Proficiency in creating engaging tech-focused videos. - Experience creating videos for Google Ads. - Have a sound understanding of iOS applications and Apple Watch. - Ability to convey complex tech features in a simple, appealing manner.

I'm in need of an expert who can optimize my PHP website for better performance. Currently, a he...an expert who can optimize my PHP website for better performance. Currently, a heavy SQL query runs every time a user visits the site, retrieving data about the pages they have visited. This is considerably slowing down my site. I would like the query to be cached into the database and generated every 1 hour through a cron job url. Afterward, the site should pull data from this cached database. Ideal Skills: - Strong understanding and experience with PHP and SQL. - Experience with implementing cron jobs url. - Knowledge of caching strategies, especially within a database. Your main goal will be to improve website performance and ensure user data is accurate...

I am looking for a developer to create a multilingual WhatsApp chatbot. The chatbot must be built on Twilio, and should be capable of answering user queries promptly and effectively in both Arabic and English. Skills and experience needed for this project: - Proficiency in chatbot development, specifically on the Twilio platform - Experience in designing chatbots that excel in query resolution - Strong command of both Arabic and English in a development context Please make sure to highlight any similar projects you've completed in your proposal, with specific details on chatbot functionality and multilingual support.

...balancing router in my home office. -The entire setup revolves around a Wired internet connection, an optimal choice for high-speed internet access. -We have TP Link ER605 Load Balancing Router We just want to set up in a way we can use its full potential - Additionally, the network should support 11-20 devices at any given time, accommodating all my office’s device needs. - These devices will primarily be used for video conferencing. The network should, therefore be able to seamlessly handle multiple simultaneous video conferences without any lag or interruptions. Ideal candidates for this project should showcase: - Significant experience with load balancing router setup. - Familiarity with the Wired internet network. - Expertise in network setups spec...

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completi...

I'm looking for an experienced Power BI professi...Implement Interactive Dashboards: With emphasis on user engagement, the dashboards should be interactive and user-friendly. - Data Visualization: The dashboard should visually represent the data from Excel spreadsheets in a clean, easy-to-understand format. - Interactive Charts & Drill-Down features: I want a dashboard where users can interact with charts and explore detailed views of our data. Ideal Skills: - Experience in Power BI - Proficient in data visualization - Deft with interactive chart development, and drill-down feature set up Your task is to guide me on how to create this, using an existing example as a guide. Your expertise in Power BI and data visualization would ...

I require an efficient web developer proficient in creating private proxies. The objective is to navigate website access blocked specifically in North Africa. Requirements: - Generate more than 50 private proxies - Ensure proxies allow secure and anonymous web scraping - Preferably have experience with similar projects Ideal skills include familiarity with ISP, proxy generation, internet security, and proficient in languages such as Python or Java.

i have excel framework that contains multiple user inputs the convert the outputs to a graphs and charts i need to convert the excel sheet to a website.

I am in need of an Excel expert who can successfully create rows in an Excel sheet with a dropdown list that allows multiple choices. These choices should be exclusively filled with text data. Key project tasks include: - The text data should be extracted from pre-existing Excel sheets that I will provide. - Any row that utilizes these dropdown lists must be color-coded differently, with the format contingent on differing data values. Ideal skills for this job would primarily include advanced knowledge of Excel or a similar spreadsheet software. Familiarity with text data extraction and color-based conditional formatting would also be of advantage. Previous experience managing similar tasks and a keen eye for detail would ...

I am in need of an experienced Microsoft Excel expert who can create a specialized personnel cost budget template. This template should include: - Automatic calculations. - Cost categories for Salaries and Wages, along with Benefits and Bonuses. Experience in financial modeling and budgeting would be ideal to ensure accurate automatic calculations are set up. You will be creating this from scratch, so creativity and attention to detail are also required. Please provide samples of similar Excel projects you've completed in the past. Adequate knowledge of personnel finance management is a plus.

Project Overview: We're building a web application focused on data aggregation, analysis, and dynamic presentation. This platform will pull data from various sources based on user inputs, analyze it for insights, and update content regularly. Core Functionalities: Data Aggregation: Collect data using external APIs based on user-defined criteria. Sentiment Analysis: Process and categorize the data using sentiment analysis. Content Presentation: Display insights through an intuitive interface, with regular updates based on scheduling or user request. Technical Requirements: Experience with API integration for data fetching. Knowledge of data processing methods, specifically sentiment analysis. Backend development skills for handli...

I am in need of data entry and web scraping experts who can assist me with a project. The tasks that need to be completed include both data entry into a spreadsheet and web scraping for specific information. The final data should be delivered in Excel format. I have a specific deadline for the project and it needs to be completed within a week. Ideal skills and experience for this job include: - Proficiency in data entry and web scraping techniques - Experience with spreadsheet software such as Excel - Knowledge of web scraping tools and techniques - Attention to detail and accuracy in data entry - Ability to meet tight deadlines and work efficiently If you have the necessary skills and experience, please submit your proposal.

I'm in need of an Excel programmer who is proficient with VBA. The task involves creating a VBA scroll bar that changes values within a specific cell. The cell's contents should be adjusted in increments of 0.01 through the scrollbar's activities. - Proficiency in Excel and VBA is a must. - An understanding of user interface designs with Excel is ideal. - The candidate should be capable of testing and debugging functions within Excel. Your main goal is to create a VBA scroll bar that can accurately manipulate cell contents. Your work will be deemed successful when the scrolling alters the cell value as per the increment specified. Reach out if you have the necessary skills and can get this job done.

KEY FEATURES: - Business name is "nexus" - The logo should be modern and minimalistic. - No particular colour scheme - Convey theme of wifi/camers/networking/internet The business is for installing network cable and providing modern communication solutions. Wifi, and CCTV cameras, mainly targeting residential.

I am looking for an Excel expert who can assist with implementing logical formulas and calculating percentage-based results for different strategies. There are three key strategies that require your attention: Strategy A, Strategy B, and Strategy C. Your tasks would include the following: - Implementing logical operations to enhance data organization. - Entering information pertinent to each strategy. - Calculating and displaying the percentage of each strategy. Ideally, you should have extensive experience in Excel calculations and logical operations. Proficiency in data analysis and reporting is also a plus. I am in need of an individual who can accurately interpret and implement my strategy-focused approach in Excel. Your output will provide a foun...

Core Functionalities 2.1 User Authentication and Manage...tracked. Task Removal: Admin can remove tasks from the system at any time. 2.3 Tracking and Rewards Visit Tracker: A tracker will be placed on external websites to track user visits and send data to the CRM system. Earnings Management: Specific earnings will be assigned to users upon task completion. Withdrawal Requests: Users can request to withdraw their earned amount once it exceeds a predetermined minimum balance. 2.4 Financial Reporting and Admin Panel Earnings Reports: Admin can view total earnings, user-wise earnings, and date-wise earnings. Export to Excel: Admin can export financial reports to Excel. Admin Dashboard: Admin can use a central dashboard to manage all aspects of the CRM add more require...

I require the assistance of a developer skilled in React and Pyt... the ideal candidate would be someone well-versed in the fundamentals of SEO and web-based data gathering. Key requirements: - Develop an AI-powered backlink analysis tool using React and Python. - The tool should be able to automatically discover new link opportunities from blogs and websites. - Design the tool to indicate which links are most valuable for brand exposure and organic traffic boosting. Ideal skills: - Extensive experience in AI and machine learning. - Proficiency in React and Python. - A strength in creating data mining algorithms. - An understanding of SEO and backlink strategies. By creating a tool that excels in these areas, we will be able to leverage the power of internet res...

I'm in need of a seasoned software developer to work on a Laboratory Information System (LIS). Your task will encompass extracting lab test data from different lab/pathology machines. The developer should know how to write code in RS 232 and TCP/IP protocols etc . I am listing some companies here from where we have to pull data Agappe, Erba Ideal Candidate Should: - Have extensive software development experience - Ability to navigate and extract data from different lab/pathology machines Please include your applicable experience. Your familiarity with specific programming languages or any additional skills relevant to this project would be beneficial. This project demands someone with a keen attention to detail, so your proposal should reflect this.