Excel macro examplesprá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

Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl

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

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?

I'm looking for an expert who can generate a Vcarve program for us. - Machine: CNC router - Material: Wood The project requires a detailed Vcarve program to carve an abstract pattern on wood using our CNC router. Prior experience in CNC programming especially with Vcarve is mandatory. - Skills: 1. Vcarve programming 2. CNC router operation 3. Experie...who can generate a Vcarve program for us. - Machine: CNC router - Material: Wood The project requires a detailed Vcarve program to carve an abstract pattern on wood using our CNC router. Prior experience in CNC programming especially with Vcarve is mandatory. - Skills: 1. Vcarve programming 2. CNC router operation 3. Experience with abstract wood carving designs Please share relevant examples of previous wo...

I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.

I'm seeking a skilled web designer and developer experienced with WordPress and Elementor to create a website for my construction company. - full web design and build on CMS tool like Wordpress, drupal - goal of website is to convert leads t...developer experienced with WordPress and Elementor to create a website for my construction company. - full web design and build on CMS tool like Wordpress, drupal - goal of website is to convert leads to sales calls - need someone with good graphic design experience so that the site has a modern look and isn't too cookie cutter/cheap looking - need to be build for web analytics - below are some examples of sites id like to mimic in a way Reference websites:

I'm looking for a highly talented graphic designer to create an ad that will help us increase our sales. The ad will be targeting professionals, so it must emanate sophistication, trust, and efficiency. The skills and experience required for this job are: - Proven experience in creating compelling graphic ads that effectively drive sales. Please provide previous examples of your work. - Understanding of the professional market, with the ability to create ads that appeal to this demographic. - Strong communication skills, as you'll be working with me closely to accomplish the goal. Your main objective is to create an ad that's not just pleasing to the eye, but achieves our main purpose - increasing sales. I can't wait to see what you come up with!

I'm looking for a skilled developer to create a Bitcoin HD wallet with specific features for the web platform. This wallet should also enable the tracking of incoming deposits and ensure secure user authentication. Key Features: - Generate new Bitcoin addresses: The wallet must be able to create and manage a sequence of addresses derived from a single...Ideal Skills: - Proficient in Bitcoin and Blockchain technology - Strong experience in web development and security - Familiarity with HD wallet implementation - Knowledge in real-time transaction monitoring If you have a proven track record in developing secure, efficient, and user-friendly web-based Bitcoin wallets, I'd like to hear from you. Please share your relevant experience and provide examples of similar projec...

I'm on the hunt for a creative and talented graphic designer to bring my garden care business...an essential requirement. You should be comfortable working with sleek lines. - Full Name & Short Logo: Both are required in the design. I am fully open to having these elements overlapping, side by side, or one above the other. The short name is ‘SCGC’. Long name ‘Suncoast Garden Care’ Essential Skills: - Graphic Design - Conceptualizing - Experience in Modern Logo Design Your portfolio examples of previous work will be a deciding factor. Preference will be given to those who have samples of sleek, modern designs. Be ready to play around with different elements and symbols to create a design that encapsulates our brand. Let's create a logo that...

...the topics given here in the attachment. It can be discussed in Chat. You should have a good, professional grade Mic. An electronic Pen is desirable. Topics for which you need to create the videos are Narration , voice change, parts of speech, sequence of tense, gerund, creating wh questions etc. Each topic should be minimum of 60 minutes length. You first need to explain the main concept, use examples and use some questions and then its answers with explanation.. also create 10 MCQ questions on each topic. Instructions to be in ENGLISH only. Use Screen recording Software and/or Whiteboard. VOICE MUST BE LOUD & CLEAR. NO BACKGROUND NOISE/SHAKY VIDEOS NOT ALLOWED. See my attached sample video. You need to give me the full copyright of all the videos. Lowest Bidder will win thi...

