Excel add days to date excluding weekends and holidaysงาน
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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
I'm looking for a writer to research and write a "How-to" eBook for more than 7,000 words and my budget is $70 USD for 7,000 words. . Paymaent conditions: Full payment upon completion (No upfront fees) Deadline: 14 days upon project acceptance. Upon project completion, you agree to me having the full rights to the eBook and its content. . To apply, please send me your past work samples so I can better evaluate your writing style . --- ผมกำลังมองหานักเขียนที่จะมาศีกษาหาข้อมูลและเขียน eBook แนว "วิธีการ" ความยาวกว่า 7,000 คำ ผมมีงบ $70 สำหรับการเขียน 7,000 คำ . เงื่อนไขการจ่ายเงิน : จ่ายเต็มจำนวน เมื่องานเสร็จ (ไม่จ่ายล่วงหน้า) กำหนดส่งงาน : 14 วัน หลังจากตอบรับงาน เมื่องานเสร็จสิ้น คุณตกลงที่...
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
ต้องการด่วน คนที่เข้ามาปิดบัญชีและเรื่องการเงินของบริษัท ด่วนที่สุด สามารถปิดจ้อบงานได้ภายใน 7 วัน ติดต่อ ด่วน URGENT !!!! NEED data entry support for journal entry to close month End accounting statements within 7 days.
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm seeking a talented developer to create an add-on for XenForo 2.x that establishes a mod-compatible game system. The main requirements for this project include: - Developing a mod management interface that is user-friendly and efficient. - Implementing a mod system that allows users to upload and download mods, enable or disable mods, and manage mod versions. The ideal candidate for this project should have extensive experience with XenForo, strong programming skills, and a solid understanding of game and mod development. Quality of work, attention to detail, and adherence to deadlines are of utmost importance. If you're interested and would like to discuss the specifics further, plea...
I'm in need of a comprehensive Domains Portfolio Manager to track and manage my domains. Key features include: - Expiration date alerts - Bulk domain actions - Ownership tracking The ideal freelancer for this project should have experience in domain management, software development and UI/UX design. Please provide previous work examples related to domain management tools. OTHERWISE DO NOT APPLY DO NOT APPLY UNLESS YOU SEND YOUR RESUME AND PROOF I WILL PAY YOU $20AUD / MO (in arrears) To manage my large portfolio And to help me move DOMAINS FROM VARIOUS REGISTRARS SUCH AS GODADDY AND DO NOT APPLY TO WASTE MY TIME IF U DO NOT ACCEPT MY ???
...for my coffee shop, Roastique. The logo should primarily feature a coffee cup, convey a sense of simplicity, and subtly incorporate coffee beans. It should reflect the premium quality of our coffee experiences while keeping a clean and elegant aesthetic, suitable for both physical and digital branding. Key Requirements: - Style: A sleek, modern, minimalist, and clean design. - Theme: The main focus of the logo will be a coffee cup, with coffee beans subtly integrated into the design. - Color Palette: Earthy tones like brown, beige, and cream, with possible accents of black or gold. - Formats Needed: PNG/JPEG - Usage: The logo should be adaptable for signage, packaging, social media, and merchandise. Deliverables: - 3 initial logo concepts for ...
Step 1: Key Variables Include the following inputs and calculations: Dates: Check-Out and Check-In Pricing: Daily, Weekly, Monthly, 3-Month Rates Charges: Fuel Surcharge, Damages, Cancellation Fee Mileage: Allowance, Actual Mileage, Excess Mileage Charge Payment: Deposit, Payment Amount, Card Fee Outputs: Total Cost, Refund/Outstanding Amount Step 2: Excel Layout Design an Excel sheet with the following structure: Description Input Formula/Explanation Check-Out Date 01/10/2025 User input Check-In Date 01/25/2025 User input Rental Duration (Days) =B3-B2 Rental Type Daily/Weekly/Monthly/3-Month Dropdown using Data Validation Daily Rate $50 User input Weekly Rate $300 User input Monthly Rate $1,000 User input 3-Month Rate $2,800 User input R...
I need a professional with strong Excel skills to help me analyze sales data using pivot tables in a spreadsheet. The primary aim is to gain insights into sales trends over time. Ideal Skills: - Advanced Excel and Pivot Table expertise - Data analysis experience - Ability to uncover trends and insights from data
...highly motivated and detail-oriented individual for the role of Internet Link Poster. The primary responsibility is to post specific links all across the internet on a variety of websites, forums, platforms, and communities. You must find suitable locations to post these links and ensure they are relevant, well-placed, and stay permanently online. Only links that remain live will count toward your daily target of 160 links. This full-time position will become easier with practice as you learn to identify the best posting opportunities efficiently. Key Responsibilities 1. Posting Links Across the Internet: You are responsible for posting links on different websites and platforms every day, including but not limited to: Onlin...
Found the Selected Data from One Excel file on the Other File. Both files are provided for reference. "Scores" sheet, find the same song on the
I'm in need of an Excel template builder who can create a template for weekly reports concerning employee shift schedules. The primary focus of these reports will be on scheduling management. Key Requirements: - Build an Excel template that can track employee shift schedules on a weekly basis. - The template should be user-friendly and easy to update with new data. Ideal Skills: - Proficiency in Excel and its advanced features (like pivot tables, VLOOKUP, etc.) - Experience in designing Excel templates. - Understanding of scheduling management. I am looking for someone who can complete this task efficiently and accurately, allowing for smooth tracking of employee shifts.
We are seeking a versatile Data Analyst to support multiple companies across different industries. The ideal candidate will excel in transforming raw data into actionable insights using various visualization tools and will be adept at managing and querying databases.
... We are seeking a motivated and results-driven Sales Representative to join our dynamic team at Kalaakaar Makerspace, a leading provider of CNC machining and laser cutting services. The ideal candidate will be responsible for developing new business opportunities, maintaining strong relationships with existing clients, and driving sales growth in the CNC and laser cutting industries. As a Sales Representative, you will be the face of our company, ensuring customers understand the benefits and capabilities of our services, and effectively closing sales while delivering outstanding customer service. This role requires strong communication skills, and the ability to manage multiple accounts and projects. Key Responsibi...
I need a freelancer to convert a 3-page PDF document into an Excel file. The Excel layout should mirror the PDF exactly. The PDF contains primarily text and numbers. Key Requirements: - Convert data from the PDF into Excel, maintaining the original layout. - Utilize your judgement to handle any ambiguities or potential errors in the PDF. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to make educated guesses when faced with uncertainties in the source material.
...very carefully and only apply if you agree with the payment and initial short deadline, submit your bid using the format below or it will be immediately rejected ******* URGENT PROJECTS I currently have three important research projects that were due this Saturday but were not started. These must be completed by Sunday, 5:00 PM MST. I have created detailed instructions and expect minimal questions. No time extensions will be granted. If you can complete these by the deadline, you will receive a guaranteed $30 CAD plus a significant gratuity for timely and high-quality work. START IMMEDIATELY You must be able to start these major projects today and dedicate significant time to ensure completion by Sunday. Only apply if you have sufficien...
...project is to develop existing MFC data logging visualisation app 'DeltaLog' to update it and bug fix issues, including implementation of BCGControlBar Pro. List of requirements: • Use BCGControlBar Pro (provided) to replace MFC classes and update look and feel of windows/frames/borders and to enable tabbed windows • Activate track map window and plot GPS track bitmap • Allow mixing of y-axis for channels with same scaling • Add function to change plot order • Fix X-Y plot conditioning • Fix bug when some channels are not plotted • Save/open desktop layout • Fix maths wizard • Add sort by name/date etc. to open file dialog...
...have an Excel file with multiple tabs, each representing a month of the year. Within each tab, my products are listed in one column, and the days of the month are represented in rows. The cells that intersect contain a number representing the quantity of products sold on the corresponding day. I need a new dynamic tab created that has at least two columns: one for products that have sold at least one unit, and another for the total number of items sold. Products that have no sales on a given day should not be displayed. This new tab should be dynamic, allowing me to see which products have sold on a given day. There should be a day selector that filters the products accordingly. Specific Requirements: - The new tab should be formatted as a simple ta...
I'm in need of an Excel wizard to create a Monthly Sales MIS Report for me. This report needs to focus exclusively on sales data and perform a trend analysis. Key Responsibilities: - Collect and analyse sales data on a monthly basis. - Identify and illustrate trends in the sales data. Ideal Skills and Experience: - Proficiency in Excel, including the use of advanced functions and features. - Previous experience in creating MIS reports. - Strong analytical skills with a focus on trend analysis. - Excellent attention to detail.
Chemical Engineer Needed for Creating Industrial Chemical Datasheets and Catalogs **Description:** We are looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and catalogs for our products. **Requirements:** - Research and compile technical specifications and industry applications. - Prepare datasheets and catalogs in editable formats (Word, Excel, and PDF). - Ensure the output is professional, accurate, and visually appealing. **Skills Required:** - Strong knowledge of industrial chemicals. - Proficiency in Microsoft Word, Excel, and PDF tools. - Excellent research and writing skills.
I'm looking for an Excel expert who can help me build a comprehensive report showing Actuals vs Budget vs FC vs PY. The report will primarily serve as a financial overview tool and needs to be updated daily. Key requirements include: - Proficient in Excel with advanced skills in data analysis and visualization. - Experience working with internal databases and external data feeds. - Ability to understand and interpret financial data. - Capability to create automated daily updates for the report. Please include examples of similar projects you've completed in your proposal.
...development team to build a multi-platform business services platform that enables clients to purchase and manage various business services, including branding, printed materials, social media management, and ERP software solutions. Project Overview Platforms: Web Application Mobile Applications (iOS and Android using React Native Expo) Dashboards: Client Portal Admin Portal Employee Portal Guest Portal Preferred Tech Stack: Frontend: React (Web) and React Native Expo (Mobile) Backend: NestJS or Database: Prisma ORM Core Features Guest Portal (Web & Mobile): Welcome screen showcasing platform highlights. Options to sign in, sign up, or continue as a guest. Menu with sections: Products, About Us, Portfolio, Branches, and C...
...hours and no cold calling? We have the perfect opportunity for you! We are seeking a Bilingual Customer Support Specialist (French & English), with experience in Sales or Customer Service, who can handle both inbound and outbound phone inquiries. The main focus of these calls will be providing product information, transfer calls to the appropriate team members, and to schedule appointments for our salespeople. About the Role: No cold calling: You will handle incoming calls and follow up with customers who have requested moving information through our website. Your main responsibility will be to schedule appointments in the seller’s calendar, enabling them to assess the volume of goods to be moved efficiently. Wh...
...Manager to oversee and execute advertising campaigns on Facebook, TikTok, Google Ads, and Twitter. The ideal candidate will have a deep understanding of digital marketing, experience in identifying target audiences, setting up and optimizing campaigns, and analyzing performance to provide actionable insights. Position will be WEEKLY - Approx 5 hours to start per week Responsibilities: Campaign Management: Develop and launch targeted ad campaigns across Facebook, TikTok, Google Ads, and Twitter. Research and identify the best-performing audiences and demographics for each platform. Create compelling ad copy, visuals, and landing pages to maximize campaign effectiveness. Strategy & Targeting:...
...name is Bhuvanesh Madaiah and I work for MarketingPRO, an Italian marketing service company well active in the area of international market intelligence surveys. For more company info, please surf I’m writing this while we are discussing a potential market survey in Japan (preferably Tokyo greater-area) in the Automotive sector. We are looking for a professional contact person interested in having an active role in this survey. Below is some general information in regards to the project: THE ACTIVITY We would need the contact person to gather market retail prices of a precise list of Automotive spare parts. Just to make an example, we will provide the person with part numbers short-listed of parts (like oil filter insert, alternator, rear bumper ...
We are looking for a skilled developer to help us integrate ActiveCampaign Event Tracking into two WordPress websites. The primary goal is to track PDF download button clicks and send associated metadata (destination and date) to ActiveCampaign using their Event Tracking API. Our Needs 1. Button Tracking Requirements: • Track all PDF download buttons on two WordPress websites. • Each button contains unique metadata in the form of data-* attributes: • Destination: The name of the location (e.g., country or city). • Date of Departure: A specific date tied to the PDF. • This metadata needs to be dynamically captured when a button is clicked and sent to ActiveCampaign. 2. Integr...
I'm seeking a meticulous freelancer for a data entry task. The job entails transferring data from a 300-page PDF file into an Excel spreadsheet. The data needs to be organized into clear columns such as First Name, Last Name, Address, City, ZIP Code, and Other relevant details. Requirements: - Exceptional accuracy and attention to detail. - Experience in data organization in a clean and structured format. - Timely delivery of the completed file. The data in the PDF file is text only and has a consistent layout. If you're interested, please provide your estimated time and cost for this task. Thank you!
...pages(from admin pabel), OTP verification, Abandoned cart notification, order notification and payment gateway integration Note 99.9% website has to be managed through Dashboard, like editing pricing, bulk import,export,bulk move with-in pages, bulk edit, bulk delete, Hide category, in page pages or multiple pages, Edit in one page or multiple pages, though coded the website has to act plug and play Ecommerce Website USP - We give return gifts to customers based on Invoice size- hence the designs is detailed accordingly You need to first ensure that Gift cards with 16 digit or 12 digit secure login with pin code (as an example shown in myntra), • Coupons creation in admin panel with expiry date and with a condition which wi...
I'm looking for an Excel expert to create a macro that will help in task automation. The specific tasks to be automated will be discussed later. Ideal Skills: - Proficiency in Microsoft Excel - Experience in developing macros for task automation - Excellent problem-solving skills - Ability to understand and analyze tasks for automation Please provide examples of similar projects you've completed in your proposal.
...freelancer to provide phone support for my customer service needs in ROMANIAN. Skills and Experience: - General customer service skills are sufficient, industry-specific knowledge is not required. - The freelancer should be fluent in ROMANIAN and have excellent communication skills. - Previous experience in customer service is desired. - The freelancer should be able to handle phone inquiries and provide assistance to customers. - The expected workload is cca 1-3 hours / day, every working day is needed. Important: Part-time job: every work day, somewhen (when it fist you) between 9am and 6pm CET, you’d have to: • you have to call the fresh orders, who just bought something in our client's web shop, ...
...based in Indonesia to conduct a detailed survey and provide actionable insights for our teak wood products business. This freelance role requires a keen eye for detail, strong organizational skills, and the ability to work independently. Job Description: As a Market Research Specialist, your primary responsibility will be to gather comprehensive data and insights across key areas critical to our business operations in Indonesia. This includes supplier sourcing, price analysis, rental market research, and workforce recruitment strategies. Responsibilities: Supplier Sourcing for End Grain Teak Wood Cutting Boards Identify reliable suppliers specializing in end grain teak wood cutting boards. Verify production processes, including...
