Macro cleaning excel jobs
I require an expert with a solid background in Excel and advanced problem-solving skills. Your tasks will include: - Cleaning and formatting sales, financial, and survey data. Please ensure accuracy and consistency in our data sets. - Calculating relevant statistics and metrics from this data. I entrust your knowledge of appropriate statistical methods to use to bring us meaningful results. - Creating dynamic charts and graphs to visually represent our data. Your ability to present information in an easily understandable manner is crucial. The main goal of the data analysis is to uncover trends and patterns that will enable us to make data-driven decisions. Therefore, strong analytical skills and business acumen are a must. Experience with similar projects is highly desirab...
I require a skilled data analyst with proficiency in Python, tasked with creating an interview scheduling system for bus lane interviews. The scope of the job includes: - Data cleaning and preprocessing of the information involved in the project. - Analysis of relevant data using python - Integrating interviewer details, interview time-slots, and each corresponding bus lane location into the scheduling system. The ideal candidate should have thorough experience in Python-based data analysis, and is able to construct intuitive organizational systems. A background in scheduling and data organization is an advantage. Please, only apply if you can demonstrate similar past projects or pertinent skills. You have to make a program which will give output as shown in sample sheet, the out...
I'm in need of a professional who can successfully convert my Excel sheet into a stand-alone Windows-compatible program. The key functionalities to be retained from the Excel sheet within the new program are: - The ability to manually input and extract data - Execution of all existing formulas and calculations - the program should be user friendly and can not be copied without special permission - a good design with my company logo is essential Ideal candidates should be experienced programmers with strong knowledge of data management and task automation, as well as an understanding of Excel functionalities. Familiarity with data analysis will also come as an advantage.
I'm seeking a professional who can script a user-friendly interface in PowerBI for my team to manually enter numerical data/ text directly without the need for excel. The main task will be to design and implement a data entry system suitable for a non-technical team. Key responsibilities include: - Setting up this custom data entry system within PowerBI - Ensuring the system allows for manual input of numerical data which is then stored in sharepoint excel - Verifying the accuracy and consistency of the data entered The ideal candidate for this project will have: - Significant experience with PowerBI, Python, and data visualization - Understanding of data management and integrity checks - Proven track record of creating custom data entry forms in PowerBI Expertise i...
I need highly skilled graphic designers to create an A5, double-sided menu flyer for my cloud kitchen. This is an exciting opportunity for a designer that thrives on clean, modern design styles. Key details about the project include: - Size: The menu flyer must be A5, ensuring a compact but comprehensive layout. - Style: Preference will be given to designers who excel at modern and clean aesthetics, providing a visually delightful and uncluttered experience for my customers. - Pages: The menu flyer should be double-sided, utilising space effectively to present all necessary information without overwhelming readers. Ideal candidates should have significant experience in graphic design, particularly in creating menu flyers or similar materials. Knowledge of modern design trends a...
I'm looking to populate the front sheet of my pricing document using the tabs behind. I need it to look for any populated value, if there is one there, return it. e.g. formula in C25 looks up list in Product List A2:A500 and returns the first value populated. In C26, it should look up the same column of A2:A500 ignore the first value because that's already populated above and return the next value. I cant have it returning row for row as i have limited space. The standard Product should look up Product list tab, Bespoke one should look up the first bespoke tab, Bespoke 2, the second etc. One formula should pretty much work for all, its just what its looking for and how to get it to ignore values that have already been pulled across.
I'm not going to spend more than 30 GBP on this project if your greedy then dont respond there are 4 things i would like 1 - remove add to wish list 2 remove the service part and links 3 to ensure that all features on the product page is consistent through out 4 - let me know if we can display our reviews differently im not asking you to create anything new its all there its just not done properly My Shopify site requires a proficient designer to revise the product descriptions on my product page. The task involves creating engaging, informative, and persuasive product information. Below are the requirements
I'm seeking detailed-oriented freelancer(s) with Excel expertise to help me transcribe and organize data into approximately 350 spreadsheets. Key Responsibilities: - Entry of various types of data (text, numbers, and dates) as modelled in the provided sample. - Employing a versatile organizational approach where data types might be handled in more than one column. Timeline: The project should be completed within one month. Ideal Skills: - Proficiency in MS Excel and data management. - Detail-oriented approach and high accuracy in data entry. - Ability to follow instructions and work with varying data arrangements.
...time data from multiple websites to Excel spreadsheets. - Data Types: The project involves working with a variety of data types including text, numbers, dates, as well as articles, notes, and data in Hindi font. The proficiency in Hindi and ability to handle various data formats is crucial. - Number of Websites: Data has to be scraped and entered from three or more different websites. Experience in web scraping tools is mandatory. - Volume of Data: For each website, you will be dealing with approximately 400 pages. Expertise in data management from high volume websites is a key requirement. Your ability to accurately handle and organise a large amount of dialogues will be directly correlated with the success of this project. In-depth knowledge of Excel functionalities...
...considered relevant for generating a sufficient regression. Key Responsibilities: - Develop R code to perform hypothesis testing and regression analysis - careful explanation for each step in the code - Assess the dataset and determine whether preprocessing or cleaning is required Preferable skills include: - Experience in hypothesis testing and regression analysis - Skill in dealing with numerical and time series data - Competence in data cleaning Please note that the current state of the dataset is uncertain, and potential cleaning may be needed. If you're familiar with managing and fixing potential data issues, this would be perfect for you. I'm looking forward to work with someone who can succinctly communicate their findings in a clear and ...
I need a solution to my manual Word document update process. Each week, I pull tables from two websites (no logi...document update process. Each week, I pull tables from two websites (no login required) and include them in my document. The tables I require update daily. What I need from you: - An automated process I can run each week - The ability to pull the required tables directly from the websites It's crucial you fully understand data extraction and automation. Experience with Word document editing on a macro level would be beneficial for this project. Solid HTML, Python, or another relevant scripting language necessary for this task. Ability to work with web scraping tools required. Your bid should reflect a complete solution, including any third-party tools or serv...
I am seeking a freelancer with expertise in data visualization for a graphic d...task will be to create a pie chart that clearly represents ten 'Sectors of Life'. I have chosen Excel or similar so that I can modify the words as needed because I appreciate its simplicity and I want to be able to make edits in the future if required. The skills and experience required for this job are as follows: - Proven experience in data visualization and Excel chart creation - Ability to interpret life sectors and visually represent them in an organized way - Consistent communication for the successful execution of the project I look forward to seeing your bids and working with you on this interesting project. Please include samples of similar pie chart graphics you have created...
...Database and PHP MySQL. I need assistance in conducting a migration project between these two platforms. - While there isn't a stringent timeline for the project, adept time-management skills are appreciated. - Your primary responsibility would be to facilitate the migration process. Ensure a seamless transition without any loss of data or functionality is what I anticipate. - Regarding data cleaning and optimization during migration, it's still an open discussion point. Your insights will be useful to help decide on its necessity. - Expertise in Firebase Realtime Database and PHP MySQL is a must. A concrete tertiary qualification or similar experience is appreciated. - You should also possess good troubleshooting knowledge to possibly combat any technical hitches that...
As a small business owner, I require an Excel expert who can assist in creating a custom-made Excel file specifically for quotation calculation purposes. This Excel file will primarily perform comparisons of quotation calculations derived from various vendor rate lists. The ideal candidate should possess the following skills and experience: • Expertise in Excel formula calculations, and knowledge of macros will be helpful. • Familiarity with business quotation calculations from various supplier rate lists. • A proven track record of creating tailor-made business tools using Excel. The role's responsibilities include: • Designing and constructing an Excel file suitable for executing complex quotation calculations reliabl...
I am promptly looking for an expert capable of converting a VBA script that currently operates on Windows Excel 16 to function on Mac Excel 16. The existing VBA script is primarily used to automate tasks, owing to which, proficient experience in scripting automation and swift task execution is key. - Ideal Skills: Proficiency in Excel VBA, familiarity with both Windows and Mac Excel 16, understanding of task automation via scripting, and the ability to deliver within short timeframes. - Key Ask: The primary function of the script is to automate tasks. While specifics aren't provided, a good grounding in automating generic tasks through VBA scripts will be invaluable. - Timeframe: This job is immediate. I require a swift conversion, with delivery wi...
I have an Excel 2016 VBA script in need of converting to Mac VBA. The converted script is expected to retain the same functionality. Additionally, I require a video tutorial demonstrating the successful running of this new script. The video duration is flexible and it shows the success of the converted script. I'm urgently looking to complete this project. Ideal freelancer should have: - Experts in VBA scripting, especially Excel 2016. - Proficiency in MAC VBA Scripts. - Experience in creating video tutorials. - An ability to complete tasks on short notice.
I am looking for a skilled developer to create a robust car detailing and washing application for iOS, Android, and web platforms. Key Features: - The app needs to facilitate booking appointments for various car detailing services. - It should also have integrated payment solutions to enable seamless transactions. Services Offered: - Exterior car cleaning - Interior car cleaning - Waxing and polishing - Vacuuming - Window cleaning Ideal Skills: - Experience in developing cross-platform applications - Understanding of GPS-based location services - Knowledge of secure payment gateway integration.
We require a VectorWorks, VectorScript plugin built to do some calculations and present results. The following is a brief summary. More details will be supplied to successful candidate. In we need to be able to click in the VW, 4 extents (length of item, start, stop, and width). A popup should show and advises some information. A data table is then referenced (think Excel - VLOOKUP) The object is then measured, labelled, and put into a table on the sheet.
...sophisticated quiz module for delivering online tests. This should include the following key features: - A facility for multiple choice questions. - A countdown timer for each question. - Random question selection for greater challenge and variation. - user can register and then attempt our quiz - list of Our created quiz will be be display at front end -admin can download quiz attempted user data in excel format I plan to create multiple types of quizzes, each having a unique configuration and targeting different user groups. Knowledgeable freelancers who can demonstrate prior experience in Drupal quiz module creation will have a significant edge here. It's worth mentioning that I will supply all quiz content. So, I do not expect the selected freelancer to create the co...
we are proficient professional who can handle data entry into Excel. Our responsibilities will primarily require: - Working with mixed text and numerical data. - Entering and organizing this data into a tabular format. Our ideal Team possess robust Excel skills, coupled with a attention to every detail. Our ability to process mixed text and numerical data efficiently will be the key to success in this role. We have multiple Prior experience with similar data entry projects and we would be advantageous but is not compulsory. We know that Timeliness, accuracy, and confidentiality are crucial aspects for this job. Looking forward to any data project will be provided to our team for processing.
I require a freelancer to convert our existing Excel estimating spreadsheet into a Cubit estimate template. Key Requirements: - Full conversion of Excel spreadsheet to Cubit. - Maintain key functionalities from our original spreadsheet, including formula calculations and data sorting. - Help us set up Cubit in our office for testing use. Ideal Skills: - Proficiency in Excel and Cubit estimating systems. - Experience in migrating data from Excel to Cubit. - Understanding construction estimating, specifically for modular residential homes, would be advantageous.
...application development to help us create a top-tier cleaning services platform. Key aspects of the app include an online booking system, real-time tracking of cleaners, and a user-friendly interface for customers to leave reviews and ratings. Additionally, we're looking for the following capabilities: For Users: • User registration and profile creation • Easy-to-use service request function • A variety of service categories, including regular cleaning, deep cleaning, and carpet cleaning among others • GPS functionality for automatic user location detection • Cost estimation tools and streamlined payment integration • Timely notifications along with a history and invoice tracking system • A dedicated, easy-to-access ...
...feeding task and capable of importing data from an XLSX format Excel workbook into Corel in a certain format . I have attached an excel file which has data of students and a corel file which has format in which the data of all students needs to be filled. (not copy pasting) So this is a school result and it is in excel file and We have a set format in Corel draw. All you have to do is import that data which is in excel file to corel file according to their headings. From class 1-12 there are 4 formats. There would be around 2000 Students. It is very time sensitive task considering results. You won't get much time (hardly 1-2 day max). Key Responsibilities: - Implement and execute graphic design tasks in Corel - Import Excel data (in XLSX forma...
...experience using Beautiful Soup, Scrapy, or similar web scraping tools will find this relevant. Sufficient knowledge in legal documentation and practice is also an added advantage. I have these other tasks that can be combined or individually parsed out. Project Workload Breakdown 1. Data Collection and Preparation • Task: Web Scraping and Data Acquisition • Task: PDF Text Extraction and Data Cleaning 2. AI Model Development • Task: NLP Model Fine-Tuning for Legal Text • Task: User Interaction and Feedback Loop Implementation 3. System Integration and Testing • Task: Front-End Development for User Interface • Task: Backend System and API Integration • Task: System Testing and Quality Assurance 4. Legal and Ethical Compliance &bul...
[Tool] Use UiPath, not UiPath X. DO NOT use other RPA tool. [Inputs] "" and "". [Output Goal]Copy Excel(.xlsx) data ant paste to Google Docs( not microsoft Word) [Output Example] [Detail]Process Excel tables row by row and paste them into Google Docs. Image data can also be set as necessary.
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule. The data parameters from the spreadsheet that need to be incorporated into the schedule are names and time slots. Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. Skills & Experience: - Strong Excel skills - Excellent organizational abilities - Prior experience in creating schedules or calendars from Excel data Your job will be to carefully transfer the 'Names' and 'Time Slots' from the spreadsheet into the daily calendar format I need. Please ensure the information is both accu...
I'm on the lookout for an Excel whizz for creating an Excel project management tracker with the following specific features. Required Features: - Task Tracking: This is the most crucial aspect of the project. We will be tracking various data like task progress, deadlines, and associated team members, in which I'm focused on. - Time Spent on Task: The tracker should also allow tracking of the time employees spend on individual tasks, helping us to understand resource efficiency. Ideal Skills & Experience: - Proven experience in creating complex Excel spreadsheets - Deep understanding of data tracking and resource management - Proficient in handling project management tools, specifically Gantt charts I'm looking forward to a specialist who can make ...
...proficiency in Microsoft Power BI, who is able to masterfully combine data visualization and data modeling. The specific functionalities required are: - Data visualization: turning large and complex data sets from Excel spreadsheets into visually appealing and understandable visualizations. - Data modeling: structuring the raw data in the Excel spreadsheets into a more useful and relatable form for easier interpretation. The primary goal for this project is to create engaging and interactive reports from existing data. An ideal candidate would be comfortable and experienced with Excel and have a deep understanding of data interpretation and reporting. Strong communication skills are essential in order to understand my needs and translate them into the interactive...
I'm looking for a talented developer to create a product comparison website focused primarily on electronics and household appliances. The website needs to include specific features: - Product reviews: Visitors should be able to read reviews about the mentioned products. - Filter and sort options: These are crucial for a user-friendly experience. Visitors should be able to easily f...product with the search button or choose the main product category for example first step -- PC then the second one is Notebook then maybe Apple then Macbook PROs and so on. I need to add Google ads(It will not take up too much of the page and will not disturb visitors much.). I need also a management console to update the website and I would like to add multiple products at the same time like from ...
I require a talented coder skilled in creating Excel macros to automate data entry tasks. The macro should efficiently handle logical formulas but does not require extensive knowledge in IF statements, AND/OR/NOT or VLOOKUP-HLOOKUP conditions. Key responsibilities include: - Developing an Excel macro that automates data entry tasks - Implementing logical formulas into the script Ideal skills: - Proficiency in Excel and VBA - Strong understanding of logical formulas in Excel - Experience in creating macros and automating data tasks Please note that while this project doesn't have the specific logical conditions, a generic understanding and ability to implement logical conditions if required are preferred.
I need an Excel expert to create a formula that will automatically pull matching data from one sheet to another based on a unique identifier. Specifically, the formula should locate and pull information using social security numbers. Here is what you need to bring to the table: - Advanced knowledge of Excel formulas - Prior experience with data matching functions - Understand the importance of accurate data handling due to sensitive information (social security numbers) - Ideally, past work with financial or personal data If you have handled similar projects and mastered the required skills, I want to hear from you.
Set up the following questions and solutions in Excel and verify the solutions provided. Explain and interpret the reasoning behind solutions. Annotate carefully your work in Excel. Provide proofs where necessary. Provide theoretical/ mathematical/statistical justification for your workings in excel. Interpret in full your results. All solutions are provided
I have multiple client lists scattered across a few Excel files, which I am keen to consolidate into a single Excel document. Each consolidated list should have its own sheet and be arranged in table format for smoother data management purposes. Freelancers ideally should have: - Strong skills in Excel and data consolidation - A keen eye for detail - Prove their proficiency by showcasing their past work involving similar tasks This project involves consolidation of 1-5 Excel files. Your thorough understanding of Excel Data management and table manipulation will be beneficial in delivering success for this task. I look forward to your expert assistance in this matter.
I am looking for a marketing expert who can devise a comprehensive marketing plan for a cleaning service, focusing on lead generation. The strategy should tap into social media advertising, search engine optimization, and email marketing, with a primary target audience of families with children. In this project, your responsibilities will include: - Crafting a robust social media advertising plan to engage and attract families with children, while also broadening our reach and visibility. - Enhancing our SEO performance to ensure our service appears at the top of search results related to cleaning services. - Designing an effective email marketing strategy to communicate directly with potential clients, delivering meaningful and compelling messages that encourage them to tr...
I am looking for a marketing expert who can devise a comprehensive marketing plan for a cleaning service, focusing on lead generation. The strategy should tap into social media advertising, search engine optimization, and email marketing, with a primary target audience of families with children. In this project, your responsibilities will include: - Crafting a robust social media advertising plan to engage and attract families with children, while also broadening our reach and visibility. - Enhancing our SEO performance to ensure our service appears at the top of search results related to cleaning services. - Designing an effective email marketing strategy to communicate directly with potential clients, delivering meaningful and compelling messages that encourage them to tr...
I am in need of a professional who possesses advanced skills in Excel data entry. My project involves: - Complex data input with use of formulas - Formulas will be provided by me The ideal freelancer would be someone highly experienced in Excel, particularly in managing complex data input through formulas. Knowledge of Excel's advanced functions is also a must. Being able to work accurately and efficiently is crucial for the success of this project. If you have such skills and you're looking to take on a new project, I'm eager to see your bid.
I'm looking for a proficient SEO expert with a track record in boosting website traffic, improving search engine visibility, and enhancing keyword rankings. My website specifically focuses on the laundry and dry-cleaning niche and is yet to gain a ranking. Your responsibilities will be: - Implement data-driven strategies to push our website to top search results. - Amplify website traffic through strategic SEO techniques. - Curate and manage keywords for better visibility and ranking. The ideal candidate should have: - Proven SEO experience, ideally in the laundry and dry-cleaning industry. - Insight on recent SEO trends, tracking and analytics software. - Strong knowledge of search engine algorithms, keyword research, and link building.
We need an expert webscraper to do data research for a project we are working...small percentage do not have on-campus pantries. Ideally, we would like to receive at least 3,500 results from this, but we will be satisfied with 2,000 results. Ideal Skills: - Experience in building web scrapers or crawlers - Familiarity with data extraction, particularly from institution-based websites - Knowledge about university/college formats would be beneficial - Mastery in handling and cleaning text-based data Your task is to ensure the accurate and efficient extraction of required text-based data from the specified websites. Efficient delivery and attention to details will be greatly appreciated. Finally, your quote is your rate. All of the relevant and necessary information is in this projec...
"Mist Cleaning Services Platform" is an app that serves as a platform for cleaners and users (who need cleaning services). I'm in need of a catchy, attractive logo ready as soon as possible. The logo should be very clean. The main purpose behind this design is to attract everyone to the platform since everyone needs cleaning done either in their home or their workplace. Experienced graphic designers who have a knack for creating engaging, distinct designs capable of drawing the attention of our target demographic would be the perfect fit for this expedited project. No color in mind, but it's a platform for cleaning services. So feel free to give your best shot.
I am in need of a meticulous freelancer with strong data entry skills to help me populate an Excel spreadsheet with simple text data. Key Responsibilities: - Data entry into my Excel database - Ensure all entries are accurate and error-free Ideal Skills and Experience: - Significant experience using Excel for data entry - Detail-oriented and accurate - Familiarity with data cleaning and formatting This task will require careful attention to detail and the ability to handle simple text data efficiently. I look forward to your bids and questions about the project.
Hi, enclosed donut chart needs to be finished. What need to be done: - outer ring needs to be finisihed - different scales of the color from dark to light - all the labels inside their area (so most of them need a small radius adjustment)
**Project Overview:** We are seeking experienced and proficient Odoo developers (2 or 3) and a Flutter developer to collaborate on a comprehensive project to develop a backend module and mobile applications for a car cleaning services platform. **Key Features:** 1. **Membership Management:** - Implement a robust membership management system to handle subscriptions and user data. 2. **Mobile Car Services:** - Develop a mobile app allowing users to book instant car cleaning services. - Implement an algorithm to determine the nearest available car service team. 3. **Mobile Apps for Different User Roles:** - Create mobile applications tailored for Workers, Supervisors, Management, and Customers. 4. **Payment Gateway Integration:** - Integrate a secure and reli...
I'm looking for a competent Excel specialist who can use advanced formulas to analyze an extensive batch of survey data. I essentially need a couple new formulas written for an existing excel file Your duties will include: I have an existing excel file I want to add an extra row of captured data to and pull out trends from that new data with existing data
Join Our Team and Shape the Future of Online Real Estate! Are you a seasoned PHP and MySQL expert ready to tackle a multifaceted challenge? is actively seeking a dynamic individual to join our team as a PHP & MySQL Partner - Tester and Programmer. As we embark on a transformative journey, your expertise is crucial in cleaning up code, conducting error testing, and optimizing the performance of our complex real estate auction site. About Us: With over 11 years of expertise in the real estate industry, , founded by Chris and Missy, is on a mission to revolutionize the online real estate landscape. Our platform is designed to elevate the buying and selling experience through innovative solutions and empathetic design. Our Vision: At , we're not just
...skilled freelancer with comprehensive knowledge of Microsoft Excel to execute intricate modifications to an existing Excel file. Key changes I need include: - Data validation: I want the data entered via the arrows online and calculated for AQL. The freelancer must be adept in managing flexible data entry and control measures. - Formula adjustments: The selected professional will have to be skilled in making and tweaking formulas. - Formatting changes: I'm looking for an aesthetic refit of my Excel sheet. The freelancer needs to have a good eye for layout design and detail. - The file should lock unused cells for consistency and error avoidance. - I'd also like to have a clear button included for the easy cleaning of specific data or ...
...skilled freelancer with comprehensive knowledge of Microsoft Excel to execute intricate modifications to an existing Excel file. Key changes I need include: - Data validation: I want the data entered via the arrows online and calculated for AQL. The freelancer must be adept in managing flexible data entry and control measures. - Formula adjustments: The selected professional will have to be skilled in making and tweaking formulas. - Formatting changes: I'm looking for an aesthetic refit of my Excel sheet. The freelancer needs to have a good eye for layout design and detail. - The file should lock unused cells for consistency and error avoidance. - I'd also like to have a clear button included for the easy cleaning of specific data or ...
