Refresh data excel 2007 vba jobs

We are seeking a versatile Data Analyst to support multiple companies across different industries. The ideal candidate will excel in transforming raw data into actionable insights using various visualization tools and will be adept at managing and querying databases.

I need a freelancer to convert a 3-page PDF document into an Excel file. The Excel layout should mirror the PDF exactly. The PDF contains primarily text and numbers. Key Requirements: - Convert data from the PDF into Excel, maintaining the original layout. - Utilize your judgement to handle any ambiguities or potential errors in the PDF. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to make educated guesses when faced with uncertainties in the source material.

...have an Excel file with multiple tabs, each representing a month of the year. Within each tab, my products are listed in one column, and the days of the month are represented in rows. The cells that intersect contain a number representing the quantity of products sold on the corresponding day. I need a new dynamic tab created that has at least two columns: one for products that have sold at least one unit, and another for the total number of items sold. Products that have no sales on a given day should not be displayed. This new tab should be dynamic, allowing me to see which products have sold on a given day. There should be a day selector that filters the products accordingly. Specific Requirements: - The new tab should be formatted as a simple table - The project is in E...

I'm in need of an Excel wizard to create a Monthly Sales MIS Report for me. This report needs to focus exclusively on sales data and perform a trend analysis. Key Responsibilities: - Collect and analyse sales data on a monthly basis. - Identify and illustrate trends in the sales data. Ideal Skills and Experience: - Proficiency in Excel, including the use of advanced functions and features. - Previous experience in creating MIS reports. - Strong analytical skills with a focus on trend analysis. - Excellent attention to detail.

Chemical Engineer Needed for Creating Industrial Chemical Datasheets and Catalogs **Description:** We are looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and cata...looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and catalogs for our products. **Requirements:** - Research and compile technical specifications and industry applications. - Prepare datasheets and catalogs in editable formats (Word, Excel, and PDF). - Ensure the output is professional, accurate, and visually appealing. **Skills Required:** - Strong knowledge of industrial chemicals. - Proficiency in Microsoft Word, Excel, and PDF tools. - Excellent research an...

As a hot shot trucking company, I'm in need of a skilled web designer who can crea...flexible for future page additions. Key Pages: The website should initially include: - Home - About Us - Contact - Services - Blog - Testimonials - Portfolio - FAQs - Careers - Request a Quote SEO: An integral part of this project is SEO. I want this site to become a top contender for "hot shot hauling", "hot shot trucking company", etc. Logo Design: Depending on pricing, we might need a refresh of our current logo, so experience in logo design would be appreciated. Ideal Skills: - Proficient in Wix - Website design - SEO expertise - Logo design experience (a plus) - Familiarity with creating professional and corporate-style websites Please note: - We have a specifi...

I'm looking for an Excel expert who can help me build a comprehensive report showing Actuals vs Budget vs FC vs PY. The report will primarily serve as a financial overview tool and needs to be updated daily. Key requirements include: - Proficient in Excel with advanced skills in data analysis and visualization. - Experience working with internal databases and external data feeds. - Ability to understand and interpret financial data. - Capability to create automated daily updates for the report. Please include examples of similar projects you've completed in your proposal.

I'm seeking a professional to implement and modify a new theme on my current e-commerce website. The primary goal is to improve user experience and refresh the brand image. This is our current website This is the new theme to be implemented. Instruction, modification and layout to be provided once you’re “Awarded” the job. ADDITIONAL REQUIREMENTS: Install this ADA compliance plugin, notes and guidelines to new website: Our

I'm seeking a meticulous freelancer for a data entry task. The job entails transferring data from a 300-page PDF file into an Excel spreadsheet. The data needs to be organized into clear columns such as First Name, Last Name, Address, City, ZIP Code, and Other relevant details. Requirements: - Exceptional accuracy and attention to detail. - Experience in data organization in a clean and structured format. - Timely delivery of the completed file. The data in the PDF file is text only and has a consistent layout. If you're interested, please provide your estimated time and cost for this task. Thank you!

