Extract database information excel jobs

I need an Excel template tailored for my existing business to manage deliveries, sales, and balance quantities on orders. Key Features: - Advanced Formulas & Conditional Formatting: I require this to ensure the template is robust and can visualize data effectively. - Data Points Tracking: I need the template to include sections tracking: - Product names and categories - Customer names and contact details - Delivery dates and quantities - Profits and balances on Purchase Orders (POs) - Daily load outs reports The ideal freelancer for this job should have: - Proficiency in Excel, with extensive experience in creating advanced templates with conditional formatting. - A good understanding of business processes, especially in sales, deliveries, and inventory ...

I need a freelancer who is proficient in research and data collection. The task involves sifting through the websites of independent bookstores located specifically on the East Coast of the US and acquiring the contact information of procurement officers. Key Tasks: - Identify independent bookstores on the East Coast - Extract the email addresses of the procurement officers Required Skills: - Excellent web research skills - Proficient in the English language - Exceptional attention to detail - Data collection and organization The final dataset should be delivered in a spreadsheet. Please ensure all collected email addresses are valid and error-free. This project could certainly become a repeat job for thorough and efficient freelancers. Having an interest in the book in...

I have a project that entails transferring text data from a PDF into Excel. Given that the information is well-structured, this task should be a smooth process for anyone proficient in data entry and comfortable handling documents in both PDF and Excel formats. Key Tasks: - Transcribe text accurately from the PDF to Excel - Ensure data maintains its structured format Ideal Skills: - Extensive experience with data entry - Proficiency in PDF and Excel - Detail-oriented and high accuracy rate A successful completion of the project would entail an Excel sheet in which the transferred text data from the PDF maintains its original structure.

...specific data from a website containing a list of potential investors. The project requires an attention to detail as well as proficiency with Excel or similar spreadsheet software. Key tasks: - Visit a pre-specified website and navigate to the list of potential investors. - Carefully extract the following details for each investor: Name, Fund name, and 'Sweet Spot' investment amount. - Collate this information in a well-organized Excel spreadsheet. - Find and add a link to each investor's LinkedIn profile alongside their extracted details. Specific requirements: - A meticulous approach to uphold the accuracy of data. - Experience or familiarity with Excel or similar spreadsheet software. - Strong data extraction and entry skills. - ...

...up and configure a MySQL database with Oracle APEX. The main purpose of this setup is to manage and retrieve product inventory and sales transaction data. Key tasks include: - Designing the database to efficiently handle product inventory and sales transactions. This involves creating an Entity-Relationship Diagram (ERD), and writing Database Definition Language (DDL) and Manipulation Language (DML) statements. - Configuring the Oracle APEX environment to interact with the MySQL database and ensure smooth data retrieval and management. - Ensuring the system is secure, ensuring no unauthorized access to the database. - Providing a high-level overview of the system's architecture and functionality. Skills and experience required: - Strong expertis...

I need a Django professional to manage a sensitive task involving the masking of our project's database. Your primary role will entail implementing encryption on our data. Key Responsibilities: - Generate an encryption key. You’ll be responsible for creating a robust and secure encryption key. - Implement Database Encryption. Utilise your Django expertise to seamlessly integrate encryption without compromising the performance or accessibility of our database. - Maintain Data Format. It is critical that the encrypted data retains its original format. Ensure that no distortions occur during this process. Ideal Skills: - Proficient in Django - Knowledgeable in database structures and encryption - Proven ability to generate secure encryption keys - Exp...

Excel to Invoice Automation System My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new a...

Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, ...time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what S...

...am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust data...

I have a project that involves entering textual data from physical documents into a database we are creating. Key details: - The data is textual in nature and will be provided to you in physical document form. You will need to accurately transcribe this information into our database. - The primary goal of this project is to create this database. Ideal skills and experience: - Strong attention to detail is critical for this project as accuracy is a key requirement. - Previous experience with data entry is preferred, especially when working with physical documents. - Familiarity with database software would be a bonus, although not necessary. - Excellent organisational and time management skills to ensure the project is completed efficiently.

write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru

