Column design excel sheet trabalhos

...cleaning up and automating my Excel data. I'm unsure if everything is possible to do, but maybe a few steps can be disregarded. The perfect scenario would be: Create a simple form to add 'ID number' to process and file name for the new file. The automation: Open designated file with info. Create columns (based on character lenght) Format columns (set length, add '0's eg '234' formated to '000234'. Get only rows where Column C matches the input 'ID number', and column B has fixed value. Insert row at top with column header titles. Save file (as excel 97-2003 format), with the input filename. If all works out well, I will have another project where similar things are needed. Ideal freelanc...

I need a short Python program that can extract transaction details from my PDF bank statements into both CSV and Excel formats. All my statements are in the same format, so consistency won't be an issue. Ideal Skills: - Proficiency in Python - Experience with PDF data extraction - Knowledge of CSV and Excel programming This project is a great opportunity for a skilled Python developer with experience in data extraction and a keen eye for detail.

...Convert client logos into vector illustrations. • Design one or more printed materials such as logos, banners, or business cards. • Ensure your designs are creative and align with our clients’ brand identities. **Qualifications** • Advanced proficiency in at least one vector design program (e.g., Adobe Illustrator, CorelDRAW, or similar). • Specialization in the design of any printed material such as logos, banners, or business cards. • Ability to work remotely with discipline. **Benefits** • No experience in printing or production is required. • Each area of expertise is evaluated separately, so you will only work on the areas you excel in. For example, a designer specialized in business cards will not be ass...

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files. Key Tasks: - Importing data from one Excel file - Creating three files using VBA and Macros - Data cleaning - Data merging - Data filtering The data filtering will involve: - Applying numerical ranges - Text matching - Date ranges Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

I need a professional to analyze some data from an Excel file. The project primarily involves numerical analysis with a focus on identifying trends and patterns in sales data. Ideal candidate should: - Have proven experience in data analysis, particularly with Excel. - Be skilled in identifying and summarizing key trends and patterns in numerical data. - Be able to present findings in a clear and concise manner. - Have a good understanding of sales trends.

...number of historical records in some of the data fields has proven to be impractical (tens of millions of records) to download using the API as it is simply too slow. I am open to alternative methods here though. There will be a limited number of transforms (calculated fields) based upon the existing data structure, perhaps 15-20. Ideally, once the database is set up, I'd like to create a system (Excel or custom) to connect to the database and run a series of statistical queries on it. That does not need to be part of the original scope of work, but if the same developer can assist with this part that would be great. A previous freelancer started this project. They set up the database and tried using the API to do the initial download. Most of the data tables were able to...

I'm looking for a professional visual style for an interactive schedule planner in Excel. This project will require some experience with the developer tab. Key Requirements: - The schedule planner should feature automatic updates, conditional formatting, and data validation. - It should have a polished, professional appearance. - User interaction will be primarily through selecting from drop-down lists. Ideal Skills: Provide ideas that will make the spreadsheet user-friendly - Advanced Excel skills including developer tab proficiency. - Excellent understanding of conditional formatting and data validation. - Strong design skills for creating a professional layout. - Experience with creating interactive Excel tools. Please provide examples of similar pr...

I’m looking for someone to search for products on Amazon and list them in an Excel or Google Sheet. What you’ll do: Search for products in specific categories that I will provide. Record the product title and the link to the product page. Requirements: Basic knowledge of Excel or Google Sheets.

I need a professional to set up an email notification system for my staff, using Excel and Outlook. Key requirements: - The system should send an email to each staff member whenever a cell related to them changes value. - The cells are populated with dropdown list values. - The emails should be simple text, not HTML or pre-designed templates. Ideal skills for this project include: - Advanced Excel skills - Proficiency with Outlook - Experience with setting up automated email systems - Good understanding of drop down lists in Excel This is an opportunity to help me streamline communication with my staff and ensure they are updated in real time.

