Excel macros jobs

...Collaborate with team members and supervisors to clarify data entry requirements and resolve any issues. Qualifications: High school diploma or equivalent; relevant coursework or certifications in data entry or related fields is a plus. Proven experience in data entry or a related role is preferred. Strong computer skills, including proficiency in data entry software and Microsoft Office Suite (e.g., Excel, Word). Excellent attention to detail and accuracy. Strong organizational and time management skills. Ability to work independently and remotely with minimal supervision. Strong written and verbal communication skills. A commitment to maintaining confidentiality and data security. Familiarity with data entry best practices and quality control processes is a plus. Reliable int...

I am looking for someone to create a SIMPLE monthly/annual personal finances tracker to keep my records in order and easily manageable. This will include both tracking my expenses and income using "fund accounting." Additionally, I would like to have SIMPLE budgeting and reporting features. The platform I plan to use is Google sheets/Excel. My budget is 50 Euros.

I am looking for a freelancer who can assist me with cleaning numeric data in Excel. The dataset has more than 5 columns and 500 rows. Skills and experience required: - Proficiency in Excel and data cleaning techniques - Strong attention to detail - Ability to work with large datasets - Knowledge of formulas and functions in Excel - Experience in data manipulation and analysis The ideal candidate should be able to clean the data efficiently and accurately, ensuring that any errors or inconsistencies are identified and resolved. They should also be able to organize and structure the cleaned data in a logical and user-friendly format. If you have prior experience in cleaning large datasets and possess the necessary skills, please submit your proposal for consideratio...

Project Description: I am seeking a freelancer who can proofread and provide me with a comprehensive video explanation of a capitalization table and deal offers. I already have an excel file with the required offers evaluated. Specific Requirements: - Video explanation: The client has specified that they prefer a video explanation over a written explanation or a visual presentation. - Comprehensive explanation: The client wants a thorough explanation of everything related to the capitalization table and deal offers. They are not looking for a general overview or a focus on specific areas or concepts. - Length of the video: The client has requested a video explanation that is more than 10 minutes in length. Ideal Skills and Experience: - Strong knowledge of staged financing and c...

Looking for an Excel wizz for a quick side by side one page comparison Excel sheet of the data in the "TCO Summary" tab on each spreadsheet. Need someone creative and who knows Excel well to design a page that will show the data as a summary in a clean manner. I will need x2 summary pages, one with the optional and the other without the optional. I am looking for a freelancer to create a side by side comparison Excel document for my project. The specific items or categories that I would like to compare are services. Although I don't have a specific format in mind for the comparison, I do have some ideas that I would like to incorporate. The data that needs to be compared is simple with few variables. Ideal skills and experience for this job ...

Project Title: Excel Automatization Description: We are looking for a skilled Excel expert to automate specific tasks in Excel. The ideal candidate will have experience in data entry, formulas and calculations, as well as data analysis and reporting. Specific tasks to be automated: - Data entry tasks need to be streamlined and automated to improve efficiency. - Formulas and calculations need to be automated to ensure accuracy and save time. - Data analysis and reporting tasks need to be automated to generate regular reports with minimal manual effort. Formulas: - We need recommendations for specific formulas to be implemented in the automation process. The candidate should have expertise in recommending and implementing formulas based on the project requirements. ...

I am looking for an experienced freelancer to create monthly Excel reports for my business. The report must contain sales, financial, customer, and supplier performance data. I have a preferred template that I will provide, and the reports are expected to be delivered on a monthly basis. This project requires solid knowledge of Excel and attention to detail to create accurate and comprehensive reports. If you have the experience to create these reports, I would be very interested in hearing from you.

...Collaborate with team members and supervisors to clarify data entry requirements and resolve any issues. Qualifications: High school diploma or equivalent; relevant coursework or certifications in data entry or related fields is a plus. Proven experience in data entry or a related role is preferred. Strong computer skills, including proficiency in data entry software and Microsoft Office Suite (e.g., Excel, Word). Excellent attention to detail and accuracy. Strong organizational and time management skills. Ability to work independently and remotely with minimal supervision. Strong written and verbal communication skills. A commitment to maintaining confidentiality and data security. Familiarity with data entry best practices and quality control processes is a plus. Reliable int...

