| Home > Freelance Excel Jobs | Share |
| 648137 |
| Excel Macro (Tue, 23 Apr 2024) |
| Need a quick macro made that will let me select two files, and then output a third that matches data and fields between the first and second file. More data available to qualified bidders. Budget: $45 Skills: Microsoft Excel, Macro Programming, Macros Skills: Microsoft Excel, Macro Programming, Macros |
| Excel Expert To Build Algebraic Formula In Excel With Multiple Variables (Tue, 23 Apr 2024) |
| I need to mix three products together to make a certain volume of Product L (solve for volume of product L). The three products have the following ingredients and volumes. 3.83% of ingredient F (concentrations can change over time so our formula must account for this) 3.18% ingredient P (concentrations can change over time so our formula must account for this) 38.5% of ingredient F 0% of ingredient P 0% of product F 80% product P Assume Product Z has no volume, thus having no impact on volume of Product L 30% of ingredient F .0333% of Ingredient P How many gallons of M amp; C, and how many pounds of Z do I need to make X gallons of Product L? Skills: Mathematics, Equations, Microsoft Excel, Algebra Skills: Mathematics, Equations, Microsoft Excel, Algebra |
| Excel Macro Debug (Tue, 23 Apr 2024) |
| We are in need for someone to debug a financial spreadsheet created by a previous employee. It has a large script capturing data from many locations and would like to have the script documented and to help us find the bug causing it to fail. Skills: Microsoft Excel, Excel Macros, Visual Basic Skills: Microsoft Excel, Excel Macros, Visual Basic |
| Excel Expert For Formula Assistance (Tue, 23 Apr 2024) |
| We are seeking an Excel expert to help us understand and analyze a formula in our budget created by an accountant. The successful candidate will have a strong knowledge of Excel formulas and functions, as well as experience working with budgets. The main task will be to review the formula and provide us with a clear explanation of how it works and any potential improvements or optimizations. Attention to detail and the ability to communicate complex concepts in a clear and concise manner are essential skills for this job. Skills: Microsoft Excel, Visual Basic for Applications, Spreadsheet Software Skills: Microsoft Excel, Visual Basic for Applications, Spreadsheet Software |
| (urgent) Vehicle Cost Modelling Excel + Vba (Tue, 23 Apr 2024) |
| The full detailed task is attached, feel free to ask me any questions I will respond ASAP. Will need this by end of day if possible, task is quite short. Provide answers in Answer sheet. Budget: $20 Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming |
| Excel Chart Expert (Tue, 23 Apr 2024) |
| We are seeking an Excel expert to assist with creating charts for our company s data analysis. The ideal candidate should have a strong proficiency in Excel and a comprehensive understanding of different chart types, including bar charts, line charts, and pie charts. Responsibilities will include analyzing data sets, identifying key trends, and transforming the data into visually appealing and easily understandable charts. The successful candidate will have a keen eye for detail, excellent communication skills, and the ability to work efficiently under tight deadlines. Auto population of cells from other workbooks hourly. The idea is to have a living chart as the data comes in. - Proficiency in Microsoft Excel - Strong knowledge of chart creation - Analytical thinking - Attention to detail - Communication skills Skills: Microsoft Excel, Data Visualization, Visual Basic for Applications, Data Analysis Skills: Microsoft Excel, Data Visualization, Visual Basic for Applications, Data Analysis |
| Edit 2 Excel Vba Scripts (Tue, 23 Apr 2024) |
| I have 2 vba scripts that I need edited. Both are written to access an external file and imports data into an existing spreadsheet. I need to make minor edits to both. Budget: $20 Skills: Visual Basic for Applications, Microsoft Excel Skills: Visual Basic for Applications, Microsoft Excel |
| Excel Expert For Operational Analytics Task (Tue, 23 Apr 2024) |
| We are seeking an Excel Expert to assist with an operational analytics task. The ideal candidate will have a strong understanding of Excel functions and formulas, data analysis, and creating visually appealing dashboards. This task involves analyzing large datasets, cleaning and organizing data, creating pivot tables, and generating insightful reports. The candidate should be proficient in using advanced Excel features such as macros, VBA, and conditional formatting. Attention to detail and the ability to work efficiently and accurately are essential. - Advanced knowledge of Excel functions and formulas - Data analysis - Pivot tables and data visualization - Macros, VBA, and conditional formatting - Attention to detail - Efficient and accurate work ethic Skills: Microsoft Excel, Data Analysis, Visual Basic for Applications, Financial Analysis Skills: Microsoft Excel, Data Analysis, Visual Basic for Applications, Financial Analysis |
| Excel Pivot Table Workbook Builder (Tue, 23 Apr 2024) |
| We are looking for an expert Excel professional to build a comprehensive Excel pivot table workbook that can interact with other Excel workbooks. The goal is to create a dynamic and user-friendly tool that allows us to analyze and summarize large amounts of data efficiently. The workbook should be able to extract data from multiple sources, perform complex calculations, and generate insightful reports. - Advanced knowledge of Microsoft Excel and pivot table functionality - Proficiency in data analysis and manipulation - Strong understanding of formulas and functions - Experience in connecting and consolidating data from different Excel workbooks This project is of medium size and expected to be completed within 1 to 3 months. We are seeking an Excel expert with a solid understanding of pivot tables and data analysis techniques. If you are detail-oriented, have excellent problem-solving skills, and can deliver high-quality work on time, we would love to hear from you. Skills: Microsoft Excel, Visual Basic for Applications, Microsoft Excel PowerPivot, Spreadsheet Software Skills: Microsoft Excel, Visual Basic for Applications, Microsoft Excel PowerPivot, Spreadsheet Software |
| Excel Creator (Tue, 23 Apr 2024) |
| Hello, we are looking for someone to create an Excel document to help us manage all our B2B contacts. Today we have an Excel document with a large number of contacts, we would like someone to create an Excel that we can use on sheets, that can be updated between different users, we would like something simple that will enable us to manage all our contacts, and to be able to sort out between two simple Prospects and real customers, we have a well-filled specification, we await your message and remain at your disposal. Budget: $50 Skills: Microsoft Excel, Data Entry, Visual Basic for Applications, Data Analysis, Administrative Support Skills: Microsoft Excel, Data Entry, Visual Basic for Applications, Data Analysis, Administrative Support |
| Excel Dashboard For Data Visualization / Forecasting (Tue, 23 Apr 2024) |
| Help me build an Excel dashboard which will be for our raw materials forecasting. I have the raw data and input assumptions prepared in an existing excel sheet, however i need someone to convert it into a good looking excel dashboard that is dynamic and well designed. I know what i need to have in terms of data visualization/ graphs, tables, etc. but need someone to help me present the data in an attractive format through a dashboard. Need someone with experience and examples of similar work done. See attached file for full project brief. What I want most is excellent design, so please send some examples. . Budget: $50 Skills: Dashboard, Microsoft Excel, Data Visualization, Data Modeling, Data Analysis Skills: Dashboard, Microsoft Excel, Data Visualization, Data Modeling, Data Analysis |
| Vba - Data Retrieval From Excel Add-in (Tue, 23 Apr 2024) |
| Hi, our accounting system has an addin to excel and we have formulas to retrieve data through that. But I want a macro code that can trigger the ribbon in the tool bar. I can give some more info. Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming |
| Excel Expert To Merge 2 Sheets Into 1 (Tue, 23 Apr 2024) |
| I am updating a spreadsheet but it has been easier for me to create a new spreadsheet from scratch due to new criteria required. I need to merge the new sheet into the previous one. Budget: $150 Skills: Microsoft Excel, Spreadsheet Software Skills: Microsoft Excel, Spreadsheet Software |
| Data Automation - Microsoft Power Automate (Tue, 23 Apr 2024) |
| Our company uses a Google sheets document to display key performance Metrics for our business. We have a separate Google Sheet for each store location and a different tab within the sheet for each month. We wish to automate the collection of this data and entry into the Google Sheets. None of the platforms have API. We require an automation to open the CRM, login, locate the required metric and then enter it into the correct location within the Google Sheet for each separate location. We think that Microsoft Power Automate will be the solution here. But we are also open to suggestions. A more detailed job brief with clear walk through videos will be provided to shortlist candidates. Skills: Microsoft Power Automate, Business Process Automation, Dashboard, Data Scraping, Task Automation, Spreadsheet Automation, Google Sheets, Automation Skills: Microsoft Power Automate, Business Process Automation, Dashboard, Data Scraping, Task Automation, Spreadsheet Automation, Google Sheets, Automation |
| Ms Excel Expert Needed For Excel File With More Than 2,000,000 Rows (Tue, 23 Apr 2024) |
| MS Excel Expert Needed To Process An Excel File With More Than 2,000,000 Rows -Must Be Familiar With Power Data Query -Data Within Files Are Not To Be Altered -Files Are Proprietary And Not To Be Shared OR Distributed To Any Other 3rd-Party (non-disclosure agreement may be required) -We Will Require A New File Processed Every Month So This Means That We Will Most Likely Hire The Same Person Every Month For This Job. -This Job Pays $5 Per Job (kindly keep in mind that we do not pay $5 per file) -Kindly Send Us Your Resume For Consideration Thank you for your time. Budget: $5 Skills: Data Processing, Microsoft Excel, Spreadsheet Software, Macro Programming, Accuracy Verification Skills: Data Processing, Microsoft Excel, Spreadsheet Software, Macro Programming, Accuracy Verification |
| Transfer Reference Format From A List In A Word File By Vba (Mon, 22 Apr 2024) |
| Transfer reference format from a list in a Word file by VBA. 1. The last author and second last author could be connected by , and , , amp; , or only , 2. The non-first authors might have their initial in front or back of surname. Some authors might use two initials. See exmple in attached. 3. There might have or not have pp. before page number. 4. The title of article could be inside or not. 5. The name of journal could be italic or not. 6. The published year might be inside parathesis or not. 7. The published year could be after name of authors or name of journal . 8. Change to a special format (JAR) that the letters of authors are all capitalized and yet the first letter is bigger (example please see the end of an attached a paper; please google to find how to transfer this format in Word). And the authors are separated by ; rather than , . For example, some in the list might have non-first authors initial in front of surname, some in the back of surname. I need the code that can make all in the reference become required format. You can find some examples of different formats in google scholar by clicking (detail attached) Usually, my original list only has APA and Harvard. So you don t need to worry about the whole name of initial. To be more efficient, please check obvious mistakes before submitting your work. Budget: $10 |
| Creating Excel Tools For Farmers (Mon, 22 Apr 2024) |
| Create user-friendly Excel spreadsheets amp; calculators for farmers amp; ranchers. I have specific examples that can be referenced, consolidated, integrated, and used as inspiration. Specific uses would be for financial/business tracking. Must be robust, visually appealing and simple enough any 8th grade educated person can use them. These will be templates farmers and ranchers can download to better manage their farm businesses. Skills: Dashboard, Microsoft Excel, Data Visualization, Excel Formula Skills: Dashboard, Microsoft Excel, Data Visualization, Excel Formula |
| Excel File Customization (Mon, 22 Apr 2024) |
| I have an Excel spreadsheet with data that needs to be developed into an application-type interface in the spreadsheet to allow for easy user-level sorting and searching of information within the fields. Skills: Microsoft Excel, Spreadsheet Software Skills: Microsoft Excel, Spreadsheet Software |
| Ms Access Query Creation (Mon, 22 Apr 2024) |
| Need to create a query in MS access using the tables Skills: Microsoft Access, Microsoft Access Programming Skills: Microsoft Access, Microsoft Access Programming |
| Ms Access - Excel Integration (Mon, 22 Apr 2024) |
| I m looking for a knowledgeable freelancer with solid experience in MS Access 2016 and Excel. - Proficiency with MS Access 2016 - Proficiency with MS Excel - Experience in handling customer data - Expertise in data linking between MS Access and Excel - Strong data management skills As this is a critical business function, reliability and attention to detail are paramount. You are expected to test and ensure the robustness and accuracy of the Access-Excel link before completion of the project. Skills: Microsoft Access Programming, Microsoft Excel, Visual Basic for Applications, SQL, Microsoft Access Skills: Microsoft Access Programming, Microsoft Excel, Visual Basic for Applications, SQL, Microsoft Access |
| Excel Data Import, Manipulation And Visualization (Mon, 22 Apr 2024) |
| I am looking to have a CSV file imported into Excel and then have date duplicates concatenated and removed, and the ability to sort the data with a dropdown menu. Create 4th order sorting option (name, date, day of week, scores, etc). Manipulate some of the data (Simple addition certain values in rows, select highest score from row, compare values, etc.) then present the data in visual graphs that automatically update depending on selected data. Presented in a visually pleasing way. Fairly straightforward for someone with a lot of experience in Excel. Budget: $20 Skills: Dashboard, Microsoft Excel, Visual Basic for Applications, Data Analysis, Microsoft Power BI, Data Visualization Skills: Dashboard, Microsoft Excel, Visual Basic for Applications, Data Analysis, Microsoft Power BI, Data Visualization |
| Excel Vba Project (Mon, 22 Apr 2024) |
| Need an Excel VBA expert to take our existing excel report and add some automation features and functions. We need to be able to select the number of test to be conducted, the type of test and have the data collection sheets automatically created. We need to add the functions of being able to add pictures to the report and timer / stop watch for each test. We need the excel report to generate a final MS word report. We have a very robust existing report that we need to add these functions too. Budget: $1,500 Skills: Automation, Business Process Automation, Data Extraction, Spreadsheet Automation, Task Automation, Microsoft Excel, Visual Basic for Applications, Data Analysis, Spreadsheet Software, Visual Basic Skills: Automation, Business Process Automation, Data Extraction, Spreadsheet Automation, Task Automation, Microsoft Excel, Visual Basic for Applications, Data Analysis, Spreadsheet Software, Visual Basic |
| Vba To Sharepoint Folder (Mon, 22 Apr 2024) |
| I have a calculate button in excel, whenever that button is clicked, its usage must be logged in a text file on a teams folder. Just calculate used must be appended to the existing data. That s all. Budget: $50 Skills: Visual Basic for Applications, Microsoft SharePoint Development Skills: Visual Basic for Applications, Microsoft SharePoint Development |
| Excel Expert Required - Business Model Template Uk P&l & Cashflow Forecast - Ongoing Projects (Mon, 22 Apr 2024) |
|
Excel Expert Required - Business Model Template UK P amp;L amp; Cashflow Forecast To re-work an existing Excel Business Forecast with new functions and calculations The excel has 1. specific related business inputs (costs) 2. From those costs a business model needs to be outputted in to 2.1. A Profit and Loss forecast (already built, needs editing) 2.2. A Cashflow forecast which is -13 weeks from an opening date. A word document brief will be supplied Export data in to CSV, TXT readable files Manipulate data using VB Script / Macros, etc I have ongoing projects that will require the skills of someone who knows VB Script and all the usual functions in excel to create reports and data generated templates from SQL. The initial project will be a small test of skill which we will pay for your time based on completing the work. Skills: Microsoft Excel, SQL, Microsoft Excel PowerPivot, Microsoft VBScript, Visual Basic for Applications, Financial Modeling, Financial Analysis, Financial Projection, Forecasting Skills: Microsoft Excel, SQL, Microsoft Excel PowerPivot, Microsoft VBScript, Visual Basic for Applications, Financial Modeling, Financial Analysis, Financial Projection, Forecasting |
| Excel Formulas Expert Needed (Mon, 22 Apr 2024) |
| We are seeking an experienced Excel expert to help create formulas for our spreadsheet. The ideal candidate should have a strong understanding of Excel functions and be able to develop complex formulas to automate calculations and analyze data. This project will involve working with large data sets and identifying the most efficient formulas to perform calculations accurately. - Develop complex formulas to automate calculations and analysis - Optimize existing formulas for better performance - Troubleshoot and fix formula errors - Collaborate with team members to understand data requirements - Proficient in Excel functions and formulas - Strong analytical and problem-solving skills - Attention to detail and accuracy - Excellent communication and collaboration skills If you have the expertise and skills required to excel in this role, we would love to hear from you. Please submit your proposal along with examples of your previous work with Excel formulas. Budget: $200 Skills: Microsoft Excel, Visual Basic for Applications, Data Entry Skills: Microsoft Excel, Visual Basic for Applications, Data Entry |
| Ms Excel Vba Udf() Calculate Vlookup (Mon, 22 Apr 2024) |
| Hi Excel VBA Gurus Two things create Sub n create function() call the sub through function and calculate the lookup output and pass the result into the working sheet where function called. once test we can add this function through Add-In so the user can call this function on their working book. Hope make sense if not happy to show you via screen share Thanks Budget: $30 Skills: Visual Basic for Applications, Macro Programming Skills: Visual Basic for Applications, Macro Programming |
| Bespoke Sales Forecast Excel Template (Mon, 22 Apr 2024) |
| I would like to create a bespoke sales forecast template that includes data capture and projection visualisation for a sales team. I have examples and a formal brief. I will need the final product delivered as both an excel and a google sheet. Skills: Microsoft Excel, Visual Basic for Applications, Financial Projection Skills: Microsoft Excel, Visual Basic for Applications, Financial Projection |
| Microsoft Word Macro For Report Writing (Mon, 22 Apr 2024) |
|
We are seeking a skilled programmer to create an advanced Microsoft Word automation tool that will streamline the process of generating reports by importing client and project details from a PDF assignment sheet into a pre-designed Word template. The ideal candidate will develop a solution that not only automates data import but also elegantly solicits additional project-specific information to be integrated into the report. Develop a Microsoft Word program or script that can extract client and project details from a given PDF assignment sheet. Ensure the extracted data is accurately placed into the corresponding fields of a Word report template. Create an interactive feature within the Word document that prompts users to input additional project details as needed. Design the solution to be user-friendly, efficient, and capable of handling various data formats and inconsistencies with elegance and precision. Budget: $200 Skills: Microsoft Word, Macro Programming, Visual Basic for Applications Skills: Microsoft Word, Macro Programming, Visual Basic for Applications |
| Consulting On How To Protect And Licence Vba Tools (Sun, 21 Apr 2024) |
| We re looking for maximum 2 hours of consultation at 100 USD/hr on how to protect our VBA for Excel code. We have valuable proprietary code that we d like to protect through a time sensitive licencing check in the spreadsheet. We have development capability on our side, so this is more about Q amp;A on best practices for how to approach a build like this. Budget: $200 Skills: Visual Basic for Applications, Microsoft Excel Skills: Visual Basic for Applications, Microsoft Excel |
| Advanced Excel Operational Analytics Expert (Sun, 21 Apr 2024) |
| Tasks 1. Construct a queueing model that replicates a week of collecting and processing DNA samples. a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an average solution. a. Unit of interest a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. a. To the nearest ten, how many samples will be processed by the end of the seven days? How many of those samples will result in a DNA match? b. What is the mean time to process a sample? c. What percentage of samples meet the police force s ambition to process samples in less than one day? d. Is there any stage of the process that looks under-resourced? Why? 4. Construct a simulation model using the information provided to you above, and your average model as the starting point. a. Unit of interest a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Each iteration of the simulation is one week of processing samples. c. Use the same assumptions as for the Task 2 model. d. You MUST use @RISK. Do NOT save raw simulation data in the file. e. You must save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. f. You will need to determine the appropriate probability distribution for each input. g. Run the model for 10,000 iterations. h. Set the random number seed to the 5052. Tasks (continued) a. Present all time units in minutes. c. Comment on any observations/insights from the queueing time distributions you have plotted and summarised in Task 4a. d. Summarise* the distribution for the mean number of samples processed, and the mean number of samples matched to the DNA database, in one week. e. Plot and summarise the distribution for the mean time to process a sample. f. Plot and summarise the distribution for the percentage of samples that are processed in under 24 hours (each iteration being one week of sampling). g. How confident are we that at least half of all samples in one week will be processed in 24 hours or less? h. Conduct an appropriate Sensitivity Analysis that shows the main influence on the time it takes a sample to be processed. i. Conduct any other relevant, ad-hoc analyses that you think will yield useful insights to help reduce the time to process samples further. 5. What-if Scenario modelling a. Taking your further analyses from Tasks 4f and 4g as the basis for improving the model, construct 2-3 plausible scenarios that will improve the confidence that at least half of all samples from one week are processed in 24 hours or less. b. Modify at least two stages of the model (these must be reasonably unique do not copy scenarios from others). c. Rerun simulation model with the same random number seed and compare results to that produced in Task 4. d. By plotting and comparing relevant probability distributions, explain how your modified scenario has reduced the time taken to process samples, and how it has impacted the likelihood of processing samples in under one day. 6. Insights and recommendations a. In your report, provide a short summary of your insights and recommendations for how to improve the Rapid DNA process that was trialled over the past few months. Budget: $180 Skills: Microsoft Excel, Data Analysis, Analytics, Visual Basic for Applications, Data Modeling, Statistical Analysis, Excel Formula Skills: Microsoft Excel, Data Analysis, Analytics, Visual Basic for Applications, Data Modeling, Statistical Analysis, Excel Formula |