Excel vba programming for dummies jobs

I need a master Excel spreadsheet designed and populated with data from financial documents I will provide. This will include a master page produced from all the data on the separate tabs. - Data Types: The project primarily involves working with financial data, specifically tracking revenue and expenses. - Update Frequency: The data will need to be updated monthly. Ideal skills for this job include advanced Excel proficiency, experience with financial data, and the ability to create clear and comprehensive master spreadsheets. Please provide examples of similar projects you've completed in the past. Each sheet will total and feed into the master page. I would like reports ideally that can be run on total expenses or revenue in a time period as well as ratios...

I need a Node.js based proxy server for mobile devices to monitor traffic. This proxy should catch both HTTP and HTTPS requests and responses, capturing full packet data. Security is paramount for this project, so the proxy should implement SSL/TLS encryption, IP whitelisting, and various authentication mechanisms. Ideal Skills: - Proficient in Node.js - Experienced in network programming - Understanding of mobile network characteristics - Knowledge in implementing security features in proxies

...MS Access database to manage and track transfers between my bank accounts. Currently, this data is being tracked in Excel, and I'm looking for a more efficient and organized way to handle this. Key Features: - The database should capture essential data fields for each transaction. These fields include: - Account number - Amount - Date - description - some sums formulas The ideal freelancer for this project should have extensive experience with MS Access, and a proven track record of creating databases for financial transactions. They should also have excellent skills in data organization and management. Importing Data: - Currently, I am entering the data from Excel into the database manually and copy paste from bank website. Th...

I am looking for a skilled writer with a strong understanding of software development and experience in writing for a technical audience. The task involves creating a 2000-word technical article focused on software development, with the primary objective being to educate readers on various programming languages. The article should: - Be written in a similar style to the example provided () Please include relevant writing samples and explain why you are a good fit for this project.

I need a C++ expert to help with debugging my Telecom-based application that incorporates GPS functionality. Project is based on C++ code for Telecom + GPS programming. We are looking for an experienced freelancer to review and fix a C++ codebase developed in the Arduino environment. The project involves programming an ESP32 to work with a GPS correction system using NTRIP and communicating with the ZED-F9P module via I2C. Code is ready but we are having some issues, and they must be fixed. - we have the project hardware done, just need to get the code fixed, we can test locally after changes. Project Overview: The system receives GPS correction data via NTRIP using an internet connection through either Wi-Fi or mobile data. These corrections are then tran...

We are looking for a skilled VR/AR/XR programmer and designer to create a full application for the Meta Quest 3 and develop another 360° experience, targeting all audiences. First Experience: Interactive Objective: Design an immersive 3D environment that reflects the aesthetics of the Islamic world and nature, with a focus on presenting Juz' Amma (the 30th part of the Quran) in an engaging and innovative way. Features: Ability to interact with the environment and change viewing angles. Display Quranic text clearly, synchronized with the provided audio recording. Design interactive elements that encourage exploration and learning. Second Experience: 360-Degree VR Video Objective: Produce 360-degree videos for each Surah (chapter) of the Quran. Features:...

I need an experienced Moodle developer to integrate a working skeleton plugin code (a chatgpt plugin) into another functioning plugin which currently provides hints from user submissions to VPL. Ideal Skills: - Extensive experience with Moodle 4.x - Proficient in plugin development and integration - Familiarity with chatgpt plugins - Understanding of VPL (Virtual Programming Lab) - Excellent problem-solving skills

As a small consulting firm in Europe, we are seeking a GenAI and Python expert for an important mission with one of our clients. This project involves extracting specific numerical data from tables in .pdf files, and subsequently importing these data points into an Excel sheet. The Excel sheet will also require some statistical calculations. Given the nature of this task, the ideal freelancer should possess: - Proficiency in Python and GenAI techniques, particularly for data extraction and manipulation - Strong statistical analysis skills with experience in Excel - Ability to work with diverse and inconsistent data formats The PDF files vary in structure, hence the freelancer must be adaptable and capable of handling a mix of varying formats. Please no...

