Excel combine data different sheets일자리
...order! Are you a science journalist or scientist with a great idea still in the beginning stages? Or are you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punc...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
I need an Excel expert to help me modify and randomize my data. The tasks include: 1. Changing all dates in the “Proc Date” column to only Tuesdays and Wednesdays from July 2024 to December 2024, excluding Christmas Eve, Christmas Day, and New Year’s Day. The dates can be random, in no particular order. 2. Updating the phone numbers in the “Phone” column to: (908) 730-8880 for the entire column. 3. Changing the address in the “Address of the Facility” column to: 1630 NJ-31, Clinton, NJ 08809 for the entire column. 4. Altering the ages in the “Ages of the Patients” column to random numbers between 12-89 for the entire column. 5. Modifying the name in the “Facility Name” column to: North Hunterdon Dental Associa...
I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.
I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data
...and deadlines (via email or in-app alerts). 3. CRM (Customer Relationship Management) Lead and Client Management: Store client/lead details with contact info, notes, and interaction history. Ability to categorize leads/clients by status or tags. Pipeline/Deal Tracking: Visual pipeline (e.g., Kanban board) for sales stages (Lead → Negotiation → Won/Lost). Customizable stages and fields to suit different processes. Communication Logs: Automatic or manual logging of calls, emails, and meetings with clients. Reminders/follow-ups for client interactions. 4. ERP (Enterprise Resource Planning) Features Accounting Module: Income and expense tracking with detailed categories. Ability to generate invoices, record payments, and track receivables/payables. Automated financial repor...
Retired senior needs help with keeping ongoing matters organized. Would need someone familiar with Word, Excel, willing to train for light duties in QuickBooks. At employer's residence (dealing with Parkinson's and really need some help) Personable, very laid back environment but employer needs help with filing, some calendaring, keeping appts straight etc, Offer needs to hire for a few weeks, maybe less.
...وبيانات سيتم تحديدها لاحقا الفروع: يمكن إضافة أكثر من فرع واحد لاستخدام هذا البرنامج مربع المسار: إنها مجموعة من الأسئلة. يتم تحديد عنوان الأسئلة ويتم وضع أكثر من سؤال واحد ويتم وضع أذونات للإجابة، سواء كان رقما أو كتابة أو تاريخا وما إلى ذلك. يمكنه إضافة أكثر من عنوان واحد داخل كل عنوان. أكثر من سؤال واحد (ستظهر هذه الأسئلة للشخص الذي سيستخدم النظام في شكل مربعات مملوءة (كل عنوان للأسئلة له ملف Excel أو نموذج تصميم خاص به. يتجاوز عدد عناوين الأسئلة 60 عنوانا أو أكثر ويندرج كل عنوان تحته. كل عنوان له وسيلة ولكل عنوان شكله أو نموذجه الخاص الذي يختلف عن الآخر. عند التنزيل، سيتم تزويدك بذلك (سيتم تزويدك بجميع الملفات ونريدك إدخالها مباشرة في النظام) مربع الإحصائيات: يمكنك اختيار أحد الأسئلة التي تم وضعها سابقا في مربع المسارات عن طريق الإدمان ثم تظهر جميع الأسئلة وفقا للعنوان ويحتوي...
I'm seeking an experienced freelancer to compile a detailed list of properties in a specified region. The project involves gathering and organizing property details in a comprehensive ...freelancer to compile a detailed list of properties in a specified region. The project involves gathering and organizing property details in a comprehensive and accurate manner. Requirements: - Exceptional accuracy and attention to detail. - Proven experience in data collection and organization. - Proficiency in Excel or Google Sheets for organizing property data. - Ability to research reliable sources. Deliverables: - A well-organized spreadsheet with all the required property details. If you have experience in real estate data collection or similar projects, ple...
I'm in need of a proficient Excel expert who can design a custom Excel template for tracking my expenses. The main purpose of this template is to help me with financial tracking. Key Requirements: - Design a user-friendly Excel template with a focus on expense tracking - Incorporate built-in calculations or formulas for totals and subtotals Ideal Skills: - Proficient in Microsoft Excel - Experience in creating financial tracking templates - Strong understanding of expense tracking and budgeting Please, submit your proposal if you can assist with this task.
I need assistance with my Excel template for a UPS franchise. The template currently has projections and assumptions filled out, but I need help refining the future projections and assumptions with a strong focus on sales growth. Key tasks include: - Analyzing and refining future projections and assumptions - Assisting with sales growth predictions Ideal candidates should have: - Strong numerical skills - Proficiency in Excel - Experience with business projections - Understanding of franchise operations - Ability to interpret and analyze data
...terms. I'm seeking an Excel expert to streamline our medical taxi charity's data processing. Currently, we manually track and report our statistics, which is time-consuming and prone to error. The project involves: - Creating an "intake" sheet to capture and automatically distribute data about riders, trips, volunteer drivers, and trends to relevant statistical sheets. - Designing a concise dashboard for our monthly reports, allowing for easy comparison of monthly trends and insights into our operations. - Ensuring the dashboard includes key metrics such as volunteer driver stats, client characteristics, and trip details. -Unfortunately the format for data collection has changed somewhat from month to month so there will be some man...
I'm seeking a meticulous research expert to gather competitive pricing on Amazon, Walmart, and Wayfair. The task involves analyzing many product SKUs and descriptions, and in some cases, images. I need the following data for each product: - Competitor Pricing - Unit Sales - Number of Reviews The collected data should be presented in a clear and organized spreadsheet. Ideal candidates should have strong analytical skills, experience with market research, and proficiency in using Excel or similar spreadsheet software. A keen eye for detail and the ability to interpret product images is also a plus. I'm looking forward to your bids.
...looking for an experienced and skilled Data Analyst to design and build three real-time dashboards to monitor key performance indicators (KPIs) related to sales performance, customer engagement, and operational efficiency. These dashboards will provide daily, weekly, and monthly insights, seamlessly updating in real time without the need for manual data imports. While we are currently exploring Klipfolio, we are open to alternatives such as Google Looker Studio or similar platforms if they better meet our needs. Key Responsibilities: Design and build three user-friendly, real-time dashboards to track specified KPIs. Connect dashboards directly to DX1 data reports, Excel, and other relevant data sources. Enable real-time data updates to minimi...
I am seeking a skilled and Data Analyst to create comprehensive dashboards in Power BI for a financial project. The goal is to visualize and analyze key performance indicators (KPIs) that will help to make data-driven decisions and enhance financial performance tracking. Project Requirements: 1. Data Analysis & Visualization: o Analyze and structure financial data from various sources (Excel, SQL, etc.) o Create dynamic and interactive dashboards in Power BI to visualize KPIs such as revenue, expenses, profit margins, cash flow, and more. o Utilize data models, DAX, and Power Query to enhance the dashboards. o Provide clear insights and recommendations based on the dashboard data. 2. Customization and User Interactivity: o Develop filter...
I'm seeking an Excel expert to streamline our medical taxi charity's data processing. Currently, we manually track and report our statistics, which is time-consuming and prone to error. The project involves: - Creating an "intake" sheet to capture and automatically distribute data about riders, trips, volunteer drivers, and trends to relevant statistical sheets. - Designing a concise dashboard for our monthly reports, allowing for easy comparison of monthly trends and insights into our operations. - Ensuring the dashboard includes key metrics such as volunteer driver stats, client characteristics, and trip details. -Unfortunately the format for data collection has changed somewhat from month to month so there will be some manual correc...
Hi! Usual conditions - four groups so €50 Have you got the excel file still?
I need a professional Excel expert with strong skills in data analysis, macros, and VBA. You will be required to create a sophisticated Excel spreadsheet for analyzing trading data. Key Responsibilities: - Create an advanced Excel spreadsheet for trading data analysis - Incorporate real-time data updates into the spreadsheet - Implement advanced charting and visualization techniques - Design automated trading signals within the spreadsheet Ideal Skills: - Excel: Advanced spreadsheet creation and optimization - Macros and VBA: Proven experience in automating tasks and enhancing workflow - Python: Familiarity with Python for data analysis and Excel integration would be a big plus. Payment: - The designer will be compen...
I'm in need of custom Excel templates specifically designed for financial reporting. These templates will be used primarily for tracking and managing accounts receivable. Ideal skills for this project include: - Advanced Excel proficiency - Experience with financial reporting - Knowledge of accounts receivable management - Ability to create user-friendly templates
I'm looking for a freelancer who can help me automate the analysis of trading oi and volumes from the NSE using Excel. Key Tasks: - Automate the collection and analysis of NSE trading volume data within Excel - Use statistical analysis techniques to interpret the data The ideal candidate for this job should be proficient in Excel automation, have a strong understanding of statistical analysis techniques, and be familiar with NSE trading volumes.
I need assistance with using mathematical formulas in Excel, specifically 'Sum and Average' and 'Index and Match'. Your role will mainly involve data entry and creating charts. Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience with data entry and chart creation - Familiarity with mathematical formulas, specifically 'Sum and Average' and 'Index and Match' - Attention to detail and ability to work accurately.
I'm seeking a proficient web scraper to extract contact details from the provided website. Ideal Skills: - Proficient in web scraping tools and software. - Experienced in data extraction from company websites. - Deliver the extracted data in Excel format.
I need a freelancer who can help me with integrating the Arctic API to Google Sheets. This project involves transferring real-time user data from the Arctic API to Google Sheets. The specific data to be transferred includes user profile information and activity logs. Key Requirements: - Experience with API integration - Proficient in Google Sheets - Able to set up real-time data updates Looking forward to your proposals.
...Needed: 1500+ (Each answer should be handmade, not AI-generated or copy-pasted). Quora Account Requirements: You must use different Quora accounts (15+ accounts, each minimum 1 year old). Each account needs to post 100+ answers. Accounts must be active and ready to post answers. Provide us with the email and password for each account you use. Quality Standards: Answers must be relevant to the niche we promote. You must use the name of our website in your answer and bold it for better visibility. Answers should be detailed, informative, and tailored to the question. No copy-pasting or AI-generated content. Question List: We will provide the list of questions via Google Sheets. Your job will be to answer these questions directly on Quora, ensuring each response is unique,...
... We are seeking an experienced data researcher or lead generation specialist to create a detailed and accurate list of car dealerships in the United States. The list must include essential contact information to support our business development efforts. Deliverables: Dealership Name Full Address (Street, City, State, ZIP) Website URL Sales Manager's Name (preferred) or General Manager Sales Manager's Email Address (verified) Sales Manager's Phone Number (if available) Any other relevant information (e.g., dealership size, brands sold) Key Requirements: The data must be accurate and up-to-date. Contact information should be verified and checked for validity. Data should be delivered in a well-organized Google...
I'm in need of assistance with data entry into an Excel sheet. The data is of mixed types - both text and numeric. Key tasks include: - Manual entry from various files - Ensuring the data is organized into standardized rows and columns Ideal candidates should have: - Proficiency in Excel - Attention to detail to ensure accurate data entry and formatting.
I am in need of comprehensive data about lodges in the Serengeti ecosystem. This data should include both the latitude/longitude of these lodges and reviews. Your task will be to compile this information into an Excel spreadsheet. The completed data set will be used for a research paper, so accuracy and thoroughness are paramount. Ideal skills and experience for this job include: - Proficiency in data collection and analysis - Experience with Excel - Attention to detail - Ability to understand and meet academic research standards.
...routes. • Multiple map views with status indications (idle, parked, moving). • Real time fuel tracking via data from the vehicles original fuel gauge system. 2. Subscription and Payment Platform • Payment gateway integration for subscription renewals and package purchases. • Notifications for payment confirmations. 3. Advertisement Platform • Allow placement of ads for related services. • Dynamic ad slots for targeted promotions. 4. Device API Integration • Support for APIs from various tracking devices (e.g., Cantrack, Teltonika, Tramigo, Fifo, Baanooliot). • Real-time reporting and seamless communication. 5. Reports and Analytics • Graphical, Excel, and PDF report formats. • Exportable data for vehicle status, trip...
I'm in need of an Excel expert to help me create a comprehensive savings tracker. This spreadsheet needs to have a variety of features and capabilities to assist in monitoring and managing my savings. Key Requirements: - The spreadsheet should automatically calculate various components, reducing the need for manual input and increasing efficiency. - It should have a user-friendly dashboard that presents key information clearly and succinctly. Calculations Needed: - The tracker should be able to calculate my monthly savings. - It should also project my total savings over a set time period. Ideal Skills: - Proficiency in Excel is a must, with experience in creating similar spreadsheets highly desirable. - Ability to design intuitive dashboards within Excel. - Str...
Training Video Creator for Sales Team We are a leading provider of steel buildings, sheds, and accessory structures. We are seeking a talented freelancer to create training videos for our sales team, using Google Vids to ensure flexibility for future edits. The training videos will focus on explaining the use of our custom Google Sheets Quoter. This tool has been developed over the years to simplify and streamline the quoting process for our products. It allows users to: - Select all options and variants to build a structure. - Generate accurate quotes for customers. - Produce final product details and POS (Point of Sale) paperwork. Responsibilities: - Create clear, professional, and easy-to-follow video tutorials using Google Vids. - Demonstrate each feature of the...
...availability, and user details. 2. Availability Updates: Allow manual updates for unavailable time slots. 3. Payment Handling: Automatically log payments and flag unpaid bookings. 4. Scalable Solution: Ensure the system can handle multiple concurrent users. Tech Stack: WhatsApp Business API or tools like WATI/Twilio Studio. Payment integration (Razorpay/Paytm/Stripe). Google Sheets or any lightweight CRM for booking management. Deliverables: 1. Fully functional WhatsApp booking automation system. 2. Integration with payment gateways and OTP verification service. 3. Google Sheet/CRM integration for admin booking management. 4. Documentation for using and maintaining the system. Timeline: Project completion within 3 days. Please provide link of any s...
Busco desarrollar un módulo para Perfex CRM, orientado exclusivamente a desarrolladores con experiencia previa en esta plataforma. Funcionalidades principales del m...según los requerimientos fiscales locales. Generación de reportes: Crear reportes específicos requeridos por la dirección de impuestos. Los reportes deberán cumplir con plantillas oficiales establecidas (se proporcionarán detalles en formato Excel para mayor claridad). Asegurar que la generación de estos reportes sea compatible con las normativas fiscales aplicables. Nota importante: Este proyecto está dirigido únicamente a personas con experiencia comprobada en Perfex CRM. Proporcionaré detalles adicionales, como los formatos de los report...
...report but the invoice they apply the payment to is not the same one as we make the payment for, as due to cash flow we have to sometimes split payments up. They may apply it to the oldest invoice. There is however sometimes errors where they have not applied our payment and we need a way to quickly spot these, without intensive labour. We need a chatgpt (or google) prompt that will take these two sheets and return a list of possible errors, it may be easier to provide a sheet that links our payment to whichever invoice the supplier has applied it to by checking the amount, note the supplier will list the same invoice ID multiple times as it's per item and our total is for the total. I think a solution is just to take anything that is type "Payment" in column ...
...implement a tailored solution that will replace my current project management setup, which includes Trello boards, Excel spreadsheets, and physical files. Key functionalities include: - Central Hub for all contacts - Accounts board to manage deals from inception to completion - Integrated management system for contacts, leads, sales, projects - Dashboards Currently, we don't have a dedicated CRM software. Customer and project management is done manually and is becoming increasingly challenging. Therefore, the ideal freelancer for this project should have: - Extensive experience with monday.com. - Strong understanding of CRM systems. - Good knowledge of data analytics and task management tools. - Excellent design skills to create a user-friendly interface. - The ...
...tariff document. This PDF includes company details, a tariff table (with vehicle types, sizes/capacity, prices, and minimum charges per mile), our logo, and a footer with contact details and a website link. We do not require a redesign of the PDF; rather, we need to link the PDF to an Excel spreadsheet, so that when we update vehicle details, prices, or other information in Excel, the changes will automatically reflect in the PDF. The final deliverables should include the existing PDF document, a linked Excel file, and clear instructions on how to update the file efficiently. The goal is to streamline the updating process without requiring manual edits in Adobe, making it easier for all team members to manage the content. If you’re able to provide this servi...
We search MAKE Expert for : - Incorporate Google Sheets as a mandatory security step between Shopify and PrestaShop on flow. - Ensure compatibility and correct data formatting during the transfer between Shopify, Google Sheets, and PrestaShop. Additional information Via MAKE, we want to send orders from shopify to prestashop with a google sheet in the middle. >>> We already made a flow without the google sheet step that works smoothly between shopify and prestashop. However for security reasons it’s mandatory to add the Google sheet step in between. The issue : We are unable to get and read the right format of the datas on the google sheet in between the Shopify and prestashop module on Make. Here are the flows details : - Flow 01 - Module Watche...
Google Sheets Creation for Real Estate Tracking
...confiables. • Experiencia en programas de detección de similitudes como Turnitin o iThenticate: Pueden ser útiles para buscar coincidencias con otros textos. • Competencia en el uso de software para la gestión de referencias (Zotero, Mendeley, EndNote o similar). • Habilidad para buscar fuentes académicas en bases de datos y bibliotecas digitales. • Dominio de herramientas digitales como Word, Excel, y gestores de documentos en la nube (Google Drive, Dropbox, etc.). • Conocimiento de formatos de citas académicas (APA, MLA, Chicago). • Atención al detalle y precisión en el trabajo con textos. • Idiomas: español e inglés (italiano sería un plus). Material de partida: ...
I need a program/software to streamline the process of creating consistent Safety Data Sheets (SDS) from various source files. Each file is a PDF or Word document, and the program should extract relevant text elements and fill them into a Word Document template. Key Responsibilities: - Extracting text elements: The software needs to identify and pull out the title and headings, paragraphs and descriptions, as well as tables and data fields from the source files and fill in the correct sections. No text should be lost. - Template filling: The extracted information should be inserted into a predetermined Word Document template.I also have the Indesign working file as well. Please note that the source files will be uploaded manually, so the software should be user-fri...
I'm seeking a meticulous freelancer to help me input mixed data (text and numerical) from paper documents into a single Excel worksheet. Ideal Skills: - Proficient in Excel - Excellent attention to detail - Experience in data entry from paper documents - Able to handle mixed data (text and numerical) - Familiarity with OCR software to convert printed or handwritten text into machine-readable data. - Expert in verifying data entries for accuracy and completeness. - Proficiency in organizing and managing files to ensure data is easily accessible. - Basic mathematical skills to handle numerical data accurately. - Ability to handle sensitive information with a high level of confidentiality. The project involves less than 100...
I'm seeking a skilled Excel professional to design a comprehensive scheduling spreadsheet for managing project timelines. Key Requirements: - The spreadsheet must be created in Microsoft Excel. - It should include drop-down menus that are linked to if/then statements, filling in information on additional sheets as necessary. - The main project timeline sheet will need to capture task names and descriptions, start and end dates, assigned team members, and a tool and material list. - The tool and material items should be linked to task descriptions. The spreadsheet will be designed to be as user friendly as possible. The Goal is to autofill as much as possible and use repetitive task lists to create a material and tool list preparation guide. This is the most d...
I'm in need of a professional data entry and scraping expert to assist in filling out a Google Sheet using SensorTower. Instructions and examples have been provided. The data primarily focuses on downloads and revenue statistics. Key Requirements: - Proficiency in data scraping and data entry - Familiarity with SensorTower is a plus - Ability to follow instructions accurately - Experience with Google Sheets Please write 'APPLES' as a test to confirm you are not a bot.
Seeking data collection specialist for 3D printing price research across 30 to 40 online platforms. Project involves: Collecting pricing data for various 3D printed parts (7 different sizes) Comparing quotes across multiple technologies (SLS, MJF, FDM, Metal L-PBF) Documenting prices for different materials (plastics and metals) and quantities (1-1000 units) Creating structured Excel dataset with 9 columns including platform details, manufacturer info, technology specs, and total costs Documenting inaccessible platforms and URL changes Deliverables: Excel file with comprehensive pricing data Protocol document noting platform accessibility issues Timeline: Due by February 15th Required skills: Data collection, Excel, Basic u...
...qualitative research project within my company and need an experienced professional skilled in NVivo 12 and thematic analysis to assist in analyzing data from 6 structured interviews. The project focuses on extracting deeper insights to develop key sections for Findings, Analysis and Discussion, and Reflection and Conclusion, aligning with research best practices. Scope of Work: 1. Findings: - Present the gathered data without analysis or discussion, ensuring alignment with the data provided. - Include information on how, when, and where the interviews were conducted. - Incorporate details about participant consent, participant information sheets, and brief descriptions of participants (e.g., demeanors like confident, apprehensive, relaxed). - Identify and ...
take mp4 as input, convert mp3 and do RAG , use pinecone to upload vector. and save answers in excel file according to questions in local folder.
As we deal will Convert Anki .apkg to Excel with 10$
What is 167 * 4? Please answer this question to confirm that you’ve read and understood the job description and the requirements outlined. . . I am looking for someone with access to multiple Apollo accounts to extract leads using specific filters that I will provide. The filtered results should total approximately 150,000 contacts. The leads must be downloaded and compiled into an organized Excel file for easy access and use. My budget for this project is $50. If you successfully complete this task, there will be an opportunity for ongoing work with unlimited similar projects every month.
Automate Your Adobe Workflow with Custom Scripts I specialize in developing automation scripts for Adobe applications like Photoshop and Lightroom. I can automate any task possible within Adobe applications, enabling it to be repeated hundreds of times with precision. Whether you need to streamline repetitive tasks, integrate external tools (Excel, Word, etc.), or create a fully-featured automation with a user-friendly interface, Ive got you covered. My scripts save time, reduce errors, and boost efficiency. Each solution is tailored to your specific needs, with fast delivery, clear documentation, and professional support. Lets simplify your workflow and take your productivity to the next level! Every solution is custom-built to your requirements. If you record a video showing the...
I'm in need of a logo for my YouTube channel. The design should be minimalistic yet vibrant, as I want it to use multiple colors rather than sticking to a monochromatic or black and white scheme. The logo should incorporate both text and an icon, so experience with combining these elements creatively is essential. Key Requirements: - Design a minimalistic yet colorful logo - Combine both text and an icon in the design - Prior experience with YouTube logo design is a plus - Ability to deliver in various formats suitable for YouTube Please only apply if you can provide a portfolio of similar work. I look forward to seeing your creative proposals.
