Excel database webงาน

I'm looking for an experienced Excel specialist that can help create templates tailored for project management. The focus will be on tracking activity such as: - Task progress: I need a clear way to visualize the start and end dates of different tasks. - Project timeline: We need to monitor a high-level view of all the activities in the business. - this will needs tabs for BG activity over various cost centres, to view as a dashboard. Comms tracker, social media tracker, bid tracker, awards tracker, pursuits tracker This system should help us understand where we are in a given project and what needs to be done to keep everything on track. Strongly proficiency in Excel and a background in project management software will be a great advantage for this project.

...easy-to-read font and colour scheme while boasting organised and intuitive sections. Professionals with a strong background in spreadsheet management, data analysis and reporting, and seamless design transition are best suited for this job. Familiarity with calibration labs and their operations will be highly regarded. The project consisting of developing excel worksheet and report format for Calibration service The company will provide the Excel file and will provide the testing method plus document how to make decision rule for pass and fail It is required to make developing on the file to be able to do calculation as per work instruction standard and to make decision rule on the report as per the provided document This development to be done on five separate file ...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I am in need of a professional who can provide meticulous bookkeeping and financial statement preparation for my business. Currently, we are using QuickBooks and Excel in managing our accounts, thus someone with capability and experience in these tools is highly appreciated. Additionally, I'm seeking quality editing services encompassing proofreading, copyediting and content editing. It is important for the successful freelancer to have an acute attention to detail and a solid understanding of grammatical rules. Ideal skills and expertise for this job would include: - Proficient in QuickBooks and Excel - Extensive bookkeeping and financial statement preparation experience - Strong proficiency in proofreading, copyediting and content editing - Exceptional attention...

I'm looking for an expert in Shopify and digital products to assist in setting up my store that will carry more than 50 digital documents. The products range from Microsoft Word, Excel to Visio files. Ideal Skills: - Proficiency in Shopify - Experience with digital product setup - Ability to suggest and implement design and layout The project requires: • Set up for an extensive digital product inventory • Capability to advise on layout and design I am open to design suggestions to create an intuitive and customer-friendly Shopify store. This should make it easy for visitors to browse, select, and purchase digital documents. Demonstrable experience in similar projects would be an added advantage. I've attached a .png file that would be displayed as the ite...

Hi, I need someone very experienced with importing variable products from Excel. Attached is a sample file. I'm having issues Doc on importing variable products using this plugin - :~:text=To%20import%20variable%20products%2C%20go,data%2C%20then%20run%20the%20import.

1. We have 32 backups from the same database as .sql-files. From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ). So basicly you must: - import 1st backup on your sql-server - export the table "contracts" to "csv for Excel" - repeat for all 31 other backups - put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute) 2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar. The report should consist of: 1. All customers that have been added at the given date. 2. All contracts that have ...

...PROGRAMA O APLICACIÓN QUE LO HAGA DESDE CERO. EL PROGRAMA O APLICACION DEBE PODER: * RESPALDAR ESA INFORMACION EN UN ARCHIVO LOCAL O SI ES POSIBLE EN UNA BD LOCAL, ME REFIERO A LA MISMA USB, PORQUE LA MEMORIA SE METERA Y EJECUTARA EN VARIOS EQUIPOS, *QUIEN REVISÓ O ESTA REGISTRANDO LA INFORMACIÓN DE CAPTURA(USA LA USB), CIERTOS DATOS *QUE TENGA UNA ESTRUCTURA PARA EXCEL O SI DE PLANO ESTE FORMATO SEA EL LISTADO O BASE DE DATOS EN EXCEL. *SI YA FUE REGISTRADO ESE EQUIPO QUE LO INDIQUE, BASADO EN SU LISTADO O BASE DE DATOS. PROGRAMAS SIMILARES *CPUZ * Speccy * HWiNFO64 Pero estos corren en Windows, se requiere que no se ejecute ningun sistema, algo booteable para que arranque la memoria....

