Excel macros need programmer jobs

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.

I'm seeking a freelancer who can develop an automated system in Excel to manage backorders. This system must create new data for efficient backorder handling. Specific requirements include: • Creation of an automation tool that handles numeric values, text strings, and dates and times. • The system should adequately track product lead times and inventory levels, despite not automatically generating reports. Please note, having prior experience in backorder management and Excel automation will be advantageous for this project. The ideal freelancer should have strong data handling capabilities and excellent knowledge of Excel. Proven experience in similar projects is preferred.

I am in need of a SCORM 1.2 programmer to create a SCORM package from scratch. I only require the creation of one SCORM package for this project. Skills and experience required: - Proficiency in SCORM 1.2 programming - Strong understanding of SCORM standards and protocols - Ability to create SCORM packages from scratch - Experience in e-learning development and courseware creation Please note that I am specifically looking for a programmer who is experienced in SCORM 1.2 and has the ability to create SCORM packages from scratch. is optional. Thank you.

I need an experienced freelancer to create a chart with interest rates in Canada for every month between January 2015 and the current month. Key Requirements: - The chart should accurately reflect the fluctuation in interest rates over the specified time period. - The format must be an excel which is easy to read and interpret. - No additional analytics features such as trend lines or forecasts are necessary, the primary focus is to clearly display interest rates by month. Ideal Skills: - Research historical interest rates in canada - Proficient in Excel and creating line graphs. - Strong understanding of financial data, specifically interest rates. - Eye for detail and ability to ensure the data is clearly presented for easy understanding.

I need an experienced freelancer who can convert Excel data to 2D DWG files on an urgent basis. Key Requirements: - Utilize the Excel data to create 2D contour plots, specifically representing the height distribution on a bridge surface and the riverbed levels. - Create these contour plots in a DWG format. - Accuracy and precision are crucial for this project. Ideal Skills and Experience: - Proficiency in AutoCAD for DWG creation. - Prior experience with data visualization from Excel. - Immediate availability to start and complete the project as soon as possible. Please include any relevant portfolio items or examples of similar projects you've done in the past. I am looking for a quick turnaround without compromising on quality.

I need someone to add a total of 50 bookmarks to my Word document. Essential Requirements: - Add 50 bookmarks to the document - create a excel; audit xls with 50 rows listing the bookmark name and the section text name (we use that as quality control and testing)

I'm looking for a skilled programmer who can quickly correct the issues in my web scraping project in python. The task involves scraping data from Website A. Specifically, I need to retrieve player, tournament, records and runs and bowlers information. Ideal Skills and Experience: - Proficient in web scraping techniques - Experience working with CSV format - Familiarity with data extraction from dynamic sources - Ability to troubleshoot and fix existing code - Strong attention to detail and accuracy Please note that I need this task completed urgently within few hours as base code is already written, need to fix details, so quick turnaround time is essential. Thank you!

I'm seeking a proficient freelancer who can handle all aspects of setting up, running, and ensuring the success of my Shopify dropshipping account. My business focuses on a specific nich...SEO: I prefer to attract customers to my store through organic SEO strategies. Practical knowledge of SEO tools and techniques is a must. 3. Social Media Proficiency: In addition to SEO, I'd like to integrate targeted advertising on Facebook and Instagram into my marketing strategy. Ideally, the freelancer should have a track record of optimizing Shopify stores for effective dropshipping. To excel in this task, the freelancer should possess excellent SEO skills, social media advertising knowledge, and a clear understanding of dropshipping mechanics. Your bids should reflect your compet...

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp

I need a C# .NET programmer to integrate UPS API functionalities into an existing .NET website. UPS is switching over from their current API to OAUTH 2.0. Everything works as it should now, but in June the current API will no longer work. We use rate calculation, time in transit, and creating a shipment. We do not need address validation and some other things that do not pertain to us. The core of the project is implementing UPS API functionalities. You will need to handle package tracking, calculate shipping rates, and create shipments through the UPS API with OAUTH 2.0 Ideally, you should have experience with C# and .NET, as well as UPS API integration. Previous work with this is ideal and would like to see examples. I will provide the Visual Studio pro...

