Macro data spreadsheet jobber

Filter

Mine tidligere søk
Filtrer etter:
Budsjett
til
til
til
Skriv
Ferdigheter
Språk
    Jobbstatus
    2,000 macro data spreadsheet jobber funnet, priser i USD
    Trophy icon Excel Data Consolidation to Word Avsluttet left

    I'm looking for a technical writer experienced with excel and Word documents. The main task is to extract Text and Numbers from an Excel spreadsheet and combine them. The depth of information will require an eye for detail and proficiency in writing with clarity, as the consolidated data will be detailed, not a high-level summary. Below are the requirements: - Knowledge of how to extract and combine Text and Numbers from Excel. - Ability to formulate a detailed bulleted list in a Word document. - Precision and attention to detail, as the final Word document will consist of highly-detailed information. Strong data analysis and excellent communication skills will make you a perfect fit for this job.

    $20 (Avg Bid)
    Garantert
    $20
    63 bidrag

    I'm in need of professional help to enter timesheet data into spreadsheets sourced from digital files, I am estimating about 8 hours of work in total. Here's what the project entails: - Converting data from PDF into Excel spreadsheets - Ensuring accuracy while inputting the information - Some interpretation of data based on rules I will provide you It is critical you possess a keen eye for detail, to confirm you are able to understand and complete what is required I am asking you to complete a small trial which should take up to 5 minutes. I have posted three files with this job: - Example - Data - - Trial - I have entered the Example timesheet in the excel file. If you could enter the "Trial - entry" timesheet in the same format and

    $6 / hr (Avg Bid)
    $6 / hr Snitt bud
    19 bud

    I'...names tied to US addresses. The project's purpose is to strengthen our donor relationships by ensuring accurate communication channels are established. **Requirements:** - Expertise in data mining and verification. - Proven track record of high accuracy in contact detail retrieval. - Capable of delivering the results in an Excel spreadsheet format. **Expected Deliverables:** - An Excel spreadsheet containing the full names, addresses, and highly accurate phone numbers. **Ideal Candidate:** - Someone with exceptional research skills. - Familiarity with donor relations or similar fields. - Experience with data verification tools and methodologies. The job will be considered successfully completed when the list meets the precise accuracy standard...

    $86 (Avg Bid)
    $86 Snitt bud
    6 bud

    I'm seeking a proficient developer to create an application that will print name data, pulled directly from an Excel spreadsheet, onto a jpeg card template. The application should also import specific images from a designated folder to couple with the relevant data. All final data must be printable and automatically exported as jpeg or pdf. Key components for the application include: - Specific layout guidelines must be adhered to for the print format. - Text and images must maintain fixed positions on the card. An ideal candidate should have experience in: - Working with database programming. - Custom software development and programming. - Data manipulation in Excel. - Proficiency in PDF and jpeg file creation and exporting.

    $141 (Avg Bid)
    $141 Snitt bud
    37 bud

    ...Python script or an executable file (.exe) tailored to our specific needs. Project Overview: Objective: The primary goal is to develop a tool that automates the process of extracting specific data from a designated website. Functionality: The tool will open an existing spreadsheet. It will read and parse a specific string (or strings) from the spreadsheet. The tool will then navigate to a predefined website and perform a search using the extracted string. After conducting the search, it will parse relevant data from the website. Finally, the tool will input the gathered data back into the spreadsheet, updating it accordingly. This is a very simple project - I am not wanting to pay more than $30 for this. Please only apply if you can do this ...

    $26 (Avg Bid)
    $26 Snitt bud
    32 bud

    I want someone to contact electronics, computer and department stores etc. and ask them the following question: "I am looking for a device about the s...media player. So it would have a port (e.g. USB) or wi-fi to copy files into it and controls (physical or touch screen) for browsing, starting and stopping videos. I don't want a phone or a computer/tablet since I don't want the extra overhead and complexity of unwanted functionality. Do you have anything like that?" Create a list of the places you contact and what each said. You can use a spreadsheet, word, pdf or TXT document. Get the exact name and price of each product. Take a screenshot showing their answer (what shows in one screenshot.) You must show me what you get after doing the first 5. How m...

    $15 (Avg Bid)
    $15 Snitt bud
    9 bud

    Can you find me the email addresses for these people pls? Normal format - First name, second name, email address, Company, Title.

    $25 (Avg Bid)
    $25 Snitt bud
    1 bud

    Can you find me the email addresses for these people pls? Normal format - First name, second name, email address, Company, Title.

    $26 (Avg Bid)
    $26 Snitt bud
    1 bud
    Excel Macro Magic Avsluttet left

    I need an Excel whiz for crafting smart, user-friendly macros and buttons that'll simplify my workflow. Here's what ...sequential number. - Ensuring this process is neatly formatted and aligns with the sheet's existing style for consistency and professionalism. For this task, a freelancer with the following qualifications would be ideal: - Strong Excel macro programming skills, preferably with VBA expertise. - Proven experience with Excel's formatting functions, ensuring neat and efficient automation. - Ability to work quickly and accurately, delivering a solution that's both effective and user-friendly. I'm aiming for a straightforward, easy-to-use system that makes my data management faster and more efficient. If you have a knack for Excel a...

    $22 (Avg Bid)
    $22 Snitt bud
    24 bud

    ...scheduling, data entry, internet research and document creation. This role involves the daily entry of data from various tables into a one table. Additionally, the assistant will be responsible for organizing my calendar to help me efficiently manage time and not miss any commitments. Working knowledge of the following software and tools is necessary: - Microsoft Excel - Google Calendar - OneDrive - Google Sheets - Microsoft Word - PDF Experience processing a bulk of data (100-500 entries) into Excel is crucial for this role. Attention to detail, ability to manage time efficiently, and organizational skills will be integral for successfully handling various assignments. In your bid, please share your experience with these tools and tasks. Familiarity with schedu...

    $3 / hr (Avg Bid)
    $3 / hr Snitt bud
    139 bud

    ...a seasoned professional to assist me with a major data entry project. This requires both typing data from physical documents, entering data into spreadsheets and copying and pasting data. - Estimated Workload: The project involves processing more than 500 physical documents. This might seem like a heavy load, however the nature of the data on these documents is simple. They contain straightforward information like names, addresses and the likes. Therefore, it should follow a standard, comprehendible format. - Ideal Candidate: A top contender for this project would have an eye for detail, great typing speed and accuracy, and experience with data management strategies. A proficiency in Microsoft Excel and familiarity with other spreadsheet...

    $11 / hr (Avg Bid)
    $11 / hr Snitt bud
    57 bud

    I'm seeking a proficient Excel expert to assist me with a task involving gauge charts. The primary aim is to use these charts to visualize target vs actual sales data values. The task includes: - Mastery of Excel formulas and functions to effectively generate these charts - Experience with spreadsheet formatting to ensure the data is presented in a clear and visually impactful way - Proven expertise in data analysis to interpret the results correctly and provide valuable insights While experience in sales data visualization is a plus, any candidate must have a thorough understanding of and experience with Excel gauge charts.

    $14 (Avg Bid)
    $14 Snitt bud
    15 bud

    I'm needing an Excel Macro that can help format my data. As I deal with a diverse set of data, the macro should be flexible and able to handle various types of data with ease. Your substantial experience in macros would be a definitive advantage. Specific formatting tasks may include, but are not limited to, text formatting and number formatting, with an understanding of conditional formatting being a bonus. If you've gotten an extensive background in Excel macros, I'd love to hear from you.

    $22 (Avg Bid)
    $22 Snitt bud
    49 bud

    I'm currently looking for a technical expert who can extract latitude and longitude data from existing address fields. The aim is to integrate Google Maps Geocoding library into an Excel spreadsheet, ensuring the geocoding process identifies only the precise address as specified—no alternate addresses should be inferred. Ideal skills include: - Experience with Excel VBA - Familiarity with Google Maps Geocoding - Strong attention to detail Your role would be to: - Implement the Google Maps Geocoding library in Excel - Extract latitude and longitude based on existing address data - Ensure only exact address data is used - Test for accuracy and fix any issues that arise The end-goal is to have a functional Excel file that can accurately determin...

    $60 (Avg Bid)
    $60 Snitt bud
    19 bud

    I am looking for a freelancer who can assist me with data entry work in MS Excel. The project involves entering less than 100 data points into a spreadsheet. Although I do not have a specific format or template that needs to be followed, I have some preferences that I would like the freelancer to consider. Skills and Experience: - Proficiency in MS Excel and data entry - Attention to detail - Ability to follow instructions and preferences accurately

    $50 / hr (Avg Bid)
    $50 / hr Snitt bud
    3 bud

    I'm in need of a freelancer who can skillfully convert two PDF documents into editable XLS files. Here are the key requirements: - All texts and tables from the PDFs should be accurately tra...The final XLS files should maintain the column widths of the original documents to ensure consistency and easier readability. - The end result should be completely editable, allowing changes to be made as necessary. Ideal person for this job would be someone with a track record of converting PDF files to spreadsheets without losing the structure of the original file. Familiarity with Excel spreadsheet formatting is a must. Attention to detail would also be paramount to ensure nothing is lost during the conversion process. Experience with optical character recognition (OCR) tools or soft...

    $12 (Avg Bid)
    $12 Snitt bud
    103 bud

    I'm in need of a skilled professional with experience in VBA and writing macros code. While the software used isn't Microsoft Excel or Access, the project involves simple tasks automation. Your role will involve: - Understanding the form and function of currently manual tasks. - Designing, developing, and implementing macros to a...used isn't Microsoft Excel or Access, the project involves simple tasks automation. Your role will involve: - Understanding the form and function of currently manual tasks. - Designing, developing, and implementing macros to automate these tasks. Ideal candidates will have a proven track record with VBA and a solid understanding of how to automate simple tasks efficiently. Experience with custom macro code in non-traditional applications wo...

    $24 (Avg Bid)
    $24 Snitt bud
    33 bud

    I require a seasoned Excel wizard to create an intricate spreadsheet for me. My necessity involves handling both text and date/time data. The optimal organization for this data on the sheet would be a mixture of columns and rows. Hence, understanding the context and logic in data placement is key. Additionally, the project would extensively require text and string operations. Ideal candidates should be familiar with various string-related functions such as LEN, RIGHT, LEFT, MID, SUBSTITUTE, and REPT, among others. Your proposal should clearly mention previous similar projects you've undertaken. An understanding of VBA to create customized functions would be a bonus, but is not a compulsory requirement. Parametres Each entry has 2 lessons that must be one...

    $90 (Avg Bid)
    $90 Snitt bud
    38 bud

    I am looking for an MS Excel add-in developer who can create functionalities similar to the WiseSheet add-in. The ideal candidate should be able to: - Implement data analysis and visualization features - Execute spreadsheet automation and macros - Integrate with external APIs This project will involve finance modeling and thus require experience in the following areas: - Forecasting and budgeting - Financial ratio analysis - Valuation modeling Additional skills in add-in development, REST API, and advanced Excel are highly desired. I anticipate needing this project completed as soon as possible. Developers with prior experience in finance or with similar projects will be given priority.

    $41 (Avg Bid)
    $41 Snitt bud
    14 bud

    I urgently require skilled Excel experts who can design a functional spreadsheet for data entry and organization, and also build an interactive dashboard for reporting and visualization. The data I'll be working with is mainly text and numerical and the spreadsheet will be utilized predominantly on a Windows operating system. Key tasks: - Development of an easy-to-use Excel spreadsheet for data entry and organization - Provision of functionality for text and number manipulation - Construction of an interactive visualization dashboard for reporting Ideal skills and experience: - Proficient in Microsoft Excel - Proficient in data visualization - Familiar with Windows operating systems - Excellent in data analysis and organizat...

    $122 (Avg Bid)
    Viktig
    $122 Snitt bud
    20 bud

    Vennligst Registrer deg eller Logg inn for å se detaljer.

    Omtalt Forseglet Taushetspliktsavtale

    I need you to fill in a spreadsheet with data.

    $20 (Avg Bid)
    $20 Snitt bud
    34 bud

    I need you to fill in a spreadsheet with data.

    $20 (Avg Bid)
    $20 Snitt bud
    1 bud

    I'm in need of a professional proficient in Power Automate to help automate the process of extractin...store them into Excel. The task at hand involves: - Setting up email notifications automation within Power Automate - Streamlining data synchronization between the email server and Excel - Implementing an approval workflow to regulate the data extraction and storage process The specifics on how the email attachments will be integrated into the Excel spreadsheet is open-ended and up to your expert recommendation - it can either be in separate columns or merged into a single column. Ideal candidates for this project would have solid experience in Power Automate with a deep understanding of email servers, data extraction and transfer mechanisms. Expertise...

    $64 (Avg Bid)
    $64 Snitt bud
    14 bud

    Hi Kym D., Feb has snuck up on me. Hope you are happy to continue. Topics should be in the previous google spreadsheet. Thanks, Steve

    $263 (Avg Bid)
    $263 Snitt bud
    1 bud

    I need someone to copy details from invoices to an excel spreadsheet. I'm seeking an experienced professional for a manual data entry project. This task requires precision and accuracy as it involves transferring alphanumeric data into a spreadsheet format. The ideal candidate should have: - Extensive experience in performing data entry tasks accurately. - A sharp eye for detail to prevent data errors. - Proficiency in using spreadsheet software for data manipulations. - Excellent skills in handling alphanumeric data. Your role will primarily focus on the meticulous transcription of the provided data, maintaining its integrity. Thoroughness and consistency in the work are paramount for this project.

    $14 / hr (Avg Bid)
    $14 / hr Snitt bud
    56 bud

    ...individual to collect and organize data from specified UK job websites: Indeed, Monster, LinkedIn, Totaljobs, and Reed. This task entails identifying and categorizing current positions in the hospitality industry, specifically restaurants, hotels, and bars. Key responsibilities include: - Accurate data collection for each position which includes: job title, company name, location, job description, specific position details, and the contact email address or phone number. Please be advised that generic email addresses (like info@) are not acceptable. - Immediate start with a focus on the most recently posted jobs. The ideal freelancer for this project should demonstrate excellent attention-to-detail, familiarity with the named job portals, and have experience in data...

    $20 (Avg Bid)
    $20 Snitt bud
    49 bud

    I'm seeking a proficient web scraper who can efficiently deliver comprehensive data from Yahoo Finance into an Excel spreadsheet. More specifically, the data to be obtained includes: - Stock prices, - Company financials, - Related news articles. To address this engagement, the key skills required from you are: - Web Scraping, - Data Extraction, - Knowledge of Yahoo Finance data structures, - Competence in Excel. Quick completion time is paramount; I require this project to be finished as soon as possible.

    $19 (Avg Bid)
    $19 Snitt bud
    15 bud

    I am looking for an MS Excel add-in developer who can create functionalities similar to the WiseSheet add-in. The ideal candidate should be able to: - Implement data analysis and visualization features - Execute spreadsheet automation and macros - Integrate with external APIs This project will involve finance modeling and thus require experience in the following areas: - Forecasting and budgeting - Financial ratio analysis - Valuation modeling Additional skills in add-in development, REST API, and advanced Excel are highly desired. I anticipate needing this project completed as soon as possible. Developers with prior experience in finance or with similar projects will be given priority.

    $14 (Avg Bid)
    $14 Snitt bud
    11 bud

    I need a professional with a solid background in data consolidation including different scales. During this project, you will be tasked with combining results from different tests. Key Objectives: - Combine results from up to 6-10 unique tests into a single, comprehensive report with overarching scores - Final report to be formatted as an Excel spreadsheet - Maintain accuracy and regard for detail when transcribing and analyzing data The ideal freelancer for this project would have: - Proficiency with Excel and data analysis - Keen attention to detail and accuracy This project requires a detail-oriented approach and familiarity with the characteristics measured in the assorted tests. Both these skills will ensure the produced reports are insightful and usefu...

    $18 / hr (Avg Bid)
    $18 / hr Snitt bud
    41 bud

    Scraping tool required to pull info from competitor websites, namely Website A, Website B, and Website C. Requirements: - Automatic - Real Time - Options include - Spreadsheet (MVP) - Live System / Database / Platform Skills & experience: - Proficient in web scraping and data extraction - Previous experience with similar projects - Familiar with CSV file formats

    $1478 (Avg Bid)
    $1478 Snitt bud
    40 bud

    I'm seeking an experienced VBA coder for building a macro code in Excel. The primary purpose of the code will be the creation of an Image Paste tool. Significant experience in VBA and familiarity with Excel are both vital attributes. Any previous work involving Image tools using VBA would be advantageous to this project. Scenario is, we have input folder(eg. 1,2,3,4,5,6) for images that folder contains multiple subfolders(eg. For folder name 1 we have subfolders 1-01,1-02,1-03....,for folder name 2 we have 2-01,2-02.... Like that and so on for other folders also), so we have to paste this images in the worksheets which will be created according to folders (e.g. inside the workbook worksheets should be named like "name of input folder-name of subfolder" like 1-1-01, ...

    $112 (Avg Bid)
    $112 Snitt bud
    21 bud

    Hi, we are looking for someone that can help us decide what technology we should use to make automation of our laser with Ezcad 2, the job will consist on providing information. The flow will be, from an internal tool we generate an svg file, then we will launch the macro and it has to enter Ezcad, load the svg, position it correctly, select the engraving preset and fire the laser. We tried to use a software to imitate the clicks on certain coordinates but we are looking if there will be something better. there will be 5 macros for 3 pieces to handle all the types of engraving: - Ring silver - Bracelet gold, silver - Bracelet black - Necklace golf, silver - Necklace black Only bid if you have experience with software automation on real productions. Thanks!

    $47 (Avg Bid)
    $47 Snitt bud
    10 bud

    I need someone to transcribe notes from an ebook. I have timestamps from an audiobook that I will provide, in addition to purchasing the Audible version of the audiobook and the Kindle version of the book, whic...version of the book, which you will use and get to keep. You will need to have an Amazon account, download the Kindle app, and the Audible app. Utilizing Whispersync on Amazon, you move your audio book to the timestamp and your Kindle version will go to that spot in the ebook, at which point you copy and paste the portion from that timestamp to an excel spreadsheet. This project is for transcribing 600 separate timestamps into an Excel Spreadsheet. I am offering $60 for this work (.10 cents a timestamp). The price is non-negotiable so if this is too low for you p...

    $55 (Avg Bid)
    $55 Snitt bud
    42 bud

    I'm seeking a specialist well-versed in Excel 365 to assist me with creating and modifying formulas and functions, as well as improving the overall styling and formatting of my spreadsheets. Wh...formulas and functions, as well as improving the overall styling and formatting of my spreadsheets. While I'm uncertain if interactive dashboards and reporting will be required, an ideal candidate should have the know-how just in case it becomes necessary. This role might require: - Crafting and editing Excel formulas and functions - Enhancing spreadsheet styling and formatting - Knowledge of interactive dashboards and reporting Experience in data analysis is also desirable, though secondary to the main tasks. Applicants should be detail-oriented, organized, and comforta...

    $19 / hr (Avg Bid)
    $19 / hr Snitt bud
    68 bud

    I need a data entry specialist who can manage both numerical and text data. Its simple : I have a few spreadsheet templates These I had printed then out and filled in by hand and scanned I needed the hand entries inputted into the templates Its a one-off Required Skills & Experience: - Proficiency in MS Excel or similar spreadsheet software - Experience in data entry from both hard copies and digitized data - Strong attention to detail for data accuracy

    $20 (Avg Bid)
    $20 Snitt bud
    117 bud

    I need a spreadsheet with the name, email address, and company name of everyone in the USA with the job title "Director of Talent Acquisition". I want 9,000 contacts minimum. Please inform me how many email addresses you can provide, and provide a sample.

    $30 (Avg Bid)
    $30 Snitt bud
    14 bud

    I require a succinct but comprehensive spreadsheet for my trucking company. It needs to present important data on a weekly basis. The following aspects must be included: - Expenses: I need a column where I can indicate my various weekly expenses owner operator. Examples include fuel, tolls, insurance and percentage the company deducts. Company Information: Lastly, please allocate space for driver/owner operator details and company information on the top of the spreadsheet. - Net: I'd like the spreadsheet to automatically calculate the net owner operator makes each week after their expenses. - Load Information: The spreadsheet should have a section where I can input specific details about the loads. This includes load ID, pick up locations, des...

    $34 (Avg Bid)
    $34 Snitt bud
    30 bud

    I require an experienced developer with proficiency in LibreOffice and macro creation. This project involves developing a macro that: - Can identify and replace multiple words within selected cells. I need the macro to delete "W's", replace "l" with "-", among others. Details will be discussed further once the project commences. - Capable of not only replacing the text but also reformatting the modified cells. The specifics of this reformatting will be provided. - Can move the changed text to different cells. The ideal freelancer will have prior experience in creating macros, especially for LibreOffice. A deep understanding of the software and adept skill in macro writing is crucial for success in this project. A keen attenti...

    $26 (Avg Bid)
    $26 Snitt bud
    9 bud

    I need an Excel wizard to create a custom spreadsheet focusing on basic arithmetic operations. The spreadsheet should be able to perform addition, subtraction, multiplication, and division. The data to be used for these arithmetic operations will all be manually inputted by me. Please note that error-checking feature is not necessary for this project. A candidate with strong Excel skills and a keen attention to detail would be the perfect fit for this task.

    $19 (Avg Bid)
    $19 Snitt bud
    25 bud

    We currently use an Excel spreadsheet for an analysis. We would like to incorporate this into our Hubspot CRM. We would like to plug in the paramaters from "Input" tab on the attached spreadsheet. We would then like to the the customer a quote based on the data from "Input" tab. The quote does not need to look like "Pricing" tab, but needs to show something similar.

    $1087 (Avg Bid)
    $1087 Snitt bud
    79 bud

    ...am looking for a detail-oriented and experienced data collection professional to gather pertinent sales data for my business. Ideally, you should have a background in market research or a similar field, giving you the skills to provide in-depth, accurate data collection. Key Responsibilities: - Collect detailed sales data, focusing on product sale quantities, revenue data, and customer purchasing behavior. - Provide the data collection results in an organized Excel spreadsheet for easy manipulation and analysis. Ideal Skills and Experience: • Proven experience in data collection, data mining, or similar. • Proficiency in Excel, including advanced formulas and data visualization. • Strong attention to ...

    $5 / hr (Avg Bid)
    $5 / hr Snitt bud
    64 bud

    I'm currently in need of an expert in Excel and Numbers. I have three sheets on Numbers that need to b...expert in Excel and Numbers. I have three sheets on Numbers that need to be transferred to Excel, adhering to the exact same layout as given in my example. The task primarily involves adjusting the frames and making small changes. • Skills required: Proficiency in Excel and Apple Numbers • Experience: Previous experience in data transfer between different spreadsheet software will be ideal. Familiarity with adjusting frame sizes in Excel is a must. Please note that no data cleaning or manipulation is required. What's crucial in this job is the need to quickly adapt the current sheets from Numbers to Excel within the specified layout. Delive...

    $20 / hr (Avg Bid)
    $20 / hr Snitt bud
    60 bud

    I am looking for a talented developer to create a custom API that connects a third-party API to Google Sheets and performs specific calculations for profit and loss. Your responsibilities will include: - Designing a secure, reliable API integration between the...profit margin. Ideal Skills: - Proficiency in API development and integration - Experience with Google Sheets - Experience with Zapier - Familiarity with financial reporting and basic profit and loss calculations - Strong troubleshooting skills and the ability to solve complex technical problems. The successful freelancer must have experience building custom APIs, preferably with a focus on spreadsheet applications. A strong understanding of financial calculations is a plus, as the API will be used for revenue and cost...

    $160 (Avg Bid)
    $160 Snitt bud
    56 bud

    I need a straightforward web application to generate and store dynamic editable QR codes. The code data, comprising short URL reference numbers and assigned telephone numbers, should be downloadable for easy export to an Excel spreadsheet. This spreadsheet will be used to produce stickers, each with a unique code, sent to specific customers. Upon receiving their sticker, customers should be able to edit their phone number by entering the code's reference number and updating their information.

    $13 / hr (Avg Bid)
    $13 / hr Snitt bud
    74 bud

    I'm seeking a skilled web scraper to extract data from one simple, static website. This project is intended to aid my self-guided studies of the Sanskrit language, so the information gathered will be utilized strictly for my personal learning. There are about 4000 static pages on that site, 99% of the text being in Sanskrit language (unicode), with very small amount of text in most pages in English. There are 12 fields from each of these pages that I want to extract and kept in a data file in a spreadsheet file. Looking forward to working with a resourceful and educational-minded professional.

    $26 (Avg Bid)
    $26 Snitt bud
    31 bud

    ...consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunities. • Well-versed with dynamic loops, data extraction from images. • Work with users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboards using advanced formulas, Advanced Excel, Python and other techniques • Consolidate, sort, organize and summar...

    $3 / hr (Avg Bid)
    $3 / hr Snitt bud
    11 bud

    ...an Excel expert who possesses strong skills in Macro programming. I have different excel files organized in different directories with the same data structure. I need to create a main excel that contain all this data in only one sheet with an automation. (This process needs to be done every 15 days, so needs to be automated) What we do now is to enter to each sheet and copy the data into a main excel and its a lot of manual work. Some requeriments: 1) the row on each excel sheet needs to be added to the main file only when the column 2 ("Fecha de ingreso (dd/mm/aaaa)" is not empty, if not the row should be not consider. 2) There should not be empty rows in the "Main excel" 3) The titles should appear only once in the main excel, as the ...

    $25 (Avg Bid)
    $25 Snitt bud
    62 bud

    I am working on a Google Sheets spreadsheet where I need to process a column of numeric values with a complex calculation function. This complex function involves multiple steps of calculation and cannot be directly translated into a single Google Sheets formula. Here's the scenario: I have a column of input values (let's say column A). Each input value needs to be individually processed by a series of complex calculations to produce a single output. The complex function uses multiple variables and parameters from different cells within the spreadsheet (for example, the annual growth rate in cell E6). The final result for each input should be placed in an adjacent column (let's say column B). Constraints: I would prefer to avoid using Google Apps Script for ...

    $22 / hr (Avg Bid)
    $22 / hr Snitt bud
    12 bud