Excel refresh import data automunkák
Problem: we want to be reminded / flagged when a contract should be renewed / re-tendered. We want to reminded / flagged six months before the contract expires. The data point we have is the contract expiry (dd/mm/yyyy). Solution: if the contract expiry is less than 6 months away, please make column H red. It needs to be done in a google sheet and in excel.
I am in need of a meticulous data entry clerk, proficient in both text and numeric data entry. The project involves entering 200-250 items into a pre-provided template. Ideal skills and experience: - Proven data entry work experience. - Strong language skills. - High levels of attention to detail. - Experience with data entry software. or in an excel template - Experience working with templates. Please note: The excel template for data entry will be provided, I'll need you to follow the structure precisely and ensure you maintain high levels of accuracy. The data provided will be a mix of text and numeric data. Fields (Columns) will be : date = date field supplier name = text field nature of items...
I am seeking a professional ...am seeking a professional with strong capabilities in Excel who can assist in creating 5-10 filter views on an online Excel sheet. The successfully completed project will include: - Ability to filter numbers, text and dates with precision - Filter views applied effectively on each individual column - Advanced understanding of Excel to ensure seamless integration of filter views The ideal freelancer for this job will have experience with complex Excel tasks, especially filter views. Your expertise should include a strong understanding of Excel formulas, data types and the ability to navigate and edit online Excel sheets with speed and accuracy. Your work will significantly improve the functionality of my sprea...
I have two lists of invoice numbers and associated amounts, formatted in Excel. I need a worksheet created that will compare these lists and highlight any invoice numbers that cannot be found and their corresponding amounts. The comparison results should be incorporated into existing sheet 1. Additionally, the data in these invoice lists includes dates, invoice numbers, and transaction amount. Ideal freelancers for this project should be: - Highly proficient in Excel - Experienced in data comparison and highlighting functions - Able to work with data that includes dates and transaction amounts.
I'm in need of an Excel expert who can utilize Excel macros to automate several of my routine tasks. The main actions to automate are listed below: - Data Entry - Generating Reports These tasks are currently taking a significant amount of time and I'm confident that with the right automation, efficiency can be greatly increased. Ideal candidates should have extensive experience in using Excel macros for automation and report generation. A deep understanding of Excel and automated data entry via macros is essential for the successful completion of this project.
I'm looking for a web designer to recreate two pages on my website (currently using the Avada Theme) in the Astra Theme and using Elementor: 1. Homepage 2. About Us page If you know the Astra Theme and Elementor really well, I'd love to hear from you. Here's my current website: When you respond to this job posting, please start off...pages on my website (currently using the Avada Theme) in the Astra Theme and using Elementor: 1. Homepage 2. About Us page If you know the Astra Theme and Elementor really well, I'd love to hear from you. Here's my current website: When you respond to this job posting, please start off your bid with "ASTRAMAN" so I know you read the job posting instead of just auto-responding. Thanks!
I'm seeking a highly skilled freelancer to assist with data processing tasks. Key Responsibilities: - Process various data efficiently Please note, the source of the data to be processed is unspecified at this point. Timeline: - There is no strict deadline for project completion. However, a sense of urgency is appreciated Ideal Skills: - Solid data processing capabilities - Prompt delivery and high-level accuracy - Exceptional problem-solving skills Experience in the data entry field If you think this project aligns with your skills, I'd love to hear from you.
Creation of a real estate acquisition model including Cash flow, tenancy schedule, lease modeling and renewal assumptions, IRR, levered and unleverred. Including formula to play with the model.
We provide to our customers "", Online Cloud/Browser based Video Editor Software, which supports auto subtitles, auto translations, AI Voiceovers, collaborative remote video editing and AI generated video content with our AI director tool. - Auto Subtitles - Auto Translations - Subtitle Editor - Online Collaborative Editing - AI Voices - Text To Speech - AI Image Generated Content for your videos - Transform Landscape videos to Portrait - Convert video content to other formats - Free Stock Videos, Images and Audio - Add Templates to your videos - Add Webcam and Screen recordings to your videos - Audio Noise Removal for your videos This is what we have now in our social media pages : @videooteam We are looking for hiring
I have multiple Excel files that require thorough cleaning. The data inconsistencies that I need addressed include duplicates, formatting errors, and incorrect entries. There's also a need for merging, splitting, and conditional formatting. Ideal candidates for this project should be proficient with Excel and have experience in data cleaning. They should also be adept at identifying and solving data-related issues. Ultimately, I need all duplicate entries to be removed from these files. • SKILLS REQUIRED: - Proficiency in Excel - Experience in data cleaning - Ability to merge and split data - Familiarity with conditional formatting
I have developed SPFx React Webpart Fetching Timeapi Data ,getting CORS error, want someone to troubleshoot the issue I can give complete solution file It will: - Fetch current time and date. - Display the fetched information as a text string on the webpart. - Update data only on page load, it doesn't need to refresh it at regular intervals. The ideal developer should have significant experience in SPFx development using React, and understand APIs, specifically Timeapi. Clear and efficient code is vital and knowledge around user interface for displaying the fetched information in a Restful way is advantageous.
Project Description: We are seeking a talented graphic designer to create a captivating social media flyer for our online course. The course targets individuals aged 15-25 and course name is Data analysis with MS Excel Requirements: 1. Design must be visually appealing, professional, and in line with our brand identity. 2. The post should include engaging visuals and concise, compelling copy to capture the audience's attention. 3. Dimensions: WhatsApp status, WhatsApp post, Instagram 4. Incorporate relevant course details such as course name, key benefits, and a call-to-action (e.g., "Enroll Now"). 5. Use our brand color pallette 6. Provide the design in a high-resolution format suitable for social media posting. Deliverables: - One social media post design...
I require a comprehensive spreadsheet created that compares four different real estate brokerages. The spreadsheet should contain multiple...spreadsheet created that compares four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the following aspects: - Fees - Number of transactions closed - Average price point - Stock options - Agent attraction For the 'number of transactions closed', I wish to use a preset value for each brokerage. Moreover, I want the 'fees' data structure to be tiered. Candidates with excellent Excel skills are preferred. It's also beneficial if you have a good understanding of real estate brokerage fees and structures. Attention to detail is essential as the spreadsheet needs ...
I require expertise in extracting purchase details from text-based PDF attachments in my Outlook emails and compiling this data in an excel sheet. Key tasks: - Set up a platform that automatically imports data from new email attachments - Extract purchase details from these attachments - Place this data into an Excel sheet accurately. Skills and Experience: - Proficient in Microsoft Outlook and Excel. - Knowledge of data extraction from text-based PDFs. - Automation experience, ability to set up a system that triggers upon receipt of a new email. - High attention to detail required. - Previous work in data extraction or related fields is a plus.
**Position: Freelance Lead Generator for Islamic Home, Commercial, and Auto Loans in the UAE** **Description:** We are currently seeking proficient freelancers to assist in generating leads for Islamic Home, Commercial, and Auto loans in the UAE. As our valued partner, you will play a pivotal role in identifying and nurturing leads, ensuring they are diligently vetted, contacted, and poised for closure before reaching our team. **Key Responsibilities:** - **Seeking Expertise**: Proficient freelancers wanted to generate leads for Islamic Home, Commercial, and Auto loans in the UAE. - **Thorough Vetting Process**: Leads must undergo meticulous vetting, including contact and readiness for closure, prior to reaching me. - **Long-Term Opportunity**: This engagement offe...
I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub
Tengo el inventario de la tienda ya escrito, pero nescesito tenerlo en un excel para que sea mas dinamico y facil de usar.
I need a meticulous person with a keen eye for detail to hunt down and manually input contact details from an event's website into an Excel file. Key Responsibilities: - Collect the data fields: Name, Email, Phone Number, Company and Sector from the website. - Store data in an organized manner in a .xls Excel file. Ideal Candidate: - Someone with experience in manual data entry - Attention to detail, as accuracy is of utmost importance - Please provide examples of past work demonstrating your data entry skills I look forward to seeing your applications and choosing the best fit for this job. Remember, past experience counts!
Hi, I need to extract data and images from product pages into an Excel file. Here is an example link - Video showing it - ATTACHED FILE is the format it needs to go into so I can import it into WooCommerce Product name All images Price About this product Details Variations: color, size, etc
...a meticulous and detail-oriented freelancer to concentrate specifically on the following for an unspecified number of Excel files and bank statements: - Date Formats: Ensure all dates are consistent - Transaction Types: Verification and correction of all transaction types - Narrative Consistency: Ascertain uniformity in transaction narratives Ideal skills for the job would include extensive proofreading experience and in-depth knowledge of Excel data and bank statements. Any examples of past work or detailed project proposals you could include in your application would be beneficial. Please be prepared to dive into a project of an undefined size, as the number of Excel files and bank statements has not been specified. With your assistance, I'm confid...
...skilled graphic designer who can develop a series of medium-sized, flat design styled icons for our digital courses. These courses encompass topics including Excel, PowerPoint, MS Project, and Power BI. The icons should follow the style of the ones we already have for our HSE (Health, Safety, and Environment) courses, maintaining consistency across our course offerings. Ideal Skills and Experience: - Proven experience in designing intuitive and visually appealing icons - Proficient in Adobe Illustrator - Strong understanding of flat design principles - Prior work on digital content or courseware would be a bonus - Familiarity with Excel, PowerPoint, MS Project, and Power BI for context-oriented design. Requirements: - Maintain consistency with the style of icons used fo...
Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but 3 results is seemed, adding more columns at the final table (see atta...
I'm seeking a freelancer proficient at data entry for impending tasks. The job involves entering both numerical and textual data. Details: - You will need to enter a mixture of numeric and textual data. - Accuracy is crucial to ensure the quality of data entry. - The finalized data should be provided in an Excel spreadsheet. Skills and Experience: - Proficient in data entry. - Strong attention to detail. - Experience using and formatting Excel spreadsheets.
I have two excel files. In the file, I want you to color code cells from B2:E2 to the end of the columns with text as either green, yellow, orange, red for how closely the text in one cell matches in another. Green - perfect or near perfect match Yellow - most of it is good Orange - less than 70% match Red - poor match or no match I roughly counted there are about 2000 cells.
I'm looking to hire someone proficient with Excel to reconstruct a spreadsheet using a template that I will provide. The new version should replicate the original as closely as possible, without any added functionalities. Key requirements: - The spreadsheet should have exactly the same type of data as the original one. - You will not need to incorporate functionalities such as formulas, calculations, data validation or conditional formatting as they were skipped in the requirements. I want to ensure that my project is in good hands, therefore, your experience is crucial to me. During your application, kindly detail relevant experiences you've had recreating or working with spreadsheet templates. Looking forward to finding a trustworthy and knowledgeable ...
Move/migrate 4-5 Wordpress websites from 1 shared server hosting provider to another. You should have experience in doing this and technical skills with all aspects such as FTP, WP installation, DB import and knowledge to fix issues with too long filenames, perma-links, SSL etc. Its important with good communication, good response time and good skills in english.
I am seeking an Excel expert who can provide in-person training on ‘Budgeting and profit and loss projections’ for one person. I already has an intermediate understanding of Excel and we need further training on: - Basic Excel Functions: The trainer would be expected to reiterate on the basic functions to ensure a strong foundation for the subsequent practical sessions. - Creating Formulas: The ability to create and manage formulas is the next skill we wish to hone. This includes all the necessary functions to perform complex calculations for our projects. The spreadsheet has already been created, it needs to be corrected a little but can be explained further in the training session. This training should be tailored to suit individuals with intermediate ...
I urgently require a meticulous and professional proofreader, well-versed in Japanese, to refine four not-safe-for-work (NSFW) lan...not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Japanese. You will be provided 6 landing pages that you will need to open with a browser language set to Japanese. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is highly val...
Hi there! I'm Sourabh Dhos a detail-oriented individual with a knack for data entry. I thrive in fast-paced environments where accuracy is key. Proficient in ( Excel,ms word,I ensure data integrity while meeting deadlines.
I have serveral raspberry Pi task so I need Pi expert for this task. Don't auto-bid and start with "Raspberry"
Looking for an individual to accurately transfer numerical information and tables from PDF to Excel. Previous experience in data entry will be advantageous. Ideal skills and qualifications: - Beginner level experience in data entry or similar roles - Proficient in Microsoft Excel - Excellent attention to detail - Ability to interpret and analyze data Example attached.
The aim is to build a comprehensive business plan for my IT Service, consulting tech...attract investment. To this end, I need a professional who can effectively portray my business and future prospects through this plan. Key Requirements: - Incorporation of financial projections for more than 5 years into an Excel sheet. - Strong understanding of the technology service industry. - Experience in developing business plans specifically for investment purposes. Skills and Experience: - Excellent financial modeling skills. - Profound knowledge of the technology industry. - Experience in preparing business plans for fundraising purposes. - Proficiency in Excel. By effectively portraying my business strategy and financial future, you'd provide the key tool I need to secu...
Task: Write an selling email to our customers who have ordered a system before (BLP-990A) about new updating/host available. Our customer have ordered this unit since before updating host available for them with new/updating functions as below: Replacement box for OLDER BLP-990A or BLP-950A (Only host, display is not included) Version 1: 8 – CORE A55 1.6Ghz 2GB ROM 32GB RAM Android 12 Bluetooth 5.0 DSP Front and Rear Camera IOS CarPlay (Wireless and USB) Android Auto (Wireless and USB WiFi 2.4G 4G SIM CARD 360* Bird View Version 2: 8 – CORE A55 1.6Ghz 4GB ROM 64GB RAM Android 12 Bluetooth 5.0 DSP Front and Rear Camera IOS CarPlay (Wireless and USB) Android Auto (Wireless and USB WiFi 2.4G 4G SIM CARD 360* Bird View
I'm searching for an individual specialized in data mining and web scraping who can help me extract specific product information from an e-commerce website. Key Responsibilities: - Locate and extract specified data from the selected e-commerce site - Ensure collected data is reliable and structured properly Ideal Candidate: - Has in-depth knowledge in Web Scraping and Data Mining - Is familiar and proficient with Excel as the required output format is an Excel file This project aims to support a larger market research initiative, thus accuracy and attention to detail is critical. Only professionals with proven experience in similar projects need apply.
I'm experiencing an issue with my pbix file. Despite the fact that my data is neatly structured on a single worksheet with multiple tables in Excel, it is not refreshing in the pbix file when expected. Given the nature of this problem, it's clear that an expertise in data management with Excel and Power BI is necessary for this project. Proficiency in troubleshooting Power BI related issues is also a must. The primary tasks will include: - Analyzing the pbix file and the associated Excel worksheet - Pinpointing the cause behind the failure to refresh data - Implementing a fix to ensure smooth data refresh in the future The preferred freelancer should be experienced with: - Power BI (especially .pbix files) - Ex...
I need to add 3 pages and input content I will provide to you. About US Page Privacy Page - already linked, but need to update content. Shipping Page There is one block with Brand Logos, I just want to hide that for now. I need to find an extension to add brands later. Need this completed asap.
...experience to our customers. Responsibilities: Order Management Integration: Ensure that all new orders and associated customer and billing details are automatically synchronized from Magento to Dynamics 365. * Implement mechanisms to handle order updates and cancellations to maintain data consistency across platforms. Inventory Management Integration: * Develop processes to reflect any product creation or updates in Microsoft Dynamics 365 within Magento, along with all related product data. * Ensure seamless synchronization of inventory levels and product availability between Magento and Dynamics 365. Customer Engagement Enhancement: * Enable a complete 360-degree view of customers within Microsoft Dynamics 365 to provide them with a ri...
I have a specific goal for this project, which involves web scraping and organizing data into a comprehensive Excel spreadsheet database of UK care homes. The work scope includes: - Extracting contact details (both phone numbers and emails) of each care home - Categorizing the extracted data based on care home location The ideal freelancer for this job should hold the following skills and experience: - Proficient in web scraping - Knowledge of categorizing or sorting data - Excel spreadsheet expertise Accuracy and attention to detail is crucial in this task. This project is suitable for individuals who have previously demonstrated efficiency and success in similar roles. Resource could be
Hi Salma A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...operations. Primarily, I need a skilled Python developer to integrate the Angel Smart API with Microsoft Excel. Areas of concern include: - Developing data retrieval and analysis functionality: This involves retrieving and analyzing stock prices. - Option chain data management: I am specifically looking for functionalities like real-time option chain data retrieval, historical option chain data retrieval, and sophisticated analysis and visualization of the gathered data. - Creating an automated reporting system: In order to keep track of market conditions, an automated system for generating reports is essential. The ideal candidate should be expert in Python, comfortable with Excel, and have experience working with Angel Smart API. A...
...professional in Excel to develop an automated dashboard for my business. The system will need to manage data entry, data analysis, and reporting - all automated. Key tasks will include: - Setting up a dashboard connected to Excel files with automation functionality. - Automating cleaning up and processing of data for analysis. - Developing reports with automatic generation feature. Regarding data visualization, the dashboard should be capable of generating pie charts, line graphs, and bar graphs as per the data analyzed. You should be proficient in Excel and familiar with data visualization techniques. Experience in automation and connecting Excel with other data sources will also be an advantage. I have att...
I'm seeking a proficient data specialist who can successfully convert a CSV file into an XLSX Excel format. This conversion needs to be done meticulously to ensure optimal usability for sharing data with others. Key responsibilities will include: - Converting a CSV file into an XLSX format - Checking data integrity post-conversion - Ensuring the final layout is easy to understand and use for sharing with others The ideal freelancer for this job has extensive experience with Microsoft Excel and, more specifically, with CSV to Excel conversions. This is a one-off project, but I'm interested in a flawless output. Accuracy and meticulous attention to detail are critical for this task.
I urgently require a meticulous and professional proofreader, well-versed in Italian, to refine four not-safe-for-work (NSFW) landin...but not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Dutch. You will be provided 6 landing pages that you will need to open with a browser language set to Dutch. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is highly val...
I have a requirement for an advanced Excel specialist to develop a structured Gantt chart. More details will be provided to shortlisted candidates.
I need to establish a Local Area Network (LAN) in my office. The system should connect four PCs with one acting as the file server while the other three will be clients. Right now we use auto configurations and we keep having problem with printer or files not being shared properly and network errors. We need exact IP configurations of each PC so that there is no problem in file and printer sharing. Setup Details: * The Operating System for all the computers must be Windows. * Our network will utilize a switch with an integrated LAN internet connection. * The server PC should function primarily as a file server. * There 3 printers connected to server and 1 to a client. All 4 printers are shared across network. * Screenshot of advanced sharing setting and TCP/IP setting is attache...
Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!
I am in need of an Excel operator to assist with data entry tasks. Ideal candidates would have extensive experience in Excel and be confident in their data entry abilities. Skills and Requirements: - Proficient in Excel data entry - Attention to detail - Experience with Excel formulas is a plus Application Details: Applicants should include their Excel experience details in their application. Please provide information about past related work, specifically focusing on data entry tasks in Excel. Tasks to be Performed: - Input various data points into Excel spreadsheet accurately - Handle high volumes of data entry - Maintain the integrity and accuracy of the data If this sounds like someth...
I have serveral raspberry Pi task so I need Pi expert for this task. Don't auto-bid and start with "Raspberry"
...developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and handling large...