I'm looking for an Excel expert to create a macro that will help in task automation. The specific tasks to be automated will be discussed later. Ideal Skills: - Proficiency in Microsoft Excel - Experience in developing macros for task automation - Excellent problem-solving skills - Ability to understand and analyze tasks for automation Please provide examples of similar projects you've completed in your proposal.

I have a project to be completed in Financial Modelling througn excel.

I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.

I'm seeking an expert to assist with converting my Excel tables and data into HTML. This project will also require the conversion of my Excel charts and graphs into static images for HTML display. Skills needed: - Proficient in Excel and HTML - Experience in data conversion - Ability to create static images from Excel charts and graphs - Attention to detail to ensure all tables and data are accurately converted

I'm seeking a web developer to create a small-scale HR management system. The application should al...Tracking: Employees should be able to mark their own attendance. - Salary Management: The system should allow employees to download their salary slips. - Data Upload: There should be an option to upload employee data in bulk via Excel. - Email Integration: The system should be configured to send offer letters through Gmail. Ideal Skills: - Web Development: Proficiency in creating interactive and user-friendly web applications. - HR Software Knowledge: Prior experience with HR management systems would be beneficial. - Email Service Integration: Experience with Gmail's API for automated email sending. - Data Handling: Skills in setting up Excel ...

I'm a beginner in Power Queries, seeking a tutor to guide me through data transformation and merging queries. Together, we'll improve an existing Excel file for better data organization. Sessions will be over Zoom, which will be recorded for future reference. Ideal skills and experience include: - Proficiency in Excel, particularly Power Queries - Prior experience in online tutoring or teaching - Ability to simplify complex concepts - Strong communication skills - Patience and understanding towards beginners

I need assistance with manual data entry of customer information I receive via emails. Requirements: - Proficient in data entry - Able to handle and convert data from emails into Excel - Detailed-oriented - Able to maintain confidentiality

I'm seeking a professional who can assist with extracting performance data of Brazilian investment funds from the Refinitiv platform. The data should be specifically focused on performance indicators and delivered in Excel format. Key Requirements: - Access to the Refinitiv platform - Ability to extract performance data of Brazilian investment funds - Proficiency in Excel for data delivery - Capability to perform this task on a yearly basis The ideal freelancer for this project would have experience with data extraction from financial platforms, particularly Refinitiv. Understanding of investment fund performance metrics is a plus. Please bid only if you have access to the required platform and can deliver the data as specifie...

I am seeking a seasoned Ruby on Rails (ROR) developer with a minimum of 4 years of experience, specifically with Rails...system availability during peak traffic and propose solutions to maximize uptime. - Identify and resolve performance and scalability issues. Key Requirements: - Proficient in data analysis and reporting functionalities within ROR. - Experience with system architecture and efficiency. - Strong drive, ownership, and team-oriented mindset. - Proficient in standard CS fundamentals (data structures, algorithms, complexity analysis). - Strong English proficiency. - Systematic debugging and problem-solving skills. The application will need to pull data from various sources including databases, external APIs, and CSV/Excel files. Your expertise in R...

...disciplinary background, and should be fully referenced, using a recognized referencing system. Statements: 1."That judicious combination of manager, commander and leader is never simple, but it is necessary." (Grint, 2020) 2.“…for leadership to function well, leaders and followers must be bound by a shared identity and by the quest to use that identity as a blueprint for action.” (Reicher et al, 2007) 3."...the conventional understanding we have of leadership today is profoundly limited, limiting and problematic." (Wilson, 2016, p2) Written Assessment Task 2: Hints and Tips The Guidance on Written Assessments section, accessible from the left-hand menu, takes you through the process of writing written assessments, including advice on how...