...management. Therefore, we're seeking an expert in Excel to build us an inclusive inventory management template. The template should possess the following specialized features: - Product Categorization: A way of classifying each product for straightforward identification and reference. - Stock Tracking: The prime functionality we're seeking. Notably, it should track items by product name. This will ensure precision in monitoring our inventory and prevent replication or confusion. - Comprehensive SKU Tracking: It should encase a complete and precise representation of our stock movements. Specifically, it should include incoming stock, outgoing stock, and current stock levels. An ideal candidate for this job should have extensive experience in Excel, particularl...

Hi Shujoy S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Shujoy S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm in need of a freelancer who is skilled in designing both process and workflow flowcharts via Microsoft Visio, as well as project management checklist forms in Excel. The checklist should be of an intermediate level complexity, incorporating features such as drop-downs and validation. Prior experience in constructing Visio flowcharts and Excel forms is imperative to understand the project's need thoroughly. Proficiency in Excel functionalities would make tackling this task comparatively easier.

I am seeking a skilled programming expert, proficient in either Ruby or Python, with intermedi...primary task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CSV conversion - Familiarity w...

Entering data into an Excel sheet is the primary task for this project. Unfortunately, I cannot specify the volume of data that needs entering as I skipped this information. However, please rest assured that there is no immediate rush, so you can complete the project at a pace that suits you. Ideal skills and experience for this job would include: - Proficiency in Excel data entry - High attention to detail - Excellent typing speed and accuracy - Relevant experience in data entry jobs If your profile matches these criteria, I'd be delighted for you to submit a bid. Looking forward to potentially working with you.

I'm looking for a skilled data entry professional who can assist me with inputting data. The exact details of ...data and proficient in working with different formats. Your responsibilities will include, but are not limited to: - Efficiently and accurately entering data into the required format - Ensuring that the data is correctly categorized and organized - Checking for errors and handling them appropriately Ideal Skills and Experience: - Proven experience in data entry - Proficiency with Microsoft Excel and other relevant software - Strong attention to detail and accuracy - Excellent time management and organizational skills Please note that the volume of data may vary depending on the project, so a flexible approach and willingness to adapt to different task size...

I need a proficient expert in Excel to type numeric data and carry out basic arithmetic calculations. The scope of the project includes: - Data entry of numeric information into an Excel sheet. - Applying basic arithmetic operations to the input data. The ideal candidate should have: - Proficient skills in Excel, specifically with numerical data entry and calculations. - A keen eye for detail ensuring accuracy in calculations. - An excellent understanding of basic arithmetic operations.

I'm seeking a professional who can assist in extracting data from a series of printed images using Text Recog...seeking a professional who can assist in extracting data from a series of printed images using Text Recognition (OCR) technology. Key Responsibilities: - Utilize OCR to extract text from printed images Ideal Skills and Experience: - Proficiency in OCR technology - Experience in data extraction from printed images - Attention to detail to ensure data accuracy - Ability to handle a large volume of images Please provide examples of similar projects you've worked on and any relevant experience with OCR technology. In your bid, kindly include an approximate timeframe for completing the project and any additional information on how you can contribute to t...

...it to draw IMEI numbers both randomly and from a database based on specific parameters. Key Features: - **Dual Functionality**: The tool should be capable of generating IMEI numbers randomly or by allowing me to specify certain parameters. - **Parameter Selection**: The parameters that I should be able to choose from when generating IMEI numbers are the device brand and the operating system (OS). - **Web Interface**: The tool should be accessible through a user-friendly web interface that allows me to easily generate the IMEI numbers. Skills and Experience: - Proficiency in Python, as I believe the tool can be built on existing scripts like ``. - Experience in working with databases, ideally with knowledge of the TAC database. - UI/UX design skills to create a simple an...

...competent freelancer with an understanding of MS Access Database creation. This project is aimed at developing a food manufacturing cost-tracking function on top of an existing product management database, while cleaning the existing database up and adding reporting functions. The project involves: 1. Cleaning up existing Database file of Products to a new layout (Can start again or build on existing file). 2. Adding the manufacturing cost analysis function to the database (Allows user to define ingredients and fixed costs for a product and calculate it’s cost price). 3. Adding the sub-recipe costing function – same as above, however, for internal products not sold. 4. Adding the ingredient purchase price and tracking to the database...

