Excel vba create monthly sheets jobs

I'm seeking a project manager with expertise in performance tracking to help me customize a scorecard template I have for tracking the performance of individual project managers. The template currently tracks all projects per project manager for the current year. Key Responsibilities: - Adjust the layout/design of the existing template t...Responsibilities: - Adjust the layout/design of the existing template to better suit our needs - Ensure the scorecard effectively tracks key performance indicators: task completion rate, time management, and quality of work Ideal Skills and Experience: - Previous experience in project management - Strong skills in data analysis and performance tracking - Proficient in design/layout adjustments of Excel or similar templates - Excellent atte...

...visualizations are recommended: ________________________________________ 1. Real-Time Occupancy Data • Bar Chart or Gauge Chart: Show the current number of people in the office or at desks. • Heatmap: Display real-time occupancy across different zones or floors of the office. ________________________________________ 2. Historical Trends • Line Chart: Show occupancy trends over time (e.g., daily, weekly, or monthly). • Area Chart: Visualize peak and off-peak occupancy periods. • Calendar Heatmap: Highlight occupancy patterns by day or week. ________________________________________ 3. Space Utilization Metrics • Stacked Bar Chart: Compare utilization rates of different desks, rooms, or zones. • Pie Chart: Show the percentage of utilized vs. underu...

I need to create a CRM to manage drivers, trucks and services (trips). Currently we manage everything on spreadsheets. Core Features: Database Management Store, add, remove, and edit records for: Drivers (personal details, license, certifications, documents) Trucks (model, plate number, maintenance records, documents) Services (Trips) (routes, assigned driver & truck, client, pricing) Clients (contact details, service history, payment status) Service (Trip) Management Add new trips and assign: Driver Truck Client Set trip price and payment terms Payment Tracking Client Payments: Full and partial payment tracking Payment status indicators (Paid, Pending, Overdue, partial) Driver Payments Track payments to drivers (e.g., per trip, weekly/monthly salary) Truck Expenses...

I am looking for a data entry operator who can efficiently handle text data sourced from online forms. The data will need to be entered into Excel spreadsheets. The ideal freelancer for this job should: - Have excellent attention to detail - Be proficient in data entry - Have experience working with Excel - Be able to work independently and meet deadlines - Possess fast and accurate typing skills Please bid if you're skilled and experienced in this type of work. The expected weekly volume of forms to be processed is between 100 and 500.

I am looking for a skilled freelancer who can help me with specific formulae in Google Sheets to facilitate my financial calculations related to Medicaid billing and payments.

I'm looking for a professional who can help me develop a market risk model monitoring dashboard. This dashboard will primarily be used by our Fund Manager to keep tabs on our public, privet funds. Key Features of the Dashboard: - Monitor key metrics such as VaR (Value at Risk), Exposure Limits, and Liquidity Ratios. - Provide a user-friendly interface for real-time monitoring and li... Exposure Limits, and Liquidity Ratios. - Provide a user-friendly interface for real-time monitoring and limit checking. - Include any breaches in predefined risk thresholds. Ideal Skills and Experience: - Strong background in finance and risk management. - Proven experience in developing dashboards. - Prior work with public and privet funds is a plus. The dashboard should be developed using Excel...

For some reason, I'm unable to download the last 10 years of OHLC Nifty 50 data from my Fyers account. I need a professional to access my Windows computer, troubleshoot the issue, and download the data in Excel format. Key Requirements: - You must be able to remotely access a Windows computer - Proficient in using Fyers and troubleshooting data download issues - Able to download data in Excel format Ideal Skills: - Experience with financial data and stock market - Proficiency in using Excel - Good troubleshooting skills

I'm looking for a professional who can develop a comprehensive, hands-on video tutorial course on Redhat Linux 9. The target audience is at an intermediate level, so the content should challenge them without being overwhelming. Key topics to cover include: - Installation and setup - System administration - Networking and security - RHCSA and RHCE Topics v9 The course should be over 12 hours long once edited, and I will require full ownership rights upon completion. Ideal candidates will have extensive experience with Redhat Linux, teaching, and video production. A prior portfolio of similar projects will be highly advantageous.

