Stata use data excel 2007 jobs
I'm looking for a skilled freelancer with expertise in Power Automate and Excel coding. I need assistance with automating data entry and updates in my Excel worksheets. Key Requirements: - Automate importing data from an email and CSV/Excel files into my Excel sheets. - Streamline the process of updating existing records. Ideal Skills: - Proficiency in Excel and Power Automate. - Experience with data handling and automation. - Strong attention to detail and ability to validate data. The goal is to save time and enhance efficiency with data management. Please share your relevant experience and examples of previous projects.
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
I'm in need of a data cleaning professional to help me with a spreadsheet containing 50,000 rows of company details. The data is currently organized in a single column and includes company names in mixed formats. Key Responsibilities: - Extract company names from the data strings - Clean the data manually to ensure accuracy Ideal Candidate: - Proficient in Excel or similar data management software - Exceptional attention to detail - Previous experience with data cleaning or data entry - Able to work independently and meet deadlines Please note that the company names are in mixed formats, so the ability to recognize and standardize these is crucial.
I'm looking for a proficient data entry specialist who can help me record mixed data (text and numerical) from Excel files. Key Responsibilities: - Accurately inputting mixed data (text and numerical) from provided Excel files. - Ensuring data integrity and accuracy during the entry process. Ideal Skills: - Proficiency in Excel and data entry. - Attention to detail to ensure data accuracy. - Experience in handling mixed data types. Please provide your experience with similar projects in your bid. Thank you.
...telecalling, sales, or customer interaction is a plus. What We Offer Remuneration: INR 20,000 per month (fixed) + attractive sales commission. Growth Opportunity: Potential to transition into a full-time role based on performance. Flexible Work Hours: Ideal for individuals looking to balance other commitments with a rewarding part-time role. How to Apply If you believe you have the skills and drive to excel in this role, please send your updated resume and a short voice recording introducing yourself....
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
I'm in need of a comprehensive Excel workbook that can assist in managing and scheduling both staff and volunteers. The workbook should be capable of: - Scheduling staff and tracking days off - Computing hours and calculating salaries Additionally, the workbook should enable viewing the schedule in Gantt charts. Ideal candidates for this project should have a strong background in Excel, particularly in creating complex workbooks with various functions. Experience in HR or volunteer management is a plus. Please note, I will be providing the data necessary for hours computation and salary calculation.
Instructions for Data Scraping Task Your task is to extract specific information from job posting links. Below are the detailed requirements: Data Points to Scrape: 1. Company Information: - Company Name - Company Details: Brief about the industry or type of work they do. - Company Website - LinkedIn Page: URL to the company’s official LinkedIn page. 2. Email IDs (3 Required): - Find 3 individuals' email IDs from the following departments: - Admin - Human Resources - Head of Sales/Top Leadership (CXO level in Sales) - Marketing Head/Top Leadership (CXO level in Marketing) - Founders/CEOs/Co-founders/Owners 3. Email Requirement: - The email IDs must be professional (e.g., `name at `). - Avoid generic emails like `...
I need a freelancer who can assist me with data extraction from PDF files. The task involves: - Extracting text content from PDF files. - Accurately entering the extracted data into an Excel file. Ideal skills and experience for the job: - Proficiency in data entry with high attention to detail. - Prior experience with PDF data extraction and Excel. - Ability to maintain confidentiality and handle sensitive information with discretion.
I'm looking for a skilled data analyst and Python programmer to create a code in Jupyter Notebook for analyzing data from Excel files. The project involves: - Primarily focusing on data analysis - Utilizing Pandas and NumPy libraries Ideal candidates should have: - Extensive experience with data analysis and Python programming - Proficiency in using Pandas and NumPy - Ability to work with Excel files - Familiarity with Jupyter Notebook Please include in your bid examples of similar projects you've completed. You are required to write the necessary program and create an effective presentation describing: The military spending of at least the top 10 nations (in military spending) Compare the data to that country’s GDP, C...
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
I'm looking for an Excel expert who can create a dynamic data visualization tab for analyzing financial data specifically for ROI metrics. The main focus will be on cost savings and investment returns. Key Requirements: - Use of Charts and Graphs: I need clear and engaging visual representations of the data. - Pivot Tables: Help in summarizing the data and making the analysis more manageable. - Conditional Formatting: To highlight key trends and important information in the data. Ideal Skills: - Advanced Excel: Proficiency in using Excel's more complex features. - Financial Analysis: Understanding of financial data and metrics. - Data Visualization: Ability to present data in a clear and engaging way. ...
I need someone reliable to input data from PDF copies of timesheets from our construction crews into Excel for weekly costing purposes. - Data: Approximately 80 sheets per day, each covering 5–20 personnel - Delivery: I will send these sheets in a couple of batches on Friday / Monday. I need the completed task back first thing Tuesday. - Duration: This will be a weekly task for the next three months. - Resources: I can provide the employee names in Excel format, which will help improve data validation and accuracy. Skills and experience: - Proficiency in any spreadsheet software (Microsoft Excel, Google Sheets, etc.) - Experience in data entry - Attention to detail - Good communication skills Communication: My preferred method is ...
I am looking for someone to copy and paste ALL the titles from my website into an Excel sheet You must copy and paste everything, EVERYTHING, EEEEEVERYTHING I will check only once and, if I find anything missing, the job will be rejected I have three websites. the budget is CAD$30
I have a corrupted Excel file that I'm unable to recover myself. The file contains complex formulas, and I'm unsure how it was corrupted - it could have been from a software crash, a virus attack, or an unexpected shutdown. - Any experience with data recovery from Excel files would be a plus
I'm in need of a professional who can create a product sales invoice in Excel for my business. The ideal freelancer for this project should have extensive experience with Excel and be able to incorporate specific features into the invoice. Key features include: - Automatic tax calculation - Discount options - Customizable logo and branding Each invoice needs to detail each product with: - Product description - Quantity and unit price - Product code or SKU It's crucial that the freelancer understands how to design an invoice that is both functional and visually appealing, reflecting my brand identity.
I have a 30-page PDF spreadsheet that is currently a scanned image. I need this data transcribed into Excel. The data is consistent across the pages, but primarily consists of text and some numbers. Key requirements: - PDF is a scanned image - Data is text-based - Needs to be converted into Excel Ideal skills: - Proficient in data entry and transcription - Familiar with Excel - Attention to detail to ensure accurate data transfer
I need an Excel spreadsheet to monitor the billed hours of each of our automotive technicians, as well as their total team hours each day. This tracking should be in relation to the daily goals we've set for them. This website gives some example of what I'm after Key Features: - A bar chart graphic display to visualize the data (along with actual numbers) - Tracking for individual technician hours and combined team hours - Comparison of hours worked against daily goals for individual as well as team -The graphic should represent how close to the set goal they are. Below 80% is red, 80-99.9% is yellow and 100% and up is green. Our automotive technicians are paid a bonus based their actual billed hours vs their target goal for billed hours. Also as a
I'm looking for a comprehensive three statement model to assist with investment analysis on the company ASML. This model should enc...encompass the following financial statements: - Income Statement - Balance Sheet - Cash Flow Statement In addition to the standard financial statements, the model should also include: - Discounted Cash Flow (DCF) analysis - Comparable company analysis (Comps) - Sensitivity analysis Ideal candidates should have extensive experience in financial modeling and investment analysis. Proficiency in using Excel for complex calculations is crucial, as is a solid understanding of DCF and Comps methodologies. A background in finance or a related field would be beneficial. Your expertise will help guide investment decisions based on the insights provided...
...skilled Excel professional to update my spreadsheet. The updates involve enhancing the existing formulas and functions, as well as improving the design and formatting. The base document just needs minor updates and needs to extend monthly from 2025-2035 Key Requirements: - Expertise with Excel functions and formulas - Strong skills in design and formatting Please note, the specific functions and formulas that need to be implemented have not yet been determined. However, you should be comfortable using lookup functions (like VLOOKUP, HLOOKUP), statistical functions (like AVERAGE, MEDIAN), and logical functions (like IF, AND, OR). Your ability to understand and manipulate data will be crucial to the success of this project. Ideal Skills: - Advanced Excel s...
I'm in need of an Excel specialist. The main task involves creating an advanced Excel formula to assist with financial calculations, specifically focusing on data lookup. Key Tasks: - Design and implement an advanced Excel formula to perform financial calculations - Focus on data lookup aspects - Potential use of VLOOKUP, INDEX and MATCH, XLOOKUP or other relevant functions Ideal Skills: - Strong proficiency in Excel, especially with advanced formulas - Experience with financial calculations - Ability to translate complex data into understandable results - Familiarity with data lookup functions If you can help me navigate this task, please make a bid.
I'm seeking an Excel expert to assist with my financial data. The primary task will be to combine data and formulas to generate comprehensive reports. Ideal Skills and Experience: - Advanced Excel skills with extensive experience in handling financial data - Proficient in combining various types of formulas - Strong report generation skills - Previous experience with financial data analysis highly preferred.
I'm in need of an Excel course aimed at beginners. Key Course Topics: - Basic formulas and functions: Teach how to use simple formulas and functions in Excel. - Data entry and formatting: Focus on how to input data and format it correctly. - Charts and graphs: Introduce the basics of creating and interpreting charts and graphs. - Pivot Tables Content Delivery: The course should be delivered through engaging video tutorials. Ideal Skills: The freelancer should have a strong proficiency in Excel, experience in course development, and skills in video production. Experience in teaching or creating educational content is a plus.
I'm looking for an Indian freelancer to help me source local wood suppliers, specifically general wood suppliers, and obtain price quotations for Birch wood and wooden beams. Key Tasks: - Conduct an online search for prices and provide URLs in an Excel sheet. - Call companies for pricing and stock availability. Only consider companies that can deliver directly from stock. - Delivery must be to Mumbai. Products: - Birch wood: 12 mm thick, water resistant limed, in two sizes (2.40x1.20 meter - 30 pieces and 3.00x1.50 meter - 30 pieces). - Wooden beams: 4cm x 14cm and 6 meters long (most economical option) - 100 pieces. Requirements: - At least 3 accurate prices from different companies for both products. - Task needs to be completed by 19:30 India time on Friday 10 January. ...
I have an Excel billing sheet and need a new Excel document that connects with it. The purpose of this document is to pull a few fields from the billing sheet and present them in a form layout. Key requirements: - The new Excel should pull the following fields from the billing sheet: - Invoice Number - Client Name - Total Amount Due - Date of Service - Service Code Ideal skills for the job include: - Proficient in Excel - Experience with designing forms in Excel - Knowledge of linking data between Excel sheets.
As discussed basically want it to look like an excel sheet, all the scanner names lined up at the top and have the stocks come down under each. and scanner in this order Multi Scanner, Breakout High, Daily High, Volume Inc. , % to change gainer, Intra Day Rise, Hug 9 EMA, HODspike, 2minSpike2. Have scanners update every 2-3 min.
I'm seeking a data analyst skilled in TTR (Turnaround Time) evaluation, specifically focusing on trends over time. Key Requirements: - Analyze historical TTR data to identify trends over time. - Utilize provided Excel/CSV files for the analysis. - Present findings in a clear and understandable manner. Ideal Skills: - Proficient in data analysis and statistics. - Experience with TTR analysis. - Able to work with Excel/CSV data files.
I need a data analyst to evaluate an Excel spreadsheet containing project data. The analysis should cover run rates, forecast dates, and schedule adherence on a weekly basis. Ideal Skills: - Proficient in Excel - Experienced in data analysis - Able to interpret project metrics No set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I'm Mandeep Kaur, a 25-year-old seeking help with data entry tasks. You will be primarily tasked with: - Excel data entry - Assisting with filling out application forms Skills & Experience: - Proficient in Excel - Detail-oriented and able to accurately fill out forms - Previous experience with data entry preferred Looking forward to your bids!
I'm in urgent need of a pre-existing, cloud-based payroll system that can seamlessly integrate with my ERP system. The payroll program must possess the following functionalities: - Automatic tax calculations - Direct deposit processing Please note, I do not wish to entertain bids proposing to construct a payroll system from scratch. This project is for a ready-to-go solution that can be implemented immediately. The payroll will include tax tables for all 50 US states, direct deposit, and automatic tax payments to state and federal government The integration with my ERP system will be through an API. Therefore, experience in API integration is essential. Proficiency in payroll systems, ERP systems and cloud technology will greatly enhance your chances of being awarded this project....
I'm looking for a web-based script for managing a domain portfolio. The script shou...revenue for cost comparison - Add domain name costs per extension (e.g., .com, .net, .xyz, etc.) to monitor yearly costs of each portfolio - Export files per portfolio, as well as a global export - Backup daily and send via email The script should use a simple Username & Password authentication method. The ideal freelancer for this project should have prior experience in domain management and web script development. Knowledge of domain valuation and renewal processes is a plus. The script should allow for import/export in CSV and Excel formats. I'm open to additional features you may suggest based on your expertise. Please only apply if you are serious and able to...
Description: We need a creative, high-quality logo for Vocabble, a vocabular...nature of the game, appealing to both children and their parents. Requirements: Game Name: The logo must prominently feature Vocabble. Slogan: Include a slogan like below: "Play, Learn, Master English" "Building Brighter Minds!" "Unlock the Power of Words!" "Play, Learn, Excel!" ..... or you can suggest one. Design Style: Clean, modern, and colorful, appealing to families. Avoid overly complex elements. Format: Deliver in vector format (illustrator/corel draw format )and high-resolution PNG/JPEG for print and digital use. Need source file with all the fonts and elements. If you have any questions, pls dm me. Thanks. We’re looking for a logo that...
...creating a custom web application with a primary focus on data analytics and reporting. Key Responsibilities: - Develop a robust custom web application - Implement user management features - Integrate data analytics and reporting functionalities - Ensure seamless integration with various data sources Ideal Skills: - Proficiency in Laravel and Vue - Extensive experience in REST API development - Strong background in data analytics and reporting - Skilled in working with databases (e.g., MySQL, MongoDB) and APIs (e.g., REST, GraphQL) The project will involve integrating with multiple data sources, including databases and APIs. Experience with external data sources such as CSV and Excel will also be beneficial. Your ability to handle com...
...transform multiple Excel sheets into an interactive Power Apps platform for various users. The project also includes the creation of a comprehensive dashboard. Key Requirements: - Transforming Excel sheets into a user-friendly Power Apps - Developing a dashboard tracking performance metrics, operational statistics, and assisting with actions and decisions Dashboard Visualizations: - Bar charts and line graphs - Pie charts and donut charts - Tables and matrices - Conditional formatted tables Additional Considerations: - Power App must support multiple clients in an Active Directory format Ideal Skills and Experience: - Proficiency in Power BI and Power Apps - Experience in creating interactive dashboards - Knowledge of Active Directory configurations - Ability to visua...
I'm in need of a Python script that can extract numerical data from an Excel/CSV file. The ideal freelancer for this project should: - Have extensive experience with Python, particularly in data extraction. - Be proficient with handling Excel and CSV files. - Be able to write clean, efficient code. Please note, the data will be purely numerical. The script will need to be able to handle large datasets with ease.
Build quote template as below - 1. Polish quote template 2. Macro to create new tab 3. Macro to add new slot in existing quote 4. PDF generation with Inclusion and Exclusion List 5. Push quote info to CRM (if API exists)
I need to create 1 or 2 shortcut keys with macros in Excel for automating the formatting and reporting of my data. Ideal skills for this job: - Proficiency in Excel - Experience in creating and implementing macros - Ability to automate tasks efficiently
Hi, we need the attached PDF document to be translated from Italian to German, destination: Switzerland. We don't have the OCR for this, but I send you both the Word editable document of the first part, and the Excel that contains the following part (table). Please, use the Word and the Excel documents to create one only final document, like the PDF. I kindly ask you to add [unleserliche Unterschrift] wherever a signature appears. We don't have any specific deadline for that.
...assist with various bookkeeping tasks. Key Responsibilities: - Recording transactions: Timely and accurately inputting all financial data - Reconciling accounts: Ensuring all accounts are balanced and discrepancies are addressed - Generating financial reports: Preparing clear and concise financial statements - Budgeting: Assisting in the preparation of budgets - Auditing: Conducting internal audits to ensure financial accuracy - Forecasting: Providing financial forecasts to aid in strategic planning - Invoicing: Preparing and sending out invoices - Project bookkeeping: Keeping track of finances for specific projects - Must know QuickBooks, NetSuite and Excel Ideal Candidates Should Have: - Extensive experience in bookkeeping - Proficiency in using accounting software - ...
Email Marketing Project Details Objective: Send two email campaigns to 5,000 current sports bettors with accounts who have not yet made a deposit. Project Overview: Target Audience: 5,000 recipients. Data provided in Excel format (includes recipient email addresses and other necessary details). Email Content: Email 1: Includes a dynamic, clickable banner and text for sports bettors. (both provided by me. Naturally I want your input). Email 2: Sent three days after the first email, includes new text aimed at casino and slots players (provided by me). Sending Details: Emails should be sent from a professional-looking sender name such as: "Mike Spencer – Your V.I.P. Host". The sender email address must be configured to forward any replies directly to my email. T...
I'm eager to create a WordPress site employing Elementor, mirroring the structure of the specified websites. The aim is to build a site that utilizes similar layouts and features, while integrating the theme from Webshark.se. The site must be fully adjustable, enabling me to effortlessly modify text, images, and colors. Key Features: - Incorporation of header and footer layouts, color schemes and fonts, and page structures from the example sites - Chat functionality that combines live support and a Chatbot for automated responses - Pop-up functionality serving as a contact form - A design and structure based on the aforementioned examples - User-friendly interface allowing easy adjustments without the need for further development help I'm looking for a professional with substan...
I need an existing Excel spreadsheet, which tracks employee data, to be transformed into a secure, user-friendly system. Key Requirements: - The system should provide view-only access to certain users, while others can edit designated sections. - It should automate calculations and formulas, as well as validate data entries to ensure accuracy. Ideal Skills: - Proficient in Excel with experience in spreadsheet security and access control. - Capable of creating automated systems within Excel. - Previous experience with HR-related spreadsheets is a plus.
In my company the arrival of the inventory to the warehouse is recorded manually in the attached excel file, in the tab "ARRIVO PRODOTTI". Each product is assigned a specific row. For each row the following columns are filled in: ARTICOLO (item code) DESCRIZIONE (item description) DATA PREVISTA (estimated availability date) I° REVISIONE DATA (first revised availability date) II° REVISIONE DATA (second revised availability date) III° REVISIONE DATA (third revised availability date) QTY (quantity) STATO (status) I would need a button for each row, next to the column STATO. The button, powered by a macro, when pushed should trigger an email to be sent to a list of internal recipients, with subject and text filled in with the val...
...organization of electricity and water bill data (PDF format) into a specific Excel structure. We will provide sample bills AND a detailed mockup of the desired final output format. This ensures your solution directly addresses our exact needs. Data Points (extracted from PDFs): Company Name Flat/Shop Number Account Number Disconnection Notices (flag/status) Electricity, Water Consumption Municipality Period Start Date, End Date Previous Balance, Total Amount Due Key Requirements & Deliverables: Automated Extraction & Formatting: Develop a Power Query workflow to: Pull data points reliably from PDFs according to the provided format guide . Structure the extracted data...
I'm looking for a WordPress professional to assist with the installation and configuration of SEO and OTP plugins on my site. 1. I want to add data by one person or by team or upload contacts in bulk, I want to have the facility to get contacts approval? When a new listing is added in my website a. From link posting advertisement- , the advertiser should get whats app or mail or SMS for confirming or declining the advertisement. or b. Upload bulk listings available in excel file containing listings data from admin panel using plugin wpallimport plugin, all numbers should get whats app or mail or SMS for confirming or declining the advertisement. 2. Need to disable the mail id as mandatory field and would like to have