I am searching for a marketing expert to spearhead a campaign targeted specifically at businesses for my LED lights. The primary goal of this task is to increase sales. With a budget of less than $100, creativity and efficiency will be key. Ideal Candidate Skills: - Proven experience in ...record in optimizing marketing campaigns to boost sales. - Ability to be resourceful and innovative on a lean budget. Your responsibilities will include: - Creating and implementing a compelling marketing strategy aimed at businesses. - Utilizing efficient marketing methods to sustain the budget. - Regular reporting on campaign performance, sales increase, and cost-effectiveness. Please provide examples of your previous work, particularly any similar B2B marketing campaigns you've succes...

I'm looking for a skilled PowerPoint designer who can create a visually appealing presentation based on a PDF paper summary for a topic (Why people use VPN). The main goal of this project is to present key findings, provide visual summaries, and enhance understanding through a minimalist and visual approach. - The presentation should...minimalist style with a strong emphasis on visual content - Design should be focused on delivering key findings and summaries in a clear and concise manner To take on this project successfully, you should have a strong background and experience in: - PowerPoint presentation design - Infographics and chart creation - Understanding of visual communication and information design Please include examples of your previous work in your proposal to...

...package_statuses is equal to the status drop down list in the National Skills Competition module. - add page number for the existing report Key Areas: - Sales and Invoicing - Inventory Management - CRM One must possess robust experience in these areas and be prepared to handle multiple tasks efficiently. I'd appreciate if applicants could showcase their proficiency in Odoo development, preferably through examples of past work. Any relevant certifications or endorsements are a considerable plus. Ideal Skills: - Experience in Odoo development - Ability to handle multi-faceted tasks - Proficiency in Sales, Inventory Management, and CRM modules of Odoo. If you believe you fulfill these criteria, I'd love to hear from you....

I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.

I'm in need of a talented 3D artist who can create a high level of detail 3D rendering of a 350 sq meter supermarket. Key Requirements: - The 3D rendering should be highly detailed, including specific brands or types of products in certain sections of the supermarket. - Before...sections of the supermarket. - Before starting the 3D designs, a 2D layout must be planned but it should not be in details. Ideal skills and experience: - Proficiency in 3D modeling and rendering - Proven experience in creating detailed and realistic 3D environments - Ability to incorporate specific brands and products into the 3D design - Strong attention to detail and accuracy Please provide examples of your previous work in a similar field. Your portfolio will be a key factor in our decision-...

I need help finding and organizing different styles of video editing and "sounds" to use in the background of edited videos. 1,500 examples Thanks!

Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria

I have a WordPress website where I've implemented a plugin-based booking system. However, there seems to be an issue with confirming bookings. I need a skilled developer to help me identify the problem and fix it. Ideal skills and experience for the job: - Strong understanding of WordPress development - Proficient in plugin-based booking system - Experience...implemented a plugin-based booking system. However, there seems to be an issue with confirming bookings. I need a skilled developer to help me identify the problem and fix it. Ideal skills and experience for the job: - Strong understanding of WordPress development - Proficient in plugin-based booking system - Experience in troubleshooting and fixing technical issues Please include past projects or examples of similar wo...

I'm looking for a skilled freelancer to connect my Shopify account to Instagram effectively. The primary functionalities I need include: - Syncing my entire product catalog - Enabling the tagging of products in posts - Creating shoppable posts on Instagram Furthermore: - I have yet to set up a Facebook Business Page for my Shopify store, req...ideal candidate for this job should be proficient in both Shopify and Instagram interfaces, has past experience in e-commerce and social media integration, and knowledgeable in creating Facebook Business Pages. Your job doesn't stop at mere connection among apps but establishing a smooth-flowing e-commerce operation between my Shopify store and Instagram. It's a significant plus if you can provide examples of similar projects...

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...

The objective of this project is to develop a modern, user-friendly website for our home services company, offering a comprehensive range of plumbing, heating, cooling, and other home services. The website will serve as a digital storefront and informational hub, enabling customers to easily browse and under...customers to easily reach out to Domino Home Services for inquiries or support. We'd prefer to use Wordpress but if you think that another platform is better, we can consider that. You'll need to provide: - the design - the content: we'll provide you with all the information you would need to create the pages. Please start your bid with "I'll be a great fit for this project because". Provide examples of websites you have created that would give...

