Excel and accessงาน
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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
ต้องการวิศวกรงานระบบ cctv, access control, telephone, internet, turnstile, data center, fire alarm คุณสมบัติ 1. ออกแบบ, ถอดแบบ, งานระบบสื่อสาร ระบบ security 2. ประเมินหน้างาน 3. ทำใบเสนอราคา, ประสานงาน suppliers 4. ควบคุมงาน, ควบคุมช่าง 5. ไม่ต้องประจำออฟฟิศ, ทำงานที่บ้านได้ แต่ต้องออกหน้างานเมื่อต้องประเมินราคา หรือต้องเข้าควบคุมงาน 6. โบนัสจากโปรเจคที่คุม สนใจติดต่อ คุณหน่อย (Removed by Freelancer.com admin)
ต้องการวิศวกรงานระบบ cctv, access control, telephone, internet, turnstile, data center, fire alarm คุณสมบัติ 1. ออกแบบ, ถอดแบบ, งานระบบสื่อสาร ระบบ security 2. ประเมินหน้างาน 3. ทำใบเสนอราคา, ประสานงาน suppliers 4. ควบคุมงาน, ควบคุมช่าง 5. ไม่ต้องประจำออฟฟิศ, ทำงานที่บ้านได้ แต่ต้องออกหน้างานเมื่อต้องประเมินราคา หรือต้องเข้าควบคุมงาน 6. โบนัสจากโปรเจคที่คุม สนใจติดต่อ คุณหน่อย (Removed by Freelancer.com admin)
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
hacking on a whatsapp account without access to the target's phone
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...ทับซ้อนกัน สามารถย่อ-ขยายภาพได้ จะไม่มีการ rotate(หมุนภาพ) เนื่องจากข้อจำกัดด้านกราฟฟิค เมื่อทำการขยายภาพ ภาพแผนที่จะเปลี่ยนจากตัวlayerที่มีความละเอียดต่ำกว่าไปเป็นตัวlayerที่มีความละเอียดสูงกว่า (หากเป็นไปได้ อยากให้มี animation การเปลี่ยนภาพ เป็นแบบ fade in และ fade out ภาพที่ความละเอียดต่ำจะค่อยๆเลือนหายไปในขณะที่ภาพที่มีความละเอียดสูงค่อยๆปรากฏขึ้นมา )* 2 หากตัวอุปกรณ์ support location access ให้ใช้ Location Manager บอกตำแหน่งของอุปกรณ์นั้น บนภาพแผนที่ offline (มีการระบุbearingหรือไม่ก็ได้)* ปริมาณงาน : ในแอพพลิเคชั่นประกอบไปด้วยจำนวนหน้าpageดังนี้ หน้าหลัก 1 หน้า ไว้ให้userเลือกแผนที่ที่ต้องการ ออกแบง่ายๆมีเพียง button link ไปยังหน้าอื่น หน้าแผนที่ 8 หน้า ประกอบไปด้วย แผนที่ offline 3 layer จำนวน 3 หน้า แผนที่ offline 2 layer จำนวน 4 หน้า ...
รับเขียน ออกแบบ แก้ไข software ทุกประเภท ทั้งงานทั่วไป และ ในโรงงานอุตสาหกรรม ประสบการณ์ใน บริษัท และ โรงงานอุตสาหกรรม มากกว่า 10 ปี -VB -Delphi -MS SQL -Oracle -MS Access -Barcode reader, RFID - อุปกรณ์เชื่อมต่อกับระบบคอมพิวเตอร์ I/O Card, Machine controller และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา
I'm looking for a talented designer to create a comprehensive ...document will serve as a blueprint for our brand identity to be shared with partners, ensuring that our core values and visual elements are consistently represented. - Format: The guidelines are to be presented in PDF format for easy distribution and access. Ideal Skills and Experience: - Proven experience in creating brand guidelines for companies - Strong understanding of visual identity, color theory, and typography - Ability to interpret and translate brand values into visual elements - Experience working in the real estate industry would be a plus, but not a necessity. The successful candidate will play a key role in shaping how our brand is perceived in the market, an...
I need an age verification popup for my website that is displayed upon entry to any page. Key requirements: - Ability to change validation type (e.g. Over/Under 18; Date-of-birth, Year-of-birth) - see images - Ability to change images, text, background and redirection address (for Under 18) - To remember age verification forever (for Over 18s) and this session for Under 18s I already have a mock up design and imagery files available. The website is hosted by Neto e-Commerce and I have full access to all files.
I'm seeking a proficient individual for constructing an Access database for my project. The principal requirements include: - Experience with Access, as that's the selected database management system. - Expertise in data storage and retrieval is essential. - The database will be storing textual and numerical data. Experience in handling these types of data is crucial. Ideal skills would include an in-depth understanding of Access, database design, data storage/retrieval techniques and knowledge in handling both textual and numerical data. This should make for a streamlined and efficient process. I'm excited for us to kickstart this project together!
...technology, and an accompanying iOS app. Here's a breakdown of the project's key components: - **NFC Card Interface Features:** - Payment Processing: Users should be able to make purchases directly through the interface - Access Control: Secure access to certain information or features based on user roles - Loyalty Program Management: Implement a loyalty program to incentivize user engagement - User Portfolio: Users should be able to customize their interface with links, contact information, and product displays - **iOS App Development:** I need an iOS app to complement the NFC interface and provide a seamless user experience across different platforms. Ideal candidates for this project should have: - Proficiency in deve...
...set goals, document uploading and feedback, and track progress of administrators over time. - The platform should include a user-friendly interface for managers to easily access and navigate through. - Integration with email services is essential. Notifications for upcoming reviews, reminders, and other relevant communication should be sent through this system. - Calendar scheduling tools should also be incorporated to allow easy organization of review meetings. Ideal Skills and Experience: - Proficiency in web development, particularly for building interactive and user-friendly platforms. - Experience with HR-related platforms is a plus. - A strong understanding of performance review processes and best practices. - Familiarity wi...
As an organization, we aim to significantly boost our network security. Thus, we're seeking a skilled professional capable of: - Configuring firewall - Implementing an effective Intrusion Detection System - Establishing secure remote access Unfortunately, we skipped out on specifying our preferred secured remote access service and the size of our network infrastructure during the initial stages. However, we encourage applicants to be fully versatile with VPN, SSH, RDP, and to be equipped to handle infrastructure of various sizes. Prior experience with these areas will be advantageous. Do you have what it takes to help us execute a thorough network security overhaul? If so, we want to hear from you!
I am facing an issue on my Windows system where the internet disconnects every time I connect to my Open...internet disconnects every time I connect to my OpenVPN. This issue is significantly impacting my ability to work remotely and access the resources I need. Key Points: - The issue started occurring when I began using OpenVPN. - I work on my system and the VPN is a critical part of my workflow. - The problem is specific to my Windows operating system. I am looking for a professional who has: - Profound experience with troubleshooting VPN connection issues, especially with OpenVPN. - Strong knowledge of Windows operating system networking and its interaction with VPNs. - Excellent communication skills and can guide me through the troubleshooting proc...
We are using an online field service software platform called Uptick for our field technicians to carry out inspections of fire sys...using an online field service software platform called Uptick for our field technicians to carry out inspections of fire systems. The online software we use generates a PDF report based on the field technician inputs. We have access to the CSS/HTML/DJango source code to modify the PDF output. We require a developer who will work with us to generate a PDF output based on our design by modifying the existing source code. Please note: The developer must be willing to discuss the project via [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions] so that clear instructions can be discussed as to the req...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set t...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant approvals. The Grant Writer MUST be Canadian or have the expertise and experience with the Canadian government, ideally living in Canada and speaks and writes English Fluently. They MUST specialize in IT/digital marketing/ ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for finding funding opportunities for our organization and writing polished proposals to earn Ontario & Federal government grant money. The ...
...business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer orders, inventory, and shipping. Key Features: 1. Customer Management - Store customer information including name, address, email, and phone number. - Track customer order history. - Customer feedback and preferences. 2. Inventory Management - Maintain a detailed list of products, including product ID, name, description, quantity in stock, and reorder levels. - Automated alerts for low stock levels. 3. Order Management - Enable creation of new orders with customer information, order details (product, quantity, price), and shipping method. - Track order status (received, processing,...
I'm in need of someone adept at PHP and SOAP. My development site is currently returning a warning message: "Attempt to read property "Invoice_Number" on string." I've set up a dev SOAP server for you to carry out the work. At this point, I'm uncertain if I'm attempting to access the "Invoice_Number" property on a string. There are also no other error messages accompanying this issue. Key tasks: - Identify the cause of the "Invoice_Number" warning - Fix the PHP SOAP warning Ideal skills: - Proficiency in PHP - Experience dealing with SOAP - Ability to troubleshoot and resolve such issues promptly
...visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) LA ROMAINE, TRINIDAD & TOBAGO • Has a camera or phone/tablet of quality with a camera, internet access Please see the attached file for the site visit guideline. You are only required to deliver the pictu...
I need an Android IPTV develop...of content for viewers. The panel should come with the following functionalities for user management: - User subscriptions management: allowing the administration of user accounts and subscriptions. - Multi-user access control: enabling different levels of access for various users. - User activity tracking: to monitor and analyze user engagement with the platform. Ideal candidates for this project should have experience in: - Developing Android applications, particularly in the field of IPTV. - Building user-friendly interfaces and ensuring smooth user experiences. - Implementing live streaming capabilities and managing video-on-demand libraries. - Creating web panels for user management with the specified functio...
...a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas ...
...are seeking an experienced software developer to join our team and work on developing a secure and scalable VPN/Internet gateway solution. This project involves building server software capable of authenticating client connections and providing access to the internet. Requirements: Master's degree or PhD in Computer Science, Cybersecurity, or a related field Extensive experience in internet security, privacy, and VPN technologies Strong proficiency in server-side software development Familiarity with OpenWrt and router firmware development (preferred) Passion for internet security and privacy Responsibilities: Develop robust Wireguard exit nodes and VPN server software Ensure seamless integration with existing client softwa...
...on my website and have it connected to Fresha CRM, the system I currently use. This shop should have a sophisticated design that complements my brand image. Key Requirements: - Development of a product catalog with detailed descriptions and prices - Inclusion of a shopping cart and a seamless checkout experience - Integration of online ordering and payment functionalities - Payment gateway setup to accommodate credit card and bank transfer options - Customization to align with an elegant and sophisticated design style Ideal Skills and Experience: - Proficiency in e-commerce development and CRM integration - Strong portfolio of elegant and sophisticated web design projects - Previous experience with integrating payment gat...
...Prime vendors and Direct clients. will pay commission per placement. This person can also bring in any other consultants on our payroll (Separate incentives for this) We don't need anyone who works on Job boards. Need someone with strong relationship in the market Job Types: Part-time, Freelance Ideal Skills and Experience: - Proven experience in IT Bench Sales recruitment is a must. - Strong network in the IT industry and access to potential candidates. - Proficiency in utilizing various sourcing techniques and tools to identify and engage with potential candidates. - Excellent communication and negotiation skills to ensure the successful onboarding of Senior-level candidates. - Experience in the freelancer recruitment model ...
I am looking for someone experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure ac...
I need a small metal shade structure built for a few horses to provide both sun and rain protection. The design should be durable, weather-resistant, and easy for the horses to access. - Materials: As indicated, the shade structure must be primarily built with metal for longevity. - Size: 40'X13' Ideal skills for this job include: - Experience with metalwork and construction - Understanding of, and experience with designing structures for animals, particularly horses - Knowledge of local weather conditions to best determine structure design. - drawing must meet Maricopa County standards
...Key Features: - Intrusion Detection: The application must be able to detect and alert me about any potential security breaches. - Log Gathering: I'll need the app to effectively and securely gather logs from IoT devices. - Access Control Management: It should have the ability to manage and control access to the security system. Logging Mechanism: - The application should be able to log activities from sensors and smart home devices effectively. Ideal skills and experience: - Strong Python programming skills, coupled with experience in security applications. - Proficiency in designing and implementing robust intrusion detection systems. - Prior work on IoT device integration and data gathering. - Experience in acc...
I'm looking for a removalist to help me move 15 carto...pretty straightforward, no need for additional packing materials, just transporting the boxes and putting them into the storage unit. Key Requirements: - Move 15 cartons, each measuring 50x40x50cm, from Melbourne CBD to Ringwood - Put all the boxes into the storage unit Additional Information: - No stairs involved, the apartment has elevator access - No requirement for packing or unpacking assistance, just need someone to follow the instructions and lay all the boxes in the storage Ideal Skills and Experience: - Experience in removalist or moving services - Reliable and careful in handling delicate items - Familiarity with Melbourne CBD and Ringwood area Please provide your quote for ...
I am seeking researchers in Manchester, UK to conduct market research for a retail audit. The ideal candidate should have good communication skills and access to a smartphone. You must be available immediately. You will visit 30 bars in the city of Manchester, UK and the payment for this project is €390. For this project, the product costs and materials that will be needed to assess the product will be reimbursed. Specific requirements for the project include: - Conducting a retail audit in Manchester, UK - Collecting data and inputting it into an app Skills and experience needed for this project: - Strong analytical skills - Excellent communication skills - Ability to finish the project by a specific deadline - Flexible schedule Please ge...
...visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) San Fabian, Pangasinan, Philippines • Has a camera or phone/tablet of quality with a camera, internet access Please see the attached file for the site visit guideline. You are only required to deliver the pic...
I'm in need of a skil...Features: - User Registration and Login: Implement a secure system to allow students to register, log in and access the platform. - Exam Creation and Management: Develop tools for examiners to create and manage exams. This should include the ability to set time limits, number of questions, and other relevant parameters. - Result Generation: Implement a function that will accurately calculate and display exam results to students. Additional Information: - The portal will only be supporting specific types of exams. - The ideal candidate should have experience with similar projects and be able to provide a secure, user-friendly and efficient solution. - The project requires an understanding of good U...
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good...
