How to create a master list in excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...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
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I need a master of Photoshop to expertly remove an object that is centrally placed in my photo. The object to be removed is distinctly separate, none of the elements in the image overlap or intertwine with it. The ideal freelancer for this project should possess: - Exceptional Photoshop skills, particularly in object removal - Keen eye for detail to maintain the integrity of the remaining elements - Experience in image manipulation and restoration projects. Your goal is to make the final image look as natural as possible, as if the object was never there to begin with. Efficiency and promptness is appreciated.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers ...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
As a music lover primed to release my pop tracks, I'm seeking an audio engineer with a keen ear and deep understanding of sound design. My project requires: - Experience with pop music production - Ability to mix and master 1 to 3 tracks - A creative touch to enhance the sound quality Listening to the music and grasping its essence will be a praxis for this task. Your role will be pivotal in creating a standout sound that remains true to my vision, while maintaining the highest audio fidelity. Let’s make some pop anthems together!
create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concept and process.
create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concept and process.
...freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answ...
I'm looking for an experienced social media manager who can help me in creating and scheduling 200 posts for LinkedIn, Facebook, and Instagram. The posts will aim to target the Saudi market, focusing on Saudi public holidays, patriotism, and more. The requirements for this job are as follows: - Create 200 posts: The posts should be engaging, creative, and tailored for a Saudi audience. They should include high-quality, royalty-free stock photos and be bilingual in both English and Arabic. - Schedule posts: Utilizing Odoo Social Marketing, the successful candidate will be responsible for scheduling these posts for optimal times to reach the target audience. - Target Saudi Market: Understanding the Saudi culture and market is crucial. The posts...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not man...
I'm looking to create several pages for my website, with the primary focus on About and Technology. Home page for my website is already created. The specific requirements are as follows: - About Page: I already have content prepared, so this will mostly involve structuring and formatting. - Technology Page: This should highlight the technologies we work with, and ideally include a section on our technology partners. Additional page requirements include: - Career page - Development Lifecycle page - Development Methodology page - Engagement & Partnership Models page - Inquiry Form page - Technology Partners Page I also have a few other smaller tasks that need to be completed. Skills and experience necessary for this project: - Proficiency i...
Create API for App developer integrate. Estimated 2-3 API only.
Create Microsoft Planner without SharePoint site or MS Teams
Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.
...searching for a skilled Agile Scrum Master to lead a team of very experienced team members in an effort to improve overall productivity. Key Responsibilities: - Utilize Agile methodologies to enhance team performance - Facilitate daily stand-ups, sprint planning, and retrospectives - Collaborate closely with Product Owners to ensure priorities are clear - Identify and help resolve any impediments hindering team progress - Provide regular updates to me via phone calls The ideal candidate should have: - A proven track record of implementing Agile methodologies - Excellent communication skills, particularly over the phone - Ability to lead a team of very familiar Agile practitioners - Strong conflict res...
We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong u...
I need a talented designer who can help me create a visually appealing home page on Shopify. My key focus is to showcase my brand identity. Required Skills & Experience: - Proficient in Shopify - Excellent design skills - Experience in creating a brand-centric homepage - Understanding of user experience principles I have a mockup created in Canva. I need it designed in Shopify for the home page Please include "I am a shopify expert and can do this" to be considered.
VM CREATION (1 VPS BIND) os CentOS 8 & 9 Stream MINIMAL Direct ins...converted from CentOS 8 Linux. (Recommended) panel add install: nginx server VARNICH APACH very important !!!!!snaphopt image creation just servers working (just os) (without admin panel)!!!I want to be able to do restores, for a new installation of another panel, if necessary.! !!! !! !!!!!! link to server add SSL ADD ALL PHP CGI AND FMP (latest 6 versions)PHP AVAILABLE FOR CUSTOMER FOR ALL SERVER ADD PHP VERSION 7.9 PACHT FMMPEG add latest version change SSH22 port verification example: ns1 . add IP.: add a Mac machine adds IP.: adds mac Example of adding HOSTENAME:
...need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project f...
We have print data for packaging but in the wrong format. It's a PDF and all single elements needed to create the new print data are delivered. We need someone who can build this 1:1 If there are questions - just let us know.
I am looking for a skilled developer to create a fully tested and secure website (frontend, backend + admin panel) with no bugs or issues using the MERN Stack. The key features of the front end design include a responsive design, user-friendly navigation, and custom animations. For the backend it would be clean, and fast high quality code with comments and good organisation and readability. The ideal candidate will have experience working with tight deadlines, provide constant high quality updates and be able to deliver quality work within a short timeframe. Bids: Please provide 3 links to your recent MERN/MEAN projects and provide some documentation or proof that you were the original developer of those 3 websites please. Tech: Fro...
Buscamos una persona española que ayude a limpiar los datos de un CRM nuevo, subir datos de excel, validarlos o buscar nuevos con herramientas de Marketing.
Create a tradingview script that: Show a candle from green >red>green and vice versa but the condition that second candele cannot close lower or higher than prior third candele cannot close under previous open.
I am in need of an interactive affiliates page for my website that showcases sister radio stations globally. This page should have a map with icon markers pinpointing station locations, a search feature to find stations by name or zip code, and a list of station names accompanied by location information. Map should allow zoom and going to country specific. So users can see entire map of their country with locations. Ideally we want world map to show first. I want tabs where users can switch between USA or world map. This page will go onto and can be with html 5 and css and js. Key Features: - Display of Sister Radio Stations: - An interactive map should be the centerpiece of the affiliates page, showing all sister radio statio...
We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the...
