Database in excelpráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
***WE REQUEST PERSONAL PRESENCE IN CZECH REPUBLIC*** Vaším úkolem bude rozvíjet JavaScript framework pro informační systém agentury práce. Jedná se o databázový systém využívající na backendu PostgeSQL, aplikační server v Javě a frontend je javaScript. Sídlíme v Praze, ale pracovat je možné odkudkoliv. Občasné osobní setkání ale pomůže k lepším výsledkům. Preferujeme dlouhodobou spolupráci.
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
...maintenance materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with Excel...
I'm in need of a proficient individual who excels in SPSS for a data interpretation task. The main task involves the analysis of a questionnaire and exporting relevant tables from SPSS. Here's what I'm looking for: • Skilled in analyzing questionnaires using SPSS • Able to export data into tables • Analysis should be done based on patterns of behavior • Writing a brief description of data based on hypotheses The data is on an Excel file right now. Please bid only if you have relevant skills and experience as it will demand a high level of expertise and detail orientation. Don't hesitate to ask if you have any queries. Thank you!
I am looking for a skilled Excel expert who can help me in organizing and documenting my data into Excel sheets. Key Points: - Your role would involve creating Excel sheets to document the data in a structured format. - I'm seeking a professional who has a good understanding of how to organize data for easy analysis and tracking in Excel. - Though the exact details of the data and the number of sheets are not provided, I expect the freelancer to be capable of handling a variety of datasets and organizing them in a professional manner. Ideal Skills and Experience: - Proficient in Excel, with a track record of organizing and documenting complex data. - Strong analytical skills to ensure the data is structured in...
As a Media TV Channel, we are se...examining our USAID contracts. - Ensuring compliance: It's essential that you ensure we strictly adhere to all terms and conditions outlined in our contracts. - Auditing financial records: You will need to conduct detailed audits of our financial records to guarantee compliance. Industry Experience: While not mandatory, if you've previously worked in the media TV channel sector, it would be an added advantage. Understanding the unique nuances and challenges of this industry will help you excel in this role. Ideal Skills and Experience: - Experience with USAID contracts is a must. - Previous work in media TV channels would be beneficial. - Strong background in contract compliance and financial auditing....
I need a competent Excel specialist to develop a robust strategy for documentations. The specific tasks are not yet determined, and the information that needs to be included will be clarified as we proceed. However, the project has no strict deadline, giving you ample time to plan, organize, and execute best practices. The ideal candidate will possess: - Outstanding Excel skills, including creating and working with complex formulas. - Robust organizational skills to manage and structure vast amounts of information. - Proactive attitude for identifying potential tasks that need documentation. - High attention to detail and accuracy. - Experience in data entry, sales records, and inventory management would be advantageous. Please bid with your plan of action and exampl...
I'm in need of a sharp Australian expert who has access to the Australian Bureau of Statistics (ABS) database and can help me gather pertinent data regarding Melbourne's older population. If you have experience with ABS table builders this should be a relatively easy job as much of the data is collected in these ranges. Key Deliverables in Excel: - All SA3s in the Eastern and Southern Melbourne planning regions - TOTAL number of people in each SA3 and the number of people in the ages of 50+, 60+, 70+, 80+, 85+ - The number of people with income per week in each SA3 of $3,000-$3,999, $4,000 - $4,999, $5,000 - $5,999, $6,000 - $7,999, $8,000 or more The example table shows information from the 2016 Census and I wil...
...need a developer to build a PHP app using Google Sheets as a database. I want add a text on a field it'll to fetch rest row and column data from sheet. Check attachment. I'll enter only order number. This will involve: - Implementing a User Authentication system. Note that no specific features like social media authentication, two-step verification, or forgot password functionality are required. Just a simple log-in/log-out system will suffice. - Data validation will be key in this project. Each entry must be checked to ensure that it meets certain criteria before being stored in the sheet. - Real-time data synchronization between the app and Google Sheets. This means that any changes made in the app should be instantly reflected in...
1 excel import task. and fix minor issue in db. Able to work with ftp. Follow and start Immediately
I need a tool that can search multiple sheets in an Excel workbook and copy specific rows to a new sheet based on manual selection. The core requirements of the tool are: - Searching across multiple sheets to find specific data. - Allowing me to manually select a specific number of rows from the search results for copying. Given these criteria, the ideal tool would be: - Capable of working with Excel files. - Providing a user-friendly interface for easy manual selection. If you have experience with these requirements, please reach out.
I need a highly accurate and detail-oriented individual to assist with entering both numeric and text data into Excel. Requirements: - Excellent proficiency in Excel - Previous data entry experience - High level of accuracy and attention to detail - Ability to handle both numeric and text data entry efficiently This role will suit someone who thrives on working with data and can ensure that all data gets entered correctly the first time, every time.
I'm looking for a freelancer proficient in Excel to help me with daily data entry and organization tasks. Key aspects of the project include: - **Data Entry and Organization**: Your main responsibility will be to input new data, as well as maintain and organize existing data in a structured manner. - **Regular Updates**: The document will need to be updated regularly, making consistency and accuracy pivotal in this role. Ideal candidates should have: - Strong proficiency in Excel, particularly in data entry and organization. - A keen eye for detail and a methodical approach to work. - The ability to work consistently, as the document will require daily updates. - Prior experience with similar tasks is a plus, but not essential.
I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.
I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.
I require a professional data scraper to scrape multiple websites. Key tasks include: - No limitation on type of data scraped as this was not specified. - Scraping must be done across multiple websites, specifics will be provided upon project commencement. - All data should be delivered in Excel spreadsheet format. Ideal skills and experience: - Prior experience in web scraping across multiple diverse websites. - Proficient in using different scraping tools. - Strong understanding of Excel and data parsing. - Attention to detail and commitment to high quality, error-free work.
I am looking for an experienced Excel tutor to provide me with in-person lessons focusing on basic formulas and functions. My Current Skill Level: I would rate myself as a beginner - I have minimal experience with Excel and would need a tutor who can help me understand the basics. Skills to Learn: My main goal is to grasp basic formulas and functions within Excel. I'm looking to build a strong foundation before moving onto more complex features. The ideal candidate for this job has: - Proven experience in tutoring or teaching beginners Excel - Strong understanding of basic formulas and functions in Excel - Excellent communication skills to effectively convey concepts to a novice - Availability for in-person se...
...someone skilled in Excel formatting and function use to build an Excel sheet specifically for financial expense tracking. The aim is to streamline the management of our financials by keeping a reliable track of expenses. While we have some options in mind, we're open to suggestions on how to effectively design and utilize this tool. Your key tasks would be: - Create an Excel based tool tailored for financial expense tracking, taking care to ensure it's user-friendly and simplifies the tracking process. - Enable customizations that further cater to our financial needs. While no specific type of expenses were indicated, the freelancer should be capable of creating a versatile sheet that can record various types of expenses in the futur...
I need a skilled professional who can adeptly convert financial Excel sheets into a document fit for presentations, adhering to standard formatting. The extensive data consists of complex financial information. The perfect match for this project would have: - Profound experience in handling Excel and financial data - Proven knowledge in producing sophisticated documents, maintaining presentability and readability - Ability to deliver precise and clear formatting in standard style Exactness, reliability, and a keen eye for detail are integral for this task. Efficient turnaround time would be appreciated.
I'm in need of a freelancer who can source a list of high-quality, potential customers. These customers should primarily be from the Transportation and logistics or Construction sector. Customers absolutely must have trucks. The more trucks the better. Customers must be in the gold coast region of Australia. Key Information Required: - Contact details: I need a name of the person who manages the trucks their phone number. - Geographic location: It's important to know where these individuals or companies are located. - I need the company name The final list should be delivered in an Excel spreadsheet. Ideal Skills and Experience: - Strong research abilities: The ability to dig deep and find the right contacts in these specified industries...
...insurance products. The successful candidate must have a proven track record in lead generation and appointment setting, as well as excellent communication and negotiation skills. Responsibilities include identifying potential leads, contacting customers, setting up appointments, and following up to ensure sales conversions. The ideal candidate should be familiar with IUL and insurance products, possess strong interpersonal skills, and be able to work independently. Training is provided. We are looking for someone that holds a valid state issued life insurance license or is willing to get a license in any state in America. To become a license agent you will have to be 18 years and up, hold a government issued ID in America, pass a background test, have a so...
I need a professional...- Extracting: I require the following contact information to be extracted: Business Name, Email, Phone number, Full address separated by suburb, postcode and state. - Formatting: All extracted data should be structured and organized into an Excel spreadsheet. Ideal Skills: - Web Scraping: Proficiency in web scraping tools and techniques is essential. - Data Entry: Experience with data entry and extraction. - Attention to Detail: Accuracy in capturing and organizing contact details is crucial. - Excel Proficiency: Ability to create and format an Excel spreadsheet effectively. - Communication: Regular communication and updates on the progress of the task would be appreciated. I'm looking for a reliable freelancer who can de...
Hello. I have a multiple page excel spreadsheet, but I need it to have more flexibility. It is for a 10 room facility, and it's purpose is to show projected revenue based on room type, employee job type, and schedule. The current spreadsheet has 10 rooms with two room types. Also there are 11employees with 6 job types. Your task will be to change the current spreadsheet to 40 rooms, 3 room types. and 22 employees with 12 job types. Changes to be made to Revenue Targets Page, Column A -I want to be able to select room type from a dropdown menu, and input the revenue for different room types on the Revenue Target page. Room types are Private Room, Shared Room, Shared Medicaid. Employees Page, Column A -I want to select employee job type from a dropdown menu for ea...
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS ...
I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.
Necesito crear una un excel con formulas que me calculen los montos acumulados segun una tasa de interes
Generar un reporte con tablas dinámicas nivel general y específico de una base de datos de 10,000 usuarios; se requiere mostrar presupuesto ocupado de 2023 y lo que va 2024; por diferentes áreas cómo se ha gastado el presupuesto, lo que se busca es un reporte como el del llamado ejemplo; pero con la información mostrada en base de datos; visualizar presupuesto utilizado por mes, y por usuario a nivel área.
I'm looking for a skilled Excel expert to automate the formatting of a spreadsheet from a Quickbooks export. Key Requirements: - I primarily need the freelancer to set up and automate formatting in my Quickbooks Excel spreadsheets. - The final formatting should be both visually appealing and easy to read for the end user, we will provide guidance on what the end result should look similar to. Ideal Skills and Experience: - Strong proficiency in Excel, especially with automating processes and conditional formatting. - Previous experience working on projects involving data visualization and presentation. - A good eye for design to ensure the data is clearly differentiated and visually engaging.
I have a project that involves data entry from an Excel file. The data needs cleaning and formatting before entry, and the end goal is data analysis. I am looking for a freelancer who can help me with the following: - Excel Data Entry: Transfer data from an Excel file into a designated system. - Data Cleaning & Formatting: Ensure the data is cleaned and formatted correctly before entry. - Data Analysis: Help in structuring the information in a way that facilitates analysis. Ideal skills for this project include experience in data entry, Excel, and data analysis. Looking for a reliable and detail-oriented freelancer to complete this task efficiently.
I require an experienced data cleaning s...an experienced data cleaning specialist who can proficiently handle Excel spreadsheets. My project involves tidying up datasets related to customer, product, and financial data, though different types of data might need to be scrubbed too. This data cleansing task involves a lower volume dataset of less than 1,000 records. Key tasks include: - Identifying and correcting any inaccuracies. - Identifying and handling missing data. - Assuring the consistency of datasets. The ideal freelancer should have strong skills in spreadsheet management, a keen attention to detail, exceptional data analysis abilities, and a solid understanding of customer, product, and financial data. Experience in Excel and a proven track recor...
I am looking for a detail-oriented professional to assist me with basic data entry tasks in Excel. The primary responsibility will be to input data such as names and addresses into an Excel spreadsheet. Key Responsibilities: - Inputting basic data into Excel spreadsheet Furthermore, the project requires data verification. This means ensuring that the data has been accurately entered. You will be required to cross-reference the inputted data against the source material to detect any discrepancies or errors. Ideal Skills & Experience: - Proficient in Excel - Attention to detail - Strong data entry skills - Familiar with data verification processes - Previous experience in basic data entry This project is quite straightforward, but pr...
I'm looking for a skilled professional to assist me with various customer suppor...Please be prepared to manage customer inquiries through phone calls, email, and live chat. - Managing Customer Databases: This project requires proficiency in maintaining databases across various platforms including CRM systems, Excel spreadsheets, and online database platforms. - Analyzing Customer Feedback: An ideal candidate will have experience in analyzing customer feedback to help our services grow. The ideal freelancer for this project should possess: - Proven experience in customer support and management - Excellent communication and interpersonal skills - Proficiency in using various CRM systems, Excel, and online database platforms - F...
I have a need for a comprehensive listing of Oracle EBS customers within the manufacturing sector in USA. This is a sizable task as it requires the creation of a list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelanc...
I need emails from these companies of CEO ot anyone else working in financials, sales, or partnerships. Data scraping from rocketreach of the emails of the people that you can find with relevance from these companies in the image. Excel sheet with company name in the rows and in the 3 columns full name, email and position in the company
Data entry operator and my work very clear
I'm in urgent need of a Python Django developer to help me deploy my old website files on Namecheap. Here's a rundown of the tasks and requirements: - Deploying old website files on Namecheap: I need you to swiftly and effectively set up and configure the database for my project. - No new development or integrations: You won't be tasked with front-end or API work, just the deployment of the existing files. Your experience with Django and database setup are paramount. Time is of the essence, so I need a professional who can work efficiently and effectively.
I'm looking fo...for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. Please include samples ...
I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.
Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not use...
Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!