Bonjour, nous avons deux fichiers Excel comprenant deux colonnes comportant des codes postaux français : colonne C "CP départ" et colonne D "CP arrivée". Nous avons besoin que dans la 3e colonne "Distance en KM" vous trouviez via google ou par VBA Excel la distance en KM entre ces deux codes postaux. Exemple ligne 2 du fichier "Tri 2024" : CP départ 54710, CP arrivé : 28500, distance en km : 408 km

I require assistance with cleaning up my Excel files. I have three Excel files, and I need duplicates in one specific column of the first file removed from all 2 files. The structure of all files is the same, with identical columns. Ideal skills for this project include: - Proficient with Excel - Attention to detail - Experience with data cleaning Please be prepared to delete identified duplicates from all files. Budget $5

...action items. Goals & Objectives Provide a structured template where I can easily add, categorize, and prioritize keywords. Include columns/tabs for capturing key SEO metrics (search volume, CPC, competition/difficulty, intent, etc.). Offer a clear workflow: from brainstorming seed keywords to final content mapping. Maintain consistent formatting that remains stable when exporting to or opening in Excel (if using Google Sheets) and/or in platforms like AppSheet. Make it intuitive and visually organized, with instructions or user notes so anyone on the team can use it easily. Key Features / Requirements Data Collection Tab Columns for keyword metrics (search volume, CPC, keyword difficulty, search intent, etc.). Ability to easily sort/filter based on priority or relevance. B...

I'm looking for a PHP web application function that can compare two Excel sheets. - The function should highlight the differences between the two sheets. the web app should provide the output excel as coded. Ideal candidates for this project should have: - Strong skills in PHP and web app development. - Experience with Excel sheet manipulation and comparison. - Ability to implement a user-friendly interface that highlights differences clearly.

I'm looking for a detail-oriented professional to help with spreadsheet data entry. The task involves transcribing product information from PDF files into a spreadsheet. Ideal Skills: - Proficiency in using spreadsheets (Excel, Google Sheets) - Attention to detail - Ability to transcribe data accurately from PDF files - Understanding of product inventory management (preferred but not essential)

I'm seeking a diligent data entry expert to assist with transferring information from an online database into MS Excel. Key Requirements: - Proficient in MS Excel; familiarity with data manipulation tools within Excel is a plus. - Attention to detail to ensure accuracy of data entry. - Ability to work independently and manage time efficiently. - Prior experience with data entry from online databases preferred. Please note, the data type is mixed (both numeric and textual), so a good command over both types is essential.

I'm seeking an Excel expert who can help me with a project needing to build a client pipeline excel sheet which provides the ability to multi select checkboxes from a drop down for certain columns. Also need to have the checkboxes grouped under a heading with indentation/ categorization The project requires the development of advanced macros and VBA scripts. Ideal Skills: - Extensive knowledge of Excel - Proficient in writing complex VBA scripts - Experience in creating advanced macros Key Responsibilities: - Develop an excel sheet with certain columns having the ability to list checkboxes and support multi selection. - this drop down multiselect checkbox list also will be categorized under a few main parent checkbox - upon multi selection ...

I'm looking for a comprehensive search for M&A advisory firms across Southeast Asia, specifically in Singapore, Malaysia, Thailand, Indonesia, Philippines, and Vietnam. Key Requirements: - The search should encompass all types of firms: local, international with local offices, and boutique firms. - The information gathered shoul...and boutique firms. - The information gathered should include, for each firm: - Name of company - Contact details - Services offered - Client portfolio - The final output should be a detailed spreadsheet with all the information. Ideal Skills: - Proficient in internet research - Experience in business analysis - Familiarity with M&A advisory firms is a plus - Proficient in Microsoft Excel or similar spreadsheet software. Lookin...

...Closing Skills Ability to proactively communicate, engage, and influence proper decision makers Ability to execute sales strategies, think clearly and overcome objections Strong personal accountability with track record for delivering on expectations/commitments with focus, perseverance, and tenacity Requires knowledge of and the ability to use computer software such as MS Office Suite (Word, Excel, PowerPoint, Salesforce, and Outlook)...