I'm in need of a Zoho Books professional who can assist with the setup and configuration of Zoho Books, specifically focusing on data import and migration, as well as customization and integrations. Key Requirements: - Importing large Excel files containing product information into Zoho Books - Customizing and integrating Zoho Books to suit my business needs - Initial setup and configuration of Zoho Books Ideal Skills and Experience: - Extensive experience with Zoho Books - Proficiency in data import from Excel to Zoho Books - Ability to customize and integrate Zoho Books - Previous experience in setting up Zoho Books

I need assistance with cleaning data from several digital Excel files. Key Responsibilities: - Review and clean data in Excel spreadsheets - Ensure data integrity and accuracy Ideal Candidate: - Proficient in Excel - Has experience with data cleaning - Detail-oriented and able to spot errors in data

I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills

I'm looking for a skilled freelancer with expertise in Power Automate and Excel coding. I need assistance with automating data entry and updates in my Excel worksheets. Key Requirements: - Automate importing data from an email and CSV/Excel files into my Excel sheets. - Streamline the process of updating existing records. Ideal Skills: - Proficiency in Excel and Power Automate. - Experience with data handling and automation. - Strong attention to detail and ability to validate data. The goal is to save time and enhance efficiency with data management. Please share your relevant experience and examples of previous projects.

I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.

I'm in need of a data cleaning professional to help me with a spreadsheet containing 50,000 rows of company details. The data is currently organized in a single column and includes company names in mixed formats. Key Responsibilities: - Extract company names from the data strings - Clean the data manually to ensure accuracy Ideal Candidate: - Proficient in Excel or similar data management software - Exceptional attention to detail - Previous experience with data cleaning or data entry - Able to work independently and meet deadlines Please note that the company names are in mixed formats, so the ability to recognize and standardize these is crucial.

Hi i created a quote for this project

The task is to build a modern data layer to enhance our legacy Property Management System (Beds24). We need a reliable system to sync and normalize data from Beds24's property management system. Current challenges include: - Inconsistent webhook formats - Unreliable API behavior - Complex data relationships - Token management needs What We're Building: ┌─────────────┐ ┌──────────────┐ ┌────────────┐ │ Beds24 │────►│ Business │────►│ Data │ │ │ │ Logic │ │ Layer │ └─────────────┘ └──────────────┘ └────────────┘ Building a robust data layer and business logic system using serverless functions (Cloudflare Workers/Supabase Functions) and SQL database (D1/PostgreSQL). 1. Modern ...

I'm looking for a proficient data entry specialist who can help me record mixed data (text and numerical) from Excel files. Key Responsibilities: - Accurately inputting mixed data (text and numerical) from provided Excel files. - Ensuring data integrity and accuracy during the entry process. Ideal Skills: - Proficiency in Excel and data entry. - Attention to detail to ensure data accuracy. - Experience in handling mixed data types. Please provide your experience with similar projects in your bid. Thank you.

...telecalling, sales, or customer interaction is a plus. What We Offer Remuneration: INR 20,000 per month (fixed) + attractive sales commission. Growth Opportunity: Potential to transition into a full-time role based on performance. Flexible Work Hours: Ideal for individuals looking to balance other commitments with a rewarding part-time role. How to Apply If you believe you have the skills and drive to excel in this role, please send your updated resume and a short voice recording introducing yourself....

Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo

Please Sign Up or Login to see details.

I'm in need of a comprehensive Excel workbook that can assist in managing and scheduling both staff and volunteers. The workbook should be capable of: - Scheduling staff and tracking days off - Computing hours and calculating salaries Additionally, the workbook should enable viewing the schedule in Gantt charts. Ideal candidates for this project should have a strong background in Excel, particularly in creating complex workbooks with various functions. Experience in HR or volunteer management is a plus. Please note, I will be providing the data necessary for hours computation and salary calculation.