I need a versatile designer to create a poster that will provide details about a specific product/service. The ideal candidate should have experience in graphic design and a knack for distilling complex information into user-friendly visual content. The scope of the project includes 3 to 4 days: - Designing a visually pleasing and informative poster. - Should replicate our brand's aesthetic and appeal. - Must be able to take complex information about our offering and distill it into digestible and engaging content. Additionally, I am in need of a data professional to clean and organize unspecified data. The relevance or nature of the data has been left unspecified, but I require it to be comprehensive and clean. Requirements include: - Experience with various data cleaning techn...

...CEO's with very specific criteria. This is an intensive, manual work project that will take at least 12 hours of dedicated effort of searching through Linkedin / Google/ general web search. Please proceed further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be sourced from databases such as Apollo.io. Please do not waste your valuable time trying to do either. The criteria are: 1. Must be a CEO, Director or MD - only these 3 designations are acceptable 2. Must have a <last name> from the list in the attached Excel sheet - only these last names are acceptable 3. Must be based in USA/UK/Australia/Canada/New Zealand / - only these 5 countries are acceptable The ...

As a client requiring precise and frequent data extraction, I'm seeking a skilled freelancer experienced in web scraping to assist with extracting specific data points from Website 1. Data Details: - The data point of interest is "Time wise status" - The objective is to have this information converted into excel format. Frequency: - The task requires real-time data scraping, with updates to be captured every 5 minutes. Desirable Skills and Experience: - Solid experience with web scraping techniques - Proficiency with Excel - Ability to create a solution that can scrape data every 5 minutes - Experience with Website 1 or similar sites would be an added advantage.

I'm seeking a skilled freelancer to assist with a special effects video editing project. The focus will be primarily on delivering compelling motion graphics and animations within a short film of 5-10 minutes length. Key Skills and Experience: - Expertise in special effects editing - Creativity in im...within a short film of 5-10 minutes length. Key Skills and Experience: - Expertise in special effects editing - Creativity in implementing motion graphics and animations - Ability to deliver quality work efficiently despite tight deadlines - Previous experience in similar projects is a bonus Please note that audio service is not required in this project, so those who excel in special effects and visual editing will excel in this project. Let's create something ...

I'm in need of a professional...can assist with data cleaning, formatting and entry for my Excel sheets. This project requires an individual who is proficient in data validation as this is an essential function to successfully carry out the task. You will be working with Excel sheets specifically for data validation during data entry and database management. Experience with Excel and a good understanding of data formatting is an absolute must for this project. Key Responsibilities: - Data cleaning and formatting - Data entry and database management - Validating Excel sheets during data entry Skills and Experience: - Proficient in Excel - Experience in data validation - Knowledge in data formatting and cleaning - Strong understandin...

I'm in search of a researcher with a keen eye for detail, equipped with robust data mining and proficiency in Japanese language skills. Your mission? To deliver a comprehensive database of all VR gaming companies based initially in Nara, Japan, before expanding the research to the national level. Here's what I need: • Company Name: The company's official name (in Japanese). • Website: The company's official website. If you have previous experience in market research or data collection, that's a bonus. Your dedication and efficiency are key ingredients to securing this project. Let’s join forces to unravel the VR gaming landscape in Japan. --------------------------------- (This are expanded info)-------------- I'll looking for: (a) ...

Top 20 us unis and their details.

I am looking for a specialist who can help automate several tasks on my desktop. Key Duties: • Open specific apps including Python, Excel, and one other unnamed app. • Execute data entry tasks. • Extract text files. • Run existing Python scripts. For this role, a background in automation, a firm grasp of Python, and knowledge in handling Excel are vital. Proficiency in other automation tools or scripts would be an added advantage. Understanding how different apps interact will also be key to this role. I will show you my desktop to you over TeamViewer. And explain you my work. The objective is to streamline my workload, improve efficiency and reduce manual input where possible. Your expertise will be invaluable in setting this up and ensuring its sm...

