Workbook.worksheets vba jobs

Filter

My recent searches
Filter by:
Budget
to
to
to
Type
Skills
Languages
    Job State
    2,000 workbook.worksheets vba jobs found, pricing in USD

    Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, 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 knowled...

    $3 / hr (Avg Bid)
    $3 / hr Avg Bid
    10 bids

    I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

    $66 (Avg Bid)
    $66 Avg Bid
    25 bids

    I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I would prefer someo...

    $19 / hr (Avg Bid)
    $19 / hr Avg Bid
    4 bids

    Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

    $7 (Avg Bid)
    $7 Avg Bid
    2 bids

    I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

    $17 (Avg Bid)
    $17 Avg Bid
    11 bids

    I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.

    $716 (Avg Bid)
    $716 Avg Bid
    60 bids

    I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro...the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

    $30 (Avg Bid)
    $30 Avg Bid
    17 bids

    I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data A...Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an added advantage. If you are interested in this project, please include any relevant experience in...

    $6 / hr (Avg Bid)
    $6 / hr Avg Bid
    78 bids
    Modify Excel Macro for macOS 4 days left
    VERIFIED

    I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requir...with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

    $27 (Avg Bid)
    $27 Avg Bid
    25 bids

    ...data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential for automation: I'm not entirely sure if I want the macro to automatically update the original workbooks if the gro...

    $5 / hr (Avg Bid)
    $5 / hr Avg Bid
    6 bids
    Automating Logistics Process 4 days left
    VERIFIED

    ...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and...

    $159 (Avg Bid)
    $159 Avg Bid
    28 bids

    Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

    $100 (Avg Bid)
    $100 Avg Bid
    1 bids

    A weight loss workbook that is appealing to look at and easy to use. Key Components: - The workbook will have textual content that is structured and visually appealing. - It should have graphics and images that are relevant to the content and help in understanding. - The interactive elements should include text input fields, checkboxes, and dropdown menus. These should be designed to be user-friendly and intuitive. The ideal freelancer for this project should have: - A strong understanding of design principles. - Proficiency in creating fillable PDFs with interactive elements. - An understanding of educational content design would be an advantage. - Good communication skills to ensure that the design aligns with the educational goals. Content should contain Weekly weight D...

    $75 (Avg Bid)
    Guaranteed
    $75
    61 entries

    Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...

    $36 / hr (Avg Bid)
    $36 / hr Avg Bid
    38 bids

    I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

    $90 (Avg Bid)
    $90 Avg Bid
    71 bids

    I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...

    $26 (Avg Bid)
    $26 Avg Bid
    37 bids

    I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

    $158 (Avg Bid)
    $158 Avg Bid
    37 bids

    the workbook consists of the below sections: - Section 1 - Vocational Education & Training - Section 2 - Core & Employability Skills - Section 3 - Learning Design - Section 4 - Learning Delivery - Section 5 - Assessment - Section 6 - Administration - Section 7 - Work Health & Safety each section contains between 15 to 26 questions, i will provide martial to help with finding the answers. the workbook is a training and assessment work book

    $11 / hr (Avg Bid)
    $11 / hr Avg Bid
    26 bids

    I am seeking a skilled and experienced content writer or academic writer to create a workbook assignment focusing on Leadership Practices Within Organizations. Key Requirements: - The workbook should be tailored for Undergraduate students. - It should include 3 distinct sections: - Understanding Leadership Practices Within Organisations: 800 words - Analyzing the Impact of Leadership within Organisations: 1500 words - Examining the following aspects of leadership: Leadership styles, Leadership effectiveness, Leadership development. Ideal Candidate: - You should have proven experience in academic writing or content creation with a focus on leadership. - Familiarity with educational materials and the ability to create engaging and informative content for undergraduate ...

    $139 (Avg Bid)
    $139 Avg Bid
    43 bids

    I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...

    $175 (Avg Bid)
    $175 Avg Bid
    49 bids

    the workbook consists of the below sections: - Section 1 - Vocational Education & Training - Section 2 - Core & Employability Skills - Section 3 - Learning Design - Section 4 - Learning Delivery - Section 5 - Assessment - Section 6 - Administration - Section 7 - Work Health & Safety each section contains between 15 to 26 questions, i will provide martial to help with finding the answers. the workbook is a training and assessment work book

    $79 (Avg Bid)
    $79 Avg Bid
    64 bids

    I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks

    $13 / hr (Avg Bid)
    $13 / hr Avg Bid
    67 bids

    ...write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experience with integrating APIs with Excel. Familiarity with cloud storage solutions like OneDrive and handling file structures programmatically. Additional Information: Please provide examples o...

    $173 (Avg Bid)
    $173 Avg Bid
    28 bids

    I need a skilled developer who is proficient in working with Google Cloud...proficient in working with Google Cloud's OCR functionalities. The project involves the following specifics: - File Format: The OCR system should be able to extract text from PDF files, no other formats are required. - Output Format: The extracted text should be converted into a word file and worksheets. - Language Support: The OCR should be able to recognize and extract text in English only. This task requires someone with expertise in Google Cloud's OCR, the ability to generate word files and worksheets, and a solid understanding of language processing for English. High attention to detail and accuracy is crucial for this project. Basic UI is also needed for file management like input...

    $44 (Avg Bid)
    $44 Avg Bid
    3 bids
    Data Analyst FARMING DATA 1 day left
    VERIFIED

    FARMING DATA Data: Download this Excel Workbook including these 3 tables: ● ○ Prices_Crops_Livestock ○ Production_Crops_Livestock. ○ Land_In_Use NOTE: These tables contain agricultural information for 20 countries and a list of various crops and livestock products. The data is sourced from the Food and Agriculture Organization of the United Nations where you can find definitions and standards. Scenario: Imagine you're a data analyst at a global agricultural organization, entrusted with enhancing worldwide agricultural production understanding. American stakeholders seek a comprehensive view of global farming trends as they evaluate diverse food supply chain initiatives. Audience: American stakeholders. Insights: Address several questions to gain insights about your data

    $27 (Avg Bid)
    $27 Avg Bid
    49 bids

    I'm seeking a...develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. Can be used as refe...

    $471 (Avg Bid)
    $471 Avg Bid
    49 bids

    ...consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts or macros for data consolidation. - Performance Optimization: Experience in optimizing Excel for better speed and performance would be a big plus. - Attention to detail: The accuracy and integrity of data are crucial, so attention to detail is a must. - Communication: Regular updates and clear communication throughout the project a...

    $21 (Avg Bid)
    $21 Avg Bid
    33 bids

    As discussed I have delivered the excel workbook. Thanks!

    $20 (Avg Bid)
    $20 Avg Bid
    1 bids

    I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.

    $1152 (Avg Bid)
    $1152 Avg Bid
    24 bids

    Develop macro-enabled Excel workbook

    $120 (Avg Bid)
    $120 Avg Bid
    1 bids

    ...runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models int...

    $13 / hr (Avg Bid)
    $13 / hr Avg Bid
    12 bids

    ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.

    $9 / hr (Avg Bid)
    $9 / hr Avg Bid
    21 bids

    ...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...

    $95 (Avg Bid)
    $95 Avg Bid
    18 bids

    I need some who could develop the skeleton of an app to generate specif...buttons will be displayed on this screen, Start Again button (starts from the beginning to choose another topic) and Retry button (redo a new test on the same topic) All logic and error checking needs to be done for each question type. The following link provides all the maths type of questions that need to be included, we are only focusing on YEAR 3 questions. I would like to get a MVP for the first 5 categories Place Value, Addition, Subtraction, Multiplication, Division. Please provide cost for MVP and in your reply the rest of the categories. If you have read this brief, please answer the follwing question in your reply. What is the the opposite of UP?

    $265 (Avg Bid)
    $265 Avg Bid
    65 bids

    Looking for someone proficient to create the design of my book. It is a book like a workbook or photo album. Book size: A5 (148 x 210 mm) The book consists on: - Introduction - Table of Contents - 100 activities. One activity per page (please see the example attached) - Quotes that intersperse the pages - Conclusion PLEASE READ - PLEASE READ - PLEASE READ Start your proposal with the budget and delivery time

    $34 (Avg Bid)
    $34 Avg Bid
    28 bids

    I need assistance with EXCEL- Working with Multiple Worksheets and Workbooks The task is quite urgent, so I need someone who can start right away and complete the project in a timely manner.

    $22 (Avg Bid)
    $22 Avg Bid
    68 bids

    I need an Excel expert to review and make suggestions for how they would improve a register workbook which I have already created for tracking Quality System Document and Record Control. The register is a template which my quality systems consulting customers use to track procedures, policies, and work instructions, as well as active and archived records. I expect the expert to have a strong understanding of Excel, formulas, functions, and design of excel workbooks so that they look professionally made and are also easy to use (and perhaps also customise if required). The final product should look professional and offer an effortless way to track quality system document controls as well as support the managers and users of the system. Proficiency in Excel and background in quality c...

    $78 (Avg Bid)
    $78 Avg Bid
    14 bids

    I am in need of an experienced ghost writer to craft a workbook consisting of 50 short activities. The workbook is for late teens age 17-19. The main objective of the workbook is to handle anger management and emotional regulation. Key tasks and outputs: - The activities should be a mix of mindfulness exercises, cognitive behavioural therapy (CBT) strategies, worksheets, journaling assignments, and self-reflection prompts. - The resource should aim to foster critical thinking, improve communication, and inculcate creativity in teens. - The writer should be skilled in working pedagogical theories into content that resonates with teens. Preferred skills: - Ghost writing experience, specifically in emotional health or wellness sector. - Effective communication...

    $415 (Avg Bid)
    NDA
    $415 Avg Bid
    16 bids

    I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking will be a plus point. Please ...

    $85 (Avg Bid)
    $85 Avg Bid
    13 bids

    ...skilled graphic designer with experience in creating compelling training materials. We are hosting a workshop geared toward holistic well-being, catering to a general audience with a focus on spiritual development. We have a book that will serve as the foundation for the content of the workshop. What We Need: - Creative layouts and designs for the whole set of workshop materials which include: workbook, slides, trainer script, exercises, handouts, and training guidelines. - Graphics that can engage adults in learning and meditative practices. Ideal skills and experience: - Graphic design experience specifically in creating educational/training content. - Knowledge or interest in topics like holistic well-being, meditation, mindfulness, and self-reflection. - Strong understandi...

    $485 (Avg Bid)
    $485 Avg Bid
    67 bids

    ...stock alert mechanisms to notify users when inventory levels fall below a certain threshold. - Alerts can be sent via email, SMS, or displayed within the software dashboard. This software solution would require a database backend to store all relevant data and a user-friendly interface for easy interaction. You could develop it using Microsoft Access, incorporating forms, queries, reports, and VBA (Visual Basic for Applications) for automation and customization. Consider consulting with stakeholders and users throughout the development process to ensure the software meets their specific needs and requirements. Additionally, thorough testing and refinement will be crucial to ensure the software operates smoothly in real-world scenarios. Key Features and Requirements: - Strea...

    $553 (Avg Bid)
    $553 Avg Bid
    51 bids

    Hi. I need help to setup the binding for a RichTextBox .NET Control so that data is retained. There may be use of VBA that is needed. This is within a FactoryTalk View SE version 14 application. I don't know .NET or VBA, I am a FactoryTalk guy though. Example use case: Lets say a factory has 100 valves. If a user opens popup for Valve #3, I need a text box field in that popup for the user to enter data, and then data is preserved/saved. That popup should be one common FTV display that references the Valve_# that was selected (using parameter files, or...). This example is the main objective. I need a simple and easy solution to this, and I need to understand how to do it myself afterwards. This is perhaps a 1 hour job. My name is Marc. I'm ready to s...

    $94 (Avg Bid)
    $94 Avg Bid
    11 bids

    ...- Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manually select the version to work with. This ensures control and adaptability to changing needs or scenarios. The Ideal candidate has advanced knowledge not only in plugin development but also a deep understanding of financial data and its complexities. Proficiency in Excel, VBA, and data management are key, along with a keen attention to detail and a commitment to accuracy. Experience in financial modeling is a big plus. Your ability to meet these specific needs could make a significant difference in my work. - I would like to do quick interactions of the project and rapidly develop the final product. My design does not require any database connection. -...

    $8 - $15 / hr
    Featured Sealed
    $8 - $15 / hr
    8 bids

    As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel 2016 - Demonstrate flexibility a...

    $20 (Avg Bid)
    $20 Avg Bid
    11 bids

    I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specifically any projects rel...

    $484 (Avg Bid)
    $484 Avg Bid
    39 bids

    ...To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK AND THE TOTAL OF ALL NEED TO PRINT EACH WORKBOOK AS IMAGE IN A3 AFTER COLORING CELLS - Applying frequency distribution in order to derive significant trends from the ...

    $50 (Avg Bid)
    Guaranteed
    $50
    15 entries

    ...ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming - Strong background in data analysis and visualization - Experience in creating macros for automation - Excellent communication skills to understand the project requirements and translate them into effective solutions This project is a great opportunity for someone looking to enhance their skills in advanced Excel-based roles and gain hands-on experience in data analy...

    $17 / hr (Avg Bid)
    $17 / hr Avg Bid
    48 bids

    I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be delivered in the next...

    $33 (Avg Bid)
    $33 Avg Bid
    5 bids
    $50 Avg Bid
    1 bids

    I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.

    $419 (Avg Bid)
    $419 Avg Bid
    24 bids