Looking to Setup WhatsApp Business API for our e-commerce platform. Want to send notification , receive photo video with data from the vehicle info ,record data in excel, find info using number plate finder api, and generate QR and provide delivery tracking. Also need to send invoice and Any one already worked on WhatsApp Business API and understand it at deeper level should only bid for this project.

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: * Call logging: The tracker should allow for detailed logging of calls made by representatives. * Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: * Proficiency in Excel and data analytics * Experience with creating tracking systems * Understanding of sales and call metrics

I am looking for a freelancer who can help me find an entry-level Data Analyst or Engineer role in the USA. I am particularly interested in the technology sector, but I am open to any type of technology ...am looking for a freelancer who can help me find an entry-level Data Analyst or Engineer role in the USA. I am particularly interested in the technology sector, but I am open to any type of technology company, be it a startup, medium-sized company, or a large corporation. Skills and Tools: The ideal role for me would require proficiency in Python and SQL, as well as experience with Tableau and Excel, and PowerBI. I am looking for a freelancer who is well-acquainted with the tech job market, has great networking skills, and can help me land a position that matches my skills and as...

I need a spreadsheet expert to help me analyze data related to divorces. The primary purpose of this project is data analysis. Ideal skills and experience for the job: - Proficiency in Excel or similar spreadsheet software - Experience with data analysis - Ability to identify trends, patterns and insights from data - Strong attention to detail

I need an Excel-based dashboard to monitor a maximum of seven items across 17 construction contractor packages. Key Data Points: - Budget and expenses - Change orders - Weekly progress reports per contractor - Resource allocation across all packages - Schedule tracking for each contractor package - Quality control measures and results Ideal Skills and Experience: - Expertise in Excel - Experience with data visualization - Familiarity with construction project tracking The dashboard should be easy to use, visually clear, and capable of tracking the aforementioned data points efficiently. Please use charts and graphs for the visualizations. Please use bar and line charts for the visualizations. Please include data filtering features to allow users to view specific subsets o...

I'm seeking an Excel expert with a solid background in accounting to enhance and redesign my current financial dashboard. Your role will involve improving the dashboard's design for better readability, adding insightful analytics, automating processes using VBA where possible, and creating custom visualizations and interactive elements. Key Tasks: - Improve the design and layout of the dashboard - Incorporate more detailed and insightful financial analytics, with a focus on ratio analysis and cost-benefit analysis - Use your expertise in Excel to ensure automation where possible - Design and implement custom visualizations, such as graphs, charts, pivot tables, and trend indicators - Create interactive elements to enhance user engagement with the dash...

I'm seeking a professional to create a Google Form for mixed data (text and numeric) entry. This project involves: - The creation of a Google Form or Web form for data entry. - Utilization of Google Sheets for data processing. - Implementation of coding for comprehensive data analysis. - Implementation of conditional logic to adapt form questions based on responses. - Setting up automatic syncing of form data with Google Sheets. - Thorough testing of the created Google Form or Web form for functionality and errors. - Setup of custom notifications or alerts based on specific form submissions. - Incorporation of user authentication to ensure data security. - Ensuring the form is responsive and works well on different devices. - Providing user training materials or...

...developer to create a WebApp for our Freight and Logistics company. This application will be responsible for collecting customer, job request, and vendor data. It will automatically generate quotations, and integrate with Odoo for seamless output of quotes, invoices, and processing of payments. Key Functions Include: - Form entry for data collection and processing information to output on a dashboard - Basic calculation functions, primarily for freight cost estimation - Integration with Excel to allow for variable data changes - Imitation of a sample WebApp we have, with additional custom features Data to be Processed: - Customer details - Job request details - Vendor details Ideal Skills: - Proficiency in WebApp development - Experience with Odoo integration - Familiar...

...content writing as well. Like social media posting, blog upload on WordPress, etc. If required, we will provide you training as well. Experience: - Relevant experience is a plus - A basic understanding of content creation and the ability to meet deadlines Working Days: - Mon to Sat - 10 am to 7:00 pm ** We always give you 5-star feedback ** We will not create or release milestones in advance. I will make payments on a weekly or monthly basis. ** Maybe Before Award, we will take a small unpaid test. ** Maybe you have to attend 7 days unpaid training before joining. ** bid ONLY if our rate and terms suit you. ** DON'T BID IF YOU'RE WILLING TO WORK 1 WEEK FOR A GOOD REVIEW. This is a full-time position offering ₹10,000/month....

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: - Call logging: The tracker should allow for detailed logging of calls made by representatives. - Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: - Proficiency in Excel and data analytics - Experience with creating tracking systems - Understanding of sales and call metrics

