Macro read data excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ 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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...Experience using Vendor Central and AMS portals is an advantage. • Strong interest in e-commerce and digital marketing. • Excellent written and verbal communication skills with the ability to adapt to different audiences. • Strong understanding of budgets, targets, and product pricing. • Proficiency in analysing sales data and making data-driven recommendations. • Self-motivated and proactive with exceptional organisational skills. • Proficient in Microsoft packages including Excel and PowerPoint. • Knowledge of graphic design is an advantage. Join our team as an Amazon Account Executive and take your career to new heights! Apply now and be a part of a dynamic and innovative organisation that values your skills and offers growth ...
Have you made a Sleep Tracker App? Great contact us and provide Playstore link so we can review $1500 budget ,- No milestones Sleep Tracker & Sleep Sound App Development (Provide sleep app APK you made, send by chat) *******Amazing how most people don't read or follow instructions******* *Read attached PDF with requirements *Will not do Milestones (Get paid once project is completed) *Only Real bids No placeholders. *Send APK by chat of sleep app you made *Send chat direct instead of bid as you have a better chance of us seeing it I'm seeking a seasoned professional Flutter developer to create a comprehensive Sleep Tracker / Sleep Sounds App. This app should track sleep and include an extensive library of sleep sounds, meditations, stories, music, and vide...
I need assistance to extract data from a PDF document into an Excel spreadsheet for 200 organisations. The data includes organisation names, emails, telephone numbers, and postal addresses. Key Requirements: - Proficient in data extraction and Excel - Previous experience working with PDF files - Attention to detail to ensure data is accurately transcribed It is essential for the freelancer to have the ability to carefully transcribe the information from the PDF to the Excel spreadsheet without errors.
I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics
I'm looking for an experienced professional to assist with reconciling my business bank account using Microsoft Excel. This task involves reviewing deposits, withdrawals, and transfers. Key Responsibilities: - Bank Account Reconciliation: You will be responsible for ensuring all transactions are accurately recorded and accounted for. - Invoice
We are seeking a full-time, bilingual translator for our new division in Turkey. This role will involve translating content from English to Turkish and vice versa. Key Responsibilities: - Translating marketing materials and office conversations from English to Turki...plus. - Strong understanding of both English and Turkish cultures. - Detailed CV Skills Required: - Bilingual in English and Turkish. - Translation skills, particularly for marketing and conversational content. - Cultural understanding of both English and Turkish contexts. Please provide us with your CV if you wish to apply. If we invite you to this job respond with " Yes, I read it all" so we know you actually read our requirements. Starting pay is 30$ per hour with a raise every 3 months if we ar...
We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.
...The design MUST include a representation of the watch and the application display. A screenshot is provided as a reference. 2. **Text Elements:** - The application name "SHOT CLOCK" must feature prominently in the design. - One creative option is to use the graphic of the watch and its display as one of the "O"s in "SHOT CLOCK." - The design must be clean and ensure the name is easy to read. - The URL "" should be incorporated into the main design if it fits cleanly. If it cannot be included without compromising the design's cleanliness, the URL will be placed on the rear of a baseball cap or elsewhere on the promotional material. 3. **Color Scheme:** - Use no more than four colors to ensure ease of embroidery and prin...
I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provid...optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported da...
I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.
...looking for an experienced data analyst who can help me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data...
...ensure deadlines are met. 5. Sugarcrete Initiative: Research and compile a list of bagasse suppliers in Belize for future brick manufacturing. Track costs related to Sugarcrete separately from gym expenses. Ideal Skills & Experience: Strong project management and organization skills. Experience with branding, marketing, and social media management. Proficient in financial tracking tools like Excel or Google Sheets. Familiarity with website development, online payment systems, and POS systems. Great communicator and skilled at keeping others on task. Resourceful with research and able to present clear recommendations. Scope & Budget: Scope: Ongoing, with a focus on the gym setup and other key projects in the first few months. Estimated Hours: 15–20 hours per week...
I'm seeking a talented anime character designer to illustrate one of my characters. This character is the protagonist of my story. He is a kind and compassionate young man who wants to be a hero like the ones in the stories he loves to read. Other known characteristics is that he has dimples when he smiles. He is what people like to call the "cinnamon role" character. A candidate should have extensive experience in designing characters from the ground up and the ability to follow instructions. Attached is AI generated image of what I envision the character to look like. Please note that this image is for your reference ONLY! The traits I want from this image is the skin color, the hair color, hairstyle (minus the braided hair/ponytail) His body type is a bit lean...
...for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow and identify automation oppor...
...Status Updates: Requests should have statuses: Pending Under Process (after Engineering Manager approval) Completed Status changes should trigger notifications. Dashboards & Reporting: Basic dashboard with the following insights: Request counts (by status, department, and priority) Average lead time (from submission to completion) Filter requests by department, category, status. Export reports to Excel/PDF. Access Control: Only authorized roles can approve/reject requests. Unauthorized users should see appropriate error messages. Custom request forms based on department/role. Technology Preferences: Web-based (accessible via PC & mobile). Simple UI with minimal complexity. Hosted online for real-time access. Suggested stack: Node.js (), MongoDB (or simple JSON storage...
I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.
Riovily Agency, a professional Digital Marketing Agency, specializes in delivering high-quality Explainer Videos and Email Marketing Services, along with web design and social ads. We are currently seeking two talented Salespeople or Closers to join our team and secure deals with businesses looking to enhance their marketing strategies. Please Read the JD Carefully. We are looking for a Saleperson with good English and Closer skills. We are not looking for Video experts. Thank you Our website: Responsibilities: Identify and engage potential business clients interested in Explainer Videos and Email Marketing services. Effectively present and pitch our services to prospects, highlighting their benefits and ROI. Build strong relationships with clients through excellent
I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience
I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets
...Operational analysis Which areas of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk management (1-2 indicators). 2. Describe the perspective of the customer selecte...
I'm looking for an expert Java developer who can assist me with a project focused on creating a specific web application. This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Res...implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet. I will need you to be good in creating weekly contnets meeting the topic lsited in the excel sheet but at the same time implementing the skills and knowledge toward completing the assignment. Please only contanct me once you go through the assignment and the excel...
Please read carefully. We’re looking for talented and detail-oriented professionals or teams to collaborate with us on creating premium animated videos. We are an animated video agency specializing in creating animated explainer videos for Software and tech companies. This is a project-based role with the potential for long-term collaboration. SCOPE OF WORK You’ll be responsible for delivering high-quality custom animations that align with our client’s brand and messaging. Specifically, you will: - Design custom graphics and storyboards based on the provided script and voiceover. - Create premium animations with seamless transitions, character animations, and other advanced techniques. - Add music and sound effects (SFX) to enhance the video’s impact. - C...
Opportunity Management Web App Overview Build a simple web application that allows users to create, read, and update “opportunities” (requests from customers for help). The app should include: Frontend: A React-based UI Backend: A Node.js/Express API Database: MongoDB for data storage Feature Requirements Create an Opportunity A form where a user can enter the details of a new opportunity Required fields: title (string) description (text) status (enum: Open, In Progress, Closed) customerName (string) opportunityType (enum: Help Request, Handover, Cover Request) startDate: (timestamp, applicable to Handover and Cover Request only) endDate: (timestamp, applicable to Cover Request only) createdAt (timestamp, auto-generated) updatedAt (timestamp, auto-generated) List...
I need a professional who can help me extract data from my Clover POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, with taxes...
I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets
I'm looking for a professional, engaging, and informative PowerPoint presentation on Saudi Arabian culture, targeted for a new American manager. The focus should primarily be on business interactions, but also touching on macro overview, religious customs, social norms, and other crucial aspects. The presentation should: - Be designed to fit within a 1 hour timeframe. - Incorporate infographics to make it visually appealing. - Include a selection of helpful videos at the end, providing further context and insight. I have provided some links to videos that can serve as a baseline for the content: - - - Ideal candidates for this project should have: - A deep understanding
...contracting business. The ideal candidate will have experience in the construction and real estate industry and be proficient in using Excel for financial modeling, reporting, and analysis. Key Responsibilities: Prepare and maintain annual budgets, revenue forecasts, and expense tracking using Excel. Analyze cash flow and ensure liquidity to meet operational needs. Assist in financial decision-making by providing insights and recommendations. Monitor project budgets and ensure financial alignment with company goals. Develop financial models to forecast project costs and returns. I am looking for an experienced financial analyst who can help prepare a comprehensive Excel workbook that includes all necessary formulas for financial analysis across various aspects of...
