Format in excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ทำ 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)
Thai และ ENG format WAV (PCM,8kHz, 16 bit, Mono, Max size 100MB) ถ่าใด้ครบทุกภาษา ต่อลองราคาใด้คับ
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I have 5 voice files in Thai that I needed translated in the format given below. I : น้องเคยค้นหาแอคเคาท์ใครในออนไลน์ป่ะ อย่างเฟซบุค Have you ever try to look for someone or search for an account online? Or in Facebook S : เคย Yes I : เหมือนฉันชอบคนนี้ ฉันไปตามล่าหา If I like this person I would look for him/her. S : โอ้ย เอาทุกสเต็ปเลย โพสต์รูปอะไรเซฟมาให้หมด Everything from posting to taking picture. S2 : โมเม้นต์นี้ เคยครับ คือคนที่เราอยากจะรู้จักใช่มั้ยครับคนที่เราแอบชอบนั่นแหละ เราจะคอยส่องเฟซเค้า ไปดู If i like that person i would peek at her Facebook. I : ไปแอดเค้ามั้ย Did you add her? S2 : เป็นเพื่อนกันอยู่แล้ว ก็ดูว่าเค้าลงรูปอะไรมั่ง กดไลค์ให้เค้า นั่งดูภาพเค้าอยู่คนเดียวอะไรอย่างงี้ We are already friend. Most of the...
I'm seeking a talented audio engineer to mix and master my pop Hindi song. Key Project Details: - Genre: Pop - Audio Quality: The final mix and master should be in WAV format. - Vocal Tracks: There are 10 vocal tracks in the song. Skills and Experience: - Proven experience in mixing and mastering pop songs. - Experience in working with multiple vocal tracks. - Proficiency in audio editing software. - Understanding of Indian music genre preferences is a plus, but not required.
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the E...
I'm currently in need of a competent and detail-oriented forensic artist specializing in composite sketching. Unlike the typical applications geared towards crime scene investigation or suspect identification, the main task revolves around recreating a memorized photo in colored format. The final output is expected to be as precise and realistic as possible, echoing the exact resemblance of the original photo (a person's face) from memory. Attention to detail, excellent color use, and proficiency in capturing human resemblance are among the key skills sought for this job. The chosen freelancer will have proven experience in composite sketching, preferably with a portfolio demonstrating projects of a similar nature. Efficient communication...
I'm looking for a skilled 3D designer who can create high-poly, realistic models of various products for an interactive 3D virtualizer. The key requirements for this project include: - Expertise in 3D modeling: You should have a strong portfolio of high-poly, realistic 3D models, ideally of products. - Understanding of 3D virtualizer: Experience in creating interactive 3D models for web use would be a big plus. - Creativity: The ability to accurately represent products in a high-poly format while keeping the designs engaging and visually appealing. The final deliverables will be high-quality 3D models that can be integrated into a virtualizer, providing users with an immersive, realistic viewing experience.
I have a data in my excel sheet. They are from column A - J, 10 column, 4137 rows of data. The data are in mixed string format, which means all long text mentioning about their company. I need to do some data analysis. So i need help in doing NLP for those data to clean and filter the data. I need help in doing NLP for the data and provide me the python code use to do the analysis, I will need like the summaries of the text. For example, for column Funder Purpose the row contain info like "Since the business started, we have been fully relying on our internal fund. We plan to utilize this fund to support our working capital requirement and operating expenses. Based on our business growth progress, we are confident in our repayment ca...
I'm looking for a talented illustrator to create visuals for my innovative smart headphones. They feature an over-ear design with sound isolation technology, noise cancellation, speech processing, and a unique eye-tracking function. Desired Illustrations: Photorealistic Image: I envision a modern,...depicting the internal components, including a central processing chip connected to sections labeled "Noise Cancellation Algorithms," "Speech Processing," and "Eye Tracking." Show Bluetooth connectivity. Portability Image: An image demonstrating the headphones' portability. It could show someone placing them in a sleek carrying case that fits easily into a bag. Style and Tone: A professional, modern, and user-friendly visual style is preferred. ...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input f...
I'm looking for a freelancer to recolor and enlarge my logo for web use. The current colors are too bright, so I'd like them to be shifted to a darker hue. The job will also involve resizing the logo for optimal web display. Ultimately, I would need the final version of the logo in JPEG format. Ideal skills and experience for this project include: - Graphic design and logo editing - Proficiency with Adobe Illustrator or similar software - Understanding of color theory - Experience with resizing images for web display
I am seeking a creative and experienced video editor to create a captivating YouTube introduction video to increase the average view duration of my posted content. This video ...video that will hook my viewers, encouraging them to watch more of my posted videos, hence increasing the average view duration. - Video Content: The video will be repurposed from the original recording. - Desired Video Length: The video should be anywhere from 30 seconds to 1 minute long, capturing the audience's interest from the get-go. Ideal Skills: - Experienced with video editing in line with YouTube's format and general style. - Ability to create content that appeals to a mixed audience of young adults and business professionals. - Ability to repurpose original recordings into a capt...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
I'm in need of a proficient Python developer who can help compile a Python code, that I have acquired from GitHub, into an executable format for Windows. As the client, I expect: - Understanding the existing Python code and its dependencies - Transforming the Python code into a Windows executable file Successful freelancers should provide a detailed project proposal illustrating how they plan to compile the code to exe on a Windows operating system. Though no specific Python libraries or frameworks were mentioned, a background in Python coding and debugging is paramount. The ideal freelancer should have a deep understanding of Python code, dependencies, and experience dealing with code from GitHub. Experience in generating Windows executable files from ...
I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.
I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a proj...
I'm looking for a data entry specialist to extract text data from scanned documents and input it into a database. Key Requirements: - Data Ent...into a database. Key Requirements: - Data Entry: Your primary task will be to accurately transfer text data from scanned documents into a digital database. - Attention to Detail: Precision and accuracy are essential to ensure the database is error-free. - Timeliness: The task should be done in a timely manner to keep the project on track. Ideal Skills: - Proficiency in English: Since the data is in text format, a strong command of English is necessary. - Data Entry Experience: Previous experience in data entry is a plus. - Familiarity with Database Management: Basic knowledge of database operations i...
I need a legal contract typed and formatted. The document is to be used for print, so it has to be formatted to a high standard. The ideal candidate will possess: - Proficiency in legal contract formatting - Excellent typing speed and accuracy - Strong attention to detail - Experienced in creating professional documents The final document should be ready for print, adhering to the standard legal document format. Please provide a brief overview of your experience with similar projects. Thank you.
I need a skilled translator to convert my legal documents written in Portuguese into English. The ideal candidate should possess an intermediate knowledge of legal processes, to ensure that the translation is accurate and maintains the legal nuances of the original text. The final output should be in a Word Document format. Key requirements: - Translation from Portuguese to English - Understanding of legal terminologies - Intermediate knowledge of legal processes - Deliver the translations in a Word document This project is for professionals with a good track record in legal document translation. A background in law or certification as a translator would be highly appreciated. Please provide examples of previous similar work.
I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data im...
I'm in need of a bilingual (Spanish/English) beta reader for my werewolf romance novels. This project is primarily focused on: - Reviewing the plot coherence and engagement. - Providing feedback in an audio format. Ideal candidates for this role should be fluent in both Spanish and English, and have a passion for romantic fiction, particularly within the paranormal genre. Experience in editing or beta reading, even better if specifically in the romance or paranormal genres, is highly desired. This role is ideal for someone who can provide constructive feedback that helps me enhance the plot of my novels and can communicate this feedback in an audio format. The aim is to ensure the plot is engaging and coherent, while mainta...
I have access to the aircraft and can get many photos. I also have access to schematics to support the design. The end product will need to be in a format readable by 3DS Max 2023 and will then be imported into a game engine. Both high detail exterior and interior models will need to be made with milestones on 3D Geometry and artwork.
I'm in need of an intermediate Shopify developer to help me create a new webpage using a page builder app, similar to one of my reference pages. Key Tasks: - Develop a Shopify page that mirrors the format and functionalities of the reference page - Use a Shopify page builder app to make the process easier and smoother Ideal Skills: - Proficiency in Shopify page development - Experience with Shopify page builder apps - Ability to replicate an existing webpage layout - Strong attention to detail - Ability to understand and implement design requirements accurately In your application, please include a detailed project proposal outlining how you plan to approach this project and your relevant experience. Looking forward to seeing your proposals.
I'm looking for a data entry specialist to extract text data from scanned documents and input it into a database. Key Requirements: - Data Ent...into a database. Key Requirements: - Data Entry: Your primary task will be to accurately transfer text data from scanned documents into a digital database. - Attention to Detail: Precision and accuracy are essential to ensure the database is error-free. - Timeliness: The task should be done in a timely manner to keep the project on track. Ideal Skills: - Proficiency in English: Since the data is in text format, a strong command of English is necessary. - Data Entry Experience: Previous experience in data entry is a plus. - Familiarity with Database Management: Basic knowledge of database operations i...
I ll upload various images under specific keywords. I want members to receive 1 image after texting that keyword in their personal channel. Also i want that image to be deleted in storage so that it will not be forwarded to other member. I also want a channel for my accountant, where he ll be uploading bill in pdf. And i ll get all data in excel sheet.
I need an electronic signature created from a JPG as soon as possible. This signature will be used for signing documents, email communications, and physical printouts. can pay 15 CAD
I am looking for a skilled graphic designer to convert my pixelated JPEG logo into a high-quality vector format, with a transparent background. The vectorized logo will need to be suitable for both online platforms and print materials. Key requirements include: - Expertise in converting raster images to vector format without losing quality - Ability to replicate the exact design of the original pixelated logo - Proficiency in ensuring the final product has a transparent background - Understanding of the use of vector graphics in both digital and print contexts Please include examples of similar work in your bid, and outline your approach to this project.
I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Estimated ...
I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.
