Excel customer database jobs

I am in need of a seasoned data entry professional who can attentively transcribe information from various online databases into Google Sheets. The role is strictly manual data entry. Skills and Experience: - Proficient with Google Sheets and similar spreadsheet management tools. - Past experience with database interaction, particularly online databases. - Must have a keen eye for detail to ensure accurate data transcription. - Excellent time management skills are essential as deadlines are strict. Although this position emphasizes manual data entry skills, experience in data cleaning and validation pave the path for optimal efficiency. The successful candidate must provide proof of prior similar projects. Your ability to maintain high standards of accuracy and confidentiality ...

I'm in need of a detail-oriented professional who can assist with a specific data entry task: data processing. My database file needs clean-up, specifically, the removal of duplicate entries. Freelancers should have experience in similar tasks and be skilled in data processing, data cleaning, and familiarity with database file formatting. The main operation will be identifying and removing duplicated data fields. Accuracy, attention to detail, and reliability are essential for this job.

I need an experienced Virtual Assistant to handle daily data processing tasks in Excel 2019. Ideal Skills and Experience: - Proficient in Excel 2019 - Strong data entry, data cleaning, and data analysis skills - Prior experience in a similar role - Ability to work in a timely manner Tasks: - Daily data entry: You'll be required to input new data into the Excel spreadsheet. - Data Cleaning: Ensuring data is free of errors or duplicates. - Data Analysis: Performing necessary analysis on data entered. The ideal candidate will be detail-oriented, have excellent communication skills, and be able to work independently.

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...

I am seeking a seasoned salesperson with a strong background in CRM software, particularly those that are used for customer service functions. Your main responsibilities will be selling our CRM software to large corporations. Requirements: - Extensive experience in CRM software sales. - Deep understanding of customer service-oriented CRM tools. - Proven record of selling software to large corporations. Those who can demonstrate a solid track record of high value sales within this specific arena will be highly considered. This role requires an assertive, professional, and dynamic individual who is driven by beating sales targets. Your passion for customer service technology should shine through and inspire potential clients.

Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from...financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal years. Requirements: - Certification in financial analysis. - Experience in creating consolidated financial statements. Note: - This pro...

...experience and boost sales. Your expertise in Shopify theme customization and performance optimization is crucial. - Web Performance and Speed: I'm looking for someone who can ensure that the website's speed and performance are optimized for a seamless user experience and to improve search engine rankings. The essential features include: - Product search and filtering - Customer reviews and ratings - Secure payment gateways - Customer Experience - Integrations with necessary tools for marketing and analytics. Ideal candidates should have: - Proven experience in developing successful Shopify websites - Strong understanding of ecommerce principles and user experience - Expertise in performance optimization and speed enhancement - Good communication skills and a...

...tasked with creating engaging and SEO-optimized content for the site. - **SEO Optimization:** You'll need to possess a strong understanding of SEO practices to ensure the website ranks well in search engine results. Marketing Channels: - **Social Media:** Your role will include managing the social media profiles of my E-commerce store. You'll be expected to create engaging content, respond to customer queries, and grow the social media following. - **Search Engine Advertising:** The ideal candidate should have experience in managing advertising campaigns on search engines, particularly Google Ads. Your aim will be to drive traffic to the website and increase sales. This role requires someone who can balance the technical aspects of website management with the creativi...

I'm looking for someone to help me organize and input my personal finance data into an Excel sheet. The Excel sheet is intended to be a combination of both summary and itemized details. This means that your work will involve both categorizing transactions, and summarizing them by month or year. This project requires a good understanding of personal finance, as well as data entry experience. The ideal candidate should be able to work with sensitive financial information and must be able to keep this data confidential. If you have experience in personal finance or accounting, and can handle this kind of detailed data entry, I'd love to hear from you.

I require a talented graphic designer and web developer with proficiency in modern design. I am launching a website to sell medical chairs an...addition, the creation of a sleek, modern 4-6 page website that appeals to my clientele is crucial. Your responsibilities: - Design an aesthetic and modern logo - Develop a 4-6 page website with modern and sleek design elements - Implement an online payment system and customer review option Ideal expertise: - Experience in graphic design particularly in creating modern logos - Web development experience, especially e-commerce websites - Understanding of secure online payment integration - Capability to implement a reliable customer review system - Able to successfully setup SEO I'm excited to see your creative solutions to thi...