I'm in search of a creative freelancer to design a modern logo for my residential plumbing service company called "Bayside Plumbing" I ser...Focus the logo around the essence of plumbing services - Originality and creativity is highly valued Ideal Skills and Experience: - A professional level understanding branding and logo designs - Experience in creating logos for home service companies, preferably in the plumbing industry - Killer portfolio showcasing past works Please illustrate your capacity by including in your proposal, examples of past works that resonate most with what I need for this project. Potential candidates will be chosen based on their creativity, originality, and experience. Remember, attention to detail is crucial. Looking forward to your vibran...

I need an e-commerce website built on Shopify with a budget ranging from $500 - $1000. The website should target young adults aged 18-34, and will be selling a variety of products, primarily in the categories of Clothing and Accessories, and Electronics and ...experience for this job: - Proficiency in Shopify development - Understanding of e-commerce and online consumer behavior, particularly for young adults - UI/UX design skills for an engaging e-commerce experience - Knowledge of product categorization and listing optimization - Prior experience with payment gateway integration - Ability to optimize the website for mobile devices Please provide examples of similar e-commerce websites you have built on Shopify, and a clear breakdown of your proposed approach and timeline for thi...

I am looking for an experienced graphic designer to create a minimalistic logo for my company, incorporating our full name. The design should be simple, clean, and use a color scheme that majorly features blue and orange hues. Key requirements: - Proficiency in minimalistic logo design - Ability to include full company name in the logo - Exp...scheme that majorly features blue and orange hues. Key requirements: - Proficiency in minimalistic logo design - Ability to include full company name in the logo - Expertise in working with blue and orange colors - Portfolio showcasing similar projects The ideal candidate must understand the essence of minimalistic design while effectively bringing in company branding. Your bid should include examples of your previous work relevant to thi...

I am looking for an advanced AI expert who is proficient in Python to help me understand and manipulate a developed Python package on a tutoring basis. The link of the package is: I am interested in the cylinder problem here: Key Responsibilities: The tutor should help me to make changes in the code, track the flow of the data, know the dimensions of the data, debug errors that I may encounter, and how to create more figures as well. Level of Expertise: Advanced. It's important that the tutor is proficient in AI and Python, and can guide me through the learning process at an advanced level.

I'm seeking expertise to develop an AI solution addressing specific communication challenges in my operations. This advanced technology will aid in requesting more specific information for document retrieval, task completion, and progress updates that are currently barriers. Key Features and Responsibilities: - Construct an AI system t...progress report. - Should work effectively with email platforms as the primary communication tool. Ideal Experience: - Proven experience in AI and machine learning technology - Familiarity with corporate communication systems - Experience in integrating AI with Email services. This project aims at enhancing efficiency and productivity through clear and effective communication. Please provide examples of similar past projects while submitting...

I am looking for an experienced Android developer to help with a couple of key issues in my app. The primary focus should be on UI improvements. Key Tasks: token refresh functionality ignore battery optimize permission run at startups functionality UI change 2 new api's refactor code for easier maintenance currently displayes persistent notification dont want it...persistent notification dont want it Other requirements: - The app's token refresh mechanism must be revised and optimized - You should be able to ignore battery optimization permission I would ideally like a freelancer who is experienced with Java, Android Studio and UI/UX principles. Experience with token refresh mechanisms and battery optimization is also highly desirable. Please provide examples of pre...

I need a logo design for my company. The name of my company " Below Ground Bliss " should be the central focus of the logo. I want the style to be fun and playful, with a bright and colorful color scheme. It's important that the design is engaging and reflects the vibrant nature of our business. The brand "Below Ground Bliss" ...the ruggedness and roughness of basements with soft, playfullness of a new living/fun space. Ideal Skills and Experience: - Proven experience in creating fun and playful logo designs - Strong understanding of color theory, particularly in creating bright and colorful palettes - Ability to balance simplicity with creativity to ensure the logo is both engaging and professional. - A portfolio or examples of previous work in the sam...