I am currently in need of a highly skilled virtual personal assistant (PA) ideally based in the Philippines who can aid me in staying impeccably organised and managing a variety of tasks. Here are the specific responsibilities: - Organising tasks and appointments to ensure that my schedule is fully optimised and nothing slips through the cracks. - Managing Zoom meetings, overseeing both the technical aspects and overall coordination. - Handling YouTube posting, including video uploads and channel management. Previous experience with YouTube channel management is preferred. - Designing visual content using Canva. A strong graphic design background and a keen eye for aesthetics would be beneficial. - Running email campaigns using MailerLite or Mailchimp. This would involve designing, ...

...application from scratch with integration to a .NET API. This application will need to make use of an existing SQL database. Key Tasks: - Design and develop a new React application. - Implement integration to a .NET API. - Utilize an existing SQL database. Candidates must have expertise in: - Development of React applications. - Integration of .NET API. - Working with SQL databases. - **Core Functionalities:** - **User Authentication:** Secure login system using email and password. This system should ensure that user data is protected and only authorized users can access the application. - **CRUD Operations:** The ability for users to create, read, update, and delete data within the database seamlessly. This includes managing user details, settings, and other d...

I am looking for an efficient data scraping specialist wh...sg/ptn/supplier/directory/index.xhtml. I need all the fields provided in the URL listings. Criteria: -Ideal candidates should have a thorough working knowledge of data scraping software and have previously worked on similar projects. - I don't have specific fields to extract but I'm interested in, the more data you can extract, the better. - All the data gathered should be delivered in an organized Excel format. - Cleaning or preprocessing the data isn't a current requirement. - Efficient and detailed scraping abilities will be beneficial for this task. This project will require you to navigate through approximately 7,000 search results on the indicated website. An attached sample file will provide guidan...

For my project, I require an expert well versed in Database Normalisation, specifically forms 1,2,3. The main goals of this normalisation process are to eliminate data redundancy, improve data integrity and enhance database performance for better usability in my document database. Identification of primary key(s),foreign key(s),partial dependencies,transitive dependencies Ideal candidate skills: - In-depth knowledge of data normalisation - Experience with document databases Responsibilities: - Ensuring data integrity and performance - Applying normalized data to a documented environment Take note that we're not using SQL, NoSQL or Cloud-based systems. Instead, a document database system will be utilised. Your previous experience in such an environment ...

Hi, I need someone to organize some Excel Files for me. I have a list of domains and emails. I need to organize the domains and emails together. I can give more info in the chat. I have a $50 budget and am hoping to complete it within a day.

Saya membutuhan rangkuman excel terbaru daftar ongkos kirim. pengiriman JNE ke seluruh indonesia. Ongkos kirim updated per tahun 2024. Tidak menerima data lama. Dibutuhkan semua ongkos kirim jne dari kecamatan sukajadi , Bandung. Misalnya juduk excel = semua data ongkos kirim pengiriman dari kec, sukajadi . Bandjng Saya butuh kolom A = provinssi Kolom B = kota/kecamatan Kolom C = kecamatan Kolom D = keluruhan Kolom E = kode pos Kolom F = ongkos kirim JNE OKE Kolom G= ongkos kirim JNE reg

I'm seeking experts with proficiency in MySQL to help normalize the database. Ideal candidates would bring extensive knowledge on normalization to bring a database to its named form. The project is somewhat urgent and needs to be completed ASAP. Skills and experience: - Expertise in MySQL - Strong understanding of database normalization - Ability to work within tight deadlines

...in PDI Essentials (C Store Pro), a back office software widely used in convenience stores across the United States. My goal is to improve and streamline my sales reporting system by: - Setting up daily reports in PDI Essentials for better tracking and analysis. - Integrating this software with custom Excel sheets, which I currently use for reporting. Your main tasks would involve designing and setting up this integrated system. Therefore, proficiency in using PDI Essentials and advanced Excel skills are required. Knowledge in convenience store operations and sales reporting is a plus. This project will be paid hourly in U.S. dollars. Your task is crucial in optimizing my convenience store’s reporting system, thus impacting decision-making and overall operations. I...

