Work excel database työt

We have some clients who want to update their MsAccess 2003 databases. Using their existing tables. The person we are looking for will update the Queries, Forms, Modules, Reports and Macros to our requirement. A = Update the reconciliation of Bank, Customer, Vendor and other Accounts. B = Improve the tables and corresponding items in a database that continues to have “Record Deleted” errors. C = After updating the MsAccess 2003 database(s) convert them to MsAccess 2007. D = After testing the 2007 upgrades these databases will be converted to MsAccess 2010. => Please send us a pdf file of a Bank Reconciliation that you have created.

I require an Excel expert with in-depth knowledge in VBA for developing a comprehensive invoicing system. I have my qr scanner when I scan product it's shows products details automatically. I attached 5 list of products. Your Task: * Create VBA macros to automate system functionalities * Design invoice templates that encapsulate professionalism * Implement automation for data entry tasks Purpose: The overarching purpose of the invoicing system is to streamline the tracking of sales and payments, automatically calculate finance-related aspects, and generate professional invoices that accurately represent our company. Required Features: * Ability to generate insightful reports on business financial trends * Functionality to send automated reminders for payments * Integration ...

Looking for Azure developer who can create Mysql Database backups and create jobs that automate the backups daily and monthly basis

Halo freelancer saya butuh Jasa Migrasi Wordpress dari Linode ke Rumahweb (Cleaning Database karena ada Sql Injection) karena sebelumnya website ada sql injection sehingga perlu dibersihkan databasenya sebelum dipindah ke wordpress baru di hosting baru. Website Terima Kasih

I require an experienced data entry specialist to convert a substantial volume of physical documents into an organized format in Excel. The job is significant, involving more than 1000 entries. This task necessitates the following: - Proficiency in Excel and its various functions - Experience with high-volume data entry projects - Excellent attention to detail - Ability to convert physical documents into digital data accurately Additionally, a strong understanding of maintaining data privacy and confidentiality would be advantageous.

I'm looking for a data analyst who will take the text data in my CSV file and streamline it for import into a database. My project will involve the following tasks: - Consolidating vast amounts of text data, approximately 23,000 rows, 140 columns (CSV). - Cleaning up any discrepancies, repetitions, and inaccuracies, - Organizing the cleaned data into fields provided by me. - Deduplicate data. - Simplify some data to reduce the total number of permutations. e.g. "Dark earth green" and "Pine forest green" would become "Green". This data is from the scraping of an ecommerce store with physical products. The ideal candidate for this project will have strong experience with text data management and data cleaning in spreadsheets. Being detail-oriented...

I will provide the freelancer with a formatted template in Excel. I will also provide the freelancer with 5-7 different excel documents that are micro reports. The freelancer will pull the data/information from the 5-7 different excel documents and format them inside of the template, keeping the same colors and conditions. The template includes a pivot table. The freelancer will need to replace the information on the pivot table with the new data from the 5-7 different Excel documents.

I want someone to copy almost 100 accounting equation answers. It's written in PDF form and I want it in Excel. Pages full of words like the first 6 pages are not required. You can leave some equations with long answers, but don't leave a lot.

Half of the work regarding object avoidance stands done.

Hello ! I need a real expert on Excel / Google sheet. I am using both for projects, and I need someone who can : Using Vlookup , and all specific formulas that can help build up and create spreadsheet. I have a lot of datas to clean and make automatic fill up . So I need someone who can help organize my spreadsheets and fill up a lot of datas . It start with small project to try and then it's gonna be a monthly project

I need an Excel expert to review, verify, and potentially improve the advanced functions (e.g., ARRAYFORMULA, QUERY) in 2 to 5 of my existing spreadsheets. Your job includes: - Inspecting and analyzing the existing functions for accuracy and efficiency - Proposing or implementing necessary adjustments to optimize functionality - Once changes are made, providing a clear explanation—either in writing or video format—on the changes applied and any suggestions to maintain or further improve the spreadsheet's performance You should have a strong knack for identifying errors, inconsistencies, and opportunities for improvements in complex Excel spreadsheets. An excellent command of advanced Excel formulas is essential. Ability to clearly communicate changes...

