Vba excel spreadsheet work jobs
...records and documentation. Assist with payroll processing and reporting. Liaise with external auditors, tax advisors, and financial institutions as needed. Qualifications: Bachelor’s degree in Accounting, Finance, or a related field (preferred). Proven experience as an accountant, bookkeeper, or in a similar financial role. Proficiency in accounting software (e.g., QuickBooks, Xero) and Microsoft Excel. Strong understanding of accounting principles, practices, and regulations. Excellent organizational, analytical, and problem-solving skills. High level of accuracy and attention to detail. Strong written and verbal communication skills....
Online New freelancer, Junior Level. I need a junior level freelancer who can assist me with custom PHP work. This could involve bug fixing, adding new features, and improving existing code. Ideal candidate should have: - Proficient in Core PHP
I'm looking for a professional who can create a comprehensive spreadsheet for my locksmith business, focusing on financial tracking. The primary purpose of this spreadsheet will be to monitor weekly pay, monthly expenses, and year-to-date totals. Key Requirements: - The spreadsheet should be user-friendly and able to provide rolling totals. - Depending on the final design, the spreadsheet may need to generate reports automatically, so a versatile approach is preferred. - It should be able to accommodate both manual input and potential future automation. Ideal Skills: - Proficiency in Microsoft Excel or Google Sheets. - Experience with financial tracking and report generation. - Previous work with small business or service industry spreadshee...
Currently the shipping plugin functions on PHP 5.6, but does not function on 7.4 PHP, and the current version of WooCommerce. The shipping plugin connects to a single API and pulls a list of possible shipping options. The updated version of the plugin needs to be compatible with the latest version of WooCommerce and PHP 8.3. Happy to answer any questions, and to provide access to a demo s...functions on PHP 5.6, but does not function on 7.4 PHP, and the current version of WooCommerce. The shipping plugin connects to a single API and pulls a list of possible shipping options. The updated version of the plugin needs to be compatible with the latest version of WooCommerce and PHP 8.3. Happy to answer any questions, and to provide access to a demo site to test prior to accepting the wor...
I'm in need of a skilled Excel professional for data analysis. I have a dataset ready for analysis. Please note that the specific type of analysis hasn't been predetermined, so flexibility and expertise in various types of data analysis will be beneficial. Ideal Skills and Experience: - Proficient in Excel - Strong data analysis skills - Experience with various types of data analysis - Able to deliver insightful interpretations of the data
I'm looking for an expert in spreadsheet development to build a custom Excel sheet for tracking progress claims on construction projects. Key Features: - Automatic calculations: The sheet should be able to compute totals, subtotals, and other necessary financial figures without requiring manual input. - Customizable templates: The spreadsheet should be template-based, allowing for easy customization to suit different projects. Ideal Skills: - Proficiency in Excel with a strong understanding of its advanced features (formulas, pivot tables, macros etc.) - Experience in construction project financial tracking would be a significant advantage. - Ability to create user-friendly, customizable templates. - The data in the current pdf spreadsheet does not...
Complete SEO work including On-site, Off-site and technical analysis.
I have a project that involves typing up content from PDF files. These PDFs primarily contain text documents, and the main purpose of this typing task is to enable editing of the text. The final deliverable needs to be in the format of a Word document. Ideal skills and experience for the job include: - Proficiency in typing - Excellent command of the English language - Experience with Microsoft Word - Attention to detail - Ability to meet deadlines
...out. Those are not correct. I will randomly pick some data and call them to verify the quality of your data collection. 5) No duplicate contact is allowed. Daily update is required. Finding the URL, writing script or using any other form of tools, platform, VPN, are your responsibilities. I will NOT provide anything. 6) Populate the Excel sheet, remove duplicate, clean it up with proper column formatting for easy readability purpose, post link to the populated Excel sheet. Do not send me junk or screen shot. I do not want to see email in phone column or vice versa. Email is the most important field. a) Milestone 1- Deliverable: 131,050 rows - - DFW-USA: From the 22 US Universities listed, collect 50 professors / Instructors and 1,000 students (BS, MS, and Ph.D.) contac...
I'm looking for an expert in spreadsheet development to build a custom Excel sheet for tracking progress claims on construction projects. Key Features: - Automatic calculations: The sheet should be able to compute totals, subtotals, and other necessary financial figures without requiring manual input. - Customizable templates: The spreadsheet should be template-based, allowing for easy customization to suit different projects. Ideal Skills: - Proficiency in Excel with a strong understanding of its advanced features (formulas, pivot tables, macros etc.) - Experience in construction project financial tracking would be a significant advantage. - Ability to create user-friendly, customizable templates. - The data in the current pdf spreadsheet does not...
I have ongoing work related to our previous project 'Al Ittihad Football Club Mobile Case Design'
...out. Those are not correct. I will randomly pick some data and call them to verify the quality of your data collection. 5) No duplicate contact is allowed. Daily update is required. Finding the URL, writing script or using any other form of tools, platform, VPN, are your responsibilities. I will NOT provide anything. 6) Populate the Excel sheet, remove duplicate, clean it up with proper column formatting for easy readability purpose, post link to the populated Excel sheet. Do not send me junk or screen shot. I do not want to see email in phone column or vice versa. Email is the most important field. a) Milestone 1- Deliverable: 131,050 rows - - DFW-USA: From the 22 US Universities listed, collect 50 professors / Instructors and 1,000 students (BS, MS, and Ph.D.) contac...
...of an Excel-Based Budgeting and Monitoring Tool for Construction Projects (WBS-Based) Description: We are seeking an experienced freelancer to create a budgeting and monitoring tool for construction projects, designed exclusively in Microsoft Excel. The tool must be based on a Work Breakdown Structure (WBS) and include task and activity management, rather than focusing solely on resources. Required Skills: • Expertise in project management (ideally with a PMP certification or equivalent). • Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, macros, and VBA. • Experience in developing Excel-based tools for complex projects. • Understanding of construction projects and their unique requireme...
I'm looking for someone to help with a work-from-home data entry project. This involves working with visual data, specifically videos. Key Responsibilities: - Tagging and categorizing video content based on provided guidelines. Ideal Skills: - Attention to detail: The role requires precise tagging and categorization. - Familiarity with data entry: Previous experience with data entry jobs is a plus. - Good communication skills: Ability to understand and follow instructions clearly. Please note: This is a remote position and you will need a reliable internet connection to watch and categorize the videos.
I need to find and compile contact information for 382 Conveyancing Solicitors and 313 Probate Solicitors within 25 miles of MK45 1AH. Requirements: - Data scraping expertise - Excel proficiency for data organization Task Breakdown: 1. Gather a list of 382 Conveyancing Solicitors and 313 Probate Solicitors using data scraping techniques. 2. Compile their details (Name, Company Name, Company Address, Phone Number, Email) into a spreadsheet. The email should be sourced from their respective websites. 3. Categorize the solicitors' data based on their type - "Conveyancing", "Probate", or "Conveyancing/Probate" (for duplicates). 4. Organize the entire list by distance from the postcode MK45 1AH. Please note: - The ideal freelancer should have ...
I'm looking for an expert in Excel or Google Sheets to help me create an automated pricing spreadsheet. This will be a product price tracking spreadsheet that will initially use manual entry for data input. Key requirements for the project: - The spreadsheet should be able to automatically add margin and mark up to the entered prices. - The freelancer should have experience with creating automated spreadsheets and be able to provide examples of similar work. - A strong understanding of product pricing strategies and spreadsheet automation is preferred. I would appreciate a quick turnaround time. Looking forward to your bids.
...ensure cohesive and visually appealing selections. Tool Proficiency: Experience using ColorZilla or similar browser extensions to quickly and accurately pick colors from websites. Attention to Detail: Precision in identifying and recording colors without errors. Avoid selecting default colors {#303954, #6993CD, #ECA542}. Data Entry Skills: Accurately input selected colors into the provided spreadsheet columns (L, M, N). Web Navigation: Ability to navigate websites efficiently to locate and analyze the required design elements. Communication Skills: Prompt and clear communication to provide updates or seek clarifications when necessary. Accessibility Awareness: Ensure all chosen colors meet readability standards and are suitable for use on a white background. --------------...
I'm looking for an Excel expert to create a comprehensive Excel sheet for my team's workload analysis and look-ahead program. Key Functions: - Workload Distribution: The sheet should help in distributing tasks evenly among team members based on their capacity and skillset. - Progress Tracking: It should allow us to monitor the progress of each task and project. - Deadline Reminders: The sheet should have a mechanism for reminding us of upcoming deadlines. The sheet will be used exclusively by my team members, so it needs to be user-friendly and intuitive. No integration with other software or tools is required. Ideal Skills: - Advanced Excel skills - Experience in creating workload analysis tools - Understanding of project management principles and tasks ...
I'm working on Excel export feature.
Automated Investment Management Tool for Rupeezy Broker (Phase 1: Buy/Sell Automation) Project Description: The objective of this project is to develop an Excel-based or standalone software solution integrating Rupeezy broker APIs. This Phase 1 focuses on automating basic Buy and Sell functionalities, along with real-time reporting, margin trading calculations, and investment tracking. Additionally, the tool will include a feature to automatically calculate target price adjustments based on user-defined profit percentages and margin costs, executing orders daily when conditions are met. Phase 1 Requirements: Core Features API Integration: Integrate Rupeezy broker APIs using: API Documentation GitHub Library Securely connect to the broker's platform for real-time data and o...
I'm seeking a meticulous data entry professional to help with organizing and validating customer data. The data is currently in Excel/CSV files and requires detailed validation for accuracy. Key Responsibilities: - Input, sort, and organize customer data with precision. - Perform detailed validation checks to ensure data accuracy. - Assist with data management and reporting as needed. Ideal Skills: - Exceptional attention to detail and accuracy. - Proficiency with Excel/CSV files. - Experience with data entry and quality control. - Strong administrative support skills. With over 24 years of experience in administrative roles, including expertise as a Steno-Typist, Personal Assistant, and Admin Manager, I am confident this project will be a success. I look forward to...
Chemical consultant work and chemical management work including chemical database management, introduction phase of new chemical registry clients and handling new MSDS requests of existing chemical registry clients.
I'm seeking an expert in Microsoft Excel to create a dynamic and visually appealing sales analysis dashboard for my bicycle business. This tool will help in understanding various performance metrics, and ultimately, in making informed business decisions. Key Features: - Incorporation of specific metrics: Sales trends by month, Profitability by product, and Customer demographics. - Exclusive use of Pie charts for data visualization. - Implementation of advanced data analysis techniques: Forecasting future sales and Seasonal trend analysis. The ideal candidate will have extensive experience in data analysis and visualization using Excel, with a strong understanding of business metrics. Prior experience in creating interactive dashboards will be a significant advantage. P...
I am seeking a skilled data analyst with a strong background in prescriptive analysis, utilizing Excel spreadsheets and SQL databases. The primary focus of this project is to conduct a thorough examination of our data for market research purposes. Key Responsibilities: - Conduct prescriptive data analysis to aid in decision making - Utilize Excel and SQL for data manipulation and examination - Deliver insights that can influence our market strategy Ideal Skills: - Advanced Excel and SQL proficiency - Expertise in prescriptive data analysis - Experience in market research analysis Please include your relevant experience and examples of similar projects in your bid.
I'm in need of an individual who can compile a comprehensive list of IT companies from Europe,...sponsorships. The data should be sourced from the official government sites of the respective countries, ensuring accuracy and reliability. Please provide the URL from where you extracted the data. Details of the project: - Format: The extracted data should be in an Excel spreadsheet. - Information Required: For each IT company, please include the company name, LinkedIn URL, website, and number of employees. - Categorization: The companies should be categorized by country. Ideal Skills and Experience: - Proficiency in data extraction and Excel. - Familiarity with IT companies and job sponsorships. - Ability to source data from government sites. - Attention to detai...
I'm seeking a detail-oriented professional to assist with entering customer data from Excel spreadsheets into our database system for my existing business. Key Responsibilities: - Accurately input customer data from Excel into our database system. - Maintain confidentiality and handle sensitive information responsibly. - Ensure data integrity and consistency throughout the process. Ideal Skills and Experience: - Proven experience in data entry, particularly with customer data. - Familiarity with Excel and database systems. - Excellent attention to detail and a commitment to accuracy. - Ability to maintain confidentiality and handle sensitive information responsibly.
DotNet Tester required to test done work of other developer thenafter create videos explaining existing errors in developer's done-work and new error born in during his development. Website Address - User emailid- userany303@gmail.c Password- kaspersky The work given to previous developer explained in below link videos- Sample video links explaining errors in developer's done-work is below-
I'm looking for someone to assist with the verification of legal documents. I need these documents to be checked for their format and structure. Ideal skills for this job would include: - Attention to detail - Familiarity with legal document formatting - Strong organisational skills The documents will be provided as digital files, such as PDF or Word.
I need a professional who can help in verifying my legal documents. The focus will primarily be on identifying typographical errors. Ideal Skills: - Experience in legal document verification. - Strong attention to detail. - Proficiency in identifying typographical errors. Please provide examples of similar work you've done in the past.
I'm looking for a data-savvy freelancer to help me gather information on software and AI influencers. The primary task is to find their email addresses, primarily from their personal websites and exact number of subscribers on YouTube. Skills and Experience Needed: - Proficient in web research and data collection - Familiarity with YouTube and other social medi...influencers. The primary task is to find their email addresses, primarily from their personal websites and exact number of subscribers on YouTube. Skills and Experience Needed: - Proficient in web research and data collection - Familiarity with YouTube and other social media platforms - Attention to detail - Ability to present data in a clear and organized manner The data should be presented in a Spreadsheet (Exc...
I need a proficient Android app developer to create a telecalling application. The app's main function will be for lead generation. Key Features: - Admin Panel: A separate web-based dashboard where I can upload contact details from an Excel sheet. - Click-to-Call Functionality: The app should display contact details for easy dialing. - API Integration: The app must utilize the Gsm (Phone SIM) for calling. - WhatsApp API: To send messages to end users directly from the app. - Feedback Mechanism: Incorporating a call disposition mechanism to capture conversation feedback through predefined options. - Tracking Features: The app should monitor total calls dialed, average talk time, and various call statuses (completed, missed, lead, callback, prospect, etc.) - Reporting: An admin ...
...contact details. As an example, the City of Mississauga in the province of Ontario has an online directory that lists 14,481 businesses in Mississauga, and allows users to download the list as an Excel file (I have already downloaded info for all of these businesses): Note: some municipality websites don’t have business directories. That’s fine - I just want you to check the top 50 municipality websites and determine which ones do have business directories. So to summarize the work to be done in this first stage (Municipality websites), you will: (a) scrape the website for every municipality (i.e. city) in Canada; (b) check the municipality websites for the top 50 municipalities
I'm in need of a person to create an Excel catalogue for my collection of 78 RPM discs. (had to re post as images and uploads did not come through on prior post) With 203 images to work from, the catalogue will need to encompass several key pieces of information which is available on the image of each disc including the artist, song title, record label, catalogue number, genre, unique identifiers, and any other relevant details observable from the images. The final catalogue will also need to include a condensed size version of each photo. - Artist - Song Title - Record Label (exact wording) - Catalogue Number (if applicable on disk) - Genre (basic classification e.g., Jazz, Blues) - Unique Identifiers (full transcriptions of labels) - Any other information found on e...
I'm looking for someone proficient in Microsoft Excel to assist with data entry. The data is mixed - both numeric and text. Key Responsibilities: - Accurately input mixed data into Excel - Perform basic data validation checks to ensure accuracy - Report any discrepancies in the data Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Ability to perform basic data validation checks Experience with data entry and Excel is a must. I look forward to your bids.
I need an expert to help me through some excel questions for about an hour on a zoom call. My main goal for the call is: - Creating new formulas The ideal freelancer for this project should have: - Extensive experience with Excel, particularly with creating mathematical operations - Excellent communication skills for a seamless Zoom interaction - Patience and ability to explain complex concepts in a simple way
I'm seeking an experienced SQL developer to write a MySQL query for me. The task involves combining two data tables based on a specific column, with the aim of generating an output that includes SKU, Product Name, Sales Group, Category, Cost Price, and Sales Price. Key Requirements: - Combine the dat...with the aim of generating an output that includes SKU, Product Name, Sales Group, Category, Cost Price, and Sales Price. Key Requirements: - Combine the data based on the item_id column. - Filter the data based on the Sales Group. - Ensure the query is compatible with MyPHPAdmin. - The final output needs to be exportable to Excel. Ideal Skills and Experience: - Proficient in SQL and MySQL. - Prior experience with data integration tasks. - Familiar with MyPHPAdmin and Excel...
I'm looking for someone to manually collect email addresses from various programming sites. Skills & Experience: - Familiarity with programming sites like Stack Overflow, GitHub, and Reddit. - Experience in data collection and research. - Proficient in Excel, CSV and Text file formats. Please note, the specific programming sites and email types will be discussed further. I'm seeking assistance in collecting member emails from specific programming community websites I will provide. Your task will primarily focus on gathering emails of recent members from these sites. You have to manually go to user profile look, for his email if not there search email for same person from his linkedin profile or google or github or twitter etc etc profile. The ideal candidate for...
I'm seeking a skilled professional with deep expertise in dynamic programming and non-linear programming. The primary objective of this project is optimiza...non-linear programming. The primary objective of this project is optimization modeling, specifically targeted at leveraging dynamic programming techniques. Ideal Skills and Experience: - Advanced knowledge in dynamic programming - Advanced knowledge in operations research - Proficient in linear programming - Skilled in dynamic programming - Experienced in non-linear programming - Highly proficient in Excel for modeling and analysis Please note, the focus will be primarily on dynamic programming and non-linear programming. Your ability to apply these techniques to complex optimization problems will be key to the success o...
...accountants, lawyers, and more. While we excel in technical expertise, we are seeking a dynamic and experienced sales partner to join as a co-founder to help us drive growth. The Opportunity: This is a unique chance to become a commission-based co-founder of a promising digital studio. You’ll take charge of sales and client acquisition, while we focus on delivering high-quality technical solutions. Together, we’ll scale the business and share in its success. What You’ll Do: - Develop and execute sales strategies targeting SMEs and specialist industries across the UK. - Identify, prospect, and generate your own leads, turning them into long-term clients. - Communicate the value of our web design and development services to potential clients. - Work clos...
I need someone to help me with typing some text data from an Excel file. The data is a few pages worth of text. Ultimately, I need the typed data to be compiled into a plain text file. Ideal Skills: - Proficiency in Excel - Fast and accurate typing skills - Attention to detail - Experience with creating plain text files
...an Excel expert to design a shift schedule for my employees. The system needs to accommodate rotating shifts, with 5 working days followed by 2 days off per week. Shifts will alternate weekly between morning and afternoon. And not all the off days occur on the weekends as I need the employees mostly at weekend so arrange the off days along the week and I need more than 6 employees each shift. Key requirements: - Shift Schedule: The schedule should cover 5 days of work and 2 days off each week. - Rotating Shifts: All employees will be on a rotating shift pattern. - Weekly Change: The shifts should change every week. Please note that the schedule does not need to take holidays into account. I will provide the names and details of employees. Ideal candidates should be profi...
...effectively. You are self-reliant and able to work with minimal supervision. You are proficient in spreadsheets, including MS Excel and Google Sheets. You excel in fast-paced, dynamic startup environments and adopt a proactive mindset. It is a plus if you have 2+ years of experience in related fields or hold a degree in Business, Sales, or Marketing. What You Will Do Develop narrative strategies for apps and games. Use LinkedIn and other platforms to generate and qualify sales leads and opportunities. Conduct searches and queries to identify, research, and create demand. Execute key demand generation initiatives as outlined in the strategy. Adapt quickly to various lead generation tools. Prepare and analyze sales pipeline reports. Work directly wi...
Creating a set of variables based on 2 sets of cells. Column A has letters or number in it. Column B has letters or numbers in it. A1 VS B1 would have 2 variable outcomes in column C1 A1 or B1. If colum A and B is increasd to 2 cells then column C would have 4 outcomnes etc. I would also need to be able to pick how many cells in each column are active.
Website briefing I want to create a website where people can review companies based on their work atmosphere, culture, and related factors. The website will have two main target audiences: 1. People who currently have (or have had) a job and want to leave a review about their experience. 2. People who are looking for a job and are interested in information about the opinions of current/old employees. Key Features: 1. Anonymous Reviews: users must have the option to write reviews anonymously or use a self-chosen username. This is an essential feature to encourage honest feedback. 2. Company Submission by Users: new users should have the ability to add companies to the platform themselves. This eliminates the need for manual additions by us and ensures that small and lesser-known ...
I am seeking a professional visa processing specialist to assist me with obtaining a work visa for Canada. The ideal candidate will assist with application preparation, document review, and interview coaching. Key responsibilities: - Application preparation: Help me complete the work visa application accurately and thoroughly. - Document review: Ensure all required documents are complete and properly formatted before submission. - Interview coaching: Provide guidance and practice for potential visa interviews. The ideal freelancer for this job will have extensive experience with Canadian work visa processing, a keen eye for detail, and excellent coaching skills.
...professional Structural Engineer with more than 08 years experience. I can design any types of residential and commercial buildings with proper structural analysis, Load calculation report and detailed drawing following by ASCE, ACI, IBC, BNBC codes. I have expertize in different types of professional software like SAFE, ETABS, AUTO CAD, STAAD Pro, SAP 20000, MS EXCEL, MS POWERPOINT etc. I have also expertise at 3D design and 2D draft work of AUTOCAD, SKETCH UP and other relevant softwares. I am able to deliver your project with all the key requirements and your timeframe. I have practical experience in many RCC structures, Steel Structures, Timber structures etc which were delivered to clients with their feedback. My team members are incorporated with me and support m...
I'm looking for someone to help with typing out some digital PDF documents. The PDFs contain text only and are approximately 1-10 pages in length. However, the documents do contain some special formatting that will need to be replicated accurately. Ideal skills and experience for this job include: - Excellent typing skills - Attention to detail - Experience with typing out PDF documents - Ability to replicate special formatting accurately.
