Raw data 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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
analysis raw data to information วิเคราะห์เนื้อหา บริการ สินค้า ผลิตภัณฑ์ ทุกอย่าง ว่ามีข้อดี ข้อเสีย ประโยชน์ที่จะได้รับมีอะไรบ้าง เป็นต้น
I'm seeking a skilled video editor to help me create engaging, fast-paced shorts for AI enthusiasts. Key Responsibilities - Edit raw footage into entertaining, quick-paced content - Incorporate subtitles and background music seamlessly - Meet daily editing deadlines Ideal Skills and Experience - Proven experience in editing shorts or similar content - Proficiency in using video editing software - Strong understanding of pacing for entertainment - Ability to meet daily deadlines
I need a data entry form with over 100 fields. The form will be used for inputting mixed data (text and numbers). The entered data should be able to be synced into 10+ sheets with the push of a button. Requirements: - Design a data entry form with 100+ fields - Mixed data input (text and numbers) - Data synchronisation into 10+ sheets manually with a button Key Skills: - Proficient in Microsoft Excel or Libreoffice Calc - Experience in creating complex data entry forms - Knowledge in setting up data synchronisation - Familiarity with data validation rules Some fields in the form will need validation, so experience with setting up data validation rules is essential. Please reach out if you have the relevant ski...
Estamos buscando un Asistente de Ingreso de Datos detallis...verificar datos en hojas de cálculo o sistemas internos. Organizar y clasificar información de manera precisa. Revisar documentos para corregir errores o inconsistencias. Mantener la confidencialidad y seguridad de los datos. Cumplir con plazos y objetivos establecidos. Requisitos: Experiencia en ingreso de datos o trabajos administrativos (deseable, pero no obligatoria). Manejo básico o intermedio de Excel, Google Sheets y otras herramientas de oficina. Atención al detalle y habilidades organizativas. Capacidad para seguir instrucciones y trabajar de forma autónoma. Si estás interesado/a, envía tu solicitud junto con una breve presentación sobre tu experiencia y dis...
...encouraging and supportive work environment? We are looking for a trustworthy and reliable EA/PA for a philanthropist / filmmaker with an interest in wildlife. The tasks will involve working on ad-hoc projects with the charities, film shoots and assistance with personal matters. The role is not just about organisation - it’s about a long-term partnership. If you have excellent communication skills, excel with logistics, have an analytical mindset and enjoy making this happen, the role is for you. Please note that the role is remote-based and the client is primarily based in Europe. Main tasks Carrying out various personal assignments of the manager related to business: real estate search, insurance, service provider companies; Search for contractors for assigned t...
I need assistance with data entry focused on numerical data sourced from printed documents. The data needs to be entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry from printed documents - Ability to handle numerical data Please note, this project requires meticulous data handling to ensure accuracy and completeness.
Sending Email and PDF generation from Excel
...7. Auto-Update from Google Sheets: If any data is removed manually from Google Sheets, the respective seat(s) should become available for new reservations. 8. Seat & Branch Management by Owner: The owner should have access to add or delete seats as per onsite requirements. Owners can also create new branches or delete old ones when needed. 9. Live Display of Seating Chart: A live seating chart should be available to display on a TV screen at the library branch. This will help new subscribers see which seats are available in real time. 10. Technical Requirements: Frontend: HTML, CSS, JavaScript (React.js preferred) Backend: Node.js with (or Django/Flask if using Python) Database: MySQL or Firebase for storing seat assignments Excel Handling: Google Sheets integr...
I would like to request the completion of data extraction for all matches of the 2024-2025 season and the integration of this data into the existing file while maintaining the Excel format. Additionally, please provide me with the source code used for the data extraction process. Let me know if you need any further details. Looking forward to your response. Please note that the final deadline for submission is today. Let me know if you need any further details.
I'm seeking an experienced data analyst to dissect COVID-19 data. The focus will be on death and recovery rates, with the ultimate aim of pinpointing the geographical spread of the disease. Key Aspects: - Analyze death and recovery rates from COVID-19 - Identify geographical patterns in the data - Present findings in a clear, accessible format Ideal Skills: - Proficiency in data analysis software (e.g., Python, R, Excel) - Strong statistical skills - Ability to communicate complex findings simply - Ability to visualize and present data in a smooth, easy-to-understand manner Expected outputs: - The file should contain data analysis and graphics that illustrate these analyses. Deadline: - It is preferable to deliver the work within s...
Sono alla ricerca di un sistema per generare un catalogo prodotti in PDF sulla base di un template popolato con dati archiviati su tabelle Excel o SQL. Allego un esempio del catalogo che vorrei ottenere.
I'm seeking an experienced video editor to help transform my raw footage into engaging clips for my social media channels, primarily Instagram, YouTube and TikTok. Ideal Skills: - Proficient in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro, etc.) - Experience with editing for social media platforms - Creative mindset with a good understanding of current social media trends Please provide examples of your previous work, specifically any content you've edited for the aforementioned platforms.
Service Member Excel Tracker. I need an Excel spreadsheet with automated formatting and drop-down lists. Conditional Formatting – The "Action" cell will turn red if more than 3 days have passed since the date was entered. Drop-Down Menus – "Types of Service" in Column B "Reason(s) for Visit" in Column I with all the requested options below: • Army Credentialing Assistance • ArmyUniversity BNCEDP • ArmyIgnitED Enrollment • ArmyIgnitED Problems • ArmyIgnitED Information • ArmyU Credentialing • BSEP Counseling • Chapter Counseling • College Information • Commissioning Assistance • Dashboard • Exception to Policy Counseling • Financial Aid Information • HE Track C...
Service Member Excel Tracker. I need an Excel spreadsheet with automated formatting and drop-down lists. Conditional Formatting – The "Action" cell will turn red if more than 3 days have passed since the date was entered. Drop-Down Menus – "Types of Service" in Column B "Reason(s) for Visit" in Column I with all the requested options below: • Army Credentialing Assistance • ArmyUniversity BNCEDP • ArmyIgnitED Enrollment • ArmyIgnitED Problems • ArmyIgnitED Information • ArmyU Credentialing • BSEP Counseling • Chapter Counseling • College Information • Commissioning Assistance • Dashboard • Exception to Policy Counseling • Financial Aid Information • HE Track C...
I'm looking for a skilled Excel VBA programmer who can help me fix my current VBA code. The code is supposed to automate repetitive tasks, but it's producing incorrect results. - Code Fixing: The primary task will be troubleshooting and fixing the existing VBA code. - Automation: After fixing, I will need the coder to enhance the script to automate more tasks in Excel. Ideal candidate should possess: - Proficient knowledge in Excel VBA - Experience in coding for task automation - Problem-solving skills to rectify existing code - Attention to detail to ensure accuracy in results.
I need 50 thousand companies name and Email. This should be only from CHINA region and the companies should be manufacturer. This is on urgent basis The data should be provided in an Excel file format. Focus on manufacturers in the Technology industry. The data should be delivered within 2 days. Please include the following details: Email and company name. No Please include the following additional details for each company: None. The data should be collected from: any site. Ensure all email addresses are verified for authenticity and validity. None. Please ensure the emails are specific to the Manufacturing department.. PLEASE SEND 5000 SAMPLE FIRST TO GET AWARDED THIS IS URGENT SO ONLY REAL PERSON.
Power BI Training Opportunity (Onsite - Maryland, US): Experience...24-28, 2025. May choose to hire for one or both sessions. Pay: $4,000 per session, not to exceed $8,000 total for both sessions. Travel costs will not be provided. Trainee Skill Levels: Attendees have varying levels of experience with Power BI, ranging from basic to intermediate, with many being advanced Microsoft Excel users. The training should accommodate this diverse skill set. Content: The training must cover topics such as connecting to data sources, data cleaning, data visualization, advanced analysis techniques, creating dashboards, and sharing reports. All training materials must be provided digitally at least one day prior to the start of training. The training must also inclu...
...company channel. 3. Company Channels & Groups: o A dedicated company-wide channel for announcements. o Ability to create department-specific or project-based channels. 4. Direct Messaging & Group Chats: o Employees can chat one-on-one or create group conversations. o Read receipts and typing indicators for real-time communication. 5. File Sharing & Storage: o Upload and share documents (Word, PDFs, Excel, images, etc.). o Cloud storage integration for easy file access. 6. Communication History & Search: o Chat history is saved for future reference. o A search function to find messages, files, or contacts. 7. Notifications & Alerts: o Push notifications for new messages, mentions, and file shares. o Customizable notification settings for users. 8. User Roles &a...
I am seeking a skilled WordPress developer to upgrade my existing website. The project involves enhancing the site's design, improving functionality, and ensuring responsiveness across devices. Familiarity with the latest WordPress plugins, firebase, GTM and themes is essential. The ideal candidate should have a keen eye fo...add a link to the store visit history page that shows the visitors of a specific store. 3. add graphical elements like a bar chart on the store visit history page to show the first 10 store visits per day. it should be related to the filter. 4. add a category statics page with a date filter and it should have charts like bar, pie and others. 5. detect user city and country from IP. 6. export data as Excel from the store visit history page. my websi...
I need assistance with a data entry task involving mixed data (both text and numbers). The data is sourced from digital files in Excel format. Key Requirements: - Proficient in Excel, with excellent data entry skills. - Able to accurately transcribe mixed data (text and numbers). - Detail-oriented to ensure data integrity. - Prior experience in similar data entry tasks is preferred.
I have a basic rules file edited in notepad or similar. I would like to duplicate... I would like to duplicate and modify the rules (name, 5 conditions and 2 values) into the duplicated rules. I have all the data that needs inputting in an excel table. I am happy to enter the required data but am looking for a tool that will create/edit the rules file with the desired amounts. I have a rules file in notepad that needs to be rewritten into an Excel file. The rules are conditional formatting rules and are relatively simple. The data in the notepad file is structured as plain text with delimiters. Ideal Skills: - Proficiency in Excel - Understanding of conditional formatting rules - Ability to interpret plain text with delimiters Experience in ...
I'm looking for a skilled Power BI dashboard developer to assist me in creating a comprehensive dashboard. The primary purpose of this dashboard is to track various performance metrics. Requirements: - Integration with Excel spreadsheets - Visualization of data in the form of charts and graphs Ideal Skills: - Proficient in Power BI - Extensive experience with Excel - Excellent data visualization skills - Strong understanding of performance metrics tracking Please provide examples of your previous work with Power BI dashboards.
I'm seeking an Excel expert to upgrade my existing sheet, initially designed for resource capacity planning, to incorporate varying cost calculations dependent on the project at hand. Key Requirements: - The upgraded Excel sheet should be suitable for project management, particularly in resource planning. - It should allow for the use of multiple labor rates in cost calculations, reflecting the different costs associated with various projects. - The sheet should be able to accommodate changes in cost based on the specific project being worked on, enhancing the accuracy of resource cost forecasting. Ideal Skills: - Extensive experience with Excel, particularly in creating complex formulas and calculations. - Prior experience in project management resource plannin...
I'm looking for a professional who can assist me in sending promotional broadcast messages to my customers via WhatsApp. - Content: The broadcast will primarily consist of promotional offers. - Custome...customers via WhatsApp. - Content: The broadcast will primarily consist of promotional offers. - Customer List: I already have a ready list of customer phone numbers, so I need someone who can efficiently handle the sending of the messages. - Format: My customer list is in an Excel/CSV file, which I can provide. Ideal skills for this project would include experience with WhatsApp Business API, understanding of promotional messaging best practices, and proficiency in handling Excel/CSV files. Knowledge of data privacy regulations and best practices for cust...
You will get a high-end and robust calendar based entirely on Excel! I have over ten years of experience in automating tasks in Excel using formulas and VBA code, and I know that a few automations at the right spots can simplify your daily routine, save you dozens of hours, and boost your performance while focusing on what matters! In the delivered calendar, you will have the option to customize the categories/personnel that will be assigned the tasks or appointments. Based on the selected version, more features are available, like customizing colors, attaching documents, exporting to PDF, and more.
Se busca responsable de catálogo ecommerce. Puedes ver todos los detalles del rol en el documento adjunto. Las habilidades principales que se requieren son: - Buena capacidad lógica y de razonamiento - Mucha organización y buen manejo de Excel/Google Sheets - Ganas de trabajar y de aspirar a crecer profesionalmente El manejo de Amazon no es un requisito indispensable ya que te podemos formar internamente para usarlo. Es un ecommerce complejo de más de 600 productos personalizables por el usuario y requiere de alguien capaz, con muy buena organización y capacidad de razonamiento lógico bueno. Remuneración: 100% REMOTO. Es una gran oportunidad. Se paga entre 1,200 y 1,500 USD al mes.
I'm seeking a data analyst with experience in SQL and Crystal Reports. The task involves creating a crystal report to generate monthly Intrastat declarations derived from our sales data. This data is stored in a SQL database and needs to be transformed into Excel format for the reports. Key components of the reports: - Sales data fields: Product information, Transaction value, Date, Invoice No, Customer Name, Item Description, Quantity, Item Amount Value, Nominal Code, SIC, Weight Each, Line Weight Amount, Gross Amount Value, Type, Customer VAT No. - Customer-based segmentation for the reports. Ideal skills: - Proficiency in SQL and Crystal Reports. - Experience with sales data analysis. - Ability to segment data by customer. - Exc...
I'm seeking a proficient English typist to assist with transcribing scanned images into PDF documents. The tasks will include: - Typing documents from scanned images - Data entry into MS Excel - Copy and paste tasks Ideal candidates should have exceptional typing skills with a knack for accuracy and speed. Proficiency in MS Word and MS Excel is a must, as well as experience with data entry. If you're capable of delivering high-quality work in a timely manner, I look forward to your proposal.
I'm in need of a skilled video editor for a corporate promotional video. This video will require a professional touch and a keen eye for detail. Key Responsibilities: - Edit raw footage into a cohesive and engaging promotional video - Integrate voiceover seamlessly into the video - Select and incorporate appropriate background music to enhance the video's appeal Ideal Freelancer: - Proven experience in video editing, particularly for corporate promotional content - Strong understanding of pacing, timing, and narrative structure - Ability to work with voiceover and music to create a polished final product Please provide examples of similar projects you've completed.
I need a freelancer to transcribe a research questionnaire into an Excel spreadsheet and populate it with 500 dummy data entries. Key Requirements: - The questionnaire consists of 60 questions, most of them in a Likert scale format and focused on collecting demographic and behavioural data. - The final Excel file should simulate 500 responses to the questionnaire, based on criteria provided Ideal Skills: - Proficiency in Excel - Experience with data entry and data simulation - Familiarity with Likert scale and behavioral research. Please ensure that your proposal includes relevant experience and a brief outline of your approach to this task. Include the word 'Ninja' in your PM.