Phần mềm ERP của mình đã có phân hệ kế toán, nhưng chưa đưa được ra các báo cáo kế toán theo chuẩn VN, họ đã có các báo cáo kế toán chung như profit & loss, Balance Sheet cần các bạn có kinh nghiệm tốt về sql để cùng với IT in-house xây dựng hệ thống report cho kế toán

I need a skilled web scraper who can extract data from a members area of a website. The data should be compiled and delivered in an Excel file. Website Scraping of Members Area Ideal Skills: - Web scraping expertise - Proficiency in Excel - Attention to detail

...involving NASDAQ data . These scripts will scrape stock prices and dividends from free stock data site (i.e., ), place the data in a single-sheet Excel file, and create a line graph similar to an attachment I will provide (). Script 1: Download stock prices (for a year - Download Historical ) and dividend data (for a year) for a given stock Script 2: save data to a single-sheet Excel file Script 3: Create a chart in the Excel file The ideal freelancer for this project should have: - Extensive experience with Python, particularly with libraries for web scraping and data analysis. - Proficiency in creating and manipulating Excel files with Python. - Skills in data visualization, particularly in creating line graphs. Please provide examples of ...

I have two sets of medical reports from the years 2016, 2018, 2019, 2022, and 2023. There are 64 tests in each report, including tests such as sugar and cholesterol. I need the data extracted from the PDFs and consolidated into a single Excel sheet for easy review. Ideal Skills and Experience: - Proficiency in data extraction from PDFs - basic data entry and Excel skills - Attention to detail The budget for the same is INR 500 pls let me know if you are interested I will award it

... When you apply provide ANY portfolio item that is relevant to this job Are you an experienced financial analyst ready to take on a new project? We need your expertise to start working on this right away. Your task will be to prepare a balance sheet and a 3-year financial projection in compliance with ICAEW standards. Note: See files attached Project Details: - New Project Planning: This project involves planning for a new venture with a few intangible assets and no reported income. - Balance Sheet: Develop a detailed and accurate balance sheet that meets ICAEW standards. - 3-Year Financial Projection: Create a robust financial projection for the next three years, providing clear and insightful forecasts. - Regulatory Compliance: Ensure strict adherence to regul...

I need an expert in Excel to help me with an Index Match formula. It's intended to locate numeric data from a single table based on 2 criteria. Key Requirements: - Proficiency in Excel, particularly with Index Match formulas - Experience working with numeric data - Ability to match data based on multiple criteria If you have the requisite skills and experience, I would greatly appreciate your assistance.

Hi. I would like to scrape oddsportal for game results,closing and opening all odds import them into excel. I am interested in soccer matches. The scraper should be able to scrape data according to date i.e. I would like to input a date range and sport (soccer) and get the match details for those matches. Further details will be discussed with bidder. I should also mention that date range for scrapping data could be quite long (i.e. months) so the output xls could be quite big. It is very important to me that scraping is done as quickly as possible (seconds) with as less clicks as possible and without hanging-up or crippling my PC while scraping. PROJECT DETAILS: Sport:----------------------Football Bookmaker:------------------Bet365, BWIN, Pame Stoixima, Stoiximan, Interwette...

I'm looking for an expert in AI tools to scrape a website for me. The goal is to extract specific contact information and organise it neatly in an Excel sheet. Data to be Scraped: - Email addresses - Phone numbers - Names - Zip Codes The ideal candidate should have prior experience in web scraping and data management. Proficiency in using AI tools for this task is crucial. Data Formatting: - I need the data to be sorted into separate sheets for each type of information. Please provide examples of previous similar tasks you have completed successfully.

I'm looking for a freelancer who can create an Excel spreadsheet containing names and verified email addresses of businesses located in specified postcodes in Sydney, Australia. The project entails: - Collecting data on approximately 1500-2000 businesses - Including business names and email addresses in the spreadsheet - Ensuring that all email addresses are verified The ideal freelancer for this project should have experience in data collection and spreadsheet creation, with a keen attention to detail. Prior experience in sourcing business data will be an added advantage. Please note that the types of businesses and additional data points (like physical address, phone number, or website URL) are yet to be determined. The primary focus at this stage is just on business names ...