I'm looking for an expert in Google Sheets and Apps Script to create a standalone project management dashboard. The dashboard is primarily for task tracking and performance metrics. Key Requirements: - Design a user-friendly, efficient Google Sheets dashboard for project management. - Implement task tracking and performance metrics functionalities. - Use of Apps Script for coding to enhance functionality and ease of use. - Create a standalone dashboard without any integrations with other tools. - Create a google sheet that incorporates google forms for order tracking , execution photos, quality and test results, issues during execution and customer feedback Ideal Skills: - Proficiency in Google Sheets and Apps Script. - Experience in designi...

Monthly ongoing seo for , with weekly work reports Include 300 backlinks and 10-15 keywords included

Create a website that will feature telecom job posting. I am looking to mimic Cabl.com. I do want to be slightly different. I want to have categories for the job postings: business to business, independent contractor, and Employment. The jobs posting would be free to view but would cost for the employer to post the job opportunity. Sub categories would be ones similiar to Cabl.com- cable installers, satellite installers, telco installers, etc. I will prove a list of sub categories once ready. In addition to a list view, I do want a map to display all of the jobs. For example, if an employer posted a job for “independent contractor- fiber splicer- Dallas, Texas”, there would be a color code sequence pin on Dallas Texas to show the job. I also want a page dedicated to &l...

READ FULLY BEFORE BIDDING. My Chrome extension, which is supposed to help me select rows and columns in a Google Sheet and format them for pasting into ChatGPT, is broken. Although I am the owner of the sheet, the extension is returning a "I am not owner" error due to permissions issues. I need a skilled professional to debug and fix the extension for me. Probably less than an hour. $50 is reasonable. I have included a video of the issue. To show you read this and did not auto-bid, but your favorite color in ALL CAPS as the FIRST word in your bid.

I'm looking for a freelancer to create and manage a faceless Instagram page for me. The main goal of this project is monetisation, so the content needs to be engaging and shareable to attract a large audience. Content Type: - The posts should primarily be quotes and text-based posts. - The overarching theme of the posts should be motivation and inspiration. Ideal Skills: - Social media management - Content creation - Understanding of Instagram algorithms - Ability to create engaging motivational and inspirational quotes

I'm looking for a data consultant to help with consolidating and analyzing a large number of Excel spreadsheets. The project involves: - Data Consolidation: Merging data from different spreadsheets into one cohesive dataset. - Pivot Tables: Utilizing pivot tables to summarize and analyze the data. - Lookups: Using lookup functions to cross-reference and find relevant data points. - Splitting of Files: Organizing and splitting data into manageable files. Ideal Skills: - Advanced Excel skills: Proficient in using Excel functions, formulas, and features. - Data Analysis experience: Previous experience in analyzing large datasets. - Attention to Detail: Ability to spot inconsistencies and errors in the data. - Time Management: Capable of working efficiently to meet ...

I'm seeking an expert in Excel who can assist with automating calculations and report generation in my bonus allocation workbook. The project requires the creation of a couple of bar and line charts, as well as help designing a tier-based system reliant on weighted project amounts determined by various financial metrics. Ideal skills and experience include: - Proficiency in Excel with a strong understanding of automation features - Experience with creating and interpreting bar and line charts - Knowledge of financial metrics and their application in project weighting - Ability to design a tier-based system. - Expertise in data visualization techniques The successful freelancer will help streamline my workbook, making it more efficient and user-friendly. The goal is t...

I'm seeking a personal assistant to help manage the bookkeeping for my stock trading account. Key responsibilities include: - Monitor trading activity for recording - Record and reconcile all transactions - Prepare trading journal and stock charts screenshoots - Ensure accurate and ti...data entry or bookkeeping, and excellent attention to detail. They should also be proficient with reading stocks price candle charts, having basic knowledge of stock trading (not mandatory), and proficient in using numerous tool for Visual illustration of trading journal, Microsoft office software with English language as these tasks may also be required. Candidates should be proficient in using Excel for financial record-keeping. The assistant will be required to handle bookkeeping tasks d...