For my project, I require an expert well versed in Database Normalisation, specifically forms 1,2,3. The main goals of this normalisation process are to eliminate data redundancy, improve data integrity and enhance database performance for better usability in my document database. Identification of primary key(s),foreign key(s),partial dependencies,transitive dependencies Ideal candidate skills: - In-depth knowledge of data normalisation - Experience with document databases Responsibilities: - Ensuring data integrity and performance - Applying normalized data to a documented environment Take note that we're not using SQL, NoSQL or Cloud-based systems. Instead, a document database system will be utilised. Your previous experience in such an environment ...

I need an experienced Excel professional who can help me extract both textual and numerical data from a particular sheet and organize it in a new one with precision. Key tasks include: - Extract specific text and numerical data from one Excel spreadsheet - Prepare a new sheet and structure it in a table format You should be proficient in Excel with experience using specific formulas or functions in addition to a thorough understanding of data extraction and organization processes. Familiarity with my specific worksheet would be an added advantage. Please indicate in your bid if you have experience in handling similar tasks. If you are skillful, accurate, and timely, then I encourage you to apply for this project.

...Drop a Suitable Offer Deadline: 14th March 2024 Software: PowerPoint/ Depends on Task. Task: Imagine you are a data scientist recently hired by the government to demonstrate the new SQL database you have created. Imagine the government is also planning on storing the names of people involved in accidents. You produced a relational database in SQL. In your presentation, you should introduce the potential technical, ethical, and legal issues of storing the data. How might an SQL relational database address some of these? Present and describe an entity-relationship diagram (ER diagram) for the database. There are a lot of columns in each table, so do not show them all. Just show primary keys, any foreign keys, and a representative sample of 2 or 3 of the o...

We are in need of a skilled illustrator to create bright, playful, cartoon-like MDMA pill images. The ideal candidate should excel in cute and playful aesthetics, as the art will be used to propel a marketing campaign intended to spark excitement. Key project requirements: - Highly inventive and colorful designs - Style should be cheerful and engaging to our audience - Previous experience in creating cartoon art preferred - Familiarity with marketing and understanding how to evoke emotions through artwork will be beneficial Please include any relevant work samples or portfolio pieces in your bid. Exciting opportunity for creative professionals looking to push the boundaries. We're all about fun and engaging content, can't wait to see what you bring to the table!

Requiero crear en Drupal 9 un certificado. La solicitud inicia En base a 4 campos en una página con un capcha de seguridad cada uno con validación propia y mostrando mensajes por los errores cometidos. Guardar una bitácora de las solicitudes con...seguridad cada uno con validación propia y mostrando mensajes por los errores cometidos. Guardar una bitácora de las solicitudes con la información del ip, hora, navegador y otros datos. En caso de solicitud aceptada Crear con datos de una Base de Datos en María DB un certificado en pdf con un qr de seguridad u otra medida de seguridad. La Base de Datos base del certificado se cargará desde una hoja Excel u otro archivo txt además también por página. Creaci&o...

I require someone to take my large VCF contacts file containing 7000 entries and comprehensively transfer them to an Excel spreadsheet. Key Project Details: - Extraction of Name, Phone Number, and Email Address from each contact file. - Names need to be split; allocating 'First Name' and 'Last Name' to separate columns in the spreadsheet. Ideal Candidate Attributes: - Strong proficiency in Excel and data manipulation. - Experience in VCF and Excel conversions. - Strong attention to detail to ensure data accuracy. - Ability to work expediently is also a plus, given the volume of contacts. Please note, no additional fields or information are required beyond name, phone number, and email address. Remember to maintain data integrity during the conve...

I need a system using Excel or Google Sheets, or a simple web application capable of compiling payroll tax data as per the attached Excel file to generate a PDF report named EA Form, with an emailing function to send it to the respective employees. Key tasks: - Generate a PDF report (EA FORM) using the excel data - Email the PDF report (EA FORM) - Print the PDF report (EA FORM) Ideal skills required: - Proficiency in generating reports from excel data - Skills in PDF report designing - Skills in automated email systems.

