Vba work excel spreadsheet işler
I am looking for somebody who can help me complete one of the excel course on cousera and share the certificate with me. This course requires very good knowledge of excel. This course id divided into 5 weeks, every week has 8- 10 videos followed by small quiz and in the end there is another quiz and one assignment. If you are very good with excel then this course should not take more than couple of hours for you to complete. I am looking for somebody who can complte this tasks with coulple of hours and share the certifictae with me. The name of the course is Excel fundamentals of Data Analysis.
I am in need of a competent spreadsheet developer, preferably with a strong command of both English and Spanish, to assist me in creating a Short Term Rental (STR) financial spreadsheet. Here are the necessary specifics: - The Monthly Spreadsheet Template is not complex, but it must incorporate revenue and especially expense categorization elements and typical Profit & Loss calculations in both US Dollars (USD) and Colombian Pesos (COP) along with published Government/Bank Rates for USD and COP on a monthly basis that will be distributed for operational comment and management of the business. - The Quarterly Spreadsheet Template provides a Financial Summary Report of the relevant Quarter and that provides the financial input for a Quarterly Report Recon...
...automating various tasks within Excel. Details and finer element scopes will be discussed once collaboration commences. To save time and streamline the processes, I am primarily interested in automating data extraction, manipulation, and validation. To apply, please showcase: - Your past work experiences related to Excel automation - The range of your professional expertise and skills - A comprehensive project proposal detailing how you'd approach this unique project, including a rough timeline and any resources you might require Essential Skills: - Proficient in JavaScript, specifically within Excel - Strong comprehension of data extraction, manipulation and validation - Proven track record with similar tasks/projects. The ultimate goal for me i...
I need someone who is savvy in Excel and spreadsheets. My project involves the following: - Analysis and creating reports from a myriad of data sources which are of medium complexity. - Formulating and implementing functions to streamline the data analysis process. - Design and formatting of the spreadsheet is vital as I'm looking for a complex workbook setup with multiple tabs. -Creating metrics with sales, operation and payroll data The ideal candidate should have proficiency in data analysis, formula creation, and spreadsheet design. A keen eye for detail and the ability to handle complexities will also prove beneficial for the completion of the project.
I am seeking an Excel expert capable of preparing a comprehensive document comprising more than 10000 rows and columns. The scope of the project involves processing substantial data sets, namely: Organizing Scanned documents and extracting the data, organizing the data in different corporations by department and years. Be able to extract a P/L and AR for all companies. Project is to be done in stages - Text - Numerical data - Date Information The ideal candidate for this job should have: - Expert knowledge of Excel and related functionalities. - Strong attention to detail. - Proven experience of data entry in large volumes. - Familiarity with basic mathematical operation functions within Excel. The deliverable will be a well-structured Excel document cr...
I'm seeking a proficient freelancer able to extract mixed data (numeric and textual) from JPEG images and transpose them into Excel. The data is organized within a tabulated format. Ideal Skills: - Competent in OCR tools usage - Proficient in Excel - Detail-oriented and accurate data entry - Capacity to interpret tabulated data from images Professionals with experience in converting visual data to spreadsheets will be highly desired. An ability to deliver high-quality and accurate work within the agreed time frame is a must.
I require a skilled data entry specialist to handle an Excel sheet that involves the aid of typing in a combination of different data forms: Numbers, Text, and Dates. - The sheet you'll be working with houses 10 - 50 columns and rows, so attention to detail is paramount. Ideal skills include: - Excellent knowledge and experience in Excel - Ability to accurately and swiftly handle data entry - Proficiency in handling multiple data types This project focuses strictly on data entry alone and does not require any data analysis skills.
I need motion graphic help with two less than 1 minute clips. The work consists in adding a company logo (provided) to a tv screen recorded while subjects move in front of it. The second clip is about the same but instead of a tv it's a wall so the logo should have some 3D depth. Please include examples of similar projects in your proposal. Thanks.
I require a skilled data entry specialist to handle an Excel sheet that involves the aid of typing in a combination of different data forms: Numbers, Text, and Dates. - The sheet you'll be working with houses 10 - 50 columns and rows, so attention to detail is paramount. Ideal skills include: - Excellent knowledge and experience in Excel - Ability to accurately and swiftly handle data entry - Proficiency in handling multiple data types This project focuses strictly on data entry alone and does not require any data analysis skills.
...looked up from a Table within the same document. Here's a bit more about what I need: - You will need to create a system where the embedded values are updated automatically whenever the source Table changes. This should occur without the need for manual intervention. - I highly value clear, precise work and would like to see detailed project proposals outlining your approach to this task. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant should demonstrate an understanding of Word functions, automation techniques, and table editing. In a nutshell, I want a system where I don't have to manually change numeric values within the t...
...functioning in the tech industry. The successful candidate will be primarily charged with: - Managing scheduling and calendar appointments - Handling Emails and other forms of correspondence - Performing data entry and general organizational duties Ideally, the associate should have proficiency in the following tools: - Microsoft Office Suite, with a particular emphasis on Word, Excel, and PowerPoint - Available to work in APAC time zones Prior experience in the tech industry is a key requirement for this role as it will help streamline the onboarding process and ensure the associate quickly fits into our operations. A firm grasp of tech industry terminology and workflow would also be advantageous. Overall, a well-organized individual with strong communication skills...
As a seasoned professional, I'm seeking assistance for an important task — improving an existing analytical tool in Excel using Power Query. This tool currently partially functions but needs some notable improvements. • Existing Database: I have all the static information ready. The data is spread across five tables, which you need to account for. • Enhancement Focus: The following areas need fixing & enhancement: 1. Data Visualization: Current graphics aren't illustrating the data as lucidly as I'd like. 2. Processing Speed: The tool is very sluggish and its speed should be optimized for efficiency. 3. Data Entry & Management: I'm seeking improvements in data entry protocols and general data management procedures. 4. Tak...
...medical devices for vulnerable populations. As our EVA, you will be at the forefront of operations, tasked with not only executing administrative duties but also crafting and implementing Standard Operating Procedures (SOPs). Your ability to create and refine SOPs will be instrumental in streamlining our processes and maximizing efficiency. Clear communication is key in this role. You will need to excel in conveying information effectively via email and know precisely when to escalate matters to a phone call for swift resolution. Your knack for concise and articulate communication will ensure seamless collaboration across our team. In addition to SOP management and communication prowess, you will leverage AI tools and platforms like Recurpost, Typeform, Pandadoc, and Asana to ...
I have ongoing work related to our previous project '"Day of Giving" Charity Poster Design'
I am in need of a skilled data entry specialist to assist with several specific tasks: - Data input - Data verification - Data cleansing This project will deal with a small volume of data, up to 1,000 records. I will provide the data in digital formats, such as Excel or Word documents, so adeptness in working with these platforms is crucial. Understanding of data accuracy, attention to detail as well as discretion for the sensitive nature of information that will be handled is also key for a successful partnership. Experience in data cleansing practices will be highly advantageous in the desired outcome of this task. As we embark on an exciting data organization project, I look forward to engaging with dedicated and meticulous individuals.
I need someone to swiftly develop a competency framework template for me. This template should be designed in Excel, with semi-automation features. Key parameters that need to be incorporated include: - Technical skills, specifically Data Analysis - Soft skills - Leadership qualities Moreover, the semi-automation of the spreadsheet should entail: - Automatic calculation of scores - Conditional formatting based on scores - Data validation for input fields This project is on a tight deadline. It needs to be completed two to three hours after being awarded. Ideal freelancers will have experience in Excel automation and an understanding of competency frameworks. Please bid with this in mind. 1. Populate the columns highlighted. 2. In the column labelled Score, use...
I'm looking for a skilled freelancer with expertise in data entry, specifically with regard to numerical data. This project will involve: - Entering numerical data in Excel in the format of percentages. - Organizing entered data in numerical order. - Strong attention to detail to ensure accuracy of data entry. Experience with Excel and data entry will be highly appreciated. An understanding of numerical data formats, specifically percentages, is needed for accuracy. The freelancer should also be well versed in structuring data in numerical order in Excel spreadsheets.
...proposals from experienced web developers or teams for a specialized project on our WordPress-based charity foundation website. The project involves a one-time bulk upload of volunteer information from a spreadsheet, which will automatically create individual volunteer profiles. A critical aspect of this project is ensuring that the URLs for these new profiles are user and SEO-friendly, adhering to our existing permalink structure as illustrated in the provided screenshot of an active profile. Key Requirements: Data Upload and Mapping: Expertise in processing a one-time bulk upload from a spreadsheet, with fields including first name, city, state, zip code, email, phone number, profile photo URL, and badge image URLs. The process must ensure accurate mapping to our websi...
As the creative mind behind Chromatoons, I'm searching for a skilled character designer, experienced in crafting cartoonish sty...Conceptualizing and drawing characters of the Chromatoons universe - Consistent communication and collaboration to refine and finalize designs based on feedback The ideal applicant should: - Be proficient in various graphic design software - Have an impressive portfolio showcasing cartoonish character designs - Understand the interests, aesthetics, and expectations of a teenage demographic - Excel in creativity, and possess a keen attention to detail A deep passion for cartoons and a familiarity with teen culture will be significant advantages in this project. If whimsical worlds and cartoony characters are your forte, I welcome you to bring Chrom...
This project involves entering numeric data into an Excel spreadsheet. I have 100-500 entries that require careful and precise entry. To successfully complete this task, here is what I am looking for in a freelancer: - Attention to detail: Accuracy is imperative in this project. - Expert skill level in Excel: You must be able to efficiently navigate and operate Excel. - Experience in data entry: Knowledge in numeric data entry would be an advantage. I am on a tight schedule, so timeliness and dedication to the task are much appreciated.
I’m urgently looking for an Excel wizard who can efficiently categorize 80,000 products in an Excel file. The categorization will be based on product category. You will be required to: - Be meticulous in ensuring the accuracy and consistency of product categories - Complete the task as quickly as possible The best fit for this project would be someone who's detail-oriented with strong Excel skills and experience in product categorization or data entry projects. Speed and accuracy are paramount in this task. Looking forward to whoever can deliver this ASAP.
I am in need of an experienced freelancer who can assist with a data entry task. The work primarily involves data entry into Excel, and I'm looking for someone who can input data accurately. Key details: - The source of the data will be directly provided by me, and you will need to enter this into Excel. - The data provided will be unstructured and in varying formats. Therefore, your proven ability to navigate and organize unstructured data will be of critical importance. Skills and Experience: - Proficient in Excel: You should be a pro at entering and organizing data in Excel. - Experienced with unstructured data: I need someone who won't be discouraged by different data formats and can effectively manage and structure disorganized data....
I'm seeking a meticulous freelancer proficient in data entry to assist me with my project. Your responsibilities will includes: - Data Input: Extract...meticulous freelancer proficient in data entry to assist me with my project. Your responsibilities will includes: - Data Input: Extracting information from PDF files and accurately inputting into an Excel Spreadsheet. - Speed & Accuracy: The task demands both speed and precision, thus you need to be well versed in working with PDFs and Excel. Ideal Skill Set: - Proficient in Microsoft Excel - Strong data entry skills with attention to detail - Experience with handling PDF documents - Consistency in meeting deadlines Please provide samples of previous work you've done with data input fro...
...Scraping text content and images from a test website. - Ensuring the data is accurate and comprehensive. - Organizing scrapped data in an Excel spreadsheet or a csv file. Keen attention to detail is critical. Applicants with prior experience in web scraping, data extraction, and data management, who are comfortable with Excel functions, will be ideal for this project. Please bid on an hourly basis for your time and explain who you will charge by the hour. I'm assuming that you will need to set up the scraping tool, which might take some time, then do the scraping itself from about 1,000 website pages, and then make sure the data is correct in the excel spreadsheet (or csv). Please share what tool you will use and if there is any additional cost ...
I'm in need of a dedicated individual with knowledge of the Tamil language to assist with entering numerical data for my specific project. Your tasks will include: - Inputting the provided numerical data accurately - Sorting the entered numerical data chronologically The ideal freelancer for this task should: - Have a remarkable attention to detail to ensure data accuracy - Have a proficiency or at least a basic understanding of the Tamil language - Have experience with data sorting tasks, particularly chronologically. Your job would contribute significantly to the smooth running of my project, your input would be greatly appreciated.
I am in need of essential software development for lead finder with key functionalities for my Python project. Ideally, you possess: - Proficiency in Python programming language - Extensive experience in providing suitable development tools I need tools that encompass: - Code editing for efficient development - Version control to monitor co...Feature 12. Track which leads are actively running paid ads on Facebook/Messenger/Instagram or Yelp New Feature 13. Detect Leads Email Provider Detection - ie Google Apps, Outlook. Zoho etc. New Feature 14. Track which leads are using Facebook Pixel or Google Remarketing 15. Find Worldwide Leads 16. Detect if business website is Mobile Friendly or uses Google Analytics/Schema/Wordpress etc 17. CSV/Excel/PDF/Print Export Options 18. Paymen...
...seasoned Excel expert who can effectively assist us in cleaning up a medium-sized data set of 1,000 - 10,000 rows. The data is relatively simple with few columns but requires some attention to detail nonetheless. The ideal candidate should: - Be experienced in removing duplicates from data sets. - Possess skills in formatting data to enhance readability and accessibility. - Have solid competency in filtering data to focus on relevant information. These three skills are crucial as we work towards having a clean, seamless, and usable data set. Accuracy, efficiency, and the ability to pay close attention to detail will be key in the potential freelancer. This is a task that requires a deep understanding of Excel functionalities coupled with practical experience in da...
I'm looking for a Wordpress expert to seamlessly incorporate two key functionalities into my website - Fluent Forms and Fluent CRM. The main aim is efficient and effective customer relationship management. On May 1st I'm launching a directory where I list all IT providers in Switzerland. I have all the providers in an Excel CSV. Before the launch, I would like to send the IT provider a link so that they can check their data and add additional information. As soon as you have done this, your entry is verified and will then be marked separately in the directory. Requirements for the pre-launch IT provider profile verification. - I would like to send the IT provider directly a link to his profile or if he goes via the website he should have the opportunity to enter the co...
I need assistance with a basic Excel data entry task. This work will encompass activities such as copy-pasting and sorting data. The volume of data is not overwhelming, with just a few hundred entries to be managed. Ideal candidates for the job are experts in Excel and have a knack for meticulousness and swift data entry.
Hello. I have some Excel Sheets whereby I have some tables in them. I want to protect the sheet. However, when I do so, I notice that I cannot add additional rows to my tables. I need to be able to lock my sheets and add additional rows to my tables when I need them. It is worth noting that I am also copying data from one table to another on a separate sheet sometimes. I want someone to solve this problem for me, and make me a small video to show me how to do it. I need it explained in perfect English in a way that I understand. In simple terms. I am not a coder or anything like this. Although I am good at using Excel. I made a video for you to check, it is a short video. I have the link on the pdf document.
Use tripadvisor ( ) website and find and build a list of 20 Restaurants who are good for meetings in New York City. We need the following information fields in an Excel File or in a Google Spreadsheet: Restaurant Name Website Address Phone Number Email Address and How many reviews they have.
I need a professional who can modify 6 PDF stickers to replace its existing text. Here's what is required: - Change the description below the image to say 'Decorative Wax Melts'. - The change must replace the existing text entirely. - You'll need to find a matching font that closely resembles the original. For this project, you will need excellent attention to detail, and experienced skills in PDF editing and typography will certainly advance your chances here. PLEASE SEE WHAT IS REQUIRED IN PICTURE. I can only supply you with the PDF document, I'm sorry, no AI
For this project, I'm in need of a professional who is proficient in R Studio to undertake tasks in data cleaning, preprocessing, statistical analysis, and data visualization. Here's a bit more about the job: Specific Tasks: - Start with cleaning and preprocessing structured data, which happens to be in a spreadsheet. - Apply your statistical analysis skills to garner valuable insights from this dataset. - Craft clear, compelling data visualizations that highlight the main findings. Results should be compiled into a succinct yet thorough written report, showcasing the insights you've derived from the analysis in a clear and understandable manner. Ideal Skills: - Proficiency in R Studio - Strong statistical understanding - Ability to create insightful data visualiza...
I am seeking an individual with proficient skills in Excel and a keen eye for detail. Your main task will be translating handwritten documents containing text, numbers, and dates into formatted Excel spreadsheets. This will require: - Accurate data transcription from handwritten documents into Excel - Filling out more than 20 columns and rows per sheet - Proofreading and immediate correction of errors The ideal candidate should have extensive experience in Excel and data entry, plus superb attention to detail. Knowledge and practice in inputting handwritten data would also be beneficial. Make sure to include any relevant data transcription experience in your proposal.
I need to extract a list of 500+ stores from an online directory. The structure of the directory is: - A home page with a long list of stores. You can see the name of each store. If you click on a store, you will be taken to that store's page. - Each store has its own page in the directory. This page contains lots of data about the company. This is what needs scraping. Key Deliverables: - Excel or CSV file containing contact data for each store Data required to be extracted (if found on the page): - store name (this is the store's name, separate from company name) - store company name - store website URL - store Facebook page - store telephone number - store email - store Introduction paragraph - google maps link - opening hours IMPORTANT: You must ensure accuracy of t...
I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...
I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...
...you only have experience working with e-commerce brands DO NOT APPLY. We are specifically looking for a Google or Facebook ads manager who has worked with local businesses before. The type of business is not necessary as long as it is a brick-and-mortar company. About the Job: We’re looking for a rockstar Google or Facebook ads manager to work with us and deliver amazing results to our clients. As our Google or Facebook ads manager you will work with us on per client basis and be responsible for the following tasks: *Setting up and launching Google or Facebook campaigns *Setting up retargeting pixels, custom conversions etc. *Daily management of Google or Facebook campaigns once they go live *Build & A/B test high-converting landing pages. * etc, etc Requi...
I look for assistant from India who will be responsible with finding suppliers, finding new items , preparing catalog and take CARE of the order. We require expierience in sourcing , Excel knowledge and negotatiation skills.
I'm seeking a skilled writer to create brief yet engaging articles centered around work-life balance, leadership, and health. The content will be posted weekly on a LinkedIn business profile. Job Requirements: - Expertise in creating relatable and captivating content - Experience in writing for LinkedIn platforms - Comfortable writing short 500-1000 word articles - Ability to produce material on a weekly basis - Knowledge or keen interest in the areas of work-life balance, leadership, and health By bringing these disciplines to life through your words, we can engage our current followers and attract new ones. I look forward to seeing your portfolio and discussing how we can work together to meet these project goals.
I have a specific ACCDE file that needs expert attention. The required tasks for the freelancer include: - Customization of forms and reports in the ACCDE file. This ACCDE file has forms where users...expert attention. The required tasks for the freelancer include: - Customization of forms and reports in the ACCDE file. This ACCDE file has forms where users can input the data, I would like to export this data into excel/csv or SQL (whichever is conviniant) - Current challenge is, unable to look at the VBA code or export full columns how in the form. The ideal candidate has extensive experience with MS Access, specifically in the customization of ACCDE files and data exportation. They should have in-depth knowledge of form and report design as well as MS Access to Excel...
I'm aiming to augment my current Skyline Chart, hosted on Microsoft Excel, by including filter slicers and a timeline functionality. This will provide interactive filtering options, visualize data over specified periods and enhance overall user experience. I'd prefer a freelancer with a strong handle on VBA and data visualization in Excel. You'll be dealing with contract and procurement data, hence, prior experience in this area would be advantageous. Tasks include: - Incorporating filter slicers into the existing Skyline Chart - Adding a timeline which fits the current design - Ensuring both new elements accurately represent contract and procurement data
I'm seeking an experienced freelancer to construct a comprehensive Excel worksheet. This worksheet will be used to calculate and compare around 10,000 individual assets with different inservice (depreciation start dates). The assets i specifically am looking at are called SUBbase assets and used in Road construction. We currently have asset lives of around 150 years but wish to compare this life with a variety of years 200/250/300/350 and 400years. Possible different years so needs to be able to amend lives and compare against original. I am looking at having something design that can give comparisons against the original live (which ive highlighted in yellow). The file attached has a large amount of data alot of which isnt necessary The columns in yellow are what you wil...
I need a VBA macro expert to automate repetitive tasks in Excel. Specifically, the focus is to build a macro that will update data from multiple database systems, pulling all necessary data and accurately updating the Excel file. The requirements include: - Deep knowledge in Excel VBA and macros. - Extensive experience in dealing with database systems. - Attention to detail to ensure valid and accurate data updating. - A solution-oriented approach to identifying potential issues with the automation. The ideal candidate will have a proven track record in creating VBA macros that interact seamlessly with various database systems. They'll bring efficiency and reliability, turning the repetitive updating process into a seamless, automated one.
I am in need of a proficient Excel automation specialist. This job requires updating an existing workbook with new data, automating the creation of rows, columns, and formulas and allowing for an undated workbook to be downloaded without having to re-create all the formulas etc. I am open to the choice of programming language used for the Excel automation, eager to discuss your expertise and preference. Here are the expected tasks: - Modify an existing workbook with new information - Automate the import of current workbooks - Automate the creation of rows, columns, and formulas The frequency of these tasks will be dictated by our data download schedule which is done on an as-needed basis per job schedule. Ideal candidates will have a solid background in Excel automat...
I have ongoing work related to our previous project 'Comprehensive Photo Enhancement for Social Media'
