2500 excel vba examples rarprá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í.

datae

datae

mise en forme

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

Napraviti Excel VBA program

...vytvořená na míru 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 dok...

Dobrý den, hledám animátora, který by byl schopný vytvořit buď ze stávajích 3D modelů ve formátech .obj, .dae, vytvořit 3D model ve formátu .js a do modelu dopracovat animaci pro změnu velikosti modelu a popisem pro změnu vrcholů pro editor Troufnete si na to?

Dobrý den, hledám animátora, který by byl schopný vytvořit buď ze stávajích 3D modelů ve formátech .obj, .dae, vytvořit 3D model ve formátu .js a do modelu dopracovat animaci pro změnu velikosti modelu a popisem pro změnu vrcholů pro editor Troufnete si na to?

Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.

I'm looking for a professional mobile app developer who can create a robust e-commerce application similar to Fashion Nova. The app is intended to be developed for both iOS and Android platforms, with an additional web app component. Key Features: - User Registration and Login - Product Browsing and Search - Shopping Cart and Checkout - Vendor Page - Order Tracking - Admi...- Order Tracking - Admin Panel - Dynamic Backend Analytics - Personalization - In-App Chat for Customer Service I am not looking for specific design or branding requirements at this stage. I'm particularly interested in your experience with e-commerce app development, as well as any unique features or functionalities you can suggest to enhance the user experience. Please provide any relevant examples ...

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

I'm looking to set up an data center, and I need your expertise for this project. Key Requirements: - Establishing an data center: You need to handle the complete setup and implementation of the data center. Ideal...center: You need to handle the complete setup and implementation of the data center. Ideal Skills and Experience: - Experience in designing and setting up data centers, particularly . - Understanding of the most appropriate technologies and approaches for a reliable and scalable off-site data center. - Knowledge of industry best practices for data center setup and management. Please provide examples of similar projects you've completed. Your understanding of the requirements and your proposed approach to setting up the data center will be crucial in m...

I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the migration proc...

I am looking for a video editor to edit our existing UGC footage into high-converting direct response video ads, for use across Facebook, Instagram and Tik Tok. I am looking for you to provide creative strategy / script ideation with customer research + direct response video editing (and sometimes using AI voiceovers). Ideally we set up a process...ideation with customer research + direct response video editing (and sometimes using AI voiceovers). Ideally we set up a process of 3-4 new videos per week. In summary, you need to: - Edit existing footage to create high converting video ads - Do audience research and craft scripts for creative video concepts tailored to our customers - Create new video scripts/ideas weekly Please provide some examples of the most recent videos you hav...

Answer the attached question correctly, and briefly explain. I'd like to learn the basic concepts and principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Key requirements: - Proficiency in networking, particularly subnetting Answer the attached questions, the provide table of ...like to learn the basic concepts and principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Key requirements: - Proficiency in networking, particularly subnetting Answer the attached questions, the provide table of the subnets correct answer with brief explanation wins Accepted file fo...

I'm seeking an experienced graphic designer for my upcoming Business and Self-improvement non-fiction book. Your design approach must be abstract and conceptual. I value quality, attention to detail, and creativity. Key requirements: - Proven experience in book cover design - Proficiency in design software - Ability to design abstract and conceptual book covers Get i...upcoming Business and Self-improvement non-fiction book. Your design approach must be abstract and conceptual. I value quality, attention to detail, and creativity. Key requirements: - Proven experience in book cover design - Proficiency in design software - Ability to design abstract and conceptual book covers Get in touch if you believe you're the right fit for this job. Please include relevant examples...

I need to transcribe data from physical documents that are in image format. Before entering the data, some basic editing is required, e.g. cropping, resizing. Key requirements: - Data Entry: Transcribing information accurately from images to a digital format. - Image Editing: Basic edi...cropping and resizing. - Attention to Detail: Ensuring the most precise and accurate transcription of data. - Time Management: Delivering entries in a timely manner. Ideal Freelancer: - Experience with data entry, especially involving images. - Proficiency with basic image editing tools. - Attention to detail and accuracy. - Ability to manage time effectively and meet deadlines. Please provide examples of prior work related to this project and an outline of your process to ensure high quality d...

