Excel vba macro optimizeprá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í.
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
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
...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...
...Work with RESTful APIs for server-side features and NMEA (National Marine Electronics Association) data integration. Develop and manage a comprehensive database to handle user profiles, chat histories, and app analytics. Collaborate with UI/UX designers to ensure the app is intuitive and engaging. Ensure the application is compliant with all relevant maritime safety and communication standards. Optimize performance for smooth functionality across various devices and operating systems. Establish a feedback loop with beta testers to iterate and refine app features. Required Skills and Qualifications: Proven experience in mobile application development with a portfolio of released applications on the Android and iOS markets. Strong proficiency in programming languages such as Swif...
I'm looking for a skilled freelancer who can help me with my Siemens NX post processor. The post processor needs to smoothly operate with Fanuc Oi-MC machine controller. Key Responsibilities: - Understand the 3D Milling operations and ensure the post processor supports them accurately - Modify and optimize the existing post processor to run seamlessly on the Fanuc Oi-MC Ideal Skills and Experience: - Prior experience in developing or modifying post processors for Siemens NX - Proficiency with Fanuc Oi-MC machine controller - Strong understanding of 3D Milling operations - Ability to deliver a robust, reliable and user-friendly post processor Please include your relevant experience in your application. It's a plus if you can provide samples of your prior work related to...
...a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - Expertise in Amazon SEO and PPC ads, with a specific focus on product listing optimization. - Experience with book listing, preferably in the coloring books category. - Proven track record in improving visibility and sales on Amazon with optimized product listings. Your responsibilities will include: - Optimizing the titles, descriptions, and other pertinent details in each coloring book listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to op...
...Responsibilities: - Develop a social media strategy to increase the artist's online presence and fan base - Create and curate captivating video content that aligns with the artist's brand - Schedule and post content across various platforms - Engage with the artist's audience and respond to comments and messages in a timely manner - Analyze performance metrics and make data-driven decisions to optimize content Ideal Candidate: - Extensive experience in social media management and marketing - Proven track record of creating and implementing successful social media campaigns - Proficiency in video content creation, with a keen eye for detail and storytelling - Strong understanding of social media analytics tools and ability to interpret data to improve performance -...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
We are seeking a highly skilled and dynamic Freelance PPC Campaign Manager to join our marketing team. If you have a passion for digital marketing and a proven track record in managing successful pay-per-click campaigns, we want you! Responsibilities: Develop, execute, and optimize PPC campaigns across multiple channels including Google AdWords, Bing, and social media platforms. Conduct keyword research and selection for pay-per-click campaigns and SEO projects. Analyze and interpret click-through rates, conversion data, and ROI to continually refine our PPC strategy. Monitor and report on campaign performance with actionable insights and recommendations for improvement. Collaborate with our marketing team to align PPC strategies with the company’s overall goals and objectiv...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...
I'm in need of a talented Shopify designer to develop a professional and visually appealing site for my digital product business. The main goal of the site is to facilitate the sale of digital products, so it's critical that the design is conducive to ecommerce. I want to make it easy for customers to navigate the site, find products of interest, and comp...encouraging them to make a purchase. - Social media integration: To help with brand building and reach, connecting the site seamlessly with social media platforms is essential. In your proposal, please include: - Previous experience with Shopify, ideally with an ecommerce focus. - Examples of ecommerce sites you've designed and developed. - Any specific ideas or strategies you would employ to optimize the UX for ...
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project req...
I am seeking a proficient techno-functional consultant to undertake the Tecnomatix Plant Simulation project for my manufacturing operations. The main objectives are: - Improve and optimize in-process production operations - Boost efficient resource utilization The consultant should focus on rectifying the lack of visibility in the production flow. To achieve this, core skills required will be proficiency in implementing Tecnomatix Plant Simulation software, strong knowledge of manufacturing processes, and experience in identifying and rectifying production bottlenecks. Ideal professionals should have: - Strong Tecnomatix skills - Experience in manufacturing process optimization - Expertise in resource planning and allocation - Troubleshooting skills to enhance visibility in pro...
2 excel files with VBA macro as per customer requirement
...boiler-plate responses will NOT BE CONSIDERED. Please complete and sign the NDA for consideration and title the file as follows: "Unii LLC - NDA - Freelancer - (YOUR COMPANY/FREELANCER NAME)". Please also respond with your hourly rate. ----------------------------------------------------------------------------------- I'm in need of a highly skilled developer well-versed in Swift and Kotlin to optimize the backend of my existing mobile apps. The project is simple. Here's what I need in detail: 1. Backend adjustments: You'll work on polishing a few features and functions of the mobile apps. Please see attached, and disregard Point 5 under Mobile App Requirements. Android is in Kotlin, and iOS is in Swift. 2. Admin Panel redesign: Use the designs of the ...
I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...
I'm seeking an experienced video editor to craft one-minute social media tailored videos from my raw footage. The videos will primarily be utilized across Instagram, YouTube, and Facebook. Key responsibilities: - Edit raw video footage into engaging one-minute videos - Optimize videos for Instagram, YouTube, and Facebook platforms Ideal Candidates: - Have proficiency in video editing software - Experienced in social media video optimization - Understand the dynamics of each platform to ensure videos are formatted correctly for all mediums. Final videos must be engaging, succinct, and tailored to the unique requirements of each platform.
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...
I need a skilled professional to help me creating email servers to send bulk emails and managing. - **Email Marketing**: I have been using the server for bulk mailing and email marketing. I need an expert who can optimize these operations, ensuring that the emails are being delivered effectively and not marked as spam. - **Troubleshooting and Support**: Although I did not select this as a specific task, I might need help with troubleshooting and support in the future. It would be great if the individual could provide this assistance as needed. The ideal candidate for this project is someone with extensive experience in managing email servers, particularly with SMTP, bulk mailing, and email marketing. A deep understanding of email deliverability and anti-spam measures is crucial...
I'm seeking an innovative and creative marketing expert, proficient in TikTok, to help generate sales for my online dropshipping store. The type of products I'll be selling is not yet decided, hence I need someone who can adapt to promoting varying items. Solid expertise in directing campaign strategies to both young adu...campaign strategies to both young adults and teenagers would be advantageous. Skills and Experience: - Deep understanding of TikTok marketing - Proven experience in driving online sales - Knowledge of different product promotion - Ability to target, engage and convert young audience - Flexibility in handling diverse product range Expectations: - Increase store traffic - Generate product sales - Optimize TikTok ads for success - Flexible approach ba...
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...
I am seeking an experienced developer to create a two-way SMS app that is compatible with iOS and web-based platforms. The app should enable users to: - Send and receive SMS messages - Manage contacts - View message history Moreover, I'd like the following features integrated: - Push notifications - Message...Manage contacts - View message history Moreover, I'd like the following features integrated: - Push notifications - Message search functionality - Support for attachments Proficiency in iOS and web development, experience with SMS-based applications, and understanding of push notifications, search functionality and attachment support are crucial for this project. Your insight and suggestions to optimize the user experience would be highly appreciated. similar ...
...compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of relational databases and experience in query optimization. Previous experience working with MLM databases and familiarity with their structures and terminology. Experience with Dolibarr ERP systems or similar ERP solutions. Ability to work independently and e...
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
...mobile applications, utilizing your expertise in React Native styling techniques and user-friendly animations. Responsibilities: - Collaborate with our design team to implement UI/UX designs into React Native components. - Develop and maintain reusable styling components to ensure consistency across the application. - Implement user-friendly animations to enhance the overall user experience. - Optimize application performance and ensure smooth animations on various mobile devices. - Stay updated on the latest trends and best practices in mobile app styling and animations. Requirements: - Proficiency in React Native development and JavaScript. - Strong understanding of CSS and styling techniques in React Native. - Experience with implementing animations using React Native...
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...
I'm in need...generating quality leads, and driving significant traffic to my website. My target audience for these campaigns ranges from individuals aged 18 to 44. The ideal candidate would have: - Profound experience in managing ad campaigns on Facebook and Instagram - Expertise in audience targeting and lead generation for the specified age group - Strong ability to create engaging content, and track and optimize campaign performance - Solid understanding of website traffic engagement metrics - Demonstrated experience in boosting brand visibility and prominence Your responsibility will be devising and implementing strategic ads that grasp this particular audience's attention and increase conversions. Links to past work or references would be very appreciated as part ...
I'm in need of a digital marketing expert who has vast experience in implementing pixels and tags for website conversion. Key Responsibilities: - Implementing pixels and tags to measure website conversions adequately. - Ensuring the tags are set up correctly to gather accurate data. - Advising on the best practices and strategies to optimize the tracking process. Preferred Communication: - Communication regarding project updates and revisions will be done via email. Ideal candidate should have: - In-depth experience in digital marketing, particularly in pixels and tags creation and implementation. - A solid background in implementing pixels and tags for website conversion tracking. - Excellent communication skills, particularly through email, to keep me updated on the projec...
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
...need someone who can manage and optimize my Google Ads account to drive more conversions and sales. - Increasing ROAS: My primary goal is to significantly improve the Return On Ad Spend (ROAS) of my campaigns. Your expertise in this area is crucial. - Performance Monitoring: You will be responsible for closely monitoring the performance of the ads and identifying areas for improvement. -Scale winning products, optimize campaign and onging management for 30 days Ideal Candidate: - Proven Expertise: I'm seeking someone with a strong track record of managing successful Google Ads campaigns for Shopify stores, particularly in terms of ROAS and sales. - Analytical Skills: You should have a keen eye for data analysis and be able to derive actionable insights to optimize...
1. We are seeking a proficient HTML5 and CSS3 expert to improve alummoottil.com. This website is purely HTML5 and CSS3 and there is no usage of javascript (except for google analytics) 2. Your task will be to optimize the performance of the website with the following objectives. a - Improve the website's loading speed b - Enhance its mobile responsiveness c - Increase the desktop performance (see performance report) from 46 to 100 d - Increase the mobile performance (see performance report) from 37 to 100 3. I do NOT want any changes to the existing look and feel. 4. I do NOT want any additional functionality. 5. Delivery must ASAP 6. The freelancer who is awarded must sign a Non Disclosure Agreement (NDA) and Intellectual Property Agreement (IPA). This will require you ...
One excel file with macro as per the customer requirement
I'm looking for a skilled programmer who can help me commission an Allen Bradley PLC for hydraulic tire presses. The service engineer would be responsible for: - Compliance with the programming of the PLC and ensure control devices have proper function. - Working with other engineering disciplines (Electrical and Mechanical) to deliver a successful proje...monitor and potentially adjust pressure as needed. - Temperature: Capability to sense and react to temperature changes in the system. - Force: Ability to measure and control the amount of force applied by the press. Ideal candidates should have: - Experience with Allen Bradley PLC programming. - Strong understanding of hydraulic systems. - Previous work on similar automated systems. - Ability to optimize system performance ...
...to increase conversions and ROI. - **SEO:** The main focus of our SEO efforts is to improve our search engine ranking. Our aim is to appear at the top of search engine results for relevant keywords. You should be knowledgeable in the latest SEO techniques and algorithms. - **Website Design:** While not the primary focus, we are also looking to make specific changes to our website design to optimize it for better conversion rates. Ideal Candidate: - Proven experience in performance marketing, with a track record of increasing conversions and ROI. - In-depth knowledge of SEO best practices and experience in improving search engine rankings. - Experience in website design, particularly in relation to maximizing conversion rates. - Understanding of both B2C and B2B audiences fo...
I'm quietly on the hunt for a skilled professional to design an Instagram bot that can perform a series of tasks on my behalf. The main functionalities I'm interested in include: - Auto-liking posts - Auto-following users - Auto-commenting on posts I'm not in search of basic or hyper-detailed, but I'm aiming for moderate customization. While I don't want a merely p...of accounts: - The ones I manually specify - Accounts within particular niches I'm interested in Having knowledge in Instagram bot programming, web scraping and understanding of Instagram API will play a vital role in this project. A sense of culture around cybersecurity and Instagram's guidelines is also key to ensuring the bot operates ethically and within boundaries. Let's work to...
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forward to your proposals.
I'm looking for a skilled Google Ads specialist to help me generate leads and sales. Key Responsbilities: - Develop and manage a Google Ads campaign with a focus on Google Search. - Optimize ad copy and targeting to attract local customers. - Monitor campaign performance and make adjustments to improve lead generation and sales. Ideal Skills: - Proven experience in managing successful Google Ads campaigns, with a specific focus on lead generation and sales. - Deep understanding of Google Ads, Google Search in particular. - Ability to target and attract local customers effectively.