Excel alert when date is dueงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...freelancer with an acute attention to detail and experience in manipulating PDF files. In this specific project, we will be modifying transactions, altering dates, and changing account balances on a bank statement. Key Tasks: - Transaction Modification: Adding, removing or changing transaction details. - Date Alteration: Tweaking transaction dates to meet specifications. - Account Balance Change: Adjusting the overall account balance accordingly. Please note, the purpose of these alterations is strictly for legal documentation purposes. Ideal Skills: - Proficiency in Adobe Acrobat or similar software, allowing high precision PDF manipulation. - Excellent attention to detail. - Previous experience in financial statement alteration would be a bonus but not essential. I...
...EMA strategies, particularly in the cryptocurrency market, is essential. - Alert customization: Experience in creating alerts within TradingView for specific events, such as EMA crossovers, will be highly beneficial. 1. EMA 7, 25, 99 with check box and adjustment settings. Smoothing 9 with check box. 2. Enter a long Position when EMA 7 and 25 crossed above the EMA 99 line and opposite for short entry. 3. exit trade when EMA 7 line crossed EMA 99 line (check box). 4. Exit previous trade before entering a new trade on opposite signal on same candle. 2 Strategy. (Give me drop down for 1 and 2) 1. EMA 7 and 200 with check box and adjustment settings. Smoothing 9 with check box. 2. Enter a long Position when EMA 7 crossed a...
...stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by which you created this graph. -Create a histogram of the stock trading volume (in the column labeled "Volume"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by which you created each graph. -Complete the following for each of the four graphs: Make sure the x and y axis have appropriate labels—“Stock Price in USD” or “Date D/M/Y” for example. Change the title of the graph to communicated what the ...
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
...collaboration, data driven, and empowerment – to achieve this goal and a fast-moving team committed to serving the needs of families. Each student is holistically evaluated through our Empowerly Score™ — the only predictive technology that can also quantify subjective material. Each student is offered a three-pronged approach to evaluate academics, essays, and extracurricular activities – providing them a 360-degree view of how to be competitive against other applicants. Empowerly has raised $12 million to date from investors, including Goodwater Capital, FJ Labs, Scrum Ventures, Translink Capital, Azure Capital Partners, and Spero Ventures. Our leadership team is from Teach for America, Goldman Sachs, Facebook, Google, Lucky Strike,...
We need an experienced 3d game artist to work alongside us. You will be working alongside 1 very experienced unity game developer who owns and is leading the project. If you want to apply please: 1) Send us a 1 minute video of you introducing yourself in english 2) Send us a link to your game art portfolio 3) If you do not follow these steps you will not be considered for this job Hours: anywhere from 10-40 hours a week. Start date probably 1 week to 1 month from now. We will task you with numerous tasks for a week and you will need to scale your hours to complete those tasks based on the week. We will continue conversation here before moving elsewhere.
...Kuwait. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers nationwide. For this purpose, we look for professionals who we contact on an "as-needed" basis to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for communication assistance. The candidate is deaf or hard of hearing but is able to read lips. For this assignment, you would be required to be on site and repeat communication from staff and content from the exam in a way that the candidate ma...
I need an experienced professional to fix my Google Merchant account suspension due to misrepresentation and assist with required setup tasks for WooCommerce and Google Ads. Key Tasks: - Fix Google Merchant Account Suspension - Ensure Only Approved Products are Displayed - Configure Proper Feed Setup for WooCommerce - Set Up and Optimize Google Ads I've received communication from Google regarding the misrepresentation issue, and I need someone who can not only address the problem but also provide long-term solutions to prevent such issues from reoccurring in the future. Ideal Skills & Experience: - Proven track record of fixing Google Merchant Account suspensions and misrepresentation issues. - Proficiency in WooCommerce and Google Ads setup. - Strong understanding of ...
I'm looking for an experienced WooCommerce and WordPress Divi developer to make some key alterations to my site. The site is current on a test domain, and viewable at: This is the site that the alterations will be made to. Following completion, a way to migrate to the live site will be required from the developer awarded the project. I have created a number of PDFs with details of the alterations. If there are any question please ask BEFORE bidding. I need the site to have a good quality feel at the end, and the design elements need to look good. I have tried to be as detailed as possible. If you are not able to commit to completing all the changes, please contact BEFORE bidding. Any plugins that are required need to be included in your bid for the project
I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.
I'm necessitating a freelancer with proficient skills in PDF modification to assist me with a few changes on my bank statement. The task will include: - Text editing, specifically modifying transaction details. - Image modification, focusing on the removal of a particular deposi...freelancer with proficient skills in PDF modification to assist me with a few changes on my bank statement. The task will include: - Text editing, specifically modifying transaction details. - Image modification, focusing on the removal of a particular deposit. Competent experience in PDF editing tools will be essential for this project. The job will require keen attention to detail and accuracy due to the delicate nature of the document. Please only apply if you can guarantee confidentiality and p...
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able ...
I'm in need of a skilled content writer who can craft engaging, informative pieces for a general audience. The primary goal of the content is to educate the readers, so a strong ability to simplify complex information is key. Key requirements: - Expertise in content writing, with a knack for simplifying complex topics - Understanding of audience engagement and ability to create compelling content that keeps readers interested - Strong research skills to ensure accurate, up-to-date information - SEO knowledge to optimize content for search engines while maintaining a natural flow Ideal candidates will have prior experience in writing for general audiences, and can provide samples that demonstrate their ability to simplify complex concepts. A background in journal...
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
...experience in creating selenium tests for web applications. - Web Application Focus: Experience with testing web applications is a must. - CI/CD Understanding: While not required, familiarity with Continuous Integration/Continuous Deployment (CI/CD) pipelines would be a plus. - Attention to Detail: Ability to meticulously craft test cases and identify and report bugs is crucial. Your responsibilities will include: - Collaborating closely with our development team to understand the application structure. - Developing a suite of selenium tests to validate the application's functionality and performance. - Executing and maintaining these tests, ensuring they remain up-to-date as the application evolves. If you're a detail-oriented Selenium expert who excels...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
Need a dev to advise on building the checkout buttons for my website, I'd prefer to use the pre-built butons for check out however I'm still looking to see how to include some custom information such as user details (for digital goods). Then on the receiving end either use IPN or similar to process that. You will need to talk me through what are the options, further work could be optional. Start your bid with "I do paypal"
...with a high-detail Rhino CAD rendering. The project timeline is specific and non-negotiable. The outcome of the project is for visualization purposes, not manufacturing. Key Requirements: - High-detail CAD model: I require a detailed model with textures and materials. - Professional Rendering: The final output should be a professional, visually appealing rendering suitable for visualization. Ideal Skills and Experience: - Proficiency in Rhino CAD: You should have extensive experience working with Rhino CAD. - 3D Visualization skills: A good understanding of 3D visualization and rendering techniques. - Attention to detail: The ability to work with high levels of detail and produce a polished final rendering. - Time Management: Due to the specific deadline, good ti...
I need two outdoor cooking tables based on the document specs provided. I am looking for scaled, cad drawings that can be given to the custom carpenters
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
Creating a comprehensive dashboard for our POS (Point of Sale) system involves several key components and technologies. Here’s a detailed outline of the project requirements and the ideal skills needed to build the solution: Project Overview The goal is to develop a dashboard for an existing POS and inventory management system that consolidates sales and collection reports, provides inventory management, and includes customer data analysis. The dashboard should be accessible via web browsers and mobile devices. Key Features 1. Sales Reports o Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data...
...convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all information This project ...
**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and t...
I need a po...Pictures to be used are in the attachment. NO OTHER PICTURES CAN BE USED DUE TO COPYRIGHT!! So it has to be very simple and also has to attract the viewer immediately with information about who is singing, when and where. Use our B&L logo also - you can find it in attachment. Outputs have to be provided in .jpg and .png format in these sizes: 1. 960x360 px 2. 300x300 px 3. 420x560 px 4. 420x280 px 5. 1920x1080 px 6. 1080x1080 px 7. 1080x1920 px 8. A4 format 9. A3 format Text to be written: Pistać party DESINGERICA DJ PETEK (this is when event starts) 7.6. Klub MARCO POLO (this is location) Nova Gorica 16+ (this has to be somewhere indicating that only 16 y.o. and older can enter) Vrata se odprejo ob 22:00. (this indicated ...
...software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not o...
I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.
...require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attent...
I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report...
I am in need a letter of intent from an attorney. The letter is required for me to attend the Informa Markets Fashion's Magic Sourcing Show in Las Vegas - August. Since I am starting a new business a letter of intent is required. The only requirements provided are as follows: A letter of intent from an attorney on official letterhead stating the intent to start a new business, the type of business, and anticipated date of opening. I called the show and they said that a digital copy is fine or a scanned copy.