Project Description: I am looking for a freelancer who can create an Excel spreadsheet with automation capabilities. The specific tasks that I want the spreadsheet to automate include data entry, calculations/formulas, and data analysis. Skills and Experience Required: - Proficiency in Excel and advanced knowledge of formulas and functions - Experience in creating automated spreadsheets - Strong analytical skills to effectively analyze and interpret data Template or Example: Unfortunately, I do not have a template or example of the desired spreadsheet layout. The freelancer will need to create the layout based on the requirements discussed. Deadline: There is no specific deadline for the completion of this project.

1. Front-end Form for Excel Upload: You want a web page with a form where a user can select an Excel workbook file (e.g., ) from their computer. 2. Node.js Reading the File: When the user submits the form, the Node.js server should receive the uploaded file via a POST of saving the uploaded file on the server's disk, you want Node.js to read the file directly from the request (in memory). 3. Parsing Excel Data with SheetJS: Once the file is read, you want to use the SheetJS library to parse the data within the 'Defects' worksheet of the uploaded Excel parsed data should be converted into a JSON object. 4. Logging the JSON Object: Finally, you want to log this JSON object to the console as proof that the Excel file has been successfully...

I am looking for a PHP developer to create an informational website with a specific design. The purpose of the website is to provide the name of the owner of phone number that I give, using TrueCaller app, I should upload an excel file to this website, that include one column ( the phone number), and the website should export a new excel file with some new columns as , first name, last name, and any other information that could get from the truecaller app. the features I want to include: Ideal skills and experience for this job include: - Strong knowledge of PHP and web development - Understanding of best practices in website security and user authentication

I need someone to extract the text data from a PDF file and convert it into an Excel spreadsheet. I'm unfamiliar with the organization of the data in the PDF so the data may be structured or unstructured. I don't have any specific formatting requirements - just basic standard formatting would be fine.

Project Description: I am in need of a freelancer who can build an excel that pulls real-time stock prices from a website API. Skills and Experience Needed: - Proficiency in Excel and API integration - Experience working with real-time data - Strong understanding of stock market and financial data - Ability to update data every hour - Familiarity with website API documentation and ability to navigate and implement it into the excel The ideal candidate will have a strong attention to detail and the ability to accurately and efficiently pull real-time stock prices from the website API. Looking to get this done by end of today (8 hours deadline)

...front end form that allows user to elect an excel workbook to upload via POST request to express application. The example to upload is attached as postConstruction.xslx. 2. Node.js reads the file in the request WITHOUT needing to save a copy locally. Alternatively, the app must delete the temporarily saved file from the request when request is complete. 3. Once the file has been read, generate a JSON object by parsing the 'Defects' worksheet of the uploaded file using SheetJS and log the JSON object to prove it has been successfully parsed. An example JSON object has been attached that should be the expected result when the is uploaded. Skills and Experience: - Strong proficiency in Node.js - Experience in working with excel files and manipulating data - K...

Develop automation to group data from a source file and generate an output file

I am looking for a Tableau expert to help with my visualizations using Excel and CSV files. The preferred type of visualization is filters and I need help figuring out how to use measures as filters. Skills and experience required: - Strong proficiency in Tableau - Experience working with Excel and CSV files. - Expertise in creating filter-based visualizations

I am in need of assistance in projecting my financial statements in Excel. I need the projections to cover a period of 3-5 years with assistance in creating a balance sheet, cash flows, income statement, ratios, as well as historical financial data. I have the historical financial data available so I need someone who is experienced in Excel to help me with the projections. The end goal is to have accurate and reliable projections to analyze and use for decision making purposes. I have attached the homework instructions and can show work already completed in excel

Need to create a set of questions on an Excel SS and convert to JSON file

...hardware for: - compute / GPIO module (e.g. ESP32) - GPS module (e.g. Geekstory BN-220) - matching possible external antennas (active/passive) to increase accuracy - LTE module (for later milestones) - research for ideal hardware (ESP and positioning) - provide a Excel with the decision parameters - provide your hardware recommendations based on the decision parameters - power supply for MS2, MS3 shall be USB powersupply to be easy able to replace/charge power banks, along with choosing usb plug for mobile tests examples for the Excel: product; product type; sensitivy GPS; sensitivy GLONASS; sensitivity Galileo; sensitivity ...; cold start time; energy during cold start, energy in hot standby, ...; description; hints; your experiences ; ...; expected accuracy internal ant...

