Convert multiple columns to rows 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)
หาข้อมูล 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 )
...strong level of experience and skills in managing safety issues at large scale events with an expected attendance of more than 5,000. Key Responsibilities: - Develop and implement robust safety measures addressing key anticipated issues including Crowd Control, Medical Emergencies, and Fire Hazards. - Review and approve all safety arrangements and plans prior, during and after the event, - Continuously monitor safety compliance during the event. - Quality control - Auditing and monitoring - Document management - Policy and procedures implementation - Other events safety related matters Skills and Experience Required: - Proven experience in large scale event safety management. - Expert knowledge of various safety threats and first-hand experience in plannin...
I'm looking to build a website to expand my vending machine business into the online space. The site's main purpose will be e-commerce, aiming to sell our range of product worldwide, with a particular focus on customers in Australia. Key Features: - Showcases our product range: plush toys, bouncing balls, and toy capsules. - User-friendly shopping experience. - Able to process payments in multiple currencies. Ideal Skills & Experience for the Job: - Proven experience building e-commerce websites - Familiarity with international shipping, specifically to Australia - Excellent understanding of user experience design.
...experienced software developer to create a PVC software for me. The core features required are: - PDF data extraction and printing: The software should have the capability to extract both text and images from PDF files and facilitate printing of the same. Proficiency in PDF manipulation tools is highly desired. - Image extraction and printing: in addition to text, the software should efficiently extract images for printing. - Localization: The software should fully support localization for all local Indian languages, with specific advantages in Hindi, Tamil, and Bengali. Understanding of the cultural context and linguistic nuances associated with these languages is a bonus. Ideal candidates will have a strong background in software ...
...skilled freelancer to develop a Procurement Management App using PowerApps. This comprehensive app will streamline various aspects of procurement, including sales, purchases, offer comparison, offer creation, order recording, item creation, and purchase analysis. Offer Comparator: The app should allow users to upload supplier offers, compare them against existing database entries, and identify the best offers based on configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and generatin...
I am in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a local area for potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and compile a list of 50-100 angel or private investors from the local area. - Investors must have a previous history of investing in the health sector. - Delivery of the leads in an Excel spreadsheet format. Ideal Candidate: - Proven experience in B2B lead generation. - Good knowledge of the health sector and investment trends. - Excellent research skills. - Proficient in data management and Excel. - Strong communication and negotiation skills.
I'm in need of a talented software developer to create a self-ordering kiosk software. This is an urgent requirement and I'd like the project completed as soon as possible. Key Software Features: - Menu Customization: The software needs to enable users to browse through a customized menu and make their selection. - Payment Processing: The software should integrate secure and efficient payment processing features, accepting multiple payment formats. - Order Tracking: Users must be able to track their orders in real-time through the kiosk software. While no particular operating system compatibility was specified, universal compatibility would be preferred. Past experience in developing similar kiosk software would be a sign...
...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 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'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...