I'm seeking a professional Excel expert to create a tailored budget template for our corporate needs. The template will primarily be used for generating quotes. Key Requirements: - Incorporation of our company logo and branding into the template - Use of our specific color scheme throughout the template Ideal Skills: - Advanced Excel proficiency - Experience in corporate finance and budgeting - Strong understanding of corporate branding and design This project requires a keen attention to detail, both in terms of financial accuracy and visual presentation. Please include examples of similar projects you've completed in your bid.

...pipeline issues, and collaborate with cross-functional teams to support data integration and analytics for the EDW program. Job Description Responsibilities: Design, develop, and implement ETL processes on Google Cloud Platform (GCP) to ensure efficient data extraction, transformation, and loading for EDW program. Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions on GCP. Utilize Google Cloud services, such as native services, BQSQL, DAG, Cloud composer, Dataflow, and Cloud Storage, to optimize data processing and storage workflows. Create and maintain documentation for ETL processes, ensuring clarity and transparency for future reference and troubleshooting. Perform data profili...

I need an Excel expert to refine my database tracking patient referrals to a hospital. The database includes tracking patient specialties, procedures, price (income), and referral sources. Key Tasks Include: - Helping with Excel formulas - Organizing the data for clarity and efficiency - Linking the data appropriately The project will culminate in creating a dashboard with visual charts and graphs. The ideal freelancer should have a strong background in data analysis and visualization, and be proficient in Excel. Experience with creating dashboards in Excel is a plus.

Here is the required knowledge for the project into English: 1. Process and Command Management Know how to execute system commands using system calls like fork(), execvp(), and manage child processes with wait() or waitpid(). Handle errors using errno to diagnose execution problems. 2. Time Management Use the <time.h> library to measure and manage execution delays and prevent time drift. Implement precise pauses in execution using usleep() or nanosleep(). 3. File Handling Read from and write to files, particularly for a configuration file or a log file. Implement simple syntax parsing to interpret a custom configuration file. 4. System Programming Understand Unix/Linux system calls (e.g., to access directories or set an execution path). Handle signals to interru...

I need a talented individual to create a system for my Excel workbook that intelligently transfers mixed data (text and numbers) from one sheet to another. The data transfer should occur daily, triggered by updates to the data. Key Requirements: - Proficient in Excel with extensive experience in creating complex formulas and logic. - Familiarity with VBA or similar programming languages for automating tasks in Excel. - Ability to understand and manipulate mixed data types. - Experience with setting up systems for daily data tracking and transfer. Ideal skills include attention to detail, problem-solving abilities, and a strong understanding of data management. Please apply if you can help me streamline my data management process.

I need assistance with my Excel Master Workbook. The project involves transferring generic data from the Master sheet into specific tables in another sheet within the same workbook. Details: - The data is dynamic and will change daily based on updates in the main sheet. - The method for matching the data to the specific tables in the other sheet varies. Ideal Skills: - Proficiency in Excel - Experience with data manipulation and transfer - Ability to work with dynamic data - Attention to detail

I'm in search of a skilled AI developer to create a highly advanced AI assistant capable of autonomous task execution. Key Responsibilities: - The AI should be able to autonomously handle various tasks including scheduling appointments, sending emails, managing to-do lists, and even programming and deploying custom software to assist the user. - This AI assistant should be omni-present and aware of every context the user has granted it access to, including work-related, personal, and health and wellness tasks. Ideal Skills: - Proficient in AI and machine learning - Experience in task automation - Software development skills - Understanding of context-aware computing Please only bid if you can demonstrate relevant experience and provide examples of similar projects you'...

i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.

...need assistance in fixing and enhancing my Excel reports that are generated daily, weekly, monthly, and yearly. 1. Please fix the Stock Performance tab with Top 20 & Bottom 20. Its never worked when 2 or more companies have the same % gain/loss. 2. Commodities & Chart_All_Commodities, I changed the commodity on a few of them including Antimony, Germanium, Gallium, Platinum & Niobium. This seems to work on the Commodities tab, but I have to manually update the Chart_All_Commodites Tab, please fix this. 3. Please add 5 new Blank Commodities & Project Location Areas so it allows me to add specific ones in that field and it automically updates to the Chart_All_Commodities & Chart_All_Project Location Area too 4. Can you add a filter by Market Cap for...

