Show date data vba excel jobs
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.
...The application will need to: - Use a dedicated scanner to scan the 2D barcode and MRZ code from guest IDs. - Extract full ID details from the guest's identification. - Post the scanned data to a database. - Include a Terms of Service and License Agreement that guests must agree to upon check-in. - Store all customer visits in the database and keep a PDF of their signed agreements. - Calculate fees to charge the guest based on values stored in the database. - Include an admin screen to select guest status. - Allow retrieval and viewing of a guest's check-in history for analysis and reporting. - Implement data encryption for both storage and transmission to ensure guest information security. - Include a reporting module to generate various reports like daily chec...
"I am a highly skilled and creative graphic designer with extensive experience in crafting visually compelling designs. My expertise spans across various design disciplines, from branding and print media to digital design and user interfaces. With a strong eye for detail and a passion for innovation, I excel in transforming ideas into impactful visual solutions. I am proficient in the latest design tools and trends, and I always strive to push creative boundaries while maintaining functionality. My ability to collaborate with clients and deliver results that meet their objectives sets me apart as the ideal candidate for any design project."
...workflow tool. We want to: Centralize our time tracking and billing process in Karbon. Use Karbon to generate invoices that will sync seamlessly to QBO. Continue collecting payments primarily through GoCardless, integrated with QBO. Automate annual fee increases, margin adjustments, and handle variable pricing scenarios. Improve reporting and profitability analysis using Karbon’s timesheets and client data. We need an outsourced resource to implement the technical integrations, configure our systems, and provide training and documentation. Current Environment and Pain Points QBO + GoCardless: Currently managing invoices directly in QBO. GoCardless is set up to handle recurring DD payments. Karbon (CRM): Used as our central client database and workflow management tool, but n...
I'm looking for a data specialist who can help me connect the Ignition MySql Historian database to Excel via MySql Connector. The main purpose of this project is to enable real-time data analysis and visualization. Key requirements: - Querying MySql Ignition Historian data using Excel via MySql Connector - Connecting the Ignition Database to Excel - Creating various data visualizations in Excel, primarily charts and graphs Ideal skills and experience: - Extensive knowledge of MySQL - Proficient in Excel, particularly in creating data visualizations - Experience with Ignition Historian is a plus - Strong analytical skills - Ability to work on real-time data I will supply two databases Once is the dat...
I'm seeking a skilled professional to automate the generation of a Microsoft Word report from a Microsoft Excel file. The report should be created on a weekly basis, incorporating specific elements from the Excel file. Key Requirements: - Data Integration: The Word report should incorporate summary tables, raw data, and text from the Excel file. - Custom Layout: The Word report will need to follow a custom layout, so experience with Microsoft Word's formatting tools is a must. - Timeliness: The project involves a weekly report, so punctuality and reliability are key. Ideal Skills: - Proficiency in Microsoft Excel and Word - Experience with data integration from Excel to Word - Strong understanding of custom formatting in W...
...develop creative concepts for ad campaigns. Video Editing: Edit and produce engaging video content, including storyboarding, scriptwriting, and post-production. Image Editing: Retouch and manipulate images to create visually appealing ad assets. Asset Optimization: Optimize images and videos for various digital platforms, ensuring they meet specific technical requirements. Staying Updated: Keep up-to-date with the latest trends and best practices in digital advertising and video production. Collaboration: Work closely with the marketing and creative teams to ensure seamless project execution. Qualifications: Proven experience in digital advertising or graphic design. Strong proficiency in Adobe Creative Suite (Photoshop, Illustrator, Premiere Pro, After Effects). Excellent under...
I'm looking for an expert who can build a financial projection for my tech startup, which operates on a subscriptions and commissions business model. The primary focus of this projection will be to assess invest...key funding milestones and the required investment for each. - Include a market analysis to justify the growth projections. - Provide estimates of the startup's valuation over the projection period. Please provide examples of similar projects you've completed in your bid. The ability to present the data clearly and concisely will be key for potential investors. Please use Excel to create the financial projection. Please include visualizations such as charts and graphs to help present the data more effectively. The primary purpose of this fina...
I'm looking for an Excel expert who can help me analyze some operational data. The main focus will be on performance metrics. Ideal Skills: - Proficiency in Excel - Experience with data analysis - Understanding of operational data - Ability to interpret performance metrics
I'm teaching a credit class on December 12th at 1230 and need a professionally designed flyer to promote it. The flyer needs to be made in Canva so I can easily edit it for future classes. Key information to be included: - Class date and time December 12th at 12pm - Instructor details (Matthew Ballantyne ) Email Phone - Enrollment instructions If you can't make it to this class please email Matthew for zoom class details Were having Pizza and Drinks so don't worry about getting food first your sure to learn a lot about Credit and how to make it work for you Understanding your credit How to make it work for you presented by Matthew Ballantyne. Hosted By High Grade The aim of the flyer is to promote the class, so it needs to be clear and concise, while still ...
I have an Excel spreadsheet that needs some cleanup and formatting. The spreadsheet primarily contains inventory details. Key Requirements: - Remove duplicate entries - Correct formatting issues - Update outdated information - Apply conditional formatting to the inventory details Ideal Skills: - Proficiency in Excel - Experience with data cleaning and formatting - Attention to detail The spreadsheet contains between 1,000 and 10,000 entries.
...Objective: When hovering over a column in the Chart, the resulting popup must dynamically display the correct data from the variables corresponding to the month of the column. This involves replacing the variable placeholders (e.g., {Date} and {Usage}) with the actual data stored in the variable set. Additional Requirement: Once approved, the final delivery must include detailed documentation explaining the logic used for connections and optimizations. The documentation should clearly outline the following: • The steps to add new variables. • How to edit existing ones. • How to maintain the functionality for future updates. • How to effectively manage the variable set to ensure the data integrity and coherence. We suggest using Scr...
I need a skilled data analyst for identifying and developing a comprehensive specialty dental practice database. The project involves: - Identifying DSO-affiliated Practices: Scraping public databases, DSO websites, and relevant directories to locate practices affiliated with Dental Support Organizations (DSOs). - Finding Independent Practices: Using online directories and Dental Association websites to identify unaffiliated, independent dental practices. - Collecting Contact Information: Targeting practice websites and public records to gather essential contact details. - Categorizing Practices: Classifying the dental practices into various categories such as specialty, size, and geographical location. - Validating Data Accuracy: Implementing verification steps to ens...
I'm in need of a comprehensive Excel spreadsheet that will help me track my finances, specifically my budgets and forecasts.
Our company has developed the Excel-to-Word Document Automation Office add-in that seamlessly integrates Excel content into Word and PowerPoint documents. The calculations and data come from an Excel spreadsheet and then our add-in updates that information into a Word or PPT document. We are seeking an expert to locate Excel-Word and/or Excel-PowerPoint template pairs that we can showcase on our website to demonstrate the capabilities of our add-in. App Overview - Current Template Examples - We have outlined various use cases here - The ideal candidate will find a template pair based on one of these use cases. The Excel template will be dynamically linked to the corresponding Word
...Planning, Local Government and the Regions Committee" and it contained two specific phrases "Scarborough Borough Council is one of three LGAs conflicted with how the apply the government's Social Cohesion Policies" and "outsource problem tenants, and tenants who will not pay, to couch-surfing and to private landlords". Those phrases might not be perfectly remembered. There was also a remembered date of 2004, although this must be incorrect as Nick Clegg was only the Deputy Prime Minister from 12 May 2010 to 8 May 2015. Unless the Nick Clegg bit is instead wrong. There was an ISBN number, although this wasn't noted down. We thought we would be easily able to refind this document and didn't realise at the time that it might become import...
I'm looking for an Excel expert to develop a production tracking spreadsheet. This will involve tracking specific Key Performance Indicators (KPIs) and automating data transfer to other spreadsheets using VBA. Key aspects of the project include: - Tracking KPIs: The spreadsheet should monitor production volume, as well as production and revenue per square foot by each harvest cycle. - Creating a Gantt Chart: A calendar or Gantt chart to visualize the production timeline is also required. Ideal skills and experience for this job: - Advanced Microsoft Excel skills, particularly with VBA and macros. - Experience in creating tracking spreadsheets. - Ability to create visual aids such as Gantt charts. Please provide a brief overview of similar project...
Create a VBA in excel to export an organization's structure from Excel to PowerPoint. Propose your template or format in Excel. Export aditional fields in excel to powerpoint as shown in the example attached. The presentation can follow a generic minimalistic style.
I'm looking for an Excel VBA whisperer to help enhance my productivity. Key Tasks: - Creating custom functions in Excel to meet specific needs - Automating data entry and clean-up tasks - Streamlining the process of importing and exporting data from/to CSV and Excel files - Debugging and resolving issues in existing VBA code Ideal Skills: - Proficient in Excel and VBA programming - Experience with creating custom Excel functions - Strong understanding of data entry and clean-up processes - Familiarity with CSV/Excel file handling
...seeking a professional proficient in data entry, particularly with mixed data types (text and numerical) sourced from online databases. Key Requirements: - Data will be pulled from various online databases and entered into an Excel spreadsheet. - The data types are mixed, so attention to detail is crucial to ensure accuracy and consistency. - Proficiency in Excel is a must, as the data will need to be formatted and organized within the spreadsheet. Ideal Skills and Experience: - Previous experience with data entry from online databases is preferred. - Strong attention to detail and ability to maintain accuracy under repetitive tasks. - Proficiency in Excel and familiarity with its various functions for data organiza...
...application for task management and time tracking using the Pomodoro technique. Technology Stack: Java Spring Boot, HTML, JavaScript, CSS, MySQL (Database) Key Features Task Management: A calendar interface where users can click on a date and add tasks. A task list page displaying tasks with options to edit, delete, or start the timer. Pomodoro Timer: A fixed timer (default 25 minutes) for the Pomodoro technique, which can be started for each task. Log the time spent on each task in the task table after the timer completes. Time Logging: Store task data and logged hours in a MySQL database. User Interface: A simple, intuitive UI using HTML, CSS, and JavaScript to interact with the application. Deliverables Complete source code and documentation. A functional prototyp...
I'm looking for a skilled VBA expert to help me automate data entry and manipulation in Excel. Key tasks include: - Sorting and filtering data - Data validation and cleaning - Merging and consolidating datasets Please note that I will be running the VBA code manually, so it does not need to run automatically based on certain triggers. Ideal candidates should have: - Strong knowledge and experience in VBA and Excel - Proven track record in automating data entry and manipulation tasks - Excellent problem-solving skills - Attention to detail Please include examples of similar projects you've completed in your bid.
I'm seeking assistance in entering approximately 3,000 email addresses from printed documents into an Excel spreadsheet. The email addresses are organized in a list format within the printed documents, making it easier for input. The ideal candidate for this job should have: - Proficiency in Excel - Attention to detail - Experience in data entry - Commitment to maintaining data confidentiality and privacy - High accuracy to avoid errors in email addresses Please note, no additional information needs to be entered along with the email addresses. The task must be completed within one week.
As discussed on direct message got an excel file with some work, will followup with other projects after this one
...work as fast as possible. modifications 1. we need to be able to add templates for titles/descriptions on models and categories. what is the easiest/best way to do it? for models, categories, tags and filter pages. 2. we need pagination , is implemented into home page, but we also need it into tags page 3. we need SEO-friendly urls for filter pages. 4. Delete - X oldest models / delete before Y date , or delete models about if offline for more than X days. 5. sitemap, we can modify a plugins that already exist? or if you think is better, you can make it full custom titles and meta tags should be used on all pages: tags, searches, filters. - you can add another tab where all the Tag Templates can be set. template tags that can
I'm looking for a proficient Excel expert to enhance my Excel 365 file. The file contains technical alpha-numerical fashion pattern data spread over more than 10 tabs. Key Tasks: (VERY IMPORTANT -> File will be locked/protected and SLICER or FILTER needs to work in locked/protected mode) Bid only if you know how to make this work... - Integrate slicer/filter buttons into some Excel tabs - Export tab(s) from multi-tab Excel file Ideal Skills: - Proficiency in Excel 365 - Prior work with slicers and filters in Excel - Ability to integrate export function The exported tab should be in Excel format. The slicer/filter buttons should be integrated into specific tabs. File will be available Monday 09Dec and due by end of same wee...
...updates. - Add profile management for customers and delivery drivers, including personal information, preferences, and contact details. - Enable customers to rate and review delivery drivers and the overall service for feedback and quality improvement. - Implement an in-app chat feature for communication between customers and delivery drivers. - Allow customers to schedule deliveries for a future date and time. - Provide real-time order tracking from dispatch to delivery. - Implement an inventory management system for keeping track of available products. - Include a customer support feature, such as a help center or live support, to address queries and issues. - Offer multiple payment options such as credit/debit cards, digital wallets, and cash on delivery. - Integrate a loyalty...
I have an Excel workbook that needs the font size increased on both the pie chart and all fonts. This will be needed on all tabs. - Font Type: All text should be in Arial. - Font Size: All elements need to be set to font size 27. - Uniformity: The font size should be the same across all elements, including the chart and text. - Headers: All headers should be bolded for emphasis. - Heading Colors: Use a distinct color for headings for better visibility. - Chart Title: Ensure the pie chart has a clear, appropriately-sized title. Please apply specific colors to the text and charts.
...Power Automate to help me extract data from two sources: an auction website and a real estate website (Zillow or ). The final output should be an Excel spreadsheet containing the extracted data as described below. Key Tasks: Auction Website (Grey Columns) Extract all the data from the grey columns (as per the attached example) on the Atlantic County and Cape May County auction websites. The data should be saved in an Excel spreadsheet. Each county’s data should be saved on a separate tab or a separate file. Real Estate Website (Purple Columns) For each property listed on the auction website, match its address with the details available on either Zillow or Realtor.com. Extract all the columns in purple (as per the attached example) a...
...production and quality control reports. Key Features: - The app should be able to pull data from our current database and generate reports based on that data. - The reports will primarily be focused on production and quality control, but the app should also have the potential to be modified for generating other types of reports in the future. - The app should be user-friendly, with a straightforward interface for ease of use. - Include customizable templates for different types of reports to cater to various needs. - The app should support exporting reports in various formats such as PDF, Excel, and CSV. Ideal Skills and Experience: - Proficient in Windows application development. - Experience in creating data-driven reporting applications. - Knowledge of m...
...your approach to design. 2. Your portfolio showcasing relevant work (branding, packaging, e-commerce visuals, etc.). 3. Your availability and typical turnaround times. 4. Your rates and any additional services you offer (e.g., 3D design). We look forward to seeing your creativity and partnering with someone who can help Vivora create timeless dining experiences! We are open to a flexible start date, as we envision this as a long-term project spanning 6 months or more. The primary goal of this branding project is to elevate Vivora's brand image to reflect elegance, minimalism, and sustainability. The primary focus of the first set of deliverables will be finalizing the Vivora logo and creating a comprehensive brand book. Modern, minimalistic but elegant luxury look. We have...
I'm looking for someone to help me increase the font size and the size of the pie charts in all tabs of my Excel workbook. - All tabs of the workbook need to be adjusted. - The font size should be increased to 27 pt. - The pie charts should have their chart area and data labels resized. Ideal skills for this project include proficiency in Excel, attention to detail and ability to follow specific instructions. Experience with data visualization and formatting in Excel is a plus.
...- Brings a contagious entrepreneurial/leadership spirit when they walk into a room - A driven individual who is consistently looking for ways to improve in their current role as well as processes - Highly adaptable in fast-paced environments where the demands are constantly changing TOOLS THAT YOU WOULD USE (Training will be provided if/when necessary) - Microsoft Office Suite (Outlook, Word, Excel, PowerPoint) - Acumatica - Smartsheet - Foxit - Client portals like Service Channel, Oracle, Ariba, Tririga, Retail Link, FM Pilot *NOTE THIS POSITION HAS A SET SCHEDULE - THE SELECTED CANDIDATE MUST BE AVAILABLE TO WORK FROM 10:30PM-7AM EST* We thank you for taking the time to apply, however, only selected candidates will be contacted for an interview....
I'm looking for an expert Excel developer who can help me create a detailed and multi-layered Excel sheet for tracking employee skills. Key Features: - The sheet should have four hierarchical levels with tasks at each level. - Upon marking a task as completed, a pie chart should indicate the percentage of completion. - The sheet needs to be editable, allowing me to modify inputs as necessary. - Each competence sheet should be separate and independent, ensuring that changes in one do not affect the others. I would prefer to have a Zoom call to discuss and clarify the requirements in detail. Ideal Skills: - Advanced Excel skills - Experience with creating complex Excel sheets - Ability to create interactive and editable Excel tools - Good communic...
...professional with expertise in Power Automate to help me extract data from an auction website and a housing website. The final output should be an Excel spreadsheet. See attached example Key Tasks: - Extract all columns in grey data from the Atlantic County auction website into an Excel spreadsheet. - Extract all columns in purple from either Zillow or into the same spreadsheet. Links: - Auction Site: - Zillow Site: The ideal freelancer for this job should have: - Proficiency in Power Automate - Experience with data extraction from websites - Advanced Excel skills Please note that I would like to run the script at
...application access. - Use industry-standard data encryption algorithms (e.g., AES, RSA) for secure file encryption. - Implement comprehensive error handling to manage potential issues seamlessly. - Optimize performance to ensure the application runs efficiently on different Windows versions. - Include functionality to decrypt previously encrypted files securely. - Incorporate logging features to track encryption/decryption activities for auditing purposes. - Allow users to configure encryption settings and customize the application to their needs. - Ensure compatibility with various file types and large file sizes. - Design a user-friendly graphical interface for ease of use. - Provide a mechanism for automatic updates to keep the software secure and up to date. Ideal Can...
I'm looking for an expert in data entry who can help me with a specific task. Key Requirements: - Data Entry: You'll be working with digital text files that I'll provide, entering them into a spreadsheet. - Conditional Formatting: You must be proficient in Excel and experienced in setting up conditional formatting rules. Your responsibilities will include: - Accurate and timely entry of provided data into Excel. - Setting up and applying conditional formatting rules as per my specifications. Ideal Skills: - Proficiency in Excel, specifically in data entry and conditional formatting. - Attention to detail and accuracy in data input. The ideal candidate for this project will have a keen eye for detail and will be ...
...highlight key travel destinations, others focus on hidden gems etc. Key Requirements: - Expertise in writing in Russian. - Deep understanding or experience in the travel and tourism industry. - Ability to write high-quality, engaging, and informative articles. - Knowledge of SEO and keywords to optimize content for search engines. - Strong research skills to gather relevant, accurate, and up-to-date information. - Commitment to producing 100% original content, free from plagiarism. - Techniques to create engaging and attention-grabbing content. - Excellent command of Russian grammar, punctuation, and syntax. - Proficiency in self-editing to ensure clean, professional-quality content. Please provide samples of your previous work relevant to this project. We will pay in accordan...
I'm the owner of a small startup in website design named Damerax Cloud Solution and I'm looking for a professional with proven experience in cold calling and cold emailing to help grow my business. I will provide you with an Excel file of cold leads, which are potential clients from the technology sector. The primary aim of this project is to generate new sales. Key Responsibilities: - Make cold calls and send cold emails to the provided lead list - Follow-up with interested clients - Inform potential clients that you'll be forwarding their details to a senior executive - Pass on the details of interested clients for further discussion and meeting scheduling I'm open to sharing my existing cold call script, but I'm also keen to hear your professional insig...
...option—unlocking all exercises—and leave the student to pick what they need to practice. When all exercises of a level or a book are completed (regardless of the order of completion), the certificate will be issued. Admin 1- Subjects, questions, answers, levels, and books can be uploaded in bulk using an Excel file. 2- This should be a subscription platform with annual payment; auto-renewal is an option provided at payment. 3- Auto-renewal should be a checkbox in the profile settings with the date it was last updated, and an email is sent to the account owner when it is updated and logged in the system for tracking. 4- Payment should be integrated with Stripe. 5. Admin can access detailed analytics of student performances and progress reports. 6. A workflow f...
I have a project that involves converting a PDF to an Excel spreadsheet (XLSX). The PDF contains primarily text with images. I need a meticulous professional who can ensure all the data is accurately transferred and properly formatted in Excel. Ideal skills for this job: - Proficiency in PDF editing and Excel - Attention to detail - Experience with data conversion
I need a web-based app that transforms my Excel spreadsheets. It will primarily handle automated calculations and reporting. The app will generate reports in PDF format. Key Requirements: - Proficient in web app development - Experience in transforming Excel spreadsheets into functional apps - Ability to implement automated calculations and reporting - Skills in creating PDF reporting functionality within the app Ideal skills and experience for the job include: - Web development - Excel - PDF generation - Automation - Programming
...Pro: Temporary Prototype The basic structure, design, and functionality are in place. The task primarily involves migrating content from the old site to the new one and ensuring everything functions correctly. Tasks to be Completed: Friars' Page: Approximately 50 friars are left to be imported. Each friar is represented as a card, which opens a popup with detailed information when clicked. The data needs to be copied manually from the old website (). Convents' Page: A similar structure to the friars' page but with fewer items (about 40 convents). Each convent should open a popup with its information, and ideally, these should be linked to their associated friars. Gallery Page: Each image in the gallery on the old site opens its respective gallery
I need assistance with data entry and research on company registration numbers. You will be required to: - Collect and input company registration numbers into an Excel spreadsheet. - Collect and input each company's website home page address - I already have company names for you to work with Ideal skills for this job: - Proficient in Excel and data entry. - Excellent research skills. - Attention to detail is crucial to ensure all information is accurate and complete. Please use online business directories e.g. companies house for obtaining company registration numbers. The project involves between 100 and 500 companies. Please use the provided template for the Excel spreadsheet.