Excel Wizard Needed for Formula Creation (CSE) In the attached are two small tables. Table one has a list of rules. Table two has a list of days. A color must be assigned to all of the days in table 2 based on the rules in table1. It will need Excel CSE or Dynamic Arrays. No VB or macros allowed. Its a puzzle!

I am looking for an Excel expert with experience in Visual Basic to help me with creating automatic data in Excel. Specific tasks that I need assistance with include: - Creating macros - Automating tasks I have specific requirements for the Visual Basic programming and I would like the expert to work with my existing Excel files. Ideal skills and experience for this job include: - Advanced knowledge of Excel - Proficiency in Visual Basic programming - Experience with creating macros and automating tasks in Excel - Ability to work with existing Excel files

...tree population and density. - Inferential statistics will be applied to draw conclusions and make predictions based on the sample data. Preferred Software: - The client prefers to use Excel for the data analysis. Therefore, proficiency in Excel is essential to successfully complete this project. Report and Presentation: - A written report of the analysis is required, as the client wants a detailed summary of the findings. - Additionally, the client would like the analysis to be presented, either through a presentation or a visual representation of the results. Ideal Skills and Experience: - Proficiency in Excel for data analysis and visualization. - Strong knowledge of both descriptive and inferential statistics. - Experience in analyzing ecological or environme...

I am looking for an Excel specialist who can assist me with intermediate data analysis tasks. Specific tasks I need help with include: - Performing data analysis using Excel - Applying formulas and functions to manipulate and analyze data - Visualizing data through charts and graphs I have all the necessary data for analysis, so no data gathering is required. The data analysis required is at an intermediate level, so the ideal candidate should have: - Proficiency in Excel and experience with data analysis - Strong knowledge of formulas and functions in Excel - The ability to create compelling visualizations of data - delivery in 2 days If you have the skills and experience needed for this project, please submit your proposal.

...Collaborate with team members and supervisors to clarify data entry requirements and resolve any issues. Qualifications: High school diploma or equivalent; relevant coursework or certifications in data entry or related fields is a plus. Proven experience in data entry or a related role is preferred. Strong computer skills, including proficiency in data entry software and Microsoft Office Suite (e.g., Excel, Word). Excellent attention to detail and accuracy. Strong organizational and time management skills. Ability to work independently and remotely with minimal supervision. Strong written and verbal communication skills. A commitment to maintaining confidentiality and data security. Familiarity with data entry best practices and quality control processes is a plus. Reliable int...

I need to analyze data concerning sample plots for tree population and density.

One off scraping of scoreboard Data into Excel file

I am seeking an experienced freelancer to carry out a trend analysis on approximately 2000 cases of data that I have. Specifically, I am after a visual analysis, which I have the data for in Excel format. The objective of this trend analysis is to identify any patterns within the data. The outcome of the trend analysis isn’t necessarily to predict future trends or understand current situations, but instead to find patterns within the data which may point to a solution, answer a question or uncover an underlying issue. Experience in data analytics is essential, and an understanding of the latest trend analysis and visualisation techniques is desired. I am open to any creative solutions to this analysis, so any experience or qualifications related to data analytics would be ...

I am seeking an experienced freelancer to assist me in setting up a report in Power BI using data from Excel spreadsheets. The data is moderately complex with multiple columns, so I need someone who is comfortable working with data of this sort. I have expectations for the final product to include extensive tables and matrices which will succinctly and clearly present the information in a cohesive manner. If this project sounds like something you can do confidently, I'd love to chat more with you about it!

I am looking for a freelancer who can help me solve a problem using transportation method software. The specific problem I need to solve is allocating resources efficient...software. The specific problem I need to solve is allocating resources efficiently. Constraints and limitations for the problem are not yet known, so flexibility and adaptability will be important in finding a solution. I prefer to use Excel Solver for this project. Please write me the following: software name, website address, problem description, and input variables and output. Required skills and experience for this job include: - Proficiency in transportation planning and route optimization - Knowledge of inventory management - Experience with using Excel Solver or similar software to s...