I'm seeking a skilled professional with architectural and CAD drawing proficiency. Your task will be: - Taking my hand-drawn residential landscape plans and transforming them into digital versions: - Experience in horticultural designs is not required. - Familiarity with various software is a plus, maybe Excel and Indesign. The proposed planting plan to be drawn up is in pencil. Other plans showing hard landscape and levels will follow in pencil, for drawing up. To illustrate what I need, I attach examples of: - a planting plan for your information, of the kind I need for this project. Yours need not be exactly the same - it is for use as a working drawing and does not need to be a pretty picture. - a planting schedule for copy pasting onto the planting plan, as an e...

...local utility to: 1. Back up the Excel Spreadsheet by making a copy, keeping the last 10 copies 2. Automatically append the contents of 1-2 CSV files found in a folder to an excel spreadsheet 3. Move processed files into a COMPLETE folder 4. Log the results in a local text file. Full story: My software exports 2 CSV files daily to a local computer. These CSVs show the products that have been sold and the quantities of each product sold for that day. We need to add these rows of data to a master Excel sheet, and it should be done automatically when a new file is detected, OR at a specific time each day. The fields would be Date Sold, Erply ID, UPC, Internal ID, Description, Qty Sold The CSV files would be The Excel Spreadsheet would be called Pionee...

I'm in need of a data extraction specialist with strong experience in web scraping to extract text content from a specific website with open data. This data should then be organized in an Excel spreadsheet following a format that I will provide. Skills required for this job include: - Experience with web scraping and data extraction - Knowledge of Excel and data organization Please note that the information extracted should adhere strictly to the provided format. With your bid, kindly include any past similar projects you've successfully completed. This helps me gauge your understanding and experience in this field. This is an important project for me, so completeness, accuracy, and confidentiality are top priorities. If you have any queries regardi...

For my ongoing work, I need assistance in converting an existent VBA script from Excel 16 on Windows to properly function on Excel 2016 on a Mac. The script I currently have is responsible for automating a series of key tasks which substantially help my productivity, specifically: - Arranging and sorting my data Successful candidates should be comfortable with both operating systems, have an excellent command over Excel, and a deep understanding of VBA scripting. Prior experience in Excel-to-Mac conversions is also beneficial. This job requires clever problem-solving, meticulous attention to detail as well as the ability to clearly communicate the changes made.

Hello Freelancers, I need someone to help me set up my Sequel Pro tool (MySQL database) on a MacBook. I just want to remotely connect to my server. Thanks

I am urgently in need of a Virtual Assistant to streamline some data entry tasks and conduct web research for my organization. Expectations: - Perform data entry tasks - Conduct web research on various topics Time Commitment: - Full-time employment; over 40 hours per week. Required Skills & Experience: - Proficiency in Microsoft Excel - Extensive experience in web research - Solid understanding of Google Search engine - Detail-oriented; capacity for handling high-volume tasks Preference will be given to candidates proficient with data entry software. Although not required, this would be a plus. Overall, I'm looking for efficiency, accuracy, and a good work ethic. If you believe this describes you, please bid!

I'm looking for an experienced PHP developer to configure and run my application, integrating it with a SQL Server for data storage. Key requirements for the project: - Expertise in PHP development - Proficient in SQL Server database management - Ensure data security and integrity during migration Considering the urgency of the project, ideally looking for candidates who can start working immediately. Respond with your available start date and a detailed outline of how you intend to approach this project.

I'm in need of a developer able to create a database to store police OB reports and design a web-based application for secure report addition and access. The requirements I'll need are as follows: 1. **User Authentication:** The system should enforce stringent security measures to authenticate users, guaranteeing that only approved credentialed users with access level to reports in the database application. 2. **Report Creation/Submission & Access:** The platform should allow users to create and submit reports smoothly. Additionally, a comprehensive report search functionality is crucial for easy access to submitted reports. 3. **Multi-Level Access Control:** The application should support more than three user roles with varying access permissions - ad...

I need an expert Excel user who can effectively refine and organize data in an existing file. Your role will primarily entail removing any entries from file A which are already present in file B. Key responsibilities: - Scan through each entry in file A to identify duplicates in file B - Erase or omit entries that exist in both files For this project, proficiency in Excel and keen attention to detail is necessary. Previous experience with data refining tasks will be beneficial. To ensure the successful completion of this project, you should be able to follow directives strictly, and apply logical reasoning skills when necessary. For confidential reasons, the specific data information will be provided only to the chosen freelancer. Thank you for your understanding.