I'm looking for a skilled Excel expert to create a comprehensive Excel sheet for managing our swag items. The sheet should include the following columns: - Brand - Category - Campus - Item - Cost per item - Quantity - Item link - Dropbox link to the design The sheet will primarily be used for order planning and will need to be updated weekly. It should contain calculations for the total cost and a summary of quantities. Pricing details for various items are provided, and the Excel sheet should accurately reflect these costs. Ideal Skills: - Proficiency in Excel - Experience with inventory management - Ability to create complex formulas Key Features: - Order planning focus - Weekly updates - Total cost calculation an...

I'm looking for a vibrant, student-friendly infographic/cheat sheet in PDF format on Sigmund Freud's Psychosexual stages of development. The infographic should be colorful, engaging, and easy for students to understand. Key Requirements: - Design a colorful, engaging infographic - Target the content towards students - Deliver in PDF format Ideal skills and experiences include: - Graphic design, particularly infographics - Understanding of psychology and Freud's theories - Ability to create visually appealing, educational material

I need a proficient Excel professional to assist me with some office work. My data is currently organized in a single spreadsheet with multiple tabs. The tasks I need help with involve: - Formula creation and calculations - Data analysis and reporting - Organizing my data according to specific requirements It's worth noting that I have a combination of prepared data and data that needs to be gathered. The ideal freelancer for this project should be well-versed in Excel, with a strong understanding of data organization, formula creation, and data analysis. Good communication skills are essential, as well as the ability to follow specific instructions for data arrangement.

I'm seeking a financial expert to create an Excel spreadsheet that projects the financial trajectory of an investment portfolio as it transitions from an operating company to three holding companies. These holding companies will serve the purpose of funding life insurance premiums. Key components of the project include: - Annual funding of a life insurance policy from the investment portfolio, coupled with a life insurance premium loan each year. This should detail the interest rate, annual deductions, and the net cost of the loan. - Retirement amounts for each of the three holding companies, sourced from both the insurance and investments, from ages 71 to 90. - Demonstrating the accumulated growth of the portfolio, with $3.9M in each holding company, and life insurance death ...

...a HIGHLY skilled professional to calculate existing numerical entries and add formulas for additional numerical entries to automatically calculate. Currently doc is in Word, but not opposed to Excel if it is faster and easier. Doc also needs page numbering (no page number on first page). Will need a grand total at end of doc. Deadline is Saturday, 01/25/25 or Sunday, 01/26/25. Key Requirements: - Add formulas to calculate the sum and averages of current and future entries. - Ensure calculations update automatically when new entries are added. Ideal Skills: - Proficiency in Microsoft Word and Excel. - Experience in creating automated calculations in documents. - Ability to translate numerical data into meaningful insights. Your expertise will ensure I can easily track a...

I'm seeking help with web research and data entry in Excel, specifically focused on finding contact details for dentists in Kuala Lumpur. Key responsibilities: - Conduct web research to find business contact details of dentists in Kuala Lumpur - Email out scope to professional dentists in Kuala Lumpur - Data entry results into an Excel spreadsheet Important skills and experience: - Proficiency in Excel - Strong web research skills - Previous experience with data collection preferred I am particularly interested in collecting the following contact details: - Email addresses - Phone numbers - Physical addresses Deliverables: - An Excel spreadsheet with the collected data Please note: I am looking for prices and the ability of the dentist to perform cer...

I need a comprehensive Excel sheet designed for cabinet selection geared towards order processing. The Excel sheet should have dropdown menus facilitating the selection of different categories, automated calculations for cost and dimensions, and conditional formatting to visually represent data variations or thresholds. Key Features: - Dropdown menus for selecting material types, color options and various construction components (like doors, drawer fronts, hardware etc.) - Automated calculations to keep track of totals, dimensions, and other necessary metrics - Conditional formatting to help easily identify key data points or anomalies I will provide you with a detailed list of all the necessary construction options, which will encompass standard, custo...