I am looking for a freelancer who can assist me with an OCR project focused on resumes/CVs. The main goal is to extract specific data fields from PDF files and convert them into an Excel spreadsheet (Specifically key-value pairs). The ideal candidate should have experience in OCR technology and be familiar with resume/CV formats. Requirements: - Expertise in OCR technology - Proficiency in working with PDF files - Ability to extract specific data fields from resumes/CVs - Experience in converting data into Excel spreadsheets Skills: - OCR technology - PDF processing - Data extraction - Machine Learning - Python

I am looking for a data extraction robot that can access the Federal Revenue Service website and extract from approximately 1 million CNPJs per week for an existing business. The data must be extracted to a specific format - an Excel file - and it must have certain specific data fields. This project requires an experienced developer who can create a reliable and efficient system to collect the data and format it accordingly. We are in need of an individual, or team, who has experience with webscraping as well as extracting and formatting data. If you think you have the knowledge and expertise required to complete this project, please get in touch. We look forward to hearing from you!

I'd like a Virtual Assistant to only input data into a to-do list. Probably I will share an excel file shared in drop box and share the drop box location with you. Hopefully I can provide you with Due date / Category / Description for you to populate Then you could share the file on email with me every week perhaps? I suspect this to take no longer than 2-3 hours per week There may be further duties but its important that English is fluent and written english is fluent. Video calls is a must.

I am looking for an experienced freelancer to perform a random sampling and sampling distribution on an excel dataset. The population size is more than 1000, and I need to take 25 random samplings of 30 observations. The purpose of the sampling is for Data Analysis. Experience in excel and familiarity with statistical sampling methods is a must. The successful freelancer will understand the project context and be able to provide accurate data to the requirements' also need a brief description on how you did it.

I need a clerk to do a comparison task between 2 excel files with approx 2000 rows

The excel template should have the option to list all the resources across multiple projects, edit/manage their allocations, and calculate the forcasted monthly costs (burnrate) for each project. Each resource (team member) would have: Employee ID Employee Name Role Project allocated (could be more than 1) Allocation % (for each allocated project) Allocation Start Date (for each allocated project) Allocation End Date [Conservative estimate] (for each allocated project) Allocation End Date [Conservative estimate] Confirmed? (Y/N) Allocation End Date [Realistic estimate] (for each allocated project) Daily Rate (Salary for each working day) There should a calendar view for the list of resources to visually view/edit the allocation at a week level detail. Color differentiated for each...

I would like to scrape data from the Dutch website Please see the Excel file what kind of info I would like to scrape. All advertisements within 20KM of 1075XJ postcode All advertisements within 20KM of 1075XJ postcode which contain "Te Huur" in title All advertisements within 20KM of 1075XJ postcode which contain "Te Koop" in title

I need help with an Excel VBA project that involves retrieving Historical data from Interactive Brokers via DDE. I currently have an existing code that needs to be modified, and I need it to be done within a week. The data I need to retrieve is Historical data only. Experience with both Excel VBA and DDE is a must. If you think you can help, please let me know. Thanks! More details summary below. The attached sheet is working and pulls historical OHLC stock trading historical data into Excel via VBA/DDE from Interactive Brokers' TWS desktop trading platform. The excel file is a cut down version of Interactive brokers example DDE excel sheet. The sheet currently uses a manual button click, which cycles through a list of stock codes on the Historica...

...Products: Please visit the respective websites and document a list of all products available for sale. Include the product name, ingredients, and price for each item. Categorization: Organize the products into relevant categories based on their intended use. For example, products related to digestion should be categorized under "Digestive Remedies," and so forth. Excel Spreadsheet: Input the gathered information into an Excel spreadsheet. Create columns for product name, ingredients, price, and category for easy reference and analysis. Please ensure that the information is up-to-date and accurate. If any products have variations (e.g., sizes, or formulations), kindly include these details in your report. We greatly appreciate your assistance in this research...

I need someone to enter product data manually from website to excel sheet *** THE TASK IS FOR 50 ITEMS ** SEND ME YOUR BEST BID Here is an Example From this link i need you to generate Title=White modern bed with chrome accent and led light white gloss Description =Elevate your bedroom's ambiance instantly with this enticing bedroom set. The standout feature is the ambient LED lighting along the platform bed's edges, evoking a vintage neon glow. Chrome accents on the headboard complement the case goods, all finished in glossy white for a timeless fusion of futuristic aesthetics with a touch of nostalgia. Keywords = Modern bed, white bed, led bed, modern white bed ,