I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. T...were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a must fo...

I'm looking for an experienced WordPress developer to create an interactive and complex website for me using Advanced Custom Fields (ACF). Key Project Details: - The website will feature less than 10 pages, so it should be relatively straightforward to navigate. - The main functionalities I want to include aren't explicitly listed, but I'd like the w...Advanced Custom Fields is a must. - Proven experience in designing and developing interactive websites. - Strong understanding of user experience and good design principles. - Excellent communication skills and a proactive approach to problem-solving. I'm open to suggestions and recommendations for additional features that you think would enhance the site's usability and engagement. Please include examples...

I am seeking a skilled freelancer with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK...

I'm looking for a talented WordPress developer to create a sophisticated and elegant website for my cake decoration and pastry business. The target audience for this website is primarily bridal and event planners, B2B and B2C so the design should cater to their tastes and preferences. Key Functionaliti...responsive and user-friendly website interfaces. - Knowledge of e-commerce tools and payment gateways for a smooth online shopping experience. - Familiarity with location integration and third-party app integration (specifically WhatsApp Business API) is a plus. If you have a keen eye for elegant design and a knack for creating user-friendly interfaces, I would love to hear from you. Please provide examples of your previous work and a brief overview of how you would approac...

...seeking a Python developer who can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of automation proc...

I need assistance with entering inventory data into Quickbooks Desktop from an Excel file. - I'm looking for a professional who has experience with Quickbooks Desktop. - The job involves bulk data entry, focusing specifically on inventory. - You will be provided with an Excel file containing the inventory data. - Attention to detail is crucial to ensure accurate and efficient data entry. Ideal skills: - Proficiency with Quickbooks Desktop - Experience with data entry, particularly inventory - Attention to detail and accuracy in data entry - Familiarity with Excel files and their import into Quickbooks

I'm working on a Zend Framework project and looking for a skilled developer to integrate Twilio for SMS/WhatsApp notifications and MercadoPago for payment processing. The key project requirements include: - **SMS/WhatsApp Notifications:** I want to automatically trigger SMS notifications when specific events occur in the system. These events include the completion of...in web applications. - A solid understanding of automating system events and processes based on specific triggers. - A keen eye for security, ensuring that all payment transactions and notifications are secure and compliant with best practices. If you're confident in your Zend Framework skills and can demonstrate experience with similar integrations, I'd love to hear from you. Please provide examples ...

I require a skilled freelancer to generate five SEO-centric blog posts to bolster the online presence of my Direct-to-Consumer wooden watch and accessory brand. Specifics include: - Each blog post should be roughly 2000-2500 words long - Keywords will be shared along with potential theme/titles - Links/backlinks are encouraged for increasing traction - The first two blog posts to be delivered within two weeks This project necessitates a strong flair for writing and outstanding SEO skills, particularly in creating engaging content and effective backlinking. Experience in writing for similar DTC brands or in the accessory niche would be a major advantage.

I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing...and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue"...

I aim to transform my existing corporate website, , into a more dynamic, interactive platform, similar to https://cylastee.com. The website should guarantee a seamless load experience with no lag. Key requirements include: - Integration of Interactive elements:...feedback forms. - To include all pages existing in the current website A successful candidate for this project would have substantial experience in web redesign, a demonstrated ability to integrate interactive elements such as sliding banners, and experience building functional forms for customer feedback. A strong understanding of UX/UI and seamless load performance is essential. Please include examples of similar projects in your bid. I am looking to work with someone long term in managing similar projects.

...Bible topics for YouTube >>>> Provide examples of previous Quizes. No examples No work. <<<<< Key Project Details: - **Frequency**: Weekly quizzes creation. - **Question Types**: Incorporate multiple choice questions and true/false questions. - **Deliverables**: The method of delivery is flexible and can be discussed. Ideal Candidate: - Proficiency in Christian Bible and ability to create engaging and accurate quiz questions. - Demonstrable experience in quiz creation is a must. - High attention to detail and ability to meet weekly deadlines. - Strong communication skills to ensure alignment with the provided topics. I will provide weekly/monthly topics. Looking for a long-term collaboration with the right candidate. Must have done quize...

