Excel front endงาน
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...
ทำระบบการเลี้ยงปศุสัตว์ (Livestock Management) นำเสนอเบื้องต้นของ Development Tools: Front-end: Angular JS Language: .Net Core (Web responsive) Database: SQL Server/Azure SQL Database Operation System: Windows Cloud Solution :Hybrid Azure
ทำ 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 ที่กำหนดให้
พัฒนางาน front end design ในรูปแบบ HTML CSS และ Javascript ซึ่งจะนำไปใช้ต่อกับ 2 เว็บไซต์ ได้แก่ และ ซึ่งเคยจ้าง designer เขียนโค้ดไปแล้วบางส่วนแต่ยังไม่สมบูรณ์ ลองดูในลิงค์ Google Drive ในไฟล์แนบของแต่ละโปรเจ็ค ขอบเขตงานอยู่ในไฟล์แนบ แบ่งงานเป็น 3 โปรเจ็ค เลือกทำ 1 โปรเจ็คที่คิดว่าถนัดที่สุด ขอให้เสนอราคาและระยะเวลาในการพัฒนาของโปรเจ็คที่ต้องการทำครับ สนใจแอดไลน์มาที่ Line id: paramathone
Frontend Dev ช่วยพัฒนาส่วน Front ส่งงานให้เป็นส่วนๆ 1) รู้เรื่อง Vue version2.0 up 2) รู้เรื่อง Bootstrap 3) รู้เรื่อง SASS 4) รู้เรื่อง GRID 5) รู้เรื่อง Webpack 6) รู้เรื่อง Node
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
...delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน 1.1.3 แสดงข้อมูล 1 sheet ต่อ 1 ยี่ห้อ 1.2 Upload excel file การกำหนดราคา รถยนต์มือสอง 1.2.1 สามารถ Upload การกำหนดราคา รถยนต์มือสอง จาก excel file ในขั้นตอน Download เพื่อเพิ่มหรือปรับปรุงราคา รถยนต์มือสอง 1.3 Exp...
ต้องการ front end/ design developer มาช่วย back end team
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creati...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...
...homes. It should cover the reasons that a plunge pool might be preferable over a full-sized pool (space saving, aesthetics etc.); what a plunge pool offers to the resident (cooling off, hydrotherapy, relaxation etc.); and the types of plunge pools that are available to luxury home owners. The writer should research and report on the aspects of plunge pools that would best fit a magazine for a high-end home buyer. This article will be published in a nationwide (US) print publication with a luxury real estate focus. The writer should be familiar with design and home styles, be proficient at writing feature articles (no listicles), and be able to work independently. Previous similar publication is a plus. The piece should be approximately 1,200 words, and the deadline is Wednesd...
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.
I require a detailed and accurate excel typist with a strong background in financial data analysis specifically in calculating profit margins. This person should: - Have strong excel typing skills for efficient data entry - Be knowledgeable in financial data analysis - Be able to interpret and analyze profit margins effectively - Have logical data organization skills to improve the overall workflow This role is essential for understanding and monitoring the profit margins of my business. Accurate analysis will aid in making strategic business decisions. Your expertise in handling financial data is highly valuable for this role.
In revamping our travel website, it's essential that we streamline the user experience by integrating flight and hotel booking functionality. A freelancer with expert-level knowledge in API integration, specifically with , or is required to: - Ensure flawless integration of both fl...functionality. The ideal candidate will bring their previous experience with API integration, preferably in the travel industry, to tackle the complexities of our project. Ultimately, our goal is to deliver an upgraded travel website that affords our users an effortless booking experience. Programming language for backend: Java Front end: JavaScript, JQuery or react.js Please submit proposals only if you are proficient in working in Java Language for API back end integration. ...
I am looking for a Flutter developer to create a modern and minimalistic Ludo game exclusively for the Android platform. The game should support both online and local multiplayer functionality. Key Requirements: - Development of a Ludo game application on Flutter for Android. - Inclusion of modern and minimalistic design elements. - Integration of both online and l...modern and minimalistic design elements. - Integration of both online and local multiplayer support. Ideal skills and experience: - Proficient in Flutter for Android app development. - Experience in creating mobile games, particularly Ludo. - A good understanding of multiplayer game development. - Strong design sensibilities for modern and minimalistic styles. - Ability to work on both front-end and back-end...
...developer to create a virtual clothing try-on platform. The system should be accessible via both website and mobile application. Key Features: - Real-time Clothing Fit Simulation: The core of this project is ensuring users can try on different pieces of clothing and see how they fit in real-time. Skills and Experience: - Proficiency in Web and Mobile App Development: A strong knowledge of front-end and back-end development is essential. - Virtual Clothing Simulation: Experience in creating similar systems, particularly those that offer real-time fit simulation, is a big plus. - UI/UX Design: A keen eye for user experience and interface design is important. Please note that while the method of displaying the virtual clothing on the user in the real-time fit simula...
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...
I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.
I'm looking for an expert in Excel data entry to assist me with a project. The job primarily involves: - Text data entry: Entering textual information into Excel. Accuracy is crucial, as even minor errors can greatly affect the output. - Data categorization: Organizing the entered data into different categories within the sheet. The ability to understand and sort data effectively is key. - Basic data visualization: I'd like the data to be presented visually. The freelancer should be able to create and include simple charts or graphs to represent the categorized data effectively. Ideal Skills: - Proficiency in Excel: A deep understanding of Excel and its functions is essential. - Data Entry: Previous experience in data entry is highly preferred. - Data...
Looking for an expert full-stack developer to join our team? Here's what we're after: - Mastery in Front-end and Back-end Development: Your role requires proficiency on both the client and server side, so experience in both domains is a must. - Specialization in Web Development using ASP.NET Core 7+ MVC and Angular: We're seeking someone with deep expertise, though familiarity with other frameworks is a bonus. - Minimum 2 years of experience is required. - Proficiency in Arabic is preferred. If you're passionate about crafting high-quality, performance-driven applications and possess the skills we're seeking, we'd love to hear from you.
I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.
...receive three free readings upon registration. - Premium Subscription: Continued access requires purchasing a subscription. Benefits include unlimited readings, access to different tarot decks and the ability to select reading masters. 6. Social Sharing: Integrated social media buttons to allow users to share their readings. Technical Requirements: - Proficiency in and React for front-end development. - Experience with React Three Fiber for implementing WebGL content. - Ability to integrate third-party APIs for dynamic data retrieval and processing. - Knowledge of responsive web design to ensure the app is accessible across various devices. - Experience with building secure authentication and user profile systems. - Capability to integrate payment systems for subscri...
...seeking a talented PHP full-stack developer for a project that lies in the moderate complexity category, featuring some customizations. Key Responsibilities: - Front-end development: You'll be expected to create a visually appealing and user-friendly interface using HTML/CSS and JavaScript. - Back-end development: You must be proficient in PHP, particularly Laravel, to successfully implement the back-end logic of the application. - Database management: Proficiency in database management is essential, as it's a crucial part of the project. The ideal candidate for this role should have: - Strong experience in front-end and back-end development - Proficiency in HTML/CSS, JavaScript, CodeIgniter and Laravel - A track record of ...
...problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding...
I'm looking for an experienced freelancer to create a Postman script that will automate the login process for without requiring any manual intervention. Here are the key details of the project: - You should be able to simulate entering the email and password, clicking the login button, and retrieving headers for subsequent actions on the front. - Upon successful login, the output data format should be in JSON. Ideal Skills and Experience: - Proficiency in working with Postman and creating scripts for automation. - Strong knowledge of HTTP methods. - Experience with handling and parsing JSON data. - Familiarity with cookies and headers in HTTP requests is a plus. Please note that the successful delivery of this project requires meticulous attention to detail and a solid unde...
As the owner of a WordPress site, I'm currently facing sever...happening: - Cron jobs on my site are not running as they should. - I'm facing errors with cURL 7. - The REST API is malfunctioning. I'm seeking a professional WordPress developer who can tackle these problems. Given these are separate issues, a deep understanding of all three areas (cron jobs, cURL 7, and REST API) is crucial. ****** FIX THE ISSUE USING ANYDESK IS MANDATORY ******* By the end of this project, I expect: - Cron jobs working to schedule flawlessly. - cURL 7 operating without any errors. - The REST API functioning correctly. The task requires working via AnyDesk Remote Desktop, so experience with remote troubleshooting is necessary. Please only apply if you're comfortable ...
I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...
I'm searching for ...storytelling and inspiration, so an understanding of how to weave a narrative through visual media is essential. The following outlines my specific expectations: - Moderate-level editing: I'm not just looking for basic touch-ups. You should be comfortable with applying effects and transitions to create smooth, engaging reels. - Aesthetic understanding: The reels need to exude sophistication. To this end, you should have experience in creating elegant and sophisticated visual content. - Storytelling expertise: Our reels tell a story. Understanding of visual storytelling techniques is a must-have skill for this project. Ideal candidates will have prior experience editing for Instagram reels and a portfolio that demonstrates both their technical skills ...
Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over ...
More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
...model, and the other is a pySpark XGboost also running on local. - Migrate These two models to AWS SAGEMAKER. Data will be on S3 -Prepare models to run on sagemaker totally, so that we can do training and testing 100% on sagemaker.-Models are already running on a local computer, but I need to move them to Sagemaker 100%. Data is on S3 already. -You need to configure and prepare Sagemaker from end to end, and teach me how you did it, since I need to replicate it in another system. -I will give you the data and access to AWS Ideal Skills and Experience: - Demonstrated experience in performing similar migrations - Proficiency in Python, R, and Spark languages - Hands-on experience with AWS Sagemaker -AWS is a MUST, -No matter how, we need to have both models up and running...