I am seeking a proficient web scraper to extract specific data from The data I need includes venue details and contact information. I require the end product to be delivered as a well-organised Excel file. Key aspects to focus on: * Meticulous detail on venue data * Comprehensive contact information * High level data formatting skills The ideal candidate has demonstrated experience in web scraping, data management and Excel. A background in music or event-based data is a plus. Efficiency, precision and respect for the source website's terms of service are crucial for this project.

I’m in need of an Excel specialist who is adept at enhancing operational efficiency through the automation of repetitive tasks, namely the creation of reports utilizing sales and operational data. Key Requirements: - Creating a system for report generation on Excel, extracting key insights from extensive datasets. - Reports should conveniently display revenue, profit margins, sales growth, as well as production metrics and efficiency metrics. Ideal skills: - Proficiency in Excel and data analysis - Experience with big data and automating report generation - Strong attention to detail and the ability to make data actionable.

Description: We are seeking a talented freelance writer...requirements for the list. Requirements: Proven experience in researching, content writing, and data entry, preferably in a business or professional setting. Excellent attention to detail and accuracy in data collection and entry. Strong organizational skills with the ability to manage multiple tasks and deadlines effectively. Proficiency in using online research tools, databases, and Microsoft Excel or Google Sheets. Exceptional written communication skills with the ability to craft clear and compelling content. Preferred Qualifications: Previous experience working in business consulting or a related industry. Familiarity with CRM systems or other data management software. Knowledge of business terminology and industries i...

...Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data The requirements for the applicant include strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). We need fast, accurate and specialized members. It is mandatory to pass a short trial test / finish a task, that could last between 2-4 hours, with the possibility of extension to up to 1 week, if the candidate is involved in other projects, or not available to start immediately....

I need an expert in Power BI to create a comprehensive and highly interactive dashboard that will help track and analyze market data more efficiently. It is important that the dashboard connects to Excel spreadsheets and other Power BI resources to provide an all-round perspective of the metrics. Ideal skills and experience: - Proficient in Power BI - Excellent knowledge of Excel - Deep understanding of retail market data analysis - Excellent in crunching and interpreting numbers - Strong attention to detail Responsibilities: - Gather and interpret market data - Create a user-friendly and highly interactive dashboard - Connect the dashboard to Excel spreadsheets and Power BI resources - Regularly update the dashboard with relevant market data - Identify tren...

I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.

I'm seeking a skilled programmer who possesses a deep understanding of Tradingview, MACD indicator and trading algorithms. Your task would be: - To create an indicator within Tradingview that traces resistance and support using the MACD on 1-hour candles whenever a MACD reading is lodged between two peaks - This indicator should automatically draw a horizontal line once it identifies a support or resistance level. Note that this task requires the use of customized parameters for the MACD indicator instead of the default ones. The ideal person for this project would have a strong background in designing algorithms for financial markets, specifically building custom indicators on Tradingview. Experience in financial analysis and understanding of the MACD indicator is also c...

I need help browsing the web for text data and organizing it in Excel. - The text data is to be organized in Excel by name and other relevant information. - No specific Excel functions or formulas need to be used, you will simply need to look at the page and type the information into the spreadsheet. Ideal skills: - Proficiency in web browsing - Be very quick - Strong attention to detail - Familiarity with Excel - Time management skills The task is straightforward, but attention to detail, accuracy, and the ability to work efficiently are crucial. Please submit your daily rate.

I am looking for an Excel expert who can help me create a dynamic and visually appealing Trend chart that can effectively communicate data composition over time. Key Requirements: - The chart must be able to clearly represent data changes over a period of time, showcasing the shifting proportions of different components. - The data for the chart will be provided in an Excel file. The freelancer will need to effectively structure this data to make it compatible for chart creation. - The chart should be designed with the latest Excel standards to ensure compatibility and ease of use. Ideal Candidate: - Strong proficiency in Excel, with a focus on chart creation. - Experience in creating dynamic and interactive charts in Excel. - Ability to underst...