Instructions for Data Scraping Task Your task is to extract specific information from job posting links. Below are the detailed requirements: Data Points to Scrape: 1. Company Information: - Company Name - Company Details: Brief about the industry or type of work they do. - Company Website - LinkedIn Page: URL to the company’s official LinkedIn page. 2. Email IDs (3 Required): - Find 3 individuals' email IDs from the following departments: - Admin - Human Resources - Head of Sales/Top Leadership (CXO level in Sales) - Marketing Head/Top Leadership (CXO level in Marketing) - Founders/CEOs/Co-founders/Owners 3. Email Requirement: - The email IDs must be professional (e.g., `name at `). - Avoid generic emails like `...

I need a freelancer who can assist me with data extraction from PDF files. The task involves: - Extracting text content from PDF files. - Accurately entering the extracted data into an Excel file. Ideal skills and experience for the job: - Proficiency in data entry with high attention to detail. - Prior experience with PDF data extraction and Excel. - Ability to maintain confidentiality and handle sensitive information with discretion.

I'm looking for a skilled data analyst and Python programmer to create a code in Jupyter Notebook for analyzing data from Excel files. The project involves: - Primarily focusing on data analysis - Utilizing Pandas and NumPy libraries Ideal candidates should have: - Extensive experience with data analysis and Python programming - Proficiency in using Pandas and NumPy - Ability to work with Excel files - Familiarity with Jupyter Notebook Please include in your bid examples of similar projects you've completed. You are required to write the necessary program and create an effective presentation describing: The military spending of at least the top 10 nations (in military spending) Compare the data to that country’s GDP, C...

I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.

I'm looking for an Excel expert who can create a dynamic data visualization tab for analyzing financial data specifically for ROI metrics. The main focus will be on cost savings and investment returns. Key Requirements: - Use of Charts and Graphs: I need clear and engaging visual representations of the data. - Pivot Tables: Help in summarizing the data and making the analysis more manageable. - Conditional Formatting: To highlight key trends and important information in the data. Ideal Skills: - Advanced Excel: Proficiency in using Excel's more complex features. - Financial Analysis: Understanding of financial data and metrics. - Data Visualization: Ability to present data in a clear and engaging way. Pleas...

I need someone reliable to input data from PDF copies of timesheets from our construction crews into Excel for weekly costing purposes. - Data: Approximately 80 sheets per day, each covering 5–20 personnel - Delivery: I will send these sheets in a couple of batches on Friday / Monday. I need the completed task back first thing Tuesday. - Duration: This will be a weekly task for the next three months. - Resources: I can provide the employee names in Excel format, which will help improve data validation and accuracy. Skills and experience: - Proficiency in any spreadsheet software (Microsoft Excel, Google Sheets, etc.) - Experience in data entry - Attention to detail - Good communication skills Communication: My preferred method is ...

I am looking for someone to copy and paste ALL the titles from my website into an Excel sheet You must copy and paste everything, EVERYTHING, EEEEEVERYTHING I will check only once and, if I find anything missing, the job will be rejected I have three websites. the budget is CAD$30

I have a corrupted Excel file that I'm unable to recover myself. The file contains complex formulas, and I'm unsure how it was corrupted - it could have been from a software crash, a virus attack, or an unexpected shutdown. - Any experience with data recovery from Excel files would be a plus

I'm in need of a professional who can create a product sales invoice in Excel for my business. The ideal freelancer for this project should have extensive experience with Excel and be able to incorporate specific features into the invoice. Key features include: - Automatic tax calculation - Discount options - Customizable logo and branding Each invoice needs to detail each product with: - Product description - Quantity and unit price - Product code or SKU It's crucial that the freelancer understands how to design an invoice that is both functional and visually appealing, reflecting my brand identity.

I have a 30-page PDF spreadsheet that is currently a scanned image. I need this data transcribed into Excel. The data is consistent across the pages, but primarily consists of text and some numbers. Key requirements: - PDF is a scanned image - Data is text-based - Needs to be converted into Excel Ideal skills: - Proficient in data entry and transcription - Familiar with Excel - Attention to detail to ensure accurate data transfer

