Excel vba accounting jobs jobs
I need a dashboard that visualizes and organizes the errors found in the List 1 and List 2 tabs of my Excel file. The goal is to track missing or blank cells within the data. The dashboard should include charts and graphs to clearly display the error data. Additionally, it should feature a mini database section with filters, showcasing the missing data headers and cell references for quick identification and navigation.
I'm looking for an expert in Tableau, specifically for creating interactive dashboards. The data will primarily come from Excel/CSV files, so proficiency with these sources is essential. Ideal Skills: - Extensive experience with Tableau - Proficient in working with Excel/CSV files - Ability to design interactive charts and graphs The dashboard should feature interactive charts and graphs. I'm not looking for a static, one-dimensional dashboard; I need something that can engage users and allow them to explore the data on their own. If you have a proven track record of creating such dashboards and can deliver a high-quality, user-friendly product, I would love to hear from you. My cost is 10USD
I'm looking for a local MS Excel tutor for my 11th grader. The focus will be on data visualization (charts and graphs) as well as data analysis (using pivot tables and filtering). Key Requirements: - Excel proficiency, specifically in data visualization and analysis - Experience with tutoring high school students - Flexible for both in-person and online sessions - Available for once-a-week sessions Ideal Skills: - MS Excel expertise - Teaching experience - Good communication skills - Patience and understanding - Ability to make learning enjoyable
We are seeking a skilled freelancer to help transfer and configure macros from one computer to another. The macros are fully operational on the original machine, and we need assistance ensuring they work seamlessly on the new setup. Ideal skills and experience for the job include: - Proficiency in Excel, specifically with macro creation and implementation. - Experience with data manipulation, report generation and task automation. - Ability to troubleshoot and optimize existing macros for efficiency.
...emphasis on innovation and functionality. --- Project Scope: Deliverables: 10 3D STL Design files: 1. Box or rectangular-shaped moulds: 5 designs. 2. Cylindrical, oval, or spherical-shaped moulds: 5 designs (using innovative "staving" techniques, similar to how wine barrels are constructed, to achieve the rounded shape). - The STL models must: - Be optimized for CNC woodcutting, accounting for machine limitations. - Provide precise instructions for cutting wood into shapes that assemble into enclosed moulds for casting. - Ensure moulds are leak-proof and deliver a smooth, high-quality finish. - Bonus Feature: Integration of self-watering or other innovative functionalities in the mould design, where feasible. --- Key Challenges: - Desig...
I need assistance converting text and numbers from an unstructured PDF into an MS Excel spreadsheet. Key Requirements: - Convert text and numbers from PDF to Excel - Data is unstructured, so adaptability is key - High level of accuracy required, with manual verification Ideal Skills and Experience: - Data entry experience - Proficient in MS Excel - Detail-oriented - Able to manually verify data for high accuracy
I'm seeking a skilled data entry professional with experience in data clean...The job will primarily involve cleaning mixed data (text and numbers) sourced from our database. Key Responsibilities: - Identify and rectify inconsistencies within the data - Ensure data integrity and accuracy - Prepare cleaned data for further analysis Ideal Skills: - Proficiency in data cleaning techniques - Experience working with mixed data types - Familiarity with database navigation and Excel/CSV files - Attention to detail and strong problem-solving skills Experience Requirement: Prior experience in data cleaning and verification, particularly with mixed data from a database, is highly desirable. Understanding of common data issues and how to resolve them quickly will be key to your succes...
Requirement for Formatting Output Using Microsoft Copilot in Word or Excel We are using Microsoft Copilot in Word and Excel, where we provide a document with a specific format as input. When we give prompts, such as "Create a new website" or "Suggest a laptop for purchase," Copilot generates content correctly based on the prompt. However, the output does not retain the same format as the input document. Our requirement is that the output should match the exact format of the input document, including colors, fonts, bold, italic, and other formatting. Currently, we must make additional adjustments to achieve the desired format, which is time-consuming. We discussed this with Microsoft, and they suggested that we could add agents to address this issue. We ...
I need a professional who can help me consolidate numbers from an existing Excel file and distribute targets based on specific priorities. Key Tasks: - Data consolidation from the provided Excel file - Distribution of targets with a focus on specific categories Ideal Skills: - Proficiency in Excel - Experience in data analysis - Ability to follow precise instructions and prioritize tasks accordingly Please note, the rules for data consolidation have not yet been determined and will need to be discussed.
I'm looking for a proficient Data Analyst to assist with generating reports based on our sales data. Key Responsibilities: - Analyze sales data to create comprehensive reports Ideal Skills: - Proficiency in Excel is a must - Previous experience with sales data is preferred - Strong analytical skills - Excellent report writing abilities
I need a freelancer to convert 49 pages of a PDF file into an Excel sheet. The PDF contains mixed data - both text and numeric information. Key Requirements: - Experience with data entry and Excel - Ability to understand and implement custom formatting - Attention to detail to ensure accuracy The Excel sheet needs to be formatted according to specific, custom requirements. This may involve detailed cell formatting, such as merged cells and specific alignments. Please note that this project does not require maintaining the original PDF formatting, but rather creating a unique, custom layout in Excel. Ideal candidates should have strong Excel skills, experience with custom formatting, and a meticulous approach to ensuring data accuracy.
extract data from web ejar SA, and put it into excel sheet
I need an application for Breast Cancer Patients In The Radiology Department, where they undergo eight different tests. I want the pateint information the has been inter be able to save then in excel The program should help schedule these tests based on the following basic information: • Patient name • Patient age • Patient file number • Referral date to mammogram • Treating doctor’s name • Patient’s phone number • Treating doctor’s email • A field from which I can send an email from my personal email The first procedure is the mammogram date. The mammogram should be scheduled within 48 hours from the referral date, taking into consideration that the appointment should fall between Sunday and Thursday. The result field is ...
I'm looking for a skilled Excel expert or data analyst to create a dynamic Excel sheet for me. This sheet should generate random pairings between individuals, taking into account specific conditions (cannot be from the same cohort year and cannot be repeat matches). Key Project Details: - Number of Individuals: Between 50 and 100 - Pairing Frequency: 3 times a year - Information to Include: - Cohort year - Full name - Email address - Previous matches Ideal Skills and Experience: - Advanced Excel skills - Data analysis experience - Understanding of creating dynamic and interactive spreadsheets - Prior experience with similar projects will be an advantage. This project will help to facilitate interactions between individuals in a controlled and fai...
Prepare a template for Depreciation and Asset Listing Control to standardize the management, recording, and monitoring of depreciation and asset values, ensuring compliance with accounting standards, maintaining accurate financial records, and facilitating decision-making. (In Excell)
I need a skilled professional to assist with my bookkeeping and sales tax preparation. Specific Tasks: - Bookkeeping: I'm looking for someone to manage my day-to-day financial t...Specific Tasks: - Bookkeeping: I'm looking for someone to manage my day-to-day financial transactions and to record them accurately in my books. - Payroll Processing: This includes managing employee compensation, tax deductions, and other payroll related tasks. - Sales Tax Preparation: I need assistance with preparing and filing my sales tax returns. Ideal Candidate: - Has a strong background in accounting and bookkeeping. - Experienced in payroll processing. - Knowledgeable in sales tax preparation and compliance. - Detail-oriented and able to maintain a high level of accuracy. - Excellent or...
...information (e.g., social media links, addresses). • Ensure data accuracy and relevancy. Qualifications: • Proven experience in market research or business consultancy in UAE • Familiarity with African business networks or diaspora communities, especially in UAE. • Strong organizational and analytical skills. Deliverables: • A comprehensive and well-organized directory in an editable format (e.g., Excel, Google Sheets). • A short summary report of the research process and insights gained during the project. Additional Information: • Preference will be given to candidates familiar with Dubai’s African community or with access to existing networks. • Please include examples of previous relevant projects or research in your proposal. ...
I'm in need of a recruitment agency that can assist in the mass hiring of mid-level professionals primarily in the Information Technology, Healthcare, and Sales sectors. Key Responsibilities: - Posting jobs in valid and verified indeed accounts for US. - Streamline the hiring process to improve efficiency -Candidate database creation Challenges: - The primary obstacle I'm facing is the difficulty in finding qualified candidates with valid Indeed Employer Accounts Ideal Skills: - Extensive network and resources in the Information Technology, Healthcare, and Sales industries - Proven track record in sourcing mid-level professionals - Ability to understand and meet specific role qualifications and organizational needs
I want to know the address OR pin of every residence or hotel or public facility in Georgetown GUYANA with a domestic swimming pool for pool surfing plies sales purposes
I'm seeking an expert in Odoo ERP implementation, specifically for the Sales, Inventory, and Accounting modules. Key Responsibilities: - Implement Odoo ERP with a focus on Sales, Inventory, and Accounting modules. - Extensively customize these modules to suit our specific business needs. Ideal Skills and Experience: - Proven experience in Odoo ERP implementation. - Deep understanding and experience with Sales, Inventory, and Accounting modules in Odoo. - Strong skills in customizing Odoo modules. - Excellent problem-solving skills and attention to detail.
I'm seeking a professional with expertise in Tally for comprehensive accounting and bookkeeping services. Your role will include managing all financial records - income and expenses, invoices and receipts, and bank statements. Key Responsibilities: - Complete accounting & bookkeeping services - Monthly GST filing - Using Tally software exclusively Ideal candidates should have prior experience with Tally and GST filing in India.
I'm in need of a proficient Excel expert who can develop a macros solution for me. This will primarily be used for automating data formatting and report generation tasks in Excel. Key Requirements: - Expertise in Excel macros - Ability to automate data formatting tasks - Experience in creating macros for report generation - Proficient in handling Excel files The ideal freelancer for this project should have a deep understanding of Excel and experience in creating and implementing macros. The goal is to streamline my workflow and make data handling more efficient.
I'm looking for a professional with advanced Excel or macros experience and a deep understanding of Shopify, to automate the upload of various data into custom metafields on my Shopify products. The data to be uploaded includes: - Text descriptions - Numeric values This is a project requiring the successful freelancer to upload the data to the custom metafields only once. There's no need for this automation to integrate with any other systems or third-party applications; the task is solely focused on Shopify and our excel. Ideal Skills and Experience: - Extensive experience with Shopify - Advanced level Excel skills - Proficient in macros - Experience in data management and automation - Data Entry
We are looking for a development partner to build a Guard Tour Tracking App with the following key features: Real-Time GPS Tracking: The app should enable security personnel to be tracked in real-time. Checkpoint Scanning & Task Logging: Each checkpoint should have designated tasks that guards ca...checkpoints), with easy querying for audits and reports. Trailer Check-In & Out: A system to manage trailer entries and exits, including regular temperature readings every 2 hours. Rearranging Trailer Order: Ability to sort trailers by yard location and quickly locate trailers by number. We also plan to expand this system in the future to include features such as scheduling, time clock, HR, invoicing, accounting functionalities, Updated website, and more. Please send a message ...
...at trade shows happening in the Dubai World Trade Center, specifically focusing on the Food and Beverage sector. Gulfood 2025 Dubai International Boat Show 2025 worldofcoffeedubai 2025 go on abaove website click EXHIBITOR LIST Key Deliverables: - An Excel spreadsheet containing the following fields: - Company names - Contact persons - Company addresses - Email and WhatsApp numbers of owners - Locations - Sector - Manual verification of the authenticity of the collected data. Ideal Skills and Experience: - Proficiency in Excel - Experience in lead generation - Strong attention to detail for manual verification tasks. To get awarded for this project, you need to extract at least 100 emails from a single website mentioned in the examples. Please note, I am...
I have over 10 Excel files containing customer contact details that need to be consolidated into a PostgreSQL database. The good news is that all these files have a consistent format, which should make the task easier. Key Requirements: - Expertise in PostgreSQL - Proficient in Excel - Experience with data consolidation - removing duplications Please ensure to deliver a clean, organized database that accurately reflects the data from the Excel files.
...Work: You will receive a names of few companies + 1 link containing lists of other companies. For each company, gather the following information (where available): Company Name Key People (CEO, Founder, Marketing Head, Sales Head, or equivalent) Job Titles Contact Details (email addresses, phone numbers) LinkedIn Profile URLs (if available) Organize the data into a structured Google Sheet or Excel file. Requirements: - Experience in data scraping, web research, or lead generation. - Attention to detail and accuracy in collecting and entering data. - Ability to use professional tools like LinkedIn, email finders, or other research methods to locate information. - Familiarity with verifying email addresses to ensure they are active and bounce-free....
I'm looking for a professional with advanced Excel or macros experience and a deep understanding of Shopify, to automate the upload of various data into custom metafields on my Shopify products. The data to be uploaded includes: - Text descriptions - Numeric values This is a project requiring the successful freelancer to upload the data to the custom metafields only once. There's no need for this automation to integrate with any other systems or third-party applications; the task is solely focused on Shopify and our excel. Ideal Skills and Experience: - Extensive experience with Shopify - Advanced level Excel skills - Proficient in macros - Experience in data management and automation - Data Entry
I'm looking for someone to create several spreadsheets that display various financial metrics related to shipments of multiple grades across different countries. The sheets should track specific details for each shipment and highlight key insights. Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong understanding of financial data - Ability to visualize data clearly and concisely Specific Requirements: - Track shipment dates - Monitor product grades - Keep a record of destination countries - Provide an overview of which grade has moved the maximum - Include quantities and other relevant data - Need charts and graphs to represent the data as well - Pivot tables and more. These spreadsheets will be instrumental in helping me understand the financia...
I am seeking an Excel expert with extensive experience in spreadsheet automation. The ideal candidate will help me automate the following tasks: - Data entry - Generating reports - Data cleaning The Excel spreadsheet will need to interact with a database. Therefore, experience with database interactions in Excel is crucial. Skills and experience needed: - Advanced Excel knowledge - Expertise in spreadsheet automation - Proficiency in data manipulation and cleaning - Experience with generating reports in Excel - Familiarity with database interactions in Excel Please provide examples of similar projects you've completed in your bid. Thank you.
I have the script but it seems to have some bugs. I need you to fix it in 2-3 hours (first phase which I will explain , there is matching for which you can take some time). If you are experienced then only propose. I have a subscription to a website. I will provide set of data in excel (I need a python script, so that I can use whenever I have new data) and need few data to be extracted from that website based on several conditions and need all the required fields to be filled in excel. And need output in excel file. I need anyone who can complete real quick. Budget 8 usd
I am in need of a comprehensive Excel dashboard for the IPL seasons spanning from 2008 to 2024. The dashboard should effectively track and display: - Player performance - Match results - Team standings The dashboard should primarily feature: - Graphs/Charts - Tables These visual elements will assist in presenting the data in an engaging and easily digestible format. The data should be updated on a monthly basis. Ideal candidates for this project should have: - Advanced Excel skills, particularly in creating dashboards - A strong understanding of cricket, specifically the IPL - Experience in data visualization - Ability to manage and update data on a regular basis
I'm looking for an Excel expert who can help me create basic arithmetic formulas to assist with financial calculations. Ideal Skills: - Proficiency in Excel - Experience with financial calculations using Excel - Ability to create basic arithmetic formulas
I have a project that requires meticulous input of numerical data into Excel. The task will involve not only data entry but also ensuring that the data is validated and formatted according to specific guidelines. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience in data entry and validation Key Requirements: - Input of numerical data - Use of Excel for data input - Ensuring data validation - Following specific formatting guidelines in Excel
...Categories Page Industry Options: • Healthcare • Trades (e.g., electricians, plumbers) • Engineering • Shop Workers • Landscaping • Construction • Cleaning Services • Finance • Technology • Hospitality Description: • Each category features a brief description of typical roles, sponsorship opportunities, and participating companies. Search Functionality: • Search bar to find specific jobs or sponsorship opportunities. 4. Immigration Attorney Services • Hire an Immigration Attorney • Banner: “Need legal help? Don’t navigate the immigration process alone.” • Button: “Get Connected to an Immigration Attorney.” • Directory: • List of vetted immigratio...
I'm seeking a diligent data entry expert to assist with transferring information from an online database into MS Excel. Key Requirements: - Proficient in MS Excel; familiarity with data manipulation tools within Excel is a plus. - Attention to detail to ensure accuracy of data entry. - Ability to work independently and manage time efficiently. - Prior experience with data entry from online databases preferred. Please note, the data type is mixed (both numeric and textual), so a good command over both types is essential.
I need a solution for transferring text from Word to Excel and vice versa. The templates I work with change frequently, so I require a fully automated system to handle the conversions. Ideal Skills: - Proficient in Microsoft Word and Excel - Experienced in creating automated systems - Able to handle frequent template changes Your task will be to create a system that can seamlessly manage this process, freeing up my time for other tasks.
...than 10 pages that needs to be transformed into an Excel sheet with specific modifications. Please upload the PDF to the project page. The Excel should include the following: Existing Columns: 1. “proc date” - copied as is 2. “description” - only include full names of items starting with “D” (example: D0150 Comp oral eval-new/estab pat) 3. “Prov” - change all entries to Dr. Cleopatra Lakota 4. “Phone” - change all entries to 908-751-7038 New Columns to Add: 1. “Address of the Facility” - for all entries, use 276 US-202 #109, Flemington, NJ 08822 2. “Ages of the patients” - include random numbers between 12-89, with some repetitions in a row going down the column 3. “Facility Name&r...
I'm seeking a web designer to modernize the design aesthetics of my existing website and update the logo. Key tasks include: - Revamping the layout to a clean, minimalist style with improved typography using sans-serif fonts. - Simplifying the menu for easier access to key sections such as "Jobs" and "Resources". - Creating a visual hierarchy with larger headings and clear subheadings. - Modernizing the color palette and incorporating high-quality images and icons to break up text. - Ensuring the site is fully responsive and optimized for mobile. - Ideally, a QR code will be generated for easy site access. The ideal freelancer for this job should have: - Extensive experience in web design with a focus on modern, minimalist aesthetics. - Strong understandi...
I'm looking for an Excel expert who can help me with applying logical functions (IF, AND, OR, etc.) primarily for data validation across multiple ranges. Key tasks: - Assisting in the use of logical functions for data validation - Implementing these across multiple ranges Ideal skills and experience: - Proficient in Excel, particularly in logical functions - Experience with data validation in Excel - Able to apply skills across multiple ranges
I'm seeking assistance with my Power Automate system. Currently, I am performing data entry from a single sheet Excel file into a web platform, specifically filling in text fields. I've encountered some hurdles while trying to automate this process. Ideal skills and experience for this job include: - Proficiency in Power Automate - Experience in automating web data entry - Familiarity with Excel, particularly with single sheet data organization Your expertise could save me a lot of time and frustration. Looking forward to your bids.
create some dashboard heat maps and other items to show repairs on propertyies by different job types and appliances I want someone to create me a dashboard where the user can select from a drop down the heat map type and they heat map displays the data ie if the user selects jobs as the filter it should show map of certain area and then show heat maps of jobs that have been done in a certain area if the user selects job type as the filter it should show map of certain area and then show heat maps of job type that have been done in a certain area ie plumbing if the user selects Asset as the filter it should show map of certain area and then show heat maps of asset that have failed in a certain area ie plumbing This needs to be basic and needs to be of a certain area i...
I'm seeking an expert in Excel to create a comprehensive dashboard that focuses on project management. The primary use of this dashboard is to monitor resource allocation, specifically equipment, for various tasks within a project. Ideal Skills and Experience: - Proficient in advanced Excel functions and features - Experience in project management - Understanding of resource allocation and tracking - Ability to create user-friendly and visually appealing dashboards
I'm looking for a professional to improve the user interface of an Excel-based governance document. This document is used to track initiatives and actions from a strategic plan. Key Focus Areas: - Navigation and layout: The document needs to be more intuitive and user-friendly. - Form input and validation: Streamlining the process of data entry and ensuring accuracy is crucial. - Color scheme and styling: Aesthetic improvements are needed to make the document visually appealing. No specific design guidelines are in place, so creativity and adherence to general best practices will be appreciated. Ideal candidates should have a strong background in UI design, particularly in Excel, and be able to deliver a document that balances functionality with an enhanced user experi...
I'm in need of a custom Excel worksheet for tracking business card orders. The worksheet has specific requirements and needs to be completed today. Please see the details below. - The worksheet needs to be separated by name, title, address, phone, fax, cell and email address, and quantity. - The first sheet should be named 'AIM', the second 'CC', the third 'TT', and the fourth 'ACT'. - I will provide the names, but you need to format the Excel sheet according to these specifications. - The quantities for each type of business card should be recorded in separate columns. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to work under tight deadlines.
I'm seeking a professional who can integrate all aspects of my small business into Shopify. Currently, we sell both wholesale and retail, with our wholesale transactions on Shopify, our website on Squarespace, and our POS and accounting on Quickbooks. This project requires: - Comprehensive migration to Shopify - Integration of both wholesale and retail transactions - Incorporation of product catalog management, customer accounts, and inventory management features - Seamless integration with Quickbooks Ideal candidates should have extensive experience with Shopify, Quickbooks, and eCommerce integration. A deep understanding of both physical and digital product management is essential. Please share your relevant experience and proposed approach to this project in your bid.
I'm seeking a professional to scrape my WordPress website for 1100 entries related to our different offices. The data needs to be exported into an Excel file, without any specific filters or sorting. In addition to data scraping, I need a thorough code review of my WordPress site. This should encompass: - Documentation and review of custom code - Optimization where necessary - Plugin review for updates - Recommendations for optimization This project requires a deep understanding of PHP, as well as experience with WordPress and data scraping. The ideal freelancer will have a strong background in website code review and optimization.
We have a python app that uses GPT API running on a local machine using local GPUs. The front end is single screen PyQT5. We now need to scale this to a web service running on , converting the PyQT5 UI to Gradio for the UI/orchestration layer so we can run batches on multiple instances and easily scale GPU and CPU resourc...files. Analyzed content is based in the biosciences area and in future phase we'll be adding functionality to analyze bio-sequences using Blast (supported on ). Experienced developer will already know: Modal enables: Full serverless execution Define container environments Attach GPUs with a single line of code. Serve functions as web endpoints. Deploy and monitor persistent scheduled jobs. Modal requires zero configuration- everything is code (no YAML)
I am seeking to hire an excellent Compliance and Administrative member to join my team. Skills Required: * Confident on the phone * Speaks & communicates clearly by phone * Excellent written communication skills * Proficient in Microsoft Excel, Word and Power Point * Can multi-task and complete projects on time * Must be able to learn on the go and figure out solutions to problems * Is an excellent self-learner * Finish projects in a timely manner, doesn't procrastinate * Proficient with Adobe Acrobat in creating forms and documents * Proficient with DocuSign. Understand how to send out documents for signature * Excellent with follow-up. If you promise something to a client or team member follow-through * Understand how to use DropBox and grant/deny access to users * Excel...