...incorporation of sophisticated data tracking capabilities and a distinctive coupon generation feature. Key Aspects: - An intelligent data tracking system should be in place, capable of performing: - Customer behavior analysis, to help predict purchase patterns and tendencies. - Inventory monitoring, to keep a watchful eye on stock levels and alert for required replenishment. - Sales tracking, to keep an accurate record of the business's sales. - A unique coupon generation feature allowing customers to enter a code to avail of particular discounts or rewards. The design should be customer-friendly and intuitive. Skills And Experience: - Strong experience in web development and eCommerce platform creation. - Expertise in creating complex, smart data tracking...

...entry project. The task primarily involves inputting text and numeric data into an Excel spreadsheet. Key tasks include: - Data Entry: You would be required to input data across multiple columns and rows. This data consists of a mix of text and numbers. - Basic Arithmetic: In addition to the data entry, I will need some basic calculations added to the spreadsheet. This includes performing simple arithmetic like sum and average calculations across different columns. Ideal skills: - Proficient in Excel: You should have a strong understanding of Excel functions and formulas. - Attention to Detail: As this is a large dataset, precision and accuracy in data entry is key. - Basic Arithmetic: Familiarity with common Excel calculations for summarizing data. Pleas...

...for two types of users: customers and admins. Key Features: * The website should provide customers with an easy way to book slots. While booking, they will need to provide their names and contact numbers. * There should also be an admin-friendly interface to manage bookings. User Experience: * Both interfaces have to be user-friendly and intuitive, promoting seamless interaction between the customer and the admin. Website Specifics: * The website is aimed at offering 1 to 5 types of services. Hence, it should be able to accommodate this range. Ideal Skills and Experience: * Experience in web development, particularly with booking or scheduling systems * Proficiency in user interface design and user experience * Strong coding skills This project requires a combination of ...

I'm seeking an experienced videographer to assist in the creation of a customer-focused video. The video should be concise and engaging, falling within the 1 minute range. The ideal freelancer for this role will have: - Proven experience in shooting and editing testimonial videos - A strong portfolio of previous work in a similar genre - The ability to work with customers and guide them appropriately for their testimonial segments - Skills in editing and post-production to create a professional, engaging end-product - Excellent communication skills and a collaborative approach If you're a videographer with a keen eye for storytelling and a passion for highlighting customer perspectives, I'd love to hear from you.

...visually appealing and functional e-commerce store. Key Features Needed: - I consider customer reviews a vital aspect of this site as they will help build trust and credibility with potential customers. Ideal Skills and Experience: - Proven experience with Shopify website development - Strong e-commerce design and development skills - Previous experience in integrating and customizing e-commerce features - Good understanding of user experience and conversion optimization - Ability to deliver a website that is responsive and visually appealing If you have experience in building Shopify websites that cater to both digital and physical products, with a focus on increasing sales and integrating customer reviews, I'd love to hear from you....

I'm seeking an experienced developer to assist in optimizing database speed for my Node.js website. Key tasks: - Conduct initial review of current setup, hosted on a Hostinger VPS with a configuration of 16GB - Advise and implement changes to improve response time, usining knowledge of different hosting platforms such as Amazon Web Services, Google Cloud Platform or Microsoft Azure. - Familiarity with MySQL as a database management system is a must. Ideal candidate would possess keen problem-solving abilities, strong knowledge in database management and previous experience with Hostinger VPS. Experience is optimizing Node.js websites is advantageous. Please provide examples of similar assignments in your proposal.

...create payment links within my website. Your role will heavily rely on familiarity with Payoneer API and specifically leverage this resource: - Integrating the resulting code on my clickfunnels html, making it an adjustable feature On the payment page, I would like to capture various types of information: - Customer contact details - Customer preferences - Specific product details The ideal candidate for this project has experience in website development and has specifically worked with Payoneer API and ClickFunnels. I am looking for someone detail-oriented, since capturing the right information at payment is key for me. Experience in building payment pages for eCommerce, particularly for digital products, will be valuable

talk Bot using Generative AI platform and RAG for knowledge base, knowledge base on pdf file we can add (add, delete, delete), using python, and can integrations with omni channel like WhatsApp business, telegram, or bind to a website, solutions should be in bahasa Indonesia users

I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.

