Excel macros simplify processes work jobs
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I need an expert in Shopify to assist and guide me through customizing my store significantly. I'm looking for someone who can work closely with me, explaining the processes, and potentially carrying out the changes themselves. As this will be an ongoing project, we'll be adding many categories. To ensure you're the right fit for this role, please provide a list of stores you've worked on in the past. Key tasks include: - Extensive customization: We need to go beyond the standard Shopify theme and make significant changes to the store design and layout. - Adding products and categories: You'll be responsible for adding and organizing a large number of products and categories. - Setting up payment and shipping: Ensure a seamless, user-friendly experie...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
Please Sign Up or Login to see details.
...ticket purchasing feature, which is currently non-functional - Determine the cause of the issue The website was built using WordPress and the payment functionality is managed by the WP Travel Engine plugin. While there are no error messages displayed to users, the system does not allow for successful ticket purchases. Your role is to fix this issue and ensure that the payment and ticket purchase processes are fully operational. Ideal candidates for this project should have: - Extensive experience in WordPress development - A deep understanding of the WP Travel Engine plugin - Strong debugging skills - Ability to identify and resolve issues in a timely manner Please get in touch if you feel you have the skills and experience to identify and rectify the issues with the ticketin...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...
MUST MODIFY CURRENT LOGO! I A'M NOT LOOKING FOR A NEW LOGO. SEE ATTACHED FILES. ALL OTHERS WILL BE REJECTED. I'm looking for a skilled graphic designer who can simplify our current logo for me. This version needs to be reduced to a basic outline and designed in a minimalist style that's ideal for embroidery on t-shirts and hats. The logo may be repositioned to the right side, and the company name on the left side to fit the dimensions. The tag line "Flow Freely with Spotless RV Tanks." can be removed or relocated if needed for fit. Key Requirements: - The final design should be 2-1/4" tall x 4-1/2" wide. - You should simplify the logo while ensuring that the main elements - the company name and the symbol - are still clearly recognizable. ...
DA upto 40 DR upto 60+ TF upto 40+ CF upto 35 UR upto 70+ PA upto 35+
Please find below the hourly rates for your approval.
I have ongoing work related to our previous project 'Modern Logo Design Contest - Sunrise Management'
As the project owner, I need an experienced IT professional, proficient in working with SAGE, to develop an in-house program which will streamline the process of flattening work tickets. This involves: - Retrieving data from SAGE This process will require you to directly interface with SAGE and accurately pull the necessary data for the ticket flattening process. - Merging Similar Work Tickets The main operation to be performed on the data retrieved is to flatten work tickets by merging similar operations. This involves efficiently condensing the retrieved data by combining similar tasks into one operation. - Pushing Merged Data Back to SAGE After the operations have been merged and condensed, the data should be pushed back into SAGE where it will ...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but th...
...Identify and fix bugs to ensure the stability and reliability of the services. - Develop and maintain internal tools to streamline development processes. - Increase test coverage to maintain high-quality code standards. Requirements: - Strong proficiency in TypeScript and Node.js. - Experience with microservices architecture. - Familiarity with developing, testing, and debugging microservices. - Ability to work independently and as part of a team. - Strong problem-solving skills and attention to detail. What We Offer: - Detailed information about the microservices and project scope during the introductory call. - A collaborative and supportive work environment. - Opportunities for professional growth and development. If you are passionate about building efficient...
I'm looking for a CRM automation expert to optimize and automate our daily processes in Monday.com. The aim is to streamline our operations, increase data accuracy, and improve task allocation in order to enhance efficiency and productivity. Key Requirements: - Automation of Sales Pipeline Management - Automation of Task Management - Automation of Communication Tracking Current Pain Points: - Manual data entry errors - Inefficient task allocation Expected Outcomes: - Streamlined processes to reduce manual effort - Increased data accuracy and reduction of errors - Improved task allocation and productivity Ideal Skills and Experience: - Extensive experience in CRM automation, particularly with - Proven track record in process optimization and efficiency improvements -...
As an established business with an existing system, I am seeking a professional to help streamline our supplier onboarding and product uploading processes. The primary challenge we face is handling a large number of SKUs effectively - we typically deal with between 10,000 and 50,000 on a regular business. Key Project Needs: - Improve SKU processing speed and accuracy. - Streamline supplier onboarding process. - Make it easier to manage large volumes of SKUs. The ideal candidate will have previous experience in SKU and/or supplier management, process improvement, and working with high volume product management. Expertise in our current system would be a beneficial, but is not a necessary requirement. You should be driven by efficiency and comfortable working with large data sets....
I'm in need of a skilled programmer who is adept in Python, Java, and C++. Your tasks will span database management, working with algorithms and data structures, and user interfa...Database management: Experience in handling large datasets, querying databases in an optimized manner, and ensuring the integrity and safety of the data. - Algorithms and Data Structures: Demonstrated understanding of algorithms and data structures. The ability to use this knowledge to solve problems efficiently is a must. - User Interface Design: Skills in creating intuitive user interfaces that simplify user interaction with complex datasets and algorithms. Regardless of the platforms you've previously worked on, I believe your proficiency in these areas will be the key to successfully comp...
I have a data in my excel sheet. They are from column A - J, 10 column, 4137 rows of data. The data are in mixed string format, which means all long text mentioning about their company. I need to do some data analysis. So i need help in doing NLP for those data to clean and filter the data. I need help in doing NLP for the data and provide me the python code use to do the analysis, I will need like the summaries of the text. For example, for column Funder Purpose the row contain info like "Since the business started, we have been fully relying on our internal fund. We plan to utilize this fund to support our working capital requirement and operating expenses. Based on our business growth progress, we are confident in our repayment capacity." I want the summary as "...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output f...
I'm in need of a freelance writer to craft an engaging, informative article on boardrooms. The key aim is to provide general information for the public. Key Requirements: - The article should cover a detailed explanation of the full function of a boardroom. - It must be educational...concepts easily understandable. - I will need a turnaround time of 4 days. - Needs to be between 1,500 and 1,800 words - Must use 3 to 5 references in the article that will be provided upon awarding of the project. Ideal Skills and Experience: - Proven experience in creating engaging, informative articles. - Good understanding of business terminologies, specifically boardroom functions. - Ability to simplify complex concepts for a general audience. - Timely delivery and open to feedback for poss...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
1) Configure the OpenVPN CloudConnexa Client on TP-Link (OpenWRT) so that other CloudConnexa Clients can access the devices behind the router. For example (see attached image), CloudConnexa Client should be able to access and 92.168.17.20. 2) Document required changes in a README file.
I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.
I require an adept senior-level Chartered Accountant/Chief Financial Officer (CFO). My ideal candidate will maintain responsibility for: - Rigorous financial reporting - Diligent budgeting and forecasting - Effective cash flow management -Supervision of existing staff to facilitate GAAP processes and timely monthly close processes A deep and demonstrated understanding of auto parts industries is non-negotiable. With your experience, you will add significant value to my company's financial standing and strategic growth. Proven track record in similar roles is highly valuable. You will be working remotely, using the data we provide and other data that you gather to advise our leadership team on all financial matters and the financial health of the company
I'm facing an error while deploying my project during its application start-up. The project is currently being deployed to an unspecified environment. I require an experienced deployment specialist to troubleshoot and resolve the deployment issue. Key requirements: - Proficiency in deployment processes - Strong experience in resolving deployment errors - Ability to work on unspecified deployment environments Your expertise in this area will be vital in getting my project up and running successfully.
I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on targ...
I am seeking an experienced Python web application developer to construct a user-friendly platform for cryptocurrency airdrop and telegram integration. The final product should be similar to no...application developer to construct a user-friendly platform for cryptocurrency airdrop and telegram integration. The final product should be similar to notcoin. Key requirements: - User registration and verification. - Airdrop distribution capabilities. - Integration with Telegram. Professional skills and experience: -Familiarity with Python. -Past work demonstrating ability to create robust web applications. -Understanding of cryptocurrency airdrop processes. Applicants should include their relevant experience in their applications. Working examples of similar projects will be hi...
I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data import for softw...
I am looking for a freelancer who can help me implement a meta ad service on Facebook Ads. Target Audience: - I have a specific demographic in mind for my ads. Budget: - My expected budget for this service is less Skills and Experience: - Experience in implementing meta ad services on Facebook Ads - Strong understanding of targeting specific demographics - Ability to work within a limited budget
I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Estimated time of arrival (ETA)...
I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.
I'm looking for a highly skilled developer to construct a well-integrated business portal for me, which includes website and apps for both Android and iOS. The portal should be able to efficiently enhance productivity and streamline business processes. Crucial components to be developed include: - Customer Relationship Management (CRM) with key features such as contact management, sales forecasting, and lead management. - Enterprise Resource Planning (ERP) with essential functions such as inventory management, order management, and supply chain management. - Financial and taxation modules. - Human resources and marketing modules. - Service and productivity modules. An ideal person for this job should have: - Proven experience in creating and managing business portals with ...
...provide exceptional user experiences. Our team is dedicated to pushing the boundaries of technology to deliver top-notch solutions to our clients. Job Description: We are seeking a talented and motivated Part-Time iOS Mobile App Swift Developer to join our team. In this role, you will work closely with our development team to design, develop, and maintain iOS applications using the Swift programming language. This position offers the flexibility of working part-time, making it ideal for candidates looking to balance work with other commitments. Key Responsibilities: Collaborate with the development team to define project requirements and objectives. Design, develop, test, and maintain iOS applications using Swift. Ensure the performance, quality, and responsiveness of...
...and be easy to understand and play. - Primary Goal: The game's core objective is to entertain the players. It should be engaging and provide a satisfying gaming experience. - Preferred Genre/Style: The game falls under the category of hand and mind coordination. This indicates that the game will challenge the player's ability to quickly and accurately coordinate their hands with their mental processes. Ideal skills and experience for this job include: - Proven track record of designing successful mobile games with mass appeal - Proficiency in creating intuitive and user-friendly interfaces - Strong understanding of game design principles, particularly those that pertain to hand and mind coordination games - Ability to collaborate effectively with the development team t...
I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus
...skilled and experienced business lawyer based in California. The main task at hand is to file a lawsuit already prepared in the Superior Court for a case involving fraud. The lawsuit will not be served initially. You must be licensed in California or please don't apply. Requirements: - Expertise in business law: You should have a deep understanding of California business laws and Superior Court processes. - Experience in fraud cases: Previous experience in handling fraud cases is highly desired. - Strong litigation skills: The ideal candidate should have a proven track record in litigation, particularly in the Superior Court. - Excellent communication: Clear and concise communication is crucial in this role, as you will need to explain complex legal matters to me and repre...
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.
...require a 3D diagram based on a structural floor plan for a metal work project. This diagram will be used for construction planning, so it needs to be detailed and accurate, reflecting the specific requirements outlined in the provided drawing. Key requirements include: - 3D visualization of the structural layout - Conversion of the floor plan to a 3D model - Inclusion of basic labels and dimensions The final output is expected in SKP format, for easy integration with our existing systems. Ideal candidates for this project should have experience in: - 3D modeling, specifically for construction planning - Proficiency with SketchUp - Ability to translate 2D drawings to 3D models with accuracy - Familiarity with metal work projects would be an advantage. Your role in t...
...features of an ERP system. The animations will demonstrate the system's interaction with people and various business processes. Key Points: - The animations should focus on key areas of the ERP system including user interface and interaction, data processing, reporting, and integration with other systems. - Specific use cases to be covered include: - Ledger accounting - Reporting mechanisms - Data flow within the system The ideal candidate for this project should have a strong background in: - 3D animation - Experience in creating engaging and informative business animations - Understanding of ERP systems would be an advantage, though not mandatory - The ability to work within a quick turnaround time is highly desirable. This project offers a great oppor...
We are a mortgage broker who needs an assistant to manage daily tasks, primarily focusing on document preparation and client communication. Key responsibilities: - Making phone calls to new leads to understand ...who needs an assistant to manage daily tasks, primarily focusing on document preparation and client communication. Key responsibilities: - Making phone calls to new leads to understand their goals and financial situation. - Preparing and processing loan applications daily - Effective communication with clients Ideal skills for this job would include a strong understanding of loan application processes, excellent attention to detail, and superior communication skills. Mortgage brokering experience is required. For time zone reasons, this role must be located in the Ph...
I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into compr...
I am on the lookout for a well-versed spirits consultant with a vast understanding and experience in liqueur production. My interest is not limited to any particular bra...liqueurs from a general perspective. - Suggestions, advice, or methods for improving production efficiency without compromising quality. As a qualified applicant, you should: - Hold a degree or certification in food sciences, chemistry, or related fields. - Have solid experience in the spirits industry, particularly in the production of liqueurs. - Show an understanding of scaling production processes. - Demonstrate adeptness at identifying and resolving production challenges effectively. Your expertise will greatly contribute to increasing both the efficiency and quality of our product, as well as my personal ...
I am on the hunt for an operations manag...with a major focus in blockchain. Ideally, you will be able to help in: 1. Managing our supply chain effectively, 2. Coordinating team efforts, and most importantly, 3. Optimizing our processes. An additional plus if you have experience in the finance sector, as we intend to apply blockchain technology in this field. The main task will be integrating Web3 technology into our existing website to further enhance its operational efficiency. The perfect candidate would be someone who has a solid understanding of decentralized applications, Web3 technology, and prior experience in overseeing operational processes. Your skillset and expertise will be highly valuable in guiding our team to deliver the best results in a dynamic and fast-p...
I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...
...management, ideally within the consumer electronics, manufacturing, or construction industry. 2. Bachelor's degree in Mechanical or Industrial Engineering, Supply Chain Management, or a related field strongly preferred. 3. Fluency in English and strong technical Mandarin abilities are required — both written and verbal. 4. Ability to work independently and prioritize tasks in a fast-paced environment. 5. Knowledge of international shipping and logistics processes is a plus. Key Responsibilities: 1. Act as the primary point of contact for designated client accounts, understanding their needs and requirements. 2. Source materials and products from various platforms and suppliers, focusing on quality, cost-effectiveness, and timely delivery. 3. Negotiate pricing, ...
I'm a graphic designer looking for freelance opportunities. I have a strong background in creating visually appealing designs for various purposes. I am proficient in using design tools and software to deliver high-quality work. I'm looking forward to exciting projects that challenge my creativity and expertise.
I'm looking for an experienced Python coder to tackle two key aspects of my project -...**Automation**: The second crucial aspect is automation. I'm looking to automate certain processes in my project that involve database queries. Proficiency in Django will be necessary here. Ideal candidates for this project would have: - **Strong Python Skills**: You should be well-versed with working on data analysis and automation tasks using Python. - **Experience with NumPy & Django**: Proficiency in these frameworks is a must. - **Data Analysis Background**: A background in data analysis will be a plus, helping you to not only automate but also interpret the data effectively. Your deliverables will be well-documented Python scripts that successfully handle data analysis and...
