Basic macros 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.
Natáčíme videorozhovory a potřebujeme někoho, kdo se postará o postprodukci a editaci videí pro Youtube kanál. Potřebujeme, aby člověk uměl editovat videa (Adobe Premium Pro, Adobe After Effects nebo DaVinci Resolve) + editace zvuku. Pokud by uměl vytvářet i thumbails, je to velkou výhodou. Basic základy Photoshop Ilustrator a grafický základy také výhodou. Jedná se o střih a editaci naučných videí pro www.kryptoskola.cz. Koncept, video materiál a ke každému videu poskytneme storyboard a vy se postaráte o technickou část. Jedná se o práci minimálně na tři měsíce, prosím také o zaslání portfoli...
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í.
Potřebuji naprogramovat cca 30 příkladů v editoru pod Excelem /Visual Basic/. Většina příkladů je jednoduchá, postupně se obtížnost zvyšuje. Je důležité si před programováním přečíst kapitolu "Pokyny ke tvorbě programů" a všechny pokyny dodržet. Pro ukázku posílám i již naprogramované příklady /BasicCv_A & BasicCv_B/, aby bylo jasné, jakým stylem je potřeba postupovat. Cena 20 EUR.
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
...the ticketing system OTRS and other Perl applications including testing and bug fixing. Moreover you are participating in data base development in SQL. As a developer you actively participate in an agile development process („Scrum“). Your profile You have a degree in computer science, business or media informatics or comparable areas with several years of experience in Perl development. Good knowledge in database programming (MySQL) are part of your skill set as well as a basic knowledge of Linux. Ideally you are familiar with the ticketing system OTRS. Moreover, you are a team player with excellent analytic and conceptual skills in combination with good language skills in English and ideally German. Wh...
...našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dokumentace, která popisuje ...
Pozdrav druze, meni trebaju uradjena 3 kratka Visual Basic zadatka za ispit, znaci samo code nikakav dizajn. Evo saljem ih na uvid. Poz.
Pozdrav druze, meni trebaju uradjena 3 kratka Visual Basic zadatka za ispit, znaci samo code nikakav dizajn. Evo saljem ih na uvid. Poz.
Pozdrav druze, meni trebaju 3 kratka zadatka uradjena u Visual Basicu za fax, znaci samo code nikakav dizajn. Evo saljem ih na uvid. Poz :)
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
I'm in need of a skilled individual who is proficient in both PHP and Google Gemini. The primary task is to integrate this platform with my PHP website. Key requirements include: - Basic data syncing: The main goal is to ensure that the PHP website and Google Gemini can share important data seamlessly. This includes basic data such as user information, clicks, and impressions. The ideal candidate must have: - Demonstrated expertise in PHP and Google Gemini. - Prior experience in integrating Google Gemini with websites. - Strong communication skills to understand my requirements and provide updates on the integration process.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I'm seeking a professional who can help me with pre-employment vetting specifically focusing on employment checks. Key Points: - I need a comprehensive employment verification report for potential employees. - The report should include basic details such as dates of employment and job titles. Ideal Skills and Experience: - Proven experience and expertise in conducting employment checks. - Attention to detail for ensuring accuracy in the reports. - Excellent communication skills to facilitate smooth interactions with past employers. - Strong understanding of employment laws and regulations.
I am looking for an experienced developer to create a user-fri...clothing, and the AI will combine these to create a natural, realistic image of the person in the clothing. Key Features: - User-friendly image uploading: The primary focus of the first version of the web app is to allow easy image upload for users. - Basic options to select the type of clothing fit: Users should be able to provide basic inputs related to the clothing, such as size or fit, before the AI generates the final image. Ideal Skills: - Proficiency in AI image processing and manipulation - Web development experience, particularly in user-friendly interfaces - Understanding of e-commerce and virtual try-on technology is a plus The final image should be a natural looking photo o...
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as ...
I am in need of a skilled SPSS expert to assist me with a small project. I require someone who is proficient in statistical analysis and interpretation using SPSS, particularly for basic descriptive statistics. Key Responsibilities: - Conducting basic descriptive statistical analysis on the data provided - Interpreting the results in a clear and concise manner - Presenting the findings primarily through graphs and charts You must have: - Proficiency in using SPSS for statistical analysis - Strong background in basic descriptive statistics - Capability to interpret data effectively - Ability to present results clearly through graphs and charts Your assistance in this project will greatly help me in understanding the da...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
...expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logisti...
I am in need of a skilled SPSS expert to assist me with a small project. I require someone who is proficient in statistical analysis and interpretation using SPSS, particularly for basic descriptive statistics. Key Responsibilities: - Conducting basic descriptive statistical analysis on the data provided - Interpreting the results in a clear and concise manner - Presenting the findings primarily through graphs and charts You must have: - Proficiency in using SPSS for statistical analysis - Strong background in basic descriptive statistics - Capability to interpret data effectively - Ability to present results clearly through graphs and charts Your assistance in this project will greatly help me in understanding the da...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
I'm in need of a professional who can update config which utilized ESRI's cloud builder tool on Azure. Specifically, the role requires assisting in configuring the ArcWeb server, transforming a site created in IIS to be public-facing. This includes making the site accessible from the internet with a basic level of security, such as HTTPS. Key Responsibilities: - Configure ESRI Cloud Builder tool on Azure - Make existing IIS site on ArcWeb server public-facing - Implement basic security measures (e.g., HTTPS) Required Skills and Experience: - Proficiency in ESRI/ArcGIS platform - Experience with ESRI's cloud builder tool - Familiarity with Azure cloud services - Strong knowledge of web server configurations, particularly IIS - Prio...
We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword...
...quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken ...
We need the following features: 1. Login/ registration 2. Stripe integration 3. Place and order 4. After placing order, user can upload files to start project 5. Admin receives files from order. 6. Email notification about order progress to use...project 5. Admin receives files from order. 6. Email notification about order progress to user and admin 7. Admin uploads final report pdf to order and marks complete 8. User can download report from order page. End of flow. More details: What specific features would you like to include in the SaaS dashboard? User management, Payment processing, Upload and download files How do you envision the user interface of the SaaS dashboard? Modern and intuitive design What level of user access control do you need? Basic (e.g., admin and...
I am seeking a proficient course builder to design a fundamental, text and image-based online course. This will be self-hosted on my website. Key requi...image-based online course. This will be self-hosted on my website. Key requirements: - Develop an engaging and informative course using text and images as main tools of delivery - Have extensive experience and expertise in creating online courses - Experience in self-hosting online courses is a plus - Provide innovative ideas to make the course more attractive and compelling The perfect candidate will have a strong understanding of how to create effective, engaging text-and-image-based educational content and possess excellent skills in course design. Previous experience in building and hosting courses on a...
I'm in need of a creative and proficient video editor who is adept at basic editing techniques for real estate video editing. This includes trimming, cutting, and incorporating various types of transitions such as fade in/out, cutaway shots, and cross dissolves into the final product. The edited video should be between 1-5 minutes in duration. Ideal applicant should demonstrate: - Proficiency in basic video editing techniques - Ability to creatively employ fade in/out, cutaway shots, and cross-dissolve transitions - Time management skills to deliver the final product within the set deadlines Experience in these aspects will be a major plus. Please include samples of your work, preferably those incorporating aforementioned tr...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detai...
Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.
...Us' and 'Blog'. - Audience Engagement: The website should be engaging to travelers. This could be through interactive design elements, engaging visuals or other creative features. - Basic Documentation: Create some documentation to help me understand the technical aspects of the website. Ideal skills and experience: - Proficiency in web development: A good understanding of web development technologies, languages, and frameworks is essential. - UX/UI Design: Experience in designing user-friendly interfaces and engaging user experiences. - Travel and Tourism Industry Knowledge: While not mandatory, a background in the travel and tourism industry would be beneficial. - Documentation: Ability to provide clear and concise documentation to help me u...
We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experien...
I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new
Buscamos una persona española que ayude a limpiar los datos de un CRM nuevo, subir datos de excel, validarlos o buscar nuevos con herramientas de Marketing.
...resulting photos via API - Everyone will see the photos they have permission to. He will be able to filter and sort them on a basic basis - Photographer rating system System users: - Broker ◦ Establishes a request for a photo shoot ◦ Selects the date and service ◦ Sees his orders including the resulting photos ◦ Evaluates - Photographer ◦ Sees assigned jobs with a schedule (calendar) of jobs ◦ Confirms the job ◦ Inserts the resulting photos ◦ Sees your historical orders as well Here is the necessary screens: ### 1. Login Screen - **Purpose:** Allow users (brokers and photographers) to log in. - **Elements:** - Email/Username input - Password input - Login button - Forgot Password lin...
We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing sour...
I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.
As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation
I'm in need of a 3D motion title teaser for an entertainment project. This teaser should be set in a realistic forest environment and convey a mysterious and dark atmosphere. Key Points: - Entertainment Purpose: The main goal of this project is to create a teaser that captivates and engages the audience, setting an intriguing tone for the content to come. - Realistic Style: The forest setup should be modeled in a realistic style to enhance the immersion and believability of the teaser. - Mysterious and Dark Atmosphere: The teaser should convey an overall eerie and enigmatic mood, setting a mysterious tone that hints at the entertainment content without revealing too much. Ideal Skills and Experience: - 3D Motion Graphics: Proficiency in creating engaging...
I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the...
I'm seeking a skilled professional to conduct basic video editing such as cuts and transitions. The main objective is to create promotional content with an engaging narrative. Furthermore, infographics will be integrated into the video to emphasize key points. Ideal candidates for this project will have proficiency in video editing and infographic design. Your portfolio demonstrating projects with similar requirements would be highly appreciated.
I'm seeking a proactive and detail-oriented freelancer for a role that demands consistent applications to various job postings on behalf of our company. Key Res...postings with attention to details - Tailoring each application to include relevant work experience, educational background, skills, and certifications Requirements: - Proficiency in navigating LinkedIn, Indeed, and Glassdoor - Strong attention to detail - Excellent written communication skills - Ability to work independently and proactively - should have basic knowledge of DevOps Expectations: - Submitting more than 20 applications per day This role is crucial in our recruitment strategy. Your ability to accurately represent our company and the skills and experience of our potential hires will be...