I need a detail-oriented and focused individual who excels in manual data entry to convert data from my physical documents into a spreadsheet. Requirements include: - Transferring data from paper formats into a computer system - Strong typing speed and accuracy - Experience with MS Excel or similar spreadsheet software - Ability to maintain confidentiality when handling sensitive information. Accuracy is absolutely critical for this project, so keen attention to detail is a must. Previous experience with similar projects will be highly regarded.

I am seeking an expert on DSpace who is able to handle a task involving the extraction of PDF files and metadata into a comma-separated file. The main responsibilities for this project are: - Comprehensive understanding and experience with DSpace - Ability to extract PDF files and associated metadata - Capability to arrange the extracted data into a comma-separated file Skills and Experience Required: - Knowledgeable about DSpace - Advanced experience with data extraction and arrangement - Strong understanding of databases and data manipulation - Excellent problem-solving abilities This project needs to be completed as soon as possible, so any interested freelancers with immediate availability will be much preferred for this opportunity. Please bid after a thorough understandi...

...ensuring that the system is not abused. Ideal Skills: - Experience in web development, particularly database management and user account systems. - Knowledge of online casino games and understanding of user interactivity. - Proficiency in creating a user-friendly interface for rating, reviewing and discussion. - Ability to integrate a comment section and discussion forum. - Prior experience in developing similar platforms would be a plus. If you are confident in your ability to deliver a platform that will meet these requirements, I look forward to working with you. ---------- - entering site will have you choose which casino , , , etc. - must find way to "extract live" from each specific site all the games/slots on their site, and include game picture, d...

...Responsibilities: · Conduct market research to identify customer needs and market trends to drive product development decisions. · Analyze the FinTech/WealthTech landscape, including competitors, market trends, and regulatory changes. Identify opportunities for product innovation and differentiation based on market demands and user feedback. · Utilize quantitative and qualitative data analysis techniques to extract meaningful insights from user interactions and market research. Translate data into actionable recommendations for product enhancements. · Create user personas and journey maps based on research findings to facilitate empathy-driven product design. Ensure that product features and functionalities align with the needs and goals of target use...

I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick,Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR an...

I need a proficient freelancer to extract and simplify excel data encompassing text, numeric, and date and time data from a significantly sized data file (approximately 5000 rows). The simplified output should be in the form of an Excel file. Ideal Skills and Experience: * Proven experience in data extraction and simplification. * Proficiency in Excel. * Excellent attention to detail. * Ability to work with large datasets. Responsibilities: * Carefully extract specific data segments. * Accurately simplify data for ease of understanding. * Convert the processed data back into an Excel file. * Ensure absolute accuracy throughout the process.

I need a skilled professional who can create some form of wizard (general office365 tools) that lets me enter personal and cv/resume types of data and then turns it into a word based cv using layout that I will provide. The word cv template must be amendable by me. The output is to remain a word document. I need it to be something that will work when my computer is offline not connected to internet I have attached a first cut of the word document template and it is the hello highlighted pieces that represent the inputs and show how/where tables need to be populated. the intent is to enter data and have a consistent cv created for all members

I'm in need of someone to assist me with typing text data into an Excel sheet. The data will be provided in a digital format (PDF, Word, etc.). Key requirements: - Accurate and fast typing skills - Proficiency in Excel for proper data entry - Familiarity with using specific fonts and sizes for consistent formatting - Experience with data sorting and filtering in Excel Your attention to detail and ability to follow formatting guidelines is crucial. The ideal candidate will be organized, efficient, and able to deliver high-quality work within the agreed timeframe.

I'm in need of someone to assist me with typing text data into an Excel sheet. The data will be provided in a digital format (PDF, Word, etc.). Key requirements: - Accurate and fast typing skills - Proficiency in Excel for proper data entry - Familiarity with using specific fonts and sizes for consistent formatting - Experience with data sorting and filtering in Excel Your attention to detail and ability to follow formatting guidelines is crucial. The ideal candidate will be organized, efficient, and able to deliver high-quality work within the agreed timeframe.

I'm in need of an expert who can assist with entering text data into an Excel spreadsheet. Key Responsibilities: - The primary task is to accurately input text data into the designated cells of an Excel file. Ideal Skills and Experience: - Proficiency in Excel, especially in handling text data. - Attention to detail and accuracy in data entry. - Previous experience in similar projects will be an added advantage. Looking forward to your bids. My typing speed is 55wpm