[Update: Please do NOT bid ...including the ability to note assignment of shares. Moreover, it should enable monitoring of various adjustments and rolls, such as: - Option adjustments - Position rolls - Hedging adjustments The ideal freelancer for this project should have proven experience in finance, specifically in creating stock market spreadsheets with a sub-specialty in option trading. Professional, expert level knowledge of Excel / Google Sheets is a must, ideally with some programming background to automate and customize the tracking process. This automation would include using Flex Query capabilities from Interactive Brokers and taking advantage of IBKR's API to automatically import all relevant trade data. A deep understanding of option trading mechanisms is also a m...

Create or select three English sentences from a randomly chosen online page ◉ Use these counts available in the xlsx files contained in the “ ” folder (along with the info reported in the ReadMe file) to estimate the probability of each of your sentences by using: • a zero-order Markov Model: ?(?1,…,??) = ?(?1)∗?(?2)∗⋯∗?(??) • a first-order Markov Model: ?(?1,…,??) = ?(?1)∗?(?2|?1)∗⋯∗?(??|??−1) ◉ Upload the solutions

I'm in need of an experienced data specialist who can perform the task of rigorously cleaning a small dataset with less than 10,000 rows. The few but intricate speci...less than 10,000 rows. The few but intricate specifics of the task include: - Removing any and all duplicates present in the data - Standardizing data formats across the dataset to promote consistency - Identifying and correcting any errors found within the clusters of information The data is in an Excel/CSV format and I expect the specialist to be highly proficient in managing and manipulating data files of this sort. Experience in data cleaning, data analysis, and ability to work with Excel/CSV files is paramount. Accuracy, attention to detail, and maintaining the integrity of the data are key r...

Hi, I'm looking for a simple solution, in an easy language so it can be easily edit, to register time and tasks in a workshop. It must be fully responsive...or select from drop list Service -  Add new or select from drop list Tasks - Add new or select from drop list Start Time - Global time, when start working on machine, and also individual time counter for tasks. And also only consider the working hours. Export final data Send by email final data In Back end: Login Add ID for new works Add Service types to IDs Add tasks to works IDs Export data (excel) Send data This is for a case study presentation to start a digitalization of processes, I currently have no chance to do this, but if it is accepted I will need a more completed solution in the future. Any doubt pleas...

...an extensive, up-to-date database of marketing and ownership email or phone contacts from 200+ bars and venues located in Boston and Cambridge. Skills required for this project include: - Database creation and management - Web research capability - Knowledge of Boston's bar scene would be beneficial - Attention to detail as accuracy is vital It's fundamental to ensure the information is correctly gathered as intended. Specifically, I'll require: - Contact Name - Venue Name - Direct Phone number/Email address - Website URL (where applicable) - Social media handle(s) (where applicable) Your task is to gather this information as accurately as possible and present it in a neat, organized fashion. The final output should be provided in common formats such...

I'm in need of a masterful web developer for a quick turnaround project. The task primarily involves integrating a MySQL database with a pre-existing project. The database will hold project management data. Key Responsibilities: - Implement MySQL database into a current project - Ensure seamless link between database and the existing system Ideal Candidate: - Fluent in HTML, CSS, JS, AngularJS, and Node.js - Experienced in SQL, specifically with MySQL - Able to quickly grasp the structure of an existing system and adapt it to include a database - Can complete work within a 24 hour timeframe Please be aware, this project is a part of an educational assignment. Looking forward to your bids!

I will provide the freelancer with a formatted template in Excel. I will also provide the freelancer with 5-7 different excel documents that are micro reports. The freelancer will pull the data/information from the 5-7 different excel documents and format them inside of the template, keeping the same colors and conditions. The template includes a pivot table. The freelancer will need to replace the information on the pivot table with the new data from the 5-7 different excel documents.

I'm looking for a savvy freelancer who has a strong expertise in data extraction from a javascript driven website. Key Details: * We'll focus on scraping text content and tables. No imagery is required. * The project should place particular emphasis on headings and links within these content types. Ideal Candidate: You are an experience...handling complex JavaScript websites and knowledgeable in accurately pinpointing and extracting the required information. Project Delivery: The project has a tight schedule and I need it completed within two weeks. Your understanding of this requirement and ability to deliver on time will be an essential factor in the success of this project. Let's get started! I can send you the website and demo excel file to show how i want...

I am looking for Microsoft Excel experts who can assist in sorting my numerical data. Features of the job: - Sorting numerical data with a high level of precision - The data should be sorted by a specific number of degrees that I will enter manually. Ideal skills and experience: - High level of proficiency in Excel - Experience in sorting operations in Excel - Attention to detail - Ability to follow instructions accurately. This job requires specific skills in Excel to ensure that the data gets sorted correctly. Your understanding and prior experience in similar projects will be highly beneficial.

I require assistance with an excel assignment that involves analysis of both numeric and textual data. The task will also entail calculations, and the creation of dynamic charts and graphs to visually represent this data. Skills needed include: - Proficiency in advanced Excel functions including lookups (VLOOKUP/HLOOKUP), mathematical expressions (SUM, AVERAGE) and logical expressions (IF, AND, OR) for data analysis. - Ability to interpret and analyze both numeric and textual data. - Expertise in creating and manipulating Excel charts and graphs for data visualization. An understanding of professional data presentation methods would be advantageous for this task. Only apply if you have significant experience in using Excel functions for data analysis.

Build an AI tool plugin for MS Excel. It's a simple project. So, I have these customer support chats that I have exported to excel. Reading through all the chats is a time-consuming process. I can copy and paste the chats in Chat GPT one by one and get the summary, but I would like to automate this task using a tool. Can you build one for me? I want a tool using chatGPT API or any other tool API to summarize the chat in the adjacent column.

I'm needing a PDF expert for specific tasks involving a project I'm currently managing. Job Details: - Task involves migrating comments within a PDF - These comments are to be realigned from left context to right - It's important to note that the com...but are embedded within the document itself. - It is very important to maintain the color of the comments and justify. Ideal Skills: - Proficiency in handling and editing PDF documents - Experience with text alignment, particularly from left to right - Strong understanding of comment migration within a PDF Only those who can specifically handle PDF formats need to apply. Expertise in Word and Excel is not required for this task. Please ensure you detail your experience relating to the tasks at hand when you submit ...

I am an entrepreneur looking for a skilled, meticulous, and experienced MongoDB professional who could help me recover my vital customer data from a server crash. I had relied this database for my business operations, so it's crucial the recovered data remains accurate and consistent. - The project revolves around data recovery—more specifically, the process of extracting customer data that I had been storing in my crashed MongoDB database. - The ideal candidate for this project would have extensive experience with MongoDB and should be familiar with server crashes and other data recovery scenarios. - Having knowledge of backup procedures or having previous experience in similar projects is a must. - Understanding of data integrity checks would also be a great a...

Looking to develop an Excel spreadsheet that will streamline tracking of Profits & Losses (P&L), sales, and payments. This obligation demands: - Create excel forms for each client/sale that will encompass information related to change orders, tracking of revenues, tracking of expenses by vendors and liabilities, and profit/loss analysis broken down for each client - Calculations: The spreadsheet must include key formulas such as gross profit margin, profit margin per customer, and payment reconciliation. Ideal candidate should possess advanced Excel skills with a robust understanding of finance and sales metrics. Previous experience in such tasks will be advantageous.

I'm looking for an experienced data web developer who is skilled in Excel to execute an in-depth data analysis. Specifically, the project entails dealing with numerical and text-based datasets. The main tasks will include: - we have some excel utilities they useful to us data management, reports, accounts and many. means excel sheet are fully developed right now i need there all excel sheet are convert in web version and more secure easier and less time taking and many other benefits.

I'm seeking a knowledgeable developer who can construct an IPTV player for Smart TV, iOS, and Android TV platforms. The ideal candidate will excel in adapting functionalities to differing platforms, with an emphasis on performance and user experience. Key Responsibilities: - Develop an IPTV player app, focusing on live TV channel streaming. - Implement provided UI/UX design, ensuring optimal performance on each platform. Ideal Freelancer: - Proven experience in IPTV app development. - Strong knowledge of Smart TV, iOS and Android TV platform coding. - Skillful at adapting design into functional application. I look forward to partnering with someone who brings these skills to bring this project to life.

**1. Objective: ** The primary objective of this project is to develop an integrated crop management plan for various crops grown in Tasmania, including but not limited to fruits (berries, cherries, apples, and pears), nuts, v...and Documentation: ** a. Provide detailed reference documentation on the selection and application of pesticides, fungicides, and fertilizers, including dosage recommendations. **8. Presentation: ** a. Present the data and findings in the form of a database in Xcel format with individual tabs for the: pesticides, fungicides, and fertilizers, to be used with associated considerations (crop type, dosage, month etc) mentioned throughout this scoping document. **Remember it is important to view this project as the development of a database. Not ...

I'm seeking an experienced Arduino coder to help establish ESP32 as a Wi-Fi router using the SIM A7670 4G Module. Key elements of the project include: - Developing Arduino code to utilize the ESP32 and SIM A7670 4G Module for internet connectivity. - Enabling ESP32 to provide a Wi-Fi network for multiple devices to connect. - Implementing WPA/WPA2 security protocols for enhanced network security. Ideal candidates will have experience in working with Arduino, ESP32 and 4G modules, understanding of Wi-Fi network configurations, and implementing network security protocols.

I am looking for a skilled graphic designer to create a modern, professional logo for my eye clinic. The design should incorporate the colors Soft Lavender (#D1C2E3) with Mustard Yellow (#FFDB58) and Charcoal Gray (#36454F) or Soft Blue (#6C8DA9) with Coral (#FF6F61) and Light Gray (#D3D3D3) ...easy to read with the first letter behaving as wordsign. Ideal Skills & Experience: - Proven graphic designing experience - A strong portfolio showcasing innovative designs - Proficiency in industry-standard design software - Exceptional creativity and innovation - Excellent time management and organizational skills - Attention to detail and a keen eye for aesthetics The right candidate should excel in modern aesthetic design with a professional edge. I look forward to seeing your creat...

I require an Excel software to be developed that is capable of handling two primary functions - managing data entry and storage, and executing various accounting tasks in my tour and travel business. I have specific requirements for the following functionalities: - Data Entry and Storage: As a priority, the software must allow for efficient and comprehensive data entry and storage. Although I didn't specify the features related to this function, it would be useful if the system could prevent errors by validating data entries, importing and exporting data, and managing access control. - Financial Reporting: The software should deliver high-quality financial reports with an emphasis on accuracy and clarity. - Invoice Generation: Additionally, the system should be equipped to p...

...listed as part of Shopify payments whenever I try to download a third party app for subscriptions. (None of Saudi payment gateways is listed). I've been in contact with the apps and shopify with no solution - I've been going in loops for a while. Any solution on how to add a subscription app with My Fatoorah as a payment provider? If this sounds like a project you'd excel in, please apply with examples of previous work. I appreciate your interest in this project and look forward to potentially working with you....

...struggle with prioritization, organizing, follow-through, and balancing the tasks that bombard me daily and could use the services of an expert who has a knack for streamlining, prioritization, and organization. Experience is a huge plus as I hope to engage someone who has successfully transformed chaotic environments into beacons of productivity and balance. I am looking for either 1 or 2 people to work with me and my 21 year old daughter (in college) separately. I manage several businesses do I am looking for someone that will be able to manage me. The title of Prioritization and Organization Expert is not merely ornamental. The right candidate will be able to: - Put their experience to task, creating systems that will keep my life in order amidst the disarray. - Smoothly ...

I'm actively seeking the assistance of a WordPress expert who can promptly resolve the current wp-config database connect error my website is experiencing. This issue first cropped up less than 24 hours ago, following some changes to the DNS information. Key responsibilities will entail: - Identifying and resolving the database connection error - Ensuring overall site function and performance post-error resolution Ideal candidate needs to: - Have a profound understanding of WordPress infrastructure particularly wp-config file - Have excellent problem-solving skills and be able to work under time constraints - Have ample experience in resolving similar WordPress issues - Be familiar with DNS info and changes and their impact on site functionality. Please note ...

We are looking for a WordPress WooCommerce expert to develop an ecommerce website built on WordPress and create e-commerce capabilities. The primary focus will be on implementing a filter and database system that allows for easy updating of product details, including images, descriptions, manufacturer information, model numbers, SKUs, product sheets, and product variables. Some products on our website will be available for direct purchase, while others will require specific configurations, such as cable length, horsepower, phase, and voltage. When a user selects a configuration, the corresponding SKU and configuration details should be automatically inserted into a contact form for further information. Additionally, we require a master filter on the product page that allows users ...

...project, you will be required to convert a piece of SQL code currently written in Java into C#. The code performs various database management functions. The goal is to accurately replicate the present functions and capabilities. High proficiency in both Java and C#, as well as a robust understanding of SQL and database management, are essential for this task. Experience in code conversion will be highly regarded. Key Requirements: - Convert Java SQL code into C# - Maintain all current database management capabilities - Thorough testing to ensure full functionality This job requires someone with a sharp eye for detail and commitment to quality, as the complexity of SQL database management in Java needs to be perfectly translated into C#. Please only app...

I'm looking for a seasoned Excel guru for some critical data entry work involving sales data. The aim of this project is to perform data analysis that will aid in making strategic decisions for the business. Your primary task will involve: - Extracting sales data from provided PDF reports - Transfer this data precisely into an Excel sheet - Prepare the data in a way that meets our data analysis requirement The ideal freelancer is proficient with Excel data functions, including formulas and pivot tables. Prior experience with data entry from PDF files and a background in sales data analysis would give you a competitive edge. Timeliness and accuracy are paramount for this task.

I'm in need of a talented songwriter who can craft a powerful and inspiring song for my Cheetah Girls RnB project. The song, which should be around three minutes long, will focus on the theme of empowerment. The ideal candidate for this project will: - Have a knack for cr...inspiring song for my Cheetah Girls RnB project. The song, which should be around three minutes long, will focus on the theme of empowerment. The ideal candidate for this project will: - Have a knack for creating catchy, engaging RnB tunes. - Be able to capture the empowering spirit of the Cheetah Girls. - Excel at setting a powerful and inspiring mood with their music. Experience in writing songs that are focused on empowerment is a major plus. Please provide samples of previous work that demons...

...-Ensure all guest details, including name, email, phone number, reservation number, booking period, and payment information, are promptly forwarded for record-keeping and follow-up purposes. Requirements: -Strong attention to detail and accuracy in task execution. -College degree or equivalent qualification preferred. -Proficiency in basic software tools, including Microsoft Office (Word & Excel). -Ability to operate electronic devices (computer or phone) proficiently. -Fast-paced and adaptable to changing priorities. -Ability to commit to 10-30 hours per week, approximately 2-4 hours per day. -Willingness to undergo a short trial test or task, lasting 2-4 hours, with the possibility of extension up to one week if necessary. Duration: The duration of the job i...

...Registro de Coordenadas Geográficas: Documentar las coordenadas exactas de cada estación. Clasificación por Autopista: Crear una lista clasificada por autopista con la información recopilada. Entregables: Una lista completa de estaciones de peaje con el nombre de la autopista y coordenadas geográficas. Documentación sobre el método de recopilación y verificación de datos. Archivos en formatos CSV o Excel con la información recopilada. Información Adicional: Incluimos un archivo de muestra para guiar el registro de datos requerido. Este debe seguir el formato proporcionado. Cronograma y Presupuesto: Solicitamos una propuesta que incluya cronograma y presupuesto. Buscamos una relación ópti...

Looking to have created to small apps in visual studio to access and write to SQL Server database. Please see the full description in the PDFs I have uploaded.

I'm seeking a proficient Visual C# developer with expertise in SQL Server integration for a critical project. Your task will be to enhance my application by incorporating Intermediate level database operations, specifically working with Stored Procedures and Triggers. Key Skills: - Extensive experience in Visual C# development - Proven expertise in SQL Server integration - Proficiency in implementing Stored Procedures and Triggers. Your ability to work efficiently while maintaining quality will be of utmost importance to the successful completion of this project.

I'm seeking an experienced developer to build an Appsheet application from my Excel database, which mainly stores inventory data. The application will run on multiple devices, allowing diverse functionality: - Data Retrieval: Find and display required data on demand. - Graphical Representation: Generate easy-to-understand graphs based on available data. - Email Functionality: Send emails directly to suppliers listing required inventory items. - PDF/Print: Export data into PDF format and enable printing lists directly from the app. The ideal freelancer should be proficient in Appsheet and have a solid understanding of inventory database management to ensure smooth functioning and seamless interaction with my existing setup. Experience with mobile and desktop p...

The project is a fixed $45 considering you are an expert and develop results in less than 2 hours. I'm seeking the expertise of an AI specialist specifically skilled in Topic Modeling and Machine Learning. I have a database of 7500 questions stored in an Excel/CSV format. The primary aim of this project is to analyze these queries for specific trends and patterns. Your mission will be to identify the most popular topics being asked about. Each question is labeled to a category/theme/topic. Ideal method is Word-Text-Topic Extraction approach. A strong level of experience in interpreting complex data sets is expected for optimal identification of these key patterns. The perfect candidate will have a proven track record in similar AI analysis tasks and will be able to de...

I'm seeking a freelancer experienced in Excel for data input and analysis tasks. You'll work with between 1 to 10 Excel sheets, so you must be proficient in managing and understanding diverse datasets. Furthermore, your skills in PowerPoint will be put to use as the analyzed data should be presented in clear, engaging visualizations - including bar charts, pie charts, and data tables. Please bid if you have: - Proven experience in data input and data analysis using Excel - Mastery in creating insightful PowerPoint presentations - Skilled in graphically representing data via bar charts, pie charts, and data tables. This project requires a professional capable of transforming data gathered through Excel into visually appealing presentations in ...

I am looking for a savvy data expert who is proficient in Excel dashboard creation. The dashboard will focus on visualizing financial and project data. Key Qualities: - Expert in Excel - Previous experience working with financial and project data visualization - Able to deliver insights that guide strategy and decisions Scope: - Display financial data including utilization, drivers and a multi-view perspective - Present project data focused on budget variance and resource allocation Your ability to transform complex data into digestible and insightful visuals will be critical for this project. Get in touch if you have relevant experience and can create a nuanced and comprehensive dashboard.

I'd like to turn 11 of my current .xls Excel sheets into a polished, printable A4 catalogue. This catalogue needs to be formatted properly to ensure product pictures are properly aligned. Because it needs to be emailed to clients, the file size must be under 5MB. For this, we will need: - Proficiency in Excel and perhaps a graphic design program - Experience in creating digital catalogues that can also print - Understanding of file and image optimization for emails. The product images should be of low quality to achieve the desired file size. Lastly, the catalogue should be organized by product name. So, experience with managing a large amount of data and thorough organizational skills would come in handy. Pages should be separated from each of the 11 suppliers.

I need a diligent and efficient worker to help with data entry into an Excel sheet. The scope of work will be entering simple text entries. Requirements: * Reliable and fast typing skills * Prior experience in data entry * Ability to pay attention to details * Deliver on-time and with accuracy Application: In your application, kindly include your past work related to Excel data entry. I am interested to review your related experiences and proficiency. This assignment could lead to an ongoing partnership if your work is of high quality. Thank you in advance for your interest in this project.

I am seeking a proficient data analyst to conduct a thorough descriptive analysis on mixed data (numbers and text). Your role will be to: - Analyze the mixed data using Microsoft Excel - Efficiently interpret the data, understanding patterns and trends - Produce comprehensive reports detailing your findings Ideal candidates will have: - Needs to have experience in SQL, PowerBI, DAX (must)and Python (optional) - Demonstrable experience in data analysis, particularly descriptive analysis - Adept at working with mixed data of both numerical and textual nature - Proficiency in Microsoft Excel, including advanced functions Your ability to interpret and translate data into understandable, actionable insights will be crucial for this project. Experience in making intuitive and in...

I am in need of a tech expert to import data that we've previously extracted from around 2000 webpages into an existing MySQL database. We intend this to not only enhance our site's performance and load times but in tandem, boost our SEO capabilities, ensuring WordPress can effectively read these pages. The data, which includes the URL, keywords, title, H1 and H2, and content, is formatted in an informative Excel file for ease, with webpage elements neatly organised in individual columns. It's necessary that interested freelancers have the following skills and experience: - Proven experience operating with WordPress and MySQL databases - Previous work involving data importation/exportation - Knowledge of SEO optimization - Familiarity with website p...