Excel conditional formatting if cell contains specific textงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...custom website layout for my project. Key requirements: - Custom Design: I do have a specific design in mind, and I'm looking for a designer who can bring it to life. - User-friendly: The website should be intuitive and easy to navigate. - Responsive: I want the site to look and function well on both desktop and mobile devices. - Clean and professional: The design should be clean, modern and professional. Ideal skills and experience for this project: - Proficiency in graphic design and web development - Strong portfolio of previous website design work - Ability to understand and implement client's design vision - Good communication skills to ensure the project meets the set standards and expectations. If you're confident in your ability to create a ...
As a newly established industrial...guidelines. Key Elements: - Logo Design: We need a professional, modern logo that represents our company's core values and services. - Color Palette: The dominant color in the brandbook should be purple. The usage of this color should reflect our brand identity and resonate with our target audience. - Typography Guidelines: We're looking for a minimalistic and clean design, including a specific font or set of fonts to be used in our branding materials. Your role would be pivotal in crafting a brandbook that not only represents our startup but also resonates with our target market. Experience in creating brandbooks and expertise in visual identity design are crucial for this project. Please be ready to showcase your portfolio wi...
I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
...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 business goals. Ideal Skills: - Advanced Excel proficiency. - Expertise in financial analysis and forecasting. - Strong analytical and problem-solving skills. - Excellent communication and reporting abilities ( need it finished by today )....
...website will include over 25 pages of content, each with unique images and content relevant to the IT managed services industry. Key Requirements: Proven Experience: Demonstrated experience in web development, with a portfolio showcasing similar projects. Design Expertise: Ability to create a website with a modern, clean design similar to Ntiva. The site must feature unique pictures and content specific to Tymor Technologies. 3D Logo and Animations: Proficiency in integrating 3D logos and dynamic animations. Communication Skills: Excellent communication skills with the ability to provide regular updates via WhatsApp. Timeline Commitment: Ability to deliver a sample home page within 1 day of the start date and complete the entire website within 2 weeks. Content Development:...
I'm in need of an expert in Excel for a project centered around statistical data analysis. Key Requirements: - I require someone able to handle statistical analysis in Excel. - The data is large and will require a high level of accuracy and attention to detail. - Since the data source is not specified, you should be flexible and able to adapt to varying data types. Ideal Skills and Experience: - Proficient in Excel, especially in handling large data sets. - Experience with statistical analysis in Excel. - Previous success in providing accurate data analysis. Please note the source of the data is not explicitly mentioned, so experience with different data types is a plus.
...and managing stock, and facilitating seamless communication with our workshop. The application should include the following features: - Fleet Maintenance Organisation: An effective and user-friendly system to manage our service schedules and gather data on both maintained and pending cases. - Comprehensive Service Dockets: Tools to record detailed information on every job, including automatic cell population for standard information. - Stock Management: Features to keep track of tyres and other parts available in each of our service vehicles. - Reminder system: Identifiers to highlight upcoming work and parts requiring attention, ensuring our team is always prepared. - Location Tracking: Can track service trucks to optimize routes and service delivery. - Time Management &...
Write 'CHINESE' OR I BLOCK YOUR BID DEADLINE is 48 hours from accepted project. I need a skilled translator who is fluent in both Chinese symbols and Danish to help convert a medical journal. The journal's focus is on a specific medical field, and it requires a high level of accuracy. Key requirements: - Fluency in Chinese symbols and Danish - Translation experience in medical content - Attention to detail - Clear, concise language skills - Ability to meet a deadline Please provide your portfolio of previous translations, especially those in the medical field. The deadline for this project is definite, so I need someone who can meet it promptly. Thank you.
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.
My primary objective is to enhance my website's ranking on Google. I have recently upgraded my site and my important keyword rankings are falling far beyond what they were previously ...and wincher to monitor. I require deep expertise in improving my SEO. Needs to be executed within a week. Website size is 34 pages and 35 posts roughtly. There are circa 10 main keywords. Key Focus Areas: - In-depth SEO audit and improvement proposal - Keyword research and optimization - On-page and off-page SEO - Contribution to improved user experience Ideal Candidate: - Expert in Google specific SEO strategies - Adept at keyword research tools - Proven track record in improving website ranking - Understanding of the services sector - Ability to work independently and propose effective...
...data to a database. Here are the specifics: - **Export Data:** The 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 fro...
As the owner of an optics-focused product line, I'm looking for an experienced freelancer who can generate a comprehensive wholesale pricelist for binoculars and rifle scopes. 1. Product Knowledge: Knowledge in various optics brands and models is a must as this project requires research on specific models that I will be providing. 2. Scope: The task includes the creation of a structured and detailed pricelist including the information about various models and their wholesale prices, all pricing and hi res images will be supplied. 3. Skills: Having data entry and data analyst skills, would be ideal to accomplish this job. Timeline: To be completed before June 10th This project would be a perfect match for individuals who have strong research skills, are highly meticulous,...
I'm looking for an expert to help configure my Cyclecloud HPC cluster. This is a specific project with the following requirements: - Configuring the cluster for machine learning and simulations tasks - Ensuring the cluster can handle large data processing in a timely manner - Implementing efficient resource utilization strategies - Validating the performance of the cluster with real-world workloads The ideal candidate for this role should have: - Proven experience in configuring Cyclecloud HPC clusters - A strong understanding of machine learning and simulation requirements - The ability to optimize resource utilization and improve scalability - Excellent communication and problem-solving skills read the specs: What I would like to do is to set up a Cyclecloud cluster w...
I need a data entry specialist to clean a dataset to be used for reporting and analys...the inconsistencies, errors, and duplicates in the dataset to make it suitable for reporting and analysis purposes - Ensuring the dataset is properly formatted and organized for its intended use Skills and Experience: - Proficient in data cleaning with a keen eye for detail - Experience with Excel and data entry is a huge plus - Strong understanding of data maintenance and organization - Ability to follow data cleaning guidelines and ensure data integrity The final dataset should be delivered in Excel format. The successful candidate for this job will have a deep understanding of data cleaning, excellent attention to detail, and the ability to deliver a clean dataset suitable for report...
I am looking for a personal mentor who can help me improve my understanding of Microsoft Dynamic365 finance and operation, specifically in the area of financial management. As a beginner in this field, I need someone who can guide me through the basics and help me gain confidence in navigating and using the software effectively. ...and Experience: - Strong knowledge of Microsoft Dynamic365 finance and operation, with a focus on financial management - Previous experience mentoring beginners in this field - Excellent communication and interpersonal skills - Ability to provide clear explanations and step-by-step guidance Mentoring Sessions: - Twice or more a week - In-depth discussions and hands-on practice - Assistance with specific tasks and challenges - Regular feedback and progre...
I'm seeking a talented designer to assist with our company rebranding. Here's a brief of what we're after: - A fresh and unique rebranding design concept. - As the company name and specific services weren't stated, we're looking for someone who can provide a wide array of design services or is open to collaboration on multiple fronts. Ideal skills and experience for this project: - Strong experience in branding and rebranding initiatives. - Portfolio demonstrating a broad scope of work in different design streams. - Availability to collaborate and communicate on refining our brand vision. I look forward to seeing how your creativity can benefit our brand transformation.
Hi im looking for someone to write my book its about a 17 yo girls on the street with a baby and my life
I have a Google document that I need converted into a Word document, specifically in .docx format. Special Requirements: - The Word document's formatting should mirror the existing Google document's formatting. - The Google document includes images that need to be accurately transferred into the Word document. - No other specific formatting is required. Ideal Skills: - Proficiency in Google Docs and Microsoft Word. - Experience in handling image transfers between different document software. - Attention to detail to ensure the final Word document looks identical to the original Google document.
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 the ac...
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 ...
I require assistance in viewing and downloading a few specific files from a different computer. Key Details: - The files that need to be accessed and downloaded are primarily documents and payment transfer proofs. - The method of access and download should be via a secure file transfer service. - Security is important. Therefore, the transfer should be password protected. Ideal Skills and Experience: - Proficiency in using remote file access and download tools. - Understanding of secure file transfer methods and experience with password protection. - Keen attention to detail, ensuring that the right files are identified and downloaded. (Images is for illustration purpose only) Name of real recipient will be told.
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 skilled and experienced professional who can convert a 50-100 page PDF document into an editable Word file. The primary goal of this conversion is to facilitate content editing in the Word document. Key Requirements: - Convert 50-100 page PDF to Word - Ensure the Word document is editable - No specific formatting style required Ideal Freelancer: - Proficient in PDF conversion to Word - Detail-oriented with high accuracy - Previous experience in similar projects Feel free to ask any questions for further clarification.
I'm looking for a skilled Python developer to help me with a scraping project. I need to extract specific product data from a website's table. Skillset: - Proficiency in Python and Scrapy - Experience in web scraping - Familiarity with handling web popups The website () contains a table with important product information. For each product, I need the following details scrapped: Certificate Type Certificate Number Product Type Organization Name Country Issue Date Expiry Date in addition to Product Details Brand Model Description Barcode The data should be saved in a CSV file. There are no specific rules or requirements to be followed during the scraping process.
We're looking for a skilled web designer, but please note that the main goal of the website redesign is currently unspecified. Unfortunately, the specific functionalities for the site have not been mentioned, and the target audience hasn't been defined either. Even without these specifics, show us what you've got! Let's see your imaginative flair and innovative ideas for a website redesign. Skills in UI/UX design, e-commerce, blogging platforms, membership login systems, and understanding diverse target audiences will be beneficial. Bring your own creativity to your bid.
... The ideal candidate should be able to: - Translate the spirit of my program into a visually appealing design - Understand the color scheme of red and yellow - Incorporate the elements of a bold S logo, circled by hands into the design. - view examples and use them for specific inspiration It's a youth program for kids ages 6-18 that combined education, outdoors, and leadership. I have provided the font sample and logo sample along with colors and help me design a logo. I have given 2 specific S examples only use those or small variances of those logos Must have hands around it to be considered Must use tagline "seek and you shall find under or around logo Only use the two S logos for design inspiration and do not variate to far. My mai...
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.
I 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 procedures. - Developing a clear and actionable clie...
