What are advanced excel skillsprá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í.
...rozsahem desitky hodin spolupráce. Požadujeme zkušenosti metodickým zpracováním a vytvořením materiálů a profesionální vedením tréninků soft skills. Zkušenosti jsou nutné. Účastníci jsou nároční na praktické vedení a odbornost. For the assistance service (assistance call center), we are looking for an external lecturer - trainer. The subject of delivery is to provide a short "standup" training for call center operators on topics such as communication, stress, positive call management, etc. in polish language. Delivery consists of - Translation of existing materiáls or co-creating materials for topics - in polish langu...
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
...odnosno scripta ( radi se o samostalnim izrađenim plugonovima odnosno skriptovima) koji se samo instaliraju: 1. 2. 3. 4. 5 Molim za ponudu št opre. Pozdrav...
...reset the circuit and it is asynchronous and active low. In addition, there is a 1-bit CLOCK as the clock. The circuit will start the operation when a 1-bit input signal START is asserted. A fruit detector provides a 1-bit input FRUIT that becomes 1 for one clock cycle if banana is detected and the FRUIT signal will be 1 for two clock cycles if orange is detected. There are 2 different outputs which are OUT1 and OUT2 that will be 1 for one clock cycle for the type of fruit where the total count is 3. OUT1 is for banana and OUT2 is for orange. Assume that the FRUIT signal is available at every three clock cycles. In addition, for the type of fruit where the output is become 1 for one clock cycle, the total count will be reset to 0 and the circuit can proce...
I have an APK which is crucial for the security of my device. To prevent unauthorized deletion, I need a professional with advanced knowledge in Android development to implement an anti-uninstall feature. Key Requirements: - Implement an anti-uninstall feature that requires Root access. - Ensure the feature is discreet, and can't be easily bypassed. - Ensure the feature doesn't significantly impact the performance of the APK or the device.
...Highlight Features: - Implementation of a highly detailed "Breeding" functionality. The plugin should simulate realistic genetics and pedigrees. Coding skills that accurately mirror real-life genetics are a must. - The "Horse Illness" feature. This should take into account various factors such as environmental conditions, the age and breed of the horse, and interactions with other horses. Experience with AI that can account for these dynamic variables would be ideal. - Additional features involving other realistic horse behavior, such as eating and drinking. The perfect candidate for this task is someone with advanced programming skills and a solid understanding of equestrian science or a demonstrable ability to research and apply the ...
I'm looking to enhance my existing managerial skills on a personal level. The project is targeted at improving how I manage my personal commitments as well as my individual consultations for opportunities. Ideal Skills and Experience: - Substantial experience in professional or personal management - Demonstrated ability to convey complex ideas into manageable and executable tasks - Impeccable communication and interpersonal skills To apply successfully, please include: - Details about your relevant experience in managerial projects or roles Please note that I aim to finalize this project within a month. Looking forward to learning from the best!
I'm in need of a custom bill format in Excel that incorporates my company's logo and branding. The bill should have automated calculations for the ease of use. Key Requirements: - A customized Excel bill format with a professional finish - Integration of the company's logo and branding into the bill - Automation of calculations within the bill Ideal Skills: - Proficiency in Excel, including advanced formula creation - Experience in design, particularly in creating professional, branded documents - Understanding of automated calculations and their implementation within Excel Upon completion, I expect to receive the Excel file with the custom bill template.
I am in search of a virtual assistant proficient in PowerPoint creation and well-versed in content research to assist on a monthly basis for my existing business. Although emphasis will be placed on PPT-making, some assistance with content research will also be required. Essential Skills: - Advanced knowledge and experience with PowerPoint - Proven content research capabilities - Organizational and time-management abilities Experience in the following areas would be beneficial but not essential: - Prior virtual assistant roles - Dealing with other business-related tasks as required including telecalling Please consider that this role is monthly and primarily focused on PPT-making when submitting your bid.
I'm seeking an experienced profession who specializes in secondary school level human biology education. This project entails designing and creating an array of innovative educational materials including: - Video lectures, giving clarity to complex biological concepts in an eng...providing detailed content in a language that's accessible to secondary school students. - Interactive quizzes, offering enjoyable and effective methods of knowledge testing and retention. The ideal candidate should possess a strong understanding of human biology and its pedagogy, with proven experience in creating engaging and age-appropriate educational content. Your goal will be to render advanced biological concepts understandable and interesting to secondary school students, igniting a pass...
I'm seeking a professional to create a series of pre-recorded training videos for an cloud based software.
As the client, I am seeking for professionals who can expedite the creation of an effective, 1-3-page website for the promotion of my products and services. The must-have features o...business. It is preferred that potential candidates should have: - Proven experience in UI/UX design for better website navigation and interface. - Proficiency in social media integration for optimal online exposure. - Advanced understanding of website building and content writing. Given that I require the website to be completed as soon as possible, ideal freelancers should showcase a demonstrated history of timely project execution and delivery. High attention to detail, great communication skills, and the ability to complete tasks quickly without compromising quality are essential....
I'm looking for a professional who can assist in converting screenshots, which already depict data set in tables, into Excel tables. The purpose of this task is to better analyze the data, which is purely textual in nature. The ideal freelancer for this job would be experienced in data entry, with a particular emphasis on Excel, and have an eye for detail to ensure all data is transferred accurately. There's no requirement for interpretation or analysis, I simply need the information from the images moved into an Excel format. Attached is a sample of the screenshot.
I have Excel sheet in the are all products added with all the categories in it. I will also share a word file in which I will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This
I need a proficient freelancer to help convert my Excel files, containing both numerical and textual data, into Word documents. The aim of this conversion is to ease the process of creating reports. The data should be precisely formatted into tables in the Word documents for a cleaner presentation. The ideal candidate would require: - Excellent skills in Microsoft Excel and Word. - Proficiency in data conversion and formatting. - Attention to detail to maintain data integrity. - High regard for timeliness and efficiency. Understanding the importance of report creation in business communication, this work must be meticulously done, reflecting professionalism in every converted document.
...for an experienced data entry professional to help me in typing less than 10 pages from a text document to Excel. This project involves text-based data entry. Here’s what I am looking for in the ideal candidate: - Proficient with Excel and able to input data with high accuracy - Experienced in copy-typing from PDF or other formats to Excel - Fast typing speed with a keen eye for details Ultimately, I require a reliable individual that can work efficiently within a set timeline. Your responsibilities will include: - Transferring data from the document into Excel accurately - Proofreading data entries to ensure no mistakes were made Please ensure you bring a good understanding of Excel functionalities. The text to be copied is less than...
I require a unique search engine designed that can effortlessly comb through several car websites (, , , , , , , Facebook Market Place) and display the results in one convenient place. Key functionalities should include: - Advanced filtering options - Price range filtering - Location-based search Ideal expertise would entail experience in advanced web scraping and designing search algorithms, along with a deep understanding of diverse automobile databases and SEO. The candidate should be capable of verifying and testing the accuracy of the collected data as well. Efficiency in coding with an ability to manage site speed and response time is crucial, especially considering the breadth
...Highlight Features: - Implementation of a highly detailed "Breeding" functionality. The plugin should simulate realistic genetics and pedigrees. Coding skills that accurately mirror real-life genetics are a must. - The "Horse Illness" feature. This should take into account various factors such as environmental conditions, the age and breed of the horse, and interactions with other horses. Experience with AI that can account for these dynamic variables would be ideal. - Additional features involving other realistic horse behavior, such as eating and drinking. The perfect candidate for this task is someone with advanced programming skills and a solid understanding of equestrian science or a demonstrable ability to research and apply the...
I'm keen on gathering a customized list of up to 50 nano or micro influencers who are distinguished in the pet food product niche. The preferred influencers are mainly those active on IG, FB or YouTube. To attract quality bids, freelancers should possess: - Expertise in Social Media and YouTube data gathering. - A strong understanding of the pet products industry. - Ability to identify key influencers in the pet products niche. - Tracking and reporting capabilities. Freelancers with current experience in influencer research will be given priority. The deliverable is a Report (Excel format preferably) that includes: - Full Name of the nano/micro Influencer - Profile Link - Username - Channel Name - Channel Type (IG, FB, YT, etc) - Email (must be current and ...
As the client, I am seeking for professionals who can expedite the creation of an effective, 10-page website for the promotion of my products and services. The must-have features of this...to my business. It is preferred that potential candidates should have: - Proven experience in UI/UX design for better website navigation and interface. - Proficiency in social media integration for optimal online exposure. - Advanced understanding of HTML, CSS, JavaScript etc. Given that I require the website to be completed as soon as possible, ideal freelancers should showcase a demonstrated history of timely project execution and delivery. High attention to detail, great communication skills, and the ability to complete tasks quickly without compromising quality are essential....
...bot that integrates with my unique set of custom trading signals. Here are some of the key points about the project: - Custom Signals: The trading bot will need to accurately interpret and act upon a specialty set of trading signals that are defined by multiple criteria. - Integrating Indicators: I haven't specified my choice of indicators yet. However, your knowledge and experience prioritizing and integrating various indicators like Moving Average, RSI, Stochastic Oscillator, or MACD will be a key assessment parameter. - The Blend: The trading signals will be based on a mix of rules precisely relying on price actions, trading volume and market trends. Resolving this blend effectively holds vital importance. Skills and Experience: - Mastery of pertinent...
I want a individual, to tell me how feasible it is, to copy this extension, We take inspiration from this extension and get something similar up, in the shopify app store, of course you need to ensure it is not a dumb copy, to avoid copyrights, make some tweaks etc In your proposal I expected, to have a plan included, how long it will take, any suggestions, and if you have done something similar before, if you have created extensions, share the link. Please include Hello world to the top of proposal.
I'm seeking a talented designer to create a distinctive and functional outfit for women's competitive tenni...fabric for the outfit is yet to be decided. - It should be functional, aiding in performance during matches. - The design should be modern and visually appealing, suitable for the competitive tennis environment. Requirements: - Strong design skills, particularly in sportswear. - Experience in creating custom clothing for sports. - Knowledge of functional and performance-enhancing fabrics. - A keen eye for fashion and current trends in sportswear. Your task is to develop a unique and high-performing outfit that will help a female tennis player excel in competitive play. The successful design should not only enhance performance but also make a distinct fash...
...background in diplomacy and international trade. Key Points: - Looking for advanced level expertise in US foreign policy. Your knowledge and insights should be at a level where you can provide in-depth analysis and propose innovative solutions. - The primary task will be to deliver written reports. These reports should be well-structured, detailed, and insightful, providing a deep dive into the implications of US foreign policy on diplomacy and international trade. Ideal Skills and Experience: - Proven experience in US foreign policy analysis, with a particular emphasis on diplomacy and international trade - Advanced knowledge and understanding of US foreign policy - Excellent research and report writing skills - Strong analytical capabilities to provide d...
I want a individual, to tell me how feasible it is, to copy this extension, We take inspiration from this extension and get something similar up, in the shopify app store, of course you need to ensure it is not a dumb copy, to avoid copyrights, make some tweaks etc In your proposal I expected, to have a plan included, how long it will take, any suggestions, and if you have done something similar before, if you have created extensions, share the link. Please include Hello world to the top of proposal.
...(CRM) app aimed at small to medium-sized businesses, as well as burgeoning startups. My expectation is a system that integrates three-fold functionality: • Coherent Contact Management: integration of an intuitive system to store and manage contact information. • Flawless Deal Tracking: A real-time, efficient system to track ongoing deals and future opportunities - very crucial for operations. • Advanced Email Tracking: A system that allows the tracking of sent and received emails, giving real-time updates and promoting efficient communication. In addition, the app should cater to finance, IT and HR operations, to facilitate seamless business activities. Developers adept in CRM software, experienced in multi-functional platform coding, and with a keen understandin...
I am seeking an AI coder for the development of a full-featured online ordering platform that emphasizes on streamlining orders and deliveries. Primarily, the platform should be designed to : - Excel on both desktop and mobile devices ensuring a smooth customer experience on all interfaces. - Prioritize on real-time scheduling functionality that optimizes order fulfilment with exemplary efficiency. -Connect to Service Monster API -Use as payment gateway. Ideal candidates should possess profound expertise in AI coding specifically in enhancing online platform functionalities. Experience with building real-time scheduling systems is critical for this project. Furthermore, a strong background in mobile and desktop compatibility is essential. The aim is to create an ordering
I am seeking an experienced...experienced RPA Developer to automate tasks relating to Excel and Web interaction. Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink you will open a broswer tab with that link analize the result of the web programming 1 or 2 IF statements Proceed to generate the unatended "clicks" in that web close the tab iterate with the next excel cell (in this case d6) repeat the web process Until Excel's data EOF Everything configurable via external TXT file - name of the excel file - starting cell - basic hyperlink - how to compose the final hyperlink - the IFs statements - the sequence of clicks for each IF condition Immediate offers after posting will be direct...
...Microsoft Office Suite: Proficiency in Word, Excel, and PowerPoint is required. - Vettrak Student Management System: Experience with this software is beneficial but not mandatory. - Dropbox: Familiarity and experience with file management on Dropbox. - Facebook and Instagram. Ideal Skills and Experience: - Previous experience in administration, data entry, and customer service roles. - Intermediate proficiency in Microsoft Office Suite. - Experience with social media platforms Facebook and instagram for marketing and communication purposes. - Experience with Dropbox or similar file management systems. - Strong communication skills and attention to detail. - Ability to work independently and remotely. If you are reliable, have the relevant skills, and...
I am in need of a skilled bookkeeping specialist proficient in Tally data entry and Excel data entry and formatting. Key Tasks: - Entering less than 100 entries per week into Tally. - Formatting and managing Excel data. The work will be ongoing, with updates and reports required weekly. Ideal Candidate: - Must possess extensive experience with Tally and Excel. - Proficiency in bookkeeping and data entry. - Ability to handle tasks efficiently and with a high degree of accuracy. - Understanding of financial reports and data reconciliation. The ideal freelancer will be able to deliver clean, well-organized data, and provide timely reports. If you have the skills and experience required, please get in touch.
I am looking for someone proficient in typing to convert content from a 30 page PDF into Word and Excel documents. The majority of the content will go in Word with a few items to be transcribed into Excel. Requirements: - High typing accuracy and speed - Familiarity with Word and Excel formatting Specific instructions: - For Word, the content should be formatted in Calibri 12 point font and single spaced. - For Excel, maintain one row per entry for optimal readability. Ideal candidates should have prior experience in similar data entry tasks. Familiarity with PDF conversion tools, text formatting, and spreadsheet management would be a plus.
I'm looking for a skilled individual who can help me read a file and extract specific data from it. Key Requirements: - Extraction of File names, File sizes, File creat...sizes, File creation dates, and messages stored in the DB file. - Ability to adapt to extracting all messages or specific ones, depending on my future needs. - Delivery of the extracted data in a Spreadsheet format, preferably Excel or Google Sheets. Ideal Skills and Experience: - Proficiency in reading and interpreting files. - Advanced skills in data extraction, particularly from database files. - Experience in delivering data in a spreadsheet format. - Flexibility to accommodate future changes in the extraction requirements. - Strong communication skills to clarify requireme...
...can export the text and numeric data from a PDF table into an Excel spreadsheet. I would like the Excel data to be organized according to the fields in the PDF table. All fields in the PDF table should be included in the Excel sheet. Key requirements: - Export text and numeric data from a PDF table into an Excel spreadsheet - Organize the data on Excel according to the fields in the PDF table - Include all fields in the PDF table in the Excel sheet Ideal Candidate: - Proficient in PDF to Excel data transfer - Excellent attention to detail for verifying and cross-checking data - Familiarity with text and numeric data formatting in Excel - Capable of delivering accurate and organized final results. There will be 901 rows of Ex...
...Microsoft Excel and Shopify for a data entry project. Having a deep understanding of these two platforms is crucial to the seamless execution of the task. The project involves: - Using a spreadsheet to find and identify approx 4500 books on Amazon. - Using an online import tool to bring book data into a Shopify website - Adding extra product information in the shopify website from the spreadsheet about the book. - Determine the genre of the book and categorising in shopify accordingly. The ideal candidate should have: - Proven experience in data entry, preferably within Shopify. - Access to US version of Amazon. - Proficiency in Microsoft Excel. - High level of accuracy and organisation. - Good level of English communication and written skills The job requires i...
I'm in need of an accomplished JavaScript developer to fine-tune my current JSON to XML conversion process for Roku. The entire focus is on enhancing the accuracy of format. As the matter is of utmost importance, I need this to be executed with immediate effect. - Key Task: Refining the JSON to XML conversion for Roku. - Required Expertise: Advanced proficiency in JavaScript and a solid grasp in handling JSON and XML data types. - Timeline: Urgent. The need is for it to be completed as soon as possible. Your responsibility would be to scrutinize the current programming and effectively enhance its format accuracy. Proven experience of similar tasks will be considered a significant plus. Your ability to prioritize tasks and deliver solutions promptly will be highly valued.
As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. Key Features: - Automatic Calculations: The plugin should be capable of performing automatic calculations, saving time, and minimizing any possible errors. - Data Validation: Ensuring data accuracy is crucial, thus the plugin should include data validation steps that help identify and correct any inaccuracies promptly. - Customizable Formatting: To enable smoother navigation and interpretation, the plugin should allow for customizable formatting tailored to my data and personal preferences. - Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manually select the version to w...
I have a list of addresses for invitations that need to be transcribed from a handwritten list into an Excel spreadsheet. The addresses should be formatted consistently in the following structure: Name, Street Address, City, State, Zip Code. - Handwritten list will be provided, and should be transcribed accurately - Standardize the address format for consistency - No correction needed for typos, just ensure the format is standardized The ideal freelancer for this project would have: - Proficiency with Excel for data entry and formatting - Attention to detail to ensure accuracy and consistency - Experience with handling addresses or similar data is a plus
I'm seeking an experienced Excel professional to assist with the implementation of various financial formulas and functions in my spreadsheets. I am trying to create an excel sheet for sales people to put some data entry and get final pricing. i have the basic excel sheet ready, and if you willing to work on it i can share it and explain in more details In particular, I need help with: - The execution and application of financial functions specifically. - An ability to accurately conduct cost and estimating calculations. - Strong problem-solving skills to fine-tune formulas for efficiency and accuracy. A background in finance and substantial experience with Excel's wide array of financial functions would be very advantageous for the successful compl...
I'm in need of a sophisticated chatbot solution. This chatbot should have the capability to interact with and analyse documents uploaded to it – including PDF, Excel, and Word files. Here is what I am expecting: Document Interaction: • Extract information from PDF, Excel and Word files • Provide document descriptions that enable efficient and informative interactions Graph Generation: • Generate graphical representations from data extracts • Capable of creating bar charts, pie charts, and line graphs Desirable Skills & Experience: • Expertise in Django is a must • A good understanding and experience of GT4 API • Knowledge of ORM and DRF • Familiarity with data visualization may come in handy To recap,...
I am seeking a proficient R programmer to assist with the evaluation of statistical significance in a large dataset. This project will involve data cleaning processes to address missing data, outliers, and unbalanced classes from CSV files. An in-depth understanding of advanced analytics and R programming is needed. • Proficiency in R language • Experience handling CSV files • Strong ability with data cleaning methods (dealing with missing data, accurately identifying outliers, working with unbalanced classes) • Expertise in evaluating statistical significance The selected candidate should not only have technical expertise but also the ability to interpret data and present findings in a clear, concise manner. This project shall pave the way for consequential de...
I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.