I need an experienced photographer specializing in product photography to help with capturing images of products for an e-comme...capturing images of products for an e-commerce site. Ideal candidate should have: - Proven experience in product photography - Familiarity with e-commerce photography trends - Ability to work efficiently with a high volume of products We're looking to photograph between 11-50 products which might include a variety of sizes, shapes and materials. These images are crucial to our online store and customer experience, so we're looking for someone who can deliver high-quality shots that highlight the product's features and appeal to our target audience. If you're a talented product photographer and have the relevant skills and experien...

I am experiencing an undefined error while fetching user data from my database. Adding small details like 20-30 rows takes a long time to reflect on the website. I believe the problem lies with my current shared hosting server, which isn't performing to the expected standards. Specifically, I need: • Diagnosing and solving the undefined error occurring during data fetching • Migrating to a more reliable and faster server • Live on-screen share during the entire migration process The ideal candidate should have: - Proven experience in solving database issues - Knowledge of efficient and secure server migration processes - Excellent communication skills to explain step-by-step actions during a live screen share.

I require a dedicated and professional developer to craft an e-commerce website for my yoga business. The ideal platform will have the following features: - An online store that's easy to navigate, reflecting a clean and effective layout. - Customer review section to facilitate transparent and honest interaction with our clients. - Convenient product search/filter function to allow customers to quickly locate desired items. We'll be retailing yoga mats, clothing, and other related accessories. As such, the right candidate should have prior experience in creating e-commerce platforms that handle such inventory, effectively categorizing them to make discovery easy and intuitive. In terms of transaction handling, we plan to incorporate the following payment methods: credi...

I'm in need of a talented designer to create a logo for my website, www.lunchboxes.online. The logo will be the face of my brand for our social media, email marketing, and customer correspondence. The design style I am looking for is 'Fun and playful', and I would like it to embody the essence of bright and vibrant colors. Key Requirements: - The logo should be fun and playful, suitable for a site that focuses on lunch boxes and storage containers. - Incorporating elements related to food and storage containers is vital. - The color scheme should be bright and vibrant, reflecting the style of the logo. - The shape must not be square and bulky but rather fit comfortable at the top of the website page. Ideal Skills and Experience: - Proven experience in designing lo...

I'm looking for a Zoho expert who can help me with improving my inventory management, streamlining sales and customer relationship management, and increasing overall efficiency and productivity. Looking to build a template platform that will be recreated across multiple companies. Key Responsibilities: - Assist with data import/export in Zoho Inventory - Customize fields and layouts in both Zoho Inventory and CRM - Integrate Zoho Inventory with my existing CRM system and sales tracking system Ideal Candidate: - Proven experience with Zoho Inventory and CRM - Strong understanding of inventory management principles - Experience in customization and integration of Zoho systems - Excellent communication and problem-solving skills Your assistance will significantly help me to bet...

...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...

...with a unique code that they can provide to their fans. When the code is used to buy product, I must be able to track/tally orders by influencer (by their code). The code also provides a discount on the first use by each new customer. 3. Finish product setup. We will start with two products (one is already shown) but need to have two more placeholder products hidden from view for easy activation when we add products 4. Set up the option for customers to subscribe for automatic shipments later (at a % discount) 5. At checkout we want a popup that asks if the customer would like to "round up" their purchase and/or donate a fixed amount extra to the school we are generating funds to support SKILLS & EXPERIENCE: - Deep knowledge of Shopify's platfor...

...above), and with the lowest price and the shortest delivery time frame to the UK (4 to 7 days). 2. Once you have identified the best products, import them into Dser and edit them before importing them into Shopify. It is crucial not to push products to Shopify without first editing them on Dser, including the SEO-optimised content in each product description. Add videos to the products for better customer engagement. Additionally, balance the different brands and avoid populating a category with mainly one brand. 3. Import reviews and optimise SEO, as these are essential. 4. Avoid listing products with non-English language descriptions, images, or videos. 5. Also, do not list products with suppliers like AliExpress or Alibaba shop details and suppliers' websites, shop nu...

I'm in need of a graphic designer that is experienced in creating modern, minimalist logos. The project involves designing a logo for my new business, TCL Travel. It is a travel company offer visa and travel services to customer . It is mainly international travel Please create one nice logo The desired color scheme is blue and gray. The logo must be able to represent the business well and should be original. Effectively, it should convey quality, trust and professionalism while also exuding some excitement of travel. Ideal Skills: • Graphic Design • Logo Design • Illustrator • Experience with modern and minimalist designs. Looking forward to seeing your portfolio and potentially working together.