I'm looking for a ChatGPT specialist who can integrate this AI tool into Excel for generating reports based on hospital data. The ideal freelancer for this job should have: - Proficiency in Excel and ChatGPT - Skills in AI integration - Report generation expertise Please note that the specifics of the report content have yet to be determined, so flexibility and creativity will be key to this project.

I need profiles created for individual practitioners at a private practice psychiatric clinic on various medical service sites. The profiles should be made on general health directories and psychiatric specialty sites, with a focus on accuracy and adherence to specific guidelines I will provide. Key Responsibilities: - Create detailed profiles for each practitioner, including their biography, clinic contact details, and a list of services offered - Ensure all information is accurate and adheres to the provided guidelines - Use discretion and judgement to represent the clinic and its practitioners in a professional manner Ideal Skills and Experience: - Familiarity with general health and psychiatric specialty sites - Excellent written communication skills - Attention to detail - Ab...

I am providing 2 month seo service at rate of 3000 monthly

As per your request. Total budget is 6000 inr .now you can accept. And it may take 8 days maximum. Thanks

We are looking for a freelancer to help build a blog focused on self-development and personal growth. The blog will share practical tips on improving self-confidence, generating passive income, and enhancing personal organization. Additionally, there’s an interest in exploring print-on-demand products that complement these themes.

