Vba excel spreadsheet work jobs
I have an old and heavy Excel sheet that often lags. I need an updated, optimized, and improved version without any errors. My primary use for this Excel sheet is data analysis. Specifically, I use it for: - Statistical analysis - Data visualization - Using pivot tables The sheet typically handles more than 100,000 rows of data. Ideal skills for the job include: - Advanced expertise in Excel - Experience with data analysis - Skills in optimizing Excel sheets for heavy data usage - Proficiency in creating error-free and efficient spreadsheets Please note, I need this task completed as soon as possible.
...enhance our customer relationship management, streamline project management, and improve our financial tracking and reporting. Key Responsibilities: - Implement and integrate Zoho CRM, Zoho Books, and Zoho Projects into our operations via Zoho One. - Ensure the systems work seamlessly together to enhance efficiency and productivity. - Facilitate improved tracking and reporting of our financials through Zoho Books. - Optimize our project management processes through Zoho Projects. Data Migration: - I have existing data from excel on customers and past histrorical data that needs to be migrated from another accounting software to Zoho Books. This includes financial records, customer data, and project history. Ideal Skills: - Proven experience in Zoho One implementation a...
I'm looking for an experienced data analyst who excels in working with Excel spreadsheets. Your primary tasks will involve: - Data entry and formatting: I have a substantial amount of data that needs to be inputted and formatted correctly in Excel. - Data analysis: Once the data is properly formatted, you'll be responsible for analyzing it in Excel. The ideal candidate will have: - Proficiency in Excel, including advanced functions and formulas - Strong skills in statistical analysis - Attention to detail to ensure data accuracy - Ability to meet deadlines If you're up for the challenge, I'd love to hear from you!
I need a straightforward Excel sheet that helps me calculate my monthly expenses. I want to be able to input daily amounts and have them total automatically. Expenses to Track: - Material - Invoices - Tools - Gas - Other - W9 - Cash - Cows Key Requirements: - The Excel sheet should be organized for daily entries with a monthly total - No charts or visual aids are required, just a simple, functional design Ideal skills for this project include: - Proficiency in Excel - Experience in creating user-friendly spreadsheets - Ability to understand and cater to specific data tracking needs
I need expert assistance to set up and manage my MySQL database on a Windows server. Specific Tasks: - I have MySQL installed. I have several very large files I want to import, but MySQL is telling me they are to large - Database Optimization: Once imported I want the database set u...a Windows server. Specific Tasks: - I have MySQL installed. I have several very large files I want to import, but MySQL is telling me they are to large - Database Optimization: Once imported I want the database set up in a certain way - Generally need advice on how to update the database - Report generation: I need specific reports generated . I'm not sure the best tool to do this but maybe excel? I'd like to form an ongoing relationship with an expert to help me develop the database an...
I'm seeking an experienced dat...seeking an experienced data engineer for a project focused on building and managing a data warehouse using Amazon Redshift. Key Responsibilities: - Design and implement a comprehensive data warehouse on Amazon Redshift. - Work on optimizing the performance of the warehouse. - Able to potentially integrate various data sources in the future. Ideal Skills: - Proficient in Amazon Redshift. - Strong background in data warehousing concepts. - Experience with performance tuning of data warehouses. - Knowledge of various data source types (Relational databases, NoSQL databases, CSV/Excel files). Please note that the integration of diverse data sources is a potential future requirement, so having the skills and experience to handle this would...
as discussed in chat the work description and delivery timeline has been fixed. we will work with it
...experience in job applications, recruitment, or HR to assist with my job search in the software development sector. The role is remote but requires availability between 8:00 AM – 7:00 PM EST. Key Responsibilities: - Tailor my resume and cover letter to match job descriptions in the technology sector - Submit applications on relevant platforms (LinkedIn, Indeed, company sites) - Maintain a spreadsheet of job submissions and responses Ideal Skills: - Experience in job applications, recruitment, or HR - Detail-oriented and proactive - Familiarity with the software development sector - Proficient in English, both written and spoken Compensation: $2-$3/hr with a bonus package open for discussion. If you're interested or know someone who fits the role, please DM me or d...
I need assistance with combining 1-2 Excel documents for the purpose of archiving. Ideal Skills and Experience: - Proficiency in Excel - Attention to detail - Data management skills
I need a comprehensive Excel-based ERP application that focuses primarily on Financial Management. This mini-ERP should help me manage my processes, see projections, and calculate finances seamlessly. Key features of this Excel Dashboard should include: - Real-time tracking of income, expenses, and cash flow. - Advanced income and expense categorization and tracking (e.g., specific projects, departments). - Trend analysis and forecasting capabilities. - Automatic bank reconciliation with accounting records. I require a professional who has: - Proficient Excel skills and experience in creating ERP applications. - Strong understanding of financial management principles. - Ability to incorporate advanced tracking and forecasting features. Please note, while Financial ...
...proficient Excel macro developer who can automate a series of tasks for me. The primary objectives include: - Data Cleaning: Streamlining and organizing data to enhance its quality and usability. - Report Generation: Automating the process of report creation to save time and effort. - Complex Calculations: Building macros to perform intricate computations seamlessly. The macros will primarily interact with Excel files and Databases. As for triggering the macros, I would like to initiate them manually. Ideal skills and experience for this job: - Strong proficiency in Excel and VBA (Visual Basic for Applications). - Prior experience in developing macros for data cleaning, report generation and complex calculations. - Familiarity with databases and ability t...
I have ongoing work related to our previous project 'Ducknpigz 247'
I'm in need of a detailed Excel sheet for my company, specifically for the Operations department. This sheet should include various registers and time sheets, all interlinked with formulas for seamless data flow. Key Components: - Invoice Register - Expense Register - Salary Register - Employee Time Sheet - Invoice Incoming - Invoice Outgoing - Outgoing Purchase Order - Purchase Order Incoming (Sales Order) - Apex and Opex Register - Asset List - Billing Forecast - Expense Forecast - Hire Employee List and Salary Register - Payroll Master and ESOB Calculator and Register The project also requires the creation of a single dashboard. The main purpose of this dashboard is to track the financial performance of the company. It should prominently display: - Total revenue and exp...
I'm looking for a skilled Excel VBA developer. I need a worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data validation and conditional ...
I need a freelancer who can help me to create a bill from an Excel sheet and convert it into both an Excel file and a PDF. Ideal skills and experience for the job: - Proficiency with Excel - Experience with creating bills - Knowledge of PDF conversion - Attention to detail - Ability to meet deadlines
I'm looking to hire a freelancer who can assist in populating a spreadsheet with data by conducting web research. Key tasks: - Conducting basic web searches to gather data - Populating a spreadsheet with the collected data The ideal candidate should be capable of conducting web searches efficiently and accurately. Attention to detail is crucial, as the quality of the data collected will directly impact the project's success.
...dedicated professional who can manage data entry tasks with precision and speed. The main focus will be on: - Spreadsheet Management: You'll be responsible for handling and organizing data on spreadsheets, ensuring accuracy and efficiency. - Microsoft Access Database Updates: Regular updates to my Microsoft Access database will be a key part of this role. The ideal candidate for this project should have: - Proven experience in data entry, particularly with spreadsheet management. - Proficiency in Microsoft Access, with the ability to navigate and update databases with ease. - Excellent attention to detail, ensuring all data is entered accurately. - A commitment to delivering high-quality work with a fast turnaround time. This role is crucial in allowing me...
Hello! I just need simple excel sheet work in under 5 hours!
I have ongoing work related to our previous project 'Logo for a Bat Mitzvah (Logo Light, Logo for Sweatshirt, Logo for Pants Sweats, and Logo for Book, Logo for Napkins)'
Create an excel file, with macros and forms (VBA development) to facilitate the folow up of work
I'm seeking an Advanced Excel professional capable of creating comparative analysis charts and graphs for financial data, specifically comparing work progress. Key Requirements: - Remote work capability - Expertise in Excel chart/graph creation - Experience with financial data - Strong understanding of comparative analysis - Excellent ability to visualize complex data Ideal Skills: - Advanced Excel skills - Financial analysis experience - Data visualization expertise - Strong attention to detail - Excellent communication skills for remote work
...trainers, and management for effective collaboration and follow-ups. OneDrive Integration: Integrate OneDrive with Odoo to facilitate document sharing and cloud storage for contracts, project reports, training content, and more. Allow users to upload, access, and manage files directly within Odoo through the OneDrive interface. 22-Direct Collaboration Tools: Use Microsoft Office tools such as Word, Excel, and PowerPoint to manage documents and integrate them with Odoo for easy document generation. Ensure seamless synchronization between Odoo and Microsoft Office applications to improve productivity. Staffing and Organizational Structure: We operate with three main departments: Sales: Manages client acquisition and sales operations. Operations: Handles day-to-day consulting and se...
I'm seeking someone to help me create a data web scraping from different car-selling websites. I need to get the prices of the cars during the time (create a timeline) of prices and characteristics of the vehicles. Getting the data from those websites, for example: You can export the data to Excel or PDF format if you like. I need the prices of the cars and their characteristics. Ideal skills for this job would include: - Proficiency in web scraping tools and programming languages like Python, BeautifulSoup or Scrapy - Experience with data extraction from eCommerce or product websites - Ability to deliver clean, structured data Please ensure you can commit to delivering this project promptly and efficiently
I'm looking for a skilled frontend developer with expertise in Microsoft Excel. The primary task will involve creating a frontend that interacts with Excel for report generation. Ideal Skills: - Proficient in frontend development - Extensive experience with Microsoft Excel - Strong understanding of report generation processes in Excel Please note, the specific data types for the reports and the frontend framework have not been predetermined, so flexibility and adaptability are key. I look forward to your bids.
I need an experienced Excel expert to rewrite my complex, formula-heavy and macro-utilizing XLSX file for use on a Mac M3 Sequoia. This project involves ensuring the formulas remain unlocked and adding filters to the spreadsheet. Key Tasks: - Convert the current XLSX file for compatibility with Mac - Ensure all complex formulas and macros are functional and unlocked - Implement filters into the file - Add Pivot tables as per the original file - Apply basic styles and colors for customized formatting Ideal Skills: - Extensive experience with Excel and XLSX files - Proficiency in creating and modifying Pivot tables - Strong understanding of basic Excel formatting - Familiar with Mac M3 Sequoia compatibility issues - Able to unlock formulas and add filters as req...
Ongoing SEO work for to improve website ranking and traffic. Thank You!
On going SEO work for to improve website ranking and traffic. Thank You!
On going SEO work for to improve website ranking and traffic. Thank You!
I'm looking for a Power BI expert to analyze my sales data for me. The data is stored across Excel files and Cloud storage, so familiarity with these sources is crucial. Your tasks will include: - Importing and cleaning the data from Excel and Cloud storage - Conducting in-depth analysis to uncover sales trends and insights - Visualizing data in a clear and engaging way Skills and experience ideal for this job: - Expertise in Power BI - Strong data analysis skills - Experience working with sales data - Proficiency in using Excel and accessing Cloud storage - Ability to present data in a clear and engaging manner
Need to build this homepage in Elementor Hello theme
I'm looking for a Google Sheets expert who can design scripts and custom functions to automate data manipu...scripts and custom functions to automate data manipulation and analysis, generate automated reports and integrate with internal data sources. Key Responsibilities: - Create Google Sheets scripts and custom functions to handle large datasets and perform complex calculations. - Automate the process of data manipulation and analysis. - Generate automated reports. - Integrate data from internal spreadsheet sources. Ideal Skills: - Proficient in Google Sheets, including script writing and custom function creation. - Strong understanding of data manipulation and analysis. - Experience with automating reporting processes. - Ability to handle large datasets and perform comple...
I need an SEO expert to help increase my website traffic primarily through link building. The ideal candidate will have extensive experience and proven track record in: - Identifying and acquiring backlinks from industry-specific websites - High domain authority sites - Blogs and forums I am not just looking for improvements in my search engine ranking, but a tangible increase in my website traffic. The successful freelancer will be able to demonstrate how their link building strategy directly correlates with increased site visits.
I have ongoing work related to our previous project 'AIRBNB Image editing'
I'm in need of a detail-oriented support secretary to assist with my weekly Excel report for our various mining exploration projects. The tasks involve basic data analysis and project management. Key Responsibilities: - Data Entry: Accurately inputting project data into the report. - Financial Tracking: Keeping tabs on project budgets and expenditures. - Performance Metrics: Monitoring and recording project performance indicators. Ideal Candidate: - Proficient in Excel with experience in data analysis and project management. - Some familiarity with mining industry terminology. - Excellent attention to detail and good with numbers. Bonus: - Previous experience in mining projects. The task should take around 3-4 hours each week, with the report needing to be complete...
I'm looking for a skilled frontend developer with expertise in Microsoft Excel. The primary task will involve creating a frontend that interacts with Excel for report generation. Ideal Skills: - Proficient in frontend development - Extensive experience with Microsoft Excel - Strong understanding of report generation processes in Excel Please note, the specific data types for the reports and the frontend framework have not been predetermined, so flexibility and adaptability are key. I look forward to your bids.
I'm looking for a skilled frontend developer with expertise in Microsoft Excel. The primary task will involve creating a frontend that interacts with Excel for report generation. Ideal Skills: - Proficient in frontend development - Extensive experience with Microsoft Excel - Strong understanding of report generation processes in Excel Please note, the specific data types for the reports and the frontend framework have not been predetermined, so flexibility and adaptability are key. I look forward to your bids.
I'm looking for a talented developer to create a custom Windows program that can correct postal codes for a ...capabilities. Key Requirements: - The program should access addresses and postal codes for all countries. - It should be able to find and replace incorrect or misspelled postal codes based on provided addresses. - The input will be an Excel file containing customer data, including name, address, postal code, phone number, and email. - The program should output a corrected version of the input file. Ideal Skills: - Proficient in Windows program development. - Experienced in creating GUI and CLI. - Familiar with API integration. - Knowledgeable in handling Excel files in programming. Please note, I'm open to proposals for implementing this via a bot, and...
...programs: I have become proficient in using programs such as Microsoft Word to formulate documents, Excel to innovate data and accounts, and Outlook to innovate email and appointments. - Accuracy and speed: The ability to transfer information with high accuracy and amazing speed, including the number and reason. - Dealing with data: I learned how to analyze data in ways that make it easier for users to access basic information. - Effective communication: Designing work environments that require effective communication with different departments and teams, which leads to improving my management and coordination skills. As a result, I believe that my experience in information sources enables me to excel in the field, and I am always improving skills and learning n...
We are seeking someone to develop an AI-driven ...user and performance feedback. 7. Compliance and Ethical Considerations: - Ensure adherence to all relevant investment regulations and compliance requirements. - Implement mechanisms to minimize biases in decision-making. Technical Requirements - Utilization of natural language processing (NLP) for understanding and generating human-like text. - Integration with financial data uploaded in excel - Scalability to accommodate additional features or a growing dataset. - Please provide an estimated timeline for project completion, including key milestones. - Include budget for the project, breaking down costs related to development, testing, and any additional resources. - Recommendations for development methodologies and tools t...
I'm looking for a meticulous data entry professional to assist in creating a new database. The project will involve: - Entering mixed data (both text and numerical) from various digital files, such as PDFs and Word documents, into Excel - Ensuring accuracy and consistency to build a reliable database Ideal candidates should be proficient in Excel, familiar with data entry best practices, and able to handle mixed data types with ease and precision. Experience working with digital files and creating databases is a plus. Your attention to detail will be crucial in making this project a success.
Hello! I came across your request for an Excel expert skilled in dashboard creation and automation, and I’d love to assist you. With extensive experience in Excel, I specialize in creating professional dashboards, streamlining data processes, and implementing automation to make workflows efficient. I thrive on problem-solving and can handle tasks from scratch to ensure the final output meets your exact needs. Let me know how I can contribute to your project and discuss any specific requirements you have. Looking forward to collaborating with you. Best regards, Nilesh Diwane
I need assistance with a data entry project involving mixed data types. The data is currently stored in online databases and needs to be accurately entered into an Excel spreadsheet. Ideal Skills: - Proficient in data entry - Experience with Excel - Attention to detail to ensure data accuracy Please note that the data types are mixed, so you should be comfortable handling both text and numerical data. Approximately 10,000 entries will need to be done at the earliest from individual 10,000 individual PDF files.
I'm looking for a freelancer to assist with data entry into a spreadsheet. The data is primarily numerical and will be sourced from scanned documents. Ideal skills and experience include: - Proficiency in Excel and other spreadsheet software - Keen attention to detail to ensure accurate data entry - Experience working with numerical data - Ability to handle and process scanned documents - Good time management skills to meet project deadlines.
...Vendor/contractor database for outsourced maintenance or repairs. • Assign tasks to staff/vendors and track progress/costs. 8. Advanced Analytics • Occupancy trends, vacancy patterns over time. • Maintenance cost analysis (by property/unit). • Potential for predictive insights (rent forecasting, AI-driven maintenance). 9. Import/Export & Data Migration • CSV/Excel bulk-import for existing records (properties, tenants, etc.). • CSV/Excel export for accounting, sharing with partners, or offline analysis. • Simple data migration tools to ease transition from legacy systems. 10. Security & Compliance • Role-based access control, encrypted credentials, and secure endpoints. • Audit logging (track who edited what ...
I need a UAT tracker created in Microsoft Excel based on provided user test scripts. The tracker should include a Summary Dashboard and categorize test scripts by module. Key Requirements: - Create a UAT tracker and Reporting Tool in Microsoft Excel. - Include a Summary Dashboard. - Categorize test scripts by module. Ideal Skills: - Proficient in Microsoft Excel. - Experience with User Acceptance Testing (UAT). - Ability to create comprehensive dashboards.
...[Specify the data fields you need, e.g., Seasons, Matchday, Results, Match Summary, Opta Points, Match Details, Venue, Attendance, Referee, date, Goal Assist, Cards, Cross ,Foul won, Foul conceded, Goal/Own Goal, Interception ,Offside, Pass, Penalty (Won, Conceded and Taken), Shot, Shot on target, Shot off target, Tackle, Save, Penalty Save] 3. The data should be delivered in [desired format, Excel, CSV]. 4. Ensure the script is reusable for future updates and scraping. 5. Follow best practices for web scraping, including respecting the website's terms of use. **Skills Required:** - Web scraping (e.g., Python with BeautifulSoup, Selenium, Scrapy). - Data cleaning and formatting. - Automation and script optimization. Deadline: [31-1-2025]....
Project: Correlating Inter-Account Transfers and Transaction Analysis Objective: To analyze and correlate inter-account transfers across multiple bank accounts, match transactions that flow from one account to another, and reconcile these with descriptions of the source, origin, and purpose of funds provided in previous submissions. Scope of Work: Data Consolidation: Compile transaction data from all provided bank accounts (FNB, Bidvest, etc.) into a unified format for analysis. Inter-Account Matching: Identify and correlate transfers between accounts (e.g., Account A to Account B) by matching amounts, dates, and any available references. Flag any unmatched or ambiguous transactions for further review. Transaction Categorization: Use the previously provided descriptions (shared w...
