Excel vba macros expertsprá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í.
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...
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ů.
...completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Cont...
I nee...hackathons, or coding competitions to foster a culture of continuous learning and innovation. Highlight past events or organize your own tech-focused events to engage with the tech community and attract talent. Social Proof: Display awards, recognitions, or industry affiliations that reinforce your company's reputation as a technology leader. Showcase client testimonials or endorsements from industry experts to build trust and credibility. The ideal freelancer for this project should have: - In-depth experience in Wix website design and development. - Experience in designing websites for software technology companies would be a bonus. Please provide samples of past work, ideally Wix websites you've developed for tech companies. Let's create an impressive ...
I require an Excel specialist proficient in creating dynamic and functional spreadsheets. This project involves designing a new Excel sheet that handles both numerical and text data. You would need to: - Set up the sheet, capable of performing multiple features such as automated calculations and conditional formatting rules. - Configure simple calculations for GP indicators basing on specific cost prices. - Ensure the spreadsheet can efficiently process a mix of numeric and text data. Strong skills in Excel and data management are essential for this project. Familiarity with advanced Excel functions and an ability to provide quick, efficient solutions to data processing problems would also be very beneficial. A good understanding of GP indicators and cost pri...
I'm seeking a professional with a strong background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - Experience creating and managing Excel databases - Proficiency in implementing keyword search tools in Excel I would like the sheet to have a Main/Search Page and another page for the database. I want to be able to add new entries to the database section and have them be searchable on the main page. I want to be able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box to narrow the results....
...shows the site in the context of the Hubspot editor is fine. If you win, we'll ask you to copy/paste it into our Hubspot environment (along with build out a couple more pages). Many thanks. Images Please use these images and gifs: I attached a couple below. Homepage Educating the next generation of STEM experts [Schedule a Demo] - Learn to program alongside AI. - Low stakes exercises. Emphasis on daily exercises. - Project-based exercises, automatically graded. - STEM is essential for our future workforce! Science, Technology, Engineering, and Mathematics. STEM is difficult While U.S. students are struggling in STEM education compared to their international peers, there are ongoing efforts
I need this to be done IMMEDIATELY! - Extract data in a specified format. - Transfer data from the price listing PDF to an Excel spreadsheet. - Input details such as SKU, Name, Description, Brand, Cost Price, Length, Width, Height, and Weight, which are highlighted in blue. - If any title or heading is not mentioned in the details provided in item #3, add it to columns U-Z. - Ensure all data is formatted correctly, with names in proper case and prices as numerical values. I'm in need of a proficient data entry freelancer to help convert a scanned image PDF to an Excel spreadsheet. Key Details: - The PDF contains less than 50 pages. - The data in the PDF is in the form of scanned images, making it crucial that the freelancer has experience in handling this ...
Job Overview: We are currently seeking skilled professionals in software engineering, web development, machine learning, computer vision, and NLP to join our team on a project basis. This is an excellent opportunity to collaborate with industry experts on significant industrial projects. Responsibilities: Work collaboratively on diverse service projects with our team and industry experts. Apply your expertise in software engineering, web development, machine learning, computer vision, or NLP to solve complex problems. Engage in project lifecycle from conception to deployment. Requirements: Proven experience in software engineering and/or specific fields such as web development, machine learning, computer vision, or NLP. Strong problem-solving skills and ability to work in...
I'm looking for seasoned professionals to upgrade my current website. Key tasks: - Redo the layout design with a fresh, appealing visual appearance. - Retrofit our navigation menu: addition of new categories, improvement of responsiveness, and simplification of the user interface are required. ...improvement of responsiveness, and simplification of the user interface are required. - Renovate our contact form to ensure it performs excellently and is user-friendly. Additionally, proficiency in SEO is vital. I aim to drive more traffic and scale up, thus the need for enhanced SEO tactics. You must possess a strong understanding of the latest SEO techniques and principles. Ideal candidates are experts in website redesign, with a focus on user interface, user experience and...
I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.
Tengo una asesoría energética, la cual paga comisión por contrato. La comisión depende de distintos factores. Actualmente tenemos un backend en excel y un frontend en pdf, es decir: Creamos las comisiones en excel para agilizar la creación, las copiamos en un POWERPOINT algo más atractivo y visual, y las convertimos a pdf. Nos gustaría poder implementar la subida de estos excels en una interfaz BONITA, incrustrada en una web. Lo ideal sería poder cargar estos excel a la web y que la web "pintara" estas comisiones a través de una interfaz visualmente atractiva y llamativa para nuestros agentes comerciales. Adjuntamos ejemplo de excel de comisiones de algunas de nuestras compa...
I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation
I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!
...using HubSpot, Mailchimp, and Excel. - Proactively seek opportunities to promote through various media channels. - Assist in securing funding by connecting with potential investors and establishing meaningful relationships. - Conduct fundraising outreach efforts, including scheduling meetings with potential investors outside of the conference. - Capture and document feedback and opportunities for post-conference follow-up. **Qualifications:** - Prior experience in sales, public relations, or business development. - Strong communication and interpersonal skills. - Proven ability to network effectively and establish meaningful relationships. - Highly organized with excellent project management skills. - Familiarity with HubSpot, Mailchimp, and Excel. - Experience in cont...
...with strong skills in data scraping and extraction, particularly with textual content and figures, from a specified public website - Tasks: - Effectively pull relevant textual content and figures - Ensuring the scraped data is comprehensive, accurate, and neatly organized Excel Skills: - The data collected must be meticulously stored in an Excel database - The organization method within the database is by entity An effective freelancer must be detail-oriented, proficient in using Excel and knowledgeable about data scraping techniques from public websites. A background in handling similar tasks would be advantageous. Accuracy and neatness in data organization are also paramount. Please indicate you reviewed the information above and attached and specify the a...
I'm in need of an experienced Flutter developer to integrate APIs into my app. Please only reply experts who knows solution.
I'm in need of an application that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this accurately. Your...
Who we're looking f...a multi-functional team that builds and design's Atlassian's core web experience across our e-commerce platform on , and more. Our team has a substantial impact on the growth of Atlassian, and we're committed to pushing current trends in web development in order to create a cutting-edge experience across our brand. What you'll do • Work with a talented team of UX experts (Product Managers, Designers and Developers) to continually iterate and improve the experience of our internal and external users. • You will be empowered to drive innovation by coming up with new and exciting ideas to creatively solve issues, as well as actively look for opportunities to improve the design, interface, and architecture of Atlassian'...
I'm in need of a proficient social media manager who can post daily content on Facebook, Instagram, TikTok, and other platforms through Loomly. The job will mostly entail modification of existing content. However, your creative input is most welcome. There is an official step-by-step Process to follow. Minor Excel reporting is required as well. I need somebody who is proficient in English-written and listening/talking. Must be able to work in a New York time zone between the hours of 12 PM and 8 PM. Roughly 2-3 hours a day total Monday-Friday at $30 a week! This role requires: - Excellent understanding of these four platforms - Proven ability to edit and modify existing content in an appealing way - Capacity to deliver consistently on a daily basis - Attention-to-detail...
...I will decide on the project in 3 days. The business evaluator estimates what your business is worth and offers a blueprint for scaling your business to the next level. The blueprint will establish your business baseline, identify your peer group, and advise you on what you need to do (people and budget) to accelerate to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from this worksheet is utilized for all 8 other reports (worksheets it produces...
Hello, We are seeking a skilled developer to construct a straightforward pipeline for processing data annotated with multiple cat...of modifications and any additional requirements will be provided. This project is initially short-term but has the potential to evolve into a long-term collaboration. We are engaged in numerous ongoing projects across computer vision, machine learning, and AI, and are looking for talented individuals to join our team. Working with us, you will have the opportunity to collaborate with industry experts on significant industrial projects. Please write "aaa" at the beginning of your bid so that we can filter out unnecessary bids. Please find attached a sample image to give you a brief idea of the task at hand. We look forward to your applica...
I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messagin...Documents and presentations - Training materials - Policies and procedures Your design should ensure the bot is user-friendly, reliable, and able to handle the company's internal resources efficiently. The Most important thing is the BOT must be PRIVATE and the only method to subscribe to BOT channel is by OTP sent to the registered e-mail in my company domain. The email list will be provided by excel sheet to you. The second MOST important thing is that the bot channel must be un...
I am in need of a skilled article writer with a deep understanding of technology, capable of producing highly technical content suitable for experts. Key Requirements: - The articles should be focused on technology. - The language should be highly technical. - The articles should incorporate links to studies or external sites. Ideal Freelancer: - Proven experience in writing technology articles. - Excellent understanding of highly technical language. - Research skills to source and incorporate relevant studies and external sources. - Good understanding of SEO principles. - Ability to deliver high-quality, engaging, and informative content.
You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.
I'm looking for a skilled Excel expert to work on my financial data. The task involves clearing the data and conducting a thorough analysis specifically focused on profitability. Key responsibilities: - Clearing the provided financial data - Analyzing the data based on the profitability metrics Ideal skills and qualifications: - Proficiency in MS Excel, especially in data analysis - Strong understanding of financial metrics, particularly profitability - Attention to detail and ability to ensure data accuracy - Ability to present findings in a clear, concise manner - Previous experience working with financial data is a plus Please note that the data requires thorough analysis. Clarity and precision are crucial as the analysis will be used to make important business de...
I have a set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains accurate and up-to-date. Ideal skills and exper...
I have a database with 200,000 SKU's from retail sales, unfortunately lacking category, subcategory, and brand details. I'm seeking a skilled professional who can assist in mapping these details effectively. Key Deliverables: - Utilize a data matching algorithm to automatically map the SKU's with high accuracy (90-95%). - Present the final output in an Excel spreadsheet. Ideal Skills: - Proven experience in data matching and SKU mapping. - Proficiency in using data matching algorithms. - Experience with handling large datasets. Accuracy is paramount for this project, as the mapped details will be used for further data analysis and decision-making in our retail operations. A high level of precision will be crucial in ensuring the effectiveness of this project.
I'm in need of a professional who can help with qualitative analysis of interviews conducted with subject matter experts. Key tasks include: - Conduct thematic analysis - Conducting a thorough qualitative analysis of the interviews - Identifying trends and patterns in the feedback - Gaining insights based on the experts' opinions Skills and Experience: - Proven experience in conducting qualitative analysis - Familiarity with interpreting feedback from industry professionals and subject matter experts - Strong analytical skills to identify codes and themes
I'm seeking an experienced Tableau and Excel expert to assist in creating a high-quality data visualization project. Key project requirements include: - Intermediate level of complexity: The data that needs to be visualized is sourced from multiple sources and requires the implementation of filters. - User-driven data filtering: I am looking to implement specific interactivity features that allow users to manipulate and filter data. The ideal candidate will have: - Proficiency in Tableau and Excel - Experience in creating intermediate level data visualizations - Strong understanding of data filtering and interactivity features If you possess the required skills and experience, please bid on this project.
I'm seeking an experienced and knowledgeable data scraping professional to collect specific information from three major platforms - RERA websites (specifically Maharas...(Maharashtra, Telangana, Haryana, Delhi) - Google (DSA and Loan Agents data) - Justdial (DSA and Loan Agents data) The ideal freelancer for this job will be highly experienced in data scraping and will be able to deliver the results in an organized manner. Proficiency in scraping from Google, RERA websites, and Justdial is particularly important. Delivery Format: - The data should be delivered in an excel file format. If you have the required skills and this project fits your area of expertise, I encourage you to bid. Your understanding of the project could make a real difference. Let's discuss how w...
I am searching for a highly experienced Wix Studio professional. The right fit for this job will have at least two years of experience in the craft. Ideally, you will be confident in creating a website geared toward a specified age range and business professionals. Crucial detail...audience being a specific age group and business professionals, the website should be professional while remaining user-friendly and intuitive. Essential skills include e-commerce, user experience design, and expertise in Wix Studio. Experience with a similar demographic would be advantageous. Must share your Previous work sample (Live website link ) that you made for your clients. Note:- We Want Experts or intermediate Wix studio developers, if you are a beginner & not have a strong portfolio pleas...
I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.
I have a 3.5-page handwritten sign-in sheet that I need transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highlighting of spec...
I'm seeking a specialist with expertise in detailed financial data entry. You'll be tasked with entering intricate numbers and figures for our financial reports. Skills and Experience Required: - Proficient in Microsoft Excel. - Experience with financial report data entry. - Detail-oriented with ability to handle complex numerical data. Main Tasks: - Inputting detailed financial data into our Excel-based financial reports. - Ensuring accuracy of data. - Completing tasks within given deadlines. Please share relevant previous experience and examples of your work when bidding.
I'm in search of a seasoned Excel-savvy bookkeeper to assist with the following tasks: - Accounts Payable: Tracking and managing all outgoing payments in a clear and organized manner. - Accounts Receivable: Overseeing and monitoring all incoming payments, ensuring timeliness and accuracy. - Bank Reconciliation: Regularly reconciling bank statements with our financial records to ensure accuracy. You don't necessarily need to be an expert in accounting software, but you should be fluent in Excel. This project doesn't involve learning new software, but rather meticulously managing and organizing financial data in Excel. I prefer to receive updates and reports via email, so clear and concise communication skills are a must. Experience in bookkeeping or a...
I need an Excel expert to help me document my financial data in a specific text-based format. Key Requirements: - Organizing and documenting financial data in Excel - Following a specific text-based format provided by me Ideal Skills and Experience: - Proven experience in working with financial data - Proficiency in Excel, including advanced functions for data organization - Excellent attention to detail and ability to follow specific instructions accurately and efficiently.
Looking for someone who is highly knowledgeable in Excel functions, formulas, and formatting. The ideal freelancer will have experience performing the following tasks in Excel spreadsheets in portuguese - Implementing a variety of Excel formulas and functions - Applying diverse formatting techniques Unfortunately, I have not specified the exact functions, formulas, or formatting needed, meaning the freelancer must employ a broad range of knowledge and expertise in these areas. Experience with Excel in Portuguese is a definitive plus. The project requires an adaptable and meticulous individual able to meet changing demands efficiently.
I need a talented designer to create a minimalist logo for my company. Here are my requirements: - The primary color scheme should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligator...should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligatory. Skillful use of it, contingent on how it fits into the design and overall aesthetics, is appreciated. Ideal candidates should possess past experience in minimalist logo design and a keen eye for balancing colors. If you excel in creating attention-grabbing logos with subtle details, then this project i...