...outsourcing decisions, providing actionable insights via a user-friendly dashboard for both operations and sales teams. Project Deliverables: Data Integration and Preprocessing: Data Sources: Historical shipment data (2 years). Real-time shipment arrival data from OTM (arrival dates, shipment types, volumes). External factors (holidays, weather, geopolitical impacts). Tasks: Clean and preprocess the dataset: Handle missing values, normalize data, and perform feature engineering. Generate derived features such as: Day-of-week trends. Seasonality indicators (e.g., peak/off-peak periods). Shipment type classifications (high-volume vs. low-volume). Ensure all datasets are integrated into a unified format suitable for modeling. Forecasting Model Development: Buil...

I have over 5000 documents, primarily in PDF format, that require document processing. I need a python script that can sift through these documents to extract allergens and nutrition information, and then compile this data into separate CSV files. Key Requirements: - The documents include not just standard PDFs, but also Excel and Word files. Some of these are scanned PDFs that contain both images and text. - The script needs to be able to interpret and extract relevant information from all of these formats. - The analysis needs to be performed on documents written in English. Ideal Skills: - Proficiency in scripting languages such as Python. - Experience with data extraction and analysis from various document formats. - Familiarity with handling and interpreting scanned documents...

I'm looking for an Excel expert to create a comprehensive Mess Management Excel sheet. Requirements: - Tracking of student Mess fees - Fee calculation and tracking functionalities Ideal Skills and Experience: - Proficiency in Excel - Experience in creating expense tracking systems - Ability to incorporate complex fee calculations Please include examples of similar projects you've completed in your bid.

I'm looking for a proficient Excel expert with strong macro programming skills to create a comprehensive Excel sheet for processing data from my securities trading reports and FX market data. This is for the purpose of tax filing. I just update the FX page and the trade data and it produces the pnl sheet for me. I’ve attached the sheet with the required output. I need a macro to automate this sheet for me. Key Requirements: - The Excel sheet must be able to process various elements from my trading reports, including trade dates and times, transaction amounts, and securities identification. - The sheet will also need to incorporate data from FX market feeds. Ideal Skills: - Advanced Excel skills ...

...seeking an experienced Shopify developer to create a custom app for our Shopify store based on our existing Laravel and Vue js 2 project. The ideal candidate will have a proven track record of developing successful Shopify apps actively listed on the Shopify App Store. Key Responsibilities: ================ -- Design and develop a custom Shopify app tailored to our specific requirements. -- Ensure the app is scalable, secure, and adheres to Shopify’s app development standards. -- Provide documentation and post-development support for the app. Requirements: =========== -- Strong experience in Shopify app development. -- Must have at least one active app on the Shopify App Store (please provide links). -- Proficiency in programming languages such as Laravel, R...

I'm in need of a skilled developer experienced with Solana to help me create a m...experienced with Solana to help me create a meme token with some exciting features. Key Responsibilities: - Smart Contract Creation: You'll be tasked with creating a smart contract for the meme token that is robust, efficient, and secure. - Implementing Specific Functionalities: The smart contract needs to support token distribution, minting and burning capabilities, as well as staking and rewards. Ideal Skills: - Proficient in Solana development and smart contract programming. - Experience with creating meme tokens on Solana. - Strong understanding of tokenomics and community engagement strategies. This project is perfect for someone who enjoys fun, creative projects and ...

I'm looking for a talented web scraper who can efficiently extract data from a specific website. The project involves navigating through pagination and scraping data from approximately 5,004 records. Requirements: - The data to be scraped is primarily text, specifically contact information from each record. - The scraped data needs to be delivered in a CSV file. Ideal Skills: - Proficiency in web scraping tools and programming languages (like Python, BeautifulSoup, Scrapy etc.) - Excellent attention to detail to ensure accurate data collection. - Previous experience in scraping websites requiring pagination and search inputs.

