Vba excelprá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...
...developer capable of creating a tool to store data in bulk and automatically remove duplicates each time new data is added to the existing database. Storage of large datasets: The tool should allow for storing a large quantity of data. Duplicate removal: It should be possible to remove duplicates in the Excel files to maintain a clean and organized database. In addition to these features, it would also be necessary to be able to edit data in the tool and export the changes made to an Excel file. Furthermore, an archiving feature would be desirable, allowing for downloading of the used data for future reference. I would appreciate it if you could confirm whether you are able to develop such a tool and provide me with a quote at a reasonable rate. Thank you in advance fo...
I'm seeking a proficient AI researcher. The main focus is to research all the AI tools and suggest best tools for the following activities, 1. PPT, Excel & word document creation 2. Prompt engineering for Chatgpt & similar 3. Project management : Auto schedule creation, task tracking, followups, resource management, report generation, auto reply for emails, risk management 4. Sentiment analysis of text 5. Engineering document creation : System Requirements, SW Requirements, Architecture creation, software detailed design, software coding, Test case creation. 6. Images, Animation creations Your primary task will be to understand different AI tools, create a list of all the AI tools, its corresponding usage for both free & paid tools. The industry targeted is automo...
I need a detail-oriented freelancer for my project on data entry on Excel. The duties include: - Entering both numeric and textual data. - Maintaining an exceptional degree of accuracy for every entry. - Ideally, you should have prior experience working with Excel and data entry. - The volume of data is unspecified as of now, but prepare for medium to large volumes. Proficiency in Excel, attention to detail, and the ability to work with a mix of data is necessary for successful completion of this project.
We are in search of a meticulous researcher adept at data compilation within Excel sheets. Your primary task will involve sourcing, researching, and organizing data for a designated list of company names provided. The role entails gathering contact details and accurately inputting them into the provided spreadsheet under relevant column headings such as email, phone number, address, country, buyer name, buyer Linkedin profile link and buyer contact number. The scope of the project requires data collection for a minimum of 1000 companies, predominantly from the United States, along with other specified countries. Upon data entry, you will be responsible for sorting and categorizing companies based on size (large, medium, small), while ensuring the removal of duplicate entries for cl...
I require a freelance bookkeeper who can assist me with my accounting needs. - You will primarily be responsible for bookkeeping tasks, ensuring that all financial tra...that all financial transactions are properly recorded in my accounting software. - As a bookkeeper, you should have a keen eye for detail, be organized, and have prior experience in bookkeeping. - Familiarity with popular accounting software like QuickBooks and Excel is a must, as I currently manage my bookkeeping through these platforms. The ideal candidate for this job should have a strong background in accounting, specifically bookkeeping. Relevant certifications or degrees in accounting are a plus. Experience with QuickBooks and Excel is a must. I'm looking for someone who is detail-oriented and c...
I'm seeking a proficient PowerBI expert who can create a simple dashboard with 2 tables and 6 card. Data is in excel and requirements will be shared in a doc file with all details. Needs to be build today.
I have a PDF list which contains text and numbers. The list is structured with columns and rows. The task is to convert this list into an Excel sheet. The Excel list should be organized in a sorted manner, either alphabetically or numerically. Ideal Freelancer: - Proficient in data entry and conversion - Experience in handling PDF to Excel conversion - Excellent understanding of sorting data appropriately - Attention to detail is crucial
...experienced Google Excel expert to assist me in refining and optimizing my current Excel tables for business purposes. Key Requirements: - **Formatting**: I need assistance in improving the aesthetic appeal and readability of my tables. This includes changes to font style and size, cell borders, and background color. - **Formulas**: The expert should be proficient in implementing essential formulas such as Sum, Average, and Count. They will play a crucial part in calculating and managing data effectively. - **Data Validation**: I need guidance on implementing data validation processes to ensure the accuracy and consistency of my data entries. Ideal Skills and Experience: - Proven experience in working with Google Excel and enhancing its functionalities. - Profici...
I'm in need of a web scraping expert who can extract daily car rental prices from and deliver this data to me in Excel format. Key Requirements: - Extract car rental prices from - US based locations - Deliver the scraped data in Excel format Ideal Skills and Experience: - Proficient in web scraping - Experience in extracting data from dynamic websites like - Able to automate daily data extraction - Proficient in delivering data in Excel format
I have image form i want to make the form in excel to print it directly
mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm
I'm looking for someone to develop a stock prediction program specifically targeted at the Saudi market. Key Requirements: - Programming Language: You can use any language you're comfortable with, whether it's Python, Java, C++, or another language or excel sheet. - Technical Requirements: The program should be highly accurate, providing predictions with an accuracy rate of over 90%. - Data Sources: The program should utilize a range of data sources to inform its predictions. These should include historical stock data for the Saudi market and any other relevant information that you can source. Be creative with your data sources and demonstrate a strong understanding of the market. Ideal Skills and Experience: - Strong background in programming and algorithm develop...
I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking will be a plus ...
I am searching for a dynamic Sales Executive well-versed in technology, specifically software solutions, to drive sales in the business sector. Key Responsibilities: - Building and maintaining relationships with business clients ...maintaining relationships with business clients - Presenting and selling software solutions ( web designing and social media marketing and management ) Ideal Profile: - Experience in B2B sales, particularly in technology - Understanding and passion for software solutions - Excellent communication, presentation and negotiation skills. This is a commission-based role offering the opportunity to excel within the tech industry while working closely with businesses. Comession is based on deals you will it is going to be between 8% - 20% on every succe...
I have an urgent project requiring the conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed successfully. Only professionals with strong crede...
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...
...real-life combat scenarios. Why Join Us: Strategic Partnership: This is more than just a job – it's an opportunity to become a key partner in our expansion, leading our machine learning initiatives to new heights. Leadership Role: As the Senior Machine Learning Engineer, you'll spearhead our efforts in leveraging machine learning technology, guiding and managing our talented teams to innovate and excel. Exciting Growth: VRAS is expanding rapidly, and we're looking for our next partner to join us on this thrilling journey. Equity Only Offer: This partnership opportunity is equity-only, reflecting our commitment to building a collaborative and mutually beneficial relationship. What We're Looking For: Technical Expertise: Extensive experience in machine...
I'm looking for someone to assist in transferring data from digital files (mainly PDF and Word) into Excel spreadsheets. Key Responsibilities: - Accurately inputting data from PDFs and Word documents into Excel - Ensuring data integrity and quality is maintained throughout the process Ideal Skills and Experience: - Prior experience with data entry, particularly with Excel - Meticulous attention to detail to ensure accurate data transfer - Proficiency in Excel and ideally some experience with PDF and Word files - Ability to work independently and meet deadlines
As someone deeply invested in the health and wellness sector, I am seeking capable freelancers to compile a comprehensive city-wide mailing list. Key Deliverables:...capable freelancers to compile a comprehensive city-wide mailing list. Key Deliverables: - Locate all disability support businesses in the chosen city. - Capture specific details for each business: name, business email. - Record the information systematically on a spreadsheet for easy reference. Ideal Bidder: - Excellent research and data gathering abilities. - Proficient in Google sheets or Excel. - Attention to detail. - Experience in database creation or compiling mailing lists. Please note, I am working on a budget AUD $60 and require the task to be completed within 1-2 days. Thank you in advance for your cons...
I have a large PDF file with a mix of text and numbers. It contains over 300 pages, but there are generally less than 10-20 lines of data on each page. I'm looking for a freelancer to convert this data into an Excel spreadsheet. I'm only in need of data entry, not analysis, so the task is straightforward. Ideal Skills: - Proficiency in Adobe Acrobat - Strong knowledge of Excel - Experience in data entry This is a simple but time-consuming job, so please provide a realistic timeframe for completion when bidding. Accuracy is important, as the data will be used for further analysis.
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...
I have an urgent project requiring the conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed successfully. Only professionals with strong crede...
I'm in need of a research professional who can collate and organize details about the Corporate Social Responsibility (CSR) activities of a specified list of 400 companies, together with LinkedIn profile URLs of respective team members. Key Task Requirements: - Research and compilation of CSR project details of the identified companies - Use of Excel for data presentation in an organized manner - Gathering of LinkedIn URLs of team members from each company Ideal Skill Set: - Proficiency in web research - Expertise in data entry and data organization - Familiarity with LinkedIn and its functionalities - Detail-oriented approach - Experience in Corporate Social Responsibility research is a plus. Your job will be instrumental in providing in-depth insights about the afore...
...customer business card scans into a detailed Excel database. Each card has been scanned using the CamScanner app and they vary widely in design, content, and layout and all of them are different. (90% of the cards are in english, 10% are in urdu and arabic) Objective: Looking for innovative, no-code methods that automate the conversion of these business card images to an Excel sheet with minimal human interaction. The best method should be fast, cost-effective (minimal or zero cost), and capable of handling high variability in card designs without any coding or manual programming. Submission Guidelines: * Propose a no-code solution using online tools or existing software that can intelligently organize varied information into consistent Excel columns. * Emphasi...
- Daily Accounts: Should have a mechanism for daily tracking of accounts. - Sales Management: An organized way to manage all sales. - Customer Management: The system must be able to maintain a proper client record. - Purchase Management: Need to keep track of all the purchases. - Supplier Management: Managing interactions with the suppliers effectively. - Database Management: Ability to handle a growing database. - Inventory Management: Keeping up with fish inventory.
I have an excel exercise as part of a financial modeling course which i need to solve It is regarding determining debt size and repayment profile while keeping DSCR at a fixed ratio. I will also need to record a Macro of the debt sizing, sculpting and leveling profile
I need a skilled statistician/data analyst to assist with imputing missing data in a meta-analysis of clinical trials dataset using SAS or Stata (ideally). I can supply the results of 28 trials (with 15 with missing data) with n events / n total in ACA analysis and n missing in both intervention and control groups (in Excel format) Key Responsibilities: - Impute missing data: The primary task will be to impute missing data in the clinical trial dataset. This is crucial for maintaining the integrity and accuracy of the overall analysis. - Generate ACA, ICA-0, ICA-1, ICA-pc, ICA-pe, ICA-p, ICA-b, ICA-w, Gamble Hollis analysis and IMRO (2/0.5 and 0.5/2) analysis plots - Generate L'Abbe plot(s) (for further details please see attached file) Ideal Skills and Experience: - Proficie...
I'm looking for a comprehensive Excel dashboard that can help me manage resources for my projects. This project will involve visualising project management data, with a focus on resources management and planning. The key elements of this dashboard will include: - Resources Planning: Visualising the availability of team members, their skills and current project assignments. This should help me in efficiently allocating resources for various tasks. In addition to these, I'm also interested in other data such as budget tracking and milestone tracking. The ideal candidate for this project should have experience in: - Advanced Excel skills, with a focus on creating visually appealing and user-friendly dashboards - Experience in designing project management dashboard...
To help streamline operations in our manufacturing firm, I'm seeking a professional with deep expertise in Excel, as well as a strong foundation in data security. As a result of this project, we need a highly functional, secure Excel template that meets the following requirements: - Advanced Excel Features: The template should involve data entry forms, complex calculations and formulas, and strict data validation rules. It should also facilitate costing, inventory management, attendance tracking, salary calculation, profit/loss calculations, and accounting. An integrated dashboard and graphical representation of data is also needed. - Security: Due to the sensitive nature of the information to be processed, we require an array of security measures. These include...
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...
I am seeking someone to retrieve specific contact details for a Chinese company located in Tibet. Key Deliverables: - Company Name - Contact Person - Address - Email - Phone Number - WhatsApp Number Preferred Format: The final deliverable should be in Excel or CSV format. Experience Required: - Proficiency in Chinese language and familiarity with Chinese business conventions. - Previous experience in retrieving contact information. - Attention to detail and accuracy in data collection. Please reach out if you believe you have the necessary skills and experience for this task.
Hiring a hybrid NYC remote assistant for a clean energy company. Job is Mond...calling) Job includes: -Scheduling clients with company for installs via phone calls -Keeping track of installs and inventory -Updating information for bookkeeping -Simple accounting and invoicing -Appointing clients to their appropriate sales rep -Social media management -Answering calls and relaying messages Must: -Speak English -Live in NYC -Have knowledge about common use of simple apps like excel, google drive, word, Gmail, WhatsApp -Organized Preferred: -Spanish / Chinese / Russian speaking -Website building, data security, tech -Photoshop -Living in Brooklyn or Queens Type : NYC only to show not a bot Please include a 15 second audio of your speaking voice to show you have english of working pr...
I require an Excel expert to assist with a complex data analysis. The dataset is quite large (more than 1000 rows) and involves matching combinations. Key Requirements: - Data Analysis: The main purpose of your task is to help me analyze the data available. This will involve identifying patterns and matching combinations. - Excel Skills: You are expected to have advanced Excel skills to handle this large dataset effectively. - Combination Matching: The combinations you will be working with are complex, and may require manipulation of the data. I'm looking for someone with extensive experience in Excel, particularly in data analysis and matching complex combinations. Your ability to efficiently handle large datasets and work through complex data structures...
I need a freelancer to gather contact info for 42 recruitment companies based in UAE. This information will be used for job seeking purposes. Key Requirement: You will need to find the contact name and e... Irwin & Dow - Premier Recruitment - ManpowerGroup - Mark Williams - Robert Murray - Future Tense - Black & Grey - Education 1st recruitment - Results should be in an excel sheet format, outlining the name, position, email address for each contact. Contacts for each company should be grouped together, end file should be in 1 sheet, not separate sheets.
i will create 1 power power point and 1 excel sheet adding the equations
I need to extract data from multiple Excel files and visualize them in a separate sheet using line charts. This project involves: - Creating a separate sheet in Excel to display the data from several Excel files - Implementing a system to automatically update the data - Generating line charts based on the data Ideal skills and experiences for this project include: - Proficiency with Excel, including data handling and visualization - Experience with data extraction and integration - Expertise in creating and customizing line charts The project requires high attention to detail and the ability to work methodically with large datasets.
As someone looking to hire a talented content writer, I have a variety of assignments that'll involve writing content within a word limit of 500-1000 words. I didn't specify the exact type of content since the tasks may vary. However, a strong command of English and the ability to write engaging, quality content are essential. Ideal Skills and Experie...content since the tasks may vary. However, a strong command of English and the ability to write engaging, quality content are essential. Ideal Skills and Experience: - Excellent writing skills - Versatility in content writing - Ability to generate creative ideas - Experience in varying styles and formats of writing - Understanding of SEO is beneficial, but not required If you believe you would excel at this, I encourage ...
I'd like to request a quote for "xl heet and powerpoint".