We work in a sector which has a lot of logistics documents. Employees are required to read and get information from these documents. We require a plugin for ChatGPT 4 which has the capability of reading some of the information on the document such as the weight, how many containers are on...sector which has a lot of logistics documents. Employees are required to read and get information from these documents. We require a plugin for ChatGPT 4 which has the capability of reading some of the information on the document such as the weight, how many containers are on the document, who is the shipper, consignee, what are the container, seal numbers, and transfer this information onto an Excel with correct categorization. There is an example of the document that will be read by this plugin...

...contextually relevant. 3. **Source Documentation:** Each sentence should be accompanied by its source. This is vital for ensuring the credibility and authenticity of the data. 4. **Excel File Management:** Compile the sentences and their sources into an organized Excel spreadsheet. Each row should contain the Cherokee sentence, its English translation, and the corresponding source. **Requirements:** - Strong research skills. - Familiarity with Excel or other spreadsheet software. - Commitment to meeting deadlines and ensuring high-quality data. **Submission:** The final dataset should be submitted in an Excel file format. Each row should have the following columns: 1. Cherokee Sentence 2. English Translation 3. Source **Duration:** The project sho...

i need dynamic hyperlinks expert who will work on my excel sheet

...looking for a skilled Excel expert to develop a linear timber cutting list optimizer. The desired output format for the cutting list is an Excel spreadsheet. Specific requirements for the cutting pattern have not been provided, so the freelancer should be able to work with specific dimensions or be open to any pattern. I should be able to import a cutting list as per attached into the optimizer spreadsheet. I will specify the timber lengths we have in stock, for example 2.4m, 3.6m, 4.2m, 4.8m, etc.(This can change) The optimizer should provide me with a cutting list, picking out of the stocked timber sizes, utilizing materials in a most cost effective way. (Less wastages) Waste should be indicated in %. Ideal skills and experience for this job include: - Advanced ...

I am looking for an advanced Excel expert who can provide training for a duration of 1 week. The training is specifically for an individual. The ideal candidate should have expertise in the following skills and topics: - Advanced Formulas and Functions - Data Analysis and Pivot Tables - Automation and Macros The training should cover these topics comprehensively and provide hands-on practical exercises. The expert should have excellent communication skills to effectively convey complex concepts and techniques. Additionally, the expert should be able to tailor the training to the specific needs and level of proficiency of the individual.

...provide a detailed analysis of the profitability, while also providing a high-level overview of the trading process. Skills and Experience: - Strong background in financial modeling and analysis - Knowledge of electricity trading and the factors that affect profitability - Experience in working with large sets of data and creating models that can handle complex calculations - Proficiency in using Excel or other similar software for creating financial models - Ability to interpret and analyze data to identify trends and make informed decisions The freelancer will need to have the ability to gather and work with the data provided by me. This may include historical electricity prices, trading volumes, and other relevant data. The level of detail required in the model is somewhere...

A 5-7 projection forecast for a business that contains but is not limited to the following capital expenditure, operating costs, taxes, foreign exchange rates, expenses, cash flows, owners equity, revenue etc. A business plan

...pursuit of a successful career in solar. We are here to foster your growth and help you achieve your personal and financial aspirations. JOIN OUR TEAM AS A SOLAR SALES CLOSER As an Inside Solar Sales Closer, you will be the driving force behind our Inside Sales Team! The ideal candidate is a seasoned expert in closing deals, possessing the motivation and readiness to hit the ground running. To excel in this role, you must possess exceptional rapport-building skills and be adept at conveying the advantages of solar energy. Fearlessly asking for the sale is crucial. With the proper use of our provided resources and training, you will effortlessly seal deals from the get-go. Requirements - Complete training successfully and learn our sales scripts - Promptly engage with pre-qua...

I'm looking for an expert Excel developer who can build a dashboard for my business. The dashboard must track specific data and metrics, including hr data such as headcount by years, new hires, open positions, average days to fill, employees by education, male vs female, I have a specific design in mind for the dashboard; it must have interactivity, including multiple filters and drill-downs. I need someone who is experienced with Excel and has a good eye for detail and can produce quality work. If you think you have the skills and experience to deliver a well-crafted dashboard, please contact me.

Creating dynamic hyperlinks in excel

I need text fields in this form to be in a fillable PDF form that can be used multiple times by multiple users - with its data automated to enter into excel