I'm in need of an experienced SEO writer with a strong understanding of the family travel market. Your main focus will be on optimizing 1-5 pages of my travel website. The chosen individual should have a genuine interest and understanding in the topics of vacation destinations and travel tips. Ideally, you should be able to: - Develop a ...and travel tips. Ideally, you should be able to: - Develop a strategy to improve the visibility of my content on search engines specifically for family travelers. - Effectively incorporate the prescribed keywords i.e 'Vacation Destinations, Travel Tips' into content whilst maintaining its readability. Prior experience in the family travel sector will be highly regarded. Please share relevant examples of your previous work and su...

I'm looking for a talented digital artist to create a realistic digital painting for me. The primary subject of the image should be capturing a moment, an event or a scene that you can bring to...for authenticity and lifelikeness in its portrayal of the subject. - Capturing a moment: The image should tell a story or encapsulate a particular instance or event. - Creativity: The ability to interpret and represent this moment in a compelling, engaging way. Please note that there are no specific items or themes to include, so you would have creative freedom in this regard. A portfolio or examples of previous work in a similar style will be highly valued in your bid. You should also be able to demonstrate a high level of proficiency in digital painting. Looking forward to seeing ...

I'm looking for proficient freelancers who can effectively input both text and numerical data into Excel from physical documents. The task does not require any formulas or calculations, but attention to detail is crucial to ensure the accuracy of data. Key tasks include: - Manual entry of text and numbers from physical documents into Excel - Ensuring accurate data entry and quality checks Ideal freelancers should: - Have experience in data entry tasks, particularly with Excel - Be detail-oriented to ensure accuracy - Have strong organizational and time management skills.

I require the expertise of a part-time remote accountant who can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely...can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely and accurate manner. - Financial analysis: Monitoring, identifying and interpreting financial trends. The ideal candidate should have a good command of QuickBooks and Excel spreadsheets. Familiarity with these tools is crucial for performing tasks efficiently and a...

I'm looking for an expert in Excel who can help me with applying conditional formatting and creating complex formulas that involve multiple conditions. Please watch this video for what i need Key Requirements: - Applying Conditional Formatting: The Excel file will require conditional formatting to visually represent data based on specific criteria. - Creating Complex Formulas: The project includes creating formulas that are not limited to basic arithmetic, and instead, involve multiple conditions. Ideal Skills and Experience: - Proven expertise in Excel: The ideal candidate should have a strong background in working with Excel and creating complex formulas. - Understanding of Conditional

I need an Excel expert to overhaul my current worksheet. Key needs include formula adjustments, data validation updates, and creating an interactive dashboard. The dashboard should boast the ability for graphical data representation, specifically bar charts, and customizable filters to view data from multiple perspectives. The right candidate will have extensive experience in Excel, knowledge of advanced formulas, data validation techniques and be proficient in creating interactive dashboards.

I'm seeking a professional who can help me to enhance the speed of my AI image generation process. Key Requirements: - Current image generation duration is over 5 seconds. I'm looking to significantly reduce this time while maintaining the image quality. - The targeted image resolution is 'Standard Definition (SD)', so the optimizations and improvements should be focu...Proficiency with AI image generation tools and techniques. - Strong understanding of the trade-offs between speed, quality, and cost in AI image generation. - Excellent problem-solving and analytical skills. If you have experience in AI image generation and optimization, especially in improving speed without compromising quality, I'd love to hear from you. Please include any relevant experience o...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

I'm looking for a talented web designer & developer with experience in both website redesign and web development. Requirements: - Redesign the existing website with a modern, tech-focused aesthetic, following examples. We can do templates ourselves, so that's not the goal, we need more - Ensure the new design aligns with our specific color scheme and branding guidelines Ideal Skills: - Web design - UI/UX design - Graphic design - Branding and style guide implementation The primary goal of this website is to provide information about our new tech business. It's essential that the final product is both visually appealing and user-friendly. The ability to work within existing branding guidelines and bring a fresh, modern approach is key.