We are looking for a highly skilled Lead Generation and Cold Calling Virtual Assistant for our Digital Marketing Agency. As a Cold Calling specialist, you will be...Requirements: 1. Should have basic understanding of Google My Business (formerly GMB Profile), Website Design, SEO, Backlinks etc. (preferred but not mandatory) 2. A big plus if you have 1-2 years of experience selling digital marketing services like Websites, SEO and etc.. 3. Must be good in researching data for companies (business name, contact numbers, emails etc.) 4. Sufficient knowledge of MS Excel for managing the data. 5. Great communication skills (both, verbal and written). Details: 10 Hours a week / 2 hours a day / Monday through Friday If this opportunity interests you, please respond so we can discus...

I am seeking a proficient programmer to develop a scraping application for the purpose of extracting text data from websites. This project is sensitive, considering that the targeted websites demand API keys for access. Accordingly, the ideal candidate should be familiar with both GET and POST methods as well as API integration and management. Experience with data extraction and web scraping from API authenticated websites is a must. Skill requirements: • Web scraping • HEADERS • CUSTOM HEADEARS • STRINGS • URLLIB • Working knowledge of GET & POST methods • Experience with API authentication • Exceptional skills in data extraction, especially text. • loliscript • SilverBullet i need to get a netflix mass account checker ...

I'm currently working on a financial analysis project through Microsoft Excel and require assistance with data structuring specifically for pivot tables. I aim to feed this data into a comprehensive dashboard. The Excel spreadsheet encompasses multiple periods of financial data. Key Aspects: - Data included in the pivot tables are dates of financial periods, types of financial information, and identifiers such as multiple General Ledger accounts, categories and subcategories. - The task involves transforming this spreadsheet data into an appropriate format suitable for creating a pivot table and consequent dashboard. Skills and Experience: - Proficiency in Microsoft Excel, particularly in the handling of complex data and pivot tables. - Experience in financial...

As the driving force behind our new project, I'm searching for an advanced Python programmer who can bring a wealth of expertise and precision to the table. -Ideal Skills and Experience: • Proven skills and experience in Python programming • Ability to adapt to the project's complexity and provide innovative solutions • Effective communication skills to handle any discrepancies professionally To ensure a perfect match, I'd appreciate it if your application could provide: • Detailed project proposals: Please outline your approach to Python coding projects, paying close attention to how you plan, execute and troubleshoot during the development phase. API skills are a part of the solution, so knowledge and competencies in this field are ...

I need help with Excel It is advance level so please be careful when you apply. Thanks.

Cuento con datos operacionales en Excel de mi trabajo, y necesito transformar esa data a dashboards y procesar data en un ambiente web. I have operational data in Excel from my work, and I need to transform that data into dashboards and process data in a web environment.

Extract the industry data from the IBIS reports and populate the Excel template

I need an Excel sheet that will empower me to manage my call center effectively by providing me with real-time insights into the number of agents needed per hour. Key Requirements: - The sheet should offer a graphical representation of the data, enabling me to quickly understand the changes in agent demand. - It must calculate and display the total call duration per agent,hourly agent demand, and the average wait time for callers. Data should be updated on a daily basis to ensure the most current and accurate information is available. Ideal Skills: - Proficiency in Excel and ability to create dynamic tables and graphs. - Experience in designing forecasting models would be a plus. - Strong understanding of call center operations and key metrics. The ideal free...

I'm in need of a Windows-based inventory tracking program. It should be user-friendly, with specific features to streamline our inventory management process. Key Features: - Barcode Scanning: The program must support barcode scanning for efficient inventory check out and check in. Also needs to allow for searching based on keywords like bandage 4", caviwipes to find items without a barcode available. - Multi-User Access: The program should allow multiple users to access the inventory database simultaneously and check items out (never in) while recording user ID# and department needing the inventory. - Email Reports: Generate and send end-of-day reports using O365 account(s), from two devices used to scan items. - Easy Database Edits: Ensure the end users at the departmen...

I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.

I need a skilled Excel specialist to handle the automation of tasks in my daily-updated Excel file. Key Responsibilities: - Develop basic macros to automate tasks: I need macros to simplify and speed up the daily operations in the Excel file. Ideal Skills and Experience: - Proficiency in Excel: You should be very familiar with Excel tools and functions, especially in the area of macro creation. - Experience in automation: Previous experience in automating tasks in Excel, especially on a daily basis, would be highly beneficial. - Detail-oriented: The tasks are basic but they need to be carried out consistently and accurately on a daily basis. - Time management: You should be able to create a system that keeps ...

