Excel programmers for hire punët

6 excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver

This take is to take a list of URLS (as in the URLS spreadsheet attached) and create a Power Automate flow to extract the following from each URL: • Previous Close • Open • Bid • Ask • Day’s Range The output should be in a separate spreadsheet (‘output’). In the sample ‘output’ file attached, this shows the result for ‘MMM’. Other URLs will follow. I should be able to run the Power Automate workspace at any point to scan the URLS. The URLS may change (added or removed).

Hello I do sales for a tobacco company and I need to enter all my sales for January February March. I need three different Excel files. All it is is the name of the store the amount that I sold and the address.

...concreto necesitamos: • Automatizar la exportación de datos de facturas emitidas (y su estado, canal de entrada, consultor asignado) y gastos, y preparación de los mismos desde HOLDED. • Automatizar la exportación de datos (presupuestos lanzados y vendidos, potenciales clientes y comerciales asignados) y preparación de los mismos desde HUBSPOT. • Automatizar la cumplimentación Excel de RRHH mediante un Excel que nos pasa la gestoría cada mes, con todos los datos de las nóminas y costes laborables de cada trabajador. *****Importación e integración de todos datos y modelado de un cuadro de mando en Microsoft Power BI con las siguientes funcionalidades:  Facturación Mensual, anual,...

I'm seeking a freelancer with advanced Excel and Power Query proficiency to provide essential data extraction, transformation, cleaning, and combination services for an Excel Report. Qualified candidates must demonstrate: - Advanced understanding of Excel and Power Query - Experience in extracting data from diverse sources - Capability for cleaning and transforming data for optimal utility - Aptitude for combining data from various sheets effectively In your proposal, include details about your relevant experience. Your hands-on experience and proven record of similar projects will secure your success in this job.

Sample pincode - 743611,743329 I will provide all pin code of India in a excel. You have to fetch agents data and have to give me in a Excel Or google sheet. Total 19000 pincode. You have to write a script that can do it. Budget under INR2000

As a busy professional, I'm on the lookout for an Excel pro who can assist in organizing my dataset of less than 1,000 rows. The data is moderately complex, with multiple columns of various types. The ideal freelancer will: - Have experience with Data Entry and Organization. This includes swiftly inputting data and structuring it for optimal accessibility and productivity. - Possess Data Analysis and Reporting Skills. I'm keen on meaningful insights from the data and require straightforward, compelling reports. - Excel proficiency is a must, with strong attention to detail, and ability to handle moderate complexity data. By bringing your advanced Excel management and analysis skills, you'll be delivering order to chaos, and helping drive ...

More details: What specific information do you need to gather for each company? Company name, Contact name, Contact email; Contact phone number; Company website, Gender, Position, Email What information should successful freelancers include in their application? Past work How would you like the database to be organized? Name, Position, Gender, Company, URL, Email, Phone, Notes Project Objective: To create an organized and detailed database, which includes the following columns: Name, Position, Gender, Company, URL, Email, Phone, and notes. Requirements: 1)Research Skills: Ability to conduct thorough online research to find accurate contact information for HR representatives, recruiters, and hiring managers within the specified companies. 2)Attention to Detail: Ensure ...

See the attached File. Simple project here. If any of the words in column A, sheet 2 are in column D, Sheet 1, then delete the entire row (in Sheet 1) (Delete the entire row, not just the cell) No macros Likely conditional formatting, new rule is the best. This will be used on multiple files so it needs to be quickly applied. New words will be added to the list to filter for. The filter list can be added to each new file. No Macros Type :Sponge Bob" in your bid (to sort through the spammers) This should be a very low cost bid and delivered today.

I need an Excel expert who can craft 4 meaningful bar charts to visualize several health metrics. The foremost tasks required would include: - Visualizing perceived health data acquired from various sources namely, self-assessment questionnaires and participant interviews - Converting raw data of percentage changes in health into impactful insights using Excel It's pertinent that the freelancer has a good grasp of Excel and data visualization. A comprehensive understanding of health metrics would be appreciated, but not compulsory. Your role will aid in the better comprehension of health improvement or decline, ultimately guiding decision-making based on these observations.