I have 5 openings for different combinations of LLMs for PST Time, Night Shift. Open positions: - LLM - Lua Developer - LLM C# Developer - LLM - Scala Developer - LLM - Haskell Developer - LLM - Bash/Shell Developer Developers will be working on: - Writing new code - Maintaining existing code - Debugging and fixing issues Ideal candidates should have: - Experience in respective programming languages - Night shift availability on PST time - Problem-solving skills The current requirement is for a combination of LLM Lua and LLM C#. Experience with specific frameworks or libraries for Lua or C# is not a must but would be a plus.

I'm seeking an experienced Excel specialist to create a software-based Gantt chart for me. This chart should incorporate task dependencies, progress tracking, and resource allocation capabilities. Key Requirements: - Proficiency in Excel with a strong understanding of its advanced features. - Experience in creating interactive, software-based Gantt charts within Excel. - Ability to incorporate task dependencies, progress tracking, and resource allocation into the Gantt chart. Ideal Skills: - Advanced Excel skills - Project management software experience - Strong attention to detail - Excellent communication skills

I am looking for a skilled professional with experience in AI and CRM systems to create a bot for my Kommo CRM. Key Features: - The bot should primarily function to answer frequently asked questions from clients. - It should be equipped with Natural Language Processing capabilities to understand and respond to messages in a human-like manner. - The bot needs to be knowledgeable about the product details of my business to provide accurate information to clients. - It should be able to respond instantly to client messages, ensuring no delay in communication. - The bot should also have the capacity to move clients between different sales funnels based on their interactions. Ideal Skills and Experience: - Proven experience in developing AI bots for CRM systems, particul...

I am in need of a skilled Excel professional who can perform comprehensive financial analysis on my personal finance data. Key Responsibilities: - Analyze my personal finance data using Excel - Provide insights on key financial metrics - Build template for tracking personal finance Ideal Skills: - Proficient in Excel with a strong understanding of data analysis techniques - Experience with Finance formula like : Present Value, Future value, formats - Able to present complex data in a clear and concise manner

...and use for profit for my business and that I own the copyrights to all work it creates for my business. Create a platform that replaces actors in live-action footage with CG characters. The system should automate body motion capture, facial animation, and scene integration using open-source or one-time purchase software (no subscriptions). All source code programs and AI's and software programs used to build my software must allow my software to be used for profit and for my business. Key Requirements: 1. Motion Capture from Video: Track actor body movements and facial expressions from video. Using tools that have no subscriptions. 2. Facial Expression Capture: Automate facial animation using for real-time facial tracking. 3. Seamless CG...

...create a software for registering outdoor objects. Login, forgotten password, selection of objects, register objects, with type, size, GPS coordinates, images, notes and condition. Report module, import and export from other programs, admin, register users, access profile, file archive ++ It is important that you have done similar things before, so you can become a good team player to get an exceptionally good user-friendliness and can give us input, selection of programming language and platform. We want an estimated time, but we have an hourly price since there will certainly be changes. It should also be adapted so that we can use a pad out in the field to make the report at the object and take pictures. We will feed GPS coordinates manually, but must include a map from...

...hours per day(Normal IST shift) I'm looking for skilled React Developers who are well-versed in JavaScript. You should have a solid grasp of JavaScript fundamentals and React development practices. Together, we will: - Develop and maintain scalable, high-performance React applications. - Ensure seamless integration of UI components with backend services. - Optimize application performance while maintaining robust code quality. - Solve complex challenges using advanced JavaScript concepts. - Collaborate with cross-functional teams to deliver high-quality solutions. Essential skills include: - Mastery in JavaScript and React. - Proficient in Prototypal Inheritance, Event Delegation, Closures, ES6+, DOM Manipulation, and Functional Programming. - Ability to work wit...

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

I'm seeking a skilled PLC programmer for a project involving a strain gauge load cell, Siemens HMI, and a Siemens servo motor. The goal is to create a PLC program that facilitates the integration of these components for weight matching purposes. Key Responsibilities: - Develop a PLC program that integrates the load cell and HMI input. - Control the Siemens servo motor for precise weight matching. Ideal Skills & Experience: - Proficient in Siemens HMI systems and PLC programming. - Experience with strain gauge load cells. - Familiarity with Siemens servo motors. - Prior experience in developing weight matching systems will be an advantage.

