Excel expert formulasงาน
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 ที่กำหนดให้
สวัสดีคุณ Facebook Marketing Expert ฉันสนใจประวัติของคุณและต้องการเสนอโปรเจคให้คุณ เราสามารถหารือเกี่ยวกับรายละเอียดต่างๆ ผ่านการสนทนาได้
วาดภาพจำลองโคมไฟของบริษัท ตามแบบ 2d ที่เป็น outline พร้อมรายละเอียดสัดส่วน และขนาดให้พร้อม อยากให้เห็น texture และรายละเอียดของงานให้ได้เหมือนของจริงมากที่สุด เช่น เหล็ก นอต พลาสติด สายไฟ อลูมิเนียม เเสงไฟ เงา อาจจะต้องมีหลายมุม ทั้งแขวน ตั้ง วาง จำนวนงาน : 7 แบบ (แต่ละแบบมีอย่างน้อย 3 มุม) รวม 21 รูป
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I am currently in search of a 3D expert who is proficient in either modeling, animation, or rendering. With limited specifics to provide, it is crucial for interested candidates to demonstrate a well-rounded skill set. My expectations include: - A variety of past work samples showcasing your talent in 3D modeling, animation, or rendering. - Your experience level in the 3D field. - A detailed project proposal outlining your work process, your understanding of the requirement and how you intend to execute it. The timeline and deadlines for the project are flexible, but I am interested in knowing your general availability and how swiftly you work within a given timeframe. Your proposal should, therefore, include this information. Ideal candidates should be quick learners, possess ex...
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will ...
ONLY RESPONSES THAT ADDRESS THE QUESTION AT the END WILL BE CONSIDERED? I need a knowledgeable Stratum v2 expert for assistance with the following tasks: - Mining Pool Configuration: Proper setup and configuration of the mining pool. - Mining Software Integration: Seamless integration of mining software into the current setup. - Protocol Optimization: Optimization of the Stratum v2 protocol to ensure peak mining performance. The specific programming languages used for the current implementation are unknown as the previous question was skipped. In terms of hardware, my setup currently includes Windows and GPU. Thus, the successful freelancer should have experience working with these specifications and will consider this in the implementation process. The ideal freelancer shoul...
I'm looking for a skilled professional who can assist with my existing Squarespace website and Mailchimp setup. Your primary responsibilities are To create a subscription form that is already designed you are going to make the same design in Squarespace, and then integrate that form with Mailchimp. The form is straightforward just the Email address and subscribe button. See the attached form. Key responsibilities: - Implementing design changes on my existing Squarespace website. - Effectively integrating Squarespace with Mailchimp, ensuring both platforms work in harmony Ideal Skills and Experience: - Proven experience in Squarespace website design and customization - Strong understanding of and experience with Mailchimp - Experience in integrating Squarespace and Mailchimp If ...
I need a Python expert with an ability to cover various functionalities as per the need. The project might involve data analysis, web scraping, automation, or could be anything else as per the project requirements. The ideal candidate should have: - Expertise in Python programming and its different libraries. - Experience with data analysis, web scraping, automation. - Strong problem-solving skills. While applying, please share: - Your past work related to Python programming. - Your Python programming experience level. - Detailed proposal of how you can assist in this project.
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
Need texture to b done urgently
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated uniq...
I'm in need of a Git expert to help me with resolving conflicts. - I'd prefer to communicate the details of the conflicts via screen sharing sessions. - I expect the freelancer to have an expert level of Git knowledge. Your role will be to guide me through the process of resolving these conflicts in a clear and concise manner. Experience in similar roles will be a plus.
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...
I'm in need of a skilled mobile app designer who can assist in enhancing the features and look of my existing app. Key Requirements: - The design modifications primarily focus on UI improvements and functionality enhancements. - For the user interface, I'm looking to make changes to the color scheme, font styles, and the overall layout. - In terms of functionality, there are a few particular areas that need work: - Integration of push notifications to keep users engaged and informed. - Integration of social media, to enhance user experience and engagement. - Enhancing user authentication to ensure robust security measures. Ideal Skills and Experience: - Proven experience in mobile app design, with a strong portfolio of UI/UX work. - Proficient in design tools and...
As a DevOps developer with substantial experience in Azure, particularly in Azure infrastructure, Azure DevOps, and Azure networking, I need your immediate support in the following areas: Your responsibilities will include: - Implementing continuous integration and continuous deployment strategies. - Resolving any bugs in the CI/CD pipeline and identifying improvements. To successfully execute this project, you should: - Have 5+ years of experience in the Azure environment. - Be proficient in Azure infrastructure, Azure DevOps, and Azure networking. - Have a track record in Jenkins, GitLab, and Azure DevOps. If you possess the above-mentioned skills and experience, please apply for this project.
I'm in need of a WordPress expert to install and configure Yoast SEO plugin on my site. The task primarily involves: - Expert installation of Yoast SEO plugin - Proper plugin configuration to ensure optimal site performance - Allowing for efficient future content management Ideal candidates should have a solid background in WordPress plugin installation and configuration, preferably with Yoast SEO plugin. Proven expertise in SEO strategies and practices is highly valued for this role. The goal is to effectively improve site SEO through this plugin installation. Substantial experience in similar projects is a huge plus.
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
I'm in need of a Shopify expert to help me with my store. I'm looking for someone who has extensive experience working with Shopify. The ideal freelancer should have knowledge of the platform's backend, its themes, and its payment gateways. Your application should focus on your past experiences working with Shopify and how they have equipped you to take on this project. If you've worked on stores with similar needs or complexities, please highlight these in your application. Please let me know your rate and availability for this project. A reasonable rate, a strong grasp of Shopify, and the ability to work efficiently are key for me. Looking forward to your applications.
We are a home furniture customization supplier, and we need an SEO expert to help us optimize our website to get more customers and let them find us.
We are a home furniture customization supplier, and we need an SEO expert to help us optimize our website to get more customers and let them find us.
I'm looking for an experienced QA Automation Engineer for solving some issues we...an experienced QA Automation Engineer for solving some issues we have in a complex Jmeter script which we are using in our performance/load tests. This is a 1 week job at most and payment will be fixed at $500. Our JMeter script is not a simple one, so if you are not a real expert in JMeter please do not apply. You will fail to do the project. If you are an expert using JMeter for really complex projects, please apply by simply answering the below questions: 1- Tell us why you consider yourself a JMeter expert. 2- What were the most complex 2 projects that you did JMeter tests for and what made them complex. Please type "I can do it" at top of your reply so that I ...
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
I'm in need of a digital marketing expert with experience in engaging large audiences. The primary goal of this project is to boost engagement among a vast audience. Key Requirements: - Experience: Please provide details of your experience in similar projects. - Strong Communication: The ability to convey a message and engage with a large user base is key. Skills and Expertise: - Proven track record in digital marketing, particularly in boosting engagement. - Strong understanding of various social media platforms, as well as what techniques work best for each. - Excellent communication skills. - Understanding of the target audience and how to appeal to them. Please note that I skipped the question about social media platforms, as I am open to suggestions on the best cha...
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to de...
I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Id...
Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.
Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!
