Data excel sheet macro jobs
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
...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 cells. Lastly, the ...
...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 cells. Lastly, the ...
...to work with us 2. Connect to their online pricing systems and generate quotes 3. Email and call lenders to gather quotes 4. Update the client on every quote and add the quote to a spreadsheet 5. Do another auction between the 3 best quotes by sending them to the winning lenders 6. Consult the client on which loans are the best ones from alll of the offers we got 7. Sign the borrower on a term sheet approval once they chose a lender We are working with the Lending Wise software for document management and also their Market Place fo rlenders, through emails and phone calls between the clients and lenders We are also using WhatsApp to communicate with clients per loan You will work on getting new lender and quotes on: 1. All social networks -LinkedIn, Facebook, Messenger etc. 2...
I require assistance with linking multiple Google Sheets documents - extracting certain cell values and incorporating them into different documents. I have tried to use the IMPORTRANGE function, however, I'm encountering difficulties connecting to the second Google Sheet. The specific error message I'm receiving states: "You do not have authorisation to access this worksheet.". I need this issue resolved, and the linkage between sheets established smoothly. Ideal Skills: - Expertise in Google Sheets and its various functions. - Problem-solving skills - able to troubleshoot the IMPORTRANGE issue. - Excellent understanding of document authorisation and permissions on Google Drive. This task requires a good understanding of Google Sheets, its various functions ...
I am in need of an individual proficient in Advanced Excel. The chosen freelancer will not need to focus on specific tasks such as data analysis, creating complex formulas or pivot tables and charts, as this question was not applicable to my project. Instead, the focus of this project lies elsewhere. Here is what I am looking for in a successful applicant: - In-depth skill set within Excel at an Advanced level (Non-negotiable) - Proof of past experience using Advanced Excel skills Finer details of the project will be shared with the successful freelancer. I encourage those proficient in Advanced Excel to apply, especially if you love a challenge!
I need help sorting out my Zoho Books software to accommodate my construction business. Here's what you need to do, - Setup Chart Accounts - Organize Ledgers - Reconcile Accounts - Data filling for VAT We've been using this program for invoicing, but now we need to take it a step further. Objectives: 1) Prepare to submit VAT. 2) Produce the following financial statements: - Balance Sheet - Income Statement - Cash Flow Statement I need this done as soon as possible. Ideal candidates would be those with: - Deep understanding of accounting principles - Extensive experience with Zoho Books - Experience in VAT filing for businesses - Knowledge in generating financial statements Please feel free to ask me any questions that will help you put toge...
I'm looking for a proficient Arduino programmer capable of: - Programming my Arduino board - Troubleshooting and debugging pre-existing code The right person for this project will excel in: - Knowledge and skills in Arduino programming - Good understanding of Arduino hardware - Experience with circuit design and wiring connections Please note that I already have all the hardware and components, but code needed for this project. Understanding and skills in Arduino programming for Arduino board is essential.
I need a person who can make quotation on ms excel along with product images
I'm urgently seeking an Excel and VBA professional who can overhaul my current workflow. Key tasks will involve: - Automating a series of repetitive tasks to significantly increase efficiency. - Optimizing a range of statistical formulas in existing spreadsheets. While the complexity of the statistical formulas in the project isn't certain, you should comfortable dealing with both simple and advanced computations. The ideal freelancer for this project should be proficient in Excel and VBA, have a solid understanding of statistical formulas, and a knack for optimizing work processes. An ability to execute tasks quickly without compromising on quality is critical.
...patterns, and insights within the data that can inform strategic decision-making. Utilize industry-specific knowledge to provide context and interpretation of the data within the chemical industry landscape. Collaborate with stakeholders to understand specific requirements and tailor the analysis to meet their needs. Develop a visually engaging PowerPoint presentation to communicate the analysis findings clearly and effectively. Requirements: Bachelor's degree in Business Administration, Finance, or a related field. Proven experience in financial analysis, preferably within the chemical industry. Strong analytical skills and attention to detail, with the ability to derive meaningful insights from complex data sets. Proficiency in Microsoft Excel for ...
I'm looking for an Excel expert to refurbish a weekly report sheet. This project will require both basic and advanced Excel skills. Key Tasks: 1. **Formatting Overhaul**: This includes updating the font style and size, creating a more professional color scheme, and aligning all cells correctly to ensure readability and aesthetic appeal. 2. **Data Visualization Enhancement**: The current forms of data visualization, including charts, graphs, and sparklines, need to be updated. Additionally, I would like some conditional formatting added to provide instant, visual analysis of data trends. Ideal Skills and Experience: - In-depth knowledge of Excel functionalities - Proven experience in data visualization - Attention to detail, d...
I have a data typing project that involves converting text data from PDF files into Excel. The ideal freelancer for this job would have: - Proficiency in Excel - Experience with data entry - Good typing speed Specifically, your task involves: - Extracting textual information from the PDF files I provide. - Organizing this information in Excel by columns. Please note, accuracy is key in this project. I need a person who is thorough, has an eye for detail and can deliver the project within the agreed-upon timeline.
...for workers at their respective sites. Automate the generation of daily and monthly attendance reports in PDF/Excel format for individual workers and groups based on client specifications. User Interface and Functionality: Supervisor Level: Supervisors will have access to a pre-fed list of workers at their assigned site. They can mark workers as present or absent for the current day and input the number of hours worked (including overtime) for the previous day. Admin Level 1: In addition to supervisor functionalities, Admin Level 1 users can manage worker data, adding new workers and deactivating terminated workers. Admin Level 2: Admin Level 2 users possess the ability to edit data submitted by supervisors and Admin Level 1 users within a specified timeframe. Mana...
I'm looking for a data professional who can systematically clean and analyze a dataset containing numerical values. Specifically, here are the tasks expected of you: - Cleanse the data using Python or Excel based techniques to ensure it's error-free and organized. - Conduct an in-depth analysis of the cleansed data. The ideal candidate for this project will have: - Proven experience with data cleansing and analysis. - Proficiency in Python and Excel. - Strong understanding of numerical data manipulation.
My automation agency is looking for an Excel Expert for this job and future jobs. I'm looking to manipulate data inside of Excel and will need to use advanced automations I do not understand in Excel to create a finished csv file that can be uploaded in a particular way. The finished CSV is for a competition draw that is uploaded with individual entries being shown with first name, last name and mobile. As every new order is placed on the webssite, the raw order data is imported into excel from Woocommerce. I need to make multiple changes to this data including- - Re format phone numbers that are sometimes +61 and not regular 04XXX - Remove a handful of columns for finished csv data not needed - Create a duplication of a pers...
I am in need of an experienced web scraper to retrieve player statistics and lineups from Soccerway.com. Key Tasks: - Obtain player stats and lineups from the current season. - Deliver scraped data in an Excel spreadsheet format. Ideal skills and experience: - Proven experience in web scraping. - Familiarity with sports data, particularly soccer, would be advantageous. - Experience using Excel and able to format data in a user-friendly way. Please note that this task requires a high level of accuracy. Demonstrated prior experience in similar projects will be highly regarded.
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.
More details: Which platform are you using to open Power Apps through Power BI? Power BI Desktop What is the primary functionality you want the Excel file upload to accomplish? Update existing Power BI visual What is your preferred way of triggering the Excel file upload? By clicking the file uploading button it will upload the visual automatically
I am looking to hire writers for my WordPress blog who excel in writing well-researched, SEO-optimized, unique articles with valid points. Please note that I don't want content generated through ChatGPT or any other AI platform. I prefer someone experienced with WordPress and using the Yoast SEO plugin. I am seeking writers who can create articles in their own words; rewriting other bloggers' points is not acceptable. The writer must have the ability to craft articles with a unique style in an SEO-friendly manner. My rate is Rs. 150 per 1000 words. If anyone is interested and can adhere to my rules and guidelines, kindly message me. Thanks and have a great day.
Location: Remote About the Role: We are seeking a highly organized and detail-oriented Remote Virtual Assistant to oversee the management of multiple Short Term Rental properties located in Los Angeles. The ideal candidate will excel at multitasking and possess excellent communication skills to ensure the seamless operation of each property, enhancing guest satisfaction and maximizing owner revenue. Key Responsibilities: Guest Communication: Promptly respond to booking inquiries and guest questions on listing platforms. Communicate professionally and efficiently to provide a high-quality experience for guests. Calendar Management: Keep all property calendars up to date, including managing bookings, availability, and scheduling conflicts to avoid double bookings and optimize re...
...listings are optimized for maximum visibility and sales. Responsibilities: -Analyze and prepare product data for import into Amazon's Jewelry Category, ensuring compliance with Amazon's product listing standards and guidelines. -Migrate and import product spreadsheets into Amazon, utilizing advanced Excel skills and Amazon Seller Central knowledge. -Optimize product listings for SEO by researching and including relevant keywords, product features, and descriptions. -Ensure all product details, such as prices, images, and descriptions, are accurately represented and meet Amazon's quality standards. -Troubleshoot any issues related to product import and listing, including error resolution and data validation. -Coordinate with our team to gather all ne...
...putting together a Christian event. We need sponsors, attendees, and project submissions. (Please read to the very end) We need someone to help gather: Christian companies to sponsors (you can look at similar events for their sponsors), Christian film producers, Christian musicians, Christian directors, Christian artists etc. We'll need phone numbers and/or emails to contact them organized in Excel by category. We'll give you scripts to email and we'll be in charge of follow up. This an international event, but we speak English & Spanish. Research will be primarily in the USA, but can reach other countries. You'd have to be able to recognize Christians *only* for these specific roles although the event is open to everyone. When you respond, please ...
I require an experienced data entry specialist who can accurately and efficiently copy information from a PDF documents into a spreadsheet. Purpose: Based on individuals' profiles, to understand the types of certifications individuals are obtaining and discern themes. Deliverable: An Excel spreadsheet detailing all certifications listed in each individual's profile. Each certification should occupy its own column. For instance, if an individual has 5 certifications, they will be in columns titled Certification 1, Certification 2, and so forth. Similarly, education details should be extracted into distinct columns. Each education entry should have two columns: one for the institution or university and one for the qualification obtained. The Excel shee...
I'm in need of an adept Excel specialist with exceptional skills to develop a multi-sheet spreadsheet capable of handling textual and date or time data. Though there was no specific need for complex functions, your ability to create logical and easy-to-follow spreadsheets is paramount. Key Requirements: - Develop an Excel Spreadsheet with multiple sheets and columns - Make sure the spreadsheet can easily handle and manipulate textual and date or time datasets While programming skills and knowledge of financials or statistical analysis aren't necessary for this project, a firm understanding of Excel and its basic capabilities is ideal. Successful completion of similar past projects would be advantageous.
I'm seeking a skilled senior excel macro coder, proficient in manipulating data, to assist with streamlining my work processes. You will be well-versed in developing bespoke macros that ensure accurate and efficient data cleaning and manipulation. Your responsibilities will include: - Developing macros for data cleaning, reducing errors and improving efficiency in data input. - Be prepared to manipulate complex data sets, although it is not determined yet how large these sets will be. - Consulting and collaborating with me to define the specific tasks needed for the data cleaning and manipulation process. The ideal freelancer for this role has in-depth experience working with Excel Macros, expertise in data cle...
I am in need of an experienced Excel macro coder who can implement automated functions to streamline the tasks. While no specific functions are designated at this moment, the coder should have proficiency in different areas of Excel automation. Desired skills include: - Expert knowledge in Excel macro coding. - Ability to understand task and design automation accordingly. - Quick turnaround time due to the urgency of this project. Please reach out if you can start on this immediately.
...financial reports based on existing ones. Please review the following summary video before providing your proposal (1.5 minutes): Tasks: Nuevos reportes: Estados de Financieros en resumen y 2 nuevos estados. (**new summary reports and new statement of equity evolution, cash flow and notes to the financial statements)** - [ ] Balance General (Balance sheet simplified report): - [ ] Estado de Resultados (Profit and loss simplified report): - [ ] Estado de Evolución del Patrimonio (equity evolution): - [ ] Estado de Flujo de Efectivo (cash flow): - [ ] Reportes sin grupo de cuentas (reports without account group):
In need of an experienced data miner to gather phone numbers for a list of clients that I have compiled. The key project details include: - There are over 500 clients to search for. - Client details are provided in an Excel spreadsheet. - For each client, I provide their full name, physical address, and email addresses. Desired Skills and Experience: - The ideal freelancer for this project has a strong background in internet research and data mining. - Familiarity and comfortable working with Excel spreadsheets and large data sets is essential. - An experienced individual who has completed similar projects in the past will be highly regarded. The goal of this project is to find phone numbers corresponding to each name in the list as accurately ...
I need a skilled Excel/Google Sheets wizard to create a comprehensive tool for tracking operating expenses. Our primary focus is on monitoring our operational expenditure in a concise, easy-to-use spreadsheet format. Ideal skills for the job would include: - Proficient understanding of Excel or Google Sheets. - Experience in building financial tracking and forecasting tools. - Great attention to detail. - Good understanding of operating expenses categorization. Your task will be: -Develop a user-friendly dashboard for inputting expenses, including options for date selection, currency selection (USD, GBP, EURO), recurring expenses (monthly/yearly), tags (e.g., marketing, operating), description, and notes. -Design and implement a dynamic dashboard that displays year-to-date ...
Read before bidding, verification test included. This should be a 30 min project for an expert in google sheets. I have a google sheet with 18 lookup tables in tab "lookup" in other tabs I need to use each of these 18 tables as dropdowns to show the options (with descriptions) but when an item is selected, I only need the number put into the field. Each table is used for 2 cells in 1 row (Now & Goal) See screen shot which shows the data tab (left) and the first 2 lookup tables in the lookup tab (right) No time to waste. To prove you read this posting, put the name of your favorite food in all CAPS as the absolute first word in your bid. Auto bids will be deleted. Your bid is your bid, don't ask budget AFTER we start chatting. I will ban you from a...
I am looking for an Excel expert who can create an easily understandable and navigable sheet that can efficiently track Diesel fuel consumption with particular emphasis on calibration error analysis. This would allow me to both track fuel usage and monitor discrepancies in fuel consumption. Key functions include: - Tracking fuel usage: Allow me to manually input and monitor the amount of diesel used. - Calibration error analysis: Track the syndromes and rectify any differences in actual and expected fuel consumption. - Track excess and shortages: Clearly indicate any discrepancies or unusual patterns in consumption, logged on a monthly basis. Ideal candidates for this project should have: - Excellent knowledge of Excel and its computational capabilities - A good unde...
I'm seeking a skilled Excel trainer with deep expertise in advanced formulas and functions. This trainer needs to conduct online live training sessions specifically for professionals with advanced Excel knowledge. The sessions should be designed for interactive learning, using examples, and scenarios for practical application. Therefore, experienced trainers with a knack for making complex topics comprehensible and engaging are most desirable. Specific areas to be focused on in training include, but are not limited to: - Comprehensive exploration of Excel formulas and functions - Application of these formulas in real-world scenarios The right fit for this role will have: - Proven experience in tutoring advanced Excel - Strong command of online training...
Urgently seeking a photo editing magician who can swiftly and cleanly remove background elements from an existing photo. No need to worry about people or text, just the background! Ideal Skills and Experience: - Proven expertise in photo editing, particularly with background removal. - Familiarity with software like Adobe Photosho...application for this project. So, let your experience and creativity shine through in your bid! Do provide any relevant examples, demonstrate your understanding of the task, and explain how you intend to accomplish it in a timely manner. Prompt communication will also be highly appreciated! Ready to start ASAP, so don't hold back! REMOVE ON PICTURE ALL ZONES OUTLINED IN YELLOW WHITE SHEET MUSIC PAPER SMALL LAMPS FOR READING SHEET MUSIC STAN...
...verification test. Here's what I need: - A method that permits me to flawlessly copy tables from a Google Sheet document and insert it appropriately into a ChatGPT prompt. -Prefer a chrome extension where a button can be pressed and the current selected table in a google sheet can be formatted and put in the clipboard. Later I can paste into a prompt - Generous attention should be given to formatting details, such as: - Consistency in the use of spaces. - The employment of specific delimiters. - Attractive and clear presentation of table headers. The ultimate goal? To end up with beautifully formatted tables that align perfectly with these guidelines; this table data should be placed into the clipboard for easy pasting into a ChatGPT prompt. ...
...illiterate and manually type hundreds of Squarespace orders' information onto a Google sheet document every year. I also act as their resident tech support, and I'm certain that simple Python code or something similar that could do this for them, but my coding knowledge is not in-depth enough to carry this out efficiently. Are any professionals available to help me out? Auto-generated description below: I'm looking for a developer with experience in Squarespace and Google Sheets API to create a program that can automate my daily tasks. This automation will allow information from orders I receive on Squarespace - including Customer details, Order details, and Payment details - to be sent directly to a Google Sheet of my choosing, and it needs to update autom...
I am looking for data of the Indian version of the TV show "Shark Tank". I need at least 200 company details **Specific Information Required:** - Company Name - Website - Email - Phone All data should be in excel file
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 ...
I need a macro specialist who can work with Excel VBA. Key responsibilities: - Creating Excel VBA macros Ideal Candidate: - Demonstrable experience in Excel VBA - Strong analytical skills - Task focus: macro creation The specifics of the function the macros will perform are still undecided. I'd appreciate your expertise and input on this.
I'm in need of assistance with various data entry tasks, including spreadsheet data entry, online form filling, and data extraction from PDFs. This project is estimated to include between 100-500 separate entries, which will need to be handled using Microsoft Excel. Scope of work: - Spreadsheet Data Entry: Entering data into predefined spreadsheet templates accurately. - Online Form Filling: Filling in different types of online forms with provided data. - Data Extraction from PDFs: Extracting relevant information from PDFs and represent it in a clear, organized format. The ideal freelancer for this job should be proficient in Microsoft Excel, have great attention to detail, and have experience in data entry and ...
I'm looking for a proficient Excel freelancer who can help me organize my data better using specific formulas. Your main task will be to: - Implement various formulas to enhance efficiency. I'm mainly interested in arithmetic formulas, but feel free to suggest any other types that may support my project objective. - Create schedules for organizing group trips and functions. These should be arranged according to date and time, location and activity. Bring your advanced Excel skills, especially in the areas of formulas and data sorting, and your knack for organizing data in a clear and beneficial manner. A sample and further guidelines will be provided to get you started. Your input and expertise will be greatly appreciated in this task. Loo...
I'm seeking a proficient individual to transfer data from physical documents into an Excel spreadsheet. The data consists predominantly of names and addresses alongside survey responses and results. Organizational skills, attention to detail, and familiarity with Excel are key. The ideal candidate should have: - Proven experience in data entry and knowledge of Microsoft Excel. - The ability to maintain accuracy, even when dealing with large volumes of data. - Excellent organizational skills to manage and categorize this data in a logical and accessible manner. If you have relevant experience and are ready to start immediately, please apply.
...local utility to: 1. Back up the Excel Spreadsheet by making a copy, keeping the last 10 copies 2. Automatically append the contents of 1-2 CSV files found in a folder to an excel spreadsheet 3. Move processed files into a COMPLETE folder 4. Log the results in a local text file. Full story: My software exports 2 CSV files daily to a local computer. These CSVs show the products that have been sold and the quantities of each product sold for that day. We need to add these rows of data to a master Excel sheet, and it should be done automatically when a new file is detected, OR at a specific time each day. The fields would be Date Sold, Erply ID, UPC, Internal ID, Description, Qty Sold The CSV files would be The Excel Spreadsheet would be...
I'm looking for a proficient data analyst to compile, clean, analyze and present 3 sets of data in an understandable and insightful manner. Key Responsibilities: - Compile and clean the provided data sets. They are currently formatted in Excel. - Perform a predictive analysis on the data sets. - Present the cleaned and analyzed data back in Excel, although I am open to suggestions for other effective presentation formats. Ideal freelancer: - Has strong Excel and data analysis skills. - Experience in predictive analysis. - Proficiency in transforming data into meaningful, actionable insights.
I have a VBA code that's currently running into issues on Microsoft Excel. The problem lies in the code not interacting properly with the correct data, causing it to function incorrectly. Key Requirements: - Understanding of VBA code interaction with data - Specific experience in troubleshooting code functionality - Familiarity with VBA for Microsoft Excel Your role will be to diagnose the problem causing the interaction failure and apply comprehensive fixes. In your proposal, please share relevant experiences of VBA troubleshooting and data handling. Efficiency and effectiveness in resolving the issue will be highly appreciated.
...looking for an experienced Excel expert who can help in effectively creating and managing Excel formulas and functions for my dashboard. For my daily business functioning, I need to keep track of key performance indicators (KPIs) that directly reflect the ongoing progress. Skills and Experience Needed: - Strong proficiency in Excel - Experience generating insightful dashboards - Knowledge in embedding Key Performance Indicators (KPIs) into a dashboard - Attention to detail to ensure data accuracy Deliverables: - Enrich my Excel task using advanced formulas and functions - Create a well-designed Excel dashboard displaying key performance indicators (KPIs) Bear in mind that this project requires advanced Excel knowledge and partic...
...requirements include: - Cross-platform compatibility: The system should be accessible on Windows and Mac, making it versatile for different users within the company. - Software integration: The system should be able to sync seamlessly with QuickBooks and Spreadsheets, allowing a hassle-free data transfer between platforms. - Financial modeling: The developer should possess strong financial knowledge to capture the complexities of cash flow forecasting, reporting and financial statements (Balance Sheet, Cash flow, income statement). Experience in creating similar systems would be highly beneficial, and familiarity with financial processes and tools is crucial. You should have an understanding of QuickBooks and Spreadsheet functions and integration. A strong record of reli...
...schedule meetings for the employer. - Coordinate and organize meetings with potential call centers to discuss and onboard our casino campaign. - Maintain communication channels with existing partners to ensure smooth collaboration. 2. Data Management: - Assist in the organization and preparation of data files for SMS campaigns, ensuring accuracy and compliance with regulations. - Conduct duplicate checks on data to prevent reusing the same numbers and maintain data integrity. - Utilize Microsoft Excel to create and manage spreadsheets for data organization and manipulation. 3. Administrative Support: - Assist in the coordination of postbacks from online casinos' affiliate tracking systems to our affiliate management syst...
