Sum individual cells excelงาน
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)
หน้าแบบฟอร์ใบเสนอราคา 1. ดึงข้อมูลลูกค้าจาก Database หรือ สามารถเพิ่มรายชื่อลูกค้าใหม่ได้เลย ใช้ Select2 1.1 เมื่อดึงข้อมูลลูกค้าได้มากแล้ว ให้ Auto fill ข้อมูลที่เลือเช่นที่อยู่ใบกำกับภาษี 2. ค้นหาข้อมูลสินค้าในฟอร์ม 2.1 ค้นหาข้อมูลสินค้าได้จาก Database ในช่อง SKU ได้ และ Auto Fill ช่องอื่นๆเช่นรายละเอียดและราคา 2.1 ค้นหาข้อมูลสินค้าได้จาก Database ในช่อง Detail ได้และ Auto Fill 3. SUM ราคาสินค้าแยก VAT และราคารวม 4. ส่งเอกสารให้ ลูกค้าได้ในรูปแบบไฟล์แนบ PDF และ Email ได้ทันที ข้อมูลตามรูปแนบบ ใช้ Codeinater และ Boostrap4
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
I own Jolly Roadside Assistance and I am seeking a creative professional who can craft an in...company. We offer various services including towing, jump starts, and tire changes. Our target audience includes individuals and various businesses - both small and corporate. The ideal freelancer for this job will have: - Extensive experience in branding and slogan development - Understanding of roadside assistance services - Ability to create a slogan that appeals to varied audience: from individual car owners to corporate fleet managers. Your slogan should be catchy, memorable and effectively communicate the range of services that we provide. It should also clearly identify us within the highly competitive roadside assistance industry. Please include samples of your previous work in...
I'm looking for a reliable individual based in Tokyo who can collect and send a medium-sized (1-5kg), non-fragile item to Australia. Key Responsibilities Include: - Pick-up item from a specified location in Tokyo - Secure item with protective wrapping - Dispatch to an address in Australia Ideal Candidate: - Must be based in Tokyo - Strong attention to detail, particularly regarding packaging and shipping procedures - Reliable and swift communication - Previous experience in courier services or shipping-related tasks would be beneficial.
I'm looking for a skilled freelancer to assist me with a cold calling campaign targeted at individuals. Our primary goal is to verify the identity of these people. The idea is to make sure the person receiving the call is the same individual we have on record. - I'll provide you with the information you need to make the calls. - Your role will be to engage them in a brief conversation, verifying their identity. - Upon successful verification, we plan to offer a bonus to the person. The ideal freelancer for this task should have: - Previous experience in cold calling. - Excellent communication and interpersonal skills. - A professional and trustworthy demeanor. - Understanding of the importance of data privacy and confidentiality. - Flexibility in making calls to su...
I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.
I'm seeking a creative individual who can shape a portfolio for my architecture portifolio , showcasing 5-10 selected projects. The focus would be on mainly 6 projects - Experts in architectural design are preferred, as you'll ' be responsible for picking out stunning visuals and marrying them with concise, descriptive copy. - Specific tasks include selecting images, formatting the portfolio layout, and writing brief descriptions for each project. - A strong understanding of architecture and experience designing visually compelling and professional portfolios is a must. - The ability to communicate the unique vision of each project through your descriptions and your choice of visuals is key. Your aim is to make each project shine and appeal to potential clien...
I'm in need of a keen researcher who can delve into a provided spreadsheet of businesses for analysis. The ...information. Key Responsibilities: - Thoroughly examine the provided businesses in the spreadsheet - Extract and analyze various attributes, such as customer demographics, product descriptions, and pricing information - Summarize and present the information in a clear, concise manner - Provide suggestions on the potential opportunities or challenges based on the data This project requires an individual who is meticulous, analytical, and has a strong understanding of business operations. The ability to interpret raw data, identify trends, and draw meaningful insights from the information is essential. Experience in market research and business analysis would be a defi...
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
I'm looking for an experienced individual who can create listings for both Mercari and Facebook Marketplace. The listings will primarily consist of clothing and home furnishings. Key Responsibilities: - Create engaging and attractive listings for clothing and home furnishings - Ensure that the listings are accurately represented and priced competitively - Write detailed product descriptions that are informative and persuasive Ideal Candidate: - Prior experience with creating listings on both Mercari and Facebook Marketplace - A keen eye for detail and high-quality standards - Excellent copywriting skills to craft compelling product descriptions - Knowledge of pricing strategies on e-commerce platforms - Ability to work efficiently and independently If you're someone wi...
I have a set of legal documents in English that need to be professionally translated into Spanish. This is a project that requires an individual with the following skills and experience: - Native-level fluency in both English and Spanish. - Previous experience in translating legal documents. - Understanding of legal terminology in both languages. - Attention to detail and a high level of professionalism. The translated documents should be able to be used by legal professionals and should maintain the accuracy and intent of the original text. Please provide examples of previous translation work when bidding.
I am seeking an experienced, talented individual to create an accurately measured floor plan based on a sketch, and perhaps 3d renderings if we align on the 2d. This project will require the inclusion of the following primary facilities: - 4-6 Treatment rooms - Sauna or steam area and day spa space - single-stall showers, changing areas, bathrooms - 1 yoga studio - Mixed use lounge with communal table, lounge area, and hidden AV - front desk - Spa Retail area - lockers - back office area for laundry, storage, and staff break If you have innovative and creative ideas beyond my sketch to further enhance the floor layout to attract more customers, they are more than welcome! You will be working closely with me to design a floor plan that truly captures the essence and objectives of ...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
I'm in need of an experienced individual who can work on mechanical design, specifically industrial design, for tools and equipment. Key requirements: - Proficiency in mechanical/industrial design, especially for tools and equipment - Strong understanding of design principles - Capable of translating ideas into functional and aesthetic designs Ideal skills and experience include: - Background in industrial design - Experience with tool and equipment design - Proficiency in relevant design software Attached is the brief document.
Are you a driven sales professional ready to take control of your income and achieve unparalleled success? Buzz Circuit Media is seekin...Generous bonus program rewarding client retention Fully remote position with the flexibility to work from anywhere Comprehensive training, resources, and support to help you succeed Opportunities for growth and advancement within our agency and sister brands Apply now and take control of your earning potential. Please note that this is a commission-only position, and earnings will vary based on individual performance. Successful candidates may also be considered for similar positions within our sister brands. Address me by the name Big Cheese. To apply, submit your resume and a brief cover letter explaining why you're the ideal candidate...
I need a skilled individual to convert my current Laravel website to WordPress. The main reason for this transition is to ensure that I have a user-friendly, easy-to-manage website. Currenlty, the website is built with Laravel, but I would like it to be converted to WordPress to make it easier for me to manage and update the content. Ideal skills and experience: - Proficient in Laravel and WordPress - Strong understanding of website architecture and conversion process - Ability to ensure a seamless transition - Good communication skills and ability to explain technical concepts to non-technical individuals.
I'm in search of a skilled individual to post a business-themed article across prominent online platforms. This task requires a keen understanding of different website formats and target audiences. You'll be expected to: - Research and recommend appropriate websites for the article posting. - Make sure the article is well-placed and resonates with business professionals. - Ensure the content is appropriately tagged and categorized for maximum visibility. I'm looking for someone: - With solid experience in content distribution and article posting. - Who can suggest and target websites effectively. - Who can cater the article to business professionals. Your expertise in this area is crucial for the success of this project. I'm open to suggestions on how to best ...
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
I'm needing a skilled individual to assist me in configuring my NodeMailer. The primary goal is to utilize this for sending bulk emails. Please pay attention to the following specifics: - My current email provider is Alibaba Cloud. - The server I'm using is either a dedicated server or a Virtual Private Server (VPS) on Alibaba Cloud. Unfortunately, I'm not sure about which it is. - The main task is to ensure that NodeMailer is set up to work seamlessly through a mobile proxy. This is crucial, as the emails I'm looking to send are in bulk. The ideal candidate for this job should have a solid understanding of NodeMailer and experience with setting it up in conjunction with Alibaba Cloud. An understanding of proxies and their integration with NodeMailer would be h...
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
I'm looking for an expert to facilitate the sale of a single domain name. I already have a fixed price in mind and I'm seeking someone who can help me close this sale within a month. Key Requirements: - Experience in domain sales, particularly in selling premium domains. - A solid network within the domain selling industry. - Expertise in negotiation and closing deals quickly. I need an individual who can work efficiently and effectively, ensuring a smooth and timely sale. If you have a background in domain sales and are confident in your ability to meet my tight timeframe with a successful sale, I'd love to hear from you.
I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all informati...
...Generation:** - At the beginning of each game session, the AI generates a hidden scenario that sets the context for the tasks. - This scenario is not directly revealed to the players but influences the tasks they receive. 3. **Dynamic Task Distribution:** - The AI distributes tasks to players based on the hidden scenario. - Tasks can be distributed to all players simultaneously or to individual players sequentially. - For example, the AI might instruct Player A to "open a door" by presenting them with a button labeled "Do it." 4. **Player Actions and Scenario Evolution:** - If Player A completes their task (e.g., presses the "Do it" button), the AI then assigns new tasks to other players (e.g., Players B, C, D). - The sequence ...
**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and the othe...
I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not on...
I'm looking for engaging marketing material to promote my newly launched website, www.ukgymrepair.co.uk. The theme I envision for these materials is modern and sleek, aligning with the overall brand identity. Key Deliverables Include: - Poster: Designed to catch the eye ...Experience: - Experience in designing marketing materials for fitness or related industries would be a plus. - Proficiency in modern and sleek design with an eye for detail. - Graphic design skills to create visually appealing and effective materials. - Ability to work with the same color scheme as the website and incorporate gym equipment images into the designs. I'm looking for a creative individual who can deliver high-quality, on-brand materials that will help drive traffic and conversions for my ...
I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.
I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attention to d...
As the creator of an educational storybook targeted at early elementary aged children (6-10 years), I'm in need of a talented illustrator to breathe l...educational storybook design. • Demonstrates a keen understanding of the specific target age group. • Good communication skills for frequent project updates. Project Details: • Develop captivating illustrations based on provided themes. • Illustrations to align with age-appropriate educational content. • Incorporate engaging, vivid colors to attract young audience. • Ensure the concept of individual illustrations are easily comprehensible to the set age-group. • Final deliverable format to be agreed upon. Let's work together to create a captivating, educational illustrated book that ...
I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even i...
