Excel vba project ideasprá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í.

datae

datae

mise en forme

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

Napraviti Excel VBA program

...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...

Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the migrati...

As someone juggling multiple responsibilities, I'm in need of a reliable an...flexible virtual assistant. Responsibilities: - Manage my schedule by coordinating appointments - Tackle basic administrative tasks as they surface - Likely will start with small tasks Requirements: - Fluent in English language - Available for less than 10 hours weekly - Excellent organizational and multitasking skills - Friendly and easy to get a long. - Communicates regularly - Able to offer ideas - Good with basic digital technology--Google, MS, Canva (would be great), Trello, etc. Previous experience in a similar role would be a plus. The ideal candidate should be able to prioritize tasks and work independently. I'm looking forward to finding a partner to help lighten the workload and...

I am looking for a video editor to edit our existing UGC footage into high-converting direct response video ads, for use across Facebook, Instagram and Tik Tok. I am looking for you to provide creative strategy / script ideation with customer research + direct response video editing (and sometimes using AI voice...provide creative strategy / script ideation with customer research + direct response video editing (and sometimes using AI voiceovers). Ideally we set up a process of 3-4 new videos per week. In summary, you need to: - Edit existing footage to create high converting video ads - Do audience research and craft scripts for creative video concepts tailored to our customers - Create new video scripts/ideas weekly Please provide some examples of the most recent videos you hav...

Answer the attached question correctly, and briefly explain. I'd like to learn the basic concepts and principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Key requirements: - Proficiency in networking, particularly subnetting Answer the attached questions, the provide table of ...like to learn the basic concepts and principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Key requirements: - Proficiency in networking, particularly subnetting Answer the attached questions, the provide table of the subnets correct answer with brief explanation wins Accepted file fo...

I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis,...professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a ...

I am seeking a skilled freelancer with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK...

I need a New York City themed T-shirt design to pair with our academy's logo. The main elements of the design should be either an Apple Style Tennis Ball or a NYC Taxi - I'm open to creative suggestions to really capture the essence of the city. - The design style is flexible, and I'm open to ideas. - For the Apple Style Tennis Ball, I'd like the ball to be red, inspired by the Big Apple. - If you choose to go down the nYC taxi idea you can use black and yellow - This design should attractively blend with our academy's branding and logo, so a good understanding of design layout and color theory is appreciated. - Experience with textile design or previous T-shirt design projects will be a plus. I'm looking for a design that's fresh, engaging...

...seeking a Python developer who can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of automation proc...

I need assistance with entering inventory data into Quickbooks Desktop from an Excel file. - I'm looking for a professional who has experience with Quickbooks Desktop. - The job involves bulk data entry, focusing specifically on inventory. - You will be provided with an Excel file containing the inventory data. - Attention to detail is crucial to ensure accurate and efficient data entry. Ideal skills: - Proficiency with Quickbooks Desktop - Experience with data entry, particularly inventory - Attention to detail and accuracy in data entry - Familiarity with Excel files and their import into Quickbooks

I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in ...Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on th...

I'm in search of a skilled content writer with a knack for crafting captivating narratives in an exceptional manner. While the type of content is unspecified at this time, it should be about 500 - 1000 words in length. As a freelancer, you should exhibit evidence of strong research ability, creativity, and command of the English language. Ideally, your portfolio will show...While the type of content is unspecified at this time, it should be about 500 - 1000 words in length. As a freelancer, you should exhibit evidence of strong research ability, creativity, and command of the English language. Ideally, your portfolio will showcase versatile and diverse writing that is both engaging and informative. I'm excited to work with someone who can bring new ideas and fresh perspect...

I'm in need of an architectural designer, expert in creating modern residential structures. My plan is for a two-story home and I'd love for it to encapsulate a modern aesthetic. Your tasks, should you be chosen for the job, will include: - Developing a comprehensive architectural plan that incorporates moder...vision into a stunning yet functional two-story residence. - Suggesting the best ways to utilize space and ensure the home is bright, airy, and spacious. Ideal skills and qualifications: - Extensive experience in residential architectural design, particularly modern aesthetics. - Understanding of efficient space planning and use. - Excellent communication skills to effectively translate my ideas into a coherent and captivating design. - Proven portfolio of si...

...patterns or graphics that stand out from typical designs - It should match our overall branding I have initial concepts but need them drawn into design templates that can be shared with manufacturers for sublimation printing Ideal Freelancer: - Experience with football kit design - A good understanding of color theory and design principles - Ability to come up with innovative and fresh design ideas - Good communication skills to understand and implement our requirements....

...informative style This project is only for one post. If you do well I'll hire you to write more posts. In total there are around 75 posts that we need to write. The budget for each post i 15 USD. I'm a wedding photographer but to stand out I'm composing an exclusive handbook for all my clients that goes through everything in preperation for a wedding. The handbook will be in Swedish since my clients are Swedish but you can write it in English and I'll translate it as I go through it. If you have recommendations on useful relevant posts, then I'm open for ideas! The topic for the first post will be either: - "Whom to invite and how to handle awkward situation" - The ultimate guide to how the groom should dress - How to execute a m...

I'm the author of an emerging fiction novel and currently seeking an imaginative designer who can help me craft a compelling book cover. I don't have specific concepts in mind yet, so your creative inputs are highly appreciated. Requirements: - Strong understanding of design elements suitable for fiction literature - Experience in book cover design is highly be...are highly appreciated. Requirements: - Strong understanding of design elements suitable for fiction literature - Experience in book cover design is highly beneficial - Ability to infuse warm color schemes (red, yellow, orange) into the design - Must be detail-oriented and receptive to feedback - Great communication skills I greatly appreciate your interest in this project and look forward to seeing your incr...

I'm looking for proficient freelancers who can effectively input both text and numerical data into Excel from physical documents. The task does not require any formulas or calculations, but attention to detail is crucial to ensure the accuracy of data. Key tasks include: - Manual entry of text and numbers from physical documents into Excel - Ensuring accurate data entry and quality checks Ideal freelancers should: - Have experience in data entry tasks, particularly with Excel - Be detail-oriented to ensure accuracy - Have strong organizational and time management skills.

I require the expertise of a part-time remote accountant who can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely...can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely and accurate manner. - Financial analysis: Monitoring, identifying and interpreting financial trends. The ideal candidate should have a good command of QuickBooks and Excel spreadsheets. Familiarity with these tools is crucial for performing tasks efficiently and a...

I am in need of a senior logo designer to create a unique, innovative logo for my healthcare project. The logo should be centered around the following elements and themes: - Elements: Caduceus and Heartbeat line - Colors: Primarily red, with the option to incorporate other complementary shades - Message: The logo should convey a strong sense of innovation Ideal Skills & Experience: - Proven experience in logo design, especially in the healthcare industry - A strong understanding of color theory and its application in branding - An ability to communicate complex ideas through simple, memorable visuals - Experience with creating logos that convey a sense of innovation - Familiarity with healthcare symbolism, such as the Caduceus and heartbeat line, is a plus.

I'm looking for an expert in Excel who can help me with applying conditional formatting and creating complex formulas that involve multiple conditions. Please watch this video for what i need Key Requirements: - Applying Conditional Formatting: The Excel file will require conditional formatting to visually represent data based on specific criteria. - Creating Complex Formulas: The project includes creating formulas that are not limited to basic arithmetic, and instead, involve multiple conditions. Ideal Skills and Experience: - Proven expertise in Excel: The ideal candidate should have a strong background in working with Excel and creating complex formulas. - Understanding of Conditional

I need an Excel expert to overhaul my current worksheet. Key needs include formula adjustments, data validation updates, and creating an interactive dashboard. The dashboard should boast the ability for graphical data representation, specifically bar charts, and customizable filters to view data from multiple perspectives. The right candidate will have extensive experience in Excel, knowledge of advanced formulas, data validation techniques and be proficient in creating interactive dashboards.

I'm looking for a talented animator to create a brief, 5-second intro for my YouTube channel. Key Requirements: - The intro should be animated in a creative and engaging style, capturing the essence of my channel's content. - It should include my logo in a prominent and aesthetically pleasing manner. Ideal Candidate: - Experience in creating animated YouTube intros is highl...Experience in creating animated YouTube intros is highly preferred. - Proficiency in utilizing animation software to produce high-quality and visually appealing content. - Ability to understand and translate the channel's theme/brand identity into the animation. Please share relevant samples of your previous work, particularly any animated YouTube intros you've created. I'm excited to see ...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

I'm looking for an innovative artist to craft a medium-sized wall piece (3-6 ft) that reflects our products in an abstract style. Ideal Skills & Experience: - Expertise in abstract art - Proven experience in creating medium-sized wall pieces - Knowledge in choosing suitable materials for wall...Proven experience in creating medium-sized wall pieces - Knowledge in choosing suitable materials for wall art as the client hasn't specified a type Responsibilities: - Conceptualizing and creating an abstract rendition of our company's products - Ensuring timely completion and quality workmanship - Advising on materials that best suit the project based on the artist’s expertise Note: The choice of materials is open for discussion. We are open to ideas...

I need a skillful and creative freelancer to create a pitch deck primarily purposed to present our business model and ideas to stakeholders. The focus should be on the following: - Concisely and convincingly communicate our unique business model - Highlight our direction as a learning platform The ideal freelancer for this job will have proven experience in designing professional pitch decks and a deep understanding of learning platforms. Knowledgeable in communicating business models clearly and effectively is a must.

Automated report using dashboard in Excel The report interface should be similar look to the pic attached. The Excel file for data source should be able to be used for Power BI. Two dashboards: 1- for multiple project management status reporting 2- for ad-hoc task management The data source is in an Excel sheet with a manual entry

...informative style This project is only for one post. If you do well I'll hire you to write more posts. In total there are around 75 posts that we need to write. The budget for each post i 15 USD. I'm a wedding photographer but to stand out I'm composing an exclusive handbook for all my clients that goes through everything in preperation for a wedding. The handbook will be in Swedish since my clients are Swedish but you can write it in English and I'll translate it as I go through it. If you have recommendations on useful relevant posts, then I'm open for ideas! The topic for the first post will be either: - "Whom to invite and how to handle awkward situation" - The ultimate guide to how the groom should dress - How to execute a m...

I'm seeking a skilled professional to enter 100-500 text entries for me. Key Responsibilities: - Entry of primarily textual data - Handling 100-500 entries Ideal Skills: - Proficient with Microsoft Excel - Excellent attention to detail - Strong typing and data entry skills. Experience in similar projects will be highly appreciated. I look forward to your bids for an efficient data entry task.

Necesito combinar un archivo excel que lo extraigo de un programa extranjero (1r archivo), y que debe añadir de otro archivo (plantilla proveedores) un dato para obtener una excel final (plantilla). El programa debe permitir insertar el archivo inicial, que consulte otro excel para añadir su CIF (el software es extranjero i no lo incluye) i transformarlo en el final (plantilla). Lo suyo sería, inserte archivo inicial, para extraer el archivo final

I'm looking for ...skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements...

As the owner of ABC Company, I am looking for an innovative logo that resonates with the essence of our brand. While I did not specify any essential symbols or shapes, applicants with a knack for coming up with original concepts are most welcome. The logo should incorporate a red, whit...specify any essential symbols or shapes, applicants with a knack for coming up with original concepts are most welcome. The logo should incorporate a red, white, and silver color scheme, radiating an aura of sophistication and professionalism. Modern design. Will be used on apparel, websites, and stickers Required skills and experience: - Proficient in graphic design - Able to brainstorm creative ideas - Excellent understanding of color theory - Previous experience in designing company logos is adv...

...Proficiency in design software - Proven experience in graphic design targeted at a retail audience Your job will primarily involve: - Understanding consumer needs and preferences - Crafting creative design elements that enhance user experience - Regularly communicating your design processes and ideas - Applying feedback for continuous design improvement Your previous work with retail customers will be a significant advantage for this project. Looking for a designer who can transform abstract ideas into compelling visuals. Please present your portfolio when bidding....

I'm looking for a talented content creator to produce engaging and high-quality videos for my YouTube channel. Key Requirements: - Video Type: The content will primarily consist of 5-10 minute videos. - Youtube Expertise: A good understanding of YouTube's standards, algorithms and trends is crucial. - Creativity: Ability to come up with fresh, interesting video ideas that resonate with today's audience. - Editing Skills: Proficiency in video editing software is a must. Ideal Skills: - Video Production - YouTube Marketing - Video Editing - Creative Writing - Understanding of the YouTube platform and its audience - Ability to create engaging content If you have a knack for creating compelling videos and understand the demands of YouTube, I'd love to hear from ...

2 pages of data sheet need to be recreated with zero mistakes and dito copy i am attaching the 2 pages i need to be recreated same to same, the top logo will change which i will provide you the screw picture and the text i am attaching with this for your review the sheets should be totally editable either make in word or excel or it should be edited in PDF the lowest quote below the price of $15 will be awarded the project thank you

When replying, reply with the text: "Forensic 4 Project" to be filtered from bot users We are looking for someone to go through around 50 accounts around 20 years timeframe for each account with experience in forensic accounting for loans, repayments and interests. Let us know when replying: 1) If you have any forensic accounting experience, if yes how many years 2) Which country's work you have done 3) If you have any experience on working on loans and which country 4) Any notable works you want to tell us about 5) Are you bidding as a freelancer or as a company, if company please share name and details 6) What qualifications you have? 7) If you have any experience in working in Singapore financial projects do highlight those as well. 8) What do you understand of ...

