Advanced excel vbaprá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...
...odnosno scripta ( radi se o samostalnim izrađenim plugonovima odnosno skriptovima) koji se samo instaliraju: 1. 2. 3. 4. 5 Molim za ponudu št opre. Pozdrav...
Hello, I am currently looking for an excellent developer wh...versed in at least any one of the following fields: Java, C#, Golang, Rust, JavaScript, Python, solidity, web3, blockchain, web frontend and backend. Of course, he must be prepared to work with us long term, more than 40 hours per week. You must be geographically located in Europe or the Americas, be able to work at least 6 hours EST day time, and possess written/verbal English skills at an advanced level or higher. In order to select excellent talents, you will need to anticipate a 30-60 minute technical interview with a project manager in our team. Dont worry. We need at least 3 developers. Expected salary range is $15-$25/hr depends on experience. Please feel free to send us applications embroidered with your prou...
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...
...enhance energy efficiency and environmental management. Ideal Freelancer Qualifications: - Proven experience in IoT device development, preferably within an industrial setting - Familiarity with MQTT, AWS, LoRaWan and Dataloggers - Proven track record in energy and environmental management - Ability to deliver accurate, property-level data precision. - Full PCB layout, design and development Your advanced skills and experience in IoT developments will be pivotal in the success of this project. Let's revolutionize industrial process control together! To start the project and share the confidential materials we have, we require the signing of an NDA and we need proof of identity. Therefore, we would appreciate, if you please provide a photo ID and If representing a corpora...
For my interior design project, I'm seeking an effective designer experienced in SketchUp to deliver a high-detail rendering. Higher quality textures, advanced lighting, and realistic shadows are the key expectations for this assignment. Ideal freelancers should have: - Profound experience with interior rendering in SketchUp - Proficiency in producing high detail work - An impressive portfolio showing previous advanced work It's crucial for candidates to be able to communicate effectively and meet deadlines, as well as handle any revisions that may arise.
...establish an engaging, efficient, and user-friendly online store specializing in women's products. The platform should not only be aligned with the GCC market dynamics but also leverage cutting-edge e-commerce strategies to ensure seamless user experiences. Key Responsibilities: - Debunk complexities of setting up an online store from scratch. - Infuse the platform with user account registration and advanced search functionalities. - Build an easy-to-navigate size chart for each clothing product. - Develop multiple website sections for different product categories. Ideal Skills and Experience: - Extensive experience in e-commerce website development and the GCC market. - Proficiency in user interface design, user experience (UX) techniques and strategies. - Experience in ...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO
I am seeking a skilled image editor to help me create a photo that gives the illusion of me having a twin. Need done ASAP Key Details: - Utilize Photoshop or other advanced photo editing tools to merge my face with another person's face. - The second individual's face will be provided by me. - I am open to suggestions for the final setting or background of the photo. Ideal Skills and Experience: - Proficiency in Photoshop or equivalent software, with experience in advanced photo editing techniques. - A creative and imaginative approach to merging two faces convincingly. - Strong communication skills to discuss and propose suitable background settings for the photo. Please share your relevant portfolio to showcase your previous work in image editing and manipula...
As the key administrator of this program, I need: - A well-built Desktop application that refines the way barrel racing tournaments are managed. - Comprehensive functionalities to set up and manage tournaments, effectively track individual participants, and simulate races. - A mechanism to record and sort race times—ranging from fastest to slowest—post-race. This should seamlessly transition into forming divisions or groups. - An efficient system to perform random draw assignments for participants across different race categories. - Automatic placement population after the times are sorted and standings are finalized. - Accurate computation and allocation of prize winnings at the end of each race. Ideal freelancers for this project should be equipped with strong programming ...
I'm in need of an individual with advanced expertise in Linear Algebra and R programming. Your critical role will encompass: - Solving complex linear equations - Matrix manipulations - Implementing statistical analysis Skills and experience sought: - In-depth knowledge and experience in Linear Algebra and R programming. - Proven ability in solving complex equations and matrix manipulation. - Experience in statistical analysis using R. - Dear skill and background in integrating R programs with other software. The specialist I'm seeking should be able to critically solve problems and integrate solutions with existing software. Ultimately, the aim is to achieve efficient results through advanced linear algebra and R programming.
I require an experienced tutor who can help me both maintain and make adjustments to the Asana, Zapier, SMS and Email automations currently in use within my business. Your responsibilities will include: Asana Adjustments: - Setting up new integrations as necessary - Advancing current workflow for better productivity - Automating tasks to streamline processes Zapier Adjustments: - Configuring new integration setups - Enhancing the existing workflow - Trouble shooting any automation issues Ideal skills: - Proficiency with both Asana and Zapier applications - Experience with SMS and Email automations - Strong problem-solving abilities - Excellent teacher with the ability to breakdown complex concepts.
I am looking for an experienced web developer to work on an exciting project with our team. We aim to build a specialized flights meta search engine website targeted towards budget travelers. This platform will be focused on providing a unique and efficient way to find niche flights. Key Features: - Advanced search filters: The website should offer a variety of filters to help users tailor their search and find the most relevant flights. - Price comparison functionality: An essential feature for budget travelers, allowing them to easily compare prices of flights. - User reviews and ratings: An interactive section where users can share their experiences and rate flights, enhancing the overall user experience Target Audience: The primary target audience for this platform will be bud...
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
...should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the given fr...
I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I'm seeking a dedicated profession...Given the volatile nature of cryptocurrency, up-to-the-minute market data is essential. You will incorporate this feature into the platform to assist traders in making well-informed decisions. - Secure transactions: With the platform targeting seasoned traders, it's expected that large volume transactions will be commonplace. Making these transactions secure will be of utmost importance. - Advanced charting abilities: To help traders make informed decisions, the platform also needs superior charting capabilities. You should be able to provide these capabilities, allowing for in-depth analysis of market trends. Not only should you meet these criteria, but a track record in creating similar platforms will put you at the top of the lis...
I have a photo of a person wearing a red dress. I need the dress to be photoshopped and changed to a black suit. Key requirements: - Replace the red dress with a black suit. - Ensure the change appears seamless and natural in the photo. Ideal Skills and Experience: - Proficient in advanced Photoshop editing. - Experience in clothing alterations and photo retouching. - Attention to detail and ability to produce realistic results.
...connections. **Project Objective:** Our goal is to develop a dating platform similar to , where users can interact with AI-generated profiles and engage in compelling and empathetic conversations. The platform must be able to charge users for private content and promote genuine emotional connections through interaction with AI. **Key Features:** 1. **AI-Generated Profiles:** We will use advanced AI generation algorithms to create profiles of virtual girls with whom users can interact. 2. **Empathetic Chat:** The AI will be capable of conducting empathetic and engaging conversations with users, creating an authentic and rewarding experience. 3. **Monetization:** We will offer users the opportunity to access premium and private content for a fee, ensuring a sustainable and profit...
I'm looking for a skilled 3D artist to create a high-quality recording studio asset using Blender. The asset should be highly detailed, featuring advanced textures and lighting. Key Project Requirements: - 3D Modeling Software: Proficiency in Blender is essential. Experience in Maya and 3ds Max would be a plus but not required. - Level of Detail: The asset should be highly detailed, with advanced textures and lighting. - Specific Elements: The model should include a mixing console, monitors, microphones, instruments, soundproofing, and acoustic panels. Ideal Candidate: - Proficient in 3D modeling and texturing. - Experience with creating high-detail assets. - Knowledge of lighting techniques in 3D rendering. - Prior experience with creating recording studio assets woul...
I am in need of 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 ...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
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 looking to hire an experienced web developer to create a website that caters to professionals. The main goal of this...they are looking for. Target Audience: The target audience for this website is professionals. It is vital that the design and functionality of the website can cater to the needs and expectations of this demographic. Ideal Skills and Experience: - Proficient in web development and design, with a strong portfolio of similar projects - Experience in developing user registration and login systems - Advanced knowledge in implementing search functionalities - Understanding of user experience principles, particularly in relation to professional audiences - Strong communication skills to understand and interpret my vision and requirements. Ask me for the scope...
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 seeking an experienced video editor for a project that involves editing TikTok videos. The primary aim of the video is for entertainment. Key Responsibilities: - Utilize skills in color correction, effects, and motion graphics. - Ensure a high-quality final product that is visually engaging and polished. Ideal Candidate: - Has a strong background in advanced video editing. - Proficient in using tools for color correction, effects, and motion graphics. - Prior experience in delivering engaging content for entertainment purposes.
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...
...designed for advanced and experienced divers who are looking for a unique and thrilling experience. Marketing Strategies: - We are currently utilizing social media advertising, email marketing campaigns, and search engine optimization. We're looking for a professional who can enhance our current strategies or offer new, innovative ideas. Tour Features: - Our scuba diving tours offer a range of exciting activities including wreck diving, night diving, and coral reef exploration. Your understanding and appreciation of these activities will be crucial in your marketing efforts. Ideal Freelancer: - Prior experience in marketing scuba diving tours or adventure travel would be a big plus. - Deep understanding of the scuba diving community and the ability to engage with adva...
2 excel files with VBA macro as per customer requirement
I'm looking to have my ...have my existing webpage refreshed. Specifically, I require: - A complete design update, revamping the layout for a contemporary and intuitive feel. Although I haven't specified a layout style, I'm open to suggestions. Creativity and a keen eye for design are crucial for this project. - Adding new functionalities that will improve the web page’s overall performance and efficiency. Expertise in advanced web development and understanding of the latest technologies is necessary. Your proposal should demonstrate your experience with web design and functionality improvements. In addition, portfolio samples showcasing similar projects would be highly beneficial. Overall, I'm seeking a freelancer capable of transforming the user experi...
...branching out into the event marketplace. My vision is to create a user-friendly platform that caters to everyone, disregarding their age or professional background. I am looking for an exceptional UI/UX designer who has a commendable portfolio and prior experience in creating distinctive and interactive designs. Specifically, the website should incorporate: - User Registration and Login system - Advanced search and filter mechanism for seamless navigation - Capability to list and provide details about the various events In terms of aesthetics, I'm leaning towards a calm and grounded visual experience. Hence, a design utilizing neutral and earth tones would just be perfect. Our model design is essentially like Airbnb. The ideal candidate for this position would have exce...
I need a professional editor with advanced expertise in epidemiology to help with editing a scientific article. The task involves a comprehensive spell-checking, anti-plagiarism review, text structuring, and abbreviation verification. Key Responsibilities: - Comprehensive spell-checking: Ensuring that the text is free of any spelling errors. - Anti-plagiarism review: Verify the originality of the content and eliminate any possible infringements. - Text structuring: Help in restructuring the article to enhance its readability and flow. - Abbreviation verification: Double-check the usage of abbreviations and ensure they are accurate. The main goal of the editing process is to ensure the scientific accuracy and coherence of the article. Therefore, it is crucial that the editor has a...
...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 modelli...
I'm seeking a talented video editor who is experienced in advanced video editing. With a solid understanding of color correction and grading, this person should be fluent in Arabic. The task includes working with footage from a single personal event, and transforming it into a high-quality, captivating video that tells a compelling story. Ideal Skills: - Advanced video editing - Experience with personal event videos - Arabic fluency - Colour correction and grading expertise - Proficient in storytelling through visual media This is an opportunity for you to showcase your skills in creating memorable videos from singular, unique life events. Your expertise will bring these moments to life, creating a lasting impact.
For the game Dead by Daylight, I would like someone to create an equalizer to isolate the sound of a specific character, and amplify that sound so its easier to hear. The sound is comparable to breathing but is more like a distinct grunting sound. At the same time, I would like the equalizer to decrease the sound of the ambience/ chase music to make the sound st...music to make the sound stand out even more. There will be 3 different equalizers, with 3 different sounds at the base. The end goal would be 3 files for peace equalizer I can download. I will provide all the input, so I can send all the audio files required to make the EQs. Looking for a developer who knows how to utilize programs to translate sounds into Hz ranges & into eq's + ideally other advanced techniques ...
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 an experienced Laravel developer to integrate and manage the database for my existing project, www.getyourhomes.in. The task is not only basic CRUD operations but also extends to admin panel updates and AJAX call filters. - Database Management: You should be adept at advanced database management with stored procedures, triggers, and optimization. - Language Proficiency: Strong language skills in either Bengali or Hindi is essential. Your role would be crucial in improving the functionalities of my project. Prior experience in similar projects would be a bonus.
...was to analyze a system. I need this part to be refined and improved upon. - Improvement of Data Analytics Charts: The original data analytics charts were created using Microsoft Excel. These need to be redone with more finesse and potentially using more advanced tools and techniques. - Text Revision: The text accompanying the project needs to be revised. This includes ensuring that the text is clear, concise, and well-structured. Ideal Skills and Experience: - Proficiency in simulation design and refinement - Strong background in data analytics and visualization - Experience with creating charts in Microsoft Excel - Ability to edit and revise technical texts Please note that the original project is available in PDF form, containing all the solutions, which can se...