... I have sample resume. You need to edit each resume on the basis on the job description posted on LinkedIn and other websites. Hello, I have a daily target of 25 applications to apply for different job domains. I have a task of 500 applications to be completed within 2 weeks. I will send you the job application link and my sample resume and you have to tailor it according to the role. It should be ATS-friendly and should have a score of a minimum of 85 % in resume worded. I have ready chatbot prompt to make your task easier so that each application resume will take less than 10 minutes. I just need the resume and its score's screenshot, I will add the job link in an Excel sheet so that it is organized properly. You will add resume's link in the same ...

...to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from different types of PDFs; - Unders...

I'm in need of a freelancer who is proficient in Tally ERP9, particularly the Silver Edition and Excel. The task involves specifically handling bank transactions. Key Responsibilities: - Transcribing bank transactions into Tally ERP9 Silver Edition - Organizing and managing the data accurately in Excel - Ensuring all data is updated in a timely and accurate manner Ideal Freelancer: - Proficient in Tally ERP9 Silver Edition - Strong experience in data entry - Skilled in Excel, particularly in data organization - Detail-oriented and accurate in data management Communication: I prefer updates and feedback to be sent via email. Clear communication and prompt responses are highly valuable to me.

I need someone to create a simple data table search and display function for me. The search form will be inside of a page. The search function will read from a specific spreadsheet with organization names and URLs but it will also have keywords and categories that it needs to search. Example: search term: Fatherhood Display: Organizations, categories, URLs with the term "fatherhood" or a category. The results will simply display below the search form in a row: ORG NAME URL. CONTACT INFO (if any) See the attached spreadsheet. I DO NOT want a listing directory with individual pages for listings. All this is should be a search box, and display results statically beneath. I can create a screenshot of necessary. Also it needs to match the CSS of the rest of the...

I'm looking for a programmer who can help me create a time series forecasting model using Python. The main aim is to predict the future default rates on lending loans based on past data. Key Requirements: - Past data includes monthly default rates till a specific time period. - The time period for which the default rates are available will vary. - There will be multiple customer, taken loan for a different time period at different months. Use all data of all customers to predict the future default rates based on the given data. Moreover, if a new customer takes loan what would have been the default rates of that customer if the customer had joined some time back in the past. Ideal Skills and Experience: - Proficiency in Python and relevant data science libraries (e.g., Pan...

As a WordPress expert with a deep understanding in PHP and AI programming, I'm looking to give my website a much-needed overhaul. What's urgently needed are: - An enhanced user interface to improve the overall aesthetics and user experience....times - A user feedback analysis mechanism to address customer grievances - Food image recognition to classify food items accurately - Recipe Generation for unique cooking ideas - Predictive inventory management to avoid food wastage - Nutritional analysis for healthier meal choices - Personalized recommendations to provide a unique user experience. Freelancers bidding on this project should excel in WordPress, PHP development and AI programming, with a proven portfolio in building complex websites with excellent UX and int...

I'm in need of a freelancer who is proficient in Tally ERP9, particularly the Silver Edition and Excel. The task involves specifically handling bank transactions. Key Responsibilities: - Transcribing bank transactions into Tally ERP9 Silver Edition - Organizing and managing the data accurately in Excel - Ensuring all data is updated in a timely and accurate manner Ideal Freelancer: - Proficient in Tally ERP9 Silver Edition - Strong experience in data entry - Skilled in Excel, particularly in data organization - Detail-oriented and accurate in data management Communication: I prefer updates and feedback to be sent via email. Clear communication and prompt responses are highly valuable to me.

I'm in need of a comprehensive Excel workshop system that can handle all the necessary features, including open job cards, inventory templates, dashboards, bills, estimations, and work orders. Here's what I'm looking for: - **Open Job Cards:** The system should be equipped with a section for open job cards where I can easily manage and keep track of ongoing tasks. - **Inventory Management:** I prefer a manual entry for inventory items. The system should facilitate the creation and maintenance of inventory templates in an easy and efficient manner. - **Dashboards:** The dashboards should be highly customizable and provide me with a detailed overview of all the key metrics that I need to monitor regularly. The level of customization should be advanced...