I need a proficient freelancer to extract and simplify excel data encompassing text, numeric, and date and time data from a significantly sized data file (approximately 5000 rows). The simplified output should be in the form of an Excel file. Ideal Skills and Experience: * Proven experience in data extraction and simplification. * Proficiency in Excel. * Excellent attention to detail. * Ability to work with large datasets. Responsibilities: * Carefully extract specific data segments. * Accurately simplify data for ease of understanding. * Convert the processed data back into an Excel file. * Ensure absolute accuracy throughout the process.

I am currently in need of an Excel and data entry expert with strong understanding in copyright matters. Key Deliverables: • Efficient handling of data entry tasks with fast typing speed. • Strong proficiency in Excel functions and formulas. • Undertaking copyright research and analysis. Ideal freelancer for this role should have: • Proven experience in Excel and Data entry. • A strong grasp of copyright laws will be a plus. Please include in your application evidence of your speed and proficiency in data handling, and any relevant experience you've had in dealing with copyright issues. Your past experience related to these tasks will be greatly considered during the selection process.

I'm looking for an expert with a keen attention to detail to manually extract particular data from a web page twice per day. The task involves gathering a 2x30 simple chart from the site. This chart consists of two columns - one representing the date and time, and the second representing a series of numbers. Once this data is extracted, it will need to be organized into an Excel spreadsheet and promptly emailed to me following each extraction. Skills and Experience: - Proficiency in data collection and entry - Familiarity with Excel spreadsheets - Exceptional attention to detail - Ability to work without supervision - Punctuality to ensure data sets are sent promptly after extraction. The success of this project relies greatly on accuracy, timeliness, and o...

I need help in exporting 50 images for a business directory I'm putting together. Key Details: - Purpose: The main purpose of this project is to help me extract logos from existing websites, resize them accordingly and rename and export each logo. - Type: There should not be too much design work involved, but there are 50 images to get through. - Features: I will provide the websites, the logos need to be extracted from there. The company's logo needs to be resized to specific specifications, renamed to match the company name, and exported to png. Ideal Skills and Experience: - Be able to extract a logo from a website - Proficiency in resizing and exporting Please note that this project is specifically about exporting images in large batches.

Project Title: Customizable Excel-Based Mark Book System for English Learning Area Tracking This reads like a lot, but I am only trying to be clear. It's just a mark book. Project Overview I need a skilled Excel developer to create a solution that helps schools track student progress against specific English Achievement Standards across year levels of the Australian Curriculum. The goal is to pinpoint areas needing improvement, empowering schools to target resources effectively. Is it Speaking and Listening, Reading and Viewing, or Writing and Creating? If so what particular Aspect (sentence? Key Requirements Foundation: Excel workbooks to accommodate multiple teachers and classes. Structure: Year Levels (tabbed sheets) with each year's Achievement...

I need a NoSQL database system that can effectively manage our company's purchases, production, and inventory. The project needs to be completed within a month. Attached the Project details ... Key Features Required: - Scalability: The system should be able to handle large amounts of data and growing demands. - Flexibility in Data Modeling: I'm looking for a system that can adapt to our changing business needs without compromising on performance. - High Performance: It's crucial that the system can process data efficiently and provide real-time insights. Ideal Skills and Experience: - Proven experience in designing and implementing NoSQL database systems. - Strong understanding of data modeling and its impact on system performance. - Ability to d...

Seeking a Python wizard to generate line and scatter plots from simple numerical data housed in Excel files. Your expertise in Python and experience with data visualization is key to succeeding in this role. Please, in your application: - Highlight your experience in Python plotting - Specify similar projects you've completed Going above and beyond to deliver an error-free, clean and professional visualization will be appreciated. Trust me, I value quality. Let's get started!

As I'm launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, o...

I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.

I'm looking to hire a web developer and designer proficient in building an aesthetically pleasing and functional character-storage site that is equally immersive. Key Features: - A platform for managing and displaying detailed character profiles. - Capabilities to categorize data such as names, descriptions, stats, abilities, and corresponding images or artwork. - An integrated search feature to filter out specific character types. Artwork Requirements: - The site should be able to host a variety of artwork formats like character illustrations, and digital paintings. - The developer should implement features for GIF support, to showcase more dynamic character pieces. The ideal candidate has previous experience designing and developing similar sites, a keen eye for aesthetics, exce...