I need help with an Excel form that involves mathematical calculations, specifically sum and averages. The calculations need to consider certain specific conditions or criteria. Ideal Skills: - Proficient in Excel, particularly in creating and troubleshooting formulas. - Strong understanding of mathematical calculations. - Experience with conditional calculations, such as IF statements. Please provide your experience with similar projects in your bid.

I'm looking for a skilled Excel VBA expert to create a macro that converts data from my Excel file into PDFs and sends them to multiple email addresses. The Excel sheet has several tabs, each corresponding to a different group of recipients. Key requirements: - The macro should be able to handle 4 or more separate groups of recipients, as per the different tabs in the Excel file. - Email addresses are provided in a comma-separated list format. - Each tab contains sales reports that need to be converted into PDFs. Ideal candidates should have: - Extensive experience with Excel VBA and macro programming. - Previous work with automating PDF conversion and email sending from Excel. - A strong understanding of handling and sorting data for...

I'm looking for a skilled Visual Basic programmer to assist in automating my reporting process through Excel. Key Responsibilities: - Utilize Visual Basic to streamline the reporting process - Source data exclusively from Excel spreadsheets - Generate detailed reports Ideal Candidate: - Proficient in Visual Basic and Excel - Experienced in creating and automating detailed reports - Capable of understanding and executing complex data manipulation tasks.

...for this project: --- ### **Key Features and Functionality** #### **Products** 1. **Two Main Products:** - **Auto-sized Gangsheets**: Customers upload their designs, and the app auto-sizes the gangsheet. - **Fixed-size Gangsheets**: Customers upload their designs, and the sheet follows a fixed size. 2. **Shopify App Integration:** - **Antigro Gang Sheet Builder**: This app will handle the gangsheet configuration. [Antigro Gang Sheet Builder App]() Ensure seamless integration with the store. --- #### **Language** - The entire store will be in **Norwegian**. Please ensure all content, labels, and notifications are localized. ---

I'm seeking an experienced Excel specialist to create a software-based Gantt chart for me. This chart should incorporate task dependencies, progress tracking, and resource allocation capabilities. Key Requirements: - Proficiency in Excel with a strong understanding of its advanced features. - Experience in creating interactive, software-based Gantt charts within Excel. - Ability to incorporate task dependencies, progress tracking, and resource allocation into the Gantt chart. Ideal Skills: - Advanced Excel skills - Project management software experience - Strong attention to detail - Excellent communication skills

I need an Excel sheet that encompasses tracking for staff attendance, leave, and performance. Key Requirements: - Attendance Tracker: Should facilitate daily attendance logging. - Leave Tracker: Must include leave balance tracking. - Performance Tracker: Primarily focused on monitoring task completion rates. Ideal Skills: - Proficient in Microsoft Excel. - Experience in creating tracking systems in Excel. - Understanding of HR metrics and performance tracking. The freelancer should be capable of producing a comprehensive yet easy-to-use Excel sheet tailored to these requirements.

I'm seeking a professional who can integrate Power App with Power BI primarily for automation purposes. This integration should streamline data entry, facilitate report generation, and improve workflow management. Key requirements: - Proficiency in Power App and Power BI - Experience in automating data entry, report generation, and workflow management - Ability to work with Excel spreadsheets as the primary data source Please provide examples of similar projects you've completed.

I'm looking for a skilled freelancer to create Excel templates and dashboards using data from our IT Service Now ticketing system. The dashboards should track multiple metrics, allowing us to gain insights into our ticketing process. Ideal Skills: - Proficient in Microsoft Excel - Experience with data visualization - Familiarity with IT Service Now Key Requirements: - Create Excel templates and dashboards - Use IT Service Now ticketing data - Track multiple metrics Preferred Visualizations: - Bar charts - Pie charts - Line graphs

