| Home > Freelance Excel Jobs | Share |
| Data Analyst (excel/powerbi) With Programming Background (Fri, 03 May 2024) |
| The Palmer Group is committed to leveraging data-driven insights to achieve our goals and enhance decision-making processes. As we continue to grow, we are seeking a talented Data Analyst with expertise in Excel, PowerBI, and a strong programming background. Bachelor s degree in Computer Science, Statistics, Mathematics, or related field. Proven experience as a Data Analyst or similar role, with a focus on data analysis, visualization, and programming. Advanced proficiency in Excel, including PivotTables, VLOOKUP, and complex formulas. Strong expertise in PowerBI or similar BI tools for data visualization and dashboard creation. Proficiency in programming languages for data manipulation and automation. Experience with statistical analysis, hypothesis testing, and predictive modeling techniques. Excellent analytical skills with the ability to interpret complex datasets and communicate insights effectively. Strong attention to detail and problem-solving abilities. Ability to work independently and collaboratively in a fast-paced environment. Skills: Dashboard, Analytical Presentation, Data Analysis, Microsoft Excel, Microsoft Power BI, Data Visualization, Data Modeling, Microsoft Excel PowerPivot, Visual Basic for Applications, Microsoft Power BI Data Visualization Skills: Dashboard, Analytical Presentation, Data Analysis, Microsoft Excel, Microsoft Power BI, Data Visualization, Data Modeling, Microsoft Excel PowerPivot, Visual Basic for Applications, Microsoft Power BI Data Visualization |
| Need Someone Good With Vba And Macros (excel) (Fri, 03 May 2024) |
|
1.In the WhatsApp New sheet, commas are missing. It should be formatted as 7,55,232/- instead of 755232/-. 2.In the Desired Output, I want to set a starting number. Currently, it starts from 1, but I wish to change it according to my preference. For example, if I set it to 5, the numbering should start from 5, 6, 7, and so on. 3.In the Customer Name Selection sheet, I want to add Cmpdil to the tab in Mjun. Additionally, provide a way to easily add more data to this tab. 4.I will provide a list of numbers, and if they exist in the total data, they should be reflected in the Customer Name Selection sheet. Please note- folks with experience or folks who send me a demo of the above work will be preferred. I have more projects with me, need someone reliable. Budget: $5 Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming, Microsoft Excel PowerPivot Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming, Microsoft Excel PowerPivot |
| Daily Macros/automation To Be Built To Gather Report (Fri, 03 May 2024) |
| Hi all - I m in need of a form fill automation. We have a need to fill out the same form multiple times, yet changing just one field in that form. I d like to build out a web app to be able to update get this done quicker. Thanks! Skills: Microsoft Excel, Visual Basic for Applications, Automation Skills: Microsoft Excel, Visual Basic for Applications, Automation |
| Excel Vba Expert (Fri, 03 May 2024) |
| We are looking for a skilled Excel VBA expert to help us with a quick project. The main task will involve creating a VBA macro to automate data processing and analysis in Excel. The ideal candidate should have a strong background in VBA programming, as well as a good understanding of Excel functions and formulas. Attention to detail and the ability to work independently are essential for this role. - Excel VBA programming - Data processing and analysis - Formulas and functions in Excel If you have the necessary skills and are available to start immediately, please apply with your relevant experience and share examples of previous Excel VBA projects you have completed. This is a small project with an estimated duration of under 1 month. Intermediate to expert level expertise is required. Budget: $15 Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming |
| Excel Spreadsheet To Visual Display Conversion (Fri, 03 May 2024) |
| We are looking for a skilled professional who can build an Excel spreadsheet that can be converted into a visually appealing display. The spreadsheet will contain data that needs to be presented in an interactive and visually engaging manner. The ideal candidate should have a strong understanding of Excel functions and data visualization techniques. Attention to detail and the ability to create visually appealing designs are crucial for this project. - Advanced knowledge of Excel functions and formulas - Proficiency in data visualization tools - Strong attention to detail - Creativity in designing visually appealing displays This is a medium-sized project with a duration of 1 to 3 months. We are looking for an intermediate-level expert who has prior experience in transforming Excel spreadsheets into visually attractive displays. Skills: Microsoft Excel, Visual Basic for Applications, Spreadsheet Software, Data Entry Skills: Microsoft Excel, Visual Basic for Applications, Spreadsheet Software, Data Entry |
| Alteryx Workflow Optimization & Macro/app Creation (Fri, 03 May 2024) |
| I have an already existing Alteryx workflow/macro that I need assistance optimizing. Ultimately I would like to make a simple conversion of the macro into an app. The base query feeds from SQL server and is straightforward. This is a two step project. First optimizing then app creation. Budget: $200 Skills: Macro Programming, Automation, Alteryx, Inc., Analytics Skills: Macro Programming, Automation, Alteryx, Inc., Analytics |
| Data Clean Up And Vba/macro Automation (Fri, 03 May 2024) |
| I have a large excel data that is generated every 4 hours. Takes a long time to clean up and arrange in prep for reconciliaiton. I need someone to write Macros to automate the cleanup and the matching reconciliation of attached sample file. Details will be provided when job commences Skills: Visual Basic for Applications, Macro Programming Skills: Visual Basic for Applications, Macro Programming |
| Excel Vba Api Call (Fri, 03 May 2024) |
|
Create a VBA Script which calls an RestFul API and sends data from the Excel Table. If data already exists, update if not create. Skills: Visual Basic for Applications, Microsoft Excel, API Development, API Skills: Visual Basic for Applications, Microsoft Excel, API Development, API |
| Sql Queries In Vba (Fri, 03 May 2024) |
| *** Need the project do be done in 7 hours *** Write 5 relatively easy SQL queries in VBA to filter/sort bond data and e.g. finding average etc. given a condition. Should not take more than 2-3 hours for an expired SQL and VBA user, and I ll even help you navigate the data so that it goes fast. Budget: $75 Skills: Visual Basic for Applications, SQL, SQL Programming, Microsoft Excel Skills: Visual Basic for Applications, SQL, SQL Programming, Microsoft Excel |
| Automate And Improve Excel Report (Fri, 03 May 2024) |
| I need to automate a number of excel reports all linked to sales data to update monthly 10-15 different tabs all linking to the same pivot table. Build in slicers and buttons to make reporting simpler and analysis more user friendly. Create tables and graphs that can easily be moved to Power point. Skills: Macro Programming, Excel Macros, Microsoft PowerPoint, Microsoft Excel, Data Analysis, Automation Skills: Macro Programming, Excel Macros, Microsoft PowerPoint, Microsoft Excel, Data Analysis, Automation |
| Excel Forms And Database Automation (Fri, 03 May 2024) |
| Develop data entry forms in excel or Google Sheets with automation capability whereby information can be extracted into a excel spreadsheet database. Three to four forms and associated lists/database excel. Content has been developed. Skills: Microsoft Excel, Automation, Spreadsheet Software, Visual Basic for Applications Skills: Microsoft Excel, Automation, Spreadsheet Software, Visual Basic for Applications |
| Vba Program Improvement And Testing (Thu, 02 May 2024) |
| Programmer and teacher. I have developed a basic restauratn simulation for teaching high school students. 1. I need someone to spruce up and standardize the look and feel of the program. 2. fix some long term bugs, improve the business model 3. Beta test all scenarios Part time 10 hours a week. Skills: Visual Basic for Applications, Microsoft Excel Skills: Visual Basic for Applications, Microsoft Excel |
| Data Migration Expert With Advanced Excel Skills (Thu, 02 May 2024) |
| We are in need of a skilled data migration expert with experience in Storis and advanced Excel skills. The main responsibility will be to migrate data from our current system to Storis, ensuring accuracy and completeness. The ideal candidate should have a strong understanding of data mapping and transformation, as well as experience in handling large data sets. Advanced Excel skills, including the use of power queries, are crucial for this role. - Perform data extraction, transformation, and loading (ETL) processes - Develop and implement data migration strategies - Collaborate with the team to ensure data accuracy and integrity - Troubleshoot and resolve data migration issues - Data migration in Storis - Advanced Excel skills - Power queries This is a medium-sized project with an estimated duration of 1 to 3 months. We are looking for an expert-level professional who can hit the ground running and deliver high-quality results within the specified timeframe. Skills: Microsoft Excel, Data Entry, Visual Basic for Applications Skills: Microsoft Excel, Data Entry, Visual Basic for Applications |
| Excel Sheet Creation For Seamless Integration With Bluebeam Takeoff Software (Thu, 02 May 2024) |
| I am seeking an experienced professional who can create an excel sheet that seamlessly pairs with my Bluebeam takeoff software to instantly generate accurate bid proposals. The ideal candidate will have a strong understanding of excel formulas and functions, as well as some knowledge of Bluebeam software. The excel sheet should be user-friendly and intuitive and easy to adapt, allowing our team to easily input takeoff data and generate professional bid proposals. Attention to detail and accuracy are crucial for this project. I m assuming we will have to go through a few iterations of the excel template until it is what I need. - Proficient in Microsoft Excel - Expertise in Bluebeam takeoff software - Strong understanding of excel formulas and functions - Attention to detail and accuracy Budget: $350 Skills: Microsoft Excel, Visual Basic for Applications, Data Entry Skills: Microsoft Excel, Visual Basic for Applications, Data Entry |
| Ms Excel Specialist For Data Viz Sales Reporting Tool (Thu, 02 May 2024) |
| We are seeking an experienced MS Excel specialist to develop a sales reporting tool using pivot tables and pivot charts. Your main responsibility will be to create a user-friendly tool that can generate comprehensive and visual reports based on raw sales data. The tool should allow for easy filtering and analysis of sales performance by various dimensions such as region, product, and time period. - Proficiency in MS Excel and advanced knowledge of pivot tables and pivot charts - Strong analytical and problem-solving skills - Attention to detail and ability to work with large datasets - Excellent communication and collaboration skills This is a smaller-sized project with an estimated duration of approx. 1 - 1.5 months. We are looking for an intermediate-level expert who can deliver high-quality results within the given timeframe. If you have a strong track record in developing Excel-based reporting tools and are excited about helping us improve our sales analysis, we would love to hear from you. Skills: Microsoft Excel, Visual Basic for Applications, Data Analysis, Microsoft Excel PowerPivot, Data Visualization Skills: Microsoft Excel, Visual Basic for Applications, Data Analysis, Microsoft Excel PowerPivot, Data Visualization |
| Excel Formula Expert (Thu, 02 May 2024) |
| We are seeking an Excel Formula Expert to compare data in 4 columns. The task involves creating a formula that will analyze the data in each column and provide a comparison result. This includes identifying matches, differences, and any other relevant information. The expert should have a strong understanding of Excel functions and formulas, as well as experience in data analysis. - Advanced knowledge of Excel formulas - Data analysis - Attention to detail This is a small-sized project that can be completed within a month. We are looking for an intermediate level expert who can efficiently handle the task and produce accurate results. Skills: Microsoft Excel, Visual Basic for Applications, Spreadsheet Software Skills: Microsoft Excel, Visual Basic for Applications, Spreadsheet Software |
| Help Improving Existing Vba Code To Add New Functionality (Thu, 02 May 2024) |
|
- Clean up the way a report is reflected, since some items are duplicated (see Pic1) - Clean up VBA code that copies Sheets to a master sheet, we are having an issue with cell Formatting (see pic2) - Create a new Module for Quotes that will not affect Invoicing - Checking for errors on the VBA modules (see pic3) Budget: $200 Skills: Microsoft Windows, Visual Basic for Applications, Excel Macros Skills: Microsoft Windows, Visual Basic for Applications, Excel Macros |
| Cogs, Margin And Profitability Report Automation (Thu, 02 May 2024) |
| We are a product-based wholesale business that uses cloud-based inventory software (cin7), and we re experiencing difficulty in generating accurate and efficient reporting each month, particularly around COGS reports, and client profitability reports. - To create an accurate COGS per product, per month - To create an average COGS for a period of time, as a single number (such as 55%) - To understand the revenue and gross profit per client, on a monthly basis - To have the ability to create these reports easily - To trust in the accuracy of the data I have created a Loom video, explaining our situation in more detail and what we are trying to achieve. Please watch the video to fully understand the task and then explain your proposal when you apply. Ideally we want to be self-sufficient and have either an automated system, use macros, scripts, or hear alternative solutions and ideas. Remember, this is not about assuming our data is formatted. This task is about implementing a solution that validates the data s integrity through your proposed process, so you need to have a deep understanding of what COGS is, what can affect it, and how you can validate the data s accuracy in the process. It will be up to you to understand the raw data, our variables, and ensure the automation provides the desired outcome. This project should not be looked at as a custom dashboard task. This task is to focus on creating a COGS and customer profitability report solution, allowing my team to access accurate reports when they need. Skills: Microsoft Excel, Accounting, Inventory Management Skills: Microsoft Excel, Accounting, Inventory Management |
| Excel Dashboard Expert (Thu, 02 May 2024) |
| We are looking for an Excel expert who can help us create a dynamic dashboard. The dashboard will involve data visualization, calculations, and interactive features. The successful candidate will have a strong understanding of Excel functions, formulas, and macros. They should be able to design a visually appealing and user-friendly dashboard that meets our specific requirements. Additional skills required include data analysis, data manipulation, and problem-solving. The ideal candidate will have experience in creating complex Excel dashboards and will be able to work independently with minimal supervision. This is a medium-sized project with an expected duration of 1 to 2 weeks Skills: Microsoft Excel, Data Analysis, Data Visualization, Visual Basic for Applications Skills: Microsoft Excel, Data Analysis, Data Visualization, Visual Basic for Applications |
| Make Automation - Sweep Custom Report Data From Xero To Excel (Thu, 02 May 2024) |
| We are a SME business currently using Xero accounting software and we require an automation set up through Make.com. That Automation will run a custom report out of Xero extracting the data to excel format to then be fed into Power Bi. Skills: Automation, Make.com, Xero, Microsoft Excel Skills: Automation, Make.com, Xero, Microsoft Excel |
| Scrape Supplier Excel Stock Levels & Sync With My Stock Sheet (Thu, 02 May 2024) |
|
Allow uploading of our latest Shopify stock export file (XLS) and the stock data files from various suppliers. I also need to update a second file in a different format for Google and mark each product in a particular column with either the text in_stock (for items in stock of with a known ETA, or backorder where the item is out of stock and the ETA is not known.) Process the uploaded files to check and scrape stock numbers or estimated time of arrival (ETA) for out-of-stock items. (for suppliers items that are in stock) (for suppliers items that are due to arrive back in stock soon) (to encourage pre-orders for items due back in stock at a known future date - the data in here should reflect what the stock sheets are advising) (to offer incentives for pre-orders when items are out of stock) The updated Excel file should be ready to import back into Shopify to reflect the changes in stock levels. To streamline our stock management process, making it more efficient and less prone to errors due to software instability. A robust app that doesn t crash, works on Mac or online if possible (or Windows if it can t be done another way), graceful error handling that picks up any expected syntax changes in the supplier sheets, and shows a pop-up at the end telling me how many products have been updated. Also good documentation to help us use the app. I have attached a screenshot of my current app, which needs replacing. Skills: Data Scraping, Data Extraction, Microsoft Excel Skills: Data Scraping, Data Extraction, Microsoft Excel |
| Vba Developer For Word File Image Rearrangement (Thu, 02 May 2024) |
| We are in need of a skilled VBA developer to create a macro for a Word file that can rearrange the placement of images and pictures. The macro should be able to effectively reposition and align images based on specific criteria. The goal is to automate the process of arranging images within the document, saving time and effort. - Develop and implement VBA code to manipulate and rearrange images in Word files. - Ensure the macro is user-friendly and easy to execute. - Test and debug the code to ensure it functions correctly across various scenarios. - Proficiency in VBA programming for Microsoft Word. - Strong understanding of manipulating and formatting images in Word documents. - Attention to detail and the ability to follow specific instructions. This is a medium-sized project with an estimated duration of a week. We are looking for an intermediate-level VBA developer with experience in Word automation. We would love to hear from you if you have the expertise and skills required for this task. Budget: $75 Skills: Visual Basic for Applications, Microsoft Excel, Microsoft Word, Desktop Application Skills: Visual Basic for Applications, Microsoft Excel, Microsoft Word, Desktop Application |
| Excel Incentives Calculator (Thu, 02 May 2024) |
| We are seeking a skilled freelancer to build an incentives calculator using Excel formulas. The calculator will be used to determine incentives for our sales team based on their performance metrics. The ideal candidate will have a strong understanding of Excel and be able to create complex formulas to calculate incentives accurately. This project requires attention to detail and the ability to organize data effectively. The freelancer should also possess excellent problem-solving skills and be able to work independently. - Advanced Excel skills - Formulas and functions expertise - Data organization and analysis - Problem-solving ability If you have the necessary skills and experience to create an efficient incentives calculator, we would love to hear from you. Please provide samples of previous Excel projects or relevant work. We anticipate this project to be of medium size and have a duration of 1 to 3 months. The expertise level required is intermediate. Skills: Microsoft Excel, Visual Basic for Applications, Financial Modeling Skills: Microsoft Excel, Visual Basic for Applications, Financial Modeling |
| Excel Expert (Thu, 02 May 2024) |
| We are seeking a skilled and analytical individual to join our team as a Discovery Offer Calculator Specialist. In this role, you will be responsible for developing and maintaining a sophisticated calculator tool used to generate offers for potential clients in the staffing industry. Your expertise will be instrumental in understanding the diverse factors influencing client offers and lead generation, ultimately driving business growth and client satisfaction. Also can do lead generation spreadsheets Budget: $25 Skills: Microsoft Excel, Data Analysis, Spreadsheet Software, Visual Basic for Applications Skills: Microsoft Excel, Data Analysis, Spreadsheet Software, Visual Basic for Applications |
| Excel Spreadsheet Formulas Expert (Wed, 01 May 2024) |
| We re looking for someone who knows their way around Excel spreadsheets and formulas. Your main job will be to create and use complex formulas to automate workflows. We understand that this isn t the ideal way to do this, and project managment would be far easier, but we are working towards implementing PM and need this in the intrem. My main task is to create an automated WORK IN PROJECT / TASKLIST. I will enter tasks and would like those tasks to copy over to the responsible persons list of daily tasks. - Create complex formulas to automate a Tasklist. - Make sure that formulas are accurate and efficient - Fix any formula errors that come up - Proven experience as an Excel formulas expert - Strong knowledge of Excel functions and formulas - Ability to work with large sets of data - Pay attention to details and be accurate If you re an Excel pro with a strong background in formulas, we d love to hear from you. Skills: Microsoft Excel, Spreadsheet Software, Visual Basic for Applications Skills: Microsoft Excel, Spreadsheet Software, Visual Basic for Applications |
| Excel Vba Ribbon Combobox Coding (Wed, 01 May 2024) |
| I have a comboBox in a Ribbon to select the paper size. It does, what it s supposed to do, but there is a minor bug. Upon closing and opening the workbook, the highlighting of the selected item disappears. I d like the comboBox to behave like for example the font size box. The selected item should always stay highlighted. Skills: Microsoft Excel, Visual Basic for Applications, Macro Programming Skills: Microsoft Excel, Visual Basic for Applications, Macro Programming |
| Excel To Access Migration (Wed, 01 May 2024) |
| Starting with a test project. I would like to migrate from Excel worksheets to Access. Importantly, there are many Excel formulas and calculations with the data that I will want to run in Access. Perhaps there is a tool to run excel formulas in Access. Skills: Microsoft Excel, Microsoft Access Programming, Microsoft Access, Visual Basic for Applications, Data Migration Skills: Microsoft Excel, Microsoft Access Programming, Microsoft Access, Visual Basic for Applications, Data Migration |
| (long Term) Excel Reporting - Consolidation And Simplification (Wed, 01 May 2024) |
| We re looking for an excel specialist to help us with reporting every week. We will provide you with a list of excel spreadsheets from different suppliers. Some might be in PDF that you might have to convert them into Excel Spreadsheets. You will need to consolidate the reports and send us a new report based on the columns we need. This is a long term position and job is one report per week. Budget: $1,000 Skills: Microsoft Excel, PDF Skills: Microsoft Excel, PDF |
| Excel Expert For Ppc Role (Wed, 01 May 2024) |
| I am looking for someone skilled in using Excel ,Pivot tables and making decisions and recommendations about the data. You will be creating Paid advertising campaigns (PPC),and using your skills to analyse the data. No previous knowledge of paid advertising is needed as training will be provided in the approach to be used but will help in the role and getting up to speed. The key to this role will be your ability to make independent decisions based on the data. The role is currently set as a 3 month role but could be extended by another 3 months for the right person. Skills: Microsoft Excel PowerPivot, Data Analysis, Microsoft Excel, Visual Basic for Applications Skills: Microsoft Excel PowerPivot, Data Analysis, Microsoft Excel, Visual Basic for Applications |
| Microsoft Access Code (Wed, 01 May 2024) |
| I have a developer who has went MIA. Therefore I fear that I may need to hire a new one. More importantly, for today, I have a simple fix that I cannot do. Hopefully you can make this change and impress me enough to use you going forward. Skills: Microsoft Access Programming, Microsoft Access, Visual Basic for Applications Skills: Microsoft Access Programming, Microsoft Access, Visual Basic for Applications |