I'm in need of a data handling professional. Gig is $36 Max. I have a large excel file that houses data from multiple sources but the columns are misaligned. I want it to be organized to Name, email, city, state, phone number, additional info columns. Your task will be to: - Correctly align the columns - Merge any duplicate records Ideal freelancer would have: - A strong background in Excel - Experience in data cleaning - Proven track record of handling large datasets - A keen eye for detail to spot and fix misalignments

Looking for an experienced Excel professional who can help debug my university project. I'm currently grappling with project-related issues and need rapid assistance. Expectations include: - Rectifying the project - Delicate understanding of Excel debugging - Fast turnaround time - as soon as possible Ideal candidate should have prior experience with Excel debugging, problem-solving ability, and methodology to correct projects. Knowledge about appropriate data structures will be appreciated. Being a student's project, confidentiality will be highly appreciated.

I'm in need of a professional Android developer to create an app that centers around collecting and sharing the vehicle and owner's information. Key Features: - Data Collection: The app should be able to collect the vehicle make and model, registration number, owner's name, Adhaar Card Number, along with the state, district, and address of the owner. Additionally, I would require the app to have the capability of taking the photo of both the vehicle and the owner. - User Authentication: The app should allow users to log in using a unique login id and password. Ideal Candidate: - Proficient in Android app development with a portfolio of relevant projects. - Experienced in data handling and secure storage on mobile devices. - Familiar with developing apps that requi...

I'm in need of a video editor with a knack for making videos sleek and engaging. The footage is a bit over 10 minutes long; thus, I need someone who can extract the most engaging parts, making it concise and appealing. Key Requirements and Responsibilities: - Trimming and cutting footage while maintaining the video's essence and message. - Incorporating calm and peaceful background music. The music's style should align with the video's content to ensure a seamless watch experience. Ideal Skills and Experience: - Proficient in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro, etc.). - Prior experience in creating concise videos from longer footage. - A good understanding of music selection to create a cohesive video experience. If you're co...

I am seeking a skilled web designer to create a professional, user-friendly website primarily focused on providing detailed information about our auto services. The essential elements for this project include: - A service listing section with an in-depth description of each service, pricing information, and the estimated duration. - An FAQ section offering guidance on common queries related to our services. Ideal candidates should demonstrate experience with content organization for optimal user navigation and service-oriented website development. Proficiency in creating intuitive, easy-to-use interfaces that facilitate customer information gathering is a must. Understanding of the automotive industry is a bonus, but not necessary. Please provide examples of similar ...

I'm looking for a skilled Python developer to combine around 1000 XLSX files into a single one. I need this new file to contain all the data from the original files. The Excel files have a structure where each file contains data for a different entity. The end goal is to have all this data centralized into a single document for easier management and analysis. The successful freelancer for this project should have: - Proficiency in Python, particularly in working with Excel files. - Experience in data manipulation and consolidation. - Strong attention to detail to ensure that all data is accurately captured and combined without loss. Please provide examples of your previous work in Python, particularly relating to data consolidation if possible. This will help me asse...

...the document need to be converted into both tables and text. This is to ensure the information is clear and easy to understand for the reader. There are a total of X photos that would need to be converted. - **Translation**: I also require the document to be translated into Russian. The translation should be done at an intermediate level of detail. This means that the translation should accurately capture the content and tone of the original document. - **Formatting**: The document should be formatted in a standard business format. This means that the layout, fonts, and styles should be consistent and professional throughout the document. I am looking for a freelancer who has: - Proficiency in Word and Excel - Translation experience, preferable with a business backgro...

I'm in need of an efficient, digital solution to streamline our insurance quoting processes as our current method is manual. Key Features: - Quot...different quotes for the customer's selected coverage. Access: I am open to ideas for the program's accessibility. It could be a web-based platform, a desktop application, or even an Excel program. The primary goal is to transition from manual quoting to a more efficient, digital process. Ideal Freelancer: - Experience: A strong background in insurance software development and a proven track record in creating similar programs. - Innovative: Capable of suggesting and implementing creative solutions for an optimal quoting experience. - Detail-Oriented: Attentive to accuracy and thoroughness in the development of the ...