Projek mini excelงาน
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 ที่กำหนดให้
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I have an xlsx file containing 460 products that need to be added to my current WordPress website. The products already have categories and URLs, so no categorization is necessary. However, the URLs don't require any modifications and only basic product information need to be included - no specific...added to my current WordPress website. The products already have categories and URLs, so no categorization is necessary. However, the URLs don't require any modifications and only basic product information need to be included - no specific attributes such as size, color, or brand. Ideal Skills and Experience: - Proficient in WordPress - Familiar with handling product uploads - Able to work with Excel files - Attention to detail for product categorization - Basic understandin...
I'm...Provider Designation: It needs to include space to designate where providers are used during appointments, to keep providers efficiently moving from patient to patient. - Procedure Difficulty/Stress Level: It should have a ranking system for the difficulty and stress level of each procedure, so that providers are not overly stressed each day. Ideal Skills and Experience: - Proficiency in creating Excel or Google Sheets templates. - Previous experience in the healthcare or dental field would be beneficial but not mandatory. - Strong attention to detail, to ensure every aspect of our busy office can be accurately scheduled. This template will be crucial in streamlining our operations, reducing stress during busy periods, and ultimately delivering a better experience fo...
...my clients' needs. I am dedicated to providing translations that respect the tone and context of the original text." --- If you are a beginner, here is a version adapted for you: "I am a beginner translator, but I am highly motivated, with a strong passion for languages and a solid understanding of grammatical structures. I am comfortable translating [describe the types of text you prefer or excel at, e.g., simple articles, product descriptions, emails]. My goal is to learn quickly, improve, and provide quality translations that meet clients' expectations." --- Tips: Be honest: If you don't have much experience, it's fine to mention it, but focus on your enthusiasm and willingness to learn. Specify languages: Always mention the language...
I'm in need of a proficient Excel expert who can devise a mathematical formula tailored for tracking a business budget. The primary function of this formula will revolve around facilitating various financial calculations. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Strong background in financial analysis - Previous experience in creating budget-tracking tools - Ability to explain complex formulas in simple terms
Project Name: Design, Programing and simulation of a 3-4 DOF robotic arm using simulink and arduino Software: Matlab Simscape Hardwares (I Have): 1) arduino mega 2560 r3 2) servor mg90s 3) 1.5v - 6v r300c mini dc motor rpm3500 4) sg90 micro servor motor 9g(360°) 5) dual channel motor driver modul L298N H-bridge 6) jumper wire cable 7) breadboard 8) robotic arm kit 6dof Deadline 2 days $20 nzd
I need a custom Excel workbook specifically designed for estimating costs in the construction of custom built sunrooms. Key Requirements: - The workbook should be able to estimate costs for a variety of elements including material costs, labor costs, and permits and fees. - There should be a customer input window for various cost factors including packages for windows, framing, and foundations, as well as siding and roofing. - Additional cost categories to be accounted for include drywall, insulation, electrical, HVAC, interior trim, exterior decking, and flooring. Ideal Skills and Experience: - Proficiency in Excel with a strong background in creating custom workbooks. - Experience in construction cost estimation. - Understanding of sunroom construction and necessary mate...
I need assistance in updating my Excel file with data sourced from an online source. Specific Requirements: - Extracting complete records with all available details from the online source: - Updating the Excel file accordingly. - You can use Excel or Google Sheets (either work) - API or Manual Update possible. (API is recommeded) - Add data in yellow section needs to be updated. - Work needs to be completed in 1 day. See attached excel file. Excel Password: 12345
I'm looking for an expert in Excel and cryptocurrency trading who can help me automate a trading system. The project involves: - Creating an Excel-based system that connects to major exchanges like Binance, Coinbase, and Kraken. - Implementing a triangular arbitrage trading strategy within this system. - Primarily focusing on automating trading execution. Ideal candidates should have a strong background in data analysis, trading automation, and a deep understanding of triangular arbitrage. Experience with these specific exchanges is a plus. The goal is to develop a reliable, efficient, and profitable automated trading system. Attached reference video:
I'm looking for a proficient software developer to create a Windows-based Point of Sale (POS) software for me. This software should cater to a multi-user environment, with a client-side interface for cashiers and a manager server for inventory control and oversight. Key Features: - The software must support importation of items from an Excel spreadsheet to streamline inventory setup. - At least three concurrent users should be supported, with potential for scale. - Additional features like sales reporting, customer management, and employee time tracking are required. - A hybrid user interface (touchscreen-friendly with keyboard and mouse options) for the cashier side. - Custom, role-based access control for different users, beyond just basic cashier vs manager permissions. Id...
I'm looking for someone to convert my Excel project data into an MS Project Gantt chart. The Excel sheet contains both tasks and resources, and I want the Gantt chart to reflect a mix of high-level milestones and detailed tasks. Key requirements: - Understanding of both Excel and MS Project - Ability to accurately represent tasks and resources - Skill in creating a Gantt chart with a blend of detailed tasks and overall milestones - Knowledge of incorporating task dependencies, resource allocation, and critical path identification into the Gantt chart Ideal candidates for this project will have experience in project management and a strong proficiency in MS Project. Please include examples of similar projects you've completed in your application.
I need assistance to convert data from 11 Word documents into a Microsoft Excel or CSV file. The data in the Word documents primarily consists of text. The converted data does not require any specific text formatting to be preserved; plain text is fine. I would like the text to be organized in the Excel or CSV file with one paragraph per row. Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in data conversion tasks - Attention to detail for accurate data entry - Able to handle multiple documents efficiently.
Option Explicit Type Authvalinterval Lower_Val As String * 40 Upper_Val As String * 40 End Type Type AUTHVALINTERVAL_TAB wert(1 To 10) As Authvalinterval End Type Type AUTHFIELD_VALS fieldname As String * 10 fieldvals As AUTHVALINTERVAL_TAB End Type Type AUTHORIZATION_TAB AUTHORIZATION(1 To 10) As AUTHFIELD_VALS End Type Type AUTHORIZATION_FOR_OBJECT xuobject As String * 10 AUTHORIZATIONS As AUTHORIZATION_TAB End Type Global IT_ROLE_AUTHS(1 To 100) As AUTHORIZATION_FOR_OBJECT Global sapSystem As Object Global sapFuBa As Object Global sapLogon As Object Global sapConn As Object Global sapReturn As Object Sub RolleAnlegen() Dim wert As Object Dim rolle As Object Dim sapObjekt As Object If InitConnection Then Se...
...Saves data to CSV or Excel files. Data Comparison: Compares newly extracted data with previously saved data. Highlights differences: Added entries: Green. Updated entries: Yellow. Deleted entries: Red. Displays comparison results in a table within the program. User Interface (UI): All interface elements (buttons, labels, etc.) in Korean. Buttons: "Login and Start": Logs into the target website. "Extract Data": Scrapes data from the website. "Load Existing Data": Loads previously saved data. "Run Comparison": Compares new and existing data. "Save Results (CSV/Excel)": Saves comparison results to a file. Table Display: Displays extracted and compared data clearly in a table format. Result Saving: Supports saving in CSV for...
I'm in need of an Excel expert who can create a formula for me that ranks data in one column, starting a new rank when data changes in another column. Key Requirements: - The rank needs to be sorted in descending order within each group. - Understanding of IF statements, SUMIF/SUMIFS, and COUNTIF/COUNTIFS is a must. - Experience with complex Excel formulas and conditional calculations. Your expertise will help me streamline my data analysis process.
I'm seeking an experienced accountant to c...an experienced accountant to create a comprehensive balance sheet and profit & loss statement for a small business. Must have an understanding of USA tax code and a creative mind to explain entries and provide valid scenarios in the current post covid business environment. The deliverables should be provided in an Excel spreadsheet. Ideal Skills and Experience: - Proven experience in accounting and preparing balance sheets and profit & loss statements - Proficiency in Excel - Experience working with small businesses - Attention to detail and ability to deliver accurate financial documents Please note that I currently do not use any accounting software. Therefore, the balance sheet and profit & loss statement ...
I'm seeking a professional who can create a sophisticated Excel sheet for me. This sheet should: - Calculate arbitrage opportunities across multiple cryptocurrency exchanges, specifically Binance, Coinbase, and Kraken. - Fetch real-time cryptocurrency prices through API integration, rather than relying on manual entry or CSV imports. The ideal freelancer for this project should have extensive experience with Excel, a solid understanding of cryptocurrency and its market, and proficiency in API integration.
...be paying a fixed price of ₹100–₹200 for the entire project. If you’re okay with this price, kindly message me back so we don’t waste each other’s time. ### **Tasks to Complete** 1. **Update Portfolio Excel File**: - Add details of 12 new clients who hired me after the initial 60 reviews (the current file includes only 60 reviews). - Create a new column to include links to the portfolio folder for each project, ensuring the links match the respective projects. - Add a column with filters to categorize projects by type, such as: - **Data Entry** - **Excel Charts** - **Outsourced Projects** (e.g., Python projects outsourced to another freelancer). - **And More**. 2. **Organize Portfolio by Project Ty...
This coursework is an individual assignment. You must implement it independently. This coursework is a mini project which applies machine leaning techniques to analyse a real- world data set. You are asked to implement several machine learning tasks using the data from "Stack Overflow 2024 Annual Developer Survey". This survey will help you understand the state of software developers, you can read more about the survey here: Stack Overflow Developer Survey 2024. The dataset can be downloaded from the stack overflow CDN and imported into Kaggle: The following tasks are required in the coursework. (1) Implement exploratory data analysis and gain an understanding
I'm looking to have an interactive Excel dashboard created, focusing on specific parameters mapped at the district level for India. The primary parameter of interest is the Count of Automobile Competition. Key Requirements: - An interactive dashboard that visualizes the Count of Automobile Competition at a district level. - Moderate interactivity, including hover effects and clickable elements. - Presentation of data in an engaging and insightful manner. Ideal Skills and Experience: - Proficiency in Excel, particularly in creating interactive dashboards. - Experience in data visualization and presenting complex data in a user-friendly way. - Understanding of the Indian geographical and automobile landscape would be a plus.
I need to develop a Mini App with the following features: 1. Login: Use a registered account and password to log in. After logging in, 9 single-word items will be displayed. 2. Homepage: • Display products and text rotation. • Clicking on a product redirects to its details page, which includes a “Buy Product” button. • Clicking on “Buy Product” redirects to the order inquiry function. The balance under “4-2” will be displayed as unavailable. 3. My Orders: • Displays: all orders, pending, purchased, invalid, completed. • Orders are displayed with calculated prices, and products being ordered will show up in the order list. 4. Member Center: Recharge: Click to display recharge methods. Monitoring of payment meth...
I need a button added in the seller's account for downloading goods using the Unisite CMS script. This should also include a button in the admin panel for the site admin to download products on the seller's tab. The file format for the downloaded goods list should be in Excel. Ideal skills and experience for the job include: - Proficiency in PHP and knowledge of the Unisite CMS script. - Prior experience in creating similar download functionality. - Familiarity with Excel file formatting and handling.
I'm looking for assistance with Excel, specifically with data entry and organization. The primary focus will be on organizing customer information by customer ID. Key Responsibilities: - Organizing customer data in Excel - Ensuring accuracy and efficiency in data entry Ideal Skills: - Proficiency in Excel, particularly in data entry and organization - Experience with handling customer information - Attention to detail Experience with SEO is a plus, as I am also interested in optimizing this data from an SEO perspective. Please provide examples of similar projects you have completed in your proposal.
I'm in need of a detail-oriented professional to assist with cleaning and entering customer data in Excel. The primary task will be identifying and rectifying errors and inconsistencies within the data. Key Responsibilities: - Cleaning customer data in Excel - Data entry into Excel Ideal Skills: - Advanced Excel skills (proficient with formulas, pivot tables, macros) - Experience with data cleaning and data entry - Attention to detail to identify errors and inconsistencies Your work will help streamline our data management processes and improve overall data quality. Please reach out if you're interested and available.
I need a dedicated professional for manual data entry from printed documents. Key Responsibilities: - Accurately transcribing text data from physical documents into designated digital formats. Ideal Skills: - Attention to detail: Ensuring data is entered correctly without mistakes. - Profici...a dedicated professional for manual data entry from printed documents. Key Responsibilities: - Accurately transcribing text data from physical documents into designated digital formats. Ideal Skills: - Attention to detail: Ensuring data is entered correctly without mistakes. - Proficiency in typing: To ensure efficiency in data entry. - Familiarity with basic software: Such as Microsoft Word, Excel, or Google Docs. - Ability to work independently: Following instructions without constant su...
I'm looking for a professional who can build a comprehensive Excel spreadsheet for daily cash flow management. The model should ideally cater to the following requirements: - **Cash Flow Management**: The primary purpose of the model will be to assist in tracking and managing daily cash flow. - **Graphical Analysis**: The model should include features for graphical analysis, enabling easy visual representation of cash flow trends. The ideal candidate for this project should have extensive experience in financial modelling and Excel, with a strong understanding of cash flow management. Skills in creating visually appealing and informative graphical representations within Excel will be particularly beneficial.
I'm looking for a skilled professional to assist with data analysis and report generation in Excel, as well as setting up workflows, integrating with other tools, and customizing fields and modules in my Zoho CRM. Key Responsibilities: - Analyze data and generate reports in Excel - Customize Zoho CRM to fit our needs - Set up efficient workflows in Zoho CRM - Integrate Zoho CRM with other necessary tools Ideal Skills: - Advanced Excel skills - Proficient in Zoho CRM - Excellent data analysis capabilities - Experience in CRM customization and workflow setup - Familiarity with CRM tool integration
I need assistance in designing and organizing three Excel sheets to streamline our workflow and improve visual appeal. Below are the specific requirements: Sheet 1: Annual Events and Campaigns Calendar Purpose: This sheet will serve as a comprehensive calendar for all events and campaigns throughout the year. It should be easy to read and user-friendly for input by all team members. Sections: Marketing Campaigns Events and Conferences Social and Digital Media CEO Profile Raising C-Suite Engagement Traditional Media Internal Communications and Employee Engagement (EE) International Relations Community Engagement, with subsections: School Visits Festivals Farms Engagement Commercial Campaigns Other. Requirements: Each section should have enough cell space for ...
I accidentally deleted some crucial Word and Excel files from my SSD 6 months ago. I consulted several professionals, they all came to 2 problems: 1, The software cannot find out the files I need. Looks like the software only has a limit on storage of deleted files. After deletion, I have played and deleted a lot of games, so the deleted files scanned a huge, included mostly the games, not the files I want. 2, The recover files are not readable. - I'm looking for a data recovery expert who can use advanced tools to recover my lost files. - Previous experience with SSD data recovery is preferred. - Knowledge of recovery methods for Word and Excel files specifically is a plus. - Chat with me.
Hi,I have two excel sheets in one doc. One is with customer information (name, last name, date of birth, etc) and a code called Leistungsort. The code tells me in which store they went shopping. In the second excel sheet there is the adress of the shops including the bsnr. I need a couple of things. 1.) The adresses of the shops have to automatically be integrated into the sheets with the customers. Columne of the code (Leistungsort is the same in both excel sheets, so with that matching would be possible) 2.) After that i need a word letter with a standardized thext includeing all the customers from one shop. i need one word doc for each shop with the name of all customers. Please see the examples attached. This tasks need to be repeated every 2-3 month so i need a t...
...automatically receive reminders for the event via WhatsApp and email. • Automation tools like Power Automate or other free solutions should be used (NO paid 3rd party integrations allowed). 3. Backend Dashboard for Admin • The admin should: • Able to upload an Excel file containing a list of attendees to be added to the sign up database • Create and schedule to Trigger *Unlimited* bulk messages (email and WhatsApp) from the dashboard to remind/invite them to a Zoom session. • Functionality should include: • Bulk messaging from the Excel data. • Management and re-blasting scheduling options for reminders. Recourses : Website is using wordpress . Microsoft suite , hosting . Send me the Video ( similar project you have done before ) , Sc...