I'm looking for a Python expert to help me automate my trading strategy, specifically for Zerotha entry and exit points. I have some ideas but need a skilled professional to assist in transforming these into a working algorithm. Ideal Skills: - Python programming - Automation - Understanding of trading strategies Experience: - Prior experience in trading automation preferred - Familiarity with Zerotha platform is a plus

I need help with creating a detailed report from my Excel file. The report should be structured with sections and include pie charts. Additionally, it should contain a comparative analysis. Ideal Skills and Experience: - Proficiency in Excel - Data Analysis - Report Writing - Chart Creation

I'm seeking a professional with expertise in supervised machine learning, specifically in building a classification model. Ideal Skills: - Strong background in machine learning, particularly supervised learning - Proven experience in developing classification models - Proficiency in Python, R or similar programming languages - Familiarity with machine learning libraries such as Scikit-learn, TensorFlow, etc. Please provide examples of similar projects you've completed in your proposal.

I'm looking for a skilled programmer to create a bot for me that interacts with the Axie Infinity and SkyMavis Marketplace. This bot should automatically buy Axies and automatic mints according to my specifications. The software should run on Windows, and I will provide specific metrics for the bot to use. Key Requirements: - Strong programming skills - Experience with smart contracts - Ability to create functional, fast software without a front-end - Delivery of all code at project completion The bot should log errors and exceptions to a file as it runs.

