How to speed up macros in excel 2010prá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í.
znas vec : ))) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR an...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set t...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...funding opportunities in order to ensure successful grant approvals. The Grant Writer MUST be Canadian or have the expertise and experience with the Canadian government, ideally living in Canada and speaks and writes English Fluently. They MUST specialize in IT/digital marketing/ ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for finding funding opportunities for our organization and writing polished proposals to earn Ontario & Federal government grant money. The Grant Writer will identify, define and develop funding sources to support existing and planned program activities as well as lead the development, ...
...professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how ...
As my site's load speeds are already under 3 seconds, the primary focus of this project will be SEO, particularly improving my site's on-page SEO. In this regard: • Evaluating and enhancing the page structure for better user engagement and search engine crawling. • Strategically placing SEO keywords in the content for better visibility. • Optimizing images, videos, or any other media forms. • Working on meta descriptions, headers, URL structures, and internal links. For this task, you need to have a strong understanding of WordPress, SEO, and user experience. Experience with optimizing websites with a similar load speed is a plus.
hello I'm looking to set up a team that would help me start my company so the deal is that I want to start a movie streaming company that lets users stream and download movies and TV shows from their phones and laptops/computers and TVs. So I have already pitched the idea to investors and they are willing to invest in the project under two conditions first, I must form a team dedicated to the idea second, the investors want the app to gain traction so if the app gets more than 10000 +active users, we will get funding to continue with the work in two months so the problem is I don't have the money to pay you right now but once we...
...am looking for someone experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail t...
...only if you're willing to work with me live via zoom. *** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, ...
I would like to design standard operating procedure (rules of lead engagement) based on large medium and enterprise segments- 1) how should sales consume the leads once a lead is assigned to the sales reps. 2) Define the stage movement timeline from one stage to another in salesforce based on which stage the lead is in. 3) How long to wait to send a follow up email /call after the two way connection has been established. 4) Reason to close or recycle the lead 5) Activities logged in salesforce. etc.
...Site is 97% Complete, you will be doing 3%) to Flip the swicth to Live Domain. Key Responsibilities: - Implementing advanced SEO techniques using Rank Math SEO (Paid) to optimize the site. (Installed) - Providing assistance in identifying target audience and keywords for the SEO campaign. -We are seeking a skilled WooCommerce Developer/SEO Specialist to join our team and optimize our newly migrated e-commerce store on WordPress WooCommerce. As a pivotal member of our team, you will be responsible for ensuring the site's optimal performance, visibility, and user experience through effective web development and SEO strategies. Our newly migrated site is ready to switch to the live domain. Before or after site Domain is switched to...
...Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finance Domain Knowledge Automation Scripting using excel Macros Other Functions: • The Quality Engineer IV participates in...
...looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowled...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's access...
More details: What is the desired color scheme for the HTML emails? Vibrant colors What type of data is being displayed in the emails? Graphs and charts How sophisticated should the timeline image design be? Moderate complexity with some unique elements
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user...
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
I'm in need of a captivating video advertisement aimed at boosting sales for my e-commerce store. While I have no specific target audience outlined, the candidate with a broad understanding of different demographics will be highly preferred. - The Work: The scope of work will include concept creation, creating storyboards, filming, and post-production. Your work should deliver a compelling narrative that encourages the viewer to make a purchase. - Ideal Skills: You should possess demonstrable skills in video production and editing, storytelling, and e-commerce marketing. Past experience creating effective e-commerce ads will be highly beneficial. - Timeframe: There's no rush to complete this project. I do value quality over speed, so ta...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting ...
tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...
**Job Type**: Full-time **About Us**: We are a startup in stealth mode located in the Bay Area. Our mission is to revolutionize Event management through innovative solutions and cutting-edge technology. **Role Overview**: We are seeking an experienced Backend Developer with strong expertise in FastAPI to join our dynamic team. This individual will be responsible for building and maintaining the server-side logic, ensuring high performance and responsiveness to requests from the frontend. **Key Responsibilities**: 1. Design, build, and maintain efficient, reusable, and reliable FastAPI code. 2. Implementation of security and data protection solutions. 3. Integration with frontend components and third-party services. 4. Define and maintain the dat...
I need an experienced engineer to design a Python-based program for a two-axes programmable motion controller that can be integrated into our food processing machine. Key Responsibilities: - The program should support speed control and position control functions. - The system should also feature an automatic reset. Ideal Candidate Skills: - Proficiency in Python programming language - Previous experience in motion control programming - Familiarity with the dynamics of mixing and blending systems in food processing The controller will be used for a mixing and blending system. Please bring any experience that could be relevant to this task. Your expertise is very valuable to us.
Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Imag...
I'm in need of a highly skilled graphic designer to create a minimalistic yet impactful logo for my podcast/creator studio, "Mic'd Up Studios". The main objective of this logo is to help in the branding of my business, ensuring it becomes easily recognizable across various platforms. Key Requirements: - Experience in crafting logos - Proficiency in minimalistic design - Adept at using black and white color schemes Your design should reflect the essence of my studio, which is all about creativity, professionalism, and innovation. Please ensure that the logo is visually appealing, versatile, and easily scalable for various applications. If you have experience with audio/visual branding, that would be a plus. I look forw...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
I'm in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided ...
As a Magento based business owner, I'm looking to significantly enhance the loading times of my website's pages. Key Project Goals: - Minimize the load time of my website's pages which are currently exceeding 4 seconds. After improvements, I'd like the pages to load as quickly as possible. - Specifically focus on optimizing the Product, Checkout, and Category pages as I'm facing the most loading time issues there. To achieve the above-mentioned goals, it is important to optimize the three crucial aspects of the website: - Image optimization – Utilize appropriate compression techniques for optimized image sizing. - Caching Improvements – Enhance the caching mechanisms to make the website extremely responsive. ...
...designer to help clean up and redesign my website. This project will involve four main areas of focus: Design Layout, Content Organization, and Speed. Design Layout: - Change color scheme: I need a fresh color palette that is visually appealing and cohesive. It should include a black and white core like my logo with red/blue accents. The images should be updated with the same colors using photoshop recoloring. - Update fonts and typography: I am looking for a modern, readable and consistent font that matches my logo. - Optimize for mobile devices: The website should be responsive and provide a great user experience on all devices. It is already setup like this, but may need some fine tuning. Content Organization: - Rearrange pages and sections: I want to...
I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.
I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.
I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.
I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload
...Full Stack PHP CI4 and Laravel developer to join our dynamic project team. Our project involves comprehensive backend development, efficient API integration, intricate database management, and crafting a frontend with a customizable layout that stands the test of user experience. **Key Responsibilities:** - **Backend Development:** Implement robust functional logic ensuring seamless data processing and workflows. - **API Integration:** Efficiently connect our platform with necessary external services and APIs for enhanced features. - **Database Management:** - **Data Migration:** Safely transition existing data resources to our new system without loss. - **Performance Optimization:** Continuously monitor and tweak the database performance for speed and relia...
I'm in need of a skilled web developer to perform a series of updates on my website as soon as possible. Key Updates: - Redesign of the Homepage - Addition of new pages and content - Optimization of site speed While the main goals for this update are not specified, the overall aim is to enhance the website's effectiveness. Ideal Freelancer: - Proficient in web design and development - Experienced in redesigning websites - Understanding of user experience and website speed optimization Given the urgency of this project, I'm looking for a dedicated and efficient freelancer who can complete these tasks promptly without compromising on quality.
