Show date data vba excelJobs
As discussed, I'll do the conversion from PDF to Excel for the file you have shared.
...details. WooCommerce Updates: Optimize the e-commerce system for seamless transactions. Include coupon and discount functionality (if applicable). Template/Section Changes: Redesign sections for improved readability and visual appeal. Email Confirmation: Optimize automated email confirmation with customized messages upon enrollment. 4. FAQ Section Enhancements: Update FAQs with relevant and up-to-date questions and answers. Structure the section for easier navigation (accordion or expandable lists). Improved Design: Make the FAQ section visually appealing with icons or categories. 5. CSS and Performance Optimization CSS Fixes: Address all broken styles or misaligned sections. Ensure responsive design across all devices. Page Load Optimization: Minimize CSS and JavaScript files ...
I'm in need of a skilled graphic designer to create a modern-themed wedding card for me. The design should incorporate a pastel color scheme and include the following details: - The couple's names and wedding date - Venue details - RSVP information - Event timings (ceremony start, reception start, etc.) Ideal candidates should have a strong portfolio in invitation design, particularly wedding cards. Prior experience with modern and pastel-themed projects will be a plus. Creativity and attention to detail are essential for this job. Please include samples of your previous work in your proposal.
I have multiple project spreadsheets in Excel that get copied and pasted as new projects are established. Within each template, there's a spreadsheet that tracks change orders identified by project names. I need a single aggregator spreadsheet that continuously pulls data from all to hold the summary data. Key tasks: - Create an aggregator spreadsheet in Excel - Ensure it pulls data from all individual project spreadsheets - Track change orders based on project names Ideal skills and experience: - Advanced Microsoft Excel skills - Experience with Excel data aggregation - Familiarity with project management spreadsheets The frequency of updates to individual spreadsheets varies. Some may lay empty, while others may have two cha...
...blog writer who can help us build our online presence by creating compelling, research-backed blog posts. Responsibilities: Write high-quality, engaging, and SEO-friendly blog posts on topics like: - Elementary Education - Math Education for Kids - Child Development and Education - Parenting Tips and Strategies - Conduct in-depth research to ensure the content is accurate, informative, and up-to-date. - Incorporate targeted keywords naturally to optimize for search engines. - Adapt writing style to match our brand voice and resonate with our target audience and target market (parents of young children, educators, and caregivers). - Provide recommendations for blog topics based on trending themes and SEO analysis. - Learning Through Play: How play-based learning techniques can ...
...Strategize, create, and manage ad campaigns on Meta (Facebook/Instagram) and Google Ads platforms. Conduct keyword research, audience targeting, and A/B testing to optimize campaign performance. Analyze campaign data and provide actionable insights and regular performance reports. Manage budgets and ensure campaigns deliver within CPA and ROAS targets. Keep up to date with platform updates and advertising trends. Requirements: Proven experience managing Meta and Google Ads campaigns, especially for e-commerce. Strong analytical skills with the ability to interpret data and make data-driven decisions. Familiarity with conversion tracking, Google Analytics, and tag management. Excellent communication and reporting skills. Availability for regular updates and...
I'm looking for an Excel expert to create a macro that helps me update my Bill of Quantities (BOQ) using an old list of glass panels. The goal is to efficiently identify and compare reusable materials. Specific Tasks: - The macro should identify reusable glass panels. - It should compare entries from the old and new BOQ. - Finally, it should generate a report detailing usable materials. Report Structure: - The output report should be structured in an Excel spreadsheet. Data Format: - The old glass panels list is currently stored in an Excel spreadsheet. Ideal Skills: - Proficient in Excel macros and VBA. - Experienced in data comparison and reporting. - Able to deliver a well-structured Excel report.
Product 1: Dynamic Vineyard Protection Overview: Product 1 represents the cornerstone of Luxura Guard's offering—an innovative, data-driven platform designed to monitor, predict, and mitigate risks for vineyards. Combining IoT sensors, AI-driven analytics, and customizable insurance solutions, this product redefines how vineyards manage their operations. Key Features: IoT Sensors: Real-time monitoring of soil moisture, temperature, and pest activity. Advanced versions include aerial drone support for comprehensive vineyard analysis. Dynamic Insurance: Flexible coverage that adjusts based on real-time risk data. Protection against frost, hail, and other environmental hazards. Predictive Analytics: AI-driven models that forecast yields, optimize resources, and predic...
I have a set of survey data that is in an Excel or CSV format, and I'm looking for a statistician or data analyst to help me summarize it. Ideal applicants for this project should have: - Proficiency in statistical analysis - Experience working with survey data - Ability to work with Excel and CSV files - Capable of providing clear, comprehensible summaries of data
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision-making, particularly in developing economies. Requirements: make sure you are able to access the sources to conduct Litigation and Bankruptcy check in Uruguay. PLEASE FIND THE JOB DESCRIPTIONS & REQUIREMENTS BELOW: 1. Conduct research the provided individual in all litigation sources in both native language and English. 2. Conduct research the provided individual in all bankruptcy and insolvency sources in both native language and English. 3. Conduct research the ...
We are looking for an experienced Excel developer to create custom dashboards for our Opportunity Tracker spreadsheet. This project involves transforming an existing data-heavy spreadsheet into an interactive and visually appealing dashboard to provide quick insights and metrics for our sales organization. Here is a video explaination: Project Overview: Our company tracks sales opportunities in a comprehensive Excel spreadsheet. While all data resides in a single tab, we need dashboards to quickly visualize and summarize key metrics such as total pipeline value, stage breakdowns, trends, forecasts, and campaign-specific data. Scope of Work: Dashboard Development: Create a dashboard to summarize and visualize key
I'm in need of a data analyst who can delve into various datasets including financial, customer, and stock information. The goal is to assess growth and degrowth indicators, maintain stock levels, and evaluate stock value. Key Responsibilities: - Analyze financial data for balance assessments, billing values, and target vs achievement comparisons. - Examine customer data for potential trends. - Conduct stock analysis focusing on maintenance, turnover rates, and value evaluation. - Prepare detailed financial reports based on data analysis results. - Forecast financial and stock performance based on historical data. - Develop comprehensive reports summarizing identified customer trends. - Compare company performance metrics with market benchmarks. - ...
I need a proficient web scraper who can extract detailed company information from various sec...Services and Outsourcing (SSO), and Energy Companies. The specific company details required are: - Contact Information - Company Address - Company Email - C-Suite Level Name - C-Suite Level Contact - C-Suite Level Email - Industry Category/Classification - Company Website URL The extracted data should be delivered in an Excel spreadsheet. Ideal skills and experience for this job include: - Proficient in web scraping - Familiarity with data extraction from the specified sectors - Able to deliver data in the specified format - Attention to detail - Good understanding of C-Suite level roles in companies. This will be a one-time web scraping project. The project sho...
...with health technology assessment outcomes for less than 10 specific treatments. The data required is primarily effectiveness data. Skills and experience ideal for this job: - Proficient in data entry and spreadsheet manipulation - Familiarity with health technology assessments - Ability to source and verify effectiveness data - Attention to detail for accurate data entry The final spreadsheet should be in Excel format. The project should be completed within 1 week. "I will provide links to the HTA assessments." The data should be organized using a predefined template that I will provide. Please categorize the effectiveness data by treatment type. Only use the links provided for sourcing the HTA assessment data....
I have multiple sheets in a workbook. Each Sheet represents a week, and each week Includes different tenders for different projects. I need assistance in extracting the lowest bidder from each sheet and respective project. - The bid entries are numerical va...sheet and respective project. - The bid entries are numerical values located in the same column across all sheets. - I have attempted to use VLOOKUP and INDIRECT functions, but they only return the first value encountered. I'm looking for a more efficient solution that can incorporate the MIN function to find the lowest bid. - The ideal freelancer for this project should be highly proficient in Excel and familiar with its advanced functions. Given my tight schedule, I would appreciate a swift and effective solution t...
...who is able to automate the trading process for me. This script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. i need it like application Broker: Note: I dont know about coding, If you install the code and run successfully at my system thereaft...
...and features as per requirements - Maintaining the existing colour schemes, fonts, and design elements Ideal Skills: - Proficient in full stack development - Experience with website theme customisation - Able to follow specific wireframes and instructions - Strong understanding of layout and structural modifications - Skilful in adjusting website functionality and features The wireframes do not show all of the pages on the website, other pages on the site such as checkout page and homepage will remain the same with checkout page seeing some customisation to accomodate functionality of new/customised pages. Final delivery will also require website to be uploaded onto wordpress as a fully functioning website. Theme used:
...our gaming blog, covering the latest news, reviews, tips, and trends in the gaming world. You will have the opportunity to connect with a community of gamers and contribute to the conversation about gaming culture. Responsibilities: Write well-researched, engaging, and original articles on various gaming topics, including game reviews, industry news, gaming strategies, and updates. Stay up-to-date with the latest gaming trends, releases, and community discussions. Create content that resonates with our target audience and encourages engagement and interaction. Ensure all content is optimized for SEO and follows best practices for online writing. Collaborate with other writers and editors to produce high-quality content. Participate in brainstorming and content planning sessions...
I need an Excel expert who can assist me in creating complex formulas, particularly for financial calculations related to mortgages and loans. Your tasks will primarily involve: - Developing intricate Excel formulas to help analyze different financial scenarios concerning mortgages and loans. - Providing insights through the use of these formulas. - Developing amortization schedules for fixed-rate and adjustable-rate mortgages. - Formulating monthly and bi-weekly mortgage payment calculations. - Creating formulas for evaluating the benefits of mortgage refinancing. - Developing formulas to break down total loan repayment into principal and interest components. - Creating projections for the future value of investments related to mortgages. Ideal candidates for this project ...
...our ERP system and update all entries based on an excel file. There are a total of 5 tasks we need to complete. The first task is to update the contacts for whom we don’t have an email address, prioritizing the Technical Director. Find email addresses for specific job positions: Technical Director, Procurement Director, Sales Director, Business Development Director, CEO. Provide the full name of the person (last name and first name). Find and include the LinkedIn profile of the person. The ideal candidate should be skilled in data entry, research and familiar with LinkedIn and other professional networking sites. Please note that the second step will be discussed after the first task is completed fully and correctly. In the first excel File there are 2078 ...
I'm in need of an Excel developer who can help me automate repetitive tasks using macros. Ideal Skills: - Proficient in Excel, especially in creating and implementing macros - Strong problem-solving skills - Attention to detail - Previous experience with Excel automation - Advanced knowledge of VBA programming - Experience in data analysis with Excel - Ability to create and manage user forms - Skills in creating charts and graphs for data visualization - Proficiency in implementing error handling in macros - Experience integrating Excel with other software - Skills in optimizing macro performance - Ability to create macros for batch processing tasks Please note, the specific repetitive tasks to be automated are yet to be deter...
I need a professional translator to help translate the user interface elements of my mobile app into Spanish, German, Italian, and Portuguese. The phrases needing translation are currently formatted in Excel/CSV files. Ideal candidates should have: - Proven experience in translating user interface elements for mobile applications - Native or near-native proficiency in the specified languages - Ability to maintain the intended meaning and tone of the original phrases - Familiarity with working in Excel/CSV files - Attention to detail to ensure every element is accurately translated.
...who is able to automate the trading process for me. This script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. i need it like application Broker: Note: I dont know about coding, If you install the code and run successfully at my system thereaft...
Milestone 1: Collect Data running your web crawler Budget $100.00 Time limit: 3 days, daily update is required You will use Excel sheet provided by me. You must follow all the instruction in the requirement document in the link below. You are doing Milestone 1a and 1b only.
I need an Excel expert who can assist me in creating complex formulas, particularly for financial calculations related to mortgages and loans. Your tasks will primarily involve: - Developing intricate Excel formulas to help analyze different financial scenarios concerning mortgages and loans. - Providing insights through the use of these formulas. - Developing amortization schedules for fixed-rate and adjustable-rate mortgages. - Formulating monthly and bi-weekly mortgage payment calculations. - Creating formulas for evaluating the benefits of mortgage refinancing. - Developing formulas to break down total loan repayment into principal and interest components. - Creating projections for the future value of investments related to mortgages. Ideal candidates for this project ...
Understanding of Requirements and Proposed Procedure 1. Data Overview:The project involves analyzing Nifty 500 stock data grouped by industry. The provided Excel file contains historical stock prices and market capitalization data from 2005 to 2023. A second file provides notes on strategy and ranking methodologies. 2. Requirements Breakdown: • Ranking Stocks by Industries: Group stocks based on their industries and rank them using performance metrics such as returns or technical indicators over time (e.g., 20th–50th percentile). • Applying Filters: Implement filters like Supertrend and other technical indicators (e.g., RSI, ATR) to identify different portfolios based on stock performance. • Timeframe Analysis: Analyze stock perfo...
I'm seeking a skilled mathematician and data analyst to assist with predictive analysis on my operational data. The ideal freelancer for this project must: - Have extensive experience in predictive analysis - Be proficient in utilizing Excel for data analysis - Possess strong mathematical skills The goal is to glean insights from the data that can inform future operational strategies. Understanding of operational data and its nuances would be a plus.
...email integration: Users should be able to log in, enter their Gmail credentials and give permission for their email to be accessed. - Email monitoring and document processing: The system should monitor the user's Gmail account for incoming emails and fetch any documents that meet the specified criteria. - Document analysis: The system should read the documents and extract the invoice number and date from each one. - Job creation and dashboard display: For every email, a new job should be created on the user's dashboard. The details from the PDF or Word document should be filled in and displayed. - Notification system: Notify users of new jobs created or errors encountered via email or SMS. Ideal skills for this job include web development, backend integration, and exp...
I'm looking for a freelancer who can scrape data from a specific travel industry website. I need information about travel packages or deals organized into an Excel spreadsheet. This task will only need to be completed once. Ideal Skills: - Proficient in data scraping techniques - Experience with the travel industry - Skilled in Excel I will provide the URL for the website.
I'm looking for an Excel VBA expert to help me automate the process of populating a new sheet from an existing one. This project will focus on generating reports based on production data. Key Requirements: - Proficiency in Excel VBA - Experience in data handling and report creation - Familiarity with production data is a plus The existing sheet contains specific data fields that I want to include in the report. The new sheet will be used for report generation. Please note that the ideal candidate should be able to work with a pre-defined set of data fields.
I'm in need of a seasoned professional with proven expertise in WhatsApp integration. The task at hand is to create an interactive flow on WhatsApp for guests to register for conferences. Key Requirements: - Guests should be able to input event data and related information. - A seamless registration process for guests. - Ticket booking capability for guests, with options to select required quantities. - An integrated payment system for ticket purchases. - Automatic generation of QR codes for entry verification. - Data consolidation into an Excel file for event owner access. - Provide multilingual support for a wider audience. - Send automatic reminders for event dates and times. - Send confirmation messages upon successful registration. - Allow guests to cancel ...
...community. - Compile and analyze social media analytics to measure effectiveness and adjust strategies as needed. - Identify and engage with relevant influencers to expand brand visibility and reach. - Design and manage social media ad campaigns to boost specific posts and reach a broader audience. - Monitor current beauty trends and integrate them into content to keep the brand fresh and up-to-date. - Respond to direct messages and comments promptly to provide excellent customer service and manage inquiries. - Create a content calendar to plan and schedule posts consistently across both Instagram and Facebook. - Optimize social media profiles and posts for search engines to increase organic visibility. Ideal Skills: - Proficient in Instagram and Facebook marketing - Strong cont...
I need assistance with data entry from digital files. The job primarily involves working with text data sourced from PDFs and Word documents. Key tasks include: - Extracting relevant data from digital documents and entering it accurately into a specified format. Ideal candidates should be proficient in Excel and Word, with excellent attention to detail to ensure data is accurately captured and entered. Prior experience with data extraction and entry is a plus.
I'm embarking on a journey to become a skilled freelance web developer and social media manager, working independently from the comfort of my home. Dreaming big, I aim to build and design websites and excel in social media management. To jumpstart my freelance career, I’m seeking: - Comprehensive beginner to intermediate level training in HTML, CSS, and JavaScript to craft responsive and interactive websites. - In-depth understanding and hands-on experience with popular Content Management Systems (CMS) such as WordPress. - Guidance on the creation of engaging and original content for various social media platforms. - Expertise in leveraging social media analytics tools to track campaign performance and engagement metrics. - Introduction to graphic design principles and t...
I need a professional who can replicate an Excel sheet that is linked with a Google Business Intelligence front end. This project involves creating a dashboard that will display operational metrics. Key requirements: - The dashboard must feature interactive charts - It should provide real-time updates - It must include custom filters - Include secure user authentication to access the dashboard. Ideal candidates will have: - Experience in dashboard creation - Proficiency in Excel and Google BI - A knack for data interpretation and visualization The dashboard should connect to our internal database for data sourcing. The attached Front end has to be created .. back end data excel we have
...extract data from the Accel Venture Fund's website. The goal is to compile a comprehensive list of the companies they have invested in, along with relevant information about each. Required Data Points: - Company name - Investment date - Company website - Founders - Funding amount - Sector The final output should be in Excel format. This is a one-time project. The ideal freelancer for this task should have proven experience in data scraping and should be able to deliver clean, well-organized data. all the info available on each company Only include information that is directly available on the Accel Venture Fund's website. The data extraction should be completed within 1 week. The data extraction should focus on specifi...
I'm looking for a freelancer to help me redesign my current work schedule, which is in an Excel format. The existing schedule could use some better formatting to make it more visually appealing and easier to read, while still keeping it as a 3-page document. The schedule is divided into three pages: - Page 1: Servers and the two bartenders - Page 2: Hostess, bussers, and dishwashers, in that order - Page 3: Cooks, and salad Key requirements: - Design Style: A minimalist approach is preferred. The aim is to keep it simple, clean, and uncluttered. - Information Transfer: All data from the current Excel sheet needs to be transferred accurately. This includes shifts and hours worked, special notes or tasks, and employee names. - Visual Elements: Use of borders and ...
... Performance Expectations: You must be able to follow detailed instructions and complete tasks independently. While occasional clarification is acceptable, constant or excessive questions are not. The provided instructions will be thorough and should allow you to perform tasks efficiently without ongoing guidance. Technical Requirements: A phone for cold calling. Access to Microsoft Word and Excel. Fluency in English (reading and writing). Ability to handle conflicting priorities from other commitments. Special Note for High School Students: High school students are eligible but must prioritize schoolwork. Clear communication is required during exams or major assignments. You will still be paid during these periods, but no tasks will be assigned. A maximum of one study week is...
...Implementation: POS interface supporting barcode scanning and manual product selection. Basic user authentication and role-based login setup (Admin, Manager, Cashier). Inventory management screens (add/update products, view stock). Configurable settings page for store details, tax setup, and receipt customization. Reporting Template: Layout for sales and inventory reports with export options (PDF, Excel, CSV). Barcode Integration: Integration with barcode scanners for product identification and sales. Documentation: Comprehensive documentation for further customization and scalability. Requirements: Proven experience in developing applications using .NET MAUI. Strong understanding of UI/UX principles for cross-platform apps. Familiarity with POS systems and their functionalit...
CHANGE THE TIME ON THE FLYER TO 3-6PM I need a creative flyer for an upcoming community event. The flyer will be used primarily for event promotion, so it needs to be eye-catching and informative. Key details to include: - Date and time of the event Ideal skills for this project: - Graphic Design - Print Design - Event Promotion Design Experience
I need assistance uploading product photos to my Walmart Marketplace e-commerce site. The photos are organized in an XLSX file, which also categorizes them by product type. Ideal Skills and Experience: - Experience with e-commerce platforms, specifically Walmart Marketplace - Proficient in Excel and image management - Attention to detail for categorization - Understanding of e-commerce product listing standards - Experience with bulk product photo uploads The project requires uploading photos for less than 50 products. The project will also include basic editing of the product photos before uploading. The project will include basic editing of the product photos such as adding a description of the product and price before uploading them.
I am seeking a diligent individual to help with a cargo audit. No prior experience is n...provided. This task includes taking photos of the cargo, confirming quantities, verifying documents, and overseeing the loading process. Key Requirements: - Fluency in the local language is essential - Attention to detail for documentation - Full availability on the inspection date - Use of a smartphone with a good camera for taking photos - Comfort with using messaging apps for real-time communication The training session, which lasts one hour, will be scheduled for the day before the first task. The tentative date for the inspection is December 14, subject to confirmation. Performance-based recurring tasks are available. If you are based in Amman, travel expenses to Zarqa...
I need to have data collected from it. The data I need is: Event Name, Date of Event, City, State, Zip, do they mention medal or medals (yes or no), shirt or shirts (yes or no), contact email address, contact phone number, including participate number. The date range I want you to collect info on is feb 1 2025 to 12/31/2025 Only collect data that has an available email address to contact. No duplicate email addresses For each data line, it's .25 cents. For every phone number gathered, an additional .15 cents per
I am seeking assistance in recruiting 12 senior-level candidates with expertise in magnetic simulation, physics, and engineering for a project involving magnetic simulation software. Key Requirements: - Candidates should have significant experience with magnetic simulation software and possess a strong background in physics or engineering - Strong programming sk...or engineering - Strong programming skills are also advantageous - Candidates should be senior-level professionals with a proven track record in these fields Ideal Skills and Experience: - Extensive experience in magnetic simulation - Deep understanding and background in physics and engineering - Proficiency in using magnetic simulation software - Strong programming skills The anticipated start date for the project is ...
I need a freelancer with strong attention to detail for a data entry job. The task involves working with mixed data sourced from various online databases. Ideal Skills: - Proficient in data entry - Familiar with online databases - Strong attention to detail - Ability to work with mixed data The final data entry should be integrated into a database. The final data should be integrated into an Excel file. The project involves entering between 1,000 and 10,000 entries.
I need a skilled Tableau expert to help visualize solar GHI data to understand the differences in solar energy potential across ASEAN countries. Key Requirements: - Data interpretation to discern the difference between ASEAN countries - Determine which countries have the highest potential for solar energy production - Create clear, concise and engaging visualizations Ideal Skills: - Proficiency in Tableau - Strong analytical skills - Experience with energy resource data - Ability to create visually appealing and informative graphs The data will be provided in Excel format. The visualizations should include sunburst and map to best represent the solar GHI data. Please deliver the final visualization outputs through Tableau Public.
I need a data entry expert who can assist in processing survey responses. This project involves entering data from survey responses, running descriptive statistics analyses using SPSS software, and visualizing the data using PIVOT tables. Ideal skills and experience for the job: - Proficient in data entry with a keen eye for detail - Experienced in using SPSS software for data analysis - Skilled in visualizing data with PIVOT tables - Able to maintain confidentiality and handle sensitive data with discretion. The project involves processing 300 - 500 survey responses. The expected timeframe for the project is 3-4 weeks. Please include demographic analysis by age, race, relationships, income, geographical area, and dependant. The raw survey...
...of the following brands (links embedded): i. Lexis Nexis Risk View/Fraud Point/Emailage Services ii. Checkr. iii. Yardstik is another popular choice. iv. Verisk The target completion date for this project is "ASAP." The freelancer is expected to prepare and complete all required documents for underwriting....
I'm looking for a Pine Script expert to create an indicator for me. This indicator should display orders and trades from Binance on TradingView. The indicator has not the purpose of place orders, only read and show details of orders and trades by groups and or dates too. Key Requirements: - The indicator should show any order or trade from Binance on TradingView - It should specifically display the orders and trades amount - The indicator should display the trade price for each order. - The indicator should display the order in the right date and hour. Ideal Skills: - Proficiency in Pine Script - Experience with TradingView and Binance integration - Strong understanding of trading indicators and signals.