...experience handling a variety of administrative tasks for a part-time role. The primary focus will be on efficient email management. The ideal candidate will need to effectively perform the following tasks: - Act as the first point of contact with my customers. - Efficiently respond to customer inquiries via email. Skills that would make a freelancer successful in this role include: - Previous experience in a customer service or administrative role. - Excellent communication skills. - Experience in customer inquiry response. - Familiarity with email management tools and systems. - Ability to work independently and efficiently. - Strong attention to detail, - High level of organization. As this is a part-time role, having a flexible schedule will be a considerabl...

...the ability to include customer's names or other relevant information. - The intended audience is our regular customers, so it should aim to strengthen the sense of community and loyalty they have towards our restaurant. - we want to change Ideal Skills and Experience: - Proficiency in AI-generated video production, particularly in creating personalized content. - A keen understanding of customer engagement and retention strategies, especially in the context of the hospitality industry. - Strong creativity and communication skills to effectively convey the desired tone and message. It should be customizable for me to be able to post and change the message. We would like to show our specials and how the restrauant work. If there is a leaning avatar that would be helpful...

I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and manipulation of complex datasets. -...

I'm looking for a skilled professional to create a robust AI-driven marketing program. This project aims to optimize the marketing database, generate sales, and increase our revenue. Key requirements include: - Building an AI system for data verification to ensure high-quality, accurate information. This includes email verification, phone number verification, and address verification. - Implementing an AI program to sort and segment lists for each campaign. It should consider the following criteria: - Demographic data: Utilizing data such as age, location, gender, and income level. - Customer behavior data: Tracking and understanding customer interactions with the business, such as preferences, buying habits, and engagement. - Purchase history data: Analyzi...

? **Join Our Team as a Customer Service Agent!** ? Are you passionate about providing top-notch customer service and ensuring smooth contract management? We're looking for a dedicated individual to join our team on a 6-month contract, with the potential for a permanent position if you excel. **Responsibilities:** - Handle customer calls to schedule deliveries and installations. - Coordinate appointment schedules with installers and customers. - Follow up with customers post-installation to gather feedback on service quality. - Communicate effectively via email to confirm appointments and provide necessary information. **Benefits:** - Competitive monthly salary of $400 with additional bonuses of $50 $75 for meeting monthly goals. - Earn $3 for every insta...

I'm looking for a talented paid media speci...Meta and Google Ads - Optimizing paid search campaigns for high visibility - Managing organized and appealing display advertising Our objective is to generate leads and catapult sales that would drive significant footfall and recognition. The targeted outcomes being a marked increase in customer engagement and consequently, our bottom line. We intend to radiate our content spotlight on our impeccably curated menu items and spectacular promotional discounts, intending to not only draw in a loyal customer base but also immerse them in our food story. Ideal Skills: - Paid Media marketing experience - Google Ads expertise - Meta Ads proficiency - Profound understanding of search optimization strategies - Display advertising ...

My WordPress website is currently displaying "Error establishing a database connection" and I can't access the admin dashboard. I need an experienced freelancer with deep expertise in WordPress troubleshooting and database issues resolution. Tasks will include: - Diagnosing the cause of the database connection issue - Fixing the problem to get the website back online - Ensuring all website features are functioning as they should post-fix I'm using a Cpanel on Godaddy for hosting. So, familiarity with Cpanel and Godaddy is a requirement for this task. Also, I'd prefer someone with immediate availability as this is a high-priority issue. Skills required: - Advanced WordPress proficiency - Strong understanding of databases - Experience with ...

I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link

I am in need of a proficient website developer with a minimu...A reference from a previous job is mandatory for consideration. Here is what I'm looking for: - Development of two e-commerce websites: You must be well-versed in creating engaging and responsive e-commerce websites tailored to my needs. - Main functionalities: The websites should have a user-friendly online payment system, a product listing with detailed descriptions, and a platform for customer reviews and ratings. - Design preferences: I prefer a clean and professional look for the websites. Your portfolio should exhibit your ability to design in this aesthetic. Pay will range from 250-500USD. Please ensure you provide a detailed proposal showcasing your experience and capabilities relevant to my projec...

