Helpful excel macros jobs
I am in need of a skilled logo designer who can create a minimalist logo using a specific color scheme. This logo will be a combination of both text and image elements. Here are some more details regarding my needs: - Logo Style: Minimalist - Color Scheme: I have a specific color palette in mind that I would like to use....project. - Logo type: The logo needs to be a concoction of both text and image. I'm looking to have a perfect synchrony between the text and image in the logo design. Ideal Skills: - Proven experience in minimalist design - Ability to work with specific color palettes - Expertise in combining image and text for a single logo Your portfolio showcasing past minimalist designs would be very helpful. I look forward to creating a sleek, modern, and engaging...
I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub
I'm in need of a unique text-based logo for the base of a ski which is die cut friendly. This entails certain specifications to consider: - The design of the logo needs to be bold, blockish, with clear separation between the letters to ensure its optimal adaptabili...of the logo needs to be bold, blockish, with clear separation between the letters to ensure its optimal adaptability to a die-cut process. - Stick to a monochrome color scheme, presenting both a professional and modern feel. Ideal candidates for this project should have a strong background in graphic design and experience working with die cuts. Familiarity with ski equipment design could be helpful as well. The success of this project will be measured by the clarity and adaptability of the logo when applied to ...
I need a meticulous person with a keen eye for detail to hunt down and manually input contact details from an event's website into an Excel file. Key Responsibilities: - Collect the data fields: Name, Email, Phone Number, Company and Sector from the website. - Store data in an organized manner in a .xls Excel file. Ideal Candidate: - Someone with experience in manual data entry - Attention to detail, as accuracy is of utmost importance - Please provide examples of past work demonstrating your data entry skills I look forward to seeing your applications and choosing the best fit for this job. Remember, past experience counts!
Hi, I need to extract data and images from product pages into an Excel file. Here is an example link - Video showing it - ATTACHED FILE is the format it needs to go into so I can import it into WooCommerce Product name All images Price About this product Details Variations: color, size, etc
...a meticulous and detail-oriented freelancer to concentrate specifically on the following for an unspecified number of Excel files and bank statements: - Date Formats: Ensure all dates are consistent - Transaction Types: Verification and correction of all transaction types - Narrative Consistency: Ascertain uniformity in transaction narratives Ideal skills for the job would include extensive proofreading experience and in-depth knowledge of Excel data and bank statements. Any examples of past work or detailed project proposals you could include in your application would be beneficial. Please be prepared to dive into a project of an undefined size, as the number of Excel files and bank statements has not been specified. With your assistance, I'm confident we ...
...Python, Excel and other development languages. Monitor+ is designed for reference data and handles complex pre-processing of data and can return historical data in a variety of JSON formats in just three lines of code." - Monitor+ is a high value, low cost, API platform designed for Reference Data. - It's a complete reference data solution for traders, analysts as well as front, mid and back office. - Monitor+ provides market data vendors with a new, affordable channel to market - fast. - Extremely powerful API gives easy data access in R, Python, Excel and other languages. - Access energy, commodities, stocks, currencies, global indices and more. For Clients Paragraph of text and 5 Bullet points "We offer native access to ma...
...skilled graphic designer who can develop a series of medium-sized, flat design styled icons for our digital courses. These courses encompass topics including Excel, PowerPoint, MS Project, and Power BI. The icons should follow the style of the ones we already have for our HSE (Health, Safety, and Environment) courses, maintaining consistency across our course offerings. Ideal Skills and Experience: - Proven experience in designing intuitive and visually appealing icons - Proficient in Adobe Illustrator - Strong understanding of flat design principles - Prior work on digital content or courseware would be a bonus - Familiarity with Excel, PowerPoint, MS Project, and Power BI for context-oriented design. Requirements: - Maintain consistency with the style of icons used fo...
Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but 3 results is seemed, adding more columns at the final table (see atta...
I'm experiencing an issue where a form in my Angular app...Angular framework, especially in form handling. - Proven troubleshooting and problem-solving skills in a similar domain. - An understanding of form behaviors, in order to help identify which action is required upon submission (whether it should redirect to another page, display a success message, etc.). When bidding on the project, it'd be helpful if freelancers could include: - Their experience in resolving similar Angular form bugs would be helpful, although it's not a requirement. - Examples of past work around Angular applications, especially those that had forms at their core. Looking forward to working with a detailed-oriented, problem-solving expert in Angular who could help troubleshoot and...
I'm seeking a freelancer proficient at data entry for impending tasks. The job involves entering both numerical and textual data. Details: - You will need to enter a mixture of numeric and textual data. - Accuracy is crucial to ensure the quality of data entry. - The finalized data should be provided in an Excel spreadsheet. Skills and Experience: - Proficient in data entry. - Strong attention to detail. - Experience using and formatting Excel spreadsheets.
I have two excel files. In the file, I want you to color code cells from B2:E2 to the end of the columns with text as either green, yellow, orange, red for how closely the text in one cell matches in another. Green - perfect or near perfect match Yellow - most of it is good Orange - less than 70% match Red - poor match or no match I roughly counted there are about 2000 cells.
I'm looking to hire someone proficient with Excel to reconstruct a spreadsheet using a template that I will provide. The new version should replicate the original as closely as possible, without any added functionalities. Key requirements: - The spreadsheet should have exactly the same type of data as the original one. - You will not need to incorporate functionalities such as formulas, calculations, data validation or conditional formatting as they were skipped in the requirements. I want to ensure that my project is in good hands, therefore, your experience is crucial to me. During your application, kindly detail relevant experiences you've had recreating or working with spreadsheet templates. Looking forward to finding a trustworthy and knowledgeable professional w...
I am seeking an Excel expert who can provide in-person training on ‘Budgeting and profit and loss projections’ for one person. I already has an intermediate understanding of Excel and we need further training on: - Basic Excel Functions: The trainer would be expected to reiterate on the basic functions to ensure a strong foundation for the subsequent practical sessions. - Creating Formulas: The ability to create and manage formulas is the next skill we wish to hone. This includes all the necessary functions to perform complex calculations for our projects. The spreadsheet has already been created, it needs to be corrected a little but can be explained further in the training session. This training should be tailored to suit individuals with intermediate ...
I urgently require a meticulous and professional proofreader, well-versed in Japanese, to refine four not-safe-for-work (NSFW) lan...not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Japanese. You will be provided 6 landing pages that you will need to open with a browser language set to Japanese. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is highly val...
Hi there! I'm Sourabh Dhos a detail-oriented individual with a knack for data entry. I thrive in fast-paced environments where accuracy is key. Proficient in ( Excel,ms word,I ensure data integrity while meeting deadlines.
Looking for an individual to accurately transfer numerical information and tables from PDF to Excel. Previous experience in data entry will be advantageous. Ideal skills and qualifications: - Beginner level experience in data entry or similar roles - Proficient in Microsoft Excel - Excellent attention to detail - Ability to interpret and analyze data Example attached.
The aim is to build a comprehensive business plan for my IT Service, consulting tech...attract investment. To this end, I need a professional who can effectively portray my business and future prospects through this plan. Key Requirements: - Incorporation of financial projections for more than 5 years into an Excel sheet. - Strong understanding of the technology service industry. - Experience in developing business plans specifically for investment purposes. Skills and Experience: - Excellent financial modeling skills. - Profound knowledge of the technology industry. - Experience in preparing business plans for fundraising purposes. - Proficiency in Excel. By effectively portraying my business strategy and financial future, you'd provide the key tool I need to secu...
I am seeking a skilled R programmer to develop code to create interaction matrices. The code will need to read in data from 80+ Excel sheets, create interaction matrices, and link in ID numbers from a separate document. Ideal Skills: - Mastery of R programming - Experience with scientific research data - Strong skills in data analysis
...Documentation covering app architecture, API endpoints, and setup instructions. Budget: We have a flexible budget depending on the scope and quality of work. Please provide your estimated cost and timeline for completing the project. How to Apply: Interested candidates, please submit your proposal along with your portfolio, relevant experience, and any additional information you think would be helpful. Deadline for Applications: [15th April, 2024] We are excited to work with a skilled developer to bring our Carrom Fantasy League app to life. Thank you for your interest ...
I'm searching for an individual specialized in data mining and web scraping who can help me extract specific product information from an e-commerce website. Key Responsibilitie...in data mining and web scraping who can help me extract specific product information from an e-commerce website. Key Responsibilities: - Locate and extract specified data from the selected e-commerce site - Ensure collected data is reliable and structured properly Ideal Candidate: - Has in-depth knowledge in Web Scraping and Data Mining - Is familiar and proficient with Excel as the required output format is an Excel file This project aims to support a larger market research initiative, thus accuracy and attention to detail is critical. Only professionals with proven experience in simila...
I'm experiencing an ...pbix file. Despite the fact that my data is neatly structured on a single worksheet with multiple tables in Excel, it is not refreshing in the pbix file when expected. Given the nature of this problem, it's clear that an expertise in data management with Excel and Power BI is necessary for this project. Proficiency in troubleshooting Power BI related issues is also a must. The primary tasks will include: - Analyzing the pbix file and the associated Excel worksheet - Pinpointing the cause behind the failure to refresh data - Implementing a fix to ensure smooth data refresh in the future The preferred freelancer should be experienced with: - Power BI (especially .pbix files) - Excel data management and organization - Problem-so...
I have a specific goal for this project, which involves web scraping and organizing data into a comprehensive Excel spreadsheet database of UK care homes. The work scope includes: - Extracting contact details (both phone numbers and emails) of each care home - Categorizing the extracted data based on care home location The ideal freelancer for this job should hold the following skills and experience: - Proficient in web scraping - Knowledge of categorizing or sorting data - Excel spreadsheet expertise Accuracy and attention to detail is crucial in this task. This project is suitable for individuals who have previously demonstrated efficiency and success in similar roles. Resource could be
I'm looking for a skilled web developer to create a vibrant and energetic sports betting comparison website aimed primarily at casual and experienced bettors. The main purpose of the website is to compare odds for users. Ideal Skills and Experience: - Web developmen...of sports betting industry - Experience in vibrant web design - Ability to target casual betting audience Key Features: - Need to be able to give you a major betting site and for odds to be copied from the entire site and compared against one other site. - Using the above line then highlight odds that are higher than the other sites by x amount - Having a subscription login website can be helpful as well - Comparison of odds and betting offers from various sources - User-friendly interface for casual better...
...operations. Primarily, I need a skilled Python developer to integrate the Angel Smart API with Microsoft Excel. Areas of concern include: - Developing data retrieval and analysis functionality: This involves retrieving and analyzing stock prices. - Option chain data management: I am specifically looking for functionalities like real-time option chain data retrieval, historical option chain data retrieval, and sophisticated analysis and visualization of the gathered data. - Creating an automated reporting system: In order to keep track of market conditions, an automated system for generating reports is essential. The ideal candidate should be expert in Python, comfortable with Excel, and have experience working with Angel Smart API. A strong background in financial mar...
...document attached for full scope of contest. I require a skilled professional in Excel to develop an automated dashboard for my business. The system will need to manage data entry, data analysis, and reporting - all automated. Key tasks will include: - Setting up a dashboard connected to Excel files with automation functionality. - Automating cleaning up and processing of data for analysis. - Developing reports with automatic generation feature. Regarding data visualization, the dashboard should be capable of generating pie charts, line graphs, and bar graphs as per the data analyzed. You should be proficient in Excel and familiar with data visualization techniques. Experience in automation and connecting Excel with other data sources will also be an adva...
I'm seeking a proficient data specialist who can successfully convert a CSV file into an XLSX Excel format. This conversion needs to be done meticulously to ensure optimal usability for sharing data with others. Key responsibilities will include: - Converting a CSV file into an XLSX format - Checking data integrity post-conversion - Ensuring the final layout is easy to understand and use for sharing with others The ideal freelancer for this job has extensive experience with Microsoft Excel and, more specifically, with CSV to Excel conversions. This is a one-off project, but I'm interested in a flawless output. Accuracy and meticulous attention to detail are critical for this task.
I urgently require a meticulous and professional proofreader, well-versed in Italian, to refine four not-safe-for-work (NSFW) landin...but not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Dutch. You will be provided 6 landing pages that you will need to open with a browser language set to Dutch. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is highly val...
I have a requirement for an advanced Excel specialist to develop a structured Gantt chart. More details will be provided to shortlisted candidates.
I am in need of an Excel operator to assist with data entry tasks. Ideal candidates would have extensive experience in Excel and be confident in their data entry abilities. Skills and Requirements: - Proficient in Excel data entry - Attention to detail - Experience with Excel formulas is a plus Application Details: Applicants should include their Excel experience details in their application. Please provide information about past related work, specifically focusing on data entry tasks in Excel. Tasks to be Performed: - Input various data points into Excel spreadsheet accurately - Handle high volumes of data entry - Maintain the integrity and accuracy of the data If this sounds like something you can handle, apply now and let's work...
As a travel business owner seeking to expand my business online, I am in need of a capable web developer. The ideal freelancer for this project will have: - An extensive background in web development, especially with travel websites. - Proficiency in integrating third-party travel APIs for flight and hotel booking capabilities. - The ability to create an aesth...effortlessly navigate the website, search for different destinations, access detailed guides, and make flight and hotel bookings. I require full integration with third-party travel APIs to ensure that my customers have a wide range of options. The main purpose of my website is to provide these convenient travel arrangements and information in one place. Not just an e-commerce platform, but also a helpful resource for all ...
...developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and handling large...
...developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and handling large...
I need a proficient translator for a document that's less than 1000 words from Spanish and French into English. Furthermore, the translation will need to be inputted into Microsoft Excel. Key responsibilities: - Translate document from Spanish and French to English - Data entry into Microsoft Excel Ideal Skills and Experience: - Fluent in English, Spanish and French - Previous translation experience - Proficiency in Microsoft Excel - Strong attention to detail - Ability to maintain confidentiality I am looking for a translator that can deliver accurate, high-quality translation and data entry with a sharp eye for detail. Please submit your bids with past related works and expected delivery timeline.
I'm...aiming for a modern aesthetic and it's crucial that you're capable of creating designs in this style. - Translating Concepts into Design: These designed shirts will be part of my marketing effort. I want to convey specific themes and messages, so you have to be adept in incorporating concepts into design. - Delivering Print-Ready Files: Ultimately, I require these designs to be print-ready. To excel in this job, you need: - Proven experience in graphic design, especially in modern styles. - An impressive portfolio showcasing your talent. - Strong understanding of how to design for print. - The ability to work collaboratively, take direction, and incorporate feedback. - Great communication and time management skills. I can't wait to see your portfolios ...
I require a skilled data entry specialist to handle an Excel sheet that involves the aid of typing in a combination of different data forms: Numbers, Text, and Dates. - The sheet you'll be working with houses 10 - 50 columns and rows, so attention to detail is paramount. Ideal skills include: - Excellent knowledge and experience in Excel - Ability to accurately and swiftly handle data entry - Proficiency in handling multiple data types This project focuses strictly on data entry alone and does not require any data analysis skills.
I am seeking a highly experienced .NET 8 trainer with advanced level expertise, capable of providing live online training. I was a full stack .Net...coding for 6-7 yrs. I am aware of the basic concepts but rusty at the moment so need to brush up the concepts. So, the training needs to be ground up. Ideal Skills and Experience: - Profound knowledge in C# programming language - Experience with .Net Core - In-depth understanding of APIs and Microservices - IIS hosting - CD via Team City and Octopus This is a fantastic opportunity for those who excel in making complex information easy to understand and engaging. If you are up for the task, connect with me and let's take this further. Please include references of your previous trainings as they will be considered during the sel...
...planning schedules, reduce wastage, and increase productivity. - Purchase Order Management: The platform needs a feature that simplifies purchase order creation and management. User Scale: - The MRP system will be used by less than ten users. Consequently, it needs to be user-friendly and intuitive, requiring minimal technical knowledge for daily operations. Optional: - We are currently using Excel to do Materials Requirement Planning, so a similar operation logic would be good. Your background should ideally include significant exposure to MRP system development, cloud-based platforms creation, and a keen understanding of inventory management, production planning, and purchase order management. Strict adherence to best practices in software development, a high degree of relia...
As an organisation, we're currently utilizing Excel 365 and have compiled sales figures by product that we'd like to further analyse. We're in need of an expert in Power BI who can help us convert our Excel data into meaningful Power BI visualizations. In essence, our main objective is to analyze our sales data comprehensively. Key Tasks: - Convert our Excel 365 sales data into Power BI - Design intuitive and interactive dashboards - Provide insights based on the data analysis Successful candidates should have: - Proven experience with Power BI and Excel 365 - An ability to create interactive visualizations - Strong analytical skills, particularly in sales data analysis
I'm looking for a proficient Excel expert with a strong background in production planning and forecasting. The task at hand involves revising and enhancing an existing production schedule, enabling it to track more complex parameters and deliver insightful reports. In particular, the freelancer will need to: - Incorporate production milestones into the schedule, with these milestones determined by both booked work values and forecasted values. - Integrate a system for tracking production based on specific booked work values, as well as forecasted values. - Use parameters such as Steel in Tons and kg, and Pipe fabrication in Diameter inch for forecasting production. The ideal candidate will have: - Profound knowledge and experience in Excel and its more advanced featur...
I'm in need of skilled developers to create a web and mobile application for my log sheet management system. The applications need to cater to data entry, approval, storage, and controlled access to records. Records should be accessible in PDF files, Excel, and Word formats, in a particular layout that I'll provide. Files and data to be stored in our own server which can be accessed via internet. Sample file format attached Key Features: * Compatibility: The mobile application must be compatible with Android devices. * User Roles: The application will host three user types - Data Entry Operator, Record Manager, and System Administrator. Each role has distinct responsibilities and access within the application that I’ll explain further down the line. * Design: The de...
Hi, I am a backend developer experienced in data extraction, web scraping, and automation. I guarantee: - Quality and Quantity - Fast delivery For more details, don't hesitate to get in touch with me. Thanks for your time. Cheers, Amr E.
I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...
I'm looking for well-versed Japanese food lovers to professionally review a collection of tour experiences for local specialty restaurants. This is specifically tailored for tourists visiting the area, hence your critiques should balance between informative and entertaining. Key responsibilities and requirements: - Providing detailed and helpful reviews of the food eaten on the tour and the tour experience itself. - Enhancing understanding of the local culinary scene and culture, attracting tourists to take part in the tour. - Accurate description of ambience, food quality, service and overall experience. - Exceptional writing skills, knowledgable about tourist perspective and keen interest in local food culture. Understanding of the tourist market is essential. Local k...
...and create an automatic ad campaign management dashboard. The dashboard should support multiple platforms including Instagram, Facebook, Kakao, Google Ads, and TikTok. Here is what I am looking for: - Comprehensive campaign management: The dashboard should be able to create, monitor, and manage ad campaigns across all platforms simultaneously. - Automate through APIs or macros: The platform should use APIs or macros to automate the campaign management. - Web-based dashboard: The dashboard should be web-based for easy access and management. Ideal Skills and Experience: - Experience in web development - Prior experience in ad campaign automation - Familiarity with APIs of Instagram, Facebook, Kakao, Google Ads, TikTok - Strong portfolio showcasing similar projects ...
I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...
...an experienced industrial engineer proficient in Excel to develop the capacity requirement component for a Manufacturing Resource Planning (MRP) system. The project involves integrating the capacity requirement section with the existing material requirements planning (MRP) part, creating a cohesive manufacturing resource planing MRPII system in Excel. Key Requirements: 1. Develop the capacity requirement component in Excel. 2. Integrate it seamlessly with the existing material requirements planning part. 3. Create a user-friendly interface for easy navigation. 4. Implement backstage functionality to simplify user interaction. Project Timeline: Completion within two days. Budget: Maximum budget is $100. If you are confident in your Excel skills and can ...
We have some clients who want to update their MsAccess 2003 databases. Using their existing tables. The person we are looking for will update the Queries, Forms, Modules, Reports and Macros to our requirement. A = Update the reconciliation of Bank, Customer, Vendor and other Accounts. B = Improve the tables and corresponding items in a database that continues to have “Record Deleted” errors. C = After updating the MsAccess 2003 database(s) convert them to MsAccess 2007. D = After testing the 2007 upgrades these databases will be converted to MsAccess 2010. => Please send us a pdf file of a Bank Reconciliation that you have created.
I require an Excel expert with in-depth knowledge in VBA for developing a comprehensive invoicing system. I have my qr scanner when I scan product it's shows products details automatically. I attached 5 list of products. Your Task: * Create VBA macros to automate system functionalities * Design invoice templates that encapsulate professionalism * Implement automation for data entry tasks Purpose: The overarching purpose of the invoicing system is to streamline the tracking of sales and payments, automatically calculate finance-related aspects, and generate professional invoices that accurately represent our company. Required Features: * Ability to generate insightful reports on business financial trends * Functionality to send automated reminders for payments * Integ...