We are looking for a skilled designer to create a compelling ad image (with supporting text) for a Google/Facebook ad campaign. The goal is to generate leads and attract Amazon Delivery Service Providers (DSPs) to try our advanced fleet management software, Fleetour. Requirements: 1.) Target Audience: Amazon DSPs – our solution is tailored to their specific needs. 2.) Brand/Background Info: Use Startseite - as the primary source for product information, brand style, and imagery. 3.) Key Selling Points: - AI-powered fleet management Real-time analytics & route optimization Scalability for Amazon DSPs of all sizes Streamlined operations and cost reduction 4.) Creative Direction: Bold, modern, and professional design Include a clear call-to-action (e.g., “...

Please Sign Up or Login to see details.

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

I am in need of a Google Sheets expert who can assist with creating custom functions and formulas to facilitate conditional formatting and dynamic updates within the sheet. Key Responsibilities: - Develop and implement custom functions and formulas in Google Sheets - Automate various processes using scripts - Ensure effective use of conditional formatting for data visualization and monitoring - Ensure data security and privacy compliance The ideal freelancer will have a deep understanding of Google Sheets and a proven track record of developing complex scripts. Experience with integrating data from Interakt WhatsApp will be an added advantage. Please provide examples of similar projects you have completed in your proposal.

I need assistance with handling customer data. Key Responsibilities: - Data entry - Data analysis - Data cleaning The ideal candidate should: - Be proficient in Excel. - Have experience with data management and analysis. - Be capable of cleaning and maintaining data integrity. Please note that tasks will be primarily focused on customer data.

Seeking Expert Digital Entrepreneur for Profitable Online Business Venture Description: Are you a successful online business entrepreneur looking for your next big opportunity? I'm seeking a proven expert to help build a profitable digital venture with the potential to earn $2,000 - $20,000 monthly. Expertise and track record in one of below: - Verifiable track record of successful online businesses - In-depth knowledge of e-commerce and dropshipping - Experience with digital products (ebooks, templates, software, graphics) - Proficiency in content creation (YouTube, blogging, newsletters) - Expertise in affiliate marketing The ideal candidate will: - Demonstrate a history of achievements in online business - Provide a clear, step-by-step strategy for business growth...

I'm in need of a field verification executive for assisting in conducting residence, office, business and document verification du...cover the following locations: Rajasthan, MP, UK, UP, Delhi NCR. All visits will be supported by visit photographs with Selfee of executive and Geo tagged. Verifications will be conducted multiple times in a day. Each verification must be completed within 24 hours. Verification reports should be detailed and comprehensive. The verification reports should be delivered in the format: either on call, excel, or informed punched in our software or shared over email with photographs evidence of visit duly geo tagged. Reports should include a basic summary of findings. Verification tasks will be assigned daily. Verification tasks are expected to be betwe...

I have an Excel workbook that has an error in the February tab. The daily totals are not posting in the correct cells. I need you to fix this issue and ensure that the tab matches both the layout and the formula structure of the January tab. Additionally, I need the remaining months of the workbook resized to look like the January tab. Ideal skills and experience for this job: - Proficiency in Microsoft Excel - Strong analytical skills to identify and rectify errors - Prior experience with data management and workbook formatting - Attention to detail to ensure accuracy and consistency

Create cv for me. I pay project fees, your 100 rupees fees, write a good review, and invite for potential new projects I have for you. The ideal cv will be plain, easy to understand and is minimalistic with no designs but is organized. I can share my photo to add into it. Canva can be used but designs are banned and must not be used. My linkedin profile will be shared with you to create this cv. I will also provide additional details as we work through. Thanks

***LONG TERM POSITION AVAILABLE*** We are looking for a skilled 3D Render Artist who can produce high quality renders, with experience in banner design and branding a bonus. The brief is as follows: 1. Create and photo realistic render a controller that matches or improves on the quality of the sample HERE: 2. Create a web banner in size 1920 x 700px using the rendered image(s) you create, with the following text: Line 1 (main text) "10% OFF Personalized Controllers" Line 2 (sub-text) "Using Code 10CMODZ" You have full flexibility in terms of the web banner, You can download all of the model files and textures below: Please see the examples of banners we like the style of (but

please accept the quote and create the milestone for the monthly SEO working

I'm experiencing issues with Excel's conditional formatting and need an expert to help. Key issues: - Cannot copy entire conditional formatting rules across the spreadsheet. Ideal skills for this project: - Advanced Microsoft Excel expertise - Proficiency in identifying and resolving Excel-related issues - Strong understanding of conditional formatting techniques Please provide regular updates via remote. The troubleshooting will be for Excel 365.

I'm seeking an instructor to help me grasp the concept of optimization, focusing primarily on Linear Programming. As a beginner with Excel Solver, I need someone who can guide me through solving questions with various constraints. Key Requirements: - Expertise in Linear Programming. - Proficient in teaching Excel Solver. - Capable of explaining different types of constraints depending on the case study. -solve with me questions Ideal Skills: - Advanced knowledge of optimization techniques. - Strong communication and teaching skills. - Experience in using Excel Solver for complex problems. As the type of constraints we will be working with will depend on the case, I require a flexible and knowledgeable instructor who can adapt to different scenarios and explai...

I need a comprehensive Print and Digital Catalog made from the data and images on our Shopify website. The main purpose of this catalog is for marketing and information, so it needs to be appealing and engaging to potential customers. Key requirements: - Utilize product images from our existing Shopify store - main product photo and production drawing if available on the website - Incorporate elements of our company branding like company Logo - Include a QR code for every product - Size to be mentioned for each item - Price need not be mentioned. Or if possible, 2 catalog versions - one with price and one without price. Ideal skills for this project include experience with catalog design, a strong understanding of marketing principles, and a keen eye for aesthetics. Familiarity with Sho...

I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME TO READ AND BID

I'm seeking a professional adept with Google Sheets to improve my current project list. This involves creating a detailed resource plan that will be interconnected with the project list. Key requirements include: - Integrating a timeline/Gantt chart within the resource plan that updates in real-time when resources are assigned to projects. - Making the timeline adjustable in the resource plan view. - Ensuring that any adjustments made in the resource plan reflect in the project list dates. The primary focus will be on human resources. While I haven't specified what details need to be tracked for each individual, I anticipate a need to monitor: - Allocation availability - Time commitment towards each project The level of detail in the timeline/Gantt chart wil...

ElectriCAD is looking to expand its software development team. We are seeking two qualified developers with expertise in building complex applications using user inputs to create interactive plans and diagrams in SVG. You are solution-oriented. You show perseverance and never give up when faced with challenges. You are passionate and involved in your projects. You are **creative** and **intelligent**. React is your tool of choice. JavaScript holds no secrets from you. You are passionate about DOM and creating engaging user interfaces. You are available for a full-time position with a minimum duration of 12 months. You are the person we are looking for. We have prepared a technical and creative challenge to select candidates who will demonstrate their creativity and, abo...

I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data - Experience with creating and using Excel Macros 1 year If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.

I have 35 pages of handwritten documents that need to be typed in xl. The specific requirements, such as document format and font style, can be budget is $10 if you think this is good for you then you are welcome. Otherwise please do not be on this project.