I need a capable hand to create an AI tool for an Android game that's similar to Subway Surfers. This tool should be built to perform at an intermediate level, hence, it shouldn't struggle with achieving basic tasks but doesn't have to excel at the hardest ones. The ideal freelancer for this job should have experience a deep understanding of artificial intelligence. Key Requirements: - AI Character Movement: The tool must automate the character's movements throughout the game. - Collecting Power-Ups: The AI tool should be clever enough to identify and collect power-ups. - Dodging Obstacles: It is essential that the tool ensures the character constantly avoids obstacles to prolong gameplay. Please note, it's crucial that the tool works seamlessly ...

financial modeling of a project real estate with excel

I require a skilled native Japanese transcriber to convert my audio recordings to text format. The nature of these audio files primarily involves conversations, and the sound quality is high with minimal background noise. To excel in this task, you should: - Have proficiency in Japanese language and transcription techniques. - Be capable of identifying different speakers during the conversations. - Ensure all transcriptions are returned with excellent grammar and spelling. Preferably, you'll have experience with transcription software and can provide evidence of your skills and experience in such projects. Your attention to detail and commitment to the agreed timelines will be paramount in this engagement.

I'm urgently in need of a highly skilled programmer who has proficiency in Python, Java, and C++. Key skills and experiences will be: - Proficient in Python, Java, C++ - Strong problem-solving skills - Ability to work under pressure and adhere to tight deadlines - Previous experience in general programming, specific project genre unspecified Due to the urgent nature of this project, I'd appreciate it if interested freelancers could contact me immediately.

I'm in need of an experienced Python programmer for a singular web scraping task on booking.com. The data obtained from this scraping will be instrumental for our competitor analysis. Key Tasks: - Implementing a web scraping script specifically for Ideal Skills: - Proficient in Python - Experience in web scraping - Ability to deliver clean and structurable data - Previous experience in competitor analysis (preferred)

I'm looking for a skilled German translator to translate a large volume of content from English to German. The co...translator to translate a large volume of content from English to German. The content is related to accounting and POS software. The source material is in Excel format and contains over 10,000 words. Ideal Skills and Expertise: - Fluent in both English and German - Proven experience in translation, particularly related to technical or software content - Proficient in working with Excel files Please note that the translation must be accurate and precise to ensure that the technical terms are properly translated. Your familiarity with accounting and POS software terminology is highly desirable. The software is up to 90% translated, we need translator...

We have a list of products. We need to check everyday, if those products have strikethrough price appear on them. All the products that need to be checked are from the same website. The following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highli...

I am seeking a skilled Freelancer to develop a comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of comp...

I'm in need of a skilled branding professional who can craft an all-encompassing brand guidelines document for my pet grooming business. This document will serve as a comprehensive resource for our marketing partners, ensuring consistent color usage across all our promotional materials. Key Elements: - Color Palette: A definitive selection of colors that best represent our brand, along with the specific color codes. - Logo Usage Guidelines: Clear instructions on how our logo should be applied, in terms of size, placement, and when alternative versions can be used. - Typography Guidelines: Detailed information about the fonts and typography style that should be used in all our communications. - Merch Guides: Design suggestions and guidelines for any promotional or merchandise ...

...professional who can set up an Azure data storage account to store Excel data, particularly with the following key features in mind: - **Data Type and Source**: The data I'm working with is primarily Excel based, so having experience with managing structured data storage in Azure is a must. - **Frequency of Updates**: The data will be updated on a weekly basis, so the storage solution needs to seamlessly accommodate this. - **Purpose of Storage**: The primary purpose of storing this data in Azure is for data analysis. While not the only use, ensuring that the storage solution allows for easy and efficient data analysis is crucial. The ideal candidate should have prior experience with Azure data storage, particularly in managing Excel data, and should be a...

I am launching a new enterprise and require an expert in OCR technology to design a program for me. The main function of this program would be to detect and digitize human handwriting from forms, consolidating that information into an Excel sheet. There would be a subsequent function for field extraction to compile a final report. - Desired Skills and Experience: • Proficiency in OCR technology for handwriting detection • Experience in custom software development • Excel programming expertise for auto-consolidation of data • Knowledge of report generation mechanisms within software Successful execution of this task would drastically streamline data processing in my start-up. To increase accuracy, the OCR program needs to be trainable, in order to reco...