I am looking for a skilled individual to create 4 bar charts in Excel for the purpose of showcasing percentage changes in perceived health over time. Key requirements: - Using perceived health data, generate 4 bar charts showing changes over time. Ideal Skills: - Proficiency in Excel - Understanding of data visualization - Ability to depict percentage changes in a clear and accessible manner. Please provide examples of your past work in your bid.

I need an Excel file created with text, numbers, and formulas. The data should be organized using rows and columns, across 6-10 tabs/sheets, and include pivot tables. Ideal skills and experience for this project include: - Advanced Excel knowledge - Experience in creating organized and visually appealing Excel files - Proficiency with pivot tables and formulas - Attention to detail and ability to follow specific instructions If you have experience with similar projects and can deliver a well-organized Excel file with the specified features, I'd like to hear from you.

...from an Excel file. The automation should be set up to run on Windows operating system using Power Automate. Requirements: - Automate creation of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in project management software I am looking for someone who can create a reliable and efficient automation system that can seamlessly...

...automate email sending through Excel. I have a list of email addresses and the same message to send to all recipients. However, there are certain conditions to consider: Firstly, as shown in the screenshot below, there are checkboxes with options (OUI ou NON) YES or NO. If the checkbox is marked with a "YES", the email will be sent. Otherwise, it will not be sent. Secondly, another condition relates to the frequency of email sending: Once a week Twice a week Once every two weeks Once a month I would like to establish an automated process that takes these conditions into account to send emails according to the specified parameters. Thank you for your assistance in implementing this solution." This version of the message is clearer and more precise, makin...

...to leverage business analytics and data visualization to achieve multiple objectives: - Identifying key trends and patterns - Making data-driven decisions - Enhancing data presentation and communication The primary data sources for this project will be Excel spreadsheets, social media platforms, and analytical software, such as PowerBI and Tableau. The desired insights from this project are specifically: - Analyzing closing prices - Gaining a clear perspective of the stock market trends Ideal applicants for this job should be highly skilled in use of Excel, PowerBI, Tableau, and social media analytics. A keen understanding of revenue performance, stock market trends, and closing price analysis is also crucial. Proficiency in communicating data-based in...

I am in need of a proficient data scrap...responsibility will not stop there. You will also need to compile the acquired data into a well-organised Excel spreadsheet - ensuring information is accurately represented and easy to navigate. A meticulous attention to detail is vital in this role, alongside experience in similar data scraping tasks. Skills: - Experience with data scraping - Proficiency in collating and organizing data - Excellent Excel skills - Attention to detail - Familiarity with Shopify and Zomato platforms This is not a short-term project. I'm looking for someone willing to establish a long-term business relationship, maintaining and regularly updating our datasets as required. If you are skilled, reliable, and looking for a steady ongo...

I'm in immediate need of a Linux expert with advanced problem-solving skills to assist with multiple tasks involving CentOS. - The right professional should excel in troubleshooting and debugging, Linux server administration, and Linux programming. - As the tasks are of an advanced nature, a strong background in Linux systems, particularly in CentOS, is essential. - Prior experience with complex issues is a must. Your challenging role will involve locating and fixing faults, managing the Linux server, and coding in the Linux environment. - If you feel you fit this profile, please apply, detailing your previous similar experience. Your commitment to a streamlined and effective Linux operation will be welcomed here.

As a business owner, I'm in dire need of a VBA Excel expert to automate key aspects of my inventory management. The primary goal of this project is to create an effective material management system. Task Description: - Automate data entry and generate regular reports - Update inventory levels regularly - Implement an efficient inventory tracking system within the operation Key Feature: The main feature that this project should hold is inventory tracking. Inventory Tracking System: - The inventory tracking should be innovative, able to adjust stock depending on the inventory levels. - Implement an automatic reordering system that triggers when stock is low. This will ensure that the operation runs smoothly without the worry of running low on inventory. Ideal candidate:...

