Can excel pull data from a closed workbook jobs

I am looking for a capable freelancer to develop a chemical reaction generation model. The goal is to do retrosynthesis, so basically predicting reactants from every SMILES product on my test data. You can use whatever you want(pre trained models or you own script)

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I have website backup which needs to be restore and fix its pages to be in working condition. there are 6-8 pages in total and its simple website. Fixed Budget: 10$

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can ...

I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please ...

...many as possible from the UK and AU to shoot a UGC video on how our product cleans your teeth. Here is an example: Here is our website: **Who we need based on our target audience:** - Female and Male between 35-44, (Mostly Female) - Mostly have a family and childrens or family oriented - Possibly a smoker or regular coffee drinker. **What we need:** - Make a Video about using our product for a few days using our scripts, you can come up with your own but basically we will provide everything. **From us:** - 50-70$ for a ready edited video 60 seconds long. (we can do the editing ourselves) - Our product you will keep and you can use it and save money

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibili...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry ou...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Ex...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I need to have a girl removed from a short, high-definition video of myself and my sister. The video is less than a minute long. The girl to be cropped out is positioned in the middle of the video and I want the edited outcome to feature just my sister and I. Key tasks include: - Identify and crop out the girl from the video - Ensure smooth transition and maintain overall video quality - Final video should be in high-definition Skills and experience necessary: - Proficiency in video editing software (Adobe Premiere Pro, Final Cut Pro...) - Ability to crop out individuals effectively and smoothly - Experience with transitional effects may be necessary - Attention to detail and creativity.

Develop macro-enabled Excel file to handle CSV

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel...

I have written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folde...

*About Us:* We are a dynamic and innovative social media marketing agency dedicated to helping businesses thrive in the digital landscape. Our team is passionate about crafting creative strategies and delivering measurable results for our clients. *Role Overview:* As a Lead Generation Expert, you will play a crucial role in identifying and engaging potential clients interested in our social media marketing services and closing deals with them. You will utilize various research and outreach techniques to identify leads, initiate conversations, setup sales call, and nurture relationships with prospects. *Key Responsibilities:* 1. Research and identify potential clients through online platforms, industry directories, and social media channels. 2. Develop and maintain...

I have a photo where I would like to remove a person who is on the side. (Want to keep only the girl in the black shirt) remove the other one on the left of her Key requirements: - Remove the person on the side of the photo while keeping the background intact. The background is mixed, with some areas more complex than others. It's essential that the background maintains its original look, even after the person is removed. - The final use of the edited photo will be for personal use, so the editing needs to be of a high quality. Ideal freelancer: - Previous experience in photo editing, specifically in object removal while maintaining the background. - Proficiency in tools like Photoshop or similar software. - Attention to detail and ability to deliver ...

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

I have a project that involves creating a custom website. The website will be a product catalog for windows, with a design similar to quartzluxurywindows.com. AND a 10 pages Product Brochure/booklet from a sample hardcopy Key Features: - Product Catalog: The main functionality of the website will be to display the range of windows that we offer. The windows should be categorized by product type, similar to the organization on quartzluxurywindows.com. Requirements: - Experience in developing custom websites, particularly product catalogs. - Strong understanding of web design with an emphasis on user experience. - Ability to replicate the design and functionality of an existing website (). - Familiarity with organizing products by category...

Do you have a deep understanding of Hyper converged infrastructure, cloud solutions, Virtualization and datacenter modernatizatio and a knack for translating complex technical concepts into clear, concise writing? We're seeking a skilled freelancer to create informative papers on various aspects mentioned below The ideal candidate will possess the following qualifications: In-depth knowledge of leading HCI solutions: VMware vSAN, NSX, HCX, Azure Stack HCI, etc. Solid grasp of HCI architecture: Distributed storage, software-defined networking, and resource management. Experience deploying, configuring, and managing HCI clusters: Proven track record of hands-on experience.
 Cloud Platforms : Proficency in major cloud platform like Azure, AWS or GCP. 
Experience ...

I have a project that involves creating a custom website. The website will be a product catalog for windows, with a design similar to quartzluxurywindows.com. Key Features: - Product Catalog: The main functionality of the website will be to display the range of windows that we offer. The windows should be categorized by product type, similar to the organization on quartzluxurywindows.com. Requirements: - Experience in developing custom websites, particularly product catalogs. - Strong understanding of web design with an emphasis on user experience. - Ability to replicate the design and functionality of an existing website (). - Familiarity with organizing products by category. Optional: - Knowledge of SEO best practices to ensure the website is search engine...

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A...

I have a Microsoft Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word

I'm seeking a skilled professional who can help me with a malware issue affecting multiple websites I own. - All my websites are experiencing the same type of malware. - The primary issue I'm facing is the presence of the malware on the websites. The ideal candidate for this job should have the following skills and experience: - Proven experience in malware removal and website security. - Familiarity with various malware scanning tools. - Implement security measures to avoid future attack

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? ASAP.

...looking for a skilled Power BI developer who can create detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a...

Recreate about 90 slides to a popular learning platform. Some images may need to be resized or replaced with stock images.

SEO from 17th May to 16th June

I have 20 pages that need some content generated from ChatGPT and entering on to the page. This includes a short bit of text (150 words) for the main content and YOAST meta descriptions. I'll provide full instructions and the correct prompts to use with ChatGPT. This is a super simple copy and paste job and should only take a couple minutes per page. Please be familiar with WordPress and ChatGPT so you can get this done quickly. Also you will need to update the DNS in your local hosts file to be able to access the site (I can show how) This is 1hrs work at most so please bid accordingly.

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with ...

Develop or sketches to run dual processors in circuit as described in schematic , The light, called Eos 24, has three use cases or modes: 1. SW1 is closed: The neopixel runs constantly until SW1 moved to open. 2. SW1 is open: The neopixel runs when the PIR is triggered until interval4 is elapsed. When SW1 is open and interval4 is elapsed Eos 24 is in standby mode and the Neopixel is dark. 3. SW1 is open and interval4 is elapsed. This is standby mode and the Neopixel is dark until the PIR is triggered again.

I need a TikTok agency business center that has worldwide targeting. And the BC should have a quota of creating 300 ad accounts.

I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround

Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract

...VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunit...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with ...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I have a hand-drawn ISO currently in JPEG format that I need converted into a 3D CAD model. I prefer the conversion to be done using AutoCAD. Requirements: - Proficiency in converting JPEG files to 3D CAD - Extensive AutoCAD experience - Ability to produce medium level detail on the model The successful freelancer should be able to identify basic shapes and some fine features from the hand-drawn ISO and replicate them precisely in the 3D CAD model.

I have an idea centere...centered on love and relationships, submitted in the form of a drama and comedy hybrid, which I'd now like transformed into a comprehensive screenplay. The final product should be prepared to appeal to a broad, general audience. Ideal Candidate Skills and Experience: - Previous experience in writing screenplays, specifically in the drama and comedy genres - A good understanding of the subtleties and nuances unique to the theme of love and relationships - Ability to target content towards a general audience Responsibilities: - Convert the provided idea into a compelling, engaging screenplay - Ensure the theme of love and relationships is comprehensively conveyed - Align the final product with the requirements and st...

...someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularl...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and f...

Please Sign Up or Login to see details.