Excel performance dashboardงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
ด่วนมาก !! ต้องการหาเขียนหน้า Dashboard 3 หน้า ด้วย ReactJS โดยดึงข้อมูลจาก RESTful ครับ ทำที่กรุงเทพ [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions]
...สามารถ 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)
ทำเกี่ยวกับร้านอาหาร ดูข้อมูลย้อนหลัง4-5ปี สามารถแนะนำการจับคู่เมนูอาหารที่ลูกค้าเลือกได้
- เครื่อง มี หน้าจอ touch screen, printer, กล้อง, ที่อ่าน smart card (บัตรประชาชน) - ใช้สำหรับแลกบัตรเข้าออกอาคารสถานที่ - สามารถ scan บัตรประชาชน เพื่อดึงข้อมูล ชื่อ-นามสกุล, รูปภาพ, ที่อยู่, เลขบัตร - สามารถคำนวณระยะเวลา และ ราคาได้ - ถ่ายรูปได้ทั้งขาเข้าและขาออก - สั่ง print ได้ - scan QR ได้ (จากกระดาษขาเข้า) - มีหน้า dashboard อย่างง่าย สรุปว่าวันนี้มีคนเข้ากี่คน, ออกกี่คน, ค้างในระบบกี่คน, ค้างเกิน 1 วันกี่คน - จากสรุปหน้า dashboard สามารถกดดูรายละเอียดของแต่ละข้อมูลได้ ต้องการประมาณนี้
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
อื่นๆ หรือไม่แน่ใจ อื่นๆ หรือไม่แน่ใจ อยากให้ช่วย customize WooCommerce appointment widget ให้สามารถเชื่อมต่อกับ dashboard ให้เชคอินลูกค้าที่มาถึงสถานที่ได้ง่าย
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm seeking an experienced 3D artist with a passion for fantasy settings c...responsibilities and requirements include: • Applying creative ingenuity to develop low poly, moderately detailed 3D fantasy models. • Writing an engaging character-driven script for the designed models. • Having a deep understanding and profound interest in fantasy genre. Ideal freelancers should have a strong track record in both 3D modelling and scriptwriting. Your portfolio should demonstrate past performance on similar character-driven, low-poly 3D modelling projects. Proficiency in scriptwriting is a must, with particular emphasis on character development and dialogues. Familiarity with the fantasy genre will be a valuable asset. Looking forward to building an immersive fantasy...
I'm in urgent need of a skilled content writer who possesses strong proficiencies in Microsoft Excel. The primary task will involve generating written material for my organization, with an additional responsibility requiring accurate invoice creation. Your responsibilities in detail: - Generate compelling content that aligns with my organization's goals and objectives. - You would also be responsible for creating invoices using Microsoft Excel. Ideal qualifications and skills: - A strong grasp of the English language with excellent writing skills. - Prior experience with content writing and invoice creation. - Expert understanding of Microsoft Excel, particularly when it pertains to invoice creation.
I'm looking for a skilled AWS expert with experience in blockchain development, particularly Solana. The primary task at hand is setting up a node on AWS, specifically for Solana's RPC. Key Requirements: - Proficient in AWS: The ideal candidate should be well-versed in setting up nodes on AWS, ensuring optimal performance and security. - Blockchain Experience: Knowledge of blockchain technology is a must, and specific experience with the Solana network is highly preferred. - Monitoring and Alerting: In addition to the node setup, I require comprehensive monitoring and alerting to be put in place. This includes proactive monitoring to ensure the node is running smoothly and the ability to respond to any issues promptly. Your role will be crucial in enabling our blockchai...
I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in siz...seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be...
I'm looking for an intermediate SAP administrator to assist with the basic administration of our SAP system. Key Tasks: - Basic user management, including creating and deleting users, assigning roles, and setting up authorizations - Monitoring system performance and taking necessary actions to ensure it runs smoothly - Troubleshooting and resolving basic configuration and authorization issues - Assisting with system backups and ensuring data integrity - Providing general support to the team on SAP-related queries It's important that you're comfortable working with the SAP system and have a good understanding of its basic functions and administration. A background in SAP Administration or similar roles is preferred. I will provide access to the SAP system, so you ...
...OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices&quo...
...developers. Responsibilities Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies. Lead a team of developers in the implementation and maintenance of database systems. Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs. Optimize database performance through indexing, query optimization, and other performance tuning techniques. Develop and enforce data standards and best practices to ensure data integrity and security. Provide technical guidance and mentorship to junior developers. Troubleshoot database issues and provide timely resolution. Stay up-to-date with the latest trends and technologies in database management and architectur...
I am looking for an experienced web developer to help with several key tasks on my website. Requirements: - Updating PHP version: I need the current PHP version on my site updated. - Deleting unnecessary plugins: You will need to review and remove any unnecessary plugins to optimize the site's performance. - Fixing Elementor builder: I have an issue with Elementor not displaying correctly above the page editing. You will need to address this issue and ensure the builder is working seamlessly. - Correcting CSS: You are expected to review and correct the CSS files on the site to ensure a cohesive and high-quality design. - Fixing the main navigation on mobile: I want the main navigation bar on the mobile version to be changed to a hamburger menu. Ideal Skills: - Proficiency wi...
I'm in need of a Google Ads expert who can help me create and manage a campaign that solely targets businesses. I'm not looking to attract consumers, but rather generate leads specifically from the business sphere. Key Requiremen...Someone who can design a campaign that ensures only businesses see and engage with the ads. The primary goal of this project is to generate leads from businesses. The successful freelancer will need to: - Create a campaign that effectively targets businesses. - Manage the campaign to ensure it's continuously optimized for lead generation. - Provide regular updates and reports on the campaign's performance. I'm looking for a quick turnaround on this project, so urgency is a key factor. If you have the right skills and experience...
...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and r...
I'm looking for an experienced SEO specialist who can help me in improving my website's search engine rankings and make my Google Business Profile more visible to local customers. Key Responsibilities: - Implement on-page SEO strategies to optimize my website's content - Execute off-page SEO tactics to build high-quality backlinks - Improve my website's technical performance - Optimize my Google Business Profile to attract and engage my target audience - Utilize local SEO techniques to improve local search visibility - Provide regular reports on the progress and effectiveness of the SEO strategies Ideal Skills: - Proven experience in SEO, particularly in content optimization, backlink building and technical aspects - Familiarity with Google Business Prof...
I'm looking for a freelancer who can create a comprehensive, user-friendly Google Form and Excel template system. This system will be geared towards the hotel management sector and will be used for recording bookings, sales, expenses, and other business-related data. Key Requirements: - Design and Implementation of Google Form: The form should be intuitive and easy to use. It should have fields for recording bookings, sales, expenses, and other relevant business information. - Excel Templates: The gathered data from the form should be integrated into a set of Excel templates. These templates should be professionally designed and easy for hotel management to use. Your Role: - Your role will be to create a system that can manage multiple businesses. The system sho...
...geolocation, filter services by category, distance, etc. - **Service Posting:** Service providers can publish services with details, photos, and prices, users can view service details. - **Messaging:** Integrated messaging system for users and service providers. - **Payment System:** Secure payments for services, admin management of transactions and commissions. - **Admin Panel and Statistics:** Dashboard for managing users, services, and transactions, view usage statistics and reports. - **Testing and Production Environments:** Set up and maintain testing and production environments. - **Store Publication:** Prepare the app for publication on iOS and Android stores. - **Promotional Website:** Create a showcase website with Home, About, Download, and Contact pages. - **Monetizati...
...teams to identify automation opportunities and design effective workflows. Data Handling: Work with large datasets to ensure accurate and up-to-date information. Task Execution: Instruct AI systems to perform specific actions, such as data processing, content generation, or predictive analytics. Continuous Learning: Stay informed about AI advancements and best practices to optimize system performance. Qualifications: Technical Proficiency: Familiarity with AI concepts, machine learning, and automation platforms. Problem-Solving Skills: Ability to analyze business processes and design effective AI solutions. Communication: Clear communication to collaborate with cross-functional teams and understand user requirements. Adaptability: Willingness to learn and adapt as AI techn...
Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. Looking forward to your proposals!
...recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for managing and sending out newsletters. - Strong understanding of the freelance industry and the needs of experienced freelancers. This is a long-term project, so I'm looking for a ...
I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas across different spreadsheet platforms...
I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, you...understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financia...
I'm in need of a skilled app developer to create a seamless and high-quality social networking app for my startup. The app should cater to both iOS and Android platforms. Key Project Requirements: - Development for both iOS and ...should have: - Extensive experience in app development for both iOS and Android - Proven track record of developing social networking apps - Strong background in incorporating multimedia sharing features, ideally in a social networking context - Excellent project management and communication skills - A keen eye for detail and user experience The app's success will hinge on its usability, smooth performance and the quality of the social networking features. A strong focus on these areas is crucial. Please include relevant samples of your previo...
...of 7 years of experience to join our team immediately. If you are passionate about creating cutting-edge web applications and have a strong background in , we want to hear from you! Responsibilities: Develop robust and efficient web applications using framework. Collaborate with cross-functional teams to define, design, and ship new features. Optimize applications for maximum performance and scalability. Implement security and data protection measures. Troubleshoot and debug issues. Stay up-to-date with emerging technologies and best practices. Requirements: Bachelor's degree in Computer Science, Engineering, or a related field. Minimum of 7 years of experience in web development. Extensive experience with and React.js. Strong proficiency in JavaScript/TypeScript, HTML
Job Position: Residential Property Cold Caller and Appointment Setter Location: Remote Job Type: Full-time Responsibilities: - Identify and contact potential leads th...Excellent proficiency in English with strong communication skills. - Robust negotiation abilities. - In-depth knowledge of the residential real estate market. Qualifications: - Experience in real estate acquisitions and sales. - Ability to work independently and in a fast-paced environment. - Professional demeanor with exceptional interpersonal skills. What We Offer: - Competitive salary and performance bonuses. - Opportunities for career advancement. - Supportive team environment. - If you are looking for a challenging yet rewarding role and meet the above criteria, please submit your resume and cover letter...
As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality
As the client, I am search of a seasoned virtual assistant to support me during typical work hours, 9am to 5pm (UTC +1). The ideal candidate will possess the following expertise: CRM MANAGEMENT: Monitor and manage follow-ups and sales activities within the CRM. Update and maintain accurate records of customer interactions and sales leads. Assist in developing ...tasks as assigned by the CEO. QUALIFICATIONS: Proven experience as a Virtual Assistant or in a similar administrative role. Excellent written and verbal communication skills. Strong organizational and time-management abilities. High level of professionalism and confidentiality. Ability to work independently and handle multiple tasks simultaneously. Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint) and Google ...
I'm looking for a skilled professional to create a Load, Functional testing, Security testing LLM to test our internal websites. Key Requirements: - Operating System: The LLM must ...Security testing LLM to test our internal websites. Key Requirements: - Operating System: The LLM must be compatible with Windows. - Reporting: The LLM should report test results through an integrated dashboard. - Testing: The LLM must be capable of performing Load, Functional, and Security testing. - Test Cases: The LLM must be able to create tests cases based on the current state of the website. Ideal Skills and Experience: - Prior experience in creating and working with LLMs. - Proficiency in load, functional, and security testing. - Familiarity with Windows OS and dashboard...
I'm an entertainment-focused YouTuber with a subscriber base currently in the 1,000 - 3,000 range. My primary goal is to significantly grow my channel to 100k subscr...to 100k - Increase video views - Improve audience engagement through compelling content creation The ideal freelancer for this project should have: - Proven experience in growing YouTube channels - Strong knowledge about entertainment content's appeal on YouTube - Expertise in video SEO and Google adword - Creative and engaging content creation skills - Strong analytics capabilities to track performance and adjust strategy accordingly If you're a growth specialist with a passion for entertainment and a track record of success on YouTube, I'd love to hear from you. Let's work together to make...
Project Name: Personalized News Dashboard Overview: This project involves creating a Personalized News Dashboard that aggregates news from various sources and uses machine learning to curate content based on user preferences. The dashboard will feature an AI-driven recommendation system that not only presents news articles but also provides analytical insights into trending topics and sentiment analysis of news content. Objectives: Main Goal: Develop a web application that personalizes news content for users based on their reading habits and preferences. Secondary Goals: Implement data visualization features to display trends and sentiment analysis of news articles. Minimum Requirements: Content Aggregator: Develop a system that pulls news data from various APIs or w...
The task at hand is to upgrade the PHP version of my content management system from 7.2 to 8.1. I have been using a PHP without any frameworks, and I'd like to keep it this way. I'm seeking a skilled developer well-versed in PHP and experienced in ...version of my content management system from 7.2 to 8.1. I have been using a PHP without any frameworks, and I'd like to keep it this way. I'm seeking a skilled developer well-versed in PHP and experienced in operations without frameworks. Your responsibilities will include: - Studying the existing PHP code - Carrying out the necessary modification for smooth running on PHP 8.1 without any performance degradation. - Testing and debugging post upgrade to ensure seamless system operation Please note, I need this work...