I need someone to manually extract phone numbers from a video that shows a contact list. - Format: The phone numbers should be saved in a Google Sheets document. - Organization: All phone numbers should be placed in a single column. - Labeling: No specific labeling or notes are needed. Just the raw phone numbers in the designated format. Ideal skills for this project include: - Proficiency in Google Sheets - Attention to detail - Experience in data entry, particularly transcribing from video content. Please ensure accuracy as the quality of the project heavily relies on the correctness of the extracted phone numbers.

I'm looking for a spreadsheet that can track my sales performance metrics and is visually appealing for a female. The spreadsheet should have a pleasant color sc...performance metrics and is visually appealing for a female. The spreadsheet should have a pleasant color scheme and theme, as well as incorporate various graphs and charts to display the data. Key Requirements: - The spreadsheet should be easy to use and intuitive. I will be manually inputting data, so it should be simple to plug information in and see the results. - A strong understanding of Excel or Google Sheets is essential. - Experience in creating visually appealing spreadsheets is highly desired. - Familiarity with sales tracking metrics is a plus. Please provide examples of similar projects you have complet...

...they are aligned with quality standards (the order is in the right subfolder, requirements, technical documentation) - update this list of routine and on-demand routine Support for HR is required - Recruiting on online platforms - Opening jobs, - making interview and tests ( We will share a technical test to be done), - first selection - Payments and follow up document template creation (Word, Excel), Marketing material, like power point presentation, brochures, business proposal lead verification and generation from Linkedin, mail and follow feedbacks Required skills - SELF SUFFICIENCY in completing required technical tasks. - Confidentiality: you will work in close contact with CEO, this means you will have access to private and sometimes confidential information, both person...

I have 52 A3 Excel pages filled with handwritten data that need to be typed up into an organized Excel document. This is an urgent task that needs to be completed by tomorrow morning. Requirements: - Typing up handwritten data into Excel - No additional data processing or analysis required, just typing Ideal Skills: - Proficient in Excel - Fast and accurate typing skills - Excellent attention to detail

I'm looking for a freelancer with exceptional Google Sheets skills to create a tailored spreadsheet for my photography company. This Google Sheet should effectively manage Attendance, CRM, and Work Management. Key Components: - Attendance Tracking: I need a system for daily check-in/check-out. It should be simple, intuitive, and able to provide a clear overview of employee attendance. - CRM: The CRM component should manage client contacts, track leads, and oversee our sales pipeline. It’s crucial for this part to be user-friendly yet comprehensive enough to handle our growing client base. - Work Management: This section should allow us to monitor project progress, allocate tasks, and manage deadlines effectively. Ideal Skills: - Advanced Google Sheets proficiency. - Pri...

You have to open 153 pdf, and copy paste in a google sheet 1. email 2. 3. date Need it done now within 1 hr

I'm seeking a professional Excel expert to build a comprehensive costing job sheet for me. The job sheet should encompass all aspects of our project costs including materials, labor, and overhead. A briefing will be required and shown what is required Key Requirements: - Inclusion of materials, labor, and overhead costs - Development of automated calculations for cost totaling and profit margin assessments - Skillful presentation of the data in a clear, user-friendly layout Ideal Skills: - Advanced Excel proficiency - Experience with job costing sheets - Ability to create automated calculations within Excel The ability to understand and reflect our costing needs in the job sheet is essential. Please ensure that all aspects of our project ...

I am a project manager handling diverse projects and need a professional Excel dashboard to track and manage my work efficiently. The dashboard should provide a clear, user-friendly interface and visual insights to monitor progress, timelines, budgets, and key metrics for the following: CSR Fund Tracking: Monitor inflows, outflows, and utilization of CSR funds across multiple initiatives. International University Collaboration: Track milestones, agreements, events, and communications with international universities. Hub and Spoke Model: Manage operations, performance, and data flow in this healthcare delivery model. Share4Care Online Fundraising: Track donor statistics, funds raised, and campaign performance. Ayurveda Marketing: Monitor marketing initiatives targeting both domestic...