I'm looking for a professional secretary to manage and handle all of my phone calls using our dedicated phone system software. The selected candidate must be highly organized, courteous, and must be able to handle high volumes of calls in an efficient and effective manner. Key Responsibilities: - Answering phone calls -Making app...concise messages on my behalf when necessary. Ideal Skills and Experience: - Previous experience as a secretary or in a similar role - High level of professionalism - Excellent verbal communication skills - Proficient with phone system software - Detail-oriented and superb organizational skills This position does require English language skills, knowledge of specific software or systems, or customer service experience other than the aforemen...

I'm se... multi-tab product pages for extensive product information Functionality Enhancements: - Synchronizing the website with our social media platforms for simple customer engagement - Developing a loyalty program to encourage repeat customers - Creating a custom checkout process to simplify purchasing and improve conversion Additional Features: - Incorporating year/make/model/submodel/engine/transmission search filters to aid customers in product selection Ideal candidates should have significant experience in Shopify website updates, particularly in design modifications and functionality additions. Understanding of retail customer journeys and engaging design concepts is key. Candidates with experience in integrating innovative features like search filters wil...

Looking for a proficient developer to build a same website with functionalities. is a wholesale printer and I already have an account with them, once we have their website built, we will then integrate their API to our website so the orders placed on our website will be goes to my account on and they will print according to order and deliver to my customer with our name and address. Key Requirements: - E-commerce platform and Portfolio showcase. - Integrate APIs: Payment gateway and Social media login, along with the specific Service provider's API. - Tech: Flutterflow Utilize Flutterflow and API integrations to carry out these tasks. Ensure smooth, seamless transactions by integrating PayPal and Stripe as the payment gateway, allowing customers to make purchases

I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyze the extracted data - Devel...

Aiming to considerably optimize my website's performance as well as improve its visibility on Google, I'm actively seeking the expertise of a seasoned SEO specialist. I need assistance with on-page and off-page optimization, keywor...enhance my website's visibility on search engine results. Previous SEO activities have been conducted on the website, therefore, a familiarity with analyzing past SEO efforts would be beneficial in managing, improving and, where necessary, changing these strategies. Ideal skills include: - Proficiency in SEO tools and software - Solid understanding of performance marketing, conversion, and online customer acquisition - Excellent keyword research skills - In-depth experience with website analytics tools - Knowledge of ranking factors and ...

I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.

...specializing in property and business loans overseas. The website should support multiple languages and feature a multi-currency loan calculator, secure loan application processing, and user account management. Objectives: Develop a clean, professional-looking website using WordPress. Include key functionalities such as a loan calculator, multi-language support, secure application forms, and customer login areas. Required Features: Multi-currency loan calculator Secure application processing User registration and management Responsive design for all devices SEO-friendly structure Skills Required: Proficient in WordPress, PHP, HTML, CSS, and JavaScript Experience with financial services websites is a plus Ability to implement multi-language support Budget and Timeline: Please...

Thrilled to seek an e-commerce assistant with 3+ years experience for our thriving online retail business focused on clothing and accessories. The ideal candidate will have sharp skills in: - Product listing - Inventory management You will be entrusted with the responsibility of order processing and fulfillment, ensuring a seamless customer experience. Excellent customer service and support are fundamental to this role. Our goal is to ensure our product listings are accurate and up-to-date, and our inventory well managed. Your journey in online retail awaits with us!

I'm in need of an experienced US telemarketer for a cold calling market research campaign to gather feedback on Pool Service companies (business statistics, size, etc.) and software usage. Your tasks will include making calls, asking targeted questions, and gathering and reporting certain information in Google Sheets. Required: Availability from 9a-5p EST on 5/13 and 5/14, ability...Experience: - Background in US telemarketing - Previous experience in conducting cold feedback phone calls - Strong communication skills - Attention to detail for accurate recording of feedback Please note, the software feedback is the main goal here, not lead generation or sales promotion. It's essential that the freelancer can handle calls professionally and maintain a high level of c...

We are an EdTech startup seeking highly motivated Sales Development Representatives to join our team. As a Sales Development Representative, you will play a pivotal role in driving our sales efforts and expanding our customer base. Your main responsibilities will include prospecting, qualifying leads, and setting up appointments for our sales team. Key Responsibilities: - Understanding customer needs and offering solutions and support. - Researching potential leads from business directories, web searches, and digital resources. - Closing sales and working with the client through the closing process. Ideal Candidate: - Proven track record in both B2C and B2B sales, specifically in selling digital products. - Excellent verbal and written communication skills. - Experience i...

I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.

I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos To find all the state outlines, you will need to Googl...

Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled...