Excel database reportsงาน
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)
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ต้องการข้อมูลที่ติดต่อได้จริง ของร้านสปา และร้านขายส่งผลิตภัณฑ์เกี่ยวกับสปา ทั่วประเทศไทย (มากที่สุด) ข้อมูลที่ต้องการ -ชื่อร้าน -เจ้าของ/ผู้ดำเนินการ -หมายเลขโทรศัพท์ -หมายเลขแฟกซ์ -หมายเลขโทรศัพท์มือถือ (ถ้ามี) -อีเมล์ -ที่อยู่จัดส่งเอกสาร ***เป็นข้อมูลที่ update ใช้ได้จริงเท่านั้น
I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10...
We are seeking an experienced data analyst to conduct comprehensive market research on consumer behavior in the USA. The project aims to understand trends in purchasing habits, demographics, and preferences among different consumer segments. Scope of Work: Collect and analyze publicly available data sources, including but not limited to census data, consumer surveys, and industry reports. Identify key demographics, such as age, income level, and geographic location, that impact consumer behavior. Analyze purchasing habits across various product categories and industries. Identify emerging trends and consumer preferences in the market. Provide actionable insights and recommendations based on the findings. Deliverables: Detailed report summarizing the findings of the market re...
...need: - Casino platform - Games from the attached in this project (should be from a game provider like pragmatic play, not own-made) - Admin panel for super agent, agent, and cashier. What we expect: - A fully functional casino platform with withdraw and deposit. - Account hierarchy for admin panel super agent, agent and cashier. - Functional admin panel that shows statistics and reports about the win/loss, account balances and account management. - Games should support PHP currency. - Demo should be in localhost version (via screenshare), not a link. Demo of this casino and panel will be provided in chat. Please note that live dealer games features are not of a concern at this moment. However, your input can be beneficial for future development stages. I'm eager to work...
I need help with my accounting and auditing tasks, including bookkeeping, financial statements preparation, and internal control evaluation. I'd like to include 1 year of financial data in the statements. I require a professional with the following skills: - Proficiency in QuickBooks, Xero, and Excel spreadsheets - Experience in bookkeeping - Preparing financial statements - Evaluating internal controls Your role will be crucial in ensuring that my financial records are accurate and compliant with accounting standards.
I'm looking for a professional who can conduct a basic background check for pre-employment screening in Yaounde, Cameroon. The results of this check should be compiled into a comprehensive written report for my review. Key requirements: - Basic background check - Compile results into a written...the vetting process in Yaounde, Cameroon Ideal candidates for this project should have demonstrable experience in conducting background checks, particularly in the context of pre-employment screening. It's important that the freelancer has the ability to operate in Yaounde for the vetting process itself. Additionally, the freelancer should have a record of delivering clear and concise written reports. Please provide an overview of your relevant experience and approach to this ...
We need a list of all stores in US & Canada that fall under any of the following categories/keywords: Watch Store Watch Repair Shop Jewelry Store Jewelry Repair Shop Fashion Boutique Outdoor Goods Store Sporting Goods Store Electronics Store Mobile Phone Repair Shop You will have to scrape these websites: Yelp, Yellow Pages, Google Maps I have provided an Excel template to follow.
I'm looking for a professional who can conduct a basic background check for pre-employment screening in Yaounde, Cameroon. The results of this check should be compiled into a comprehensive written report for my review. Key requirements: - Basic background check - Compile results into a written...the vetting process in Yaounde, Cameroon Ideal candidates for this project should have demonstrable experience in conducting background checks, particularly in the context of pre-employment screening. It's important that the freelancer has the ability to operate in Yaounde for the vetting process itself. Additionally, the freelancer should have a record of delivering clear and concise written reports. Please provide an overview of your relevant experience and approach to this ...
...secure credential management system, automating user account management, and implementing Selenium scripts for login verification and automated reporting from web portals. Responsibilities: Integrate Microsoft 365 and Bitwarden APIs to automate the creation and management of user accounts and secure credentials. Develop and maintain Selenium automation scripts to validate logins and pull reports from web portals. Implement robust error handling and reporting mechanisms for failed logins and other issues. Schedule automated tasks to ensure timely execution of scripts and operations. Maintain compliance with security best practices throughout the system's architecture and implementation. Required Skills: Proficiency in Python and experience with Sel...
*I am looking to fill a long-term editor position for multiple projects for my agency.* *I run a short-format content agency that edits videos for various coaches, businesses and podcasts.* *The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entert...instagram (roman_marron) and tell me a bit about yourself, your current situation and show me previous work.* ***Important***: *I expect a sample to quality check your work, if I find qualified for the position, I will provide you with the raw 60-seconds footage.* *Fluent English is a must + you must be able to jump on a Zoom call to go through the onboarding process (webcam is a must).* *Daily reports are expected whenever we get to...
...entries and MS Excel billing work. The ideal candidate should be well-versed in both Tally and MS Excel, as well as have a strong attention to detail and a high level of accuracy. Key responsibilities include: - Data entry: You will be responsible for entering a wide variety of data into Tally, including processing of invoices, bank statements, and other financial records. - Account reconciliation: Regular reconciliation of Tally entries against bank statements and other financial records is crucial to ensure accuracy in our financial data. - Inventory management: Tracking and updating inventory records in Tally is another essential task that needs to be performed regularly. For the MS Excel billing work: - Creating invoices: You will be responsible for creatin...
I need a database entry worker to assist me with entering names, contact information, and product details into my database. Key Responsibilities: - Entering names, contact information, and product details accurately into the database. - Proficient English communication skills to ensure correct interpretation of the data. I have 1000 records to enter
I am on look-out for a thorough SEO expert with profound understanding of European markets to...been specified, I am looking for someone who can partner with me long-term to continually optimize and improve my site's performance in relation to SEO. The ideal freelancer should be: - Proficient in researching and leveraging EU-specific SEO trends and best practices - Skilled in SEO tools and strategies to drive traffic, improve rankings and generate leads and sales - Able to provide regular reports and analytics on the project's progress - Have previous experience with similar SEO projects, particularly within the European market. Your proposals should include examples of past work and results achieved. Let's connect to discuss how we can make my website a formidabl...
I'm in need of an experienced digital ...Facebook, Instagram, and Twitter. The campaign should target local, national, and international audiences, tailored to each platform's unique demographics and features. Key Responsibilities: - Develop and execute a strategic social media marketing plan - Create engaging and relevant content for each social media platform - Monitor and analyze the performance of each campaign, providing regular reports and recommendations for improvement Ideal skills and experience for this project include: - Proven track record in running successful social media campaigns - Excellent understanding and experience in utilizing Facebook, Instagram, and Twitter for marketing purposes - Strong analytical skills to track campaign performance and make da...
I need a pretty simple Excel spreadsheet. It is for a used car dealership. I need a row to imput the vehicle, one for the purchase price of the vehicle, one for the cost to prepare the vehicle for sale, one for the sale price, and one for the profit or loss on the sale. I would like it setup with tabs at the bottom for months and years
I'm looking for a proficient Excel expert to create a comprehensive, automated meeting minutes template for Excel 2016. Key Features: - Auto-fill dates and participant names - Automatic calculation of meeting duration - Dynamic agenda item addition - 15 task owners fields - Core areas discussed: Process, People, Technology, System Ideal Skills: - Advanced Excel skills - Strong knowledge of Excel 2016 - Experience in creating automated templates - Eye for detail to ensure the tool works flawlessly The goal is to streamline our meeting minute creation process and ensure accuracy in documenting key points discussed and task assignments. Delivering a user-friendly tool that requires minimal manual input is key.
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Invento...
...account on various major e-commerce platforms. Key Responsibilities: - Handling my products on Amazon, Flipkart, Ajio, Myntra, Snapdeal, and Shopclues. - Optimizing product listings, pricing, and promotions. - Managing inventory and sales on a day-to-day basis. - Handling customer queries and ensuring timely responses. - Implementing SEO and marketing strategies to boost sales. - Generating reports and offering insights for growth. Ideal Skills and Experience: - Prior experience in managing seller accounts on Amazon, Flipkart, Ajio, Myntra, Snapdeal, and Shopclues. - Proficiency in e-commerce tools and platforms. - Strong understanding of SEO, digital marketing, and customer engagement. - Excellent communication and problem-solving skills. - Ability to work under tight deadlin...
I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.
...template building, requirement building. - Document management module equipped with AI capabilities. This module should allow for collaboration, offer templates, and require approval with an activity log. - A signature module that supports e-signing of documents with a timestamp. - GDPR module to enable sensitive data encryption both in the system and the database using a PIN and password. - Report data generator that creates encrypted reports concerning requirements, activity logs, and milestones. - Milestones management - An API library for developers and APIs for the new features to ease third-party integrations. Ideal candidate: - Proficient in Laravel & Machine Learning - Familiar with GDPR regulations and data encryption - Adept in developing and working...
I'm in need of a data analyst with experience in statistical analysis specifically for the Arabic language. The primary focus will be on implementing three key techniques - Descriptive statistics, Hypothesis testing, and Regression analysis. Ideal Skills: - Proficiency in Arabic language - Strong background in statistical analysis - Experience with Descriptive statistics, H...analysis specifically for the Arabic language. The primary focus will be on implementing three key techniques - Descriptive statistics, Hypothesis testing, and Regression analysis. Ideal Skills: - Proficiency in Arabic language - Strong background in statistical analysis - Experience with Descriptive statistics, Hypothesis testing, and Regression analysis - Ability to provide clear and comprehensive reports...
I'm looking for a detail-oriented freelancer to generate website analysis reports, using Google Docs, ChatGPT, and other tools. I have the template to give you and a the process outlined. I have a demo video to send you that shows the process. I'm looking to pay $4 per report. It should be possible to complete one in about 20-30 minutes after you get used to the process. I have about 20 analyses that need doing right now. After those I can provide about 5 per day to start and plan to scale up to about 20 per day after a couple of months.
I am seeking for property manager who have strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). Responsibilities • Gathering data from one source (Google Drive) to enter into document management (databases or partner websites by case) • Checking and reviewing documents for accuracy and completion • Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data Data Management: Your job also includes maintaining basic property data such as address and size. The ability to organize, update, and retrieve this in...
...software to enhance sales and invoicing processes. - Improving inventory management systems. - Generating more precise financial reports. Skills and Experience Required: - Extensive knowledge of Microsoft Dynamics F&O. - Proven experience in configuring and customizing the software to specific business needs. - Familiarity with sales and invoicing processes, inventory management, and financial reporting is critical. Ideal freelancers should emphasize their experience in configuring and customizing Microsoft Dynamics in their applications. A detailed history of your experience with this software is a major plus. This is an excellent opportunity for those who excel at making business processes more efficient through tailored software solutions. If that sounds like you...
Description: Are you a freelance sales professional with a knack for closing deals and a passion for helping others succeed in their careers? Our startup is seeking an experienced freelancer to join our sales team and drive growth for our mock interview services. As an independent contractor, you'll hav...and interpersonal skills, with the ability to tailor your pitch to different audience groups. - Self-motivated and results-driven, with a strong desire to achieve and exceed sales targets. If you're a freelancer looking for an exciting opportunity to leverage your sales skills and make a meaningful impact on the careers of others, we want to hear from you! Join us in empowering individuals to excel in their job interviews and achieve their professional goals. DM your de...
I'm seeking an Excel expert to provide a comprehensive training session for my team of 11-20 individuals. We're at a beginner level and need someone capable of teaching us the basics and showing us how to optimally utilize data analysis and reporting features. - The training should cover: - Basic Excel functions and formulas - Data analysis - Reporting techniques The perfect fit for this project would be someone with an extensive background in Excel, ideally as a trainer or educator. Experience with teaching groups is a must, and the ability to break down complex topics into digestible, understandable parts is essential. Our goal is to increase our productivity and data handling capabilities through this training, so if you have a track recor...
I'm looking for an Excel expert who can create an automated template for a financial renewal analysis dashboard. The dashboard should include basic descriptive statistics functions such as mean, median, mode, standard deviation, correlation, and regression. Key Requirements: - The dashboard needs to focus on the renewal status of our products/services. - It should be able to track the renewal status by product/service type. - The dashboard should be able to automatically update renewal statuses. Ideal Skills and Experience: - Proficiency in Excel and its advanced functions. - Experience in creating automated dashboards. - Understanding of financial data analysis, particularly in the context of renewals. - Strong communication skills to understand our specific needs and...
I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a robust, user-fri...