Excel vba macros charts jobs
I need a skilled professional who can adeptly convert financial Excel sheets into a document fit for presentations, adhering to standard formatting. The extensive data consists of complex financial information. The perfect match for this project would have: - Profound experience in handling Excel and financial data - Proven knowledge in producing sophisticated documents, maintaining presentability and readability - Ability to deliver precise and clear formatting in standard style Exactness, reliability, and a keen eye for detail are integral for this task. Efficient turnaround time would be appreciated.
I am looking for an expert in Power BI visualization design to work with me on my project. I have a dataset focused on operational metrics and need professional assistance in turning this data into comprehensive charts and graphs. The scope of work includes: • Developing Key Performance Indicator (KPI) visuals • Integrating data into visually engaging charts and graphs The ideal candidate will have: • In-depth experience with Power BI report development and visualization design • Proven background in representing operational metrics data through graphs and charts • Strong understanding of data modeling and report optimization • Excellent attention to detail and accuracy in representation of data. Overall, my aim is to represent my ope...
...coast region of Australia. Key Information Required: - Contact details: I need a name of the person who manages the trucks their phone number. - Geographic location: It's important to know where these individuals or companies are located. - I need the company name The final list should be delivered in an Excel spreadsheet. Ideal Skills and Experience: - Strong research abilities: The ability to dig deep and find the right contacts in these specified industries. - Proficiency in Excel: The ability to compile and present the data in an organized and clear manner. - Understanding of the target industries: Experience in or understanding of the Transportation and logistics, Construction, and Agriculture sectors would be a big plus. Please let me know about any past ...
...the quality of their own leads by contacting the customer by calling or messaging them to scheduling a zoom call using Calendly. The states will depending on the states you hold an active license in. (I will help you get your Non-Residence license in the states you get clients) #2 Agent Acquisition Specialist. I am looking for someone to scout for people looking for jobs that allows them to excel in the company quickly. I am looking to hire 10 more agents just like you. Or agents with potential in any state (CLOSERS). This position with require you to generate your own leads for potential life insurance agents screen them for the criteria listed above, and book the potential agent on a zoom call with me or one of my staff using Calendly. Please note that these agents will...
I need a professional...- Extracting: I require the following contact information to be extracted: Business Name, Email, Phone number, Full address separated by suburb, postcode and state. - Formatting: All extracted data should be structured and organized into an Excel spreadsheet. Ideal Skills: - Web Scraping: Proficiency in web scraping tools and techniques is essential. - Data Entry: Experience with data entry and extraction. - Attention to Detail: Accuracy in capturing and organizing contact details is crucial. - Excel Proficiency: Ability to create and format an Excel spreadsheet effectively. - Communication: Regular communication and updates on the progress of the task would be appreciated. I'm looking for a reliable freelancer who can deliver this tas...
Hello. I have a multiple page excel spreadsheet, but I need it to have more flexibility. It is for a 10 room facility, and it's purpose is to show projected revenue based on room type, employee job type, and schedule. The current spreadsheet has 10 rooms with two room types. Also there are 11employees with 6 job types. Your task will be to change the current spreadsheet to 40 rooms, 3 room types. and 22 employees with 12 job types. Changes to be made to Revenue Targets Page, Column A -I want to be able to select room type from a dropdown menu, and input the revenue for different room types on the Revenue Target page. Room types are Private Room, Shared Room, Shared Medicaid. Employees Page, Column A -I want to select employee job type from a dropdown menu for ea...
I am in need of an efficient professional who can convert my mixed content PDF document into a Word document, while retaining the same format and layout as present in the original document. The PDF primarily contains text content only, so expertise in handling complex content like mathematical equations, charts or tables is not a requirement. The ideal freelancer for this job should: - Be proficient in PDF and Word processing tools - Have strong attention to detail to ensure layout fidelity - Have experience in similar document conversion tasks
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed...
I'm looking for a skilled Excel expert to automate the formatting of a spreadsheet from a Quickbooks export. Key Requirements: - I primarily need the freelancer to set up and automate formatting in my Quickbooks Excel spreadsheets. - The final formatting should be both visually appealing and easy to read for the end user, we will provide guidance on what the end result should look similar to. Ideal Skills and Experience: - Strong proficiency in Excel, especially with automating processes and conditional formatting. - Previous experience working on projects involving data visualization and presentation. - A good eye for design to ensure the data is clearly differentiated and visually engaging.
I have a project that involves data entry from an Excel file. The data needs cleaning and formatting before entry, and the end goal is data analysis. I am looking for a freelancer who can help me with the following: - Excel Data Entry: Transfer data from an Excel file into a designated system. - Data Cleaning & Formatting: Ensure the data is cleaned and formatted correctly before entry. - Data Analysis: Help in structuring the information in a way that facilitates analysis. Ideal skills for this project include experience in data entry, Excel, and data analysis. Looking for a reliable and detail-oriented freelancer to complete this task efficiently.
I'm looking for a Google Sheets expert to help with the following tasks: - Implementing formulas for summing and averaging data - Applying conditional logic for data analysis - Setting up conditional formatting for better data visualization - Creating data validation rules for accurate data input - Designing custom charts and graphs for enhanced data representation. The ideal candidate for this project should have a strong background in Google Sheets and data analytics. Experience with complex formula implementation and data visualization is a plus. Being detail-oriented is crucial, as accurate data handling is a key aspect of this project.
I require an experienced data cleaning specialist who can proficiently handle Excel spreadsheets. My project involves tidying up datasets related to customer, product, and financial data, though different types of data might need to be scrubbed too. This data cleansing task involves a lower volume dataset of less than 1,000 records. Key tasks include: - Identifying and correcting any inaccuracies. - Identifying and handling missing data. - Assuring the consistency of datasets. The ideal freelancer should have strong skills in spreadsheet management, a keen attention to detail, exceptional data analysis abilities, and a solid understanding of customer, product, and financial data. Experience in Excel and a proven track record in data cleansing are a must.
We have three separate infographics that we need created. Day to Day Operations, Day to Day Operations with a TPA, and Contracting Enrollment. You will find each of these charts in the files. Ware looking to improve this very simple, infographic. Attached is also the logo we have as well as some inspiration for color/font/etc. We want the infographic to have great color, and flow, using real word images/stock photos or cleverly related icons for each step. We want this to wow our potential customers. Note, the bubbles contain a lot of text. If it makes sense to use single words then a feature list below each bubble we are fine with that (see example). Please see project files and ask any clarifying questions. Thank you
I am looking for a detail-oriented professional to assist me with basic data entry tasks in Excel. The primary responsibility will be to input data such as names and addresses into an Excel spreadsheet. Key Responsibilities: - Inputting basic data into Excel spreadsheet Furthermore, the project requires data verification. This means ensuring that the data has been accurately entered. You will be required to cross-reference the inputted data against the source material to detect any discrepancies or errors. Ideal Skills & Experience: - Proficient in Excel - Attention to detail - Strong data entry skills - Familiar with data verification processes - Previous experience in basic data entry This project is quite straightforward, but precision and accuracy ...
I'm looking for a skilled professional to assist me with various customer support, operation, and mana...manage customer inquiries through phone calls, email, and live chat. - Managing Customer Databases: This project requires proficiency in maintaining databases across various platforms including CRM systems, Excel spreadsheets, and online database platforms. - Analyzing Customer Feedback: An ideal candidate will have experience in analyzing customer feedback to help our services grow. The ideal freelancer for this project should possess: - Proven experience in customer support and management - Excellent communication and interpersonal skills - Proficiency in using various CRM systems, Excel, and online database platforms - Familiarity with analyzing customer feedbac...
Some charts I'm trading get rugged by some scammers that mint new tokens and sell them in the same block using a jito bundle. I need a solution that given a target token CA, to whenever new mints of that token are detected, before they even get confirmed as the dump happen in the same block to place a jito bundle of my own with a higher tip to liquidate my position before the ruggers transactions.
I need an expert in PowerPoint to assist with some key tasks: - Designing eye-catching and effective slides. - Creating engaging animations that drive home key points. - Formatting text to make it accessible and engaging. The purpose of this PowerPoint presentation is for a business presentation, so a more formal tone is necessary. I envision the style to be data-heavy with lots of graphs and charts, so the ideal candidate should be experienced in presenting complex data in a clear and easy to understand way. Experience with similar business presentations would be beneficial. Slides are regarding Consumer Privacy Act (CPA), The General Data Protection Regulation (GDPR) & Children's Online Privacy Protection Act (COPPA)
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
I need emails from these companies of CEO ot anyone else working in financials, sales, or partnerships. Data scraping from rocketreach of the emails of the people that you can find with relevance from these companies in the image. Excel sheet with company name in the rows and in the 3 columns full name, email and position in the company
Data entry operator and my work very clear
I'm looking for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. Please include samples of similar work you've done ...
...clear, straightforward manner to accentuate the important points and make it easy for the audience to follow from one point to another. Please import icons or logos to improve the presentation. Leave spaces where you think it would help to have my photo or other content. - Formatting: The text, graphs, and flow charts appear messy. I need them to be formatted in a formal, professional style which enhances readability and ensures consistency throughout the presentation. The flow charts in there are basic - please improve to make them look better. Ideal candidates should possess strong skills in PowerPoint design, as well as a creative eye for graphic design and typography. You should be able to take the content we have and turn it into a visually engaging, professional pr...
I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.
Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-friendly or ...
Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!
Website on Wordpress License key generator with DB API for Excel Template connecting to DB for license key validation. Dashboard for administrator enter buyer/customer account credetials. The administrator must be able to enable and disablle accounts. Update Excel Template LicenseValidation code for connectiing to API/DB. I will privide this Excel Template code file.
...item availability. 4. Delivery Tracking - Allowing customers to check their food order status. 5. Nutrition Coaching Reservation - Capability for customers to reserve sessions with a dietitian. 6. Customized Ordering - Feature that facilitates personalized orders based on customer needs of calories and macronutrients (the system will customize the meals according to user inputs of calories and macros). 7. Blog Integration - To serve engaging, relevant, and up-to-date content to our users. 8. Calculators for calories and macronutrients. 9. using geolocation to locate the customer's location. 10. multilanguage (arabic, english, kurdish) 11. PWA app of the website. 12. User Authentication: A secure logging system for users. 13. Payment Integration: A stable and secure mechanism...
This project requires an expert in P...The data source for this project will be SharePoint, so advanced experience handling and processing data from SharePoint is a must. Key requirements and responsibilities include: - Design and implement charts and graphs for relevant and accurate data representation. - Ensure data visualizations are simplistic yet detailed to engage targeted audience. - Streamline and manage data from SharePoint effectively. - Problem-solving with agility based on data-driven evidence. Skills and experience necessary: - Extensive knowledge in Power BI and SharePoint. - Proven experience designing charts and graphs. - Demonstrated ability to translate data into compelling visual narratives. This is a ongoing project... only experienced Power BI free...
I need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project is changing the color of cel...
I'm looking for an experienced Excel and PineScript expert to create custom Excel formulas replicating my developed PineScript indicator. The indicator performs functions for Bollingerbands and Keltner Channels. The task will be to incorporate Open, High, Low, Close prices into the Excel formulas. Please note, data collection or data visualization is not required for this project. To give your best, you should possess an advanced understanding in: - PineScript - Creating complex Excel formulas Looking forward to your informed bid.
I'm looking for an experienced developer who can create a high-quality app...create a high-quality app for both Android and iOS platforms. This app offers a comprehensive view of fresh statistical data updated weekly, which has been designed in Figma and now needs to be brought to life. Key Features: - Display of updated statistical data - Interactive charts for an engaging look at the statistics Ideal Freelancer: - Proficient in both Android and iOS development - Experience in translating Figma designs into working apps - Familiarity with data visualization, particularly interactive charts This is not just about coding an app; I need someone who can intelligently implement the design details and make the statistical data immersive and interesting. Let's create...
I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer information and product inventory management Ple...
...fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all accessible information per entry is needed. Your expertise in internet research, data mining, and...
I am seeking a t...numbers for promoting my business. Key Features: - Bulk Phone Number Verification: The tool should be able to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number verification tools will be a plus. Please provide examples of similar projects you have worked on previously. Looking forward to y...
I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.
I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided
Work on SDTMs, ADaMs and TLF for various projects. To be able to work on standard macros. STDMs and ADaMs specs writing
For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.
I'm in need of a chart that can visualize real-time data on a web application. The chart should exhibit a scrolling behavior that's ...like this. Key Requirements: - The chart should be developed specifically for a web application - It must update every second to reflect the real-time nature of the data being visualized - The scrolling effect should be smooth and engaging, similar to the movement of a snake in a game Ideal Skills and Experience: - Proficiency in web development, particularly in creating complex, interactive charts - Experience with real-time data visualization - Knowledge of animation techniques and their implementation in web applications - A creative approach to user experience and interface design Please provide examples of similar projects you'...
...our Point of Sale (POS) system, and warehouse stock counts. Key responsibilities: - Regularly updating our inventory data with utmost accuracy - Ensuring all channels of data (supplier invoices, POS system, stock counts) are accurately reflected in our inventory records - Generating purchase orders based on the updated stock levels Your skills and experience should include: - Proficiency in Excel/ Google Sheets - Experience in inventory management/data entry - Attention to detail and accuracy - Ability to work independently and meet daily deadlines - Familiarity with purchase order generation is a plus. A successful candidate will not only update the inventory data accurately and promptly but will also be able to adapt to any changes in stock levels in real-time, ensuring ou...
I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data s...
I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.
I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more
... The information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain d...
I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.
Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would greatly appreciate it if you co...
I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.
I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.
I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a timely fashion.
I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.