I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find

I need a skilled Excel data analyst to work on sales data. Requirements: - Experience: Please include your previous experience with similar data analysis projects in your application to be considered. Please submit your bids along with a summary of your experience in this field. I will share the specific data once we are in contact.

I have a black and white Excel sheet that dosent look Professional ... I need it to be Colorful and attractive

I need a data entry specialist to compile an Excel spreadsheet database of addresses and opening times relating to approximately 400 branches of the Citizens Advice Bureau. The data will be collected from URLs that I will provide. Ideal Skills and Experience: - Proficient in data entry and Excel - Experience with web research - Attention to detail - Ability to meet tight deadlines - Previous experience with similar projects is a plus This is an urgent project and I need it completed as soon as possible. Thank you.

...registration details. What I don't have is knowledge of the specific password that I used for the file at the time. I have a list of 35 passwords that I was using for various tech systems around 2009. One of which is likely to open it or as a professional you may know a different way to access the data. At minimum I need from you an Microsoft Excel or Libre Calc file of all of the data in its fields that I can work with. Ideal professionals for this task should: - Have proven experience with Quickbooks, especially old versions - Be familiar with potential issues of opening older Quickbooks files using newer versions - Be able to ensure that data integrity is maintained throughout the process To show you're up for the task, you should: -...

I have code for login trading accound and fetch token data. I need to update code to my system. you can create new code for my requirement at same cost.I need to collect live data from the web and candle stick with different time frame.I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Stock Broker account: If Buy signal find it will automaticlly place Buy order,etc., Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you ag...

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect m...

I require both exterior and interior architectural 3D renderings for design development purposes. The renderings need to be detailed, inclusive of texturing, lighting effects, and even furniture and decor. - Freelancers that excel in photorealistic 3D modelling and architectural visualization are preferred. - Experience with a variety of 3D software and sophisticated texturing and lighting techniques is desirable. - The ability to effectively represent scale and layout, as well as a keen eye for interior design and detailing, would be beneficial in this project.

I am in need of a professional to convert a text-only PDF document into an Excel file. The converted document should not just be a direct replication, but should include some modifications to the formatting. The tasks are as follow: - Convert the text-only PDF to Excel. - Reorganize some data sections in the converted file. - Add or delete certain rows or columns as required. Proven experience in data organization, data entry and advanced knowledge of Excel is ideal for this project. Attention to detail is crucial as the final output needs to maintain content accuracy while adjusting the original format.

I'm in need of a creative graphic designer who can help me with designing materials for my product launch and portfolio showcase. Key Responsibilities: - Design a brand new website to promote my product/service - Design print materials to showcase my portfolio Ideal Skills and Experience: - Proficient in website and print design - Previous experience in promoting products/services - A portfolio showcasing previous design work - Understanding of consumer-focused design If this sounds like a project you'd excel at, please submit your bid along with relevant examples of your work. Ideally person should be able to work in illustrator understands that concepts of pixel base and vector base .. Has great knowledge of resolution adjustments. , 2 d drawings and banner cr...

More details: Are you looking to hire a freelancer to clean data in both CSV and Excel formats? Yes What is the primary goal for cleaning this data? Assessment What type of assessment do you need the freelancer to perform on the data? pass assignment.

More details: Are you looking to hire a freelancer to clean data in both CSV and Excel formats? Yes What is the primary goal for cleaning this data? Assessment What type of assessment do you need the freelancer to perform on the data? pass assignment.

I am looking for an Excel expert who can set up automation for specific tasks and create custom formulas based on my requirements. Key Requirements: - Automation of specific tasks: I need to reduce manual work and save time by automating repetitive tasks. - Custom formulas: I need new formulas developed to perform calculations and analysis that are not covered by Excel's standard functionality. Autocalculation Trigger: - I want the autocalculation to be triggered every time the Row is highlighted with sold green color. I have ten different columns with hundred of rows with specific beginning text "spect". When user fills a background color assume its solid green on a cell of a particular column the function should autocalculate the complete column a...

