Basic excel formulas 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 ที่กำหนดให้
...THE WORLD THAI CULTURE AND CITY THEN PLEASE MAKE THE BEST USE OF THIS CHANCE. Our Expectations: Have a great body and being a fit person who goes to gym frequently (male/female) (Sharing your full photo is mandatory to apply along with resume) Provide security or being a bodyguard or secretary for our client in person or their organization. Speaks Thai fluently and knows driving bike/car. Speak Basic English Familiar with all the tourist attractions in your area or clubs,nightlife. Ideas to make tourists happy for secretarial jobs by being creative, smart, honest, punctual and hard working (10-12 hours daily). Should be currently living in Pattaya or should make his/her own arrangements for staying in Pattaya during internship. The testing phase is between September 29 to Octob...
อื่นๆ หรือไม่แน่ใจ อื่นๆ หรือไม่แน่ใจ อยากให้ช่วย customize WooCommerce appointment widget ให้สามารถเชื่อมต่อกับ dashboard ให้เชคอินลูกค้าที่มาถึงสถานที่ได้ง่าย
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
ปัจจุบัน TOPICA EDTECH GROUP ต้องการผู้ช่วยสอนภาษาอังกฤษ 20 คน ในโปรแกรม TOPICA หน้าที่: - ช่วยเหลืออาจารย์เจ้าของภาษาในคลาส Live Session Basic - สอนนักเรียนในคลาสสนทนา - ช่วยเหลือและปรับปรุงคลาสเรียนออนไลน์ให้มีประสิทธิภาพมากยิ่งขึ้น - ทดสอบทักษะภาษาอังกฤษของนักเรียนไทย สิทธิประโยชน์: - เงินเดือนดี ขึ้นอยู่กับจำนวนชั่วโมงที่คุณสอน - ไม่จำกัดชั่วโมงสอน - ทำงานที่บ้าน - ได้ทำงานกับอาจารย์เจ้าของภาษาเพื่อฝึกทักษะภาษาอังกฤษไปในตัว คุณสมบัติที่ต้องการ: - พูดภาษาไทยเป็นภาษาหลัก - สามารถสื่อสารภาษาอังกฤษได้ดี - มีความมั่นใจในการสื่อสาร ชัดเจนและไม่ติดอ่าง - ต้องมีอินเทอร์เนตที่เสถียร (สำหรับที่บ้าน)
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ต้องการให้ set-up ในส่วนของ WEB Hosting (ตั้งค่า DNS + อื่นๆ) Wordpress installation (Basic Themes)
I need a freelancer to edit two images, changing the measurements currently in centimeters to inches. I have two images, one for large size suit and another for medium size suit. Currrently all measurements are in cm. Please convert to inches update the two images with inches instead of cm. Skills/Experience: - Proficient in photo editing software - Strong attention to detail - Basic mathematical focus for accurate conversion - A keen eye for aesthetics, to choose pleasing and readable fonts.
I have an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensu...
Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be ...
...site. The selected individual will be primarily tasked with: - Document management: The organization, updating, and safeguarding of crucial documents. - Workflow automation: Streamlining business processes to improve effectiveness. - SharePoint site customization: Tailoring the site to suit our specific needs. At the moment, the specific SharePoint version being utilized is unspecified, so a basic understanding of multiple versions is beneficial. There's also a need to integrate Power Automate, so experience with this tool is essential. Ideal candidates must be proficient with SharePoint, organized, detail-oriented, and experienced in workflow automation and Power Automate. Below is JD Position Title: Functional Business Analyst 2- Run the Business (RTB) Reports to: Ent...
I'm currently on the lookout for an expert in Excel 2016, with a specialized focus on the creation of VBA. The end goal? Correct spelling mistakes across multiple worksheets in my data set. Given the language locale, proficiency in English (USA) is essential. In addition to this: - Strong attention to detail and accuracy skills are needed. - Proven experience of using Excel, especially dealing with multiple worksheets. - Experience in creating and executing VBAs effectively for similar problems. Do you believe that your expertise aligns with these requirements? If so, consider submitting a proposal.
...communication with guests, and appropriately logging all reservation details. 2. Accounting Assistance: - We are also looking for an accountant. Your responsibilities would include addressing guest inquiries about charges, and ensuring all financial transactions related to reservations are accurately processed and recorded. Ideal candidates should have experience in hotel reservation systems and basic accounting. Familiarity with financial tracking software and customer service skills are a must. Note: This project involves dealing with financial data, hence trustworthiness and attention to detail are crucial....
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers ...
I'm in need of a freelancer who can create simple assembly drawings in Fusion 360 for a project I'm working on. Key Requirements: - Experience with Fusion...working on. Key Requirements: - Experience with Fusion 360: You should be proficient and comfortable working in this software to create accurate and clear assembly drawings. - Attention to Detail: The drawings should reflect basic shapes and dimensions of the components involved in the assembly. The final deliverable should be a set of assembly drawings providing a clear outline of how the different parts fit together. No need for detailed assembly instructions, just the assembly drawings themselves. If you're confident in your Fusion 360 skills and can deliver these basic assembly drawings efficie...
I'm looking for a fre...in data integration and ETL processes. - Experience with public datasets. - Advanced knowledge of Microsoft Power BI. - Solid understanding of the business needs behind data warehousing. What exactly I will need you to deliver in the 1st stage: -EXPECTATIONS AND DETAILED NEEDS FOR DECISION SUPPORT -SCOPE OF ANALYSIS – ASPECTS EXAMINED -DATA SOURCES -LOCATION, FORMAT, AVAILABILITY -DATA SOURCE BASIC INFORMATION -DATA SOURCE INITIAL ASSESMENT (ADDITIONAL INFORMATION. TIME SPAN FOR FACTS, ETC.) -DIMENSIONAL MODEL SYNOPSIS -FACTS AND MEASURES -CONTEXT FOR FACTS -DIMENSION OVERVIEW -DATA SOURCE DETAILS -DOMAIN DATA DICTIONARY -QUALITY ASSESMENT SHEET If you have a background in this field and can help me with this initial phase of the project, I'...
I'm seeking an experienced freelancer who can convert my PDF documents, which include images and tables, into Word format. The main objective is the need to edit the content. Key requirements include: - Maintaining the content's original integrity while stripping away the complex formatting to a basic Word format. Your craftsmanship in handling text with images and tables is vital here. - I want the converted Word documents to be fully editable and easy to use. Attention to detail is a must. - Experience with similar tasks is much appreciated. Freelancer should have familiarity with both PDF and Word formatting options, and a keen eye for design to ensure the visual aspects of the content are preserved during conversion. Ability to handle documents with images and ...
Hi! I am an individual real estate agent based in Indiana and I'm looking for someone to help me with basic social media management to gain traction and bring in new leads. I currently have a Facebook, Instagram, and LinkedIn. The CRM my brokerage uses is Lofty and I also have a Canva premium account. If this is something you're interested in, let me know:). Hope to hear back soon, Thanks! Alexa Breedlove
Project Description: I am in need of a tale...needs to be properly rigged to allow for realistic movement and animation. The freelancer should have expertise in rigging techniques. - Texturing: While not explicitly mentioned by the client, it is assumed that texturing may be required to enhance the visual appeal of the character model. - Prototyping: Although not mentioned by the client, the freelancer should be able to create a prototype or a basic representation of the character model and rig animation to present to the client for feedback and approval. Please provide examples of your previous work in character modeling and rig animation, showcasing your ability to create high-quality animations with simple motions for human characters.
...overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be involved in our pre-employment screening by conducting a visit to our candidates’ residential address with the candidate’s consent letter. JOB DESCRIPTIONS: • Conduct the site visit to the candidate’s residential address • Conduct the basic verification of the candidate’s residence & reputation with the neighbors, head of the local community, police stations, building operators, etc. • Take pictures of the candidate’s residential address, as per Confirmis’ standard operating guidelines. • Provide observation about the address such as the location, the build...
I am in search of a proficient data entry specialist based in LATAM who can help me with various data management tasks... and interpreting data. - Data Cleaning: Your role will also involve cleaning data sets to ensure they are free from errors and inconsistencies. - Data Verification: You will need to cross-verify data to guarantee accuracy and reliability. Preferred Tools: - Proficiency in Microsoft Excel, Google Sheets, and CSV file format is preferred. Ideal Candidate: - Prior experience in data entry, processing, and cleaning. - Familiarity with data verification methods and tools. - Proficiency in Microsoft Excel, Google Sheets and CSV file format. - Attention to detail and accuracy in data management. Please note that the estimated amount of data to be processed...
I'm looking for an experienced Wikipedia writer to create an article about my trajectory and achievements as an actor. Ideally, someone who has written biographies or worked with subjec...ensure all data is accurate and up-to-date. - Chronological Storytelling: I want the biography to follow a chronological structure, covering my early life, career progression, and personal life. Skills and experience expected: - Strong researching and writing skills, preferably with an experience in biographical writing - Familiarity with Wikipedia's guidelines and article-writing procedures - Basic fact-checking skills and the ability to cross-verify sources. If you have any previous work samples, especially articles on the film industry or biographies, please feel free to share th...
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
...to , offering a clean and user-friendly interface that is tailored to the target audience of companionship seekers. - WordPress Expertise: The choice of CMS is WordPress, therefore the ideal candidate should be proficient in creating and customizing websites using this platform. - Language: The site will be in one language (Spanish) only, so fluency in Spanish is a plus. - SEO: Basic understanding of on-page SEO best practices is appreciated, though not mandatory. Ideal Skills and Experience: - Proficiency in WordPress theme and plugin development. - Experience with designing and developing websites in a similar industry (i.e., companionship services). - Ability to create a secure and user-friendly website that aligns with the specified requirements. Please feel free to
I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share...creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake data entry tasks with accuracy and speed. Experience with Excel data manipulation and a keen eye for detail are ideal for...
I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.
I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of
We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills
I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensu...
I'm looking for a dependable Virtual Assistant with intermediate experience. You'll be tackling a variety of tasks, primarily: - Email management: Sorting, forwarding, and replying to emails on my behalf. - Calendar management: Scheduling, rescheduling, reminders, and confirming appointments. - Data entry: Input and update information into our databases accurately. Basic requirements for this role include: - Fluent in English: I need someone who can communicate clearly and effectively in English. It is important that my assistant understands tasks and can relay information properly. This role may require multitasking and fast-paced work, but I'm willing to work with someone who is keen on learning and improving. Having experience with these tasks will be a great ...