I am looking for an efficient data entry expert to assist me in entering textual, numerical, and image-based data. The project involves a medium amount of data that needs to be meticulously transferred to an Excel file. Your responsibility will include, but is not limited to: - Inputting textual data while maintaining accuracy. - Adding numerical data precisely. - Uploading images correctly. An ideal freelancer for this job would have a keen eye for detail, substantial experience with Excel, and the ability to handle different types of data. Prior knowledge in image uploading and handling is a plus. You should also pride yourself on accuracy and efficiency. In your proposal, please share a brief summary of your experience, including one to two data entry projects you hav...

I'm looking for a skilled software developer with a focus on mobile app development. Key Requirements: - Experience in creating mobile apps, particularly in the finance or lending sector would be a significant plus. - Expertise in building user-friendly interfaces that are ...means there are a few core functionalities that are essential: - Loan approval and disbursement: Users should be able to apply for loans via the app, and once approved, the loan should be disbursed. - Payment tracking and reminders: The app should facilitate tracking and managing payments, sending reminders to users about due payments, and providing a seamless payment process. Please provide examples of your past work, especially if you've worked on similar projects, and highlight your relevant sk...

Automated report using dashboard in Excel The report interface should be similar look to the pic attached. The Excel file for data source should be able to be used for Power BI. Two dashboards: 1- for multiple project management status reporting 2- for ad-hoc task management The data source is in an Excel sheet with a manual entry

I'm looking for a skilled professional who can create a 1-minute live video on our website. This live video will be streamed using the front camera and will serve as a product demonstration. The ideal candidate for this project should have experience in: - Video production and live streaming - Web development (to integrate the video on our site) - Understanding of live ...be engaging and visually appealing - Ability to optimize the video for web streaming - Ensure the video is compatible and functional across different web browsers - Deliver a product demonstration that is clear and concise - Implement interactive elements to enhance user experience If you have the right skills and experience for this project, please reach out with your quote and any relevant examples of your...

I'm seeking a skilled professional to enter 100-500 text entries for me. Key Responsibilities: - Entry of primarily textual data - Handling 100-500 entries Ideal Skills: - Proficient with Microsoft Excel - Excellent attention to detail - Strong typing and data entry skills. Experience in similar projects will be highly appreciated. I look forward to your bids for an efficient data entry task.

Necesito combinar un archivo excel que lo extraigo de un programa extranjero (1r archivo), y que debe añadir de otro archivo (plantilla proveedores) un dato para obtener una excel final (plantilla). El programa debe permitir insertar el archivo inicial, que consulte otro excel para añadir su CIF (el software es extranjero i no lo incluye) i transformarlo en el final (plantilla). Lo suyo sería, inserte archivo inicial, para extraer el archivo final

I'm in need of an experienced SEO writer with a strong understanding of the family travel market. Your main focus will be on optimizing 1-5 pages of my travel website. The chosen individual should have a genuine interest and understanding in the topics of vacation destinations and travel tips. Ideally, you should be able to: - Develop ...and travel tips. Ideally, you should be able to: - Develop a strategy to improve the visibility of my content on search engines specifically for family travelers. - Effectively incorporate the prescribed keywords i.e 'Vacation Destinations, Travel Tips' into content whilst maintaining its readability. Prior experience in the family travel sector will be highly regarded. Please share relevant examples of your previous work and su...

I need a seasoned WordPress developer who can optimize existing numberplate builder plugin on our site. The project's focal point is on functionality and optimization to enhance user interface and experience. Key tasks involve: - Developing custom design options and a dynamic preview feature that will allow clients to envision their designs before ...font size. Essential skills for the job include proficiency in WordPress, excellent coding capability and experience in plugin creation and optimization. A proven knack for refining user interface design would be advantageous. The ideal freelancer should hold a keen eye for detail to ensure quality, accuracy and a thorough understanding of the project's objectives. Please submit your bids with examples of similar projects ...