I'm launching a project in the medicinal field and am in need of a competent and dedicated research assistant. You'll primarily be dealing with published literature and are expected to perform the following tasks: • Assist in literature reviews in a research topic • Screen search results ibased on a predefined criteria to select studies for inclusion in the review. • Extract data from selected studies using standardized forms and protocols. • Verify the accuracy and completeness of extracted data, resolving discrepancies through discussion with team members. • Summarize and synthesize findings from included studies, highlighting key results and trends. • Participate in team meetings, providing updates on progress, challenges, and insights gain...

I have a project that revolves around copying and pasting text data within a single Excel sheet, focusing on specific rows or columns. - Brief for This Job - Your primary task is to copy text from specific rows or columns and paste them responsibly where needed. This project will probably only take four hours of your time. (course number + date from + date to) copy paste beside every student name I need it for my database to be in this format video will be send to you to understand my requirement each freelancer will cover 200 course out of 1000 course so 5 freelancers will be hired maximum budget is 16$ for each freelancer do not contact me if your bid more than that submission within 24 hours from awarding the project (failure to submit will considere...

I need a dedicated and thorough researcher to help me compile a comprehensive list of local builders... and roofers. Your main task involves finding their emails and Instagram accounts as we need these for marketing purposes. Key Requirements: - The service providers must be local to a specific city which will be provided to you. - The collected information should include the provider's full name, service type, and contact number. - The information should be appropriately organized into a Google Spreadsheet so that it's easy for me to analyze and use. Skills and Experience: - Experience in web research or data mining - Precision and attention to detail - Familiarity with Instagram and ability to find user profiles - Excellent organizational skills - Proficienc...

Have operations based math problems that I need done for a work project. 3 problems that involve aggregate planning, inventory planning, subcontracting, production levels, economic order quantities ect. Strong excel knowledge required where you can run solver.

I'm seeking a talented visual effects artist to create a stunning character transformation scene for my film. Specifically, the scene involves a character eerily morphing into a dead body. Requirements: - Proficiency in creature animation, particularly in the realm of morphing effects. - Experience with macabre or horror-themed VFX would be an asset. - Capability to create convincing and visually striking transformation effects, in this case, human to corpse. - Ability to closely collaborate and discuss progress and revisions. This project presents a unique challenge and is ideal for those who excel at creature animation and have a knack for the unsettling and uncanny. Your creativity and distinctive flair will bring an integral scene in my film spect...

I am in need of a skilled SQL coder to help me join the tables and build a health care report in Excel. The report will focus on patient demographics and medical procedures. Key requirements: - Expertise in SQL coding - Proficiency in Excel for report building - Experience in handling health care data - Ability to merge tables effectively The report should include: - Patient demographics such as age, gender, and location - Medical procedures data The ideal candidate should be detail-oriented, able to follow instructions, and have a background in health care data management. It is important that the report is well-structured, easily understandable and can be updated efficiently.

More details: Have you already created an Amazon seller account? Yes What type of products are you planning to list on Amazon? Accessories Do you have product images and descriptions ready for your Amazon listings? I have descriptions but need assistance with images.

More details: Do you want the Excel program to convert purchase orders and local stock into separate TXT files? Yes Should the program automatically detect and apply specific parameters for each conversion, or will you provide the parameters? Mix of both Which specific parameters do you need for the TXT conversion of purchase orders? Each order should be a TXT

I am looking for a proficient data analyst who can assist me in providing data analysis using Excel. Specific tasks include: I have two online retail catalogs that sells similar products as one another. Medline & CVS Health. Medline has 313 products listed and CVS Health has 892. I need a comparison chart in any format (Excel or Word) that addresses: 1.) how many brand name products are under Medline. List then out. 2.) how many brand name products are under CVS Health. List them out. 3.) how many Medline specific products are under Medline. List them out. 4.) how many CVS branded products are under CVS Health. List them out. 5.) Which products does CVS health have that Medline does not? (Ex: reading glasses) 6.) Which products does Medline have that CV...

