Excel vba tips and tricks pdf jobs
...building and we need proper professional spreadsheet done with ( cash in flow and cash out flow. . It should encompass data on sales, expenses, and profits, analyzing trends and variances, while also incorporating a break-even analysis. Key Requirements: - In-depth monthly analysis of sales, expenses, and profits. - Solid experience in applying trend analysis. - Capable of conducting variance analysis. - Skilled in implementing break-even analysis. - Previous experience in creating comprehensive business financial forecasts. The end goal of this project is to have a detailed yearly overview of my business's financial health, with a focus on identifying trends and outliers, and ensuring our financial strategy is aligned with our ...
I'm looking for a freelancer who can gather and organize data in Excel for me. This will involve gathering specific data, creating an Excel spreadsheet and providing a basic summary of the data. Key responsibilities: - Organizing data in an Excel spreadsheet - Creating basic summary Ideal Skills and Experience: - Proficiency in Excel - Data organization - Data analysis - Chart creation in Excel I may have more projects in the future if this one goes well. Please include your relevant experience in your bid.
I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.
I need a website to promote my holistic healing and life coaching services. It's crucial that the website contains: - A blog section for sharing useful information and tips - A testimonials area to highlight the benefits of my services - An online booking system to conveniently schedule appointments I prefer a calming color scheme using blues and pastels. Ideal freelancers should have experience in developing such websites, particularly with online booking system integrations. A keen sense of design, with the ability to create visually soothing aesthetics, would be greatly valuable.
I need an exp...form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience with exporting to databases and Excel - Proficiency in generating PDF documents from form...
I'm currently in need of an HTML expert to take care of several tasks for me. The ideal candidate should have a proven track record in front-end development, responsive design, and creating HTML email templates. Required to create HTML for PDF generation and HTML should be A4 print compatible. Please check the attachment then let me know
READ BEF...a Short-Term commitment for Ongoing Mobile App's Phase II Firstly starting the Android Upgrade and then iOS and Web Admin Panel's works will be started. *Phase II Features with Allocated Budgets for Android App 1. Integrate Google In App Purchases = 150USD 2. Welcome (3)Pages = 100USD 3. Integrate New SMS OTP API = 30USD 4. Fix Minor Note Issue = 20USD 5. Set the App to All countries in Playstore = 20USD 6. Speed up the App = 30USD 7. Tips for Deliver Ontime in 7 Days = 50USD Total = 400USD (BUDGET IS ROCK SOLID) Required Skills: - Kotlin and Swift for mobile apps - Node for BackEnd - ReactJs for Web Admin panel Additional Requirements: - (NDA) and (IP) Make your you read everything and no more pay for code understandi...
I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure...
I need a freelancer to convert a series of simple, text-based PDF documents into Word. Your job is to ensure that the text in the Word documents is fully editable, and that the original formatting is preserved. Key Responsibilities: - Convert multiple text-based PDF documents into fully editable Word documents. - Ensure the text is accurately extracted and maintained, without any errors or omissions. - Preserve the original formatting of the documents in the Word version. Ideal Candidate: - Proven experience in PDF to Word conversion, especially with multiple documents. - Proficient in software for text extraction and formatting preservation. - Attention to detail and ability to meet deadlines. Please note that the documents are text-on...
...experienced designer who can convert 2 existing posters into vector format using Adobe Illustrator. This is to ensure that the posters can be printed at a size of 120 cm width and 180 cm hight without any loss of quality or pixelation, so the final product is crisp and clear. Key requirements: - Posters are ready and do not need any design changes - Conversion to vector format is the main task - I will be printing the posters at a size of 120 cm width and 180 cm hight, so the vectorization must be of high quality to accommodate this - The final deliverable should be in a format that will not lose quality when scaled, such as SVG or PDF. - Experience with large format printing is a plus The deadline for this project is ASAP. Please let me know if you ...
I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.
I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I'm looking for a professional who is proficient in converting PDF files to Word documents. This project entails: - Working with a PDF file that primarily contains textual content. - Ensuring the Word document mirrors the PDF format exactly, from text placement to style. - Operating within a Windows environment. The ideal freelancer should have superb attention to detail, and should deliver the work in a timely manner. Experience with Adobe Acrobat and Microsoft Word is highly desirable. Accuracy and format preservation is of utter importance in this task.
...am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedure...
I require a freelancer with excellent Word processing skills and a solid understanding of professional resume layouts. You'll be tasked with formatting a resume from a PDF into a Word document. Here are the key project requirements: - Format the resume in Word maintaining a clean, professional layout The word Doc is the content I want it to be. The PDF is how I want it formatted. As the files have my personal information I don't want to attach them just yet. The documents are only one page
I have a simple text-based PDF file that I need converted to a fully editable Microsoft Word document. Key Requirements: - The purpose of this conversion is to allow for easy content modifications, so the document should retain the same content layout as in the PDF. - No complex formatting is present, just the text that needs to be edited. - The final Word document should be compatible with Microsoft Word only. Ideal Skills and Experience: - Proficient in PDF to Word conversion tools or manual typing to maintain document integrity. - Expertise in Microsoft Word to ensure the best conversion for editing purposes.
I need a Python developer to help me convert a PDF file into an XML file. And Share that Python Code With me as well. Key Requirements: - The primary task is to extract text from the PDF and structure it into an XML file. Ideal Skills: - Strong proficiency in Python, with a good understanding of its syntax and libraries, particularly for PDF processing. - Experience in text extraction from PDFs is a plus. Please note that I do not have a predefined XML structure in mind, so I'll need some guidance on how to structure the output.
I have a PDF file that I need converted into a Word document. The purpose of this conversion is to enable editing of the contents within the file. The layout of the PDF file is quite complex as it contains various images and tables. I would appreciate if the Word document could be formatted in a standard business format. Ideal Candidate: - Proficient in converting PDFs to Word - Experience with complex layout conversions - Attention to detail in formatting - Understanding of standard business formatting
...emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaning...
...of a professional who can create a website that perfectly blends modern and traditional design elements, while focusing on providing an informative experience for my visitors. Key Features and Requirements: - The website is primarily informational in nature, so it must be designed with a user-friendly interface and clear navigation. User should be able to find product description using part number - Required to create a digital product catalogue that can also be downloaded as a PDF booklet - The design should be a seamless integration of modern and traditional styles, ensuring an appealing and unique look that stands out. - It is crucial to include product categories and filters, enabling visitors to easily search and navigate th...
I'm looking for a creative designer to craft an invitation card for my baby's naming ceremony. I've decided on a pink and gold theme, which should be tastefully incorporated into the design. Key Requirements: - The card should be visually captivating and in line with the theme. - I need both digital (e-invite) and printable (PDF) versions of the card. - It should not include any photos. Ideal Skills: - Proficiency in graphic design, especially for invitation cards. - Experience with creating both digital and printable formats. - A good understanding of color schemes and design aesthetics. If you have a portfolio or previous work that aligns with this project, please share it. I'm excited to work with a professional who can br...
Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account
I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.
...that needs minor revisions focusing on size modifications and corrections to a couple of elements. Here's what is expected: - Correction on Text: The text featured on the banner of a shield needs modifications. It must appear crisp, and maintain its style with no color interference between letters. - Image Modifications: A specific image of a missile in the artwork needs correction. Note that the TOP of the missile is rendered in TWO colors; retain this. Grey hatched area around the shield needs to be removed. - Size & Resolution: The final artwork should fit perfectly on a flag measuring 3' x 5', with a resolution of 4000 x 7000. All the images and text should appear sharp and clear when the flag is printed. Height of the shield an...
Hi Zainab528, I noticed your profile and would like to ask about getting you to redesign / reproduce a couple of Leaflets for me. I have some existing ones for 2 of my products, and will shortly need a third one. The two I already have I need producing into a format that I can upload to my website. I can send you PDF copies of them for you to look at and give me a price? Thanks, Dan
I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.
...am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedure...
...an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify...
I am urgently in need of an expert in Docparser. I have several PDF documents from which I need to extract specific information in the form of both text and tables. Therefore, the successful candidate must have: - Extensive experience with Docparser - Strong ability to identify and extract specific text and tables from PDF files - Proven track record of delivering tasks promptly Given the urgent nature of this project, applicants who can start and deliver this project ASAP will be highly appreciated. If you are proficient in Docparser and can handle this task accurately and quickly, please bid. ~~~ I have 4 different vendors that we buy from, each having different invoice styles and details. I have all of the pdfs most are in...
Looking for someone to evaluate the USPTO design patent drawings below, compared to the 3D CAD drawings below. In other words, show what changes...USPTO design patent drawings below, compared to the 3D CAD drawings below. In other words, show what changes must be made to the design patent drawings to claim the main features of the 3D drawings. All suggested changes should be written on the PDF, using PDF software (preferably Foxit Reader, which can be downloaded for free). Example changes have been written on the PDF. Candidates should confirm that they are familiar with USPTO design drawing guidelines. Thank you.
I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.
I'm s...the plugin fosters good user interface with functionalities that can make it modern and clean. Here are the project's details: -The idea for the plugin is that it uses the already existing format seen in the grading view for submissions and instead uses that as the foundation with the online text replacing the pdf panel (left) and the feedback panel (right) will instead store instructor provided resources such as assignment-relevant description, links, and most importantly, the assignment rubric for easy viewing. - The plugin should have a good user interface. This will significantly improve user experience and interaction with the platform. - Only barebones structure for the plugin is required Key skills and experience...
business profit loss reporting excel(Jan, Feb & March)
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis ...
I have a set of architecture drawings for a 3 story building in PDF format that I need to be converted to CAD. The primary reason for this is so that I can easily make modifications to the plans. I also need new drawings created for the purpose of obtaining building permits. Key Project Tasks: - Convert existing architecture drawings from PDF to AutoCAD - Create new building permit drawings maintaining the basic layout and dimensions of the original plans Ideal Skills and Experience: The ideal candidate for this project should have: - Proficiency in AutoCAD - Experience in architectural drawing and permit creation - Attention to detail to ensure accuracy in the conversion process - Ability to understand and replicate a set of existing drawings ...
...accounting firm, we need a modern and minimalist brochure/front page template created on Canva. This design will be a vital part of our client communications, underlining our commitment to transparency and professional service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receiv...
I'm in need of a skilled WP Job Manager/Smyles Plugin expert to make some changes and additions to both the back-end and front-end of my website. The primary focus of this project is to modify the back-end using the Smyles Plugin. Key requirements: - Expertise in WP Job Manager/Smyles Plugin: You should have proven experience with these plugins and be able to implement the necessary changes competently. - Back-end Development: You will be tasked with adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new search criteria: Specif...
I need a professional to convert my existing coffee packaging design from PDF to diecut file format. I have the design ready and it's in PDF format. I'm looking for someone to prepare a diecut file of the design for submission. The packaging types I require the diecut for are: - Coffee cup (paper-plastic) - Paper bag - Sweet packaging The project is urgent, and I'm looking for someone who can deliver the diecut files quickly. Ideal Skills and Experience: - Proficient in graphic design software - Experience in diecut file preparation for packaging - Ability to work under tight deadlines - Good communication skills for quick project updates.
...professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a good understanding of...
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
...two services: one for subscribers and one for the general public. For the general public: 1. When a sender sends any message, number, or letter, the bot greets them and requests input of a code or menu name (there are 200 codes or menu names available). 2. If the input is incorrect, the bot asks the sender to resend the correct code, send an image containing all the codes, or return to the main menu. 3. If the code is entered correctly, the bot displays general information in text form taken from a Google Sheet. Along with this information, a menu is displayed: • PDF file extracted from Google Drive or a folder • Image • Information in text form taken from a Google Sheet • Input another code • Return to the main menu For subscribers: 1. Info...
...residential floor plans. Scope of work: Update plans and make necessary modifications per information below. We want to make some changes to the attached plans. The main objective was not to compromise the roof lines and exterior. Scope of work- Masterbath- Bumpout for Tub with side roof. Will not affect main roof. Masterbath and Closet reworked and extended this area along with the garage back 5’-0” existing roof pitch will extend. Bedroom 3- Extended this area back 5’-0” and added a pitch roof to the existing roof line. Moved rear porch demising wall over 3 ft to expand the width of this room. Need to resize living room windows next to back door. Prefer Qty.3 3060 windows with 3080 door in living room. No need to u...
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
Python Script Developer for Photoshop Automation & WordPress/WooCommerce Integration We are seeking a freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script with WordPress/WooCommerce to retrieve order details. Automatically open Photoshop and modify PSD files based on customer orders. Update text layers with customer input and save customized templates as JPG/PDF.
...are seeking a talented and creative graphic design team to create a professional and visually appealing pamphlet. This pamphlet will be used to showcase the various service plans and benefits offered by our HVAC company. The goal is to clearly communicate the value and benefits of our services to potential and existing customers. Project Scope: Design and Layout: Create a visually appealing and professional design that aligns with our brand identity. The pamphlet should be easy to read and navigate, with clear headings, subheadings, and bullet points. Incorporate high-quality images, icons, and graphics to enhance the visual appeal and readability. Content Integration: Use the provided content from our three...
...for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
...system will focus on Background check and Referral check. Key Functionalities: - **Background Check**: This system should have the ability to conduct background checks on potential employees. This can involve checking criminal records, credit history, and other relevant information. - **Referral Check**: The system should also incorporate a referral check system. This can help verify the authenticity of the references provided by the employee. User Interface: - The UI of this system should be interactive and engaging. This will ensure that the system is not only functional but also user-friendly. Reporting System: - The system should generate reports in two ways: - **Downloadable PDF Reports**: The system should be able to generate downloadable PDF...
...of a skilled graphic designer to craft a comprehensive overview PDF for my digital services and solutions. Key Deliverables: - Service Descriptions: A detailed explanation of the range of services I offer should be included. - Professional Design: The overall look and feel of the overview should be corporate and professional. This will resonate well with the target audience and reflect the nature of the services I provide. Distribution Plan: - The PDF will be used in a variety of situations, so it must be adaptable. I intend to: - Email the document to clients. The design should be compatible with and visually appealing in email format. - Make it available for download on my website. The PDF should be easy to access and...