...Reels and animated content featuring our milkbag character. - Take the lead in brainstorming ideas and concepts for new animations. - Maintain a steady workflow to meet deadlines consistently. - Collaborate closely with our team to ensure the animations resonate with our brand and vision. Requirements: - Proficiency in animation software like Adobe After Effects, Photoshop, or equivalent tools. - A robust portfolio showcasing prior animation projects. - Ability to work autonomously and drive creative initiatives. - Excellent communication skills and a collaborative mindset. - Meticulous attention to detail and a knack for humor and narrative. - Knowledge about cryptocurrencies and trading. Example Project: Check out the Instagram Reels by Ponkesol () to

I need a dedicated professional to assist with a crucial data entry project. The work involves: - Encoding textual data sourced from digital documents. - Delivering accurately encoded data into an Excel spreadsheet. This task requires keen attention to detail to ensure the absolute accuracy of the data entry. The ideal candidate must have extensive experience handling textual data and an aptitude for meticulous data entry work. Proficiency in Excel and working with digital documents is also vital.

I have a data transcription and cleaning/validation project that requires a skilled individual. All data will be provided in Excel and PDF formats. Key Responsibilities: - Transcribing data accurately from multiple sources - Cleaning and validating the data to ensure accuracy - Working primarily within Microsoft Excel Skills/Experience Required: - Proficiency in data entry, transcription, and data cleaning - Strong command over Microsoft Excel - Attention to detail and accuracy are key I am looking for a detail-oriented individual with relevant experience to help me complete this task efficiently and accurately. Please include examples of similar projects you have completed in your proposal.