...looking for a skilled and experienced Excel expert to create a detailed and comprehensive Excel spreadsheet which will serve as a trucking business operational tracker. Key Information to Include: - Revenue: Primarily from freight charges. - Expenses: comprising of fuel, maintenance, office expenses and rent. - Profit Margins: Determine the profit margins by deducing expenses from revenue. - Mileage and Fuel Costs: Tracking to determine efficiency and cost-effectiveness. Frequency: - The ideal candidate should create a sheet easy to update on a daily basis. Ideal Skills & Experience: - Proficiency in Excel - Astute attention to detail - Experience with financial and operational data tracking - Knowledge or experience in the trucking industry would ...

I am in need of an expert in Excel to create a system for managing my financial and inventory operations. With your specialized skills, I require a streamlined and seamless workflow for my business that includes the following: Accounting: - Managing both income and expenses in a clear and concise manner Invoicing: - Capabilities to create invoices directly within the sheet - Functionality for generating these invoices in a PDF format - A reliable system to track invoice payments Inventory Management: - A method to effectively track stock levels - A simple way to generate purchase orders as needed - A solution for generating sales reports for analysis The freelancer best suited for this project would have an extensive background in Exc...

I have code for login trading accound and fetch token data. I need to update code more details in that code. I need to collect live data from the web and candle stick,. Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need to find signal and automate the trade based on Condition I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire...

I would like a chrome (or chromium, edge extension (for my own use, not for sale, not uploading to the store). The extension should be able to retrieve keywords from a given text or excel file and perform one by one google search at a time (line by line). Google AD results will be extracted to a file (the URLs). Give a specific price! Don't ask how much my budget - I've already given my budget limit. That's the maximum.

بالمرفقات أنا بحاجة إلى شخص يمكنه إجراء بعض العمليات البسيطة على ملف Excel الحالي الخاص بي. تشمل المهام ما يلي: - تنظيم البيانات وتصنيفها - إضافة الصيغ والحسابات - اجرائات اخرى

?THIS ANNOUNCEMENT IS ONLY FOR THOSE WHO WANT TO SHARE THE SYSTEM? I am selling a system for recording and tracking bird sightings designed to facilitate the process of observation and monitoring of biodiversity. This system provides an organized and updated platform for the registration of birds observed in different areas, allowing to identify and monitor the species of birds that inhabit the area. In addition, the system encourages learning and interest in bird watching and biodiversity conservation. The system has the following specifications: Login: the user can log into the system using their email and password. Reset password: the user can reset his or her password in case he or she has forgotten it. Sightings registration: The system should allow users to ...

Necesito construir un dashboard dinámico en excel para análisis de información

Hi Kelvin Writer, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I require immediate assistance for a web scraping into Excel task. This project focuses on the extraction of complete tables from different websites. Requirements: - Have expertise in web scraping and excel. - Be able to deliver completed work ASAP. Ideal Skills: - Proficiency in tools or programming languages for web scraping. - Strong command of Excel and data wrangling. - Demonstrated punctuality and adherence to deadlines. This is a time-sensitive task, requiring both speed and accuracy. Please, only serious and dedicated freelancers should consider this project. Job Description: There are 2 sets of tables, Soccer and Basketball for my analysis during my free time. 1. The links are in the spreadsheet highlighted in yellow. The script mu...

Ge...regresión tipo probit o algun modelo prospuesto por el analista con las variables datos demográficos con la productividad, la permanencia, las asistencias, la puntualidad, las horas trabajadas y el salario para obtener un perfil laboral del trabajador que mejor se ajuste a la empresa. Perfil del cargo: • Profesional con estudios de estadistica o certificación en analisis de datos • Conocimientos Excel, Power BI o Tableu , BBDD y semantica. • Experiencia en análisis de datos Funciones: • Analizar datos y confeccionar dashboard con semantica. • Establecer manejo de bases de datos y su optimización. • Regresión lineal o modelos para obtener analitica fiable. • Integración y qwerty ...