Excel year to date sum based on monthงาน
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)
หน้าแบบฟอร์ใบเสนอราคา 1. ดึงข้อมูลลูกค้าจาก Database หรือ สามารถเพิ่มรายชื่อลูกค้าใหม่ได้เลย ใช้ Select2 1.1 เมื่อดึงข้อมูลลูกค้าได้มากแล้ว ให้ Auto fill ข้อมูลที่เลือเช่นที่อยู่ใบกำกับภาษี 2. ค้นหาข้อมูลสินค้าในฟอร์ม 2.1 ค้นหาข้อมูลสินค้าได้จาก Database ในช่อง SKU ได้ และ Auto Fill ช่องอื่นๆเช่นรายละเอียดและราคา 2.1 ค้นหาข้อมูลสินค้าได้จาก Database ในช่อง Detail ได้และ Auto Fill 3. SUM ราคาสินค้าแยก VAT และราคารวม 4. ส่งเอกสารให้ ลูกค้าได้ในรูปแบบไฟล์แนบ PDF และ Email ได้ทันที ข้อมูลตามรูปแนบบ ใช้ Codeinater และ Boostrap4
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
ข้อมูลในภาษาไทยจะเป็นไปตาม. YOU MUST BE A NATIVE THAI SPEAKER TO DO THIS JOB!!! NO EXEPTIONS!!! Im looking for someone to complete a SEO on our page: www.d-contact.shop. The page is in pure HTML, so no wordpress plug ins or anything like that. The metatext for google search has already been written in thai. If you deliver good work there might be aditional tasks such as off page SEO. We also have several other pages that needs fixing. ฉันกำลังมองหาคนที่จะทำ SEO บนหน้าของเรา: หน้าอยู่ใน HTML บริสุทธิ์ดังนั้นไม่มีปลั๊กอิน wordpress ins หรืออะไรแบบนั้น มีการเขียน metatext สำหรับการค้นหาของ Google เป็นภาษาไทยแล้ว หากคุณทำงานได้ดีอาจมีงานอื่น ๆ เช่น off page SEO นอกจากนี้เรายังมีหน้าที่อื่น ๆ อีกหลายหน้าที่ต้องการแก้ไข
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
ต้องการด่วน คนที่เข้ามาปิดบัญชีและเรื่องการเงินของบริษัท ด่วนที่สุด สามารถปิดจ้อบงานได้ภายใน 7 วัน ติดต่อ ด่วน URGENT !!!! NEED data entry support for journal entry to close month End accounting statements within 7 days.
สวัสดีคุณ davidbrookesuk ฉันสนใจประวัติของคุณและต้องการเสนอโปรเจคให้คุณ เราสามารถหารือเกี่ยวกับรายละเอียดต่างๆ ผ่านการสนทนาได้ Could you please accept this rate for each manuscript? I have 2 manuscript which the 2nd will be ready in mid month. Be happy for long term collaborate work with you.
Improve my PS website ranking for 10 local keywords in 1 month - organic SEO - white hat only - off-site SEO - website to own the top ranking for 10 local keywords - work report (weekly) - every wednesday - keywords ranking report (weekly) - every wednesday - need to see improved ranking result in 1 month. - not more than 75 USD - keyword นายสิบตำรวจ สอบประทวน สอบนายสิบตำรวจ นายสิบ สายอำนวยการ นายสิบ สายปราบปราม สมัครนายสิบ สมัครนายสิบตํารวจ ติวนายสิบ กำหนดการสอบนายสิบ สมัครเรียนนายสิบ
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
Improve my PS website ranking for 10 local keywords in 1 month - organic SEO - white hat only - off-site SEO - work report (weekly) - keywords ranking report (weekly) - need to see improved ranking result in 1 month to continue another month - not more than 75 USD - keyword นายสิบตำรวจ สอบประทวน สอบนายสิบตำรวจ นายสิบ สายอำนวยการ นายสิบ สายปราบปราม สมัครนายสิบ สมัครนายสิบตํารวจ ติวนายสิบ กำหนดการสอบนายสิบ สมัครเรียนนายสิบ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I am in need of an experienced professional to assist in integrating 2 instances of Unleashed. The primary goal is to optimize 3pl, ordering and inventory management by streamlining the process across both instances. Must be able to get Unleashed platform to talk to our clients unleashed account. Providing live stock updates order from one to another live and automating all this. This will need to be completed this week and no later as we have a tight deadline to achieve this. Flow Chart, Shopify Order > Unleashed > (Updates stock levels on clients unleashed as well as our own)> Send order to clients unleashed. Client uploads new stock > updates our unleashed account. Key Tasks: - Inventory Management: ...
I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understandi...
I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
I am looking for an expert in Excel to help me with a relatively straightforward task. I have data that needs to be reorganized in a new Excel sheet. Key Tasks: - Organize the data by date. - Add a summation formula to the sheet. This project is perfect for someone who is meticulous in data handling, proficient in Excel, and can ensure accuracy and attention to detail.
...Wix expert who can help me with some essential updates to my website. Specifically, I need to add a few new pages and enhance the overall functionality and navigation. Key Tasks: - Improving functionality/navigation: While the specifics weren't included, I'm open to suggestions and recommendations based on your experience. We are a 1 product store, with a recurring Monthly rental. We need to be able to add a flat shipping cost to our product. We need to add specific details to the transaction , such as : Date required and measurements on payment form Request for call back where they enter the date and time Return/refund request submission form A page to add product videos ...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I need a skilled designer for my brand LOGO & BROCHURE GRAPHICS DESIGN . I only have little details then you can decide on Designs but I want the color to consist of Red and Gold with an image of an ancient chair. I want a very mature and presentable Graphic design and my budget for this project is $150 - $350 For the Brochure Design, I want a double folded A3 size brochure with 24 - 48 pages and I can only supply the TEXT CONTENT & PHOTOS but all are with my project consultant, but the logo and brochure will be designed by you and the due date for the project is 20 of next month 2024. The company name is RANDAL FURNITURE INC and is based on importing and exporting of furniture. That is all i can provide from my end and I need...
I'm in need of a Virtual Admin Assistant to help me manage my daily work. Our dailly working time is : 10 - 7pm. We are in retail industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added...
I am lookin...effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing comprehensive plans that can be used for obtaining necessary permits. Your understanding of local building codes and regulations will significantly contribute to the project's success. - Ensuring these detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, y...
U7/U8 Page 1: Change Year to 2024/25 Change volunteer check due date to: September 8th, 2024 Page 2: Down Payment Due 6/12/2024 Change 10 monthly payments to 11 Monthly payments Change payment amount per month to: $85.00 U9/U10 Page 1: Change Year to 2024/25 Change volunteer check due date to: September 8th, 2024 Page 2: Down Payment Due 6/12/2024 Change 10 monthly payments to 11 Monthly payments Change payment amount per month to: $95.00 U11/U12 Page 1: Change Year to 2024/25 Change volunteer check due date to: September 8th, 2024 Page 2: Down Payment Due 6/12/2024 Change 10 monthly payments to 11 Monthly payments Change payment amount per month...
FOR AU BASED FREELANCERS As an authority handling police evidence from Axon, I require assistance with the task of converting these received videos to DVD format. Key Responsibilities: - Convert the received video files into a format that can be recorded onto a DVD. - Ensure that the content retains its High Definition quality post conversion. - Append timestamp inclusive playback on the DVD. Ideal Candidate: - Has experience with Axon video file types. - Familiar with professional video conversion tools and techniques. - Understands the specifics of video recording onto DVDs. - Able to maintain HD quality through the conversion process. - Can annotate with timestamp during playback.
I'm looking to create a comprehensive database of self-managed home care providers in Queensland and Australia to facilitate networking within the industry. Key requirements: - The database should include the provider's: - Name - Address - Email - Prime contact Ideal skills for this project: - Proficiency in data collection and database creation - Familiarity with the home care industry in Queensland and Australia - Organizational skills, to categorize the data by region - Excellent attention to detail, ensuring accuracy in information provided The data should be organized by region for easier networking. I may also require the database to be updated periodically. The collected information should be reliable, up-to-date...
...analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experien...
I'm in need of an expert who can max...the reach and visibility of my videos on YouTube. Key Responsibilities: - Increase video views to drive traffic - Improve video ranking on YouTube - Optimize videos for search engines I'm aiming to build an audience and enhance engagement through these video optimizations. Ideal Skills: - Proven experience in YouTube video promotion and SEO - Deep understanding of YouTube's algorithm - Ability to strategize and implement improvements quickly - Strong analytical skills to measure success and adapt strategies Tasks: - take completed videos and upload to Youtube account - generate SEO, description, hashtags etc Payments will be per uploaded and finalized video with all keywords and des...
I am searching for a freelancer to enhance my local search rankings by creating and managing map citations on Google My Business to reach the top 3 positions with guaranteed results. If you cannot provide a guarantee, please do not apply for this job. Key Responsibilities: - Create high-quality Google Map Citations for my business - Ensure all information is up-to-date and accurate - Regularly monitor and update the citations to maintain their effectiveness Ideal Candidate: - Experience in local SEO and Google My Business - Proven track record in improving local search rankings through map citations - Detail-oriented and a stickler for accuracy - Capable of managing and updating the citations on an ongoing basis - Strong communication skil...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical condi...
...experienced Corporate Secretary to handle key responsibilities for my public company. It's crucial for this role to be filled by someone with prior experience in finance or corporate governance. Key Responsibilities: - Corporate governance compliance: This includes ensuring that the company is following all relevant laws, regulations, and best practices. - Board meeting coordination: You'll be responsible for scheduling and organizing board meetings, ensuring that all necessary parties are present. - Regulatory filings: You should have experience in preparing and filing various regulatory documents, including SEC filings, annual reports, and proxy statements. - Corporate administration: This includes ensuring the company's records are accurate, up-to...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
...the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. 1.To use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websites, and phone numbe. 4. To manually chec...
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'm in search of an experienced salesperson who is fluent in German, Portuguese, or Spanish to help drive sales for my service provider platform in Europe. Key Responsibilities: - The primary goal of this role is to increase sign-ups for the platform, so I'm looking for a professional with a proven track record of doing just that. - You will be focusing on the European market, so knowledge or experience with this particular market would be a plus. - As the platform is aimed at service providers, experience in a similar industry would be advantageous. Ideal Candidate: - Fluent in German, Portuguese, or Spanish. - Proven track record in increasing sales. - Knowledge or experience in the European market. - Experience in the service provider industry would b...
Hi Andrada, You did a project for me last year and the work was excellent. You did research and data entry for 200 lines on an excel spreadsheet. This project is identical. I need to add 53 entries to the same spreadsheet. I would love to work with you again.
I'm looking for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to go ...