I need an Excel spreadsheet to monitor the billed hours of each of our automotive technicians, as well as their total team hours each day. This tracking should be in relation to the daily goals we've set for them. This website gives some example of what I'm after Key Features: - A bar chart graphic display to visualize the data (along with actual numbers) - Tracking for individual technician hours and combined team hours - Comparison of hours worked against daily goals for individual as well as team -The graphic should represent how close to the set goal they are. Below 80% is red, 80-99.9% is yellow and 100% and up is green. Our automotive technicians are paid a bonus based their actual billed hours vs their target goal for billed hours. Also as a

I'm seeking a skilled WordPress developer to refresh my website's design and enhance its functionality. Key Tasks: - Redesign the site with a focus on a multi-column layout. - Update the navigation and layout aspects. - Install and configure plugins to improve site functionality. Ideal Skills: - Proficient in WordPress. - Strong design sense, especially with multi-column layouts. - Experienced with WordPress plugins. - Good understanding of user-friendly navigation systems. Please include examples of previous WordPress design and functionality projects in your proposal.

I'm looking for a comprehensive three statement model to assist with investment analysis on the company ASML. This model should enc...encompass the following financial statements: - Income Statement - Balance Sheet - Cash Flow Statement In addition to the standard financial statements, the model should also include: - Discounted Cash Flow (DCF) analysis - Comparable company analysis (Comps) - Sensitivity analysis Ideal candidates should have extensive experience in financial modeling and investment analysis. Proficiency in using Excel for complex calculations is crucial, as is a solid understanding of DCF and Comps methodologies. A background in finance or a related field would be beneficial. Your expertise will help guide investment decisions based on the insights provided...

I'm seeking a solution to expedite job posting updates on Clasified website. I refresh my page every minute but still miss listings. I need a faster, more reliable way to track job if i update the browser every appears new ad appears for example with this message "posted 8 minutes ago"

I'm in need of a skilled web developer to assist with my site. The job will involve editing text, troubleshooting SQL database problems, and fixing various issues related to the website's functionality. Key responsibilities include: - Content updates: Primarily text alterations to refresh and improve website content. - Database troubleshooting: Identifying and resolving SQL problems that are affecting site performance. - Functionality improvements: Diagnosing and repairing various issues to enhance overall site usability. The ideal candidate will have experience in web development, database management, and content editing. A keen eye for detail and strong problem-solving skills are essential.

...skilled Excel professional to update my spreadsheet. The updates involve enhancing the existing formulas and functions, as well as improving the design and formatting. The base document just needs minor updates and needs to extend monthly from 2025-2035 Key Requirements: - Expertise with Excel functions and formulas - Strong skills in design and formatting Please note, the specific functions and formulas that need to be implemented have not yet been determined. However, you should be comfortable using lookup functions (like VLOOKUP, HLOOKUP), statistical functions (like AVERAGE, MEDIAN), and logical functions (like IF, AND, OR). Your ability to understand and manipulate data will be crucial to the success of this project. Ideal Skills: - Advanced Excel s...

I'm in need of an Excel specialist. The main task involves creating an advanced Excel formula to assist with financial calculations, specifically focusing on data lookup. Key Tasks: - Design and implement an advanced Excel formula to perform financial calculations - Focus on data lookup aspects - Potential use of VLOOKUP, INDEX and MATCH, XLOOKUP or other relevant functions Ideal Skills: - Strong proficiency in Excel, especially with advanced formulas - Experience with financial calculations - Ability to translate complex data into understandable results - Familiarity with data lookup functions If you can help me navigate this task, please make a bid.

I'm seeking an Excel expert to assist with my financial data. The primary task will be to combine data and formulas to generate comprehensive reports. Ideal Skills and Experience: - Advanced Excel skills with extensive experience in handling financial data - Proficient in combining various types of formulas - Strong report generation skills - Previous experience with financial data analysis highly preferred.