Dat files excel jobs
We need to add thousands of products to our ecommerce website. Most of our suppliers do not provide the product images and product documents like specification and installation documents. We need help getting these images and documents from supplier websites. You will be provided with excel files for each supplier with the full list of product for which to get images and documents
I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!
I need a fillable PDF created from an Excel worksheet. The PDF will be used to conduct a survey and will include both multiple choice and short answer questions. Key Requirements: - Convert specified Excel worksheet into a fillable PDF. - Incorporate various types of survey questions (multiple choice and short answer). - Ensure the PDF can be easily returned via email once completed. Ideal Skills: - Proficiency with Excel and PDF creation software. - Experience in designing user-friendly fillable PDFs. - Understanding of survey design and data collection processes.
I need an expert in Excel to assist me in merging two files. The task involves transforming the data in these files before the merge. Ideal Skills: - Proficient in Excel, particularly in data transformation techniques - Experience with data merging - Attention to detail for accurate data handling
I have 6 excel spreadsheets containing attendee information for some small upcoming events. I need the data sorted into groups by age and other specific requests. Additionally, I need some standard data cleaning to be done, specifically standardizing phone numbers and removing duplicates. Ideal skills for this project include: - Strong proficiency in Excel - Attention to detail - Good understanding of data sorting and cleaning techniques Please bid if you can assist with this task.
I need help with reworking an existing venture capital excel model for a new investment. The model should provide accurate financial returns for this investment. Specific Sections: - Revenue projections - Expense forecasts - Return calculations Assumptions to Update: - Market growth rate - Cost of goods sold - Operating expenses New Financial Metrics to Incorporate: - Internal Rate of Return (IRR) Ideal Skills: - Expertise in Excel and financial modeling - Understanding of venture capital and investment analysis - Strong analytical and problem-solving skills Experience: - Prior experience reworking venture capital models - Proven track record of accurate financial forecasting I'm looking for a freelancer who is detail-oriented and can deliver a robust model that me...
I'm seeking a skilled professional who can adjust my existing automotive race car CAD files for 3D printing. The adjustments are specifically needed in certain sections of the models. Ideal skills for the job: - Proficiency in CAD software - Experience with 3D printing - Attention to detail - Ability to modify specific sections of complex models
...statements for each account have already been converted to excel format. You must go through the transactions for each year and properly itemize each transaction and creat the Businesses Financial Statements (PNL & BS) for tax filing purposes. This role also involves reviewing my personal bank account statements to identify any business-related transactions made that should be included such as making a payment for a business credit card, owner investments, and Etc. I need this to be completed ASAP perferably by the end of this week if possible. Key Responsibilities 1. Organize and Classify Transactions: Review and categorize all business-related transactions from each accounts transactions that have already been converted to excel from the PDF statements, including: ...
I need a Data Entry Specialist, preferably with an engineering background, for a 3-hour task. This project involves: - Transferring mixed data (numerical and textual) from a PDF document into an Excel spreadsheet. - Organizing the data by categories or sections in a clear and user-friendly format. - Applying both totals and averages using basic Excel functions or formulas. The ideal candidate for this task must: - Have a strong proficiency in Excel. - Possess keen attention to detail and accuracy. - Be able to complete the task within 3 hours. Given the nature of the task, an engineering background would be beneficial due to the need for precision, analytical skills, and a structured approach.
I need assistance pulling all followers from my business Instagram account. Specifically, I'm looking for their username, email, and name (if available). Ideal skills for this project include: - Proficiency in data extraction and web scraping - Familiarity with Instagram's platform and its data privacy rules - Experience in data pres...need assistance pulling all followers from my business Instagram account. Specifically, I'm looking for their username, email, and name (if available). Ideal skills for this project include: - Proficiency in data extraction and web scraping - Familiarity with Instagram's platform and its data privacy rules - Experience in data presentation using Excel or CSV formats Please bid only if you can deliver the data as a neatly organ...
I'm in need of a comprehensive spreadsheet to track various employee absences. The types of absences I want to monitor include sick leave, call-o...spreadsheet should capture the date and time, the reason for the absence, whether the employee gave late notice or not, and the number of "attendance points". - Identification: Employees should be identifiable by their full name. Here are some links to tutorial for similar trackers: Ideal Skills: - Proficiency in Excel or Google Sheets. - Experience in creating tracking spreadsheets. - Understanding of HR metrics would be a plus. Please ensure that the spreadsheet is user-friendly and can be easily updated on a regular basis. Looking forward to your bids.
I have two Excel files detailing my wine collection - one is from 2023 and the other is an update. I'm looking for someone to identify the differences between the two files. Specifically, I need to see: - Changes in item quantities - Any addition or deletion of items After the comparison, I would like the results to be compiled into a summary report. Additionally, if possible, a visual chart illustrating the differences would be appreciated. Ideal candidates should have extensive experience with Excel and data analysis. Familiarity with inventory management and wine collections would be a plus.
I require an excel sheet that tracks and analyzes the changes in open interest data of the NIFTY index. This sheet should be able to provide insights into market sentiment based on this data. Key Requirements: - The excel sheet should continuously update the data every minute. - The sheet should be able to provide a text summary of inferences about market sentiment from the open interest data. Ideal Skills: - Proficiency in Excel with experience in financial data analysis. - Understanding of open interest and its implications on market sentiment. - Ability to create an automated Excel sheet that updates data every minute. Please note that I'm looking for a freelancer who can deliver a high-quality, reliable tool for tracking and interpreting NIFTY index...
I need a excel sheet (some columns protected), as soon as date are entered in Sheet 1 on a specific column the entire row needs to more to tab2, same at tab 2 as soon as date entered the row needs to move automatically to tab 3, same to tab 4, 5, 6. (All the rows are protected, can not be deleted, they will only move between tabs as the project runs) - Production Job Tracking report I would like to do the project together with the freelancer on teams (within the next hour is possible) I assume the project will take maximum an hour
I'm looking for an Excel developer to create an inventory management system. While specifics on the functions of the system haven't been detailed yet, the system will need to track stock levels and generate reports. As such, the ideal freelancer for this project should have prior experience in developing similar systems on Excel. Skills and experience required: - Advanced knowledge of Excel - Prior experience in developing inventory management systems - Ability to generate and interpret detailed reports - Excellent understanding of tracking stock levels
...freelancer who can assist me with entering part numbers and costs from a supplier's website into an Excel spreadsheet. This spreadsheet contains makes and models for every vehicle listed in the UK. Key Responsibilities: - Accurately input part numbers and costs from a supplier's website into designated columns of an Excel spreadsheet. - Follow specific formatting and column header requirements as detailed below. Specific Columns and Formatting: - The data needs to be entered under specific column headers in a predefined order: makes, models, costs, part numbers. - Conditional formatting or color-coding will need to be applied at times according to supplied guidelines. Ideal Skills: - Familiarity with Excel and its data entry requirements. - Attention to...
I need a comprehensive dataset prepared for Tableau that encompasses a variety of data types including sales, customer, and financial information. The data is currently in Excel/CSV format. Key Requirements: - Transform and clean various data types (sales, customer, financial) from Excel/CSV for Tableau - Prepare the dataset to allow for a variety of analyses and insights, including but not limited to sales trends over time, customer demographics, and expense versus revenue tracking. Ideal Skills: - Proficiency in Excel/CSV data handling - Expertise in data preparation for Tableau - Strong analytical skills to understand and anticipate necessary data transformations for desired insights Please note that the final dataset should be versatile enough to facilitate a wi...
I'm looking for an Excel expert to design a template for tracking my total monthly/yearly sales. This template should also allow for comparison over time. Key Features: - Total sales tracking - Comprehensive data visualization features: Bar charts, Pie charts, Line graphs - User-friendly manual data input Ideal Skills: - Advanced Excel skills - Experience in data visualization - Knowledge in sales data tracking
I'm in need of a reliable freelancer skilled in Excel and SQL database management. Key Responsibilities: - Regular data entry and updating in Excel. - Managing and maintaining a SQL database. Ideal Skills: - Proficiency in Excel for data entry and updating. - Experience with SQL database management. - Attention to detail for accurate data handling.
...dependents. The app will have two user roles: employees and employers. Key Features: Employee Login: Enter Employee ID to access the app. Display Details: Show the employee's name and their dependents. Admission Form: Select the person to admit (employee or dependent). Input fields for hospital name and admission date. Submit Button: Sends the data to a backend. Employer Dashboard: Generate an Excel sheet with all admission records....
...Key Responsibilities: • Set up and manage Facebook Ad campaigns, including campaign groups, ad sets, and individual ads. • Collaborate on Google Ads campaigns, refining bidding strategies and audience targeting through regular Zoom sessions. • Optimize ad campaigns to ensure maximum ROI, including A/B testing and data analysis. • Work with contact lists from tools like Seamless to upload Excel files containing 1,000-2,000 targeted contacts into the backend of Facebook Ads Manager and Google Ads for custom audience creation. • Create and manage remarketing campaigns using these custom audiences to deliver video ads tailored specifically to this list. • Provide regular performance analyses and actionable recommendations based on campaign d...
Transform Excel Sheet Data to Charts and Stats using Power BI, we need interpretation for each chart.
I am seeking a highly experienced circuit design engineer with expertise in digital and analog electronics, proficient in using Eagle for PCB design. The ideal candidate will have a strong background in signal conditioning, low-noise circuit design, and power management for compact, low-po...power management for compact, low-power applications. Familiarity with integrating multiple sensors, including PPG, glucose, HRV, and electrolytes, into electronic systems is a significant advantage. The role requires exceptional problem-solving skills, attention to detail, and the ability to deliver efficient, production-ready designs, including schematics, PCB layouts, and prototypes. If you excel in creating innovative circuit solutions and thrive in challenging projects, I would love to hear...
This project involves manually searching through a list of Facebook groups for posts containing offers and events (e.g., "Happy Hour," "Live Music"). The freelancer will identify relevant posts, extract key information such as location names and Facebook links, and compile the data into an Excel spreadsheet. They will also download and save images of the event locations. The search period for this project is from January 1st to January 7th. Evaluation Questions: 1) Describe your experience with manual data entry and data organization. 2) How would you approach the task of efficiently searching through multiple Facebook groups and identifying relevant posts within a short timeframe? 3) Imagine you encounter a Facebook post that mentions an event but does not ...
Hi, Statistics is my favorite subject and will be glad to help. I have skills in Data Processing, Statistics, R Programming Language, SPSS, Tableau and Excel. Hire me for your methodology and data analysis chapters for your dissertation.
I'm seeking a proficient Excel Solver expert to help me analyze my inventory data. The tasks involve moving averages, Mean Absolute Deviation (MAD) calculations, and time series forecasting. Key Tasks: - Help with moving average calculations - Calculate MAD - Apply time series analysis for forecasting Ideal skills for this project include: - Advanced Excel skills, especially with Solver - Strong understanding of inventory data analysis - Proficiency in time series forecasting methods
...currently using an Excel template to visually represent all our projects in a Gantt chart. I need an expert to enhance this template for me by adding a sales target function. This function should calculate and sum up the revenue for each job based on the percentage of the job completed in each month. - Example: For a $100k job with 75% of the work days in January and 25% in February, the system should automatically allocate $75k to January and $25k to February, and sum up all the jobs for each month. The work days are automatically calculated by the existing template. The only adjustment needed is the division of revenue by month and the presentation of this in total. I have an example of the desired output, just built manually. Ideal skills and experience: - Proficiency in ...
...Visualization and Reporting: - Create interactive dashboards using tools like Power BI or Tableau. - Provide meaningful visualizations such as charts, graphs, and heatmaps for easy interpretation. - Prepare a detailed final report with actionable recommendations. Requirements: - Proficiency in Python, R, or other statistical programming languages. - Experience with tools like Excel, Power BI, or Tableau for visualization. - Strong understanding of statistical methods and data modeling. - Ability to communicate insights effectively. Project Timeline: Expected completion within 3 days from the project start date. If you have the required skills and can deliver high-quality results within the timeline, we’d love to hear from you. Please include e...
This project involves the delivery of translated documents related to "Attachments - كتاب ومرفقات خاصة بملف الشركة الأهلية للتأمين." The scope includes six files: two previously delivered (كتابنا للموكل and تقرير الخبير), one translated last November (صحيفة استئناف), and three newly delivered (إجراءات تنفيذ 4, حكم أول درجة 2, and حكم الوقف). A translation progress report, including rates and pricing details, has also been provided.
...I'm looking for an expert in Excel and astrology software integration. The primary task involves data import/export between the two platforms (excel and software). Please note, the data to be transferred/extracted encompasses specific fields from the astrolog software. Ideal Skills: - Proficiency in Excel and creating macros - Experience with software or with any astrology software that uses swiss ephemeris - Data management skills - programming skills to pull out data from () - be able to connect data from excel and the astrology software I will be placing dates and times into excel, and then I want to click a button and extract out info from software and paste it into the excel worksheet. The data I want
...Collection:** - Use tools like Lusha, , and any additional necessary platforms. - Identify target companies and their main subsidiaries across the specified regions. - Gather detailed contact information, including **personal emails and phone numbers** of CEOs, CFOs, and key decision-makers. 2. **Data Organization and Delivery:** - Structure the information in an Excel sheet or database, ensuring it includes company details, locations, and contact hierarchy. - Deliver contacts progressively for quality verification and catalog integration. 3. **Verification:** - Cross-check all collected data for accuracy, reliability, and completeness. **Requirements:** - Expertise in tools like Lusha, , and other B2B data platforms. - Strong skills
Hi there! I'm often working in Google Sheet and Microsoft Excel and need a formula or some random tips and advice on how to make my sheet better, make my formulas cleaner, or macros written. It's not a full time job, or even consistent work. I'm looking for something like a co-pilot, preferable on Slack that I message any time. There might be weeks or even months where I don't need the help, but I know there is someone to help on hand when needed.
I'm looking for a data-savvy professional to assist me with analyzing and processing some wine investment fund data. Key Responsibilities: - Data entry: You'll be entering data from Excel spreadsheets into other required formats or systems. - Financial Analysis: You'll need to interpret the data and provide insights into trends, valuations, and potential investment opportunities. - Investment Research: I need you to conduct thorough research on possible investment opportunities within the wine market. Skills and Experience: - Proficient with Excel and other data processing tools. - Strong understanding of basic finance and investment concepts. - Prior experience in analyzing financial data and conducting investment research is a plus. - A passion for wine or...
I will add these features on the Form - * Please add the header content, logo & steps to use the form as provided in the reference excel sheet. * The user should be allowed to fill the form only if the selection is 'Yes' * Please check the verbiage in the first page (Specially under Residency information - Canadian tax return (also check the order of questions here) & Residency information -US tax return) * In UN25, the selection should be a tick mark instead of just a dot. * Changes regarding the appendix as discussed in the call and also as highlighted in #3 in our previous mail. *U9 to U39, UN1 to UN25 (when a user clicks on the 'Yes', the alert box is not changed as per the previous requirement. I guess you have missed from the previous requirement...
I'm in need of a Python script that can download an Excel report from a public website every hour and upload it to a designated portal folder without any modifications. - **Task**: Script should perform the following tasks - Download an Excel report from a public website every hour. - Upload the report to a specific portal folder without any modifications. Ideal Skills: - Proficient in Python programming. - Prior experience with web scraping and automating tasks. - Familiarity with working with Excel files in Python. - Knowledge of file upload protocols and processes.
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
I'm looking for a skilled Virtual/Administrative Assistant to support me, a busy C-Level Executive. The ideal candidate should possess 3-5 years of experience, particularly in: - Project Management - Business Calendar Management - Copywriting - Task Prioritization - Researching - Personal Task Management (Daily, Weekly, Monthly) - Proficiency in Microsoft Office Suite (Excel, Word) - Excellent Typing Skills - Coordinating Contacts Meetings - Outbound Phone Support - Data Entry (with Excellent Accuracy) - Other Related Business Tasks To start with, I require 5-10 hours a week. The most crucial skills for this role are Project Management, Calendar Management, and Copywriting. Your primary focus will be on managing my business calendar, so experience in this area is vital. Add...
We are seeking a skilled data professional to compile a comprehensive database of recently registered domain names along with relevant ownership or business details for the purpose of targeted outreach and lead generation for website development services. Database Scope: Collect domain registration data with a focus on re...sources such as WHOIS databases, expired domain lists, and domain auction sites. No data collection that violates GDPR, CCPA, or similar data protection laws. Preference for data from businesses requiring web development services. Data Accuracy: Ensure data is as up-to-date and accurate as possible. Remove incomplete or redacted records from the final dataset. File Format: Deliver data in CSV or Excel format. Proper column segregation and labeling for easy ...
I'm looking for an Excel sheet that can help me track daily sales for my pizzeria. The sheet should be user-friendly and structured in a way that allows for easy data input and analysis. Key Requirements: - The Excel sheet should be designed specifically for sales tracking. - It needs to accommodate daily sales data. - It should be able to present the data in tables. - The design should be clean, simple and easy to use. I have an existing sample , if you like Ideal Skills: - Proficiency in Excel - Experience in designing sales tracking tools - Ability to present data clearly and logically Please note, the primary purpose of this Excel sheet is to keep track of my pizzeria's daily sales. It should not include any unnecessary features or complexiti...
I'm looking for an expert in Excel to create a comprehensive bidding sheet for my concrete company. The sheet should be able to accurately calculate labor costs, material costs, and time estimates for different projects. Key Features: - Formulas and calculations: The sheet should include necessary formulas to automate calculations and ensure accuracy. - Conditional formatting: This feature will help in easily identifying key data points or alerts. - Graphs and charts: Visual representation of data will be beneficial for understanding project estimates and costs at a glance. Templates: The Excel sheet should also include templates for: - Bid proposals: A pre-formatted template that I can use for submitting bids. - Invoicing: A template for creating invoices based on pro...
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
I am currently working with a budget model and need a financial modeling expert to help me complete a sensitivity analysis. The variables that need to be includ...working with a budget model and need a financial modeling expert to help me complete a sensitivity analysis. The variables that need to be included in the sensitivity analysis are: - Revenue growth rate - Operating costs - Interest rates The analysis should be conducted in Excel. Ideal candidates will have extensive experience with financial modeling, particularly with budget models, and be able to conduct a comprehensive sensitivity analysis. Proficiency in Excel is a must, and familiarity with advanced Excel functions and techniques will be an asset. Please provide examples of similar projects you&#...
I need a skilled Desktop Support Engineer for Windows 11 installation, hardware troubleshooting, and MS Office setup. Your responsibilities will include: - Installing Windows 11 on various desktops - Troubleshooting hardware issues as they arise - Installing and configuring MS Office applications (Word, Excel, Outlook) - Setting up printers and configuring computers Ideal candidates should have: - Proven experience as a Desktop Support Engineer - Strong knowledge of Windows 11 and MS Office - Excellent problem-solving skills - Ability to install and configure printers Please provide evidence of your relevant experience and your approach to troubleshooting hardware issues.
I'm seeking an Excel expert to develop a spreadsheet that will assist with calculations and comparisons for our purchases. Key Requirements: - The Excel sheet should be able to help us make comparisons and use logic to decide whether to place orders. - Data inputs will include product prices and quantities, supplier details, as well as purchase dates and times. - A primary function of the sheet will be to carry out price comparisons between different suppliers. Ideal Skills: - Proficiency in complex Excel formulas and functions. - Experience in data analysis and comparison. - Ability to create user-friendly and efficient Excel models.
I'm in need of a skilled Excel VBA developer to create a macro that transfers numerical data from one Excel workbook to a second one on a daily basis. The macro should be designed to bring over all data from the source workbook. In addition, I would appreciate written instructions on how to recreate the macro in the event of a break. This project requires a clear understanding of Excel, VBA programming, and the ability to write clear and concise instructional material. Must speak good english as best we do a zoom / teams meet to review workbooks.
