How to build a database in excel jobs
I'm seeking a skilled professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would...
I'm in need of a database designed to organaize companies for Italian regions the data are not well organized, there are 927 companies with different address and region and they need to be divided by north west, north , north east etc - - Customer Information Management: The database should be structured in such a way that it allows categorizing companies according to their respective regions. Ideal freelancers for this job should possess robust skills in database design and management. A keen understanding of categorizing/mapping data based on geographical regions will be considered a huge advantage. Efficient, accurate, and secure data manipulation and storage is essential for this project...
I'm seeking a professional with exceptional data management and customer after-sales support skills. The selected candidate will be expected to perform the following tasks: Data Entry Tasks: - Data cleaning and organization. - Creating and managing spreadsheets. - Conducting data verification and quality control on all data sets. After-Sales Support: - Managing product troubleshooting. - Overseeing and tracking customer orders. - Handling customer returns and exchanges. Tools Utilized: - Excel for data handling. - Communication via WhatsApp and Facebook for customer support services. The ideal candidate should be proficient in Excel and comfortable using social media platforms such as WhatsApp and Facebook. Previous experience in data e...
I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scri...
...are currently looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn job posting. While the tasks themselves are relatively straightforward, it is important to note that this will be ongoing, daily work for the foreseeable future. If you have a proven track record of delivering high-quality work, and maintaining consistent performance, we encourage you to apply. Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheet...
As discussed I have delivered the excel workbook. Thanks!
...someone to help me recover the password for an Excel Workbook. It was prepared by an employee who has since left the firm. Note that I am not seeking to have someone recreate this Workbook without the password, but to have the password itself. There are several videos on YouTube about this, but I've had no luck: I've attached the spreadsheet if you want to try. The first person to provide the password will get paid. Just let me know if have it, I'll hire you, and you supply it. PLEASE DO NOT ACCEPT THE PROJECT UNLESS YOU HAVE THE PASSWORD FROM THE ATTACHED SHEET. Key Project Requirements: - Password Recovery: The primary task is to recover the password for an Excel Workbook. Ideal Skills and Experience: - Expert...
I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generatio...
I'm looking for a versatile Excel professional. Key Requirements: - Restrict Sheet Access and Hide for specific users - Changes made in the master sheet should be automatically displayed on specific sheet. - When a change is made on the master sheet, the cell should automatically be highlighted in red color. and also reflected in the specific sheet. I am looking for a good english professional . Automatic bidders will be blocked . If you are here type in salut at your beggining of the bid.
...developer who can integrate a cloud-based database into my project. Ideal Skills: - Strong proficiency in Java - Prior experience with database integration - Specifically, experience with cloud-based databases, Microsoft Azure in particular, is a big plus The Project: - Your primary task will be to integrate Microsoft Azure, a cloud-based database, into an existing Java project. - The project already has a well-defined structure and the database will serve as a key component. - The database integration should be secure, efficient, and scalable, meeting the highest standards. - There will be no need for user authentication or API integration, as this project is solely focused on database...
We are an Ecommerce...company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills...
I'm requiring a proficient Java developer for a college project. The main task will be building a web application along with database integration. I'll need you to implement vital functionalities, such as: - A user registration panel - A user login page - Fee structure - Contact us section - Admin as well as user registration option - Subjects and courses - Basic website navigation functions For the front end, HTML and CSS skills are necessary to render a clean and minimalist design. It's vital you're experienced in these domains and can provide examples of your past work. Looking forward to your proposals.
Data entry work from home part Tim e
Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database syste...
I am in need of a one-time service to clean out my email database of invalid email addresses that generates too much soft bounce and hard bounce (and spam trap emails). Key Points: - **Objective**: The main goal of this project is to remove outdated or incorrect email addresses from the email database. - **Frequency**: This is a one-time project, not requiring ongoing maintenance. - **Current Platform**: I use Brevo as my email platform Ideal Freelancer Skills: - Experience with email marketing and database management - Familiarity with Brevo or similar email platforms - Proficient in identifying and removing invalid email addresses - Proven track record of improving email deliverability and marketing campaign results. I su...
You need to build a power app for a business process of onboarding, offboarding customers. There is a database of the customers with specific users db that has access and approve a checklist. We need it on a sharepoint portal and emails are automated for every action. It is a simple process of adding a user, give them a checklist, customer completes all actions, there is an internal admin who confirms the checklist and there is a progress to track. Will provide a dummy of excel sheet, expect 3-5 screens across onboarding, offboarding, admin and customer login. Ideal Skills: - Proficiency in Power Apps, Microsoft Power Automate. - Expereince in MS dataverse, power platf...
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficientl...
We are seeking a Business Data Analyst for our team who is willing to work with new beginners in the field. As a Business Data Analyst, you will be responsible for analyzing large datasets, interpreting trends, and providing insights to drive business decisions. The ideal candidate should have a strong analytical mindset, excellent problem-solving skills, and the ability to work collaboratively with a diverse team. Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - S...
I'm looking for a Virtual Assistant to grab leads, I’ll send material on how. It’s pretty simple. We'll specifically be targeting those who work in the nightlife industry and going down the research rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in usi...
...seeking a proficient Excel expert to build a multifunctional sales proposal tool. The core functions include: - Entering Data: The tool should accommodate efficient and easy data entry from multiple source files. If this can be automated that would be preferable. - Sales Calculations: The tool must have the ability to perform various sales calculations and convert source files from multiple currencies to GBP - Templates: I require outputs to integrate into existing Excel templates for generating client proposals, producing invoices, and confirming projects. - Automation: Desired features include automatic data sorting and automated calculations to streamline and simplify tasks. - I have example files I can share whi...
I require a professional freelancer with extensive experience in Microsoft Office 365 to develop a set of Word, Excel, and PowerPoint templates for my business. Key Details: - Each template needs to incorporate our company's logo, color scheme, and slogan in a visually appealing manner. - I am looking to have 1 to 3 distinct templates created for each platform – Word, Excel, and PowerPoint - so I need someone versatile and creative. Ideal Skills: - Strong knowledge of Microsoft Office 365 - Graphic Design Skills - Branding Experience Please provide some examples of the branded content you have created in the past, especially any corporate identity materials. Looking forward to your ...
Hello! I need to build a module or functionality to the ServiceGo - Multi Vendor On-Demand Service & Handyman Booking Marketplace system for vendors. The module (functionality) should be the following, subscription model for vendors. In this subscription model, there should be a limit on how many listings (job services) a given vendor can publish and how many customers it can respond to. P.S. The above mentioned functionality is important to us, but even if you can't offer us such a solution we are also looking for the functionality of only registering as a vendor to pay a fee again, which should be per subscription. Link to the system:
I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with complex data sets. The project will requi...
I need to extract text and tables from a series of PDFs and convert them into an Excel file. The main requirements for this project include: - Extracting text: The texts from the PDF files need to be carefully extracted and placed into the corresponding cells in the Excel sheet. - Tables: There are some tables within the PDFs that need to be accurately reproduced in Excel. The Excel file must preserve the original formatting of the text and tables, so as to maintain the integrity of the data. The PDFs are only in English, so no complex multilingual extraction is required. Ideal Skills: - Proficiency in PDF to Excel conversion - Strong attention to detail - Ability to...
I'm in need of a skilled professional who can help me generate leads. Unfortunately, I missed providing some important details in the initial questions. - I'm open to both B2B and B2C leads, so I need someone who can handle both categories effectively. - The industry I target is quite broad, including but not limited to Technology, Healthcare, and Real Estate. Hence, I need a freelancer who is experienced in lead generation across various sectors. - Lastly, the leads should be provided in an Excel spreadsheet. This is crucial for my further processing and follow-up. Your previous experience in generating and categorizing quality leads across different industries will be a huge advantage. Proficiency...
I'm looking for an SAP B1 expert to help me extract critical data for a migration project. Your main tasks will include: - Extracting data from SAP B1, including customer data, inventory data, sales data, purchase orders, and financial data such as journal entries. - Ensuring the data is extracted in Excel format for ease of handling and migration. The successful freelancer should have: - Extensive experience working with SAP B1 and extracting data from it. - Proven track record of successful data migration projects. - A strong understanding of how to handle financial data, especially journal entries, within SAP B1.
...talented and specialized professionals in UI/UX Design to join our team. We are looking for individuals who can bring innovative and effective solutions to the creation of interfaces that not only delight but also provide an exceptional user experience. Responsibilities: - User Research and Analysis: Deeply understand user needs and behaviors. - Interface Design: Create attractive and functional designs for mobile and web applications. - Prototyping and Wireframing: Develop clear and functional prototypes and wireframes. - Usability Testing: Conduct tests to ensure the effectiveness of interfaces. - Style Guide Development: Create coherent and effective style guides and design systems. - User Experience Optimization: Improve the usability of existing website...
I'm seeking a data-savvy freelancer with a deep understanding of Instagram, to create a well-organized spreadsheet of micro influencers. There are three crucial components needed for each influencer: I AM NOT LOOKING TO CREATE FAKE SOCIAL ACCOUNTS - I WANT EMAIL ADDRESSES TO CONTACT THEM TO HELP CREATE CONTENT> 1. Instagram Handle 2. Number of followers 3. Their Email Search Criteria - total of 2000 records acrsoss - Dieticians and Nutritionists - Pregnancy and infertility - Mums / Working Mums 500 - 5000 followers only. Australian-Based Accounts
...Backend + Database + File storage Customer will choose a vehicle and upload an ECU or Transmission file. In admin panel, that file will be downloadable and a admins uploads processed version of the file. There will be a credit system in the platform. Customer will buy credits with their credit / bank cards and the credits will be deposited. They will spend their credits by requesting file processes. Also, there will be a shop section in the platform. Customers will be able to buy already uploaded files by admin. Customers shall be able to view their expenses and deposits as a list and that table should be exportable to excel. There will be 3 information pages which customers will be able t...
I am looking for a skilled data entry specialist with advanced proficiency in excel. The project at hand is a one-time copy typing task. The task involves: - Entering a variety of data types into an excel spreadsheet (Text, Numbers, and Dates). - Creating a custom excel template with less than 10 columns. Ideal skills and experience for the job include: - Proficiency in using Excel, especially in data entry tasks. - Strong attention to detail to ensure all data is accurately entered. - Experience in creating custom excel templates is an added advantage. Please note, I will provide the document that needs to be copied and expect the resulting spreadsheet to match the in...
I'm in need of an experienced Talend Studio developer to assist with a database migration project. Key Project Details: - **Data Sources**: The project entails integrating data from various databases. - **Primary Goal**: The primary focus of the project is to migrate the data accurately and efficiently. - **Data Processing**: The data migration will primarily be through batch processing, therefore real-time processing is not required. Desired Skills: - **Talend Studio Proficiency**: A strong understanding of Talend Studio and its capabilities is essential for successful project completion. - **Database Integration Skills**: Experience working with database integration is a must. - **Data Migration Experience**: Previous...
We have a list of products. We need to check everyday, if those products have strikethrough price appear on them. All the products that need to be checked are from the same website. The following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does n...
Data Entry Project - I am looking for a freelancer who can assist me with typing work. - The project involves entering data into a spreadsheet or a database. - The ideal candidate should have excellent typing skills and attention to detail. - There is no specific software preference for data cleaning, so the freelancer can use Excel, Python, or any other tool they are comfortable with. - The dataset contains 100-500 records or entries. - The project requires accuracy and efficiency in data entry. - Experience in data analysis would be a plus, but not mandatory. - The freelancer should be able to complete the task within the specified timeframe. - Good communication skills and the ability to follow instructions ar...
want an excel expert for google excel sheet, who can make raw material data entry for purchase of raw material stock add and when someone uses it then particular raw material to be subtracted from that item two sheets one is for list of items & another is for entry
Laravel who can start immediately. Work with ftp only. Import excel work
Yesterday, OpenAI released the new module "ChatGPT 4.0". I want to create a video on how to automate and visualize Excel files using this new version. The thumbnail should include my face, the Excel logo, the OpenAI logo, and the text "Automate Excel with ChatGPT 4.0".
I am in need of a professional web scraper with Python expertise, who can scrape data from a website(with filter Options) and convert it into Excel format. Key Requirements: - Expertise in web scraping with Python, including dealing with website search filters. - Proficiency in data extraction and manipulation. - Experience in converting extracted data into Excel format. Please note that the specific website and the type of data to be extracted has not been provided as it was skipped by me. The project can be detailed further with the selected freelancer. If you have the skills and experience in this area, please do apply.
...looking for a talented freelancer to create a logo for the "FCA Jugend Förderverein e.V." The association was founded in 2012 and focuses on nurturing young talent in football. **Brief Overview:** - **Name:** FCA Jugend Förderverein e.V. - **Year Founded:** 2012 - **Colors:** Black and Orange - **Description:** The association is dedicated to promoting youth football development and providing opportunities for young players to grow and excel in the sport. **Design Requirements:** - The logo should reflect the essence of youth, growth, and football. - Incorporate elements that symbolize progress, teamwork, and dedication. - Use the colors black and orange prominently in the design. - Avoid compl...
...have a detailed list on an Excel sheet that I need converted into an organizational chart. The chart needs to include information like 'Grade', 'Nationality' and 'Occupation' and display them in a visually appealing format. Key Requirements: - Convert an Excel sheet which consists of approximately 140 line items into an organizational chart. - Display the following information in the chart: 'Grade', 'Nationality' and 'Occupation'. - Create visual lines connecting positions to indicate the reporting relationships. - Provide the final output in both PowerPoint and Visio formats. Customization: I am looking for a moderate level of customization in t...
My bakery is now in it's fourth generation of ownership. My Dad started using a database program called Formula Coster on his Apple IIc to figure out how to correctly price our baked goods based on ingredient costs, labor costs, overhead, etc. The program also allows us to store the formulas and makeup instructions for all our products based on the dough batch and individual pieces from the dough. It's a simple program that we still use today, but are afraid it may not continue to work very long. Other programs exist, but are all cloud based and require subscriptions with features we do not need. I am seeking an adept database developer to either continue work on an in-progress database ...
I'm seeking a skilled individual to assist me in creating a custom project cash flow spreadsheet. The primary functionalities I'm looking to incorporate in this spreadsheet are budget tracking, expense categorization, and cash flow projections. The spreadsheet will be primarily used for inputting income and expenses and should be updated on a monthly basis. Key requirements: - Design and development of a custom cash flow spreadsheet - Implement budget tracking, expense categorization, and cash flow projections - Ensure ease of use and understandability for monthly updates Ideal Skills: - Proficiency in spreadsheet software (e.g., Excel, Google Sheets) - Experience in creating budget tracking and cash ...
I require a freelancer to assist with a one-time copy typing project. The task involves entering data from a single document into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in copy typing - Proficient in Excel - Attention to detail and accuracy - Previous experience in similar projects is a plus.
ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou
I'm in need of a Excel setup algo that can execute orders on Zerodha from excel file. I require the following features: - One click button: The system should be able to place and execute my selected orders from excel with one click button. - Customizable Order Parameters: I need to be able to set my own order parameters, including the stock, quantity, price, and other variables. The ideal freelancer for this project should have experience in: - Developing python algo application with excel. - Integrating with Zerodha API. - Implementing automated trading systems. - Creating user-friendly interfaces, with some level of custom design.
Our developme...development team just wrapped up front end development for a large-scale website. At this critical juncture, we're seeking advice to ensure that our back-end databases - PostgreSQL and Cassandra - will be optimally performing and highly available. Key areas of consultation include: - Performance optimization strategies - Replication and high availability options - Ideal design of databases to accommodate the scale of our website Ideal professionals would bear extensive experience with both PostgreSQL and Cassandra databases, as well as a keen understanding of integrating front-ends to back-end databases. Your prior work with large-scale website infrastructures will greatly benefit our project. Database optimization and desig...
As a client seeking to improve my understanding of excel, I would like a skilled instructor to guide me through the basics of formulas and functions, data analysis and reporting, as well as formatting and conditional formatting in Excel. Although I don't have a specific completion time, expediency is appreciated. Skills and experiences that would be ideal for this job: - Advanced Knowledge of Excel - Excellent Teaching Skills - Flexibility to cater to learning pace No preference was selected for the type of learning medium, so offering a blend of online videos, live training sessions, and written instructions could be beneficial to cover all bases.
ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou
