Combine data different tab 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í.
Dobrý den, rád bych Vás oslovil s nabídkou práce na vytvoření stránek, které budou umožňovat lidem hrát různé hry o virtuální měnu v podobě skinů ze hry CS:GO. !!! PLATBU ZA PROJEKT PROVEDU AŽ PO DOKONČENÍ A PŘEDSTAVENÍ HOTOVÉHO DÍLA !!! V opačném případě mne ani nekontaktujte. Platba předem nepřipadá v úvahu. Již jsem byl podveden a mám špatné zkušenosti. Stránky musí umět : Napojení a přihlášení přes steam API viz. Steam analyst API viz. OPSkins API Vzhled stránek může vycházet z následujícíh : (Lehce preferováno) ...
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
I'm in search of an accomplished tattoo artist who specializes in minimalist designs. I have two existing pictures that I want expertly combined. The first picture is a depiction of Tin Tim the character. I just want his dog changed to my personal dog which may have to be re sketched. I have many photos for reference. - The design will be placed on my...photos for reference. - The design will be placed on my leg. - The freelancer must be able to thoughtfully blend these two pictures into a minimalist tattoo sketch. - I'm looking for someone with an eye for detail and strong familiarity with minimalist sketching styles. Ideal skills for this project will include: - Proficiency in minimalist sketching - Demonstrated ability to creatively combine images - Prior tatto...
I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues...
I'm looking for a skilled data analyst to help me with a comprehensive statistical analysis of a survey I conducted with roughly 100 participants. Key Requirements: - Proficiency in Descriptive, Inferential, and Correlation data analysis techniques - Experience in interpreting survey data to identify trends and patterns - Ability to test hypotheses and make inferences - Knowledge of how to determine relationships between variables - Excellent skills in Excel and/or other statistical software or python for data manipulation and analysis Ideal Candidates: - A data analyst with a proven track record of handling survey data - Someone who can derive meaningful insights from the data - Excellent communication skills to explain the ...
As an active user of the Odoo 17 platform, I am looking to augment my current interface further. Key Tasks: - Addition of 'Tickets', 'Tasks', and 'Subscription' buttons at the top of the existing Contacts form. - Insertion of a new tab to summarise all tickets connected to a contact. - Modification of Arabic fonts to a Cairo font with Right-To-Left (RTL) layout. The ideal freelancer for this task should: - Have extensive experience in modifying Odoo interfaces, particularly Odoo 17. - Be capable of swiftly yet carefully carrying out these modifications, as I require them within a day. - Showcase pertinent past work in their application to demonstrate the relevant skills and experience.
I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrieved and...
...a PERL, HTMX, MYSQL programmer who can help me with an intermediate level project. The ideal candidate should have experience in these areas and be comfortable starting a project from scratch. I will give you a dump from my MySQL table. From which I need an interactive HTML interface, based on Perl, HTML, HTMX to this table. I need to be able to search, add, edit and delete entries as well as combine two entries into one, all via one HTML::Template file with a single perl script as interface to the MySQL table. I do want an active submit button for all changes, as well as a single interactive upload button for each field of the MySQL table. also each field needs to be validated via a given specification. All code needs to be well documented and commented. Perl based database inte...
...knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong under...
I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear and insightful manner. ...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each pi...
I'm in need of a graphic artist who can create 2-3 gif animations for advertising my mechanic business in a game called FiveM. Key Points: - The GIFs should depict the services we offer: repairing, customizing, and upgrading vehicles. - They should visually capture the essence of the game and resonate with its community. - I would like ...game and its graphic style would be an advantage{The better Graphics the better). - Ability to communicate complex ideas through visually engaging and creative graphics. In essence, I'm looking for someone who can deliver professional, yet game-appropriate, advertising graphics. Understanding our services and how they fit into the game's universe is key to this project's success. If you can combine these aspects in a visua...
I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel spreadsheet.
I'm looking for a skilled developer who can create an interactive VR shop that doubles as an English learning platform. This is a unique opportunity to combine e-commerce with language learning. Ideal Skills: - Proficient in VR development - Experience with e-commerce platforms - Knowledge of gamification in education Key Features: - Product Catalog: The shop will offer a range of items, but the primary goal is to provide a practical English learning experience. - Interactive Elements: The shop must be engaging, with interactive tasks that are designed to improve the user's speaking fluency. - User-Friendly: The site must be intuitive and easy to navigate, suitable for an adult audience. I'm particularly interested in a freelancer who can bring creativity to the p...
I need help with my accounting and auditing tasks, including bookkeeping, financial statements preparation, and internal control evaluation. I'd like to include 1 year of financial data in the statements. I require a professional with the following skills: - Proficiency in QuickBooks, Xero, and Excel spreadsheets - Experience in bookkeeping - Preparing financial statements - Evaluating internal controls Your role will be crucial in ensuring that my financial records are accurate and compliant with accounting standards.
We need a list of all stores in US & Canada that fall under any of the following categories/keywords: Watch Store Watch Repair Shop Jewelry Store Jewelry Repair Shop Fashion Boutique Outdoor Goods Store Sporting Goods Store Electronics Store Mobile Phone Repair Shop You will have to scrape these websites: Yelp, Yellow Pages, Google Maps I have provided an Excel template to follow.
...need of a highly skilled data entry operator to assist with my Tally entries and MS Excel billing work. The ideal candidate should be well-versed in both Tally and MS Excel, as well as have a strong attention to detail and a high level of accuracy. Key responsibilities include: - Data entry: You will be responsible for entering a wide variety of data into Tally, including processing of invoices, bank statements, and other financial records. - Account reconciliation: Regular reconciliation of Tally entries against bank statements and other financial records is crucial to ensure accuracy in our financial data. - Inventory management: Tracking and updating inventory records in Tally is another essential task that needs to be performed regularly...
I need a pretty simple Excel spreadsheet. It is for a used car dealership. I need a row to imput the vehicle, one for the purchase price of the vehicle, one for the cost to prepare the vehicle for sale, one for the sale price, and one for the profit or loss on the sale. I would like it setup with tabs at the bottom for months and years
I'm looking for a proficient Excel expert to create a comprehensive, automated meeting minutes template for Excel 2016. Key Features: - Auto-fill dates and participant names - Automatic calculation of meeting duration - Dynamic agenda item addition - 15 task owners fields - Core areas discussed: Process, People, Technology, System Ideal Skills: - Advanced Excel skills - Strong knowledge of Excel 2016 - Experience in creating automated templates - Eye for detail to ensure the tool works flawlessly The goal is to streamline our meeting minute creation process and ensure accuracy in documenting key points discussed and task assignments. Delivering a user-friendly tool that requires minimal manual input is key.
Ready to take on a challenge? I am in need of a well-experienced full stack developer who is adept in Wordpress, or another similar site-building system that can be easily modified in future for both design and SEO optimisation. Your expert ability to seamlessly combine front-end and back-end capacities will be crucial to the success of this project. The project encompases 3+ websites, new logo design, testing, and hosting capabilities. Key Requirements: - Mastery of Wordpress or similar. - A minimum of 5 years experience in full stack development. - Expert in UX/UI. - Integration of chat function. - Integration of ticketing system. - Integration of chat function. - Integration of advertising banner function. - A proven record in deploying and maintaining functional, secure and h...
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Invento...
I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.
Wordpress Single product page - product tab section - Need to change tab title and tab content. Note- this was done long back by the person who designed the website. Probably he used some snippets to change the tab name. The present tabs are - Description Additional Information - ( now named as - "size guide" ) reviews Freelancer needs to change the tab content of "size guide" and explain, from where content can be uploaded for the tab - "size guide"
More details: We are...database. This isis for your reference : We operate a LPG gas agency, where customers exchange their empty cylinders for filled ones. However, sometimes we give out filled cylinders before receiving the empty ones back, resulting in two separate inventories: one for filled cylinders from our dealer, and another for empty cylinders returned by customers. To streamline this process, I propose adding a tab or checkbox in our Point of Sale (POS) system when selling the product, prompting the staff to confirm whether the empty cylinder has been received. If yes, it should update the Empty Cylinder stock; if no, it should not. Database management, Creating Two New database and a button in a dashboard., Need someone Who understand complex Backend Architecture in ph...
I'm in need of a female, tall and slender model for a casual wear project in Bulgaria. Ideal Skills and Experience: - Proven experience in fashion modeling, preferably in casual wear - Must be tall and slender - Strong portfolio showcasin...Bulgaria, or willing to travel there - Good knowledge of posing, expressions and movement in front of the camera - Ability to convey the brand's image and the style's feeling. Your responsibilities would be: - Wear our clothes for photoshoots, ads and other fashion embedded content - Showcase casual outfits in various settings, interpret the concept and style. A successful candidate will combine a professional attitude with an understanding of the casual wear industry. If you believe you're a fit, please bid ...
I am in need of an experienced content creator who can produce anime scripted videos for my e-commerce platform. - Genres: The videos to be created will combine elements of social constraints and product description. Previous experience in creating videos with these themes is a plus. - Ethical Guidelines: It's crucial that the content adheres to ethical guidelines. The candidate should have a good understanding of these guidelines and can apply them effectively in the videos. - Product: The videos will be showcasing an e-commerce platform. The ideal candidate should be able to incorporate the products and services offered by the platform creatively and engagingly. Skills and Experience: - Previous experience in creating anime scripted videos. - Strong understanding of social ...
Description: Are you a freelance sales professional with a knack for closing deals and a passion for helping others succeed in their care...Deep understanding of the IT, sales, marketing, finance, and accounting industries, including common interview practices and requirements. - Outstanding communication and interpersonal skills, with the ability to tailor your pitch to different audience groups. - Self-motivated and results-driven, with a strong desire to achieve and exceed sales targets. If you're a freelancer looking for an exciting opportunity to leverage your sales skills and make a meaningful impact on the careers of others, we want to hear from you! Join us in empowering individuals to excel in their job interviews and achieve their professional goals. DM your ...
I'm seeking an Excel expert to provide a comprehensive training session for my team of 11-20 individuals. We're at a beginner level and need someone capable of teaching us the basics and showing us how to optimally utilize data analysis and reporting features. - The training should cover: - Basic Excel functions and formulas - Data analysis - Reporting techniques The perfect fit for this project would be someone with an extensive background in Excel, ideally as a trainer or educator. Experience with teaching groups is a must, and the ability to break down complex topics into digestible, understandable parts is essential. Our goal is to increase our productivity and data handling capabilities through this training, so if y...
I'm looking for an Excel expert who can create an automated template for a financial renewal analysis dashboard. The dashboard should include basic descriptive statistics functions such as mean, median, mode, standard deviation, correlation, and regression. Key Requirements: - The dashboard needs to focus on the renewal status of our products/services. - It should be able to track the renewal status by product/service type. - The dashboard should be able to automatically update renewal statuses. Ideal Skills and Experience: - Proficiency in Excel and its advanced functions. - Experience in creating automated dashboards. - Understanding of financial data analysis, particularly in the context of renewals. - Strong communication skills to understand our specific ne...
I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a ro...
I'm in need of an experienced UI/UX designer to review, customize, and improve my Shopify store's existing theme, as well as the app using in Shopify that sells phone cases and accessories. The primary focus is on enhancing the user experience to drive increased conversion rates. Key requirements include...design, particularly for e-commerce platforms - A clear understanding of user experience best practices and how they relate to increasing conversion rates - Strong communication skills and a proactive approach to suggesting improvements I'm looking for a proactive, creative and experienced freelancer who can take my store to the next level. Your approach to the project should combine a keen eye for design with a data-driven understanding of how UX improveme...
I need an expert WordPress programmer who can create custom functions for my website. Currently, I need to fix two things: I have a list of offers in the hotel tab of each individual hotel, and I want to open them using a custom button rather than the native link of the accordion. If I post an offer for a hotel, that offer should only be visible for that specific hotel. However, at the moment, it is shown in all hotels, even though I select the hotel to associate these offers with from a select box in the control panel during the posting phase. This involves creating custom queries for WordPress. I usually use PHP/MySQL, but for this new version of the site, I am using WordPress. The total budget is 15 USD it's not a demanding job for an expert. I am attaching images to cla...
I am looking for a Video editor that can perform the following tasks - - Remove green screen and replace it with image background - Combine multiple footage - HD (1080) Render
I have a need for a meticulous freelancer with solid web research and data entry skills. The project involves researching company details and the necessary data should be accurately entered into an Excel sheet. Key Responsibilities: - Detailed online research to gather specific company data. - Accurate data entry of information into Excel, adhering to specific guidelines. Ideal Candidate Skills: - Strong web research ability. - Very accurate data entry skills. - High proficiency in Excel. - Able to meet deadlines. - Excellent attention to details.
I'm in need of a skilled freelancer with proficient online research and data entry skills. Responsibilities: - Conduct online research to collect necessary data - Expertise in entering numerical data precisely - Compile, verify accuracy and organize the information into a Excel spreadsheet Desired skills/experience: - Attention to detail - Experience in data entry - Excellent knowledge of MS Excel - Strong ability in online researching
...01 Signup Form with Phone, Email, Address Step 02 A chat box would open up with basic questions as; • Date for Booking • Time Period for Booking Step 03; Within the chat box the next question would be regarding the work profile Users can text to match profiles. Example: I want Bamboo Artisans Step 04: The Chat box will show all profiles for Bamboo Artisans as in the Directory or excel file Excel would be as simple as Skill Set, Profesional Profile Step 05: The User will select the profile they want and the next would be followed to payment gateway. Step 06. Post payment a confirmation message would be sent with contact details Service Provider Interface Step 01 Signup Form Step 02 Detailed Profile Step 03 View Bookings, View Amount which will b...
...real-time. Key Requirements: - I need the dashboard to be able to pull data from reliable sources(officials in polling station in an excel form) and refresh the data in real-time. This will facilitate the display of accurate and up-to-date results. - The design of the dashboard should be clean,animated,interactive, intuitive and easy to understand for users. It needs to be able to show data for both elections simultaneously with the help of a switcher between the two pages. - The dashboard should be mobile responsive, so that it can be viewed on various devices with ease. - The security of the data is paramount, so it's important that the dashboard is developed with necessary security measures in place. This is to secure the data which off...
I'm in need of an Expert Excel programmer to help design a user-friendly Excel sheet focusing on stock and ledger management. Specifically, I'm interested in: - Incorporating Automatic Calculations: The ideal candidate should be able to create a system that automates complex calculations based on data inputs. - Dropdown menus: The sheet should offer an easy interface with dropdown menu options for hassle-free data inputs and editing. - Linking Stock and Sales: The sheet should be designed in such a way where the inventory updates automatically from sales data. So, a keen understanding of Excel's data integration and interconnection capabilities is necessary. - Essential Data Fields: My Excel sheet needs to include spec...
I just need a list of employees from Linkedin Recruiter.. I will get in a google-meet or zoom meet with you, and I give instructions. _We need to find the list of 'Open to Work' People from a particular Company in India. The re...Work' People from a particular Company in India. The reason for doing that is, We want to look for employees, who are considering Job switch from this company. _we will together log into your Linkedin Recruiter account _We will look for 'open to work' candidates _we will export the list (around 313 people) in CSV or Excel or PDF format. _If exporting the list is costly, in that case, I will simply take screenshots of the List (of candidates), and will later convert that into excel sheet. **The Task will take maximum of 1...
I have a project that involves the entry of data from Excel into a new system. The data entries are in Excel format, and I estimate the total number of entries required to be between 100-500. The task will involve a mix of text and numeric data. Ideal Skills: - Proficiency in Excel - Strong attention to detail - Efficient, accurate data entry - Previous experience with data entry projects of similar scale This is a straightforward task that requires someone who can work accurately and efficiently. Meeting the estimated entry count and maintaining data quality are key.
