Convert multiple rows to columns in excel formulaงาน
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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
...SEO company to handle a comprehensive SEO project for 12 websites in the Miami, Florida area. The goal of the project is to primarily increase traffic to these websites. Key Responsibilities: - Conduct thorough keyword research related to the Miami area - Implement on-page optimization techniques to enhance each website's search visibility and user experience - Perform off-page optimization to build quality backlinks and improve domain authority - Regularly monitor and report on the performance of the implemented SEO strategies - Utilize white-hat SEO techniques that align with Google's guidelines - Collaborate with me to ensure that the SEO strategies are aligned with my business goals Ideal Skills and Experience: - P...
...seeking a skilled video editor for my YouTube channel. The goal is to convert my existing video content into engaging, fast-paced 1-minute clips in the style of reels or shorts. Key requirements: - Editing existing video content to create 1-minute reels or shorts - Fast-paced and energetic editing style - Incorporating text overlays or captions throughout the video - Ensuring the final product is suitable for YouTube and other social media platforms Ideal skills and experience: - Proficiency in video editing software (e.g. Adobe Premiere Pro, Final Cut Pro) - Previous experience in creating short form content for YouTube or other social media platforms - Strong understanding of pacing and storytelling in a short format - Ability to...
...product descriptions. The main aim of this project is to increase sales by capturing the attention of professionals. Key tasks and requirements: - Write engaging, persuasive product descriptions: Your primary focus will be on creating product descriptions that not only inform but also persuade professionals to make a purchase. - Understand and cater to a professional audience: The language and tone of the content should resonate with professionals. It's essential that you have a good understanding of what would appeal to this demographic. - Drive sales: The end goal here is to contribute to an increase in sales through your copy. Your descriptions should be able to convert readers into buyers. Ideal skills and experie...
I am in the need of a talented host to facilitate lead generation webinars targeted specifically at professionals. Each webinar should be approximately 60 minutes in length, filled with engaging and insightful content. Key Responsibilities: - Assist in the creation of engaging webinar content - Host webinars in an engaging manner to keep the audience interested - Ability to convert webinar viewers into potential leads Ideal Skills: - Solid understanding and experience in lead generation - Excellent presentation and communication skills - Experience in presenting to a professional audience. - Provable track record in webinar hosting and lead generation Your ability to keep an audience engaged ...
I'm looking for an experienced Excel Power-BI professional to assist me with various tasks. Key requirements: - Proficiency in Excel Power-BI. - Demonstrated experience in data analysis, dashboard creation, and report generation. - Ability to work with minimal supervision. I will share more details in via chat box. Only interested person placed a bid Thanks
I have a PDF file that I need to convert to a Word file. The key purpose for this conversion is to extract the editable text from the PDF. I intend to use this Word document for digital archiving, so it's important that the text remains editable. The PDF file does not contain any images or graphics, just text. So, the task is limited to text extraction without any graphic elements. Ideal skills and experience for this job include: - Proficient in PDF to Word conversion - Attention to detail to ensure no text is missed in the extraction - Understanding of the importance of retaining text editability - Experience in digital archiving would be a plus, but not essential
I'm seeking a Django and Python Fullstack developer who can lend their expertise to my application project. The chosen freelancer should excel in creating: - Robust user authentication and authorization systems - Seamless database integration - Responsive design that adapt to various devices I have certain design ideas but I would highly appreciate guidance to help realize these concepts. The freelancer should possess a strong grasp of user-centric design and prove instrumental in translating these concepts into a streamlined, functional, and easy-to-use interface. Ideal skills: Python, Django, Database Management, User Interface Design, User Experience Design, and Responsive Web Design. It's a bonus if the candidate has a knac...
I'm looking to create a top-notch e-commerce website that can handle transactions across multiple payment gateways and cater to a global audience. This site should be well-integrated with multiple payment options including Credit card, PayPal, Stripe, UPI, Phone pay, Google pay, Paytm. The site should be developed with a global scale in mind, with the ability to sell to countries such as United States, United Kingdom, Australia, India, and beyond. Key Requirements: - E-commerce Website: You should have a strong background in developing e-commerce sites with extensive experience in integrating multiple payment gateways. - Global Audience: The site should be designed to handle transactions in multipl...
...effectively drive traffic to my new website and establish proper analytics for visibility and audience targeting. The freelancer should have a strong understanding of TikTok, Google, Instagram, and Facebook. It's crucial that they can set up and manage these platforms to maximize their potential for my website. Key Responsibilities: - Implementing traffic-driving strategies and campaigns on TikTok, Google, Instagram, and Facebook. - Setting up analytics and tracking mechanisms on my WordPress site. - Tailoring the content and strategies to attract teenagers, young adults, and parents, my target audience. The ideal freelancer should have: - Proficiency with TikTok, Google, Instagram, and Facebook, as well as WordPress. - Proven experience in driving tr...
...assistant to help hunt specific items and promote select services on Facebook marketplace. Key Responsibilities: - Searching for specific items on the platform which includes: Electronics, Furniture, Clothing, Cars, Homes, and Gold - Notifying about new listings of these items - Promoting select services The ideal candidate should be able to gather and provide me with specific information on the items found as well. This includes: - Price - Location - Condition - Seller Finance - Land contract The selected freelancer will need to have: - Prior experience with Facebook marketplace and an understanding of how it works - Excellent communication skills - The ability to manage multiple tasks simultaneously - Attention to detail is a must. Pl...
...users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design
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
I'm seeking an individual with excellent typing skills to convert a text-only PDF file into a Word document. The content is not complex; it consists of plain text without images or tables. Key Requirements: - Complete the task within 3-5 days - Ensure the content is accurately typed - Deliver the Word document in a standard text format Ideal skills: - Proficient in typing and data entry - Familiar with Word processing software - Attention to detail in maintaining accuracy - Ability to meet deadlines
...looking for a proficient spreadsheet expert to create a thorough forecast sheet for my new project. I will be providing all required information for our project. It’s a village that we 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 proje...
I require a well-designed Shopify store to sell my range of physical products. The website should offer a seamless and user-friendly experience to convert visitors into customers effectively. Key project requirements: - Configure and integrate an e-commerce platform into the website - Design features for showcasing more than 50 different types of products - Implement efficient transaction processing and secure payment gateway systems Ideal skills and experience: - Extensive experience in building and designing Shopify websites - Excellent understanding of e-commerce platforms - Strong track record of working on similar projects.
I'm in the process of launching a consulting business focused on staffing services. I'm in need of a talented Client Acquisition Specialist to help me secure freelance staffing clients. Key Responsibilities: - Engage in the overall sales process , from lead generation, initial outreach and closing deals. - Develop an effective client acquisition strategy. - Reach out to prospects through various channels (e.g., email, social media, networking). - Present our service offerings in a compelling way to convert leads into clients. -Secure deal closures by skillfully managing negotiations and terms. -Establish and sustain robust client relationships. Ideal Candidate: - Proven experience in client acquisition, ideally with...
...experienced Unifier consultant to streamline our project management system and provide strategic guidance on process optimization. Key Tasks: - Conduct a thorough process review and analysis to identify inefficiencies and areas for improvement. - Implement workflow optimization strategies that enhance project efficiency and reduce time-to-completion. - Integrate multiple systems to ensure seamless data flow and accurate project tracking. Challenges: - Inefficient communication between teams: The current system hampers cross-functional collaboration and slows down project progress. - Manual data entry and duplication: We're struggling with data accuracy issues due to manual entry and duplication. - Lack of automation: The absence of auto...
I'm in need of a comprehensive, multi-tasking personal assistant AI to support me in a variety of ways. In addition to the standard tasks like scheduling appointments, managing emails, and setting reminders, you'll be responsible for quite a bit more: - Daily Eating Plan: This will involve keeping track of my dietary requirements and suggesting meal plans. - Warnings: I need to be alerted of any potential issues or conflicts that might arise. - Sports: I require assistance in tracking my sports activities and training regimes. - Calorie Calculations: It's important for me to track my calorie intake, so I'll need you to help me with this. - Heart Rate: Monitoring my heart rate and keeping track of this data....
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.
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.
...Wordpress developer to create a custom online form on my website using WPForms. The form should save all submitted 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 shou...
...design expert to create a clean, minimalist landing page focused on promoting my product/service. Please make sure to integrate the following details about my offerings into the design: - Specifications of product/service - Testimonials/reviews - Comprehensive price list - Terms and conditions - List of services The ideal freelancer for this task would have extensive experience in minimalist design and a keen understanding of marketing fundamentals to optimally position the product/service. The aim is to communicate these details clearly while still maintaining a clean and uncluttered aesthetic. Experience in conversion optimization and user experience principles will also be a significant advantage, as the end goal is not just to inf...
I'm in need of a skilled Laravel developer to create a QR scanner-enabled webpage. This webpage should be capable of updating a database based on the scanned QR code information. I'm not entirely sure whether an existing database can be used for this project, so your experience in setting up databases would be a plus. Key requirements and decisions to be made: - Setting up a Laravel project with QR scanner functionality - Integration of the scanner with a database to update it according to scanned QR codes - The system should handle multiple scans of the same QR code by the same user by ignoring subsequent scans - The primary action the system should take is a check-in/check-out registration process, triggered by the QR ...
...a data entry specialist to clean a dataset to be used for reporting and analysis. Key Responsibilities: - Cleaning up all 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, excel...
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.
I need a cu...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 ...
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. ...
I need an 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 ...
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.
