How to set expiry date in excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ต้องการระบบรับ Realtime feed จากตลาดหลักทรัพย์ (SET/TFEX) ข้อมูลที่ต้องการได้แก่ Ticker/BidAsk5ช่อง/CandleStick 1MIN/15MIN/30MIN/60MIN
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
We are seeking a skilled professional to build an Excel model for our early stage company that manufactures and distributes outdoor furniture. Our business operates through various channels including direct-to-consumer (DTC), retail, and B2B. The Excel model will be instrumental in analyzing and forecasting sales, expenses, and profitability. It should provide clear insights and help in decision-making processes. The successful candidate should have expertise in financial modeling, Excel, and a good understanding of manufacturing and multi-channel distribution. Attention to detail, strong analytical skills, and the ability to work independently are crucial for this role.
I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.
I need a skilled Excel user to help me format a single spreadsheet and create formulas to automate some calculations. Key Responsibilities: - Format the spreadsheet to make it visually appealing and easy to read. - Create formulas to automate calculations based on the data input. - Ensure the spreadsheet is user-friendly and easy to update. Ideal Skills and Experience: - Proficiency in Excel, particularly in data formatting and formula creation. - Prior experience in handling data-heavy spreadsheets. - Strong attention to detail to ensure accurate data processing. - Ability to work independently and deliver the project in a timely manner.
I am searching for a knowledgeable expert in Microsoft Excel who can assist me with a variety of tasks. Specifically, I require aid with formulas and functions, and formatting and design. More specifically, I need assistance with summation and averages, and VLOOKUP and INDEX-MATCH commands. The ideal candidate would have substantial proficiency and experience with Excel, with an emphasis on utilising complex formulas and creating aesthetically appealing and comprehensible spreadsheets.
I need someone to set up the ability to automatically run a plugin installed on two websites developed with WordPress. Specifically, I need a system that can be edited by me and that allows me to set: - Date/days (either a specific date or telling it to start every day or only from Monday to Friday) - Hour (so that i can choose at what time to run this activity) - Repeat the action X amount of time later (e.g. repeat the same action 30 minutes later) This tool will have to activate, according to the settings selected by me, a plugin already present on the website.
Hi I need help with the following 3 tasks in my website, my website is built on Wordpress. COOKIE POLICY PLUGIN Im currently having an issue with my cookie plugin, it is not displaying on my website even after excluding its scripts and files from my cache plugin, the issue appeared after I deactivated and deleted my old cookie plugin "Cookie Notice & Compliance for GDPR / CCPA" I now want to use a new plugin called "#" but it is not loading at all. I need you to look into why my new plugin is not working and showing my new cookie policy. CLICK AND COLLECT I have an online store that does deliveries according to a time and date you choose, I use a plugin called "WooCommerce Delivery & Pickup Date Time" ...
I'm seeking a talented designer who can help me create modern, stylish ashtray and lighter made from glass. Unique, contemporary d...Material: The products will be made from glass. Experience working with this medium would be a plus. - Style: I prefer a sleek, modern look. Creativity for designing appealing, up-to-date patterns is a must. - Personalization: The centerpiece of this project will be a logo/design to be engraved on both items. Experience in graphic design and precision detailing is necessary. Successful completion of this project requires a keen eye for modern aesthetics, a solid background in product design, and experience working with glass as a material. This is an opportunity to showcase your creative talents, and looking for...
...search engines. However, I'm looking to further enhance its performance through an advanced SEO strategy. As part of this project, I aim to increase website traffic, improve keyword rankings, and boost conversion rates. The target audience for my site is not just local, but includes national and international customers. Key responsibilities for this project include: - Conducting a comprehensive SEO analysis and audit of the website. - Developing and implementing an advanced SEO strategy to maintain and improve the current ranking. - Identifying and optimizing high-impact keywords to attract a diverse audience. - Using industry-leading tools and techniques to enhance the site's overall search engine performance. - Regularly monitoring and r...
Description For this project for a well-known technology company, we invite experienced software developers to help enhance accessibility for individuals with disabilities. Qualified participants will participate in a 60-minute online live interview with a usability researcher. During the interview, they will be asked to share their device screen, complete some simple coding tasks, and provide feedback in English. Please note that the interview may be recorded for reference purposes by the research team. Project Details: Start Date: ASAP Location: Worldwide Time Commitment: 60 min
I need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience...
...an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objec...
I need to automate the process of making 5 bookings on every week. Some key requirements: - The automation should make 5 bookings on each week. - Each booking will have the same course, people and starting-times each week.... only the date varies. - It's crucial that the automation doesn't interfere with the site's functionality and doesn't breach any terms of use. - The booking opens 2 weeks before and others are manually waiting to book, so the booking script needs to run exactly 00:00:01 each week - Would be great if we could activate/deactivate the script ourselves as there will be a time during the winter and summerholiday, where we dont need it. - I have a list with names/logins, password and member-numbers on the 20 players (4 on ea...
I'm in search of a skilled SEO expert who can help me improve the search engine rankings of my website. The primary focus will be on driving organic traffic through blog posts. Key Responsibilities: - Conduct comprehensive keyword research to target the most relevant and high-traffic keywords related to my niche. - Implement on-page SEO strategies to optimize the blog content for search engines. - Monitor the website's performance using tools like Google Analytics and adjust strategies as needed. - Stay up-to-date with the latest SEO trends and algorithm changes. Ideal Candidate: - Proven experience in successfully boosting search engine rankings through organic SEO, particularly with blog content. - Proficiency in conduct...
I'm in need of a data entry professional who can handle a major project involving over 1000 pages of text data. This material is currently in a non-tabular structure, including paragraphs and sentences, rather than tables or spreadsheets. Key Responsibilities: - Accurate and efficient entry of textual data - Structuring unorganized data in a logical format Ideal Skills: - Proven experience in data entry work, preferably involving textual data - Strong understanding and ability to work with structured and unstructured data - Excellent attention to detail and commitment to error-free work - Proficient in MS Word, Excel, and data management software - Ability to interpret complex written instructions Please ensure...
I'm looking for a professional email marketing agency that can manage an email campaign for me. Essential skills/experience required: - Proficiency with email service like mailchimp or similar - Previous experience in email marketing, particularly in promoting products - Ability to send follow-up email Key deliverables: - Sending out 350 emails using our email id - Creating and sending follow-up emails - Providing a detailed report on the campaign's performance Please note, I have a template for the emails already. I also have the database of the people to send out in excel format - company name, email, first name and last name - so it should be easy
...individual to assist in designing a compelling, professional corporate PowerPoint presentation, with an objective of introducing my company to potential clients. This slideshow should primarily focus on my company’s products and services, demonstrating our competencies and capabilities effectively. Key Requirements: - Deep understanding of PowerPoint design, and good eye for attention-grabbing visuals - Ability to translate corporate and product information into engaging content - Experience in creating corporate PowerPoint presentations is a major plus Specific Elements: - The presentation should showcase our capabilities, the products or services we excel in. - While not necessary, a designer who can incorporate well-craft...
...detail-oriented freelancer to assist me in organizing electronic correspondences for the purpose of compiling a comprehensive spreadsheet and summary of events. This project pertains to a legal case, so accuracy, efficiency, and confidentiality are paramount. Key Responsibilities: - Compilation: You will be required to gather WhatsApp messages and other electronic correspondences relevant to the case. - Data Input: The extracted messages should be input into a spreadsheet and organized by topic/subject. - Spreadsheet Creation: The spreadsheet should include the following fields: Date, Message Content, and Attachments and also print and file all correspondence in date order etc. Ideal Skills and Experience: - Experience ...
I'm in need of an experienced Excel professional who can help automate some daily tasks for me. Key Requirements: - Automate tasks: I need an expert who can help me automate some of the manual tasks that I perform daily on Excel. The aim is to speed up the process and potentially reduce errors. Additional Information: - No external interactions: The automation should be self-contained within Excel. There's no need for it to interact with any external databases or applications. Ideal Skills and Experience: - Advanced Excel Skills: The successful candidate should have a proven track record of automating tasks in Excel. - Experience with Daily Automation: Since this is a daily task, experience in setting up s...
I'm seeking a skilled freelancer to assist in collecting email addresses for an upcoming email marketing campaign. The ideal candidate will have experience and expertise in web scraping, particularly from social media profiles, professional networking sites, and company websites. Key Responsibilities: - Collect email addresses from social media profiles, professional networking sites, and company websites. - Ensure the collection is accurate and up-to-date. - Provide the email addresses in a well-organized manner, making it easy to integrate into our marketing campaign. Target Industries: The primary focus for this collection is media, video production, photo production, TV production, film production, and music production. This mean...
I need a System Administrator to handle both setting up a website using Aruba and maintaining the MX (mail exchange) records. Here's what I'd need assistance with specifically: - Website setup and deployment: This involves general website operation management, hardware and software updates, and ensuring seamless website functionality. - MX record configuration and maintenance: This includes all tasks in relation to managing the mail exchange records - set up, checkups, modifications, and ensuring our web-communication stays efficient and up to date. A candidate with experience in both Aruba website deployment and MX record management will be considered ideal for this job. Knowledge about server troubleshooting will be a plus.
I'm in need of someone who can help me with lead generation. I'm looking to target specific industries in the process and would like to focus on the following segments: - Manufacturing & Machine Industry - Energy Providers - Insurances - Webshops ALL COMPANIES MUST BE BASED IN THE COUNTRY OF SWITZERLAND. COMPANIES SHOULD BE OF SMALLER TO MEDIUM SIZE, IDEALLY BETWEEN 10-99 EMPLOYEES. The leads I'm interested in should be responsible for digital transformation, digitisation, or be a product manager/owner. In small companies, this might be the company owner/CEO. In a bit larger companies (e.g.> 50 employees), this could be a separate position, which could either have the title of "Digital...something&...
I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.
I'm looking for a skilled professional to assist with a data entry project. The aim is to input various contact details into a spreadsheet, with a range of essential and additional information. Key responsibilities include: - Entering Name, Email IDs, Phone/Mobile Numbers, and Website Links for each entry. - Including LinkedIn profile links, Other correlated details, and Remarks for each entry. Ideal freelancers for this project should: - Have a background in data entry. - Possess excellent attention to detail. - Be able to work efficiently and accurately. - Familiarity with LinkedIn and other social media platforms. - Experience working with data on spreadsheet platforms like Excel or Google Sheets.
...products. Key Features: - The app should be compatible with iOS only. - The form is meant to collect information like Name, RMA #, Order #, SKU, SKU quantity, a checkbox "Pass" and a checkbox for "Restocked" (with an option to add multiple SKUs). - The app should also have a drop-down list to select the store name, which will determine the email address the result is sent to. - It should have a section to upload up to 10 images using the phone camera. - Date and time fields need to be automatically populated with the current date and time as default. - There should be a drop-down list to select the person inspecting the returns. Ideal Skills: - Experience in iOS app development. - Pro...
I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.
...time Acting Project in Vancouver I am seeking enthusiastic individuals located in the Vancouver area for a unique project that involves acting out a scenario. This is a 1-time opportunity lasting 1-2 hours with a pay rate of $25 per hour (with potential for increase to $30/hour based on enthusiasm and performance). Responsibilities: • Act out a scenario (more details will be provided) • Think on your feet and improvise as needed. • Attend a meeting where I'll walk you through the details and provide guidance on what to say and do. Requirements: • Must be located in the Vancouver area. • Acting skills and ability to think on your feet. • Enthusiastic and energetic attitude (Most important) Additional Informa...
I need a certified lawyer to notarize an incumbency certificate from a company in the British Virgin Islands. The notarization involves printing and certifying the true copy with your name, certification, and date. Key Requirements: - Notary services for an incumbency certificate - Capable of printing and certifying the true copy - Name, certification, and date insertion Important Information: - Specific deadline for this task - No additional legal services required Please note that the original documents are still with me, and I will provide them to you through the most convenient means for both of us.
Deseo un sistema de ventas que me permita crear una base de datos para mis clientes , registrar inventario de bidones , registrar los pagos en efectivo Transferencia y los que deben , registrar compras , Cuento con un cuaderno con informacion de los meses de enero febrero y marzo quisiera ingresar esa informacion . Adjunto un formato de excel donde llevo prácticamente ingresando datos manuales , necesito llevar control de los ingresos y egresos
I'm seeking a skilled freelancer to assist in collecting email addresses for an upcoming email marketing campaign. The ideal candidate will have experience and expertise in web scraping, particularly from social media profiles, professional networking sites, and company websites. Key Responsibilities: - Collect email addresses from social media profiles, professional networking sites, and company websites. - Ensure the collection is accurate and up-to-date. - Provide the email addresses in a well-organized manner, making it easy to integrate into our marketing campaign. Target Industries: The primary focus for this collection is media, video production, photo production, TV production, film production, and music production. This mean...