Hi, I’m looking for a freelancer to help me design two PCB variants for a stair-lighting controller using a 38-pin ESP32 Dev Module (USB-C). This system will power and control WS2812 LED strips and incorporate multiple sensors for an intelligent lighting setup. Below is an overview of what I need, followed by detailed requirements. At the end, I’ve included links and attachments referencing a similar board and my own sketches. >>> Overview of the Project 1. Goal: Create two PCB variants (Version A and Version B) of a stair-lighting controller for WS2812 LEDs: - Variant A: 2 LED outputs, - Variant B: 16 LED outputs. 2. Board: Uses an ESP32 Dev Module (38-pin, USB-C) mounted on female headers (no extra programming buttons neede...

I'm looking for an expert in robotics to integrate a set of developed manipulation-focused solutions onto a robotic platform designed for space. This platform will primarily be used for conducting scientific experiments. Key Requirements: - Expertise in robotic systems, particularly those designed for manipulation tasks. - Experience working with or understanding the unique challenges of space environments. - Ability to implement and integrate developed robotic solutions onto a platform. Ideal Skills: - Proficiency in robotics software and programming. - Strong understanding of manipulation-focused robotics. - Experience in designing or working with space-capable robotic systems. Tasks: - Integrate developed manipulation solutions o...

I need an experienced freelancer who can convert my .xlsx Excel sheet into Avery format address labels. Ideal Skills: - Proficient in Microsoft Excel - Familiar with Avery label layout templates - Attention to detail for accuracy

I need help with my linear programming assignment. The assistance should primarily focus on solving problems related to linear equations and optimization problems. Ideal skills and experience: - Strong understanding of linear programming - Experience in solving complex linear equations - Proficient in tackling optimization problems - Prior teaching or tutoring experience in this field

...standalone hardware without internet connectivity and support a cloud architecture for at least 1000 concurrent users. The architecture must address Big Data's Velocity, Volume, Value, Variety, and Veracity while ensuring security compliance. (a) Model will be trained on large amount of variety of data such as documents, handwritten text, excel sheets, power point PPTs, word documents, BRs, equipment manuals, IR images, reports, letters, faxes, flow diagrams, charts, block diagrams, videos, training books, medical reports (all variants of medical reports, data and scanned copies). (b) The format of documents, manuals, reports, letters, faxes will not be restricted to readable PDF format and the solution should cater for all possible formats. Accordingly, so...

...operating, AI-integrated platform. Implement compliance features for data protection (e.g., GDPR, CCPA) and industry regulations. Build tools for monitoring, reporting, and managing compliance violations. Create systems for user consent management and privacy policy enforcement. Key Features to Implement: Data Privacy and Protection: User data encryption, secure storage, and controlled access. Automated user data requests (e.g., access, deletion) in compliance with regulations. Regulatory Adherence: Compliance dashboards for internal tracking and reporting. Real-time monitoring of platform activities to detect violations. Audit Logs: Maintain detailed logs of user activities for audits and legal inquiries. User Consent Management: Systems for m...

I need help with capturing data from a website. The data is displayed in a table format below a chart for a particular facility. I want to capture monthly data for all time periods for all facilities on the website. Key Details: - The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of use. Ideal skills for this project include: - Proficiency in Excel, particularly with creating and using macros. - Experience with data extraction from websites. - Attention to detail to ensure all data is accurately captured. Budget is $50

I'm looking to scrape 10000 restaurant websites in Australia to analyze their payment gateways. The primary pur... The primary purpose of this task is to conduct competitor analysis. I also need to gather the contact information from these sites. The ideal freelancer for this task should be skilled in web scraping, data analysis, and have a keen eye for detail. Requirements: - Extensive experience in web scraping - Proven track record in data analysis - Ability to gather and organize contact information - Skills in competitor analysis - Attention to detail The scraped data should be provided in Excel format. Please ensure that the payment gateway details are included as part of the contact information. Please organize the scraped data in an Excel file fo...

I am seeking assistance with a web application. The specific purpose of the application has not been defined yet. You should be able to work with any major programming language or framework and adapt as necessary. Ideal Skills: - Web application development - Proficiency in multiple programming languages and frameworks - Adaptability to work with undefined project parameters Experience: - Previous work on diverse web applications - Ability to handle project scope changes - Experience in collaborating on web application development.

I'm seeking a freelancer to design an Excel reporting template to track our membership enrollments. The template will primarily handle registration data, specifically focusing on membership sign-ups. Key Features: - Automated Calculations: The template should perform relevant computations automatically. - Visual Charts and Graphs: The template must convert data into easy-to-understand visual representations. - Data Filtering and Sorting: The template needs to facilitate easy sorting and filtering of data. Ideal Skills: - Proficiency in Excel, particularly in creating complex templates. - Experience with data visualization - Strong understanding of membership enrollment processes. With this project, I hope to simplify our reporting process and enhance our data interpre...

...server-side infrastructure for our feature-rich platform. Your role will involve creating scalable, secure, and efficient back-end systems that integrate seamlessly with the front-end and external services. Scope of Work: Platform Overview: Develop and maintain back-end systems for 40 platform sections. Ensure seamless data handling and integration with the front-end. Implement secure APIs and services for features like job listings, user dashboards, local services, and gig management. Core Features to Develop: Authentication and User Management: Secure user registration, login, and role-based access control (e.g., employers, freelancers, admins). Job and Gig Listings: API support for advanced search, filtering, and listing updates. Payment Integration: Su...

Mortgage Advisor (VA for a Dubai based entity Key Responsibilities * Analyze client financial information to determine mortgage eligibility and assist in the preparation of mortgage quotations. * Guide clients through the end-to-end mortgage application process, including rigorous follow-ups with clients and banks until loan disbursement. * Create and manage LinkedIn page of the company through advertisements and posts to promote the company’s mortgage services to ensure lead generation through Linkedin. * Organize and schedule appointments with real estate agents mortgage lenders, solicitors and clients. * Develop and maintain professional relationships with real estate agents and potential partners * Create and Manage the company’s Instagram page. * Support in addit...

Dashboard Creation We are seeking a highly skilled and experienced Excel Expert to create professional and visually appealing KPI Dashboards in Excel. The ideal candidate should have extensive knowledge of advanced Excel functionalities and a strong ability to translate data into actionable insights. Proficiency in Google Sheets is a plus. Key Responsibilities: Design and develop customized KPI Dashboards in Microsoft Excel based on business requirements. Collaborate with stakeholders to identify key performance indicators and define dashboard objectives. Use advanced Excel formulas, functions, and tools (e.g., VLOOKUP, INDEX-MATCH, SUMIFS, Pivot Tables, etc.) to process, analyze, and visualize data effectively. Create dynamic and interactive dashboards ...