List of information functions in excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
Existing functions still have to work with completely new templates bootstrap. I want to change the old to a new template. The duration is not more than 7 days. At a cheap price.
ทำ 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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
ไฟล์ template ที่มีให้เป็น .AI ต้องการใส่ข้อมูลลงใน template มีข้อข้อมูลต้นฉบับให้เป็น ไฟล์ pdf ให้ใส่เนื้อหาและจัดเรียงตามตัวอย่าง (file pdf) จำนวน 39 หน้า
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I need an Excel expert to assist me with various tasks involving data analysis and calculation 1. I have data and you need to do the historical data 2. After that you are required to write report as per requirement and instruction 3. Deadline: you may take 8-10 hours
I am seeking a talented pop vocalist with a knack for creativity. This exciting project involves converting a poem into a song. Key Responsibilities: - Create a pop melody for a specified poem - Bring the poem to life through song. Ideal skills: - Previous experience in the Pop genre - Strong vocal abilities - Previous songwriting experience or ability to translate poetry into musical form. This is a fantastic opportunity for those who excel in conjuring up catchy pop melodies and are skilled at breathing new life into written words.
I need a data entry specialist to help me with a simple task of entering data into spreadsheets. Ideal Skills and Experience: - Proficient in data entry, specifically into spreadsheets, with a keen eye for detail - Experience working with Excel or similar tools - Ability to maintain accuracy and meet deadlines - Good communication skills and reliability Looking forward to working with a professional who can complete the task efficiently and accurately.
I'm in need of a talented Senior Developer who has in-depth experience with both Boomi and Mulesoft. The primary goal of this project is to migrate our existing integrations to a new platform successfully. Key Requirements: - Proficiency in Boomi and Mulesoft: You should be well-versed in both platforms, able to navigate their functions and features effortlessly. - Migration Experience: Your role will involve transferring our existing integrations to a new platform. As such, experience with migration projects is essential. - System Integration: We're looking to integrate various types of systems, including CRM and ERP systems, custom applications, and third-party services. Your ability to connect these seamlessly is crucia...
In this project, I need a freelancer who can meticulously manage data entry tasks. Ideal Skills: - Strong data entry skills, specifically with text data. - Advanced knowledge of Excel and data management within it. - Ability to understand and follow custom data organization instructions. Job Summary: - Enter text data into Excel format, understanding the importance of accuracy. - The data must be organized in a specific, custom order that I will provide. - Experience in similar jobs and a keen eye for detail will be highly beneficial.
...Script that will specifically help me identify the 52-week high of a stock and plot a marker on the chart when this price point is reached. Key Requirements: - **52 Week High Calculation**: The script needs to identify the highest high of a stock in the past 52 weeks and utilize this as the 52-week high. - **Marker Plots**: When the price hits this 52-week high, it should automatically plot a marker on the chart to make this point visually identifiable. It's important that the script is accurate in identifying the 52-week high and that it's reliable in plotting the marker when this price level is reached. Ideal Skills: - Proficient in TradingView Pine Script - Experience in developing custom indicators and strategies - Unders...
I'm in urgent need of a skilled content writer who possesses strong proficiencies in Microsoft Excel. The primary task will involve generating written material for my organization, with an additional responsibility requiring accurate invoice creation. Your responsibilities in detail: - Generate compelling content that aligns with my organization's goals and objectives. - You would also be responsible for creating invoices using Microsoft Excel. Ideal qualifications and skills: - A strong grasp of the English language with excellent writing skills. - Prior experience with content writing and invoice creation. - Expert understanding of Microsoft Excel, particularly when it pertains to invoice creation.
...$50. I'm in need of a talented web designer who can use the template we've purchased to create a single page website for this political campaign. The primary aim of this site is to attract and engage a specific demographic group in the city we live in for the political campaign. Key Requirements: - The web site should look "exactly" like the template, include scale and size. - Copy for the web site is completed. - Images are available for the site - Incorporate relevant SEO elements to boost online visibility Ideal Skills and Experience: - Proven track record of creating engaging, conversion-oriented websites - Understanding of web design best practices and UX/UI principles - Proficiency in SEO to ensure the ...
I'm looking for an intermediate SAP administrator to assist with the basic administration of our SAP system. Key Tasks: - Basic user management, including creating and deleting users, assigning roles, and setting up authorizations - Monitoring system performance and taking necessary actions to ensure it runs smoothly - Troubleshooting and resolving basic configuration and authorization issues - Assisting with system backups and ensuring data integrity - Providing general support to the team on SAP-related queries It's important that you're comfortable working with the SAP system and have a good understanding of its basic functions and administration. A background in SAP Administration or similar roles is preferred. I will provide access to th...
...GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Su...
Please only bid if you have experience in song generation using AI. Your expertise will contribute to a cutting-edge project that combines music generation with voice cloning to create songs sing by virtual persons. We want our app to have the following features. - Create unique music based on user input information (speed, type, length...). - Create music based on the voice provided by the user - Change the voice of music provided by the user to the voice provided by the user Frontend is already done. The model we want must be able to perform two large functions. 1. Generate a song based on the text entered by the user using the sample voice selected by the user. 2. Converts the voice of the song uploaded by the user to the voice selected by the
I'm looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accu...
I'm looking for someone to help me create a list of 2000 industry specific business contacts, particularly names, company names, position, location information and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date information.
Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. Looking forward...
I'm in need of a seasoned freelancer who can help design a professional and engaging newsletter targeted specifically at newby freelancers. This is a recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools fo...
I'm in need of a creative and skilled developer to help me create an engaging platform for language translation between French, Algerian dialect, and vice versa. The goal is to enrich users' vocabulary. My primary requirements for this platform include: - A user-friendly search function that allows users to look up words in both languages. - A feature that enables users to record their pronunciation of words for feedback and improvement purposes. In terms of design, I envision the platform to follow a zoo and animal theme, presenting a fun, vibrant, and engaging visual experience for users. Ideal candidates for this project should have experience in: - Building interactive and engaging platforms - Integrating search function...
...converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas across d...
I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financial management toget...
As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality
As the client, I am search of a seasoned virtual assistant to support me during typical work hours, 9am to 5pm (UTC +1). The ideal candidate will possess the following expertise: CRM MANAGEMENT: Monitor and manage follow-ups and sales activities within the CRM. Update and maintain accurate records of customer interactions and sales leads. Assist in developing strategies to improve CRM processes and efficiency. Customer Service: Respond to customer inquiries and resolve issues promptly and professionally. Maintain a high level of customer satisfaction through effective communication and problem-solving skills. Liaise with other departments to ensure customer needs are met. Email Management: Monitor and manage the CEO's email inbox, prioritizing and flaggi...
Seeking assistant for con...Duties: Gather Contact Info Email & Phone Number for the following U.S States: 1. Utah ( Primary Home State) 2. Nevada 3. Idaho 4. Wyoming 5. Arizona 6. New Mexico 7. Colorado -Locate all Roofing companies by state and compile a list for me to email & offer property claim insurance services. - Locate all Restoration & Mitigation Companies by state to offer insurance property claim services. Contact Emails for HR preferred/ management. Email & Phone compiled into a spreadsheet or what you see best fit for a email list to send out. I am based in Utah so starting homebase and spreading out to surrounding states after. would like to have 100+ roofing companies by state. 100+ mitigation companies by stat...
I'm currently in need of a skilled individual proficient in Elementor and JetEngine to assist in finalizing the configuration of dynamic content imported from another site. The content, which includes Artists, Styles, and Portfolio Items, has been imported successfully (as a Crocoblock/JetEngine "skin" as well as Elementor archive and single templates), but requires further configuration to ensure it functions optimally on my website and fits the visual aesthetic. Key Tasks: - Configuring Custom Post Types (CPTs): The project involves working on Artists, Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships betwee...
I'm in need of an experienced Android developer to update our Java-based app, originally designed for Android 5 KitKat, to work seamlessly on modern tablets. Key Requirements: - Improve User Interface: The project involves enhancing the app's existing UI. - Compatibility Upgrade: The current app is only compatible with Android 5 KitKat; the developer must ensure it functions smoothly on contemporary tablets. Additional Information: - The app currently consists of 6-10 screens or activities. - A new feature will be the integration of Bluetooth connectivity. -The app controls hardware via bluetooth, sends PWMs and reads ADC values and reads/writes to an rs232 info stream
I'm in need of an experienced React Native developer to help me debug an issue with a hook in my app. - The hook seems to be causing unexpected behavior in the app but I'm not sure of the specific problem. - I'm not using any third-party libraries in the app that could be affecting the hook. I need someone who can efficiently identify and resolve the issue with the hook, ensuring that the app functions correctly without any unexpected behaviors. Please reach out if you have experience in React Native debugging and can help me with this.
I'm looking for a freelancer who can assist me with an unspecified test project.
I'm currently in need of a skilled individual proficient in Elementor and JetEngine to assist in finalizing the configuration of dynamic content imported from another site. The content, which includes Artists, Styles, and Portfolio Items, has been imported successfully (as a Crocoblock/JetEngine "skin" as well as Elementor archive and single templates), but requires further configuration to ensure it functions optimally on my website and fits the visual aesthetic. Key Tasks: - Configuring Custom Post Types (CPTs): The project involves working on Artists, Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships betwee...
...freelance cold caller to join our team and assist in prequalifying low-income prospects for our revolutionary no-cost health benefits program. This is an excellent opportunity for individuals who are skilled in high-volume cold calling and have a passion for helping others access essential healthcare services. Responsibilities: -Make outbound cold calls to potential prospects to prequalify them for our no-cost health benefits program. -Conduct approximately 100-200 calls per day with a focus on efficiency and effectiveness. -Engage prospects in a professional and empathetic manner to gather necessary information. -Use qualifying questions to determine eligibility based on income level and current health coverage. -Clearly communicate the benefits of ...