Looking for a seasoned SEO expert who can effectively optimize the on-page SEO for my built website. In the application, kindly include: • Examples of your past work, particularly highlighting website projects built with you’ve worked on. Ideal skills and experience: - Solid understanding of and SEO techniques - Extensive background in on-page SEO best practices - Good eye for detail in identifying SEO opportunities within a website structure.

Our team is seeking a talented WordPress developer with specialization in theme customization, plugin development, and website maintenance to join us in bringing exciting websites to life....join us in bringing exciting websites to life. You will be involved in: - Collaborating on versatile and innovative projects - Utilizing your expertise to enhance our digital presence Ideal Skills: - Deep understanding of WordPress - Proficiency in Theme Customization - Experience in Plugin Development - Knowledge in Website Maintenance In your application, please include your past work. Examples demonstrating your proficiency in WordPress, theme customization, plugin development, and website maintenance are especially welcomed. We look forward to reviewing your contribution to this creativ...

I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.

I am looking for a skilled WordPress designer...am looking for a skilled WordPress designer to create an engaging blog website. As client details were not provided, the site should be versatile enough to work for a personal, business, or news blog. - Design: While no specific design elements were specified, the site should be modern, user-friendly, and visually compelling. - Freelancer Applications: Potential freelancers should include examples of past work, their experience, and detailed project proposals when applying. Ideal Skills and Experience: - Advanced proficiency in WordPress. - Previous experience designing blog websites. - The ability to incorporate versatile features to suit various types of blogs. - Strong communication skills to comprehend and execute my vision ef...

I need a React developer for immediate collaboration. The primary focus will be on frontend development, with special emphasis on creating a basic user interface, involving simple forms and buttons. Skills Required: - Proven experience in React, with a strong portfolio of work in frontend development. - Ability to work quickly and efficiently, meeting an ...development. - Ability to work quickly and efficiently, meeting an immediate project deadline. - Familiarity with integrating APIs into a project. The ideal candidate will have: - Strong communication skills as this is an immediate requirement. - Prior experience working on simple UI/UX design. - A keen eye for detail and the ability to follow design specifications accurately. Please include examples of your work with your...

I am seeking a skilled developer to create a comprehensive beauty appointment booking application that will run on both Android, iOS, and the web. As the app will be for beauty appointments,...space for beauty professionals to promote their services. Ideal Skills: - Experience in developing multi-platform applications. - Proficiency in user-friendly design. - Knowledge of secure payment gateway integration. - Previous experience with calendar-based applications. - Understanding of SMS integration for reminders. - Ability to implement advertising sections within an app. Please provide examples of previous work, particularly in the appointment booking realm. Your understanding of the beauty industry and its unique appointment booking requirements will be a plus. Let's discuss f...

I am looking for a skilled freelancer who has extensive experience in managing ads on both Google and Facebook. The main goal of this project is to increase the traffic to my website, focusing on professionals aged between 35-54 years. The ideal candidate for this job should have: - Proven experienc...on professionals aged between 35-54 years. The ideal candidate for this job should have: - Proven experience in managing Google and Facebook ad campaigns - A track record of achieving the goal of increased website traffic - A deep understanding of the professional demographic on these platforms - Excellent analytical skills to monitor and optimize the campaign's performance Please provide examples of your previous successful campaigns and details of how you plan to execut...

This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.

Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements with...

Are you passionate about digital marketing and ready to take your career to the next level? We're seeking talented individuals to join our dynamic team at zintcs, a leadin...communication and collaboration skills. A passion for staying up-to-date with the latest trends and developments in digital marketing. Benefits: Competitive salary and benefits package. Opportunity for career growth and advancement within a thriving agency. Collaborative and supportive work environment. Access to cutting-edge tools and resources to enhance your skills. To apply please: 1. Provide a few examples of your work 2. Let me know what you charge for a given level of quality Also, so I know that you’ve read and understood this job post, please start your response with how many years you&rsquo...