Show date data vba excel jobs
I'm looking for a talented app developer to create an astrology application focused on delivering personalized astrology readings, primarily through birth chart analysis. The app should be able to generate a user's birth chart based on their date of birth input and provide insightful interpretations. Key features and requirements: - The app should be user-friendly and intuitive, appealing to both astrology novices and enthusiasts. - The birth chart analysis should be comprehensive and accurate, based on established astrological principles. - The app should be able to handle high volumes of users without compromising performance. - Quality UI/UX design to enhance user experience. - Prior experience in astrology app development or a strong understanding of astrology would ...
...seasoned trainer with a minimum of 7 years of real-world experience to provide comprehensive technical and functional training in both Data Analytics and Data Science. The target trainees are absolute beginners, so the trainer must be adept at simplifying complex concepts. The Trainee should explain all the topic that are required but not subject to the one mentioned below. The Trainer should also execute end to end hands on project with the trainee. Please refer to the attached Training topic requirement. The training should cover: - Python and R - SQL and Excel - Tableau and Power BI - Data Extracting, Transforming, and Loading (ETL) processes - Large data platforms Ideal candidates are those with extensive experience dealing with corpora...
We have a WordPress website that uses Leaflet + Google Maps, and until now, the map has been displayed correctly. Due to some update, the map is not visible, but the point markups are still showing We need resolve this problem. We provide FTP access to isolated code.
I'm looking for a seasoned Excel developer to create a macro that can sort and filter mixed data (both numeric and text) effectively. The macro should be able to fetch data from another spreadsheet. Ideal Skills: - Proficient in Excel VBA - Experience with data sorting and filtering - Ability to create efficient macros for repetitive tasks Definition: I have an Excel spreadsheet with Columns A-C, which can be seen in the Example.png. In the current format, the part level doesn't exist, so I created and colorized Columns J-M manually to show my need. But I want a macro to do this format automaticity
PLEASE DO NOT CALL ON THE NUMBER MENTIONED IN BROCHURE, KINDLY ONLY MESSAGE ON FREELANCER I'm looking to create a website for my construction com...DO NOT CALL ON THE NUMBER MENTIONED IN BROCHURE, KINDLY ONLY MESSAGE ON FREELANCER I'm looking to create a website for my construction company, which primarily serves to provide information to potential clients. Key Information to Include: - Comprehensive details about our company history and team. - Clear, concise descriptions of the services we offer and the projects we've undertaken. - Up-to-date contact details and office locations. Ideal Skills: - Web development and design - SEO optimization - Content creation - UX/UI design Experience: - Prior experience in creating websites for construction companies or simila...
I need a freelancer to extract data from specific sections of the GSIDC website. The data should be organized into separate sheets in an Excel file for each of the following categories: Contractors, Major consultants( Only category 2 &3), and Minor consultants. Data Fields Required: - Name - Phone Number - Email - Address - State - PIN Code - Company/Organization Name Ideal Skills: - Proficient in data entry and Excel - Attention to detail - Familiarity with data extraction from websites - Ability to organize data efficiently Please be sure to check the specified URLs for the data categories: , , and
Hello, Looking for Support: HivePress Matching Site Development ✨ We are currently buildi...tracking. ・3. Create Shortcode for Page Content Objective: Display the content of the following HivePress-generated page on other pages using a shortcode. ■Scope of Work ・Investigate and resolve the above issues. ・Ensure compatibility with HivePress, GamiPress, and Divi. ・Implement fixes using "custom CSS", "snippets", or "additional plugin" configurations where necessary. ■Timeline ・Start Date: Immediate availability preferred. ・Deadline: The final task must be completed within 72 hours from the start. I・mportant Note: If the deadline is exceeded, the project will be cancelled and no payment will be made. Please let us know if you are available to assis...
PLEASE DO NOT CALL ON THE NUMBER MENTIONED IN BROCHURE, KINDLY ONLY MESSAGE ON FREELANCER I'm looking to create a website for my construction com...DO NOT CALL ON THE NUMBER MENTIONED IN BROCHURE, KINDLY ONLY MESSAGE ON FREELANCER I'm looking to create a website for my construction company, which primarily serves to provide information to potential clients. Key Information to Include: - Comprehensive details about our company history and team. - Clear, concise descriptions of the services we offer and the projects we've undertaken. - Up-to-date contact details and office locations. Ideal Skills: - Web development and design - SEO optimization - Content creation - UX/UI design Experience: - Prior experience in creating websites for construction companies or simila...
I'm in search of a skilled data scraper who can extract comprehensive real estate data from into an Excel spreadsheet. This project involves gathering information from all states and territories across Australia and includes a variety of property types such as residential, commercial and land. Data Fields Required: - Price - Address - Number of Bedrooms - Land Size - Bathrooms - And other relevant details Ideal Skills and Experience: - Proficiency in web scraping and data mining - Familiarity with Excel for data organization - Understanding of real estate terminology would be a plus - Prior experience with similar projects is preferred Please note, I do not require any additional property details beyond the basics.
...LinkedIn. The banner will promote a weekly discussion co-hosted by myself and a colleague, so it needs to prominently feature our names and titles. Key Requirements: - Incorporation of our logo - Use of a warm and inviting background - Inclusion of the text "Join our discussion" in a clear and engaging way - Inclusion of the text "Welcome to the Name" in a clear and engaging way - Include the date and time of the webinar prominently, it is same time weekly with a zoom link. Ideal Skills: - Graphic design with a focus on professional, corporate aesthetics - Experience designing for social media platforms, particularly LinkedIn - Ability to create visually appealing designs that effectively convey a message Deliverables: Vector image Ai file with all layers...
I need help with data entry into Excel from various digital files. - **Source of Data**: The information will be taken from digital files, specifically PDF and Word documents. - **Volume of Work**: Approximately 11 to 50 files will require data entry. Ideal candidates for this project should have: - Proficient Excel skills, particularly in data entry. - Ability to accurately transfer information from PDF and Word files into Excel. - Attention to detail to ensure data is entered correctly. - Familiarity with PDF conversion tools and Excel functions. - Ability to manage time effectively to meet deadlines. - Consistency in maintaining data accuracy across files.
I'm in need of a sophisticated Library Management System. The platform should streamline all library operations, from book issuance and returns to inventory management. It should also facilitate user account management. Core Functionality - Book Issuance and Returns: The system should efficiently track books being borrowed and returned. - Inventory Management: It should keep an up-to-date record of all library materials. - User Account Management: The system should support creating and managing accounts for different users. User Types The system will cater to: - Librarians: They should have access to all system functionalities. - Students: They should have access to borrowing, returning and searching for books. - Guest Users: Limited access for browsing and searching purpose...
Title: Urgent Data Checking and Sales Modification Task – 24-Hour Deadline Description: I am looking for a skilled and detail-oriented freelancer to help with an urgent data task that must be completed within 24 hours. The work involves two key steps: Data Checking and Validation: Verify and validate prices in the dataset. Ensure accuracy in "free issue" entries based on the given scheme and stock-keeping units (SKUs). Sales Data Modification: Modify sales data to align with the correct pricing and free issue scheme. Organize the data in a clean and structured format as per my requirements. After you complete these tasks, I will review and finalize the schedule in the data sheet. Requirements: Experience with data ...
I'm seeking a highly skilled data analyst, primarily focused on data analysis using Excel. The successful candidate will need to generate operational reports and should ideally have experience with other analytics tools like Tableau and Zoho Analytics. Excellent written English is also a requirement, as clear and concise communication of findings is key. Key Responsibilities: - Conduct comprehensive data analysis using Excel - Generate insightful operational reports - Utilize other analytics tools for deeper insights Ideal Skills: - Expert level in Excel with pivot table - Proficient in Tableau and Zoho Analytics - Exceptional written English for report generation
I'm looking for an expert who can help me with data entry and organization in Excel. The primary focus will be on the creation of financial reports. Ideal skills and experience for the job: - Proficiency in Excel - Experience in data entry and organization - Familiarity with financial report generation - Detail-oriented and able to maintain high accuracy - Ability to meet deadlines
I'm looking for a Data Science Content Creator and Tutor with expertise in Python, R, SQL, Excel, Advanced Excel, Statistics, Probability, Tableau, and Power BI. The primary focus of the content will be tutorials and guides specifically designed for beginners. Your role would involve: - Creating engaging and easy-to-follow tutorials and guides - Teaching and explaining complex data science concepts in a simple way - Using various data science tools and languages in the tutorials - Covering necessary theoretical concepts such as Statistics and Probability - Creating high-quality video lectures explaining key concepts. - Hosting live Q&A sessions to address student questions. - Designing hands-on projects to apply theoretical concepts. - Developin...
...advanced filters for analyzing chat history (by date, operator, or inquiry type). Automation: Section to customize quick replies or automated messages. Pre-set messages for users in waiting or outside business hours. 3. Preferred Technologies: Frontend: React.js or Vue.js with graphical libraries like , D3.js, or Highcharts for interactive visualization. Responsive design with frameworks like TailwindCSS or Bootstrap. Backend: Node.js (with for real-time communication) or Django. REST API to manage data between frontend and backend. Database: Firebase for real-time data storage or MongoDB for flexible data structure. 4. Additional Requirements: Basic security implementation (encryption of sensitive data and user authentication). ...
I need an experienced Excel expert to modify my existing timesheet with a salary calculator. including : - A variety of financial metrics, specifically a timesheet with a salary calculator based on different staff salary levels. - A comparison of the cost of wages versus our budget. Skills and experience required: Strong proficiency in Excel, experience in financial modelling, and familiarity with creating interactive and automated Excel sheets.
...formatting with knowledge of advanced table features · Insertion of fillable text fields, drop-down lists, date fields, signature fields · Use of section breaks vs page breaks · Insertion and customisation of headers/footers (including different 1st page) · Working with mixed portrait and landscape pages within a document · Linked bookmarks and cross-references · Bulleted, numbered, and lettered lists · Insertion and formatting of graphics and flowcharts · ...
I'm looking for an Excel expert to help me consolidate information from individual staff timesheets into a master view. Key tasks: - Total hours worked and all related hours into a comprehensive weekly view. - Utilizing separate Excel files for each employee's timesheet. - Designing the master view in a standard table format with appropriate graphical representations (charts). Ideal candidates will be proficient in Excel, have experience with data consolidation and analysis, and be able to create clear and informative visual representations of data. Please utilize bar charts for graphical representations.
...posted on the IGEM website. Key Tasks: - Process an Excel spreadsheet containing hundreds of project names. - Identify and extract the corresponding project team member' names (thousands) from a specific section of each project's page on the IGEM website. - Prepare a new excel spreadsheet with project name, team members and a like to their linkedin profile. Ideal skills for this project: - Experience with data processing and Excel. - Attention to detail to ensure accurate identification of project owners. - Ability to follow instructions and work independently. Link to the iGEM team pages (see for example year 2024): Deliver the extracted data in an Excel file. Please use manual extraction of team member names
...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 ...
...Easy for Techs who work remotely to access • We can design excel template for the timesheets which can then easily be cut and pasted into Xero (our accounting package which also does our payroll). • The documents are live However, we are unsure as to whether Google Docs will allow us to do the following: • Have 1 x Google Doc with individual tabs which can be quarantined/separated so that Techs can only view their own (and not other Techs) time sheets/tabs? • Allow 2 x payroll staff working at separate locations to edit the time sheets (individual tabs?) submitted by Techs and also make comments that are visible to payroll staff only and not to Techs. Please advise if you think you can assist and set up something for us with an excel template that we...
I'm seeking a designer to create packaging for a line of professional skincare products. The design should be both professional and elegant, striking a balance that conveys quality without being flashy. Key Requirements: - Design a box that reflects the product's premium nature - Design a simple label that includes a logo, bilingual product name English & French, volume, expiration date, and company URL. - The design should be minimal but not overly simplistic - Experience in skincare packaging design is a plus Ideal Skills: - Strong background in graphic and packaging design - Understanding of the skincare market - Ability to create designs that are both professional and elegant Features of the Packaging: Material: The box have a glossy finish, likely a coated pa...
...who can help me clean up my Excel file by removing disconnected phone numbers. Specifics: - I will be using Twilio as the phone validation service. - It is crucial that the disconnected numbers are completely deleted from the file, not just moved or highlighted. Ideal candidates should have: - Experience with Excel and data management. - Familiarity with Twilio or similar phone validation services. - A keen eye for detail to ensure no disconnected numbers remain in the file. - Strong communication skills to provide updates and clarify requirements. - A problem-solving attitude to identify alternative methods if issues arise. - Excellent time management to meet deadlines promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of ...
I'm looking for someone who can help me gather specific financial data from companies listed on the Saudi stock exchange (Tadawul) for academic purposes. The data I need is from the Balance Sheets of these companies' Financial Statements, and it should cover a specific range of years. Ideal skills for this job include: - Knowledge of financial data and stock markets - Proficiency in data mining and analysis - Familiarity with the Saudi stock exchange (Tadawul) - Academic research skills - Experience with Excel for data organization and analysis. The goal of this project is to obtain a comprehensive set of balance sheet data for analysis and research.
I have approximately 1500 contacts from the California Department of Health website(which you can download free). I need a skilled professional to clean, transform and import this data into Outlook for my sales database. Ideal Skills: - Proficiency in Excel for data cleaning and transformation - Experience with Outlook - Attention to detail - Ability to maintain confidentiality of sensitive data Key Tasks: - Clean and transform the data as necessary - Import the data into Outlook - Validate the data for any duplicates or erroneous entries before cleaning. - Standardize fields to match Outlook’s required format, such as names, phone numbers, and email addresses. - Ensure the CSV file is in the correct format for Outlook import. Ple...
I need a creative graphic designer to produce a fun and playful, multicolored gift certificate for a Christmas present. The recipient will be attending a Holiday Tennis Clinic. Key Requirements: - Incorporate the Fireball logo into the design - Include space for the name of the recipient - Designate a line for the gift person to write in - Specify a section for 'From' - Clearly state an expiry date - Include space for recipient's contact information The gift certificate should embody a 'fun and playful' style and use a 'multicolored' scheme. It should not contain any additional text apart from the standard components. Ideal Skills and Experience: - Proficiency in graphic design - Experience with creating gift certificates or similar items - Ab...
...Status, Deadline, Days Left, Percentage Complete, Date Received, Reference, and End User. • Edit Bids: Users should be able to edit bid details and update their status as needed. The system must support the following statuses, with the flexibility to modify them in the future: "Not Submitted," "Not Awarded," "Cancelled by Customer," "Submitted," "Follow-Up," and "Awarded to Us." • Bid Dashboard: A dashboard to view all active and closed bids, with filters for sorting by date, client, and status. Task Assignment • Task Creation: Users should be able to create tasks under each bid with details like task name, description, assignee, and due date. The team must be notified if the task status cha...
...identifies certain services a customer currently has with us. For example, we have customers who have voice service with us, data service, or both. We want a dynamic report built that will look at the services on a customer’s recurring invoice and put them in categories or filters for the types of service they have. Using the example scenario, we want said report to be able to filter for voice or data service, or a combo of both filters, and list those customers on the report depending on what service filter(s) are set. A full list of the exact filters we want this report to look for will be provided. We want this to look at the recurring invoice in order to be most up to date instead of using static labels that need to be manually updated. Preferred Skil...
Any trending or patterns analysis across all fields in the report. Sample excel file provided when selected for the project.
- Provide an Excel spreadsheet of 200 businesses in Fairfield, CT, that are underperforming, with less than 3 stars and more than 20 reviews. Sheet to have - Business Name - Description - Address - Contact (Phone or Email) - Rating - Website Link
...basic content; however, the developer should help optimize this content for SEO where possible. Additional Features: Blog Section: For educational content related to property deeds and legal advice. Client Testimonials: A section or feature for displaying client reviews/testimonials to build trust. Legal Disclaimer: Include a disclaimer page regarding the services offered. Project Timeline: Start Date: As soon as possible Completion: Preferably within 4 weeks from project initiation, though this is negotiable based on scope and complexity. Budget: Open to Discussion: We aim for an affordable solution that delivers high quality. Please provide a detailed quote including any costs for domain, hosting, or additional plugins/themes if necessary. Deliverables: Fully functional, liv...
I would like an Excel macro that updates my Master Household File with current revenue data I download from a proprietary system in a separate Excel sheet. I would like it to check for duplicate household names in both the New Revenue File and the Master Household File as this does not have to be unique and generate a separate text file to report it so I can manually clear duplicates. I would like to add new Excel rows if the Master Household File if there are new ones in the New Revenue File I would like it add update an X for a household revenue in Master Household File if it is in there but not in the New Revenue File Keep existing additional column data what for each unique row in Master Household File. There could be new ones added or deleted depend...
Share proposed index portfolio performance modelling based on the ASX200 and ASX20 past 20 year historic as compared to the ASX200 and ASX20 index. Needing to model how a proposed share portfolio would have per...be executed if the P/E ratio is greater than 25, this needs to be adjustable The buy and sell orders can be based on prices at the close of the day, or close of the week. This will be compared to the ASX200 and ASX20 indexes over the same period. Deliverables will include an excel file, (or other proposed file) with a summary page of the performance of the proposed index, and the ASX200 and ASX20 indexes over the period including a graph of the comparisons. The file will include the individual by share and by date share prices, P/E, ROE(return on equity), and D/E...
I require assistance with undergraduate-level Excel spreadsheet assignments. Ideal candidates should be proficient in Excel and possess strong academic support skills. The primary need is support with Excel formulas and functions.
QRcreation---- The couple fills ou...memory” button that returns the user to the previous page to upload another photo LACK- Below the button phrase “collect the photos of your guests in an easy, automatic and organized way”. Typography “Oswald” and below phrase, Logo Greetti”. LACK Add image border of comment LACK Create .PDF, store it in the cloud by folder depending on the form data (First Name-Surname-Completion Date in WIX Storage?) and upon arrival of the completion date (indicated in the Frontend Web Bride and Groom form) send by e-mail. NOT VISIBLE TO THE USER- LACK Generate 1 .PDF that has 1 image + comment (Special Elite Typography) per page of all images that have been uploaded and later. LACK Generate another PDF ...
I need assistance with extracting production data from a plain text email into a custom structured Excel file. The ideal freelancer for this project should have: - Proficiency in Excel - Attention to detail - Experience with data extraction and organization. - Experience with scripting languages like Python or VBA. Please ensure you can work to a custom structure before bidding. The data volume is small and manageable. The Excel file needs to be updated with new data from emails weekly. The emails containing production data will be from an Outlook account. The data extraction process should be fully automated to update the Excel file weekly. The preferred method for automation is a VBA macro. The Exce...
I'm looking for an Excel expert to create a basic spreadsheet for analyzing my sales data. The spreadsheet should include: - Pivot Tables: To help summarize and analyze the sales data efficiently. A strong candidate for this project should have extensive experience with Excel, particularly with creating and using Pivot Tables. Familiarity with sales data will be a plus. The goal is to have a functional, easy-to-use spreadsheet that can help me better understand my sales trends.
...evidence is a must. The software should also include version control and change tracking, as well as integration with document sharing platforms like Google Drive and Dropbox. - Reporting and Analytics: The software should generate detailed audit reports, provide dashboards with compliance metrics (like risk trends and completion rates), and allow exporting reports in multiple formats (like PDF, Excel). - Real-Time Monitoring and Alerts: It should monitor compliance performance metrics, and send alerts for deadline deviations or non-conformities. The ideal candidate for this project should have extensive experience in software development, with a particular focus on compliance and audit software. Familiarity with the healthcare, finance, and manufacturing industries would be a s...
I require a seasoned financial analyst to construct comprehensive financial models for investment analysis, specifically for valuing an existing hotels. Key Responsibilities: - Develop a detailed financial model cent...comparable hotels within the market area to support the valuation model. - Evaluate the current and potential capital structure, including debt-to-equity ratios. Please note that I can supply additional information and data as needed. The ideal candidate should be proficient in financial modeling, with a strong background in real estate and hotel industry valuation. Experience with investment analysis and understanding of various valuation methods is essential. Please ensure the final deliverable includes a detailed report. The financial model should be created us...
Looking for an expert to convert my Excel data into PowerPoint. Ideal skills and experience for the job: - Proficiency in Excel and PowerPoint - Experience in data visualization - Attention to detail - Ability to adhere to specified formats and templates
I need a freelancer to scrape text content from a specific website and deliver it in an Excel file.
I'm looking to develop a mobile app for both iOS and Android that helps users find local venues with Karaoke nights. This app should be user-friendly and packed with essential features. Core Features: - Location-based Search: The app should allow users to input their location and will subsequently list nearby Karaoke venues. - Day or Date Specific: Users should be able to specify which night they want to perform. - User Reviews and Ratings: The app will need a section for user feedback on venues, to help others make informed choices. - Venue Details: Provide detailed information about venues such as opening hours, amenities, and entry fees. User-related Features: - User Registration and Login: The app will require a registration and login functionality for users. This can hel...
I need an Excel and PowerPoint guru to transfer my expense tracking data from Excel to PPT. Expertise in creating visually appealing, high-quality slides is a must. The project involves: - Creating two full pages of slides from the provided Excel data. - Making the slides visually appealing and easy to understand. - Completing the project promptly. Please only apply if you are an expert in Excel and PowerPoint, and can deliver high-quality work quickly.
I have two Excel lists that need to be merged and sorted. The data in these lists includes text and numbers, and each list contains three or more columns. Key Requirements: - Merge two separate Excel lists - Sort the merged data alphabetically - Use filters to display specific data subsets Ideal Skills: - Proficient in Microsoft Excel - Experienced in data sorting and merging - Attention to detail to ensure data integrity Please prioritize sorting by the Name columns. The final merged and sorted data should be in Excel format.
I need an Excel-based report that tracks item sales from Zoho Books. The report should be generated at a frequency that you deem appropriate. Skills and Experience: - Proficiency in Excel - Experience in data analysis - Ability to identify sales trends, profit margins, and top-selling items. SAMPLE EXCEL REPORT ATTACHED
I need an expert to convert my Excel data tables into a professional and corporate-style PowerPoint presentation. The presentation should encapsulate a summary of the data findings and a detailed data analysis. Skills and Experience: - Proficient in Microsoft Excel and PowerPoint - Experience in data visualization and presentation design - Ability to distill complex data into digestible insights - Understanding of professional corporate presentation standards - Prior experience in creating data-driven presentations