I am currently in need of a meticulous data entry specialist with a good sense and understanding of SQL Server. Your primary responsibilities would involve: - Organizing and processing data on our SQL Server - Keeping the database updated - Ensuring data integrity and security - Regular reporting and documentation This project requires a detail-oriented professional with excellent keyboard typing skills and profound knowledge of spreadsheets and online databases. An ideal candidate would have experience in managing SQL Server databases. Impressive organizational skills and a keen eye for detail are both a must to do well in this role. I await your proposals.

I currently have several databases on airtable which I built myself and use to track: assigned to employees (task cards) 3. Training records 4. Inventory I would like to take this a step further and have an app designed to tie all of it together and possibly develope it further. The App will be for emloyees only to submit data in realtime. Looking forward to discuss further my requirements.

I need an automated system built on Excel for my business. Invoice, Stock Mgmt, Payments, Expenses. Will pay in INR.

Hi, Here is the invoice as per the discussion

[Tool] Use UiPath, not UiPath X. DO NOT use other RPA tool. [Detail]Process Excel tables row by row and paste them into Google Docs. A (Create Notice of Appointment to Employees) --[Input] "" --[Output Goal]Copy Excel(.xlsx) data and paste to Google Docs( not microsoft Word). Create google docs that is very similar to following Example. --[Output Example] B (Create Test for Interview Candidates) --[Input] "", --[Output Goal]Copy Excel(.xlsx) data and paste to Google Docs( not microsoft Word). Create google docs that is very similar to following Example. --[Output Example]

I'm seeking a professional with proficient knowledge in Microsoft Excel, who can perform basic arithmetic calculations (addition, subtraction, multiplication, division) on a single worksheet. Your responsibilities will include: - Implementing formulas to perform arithmetic operations - Ensuring high data accuracy - Validating calculations results. Ideal candidates will have previous experience with similar tasks and a keen attention to detail for ensuring accurate calculations. Strong Excel skills are a must. The freelancer should be able to begin work immediately.

...very specific criteria. This is an intensive, manual work project that will take at least 12 hours of dedicated effort of searching through Linkedin / Google/ general web search. Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be sourced from databases such as Apollo.io. Please do not waste your valuable time trying to do either. The criteria are: 1. Must have Indian CEO, Director or MD - only these 3 designations are acceptable 2. Must have a <last name> from the list in the attached Excel sheet - only these last names are acceptable 3. Must be based in USA/UK/Australia/Canada/New Zealand / - only these 5 countries are acceptable ...

In need of an experienced Microsoft Excel specialist who can assist with a task in MS Excel I have an excel workbook that has a lot of formulas. As a result, it is taking a lot of time even when I add a row. I need someone who can fix this for me. Due to the urgency of the project, I need someone who can start as soon as possible. If this sounds like something you’d be capable of, please place your bid. Completion is required ASAP, so your immediate availability is key. Please apply only if you have handled a similar situation below. Also, to make sure that you have read this description, please start your proposal with the word "Bruno" Thank you.

Repost of the following project: https://www.freelancer.com/projects/excel/transform-text-evaluable-format. The required files will be exchanged after nomination.

Calling all digital nomads: Seize the opportunity to delve into th...work experience in Link Building (Q&As, Forum Submissions, Directory Submissions, Article Submissions, Image Submissions, Social Bookmarking etc.) Excellent written and verbal communication skills in English Language. Strong organizational skills and attention to detail. Willingness to learn and take on new challenges. Should be tech-savvy. Sound knowledge of Google Sheets, Google Docs & Microsoft Excel would be an added advantage. Benefits: Remote, providing flexibility for a comfortable work environment. Gain hands-on experience in SEO and Digital Marketing. Flexible working hours to accommodate academic commitments. Competitive rates based on qualifications and experience. Marketing background will be...