Excel functions for statistical analysisงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
รับสมัครนักวิเคราะห์การเงิน(ฟรีแลนซ์ ทำงานที่บ้าน) รายละเอียดงาน -จำนวนที่รับ: ไม่จำกัด(รับเป็นแบบระยะยาว) -แนวทางบทความ: บทวิเคราะห์และกลยุทธ์การซื้อขายในด้านฟอเร็กซ์ น้ำมันดิบ ทองคำ ดัชนี หุ้นและสกุลเงินดิจิตอล ฯลฯ ตัวอย่างเช่นบทความในเว็บ -จำนวนคำของบทความ: 500-2000 คำ คุณสมบัติผู้สมัคร -มีทักษะในการเขียน สามารถสื่อสารออกมาให้ผู้อ่านเข้าใจได้ง่าย -ใช้ภาษาไทย และอังกฤษได้อย่างถูกต้อง -มีความคิดสร้างสรรค์ ไม่ลอกงาน -มีความชอบหรือถนัดและมีประสบการณ์ในการเขียนบทความด้านการเงิน -มีทักษะในการค้นคว้าหาและรวบรวมข้อมูลจากแหล่งต่าง ๆ -ถนัดในการวิเคราะห์ทางพื้นฐานหรือวิเคราะห์ทางเทคนิค -สามารถทำงานแบบระยะยาว สามารถส่งงาน 2-4 บททุกสัปดาห์ -จบสาขาวิชาการเงินหรือสาขาวิชาอื่นๆที่เกี่ยวข้องกับการเงิน หากถือใบรับรอง Chartered Financial Analyst(CFA) จะรับพิจารณาเป็นพิเศษ
...สามารถ 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...
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
analysis raw data to information วิเคราะห์เนื้อหา บริการ สินค้า ผลิตภัณฑ์ ทุกอย่าง ว่ามีข้อดี ข้อเสีย ประโยชน์ที่จะได้รับมีอะไรบ้าง เป็นต้น
I am in need of a skilled individual to assist me with a data entry project. The data provided comes in a digital format and is primarily numerical in nature. Key Respons...format and is primarily numerical in nature. Key Responsibilities: - Entering numerical data accurately and efficiently into the system - Ensuring data integrity and quality - Preparing the data for further analysis Ideal Skillset: - Proficient in data entry with specific expertise in handling numerical data - Strong attention to detail and accuracy - Familiarity with tools, software, or techniques for data analysis is a plus The main goal of this project is to have the data analyzed, so your contribution in ensuring the data quality and integrity will be crucial. An understanding of da...
I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.
I am looking for a proficient freelancer to undertake CV screening focused on technical skills. The ideal candidate will have: - The ability to verify competence in the domains of Programming, Network Management, and Data Analysis. - An excellent understanding of these areas to an intermediate level so you can correctly identify them in CVs. Your communication skills should be top-notch to allow smooth interaction. Also, your educational background in a technology-related field will be advantageous. Your role will be to screen through CVs and identify candidates that meet the required technical criteria to proceed to the next round of our hiring process. Your accuracy and precision would be greatly appreciated.
...data to a database. Here are the specifics: - **Export Data:** The form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience with exporting to databases and Excel - Proficiency in generating PDF docume...
...consumer preferences, competition analysis, and pricing trends. Key Tasks: - Gather and analyze data on consumer preferences regarding black beans in Mexico City. - Conduct a thorough competition analysis of the black beans market in the city. - Identify and document the pricing trends of black beans in the local market. - Complete the questionnaire we provided Target Audience: - Consumers: Understand their preferences, purchasing habits, and expectations. - Retailers: Identify key players, their pricing strategies, and market positioning. - Distributors: Explore current distribution networks, challenges, and opportunities. - wholesale market of agricultural products - Agricultural supermarket - Ideal Candidate: - Located in Mexico City for on-...
I am looking for an experienced electrical engineer who can perform a load flow analysis using Power Factory with moderate accuracy. Key Responsibilities: - Conduct a comprehensive load flow analysis of the electrical system specified. - Ensure moderate accuracy in the results obtained. - Provide detailed documentation of the analysis and results. Ideal Candidate: - Skilled and experienced in using Power Factory for load flow analysis. - Able to deliver accurate results while working independently. - Strong written communication skills for documentation.
I need ...be used for reporting and analysis. Key Responsibilities: - Cleaning up all the inconsistencies, errors, and duplicates in the dataset to make it suitable for reporting and analysis purposes - Ensuring the dataset is properly formatted and organized for its intended use Skills and Experience: - Proficient in data cleaning with a keen eye for detail - Experience with Excel and data entry is a huge plus - Strong understanding of data maintenance and organization - Ability to follow data cleaning guidelines and ensure data integrity The final dataset should be delivered in Excel format. The successful candidate for this job will have a deep understanding of data cleaning, excellent attention to detail, and the abili...
I'm looking for a Python expert who can help me preprocess and normalize a CSV dataset for a machine learning project. Key Responsibilities: - Loading the CSV dataset - Adjusting timestamps - Merging data from a single file - Normalizing the data using Min-Max scaling Ideal Skills and Experience: - Proficient in Python programming - Solid understanding of data preprocessing techniques - Experience with handling and merging large datasets - Familiarity with statistical analysis and machine learning modeling This project is crucial for setting a solid foundation for the subsequent machine learning analysis. The freelancer who takes on this role should be able to execute these tasks accurately and efficiently, with a strong eye for...
I am looking for a highly skilled and adept structural engineer who can supply me with the following: -HER ISS THE COMMUNICATION WITH THE COUNTY: Good afternoon all, There has been no permit technician assigned to the case, the previous owner had discussed removal of the structure and septic, and was not attempting to permit it. I can see about having one assigned, though a lot of the conversation will be dependent on the flood plain survey to determine if the structure can remain or not. Both it and the RV are currently located in the mapped floodplain. Certainly for procedural questions, the *********** is a good choice. Thank you, THE EXISTING BUILDING IS NOT PERMITTED AND I NEED A STRUCTURAL ENGINEER TO DO CALCS AND DRAWING FOR THE CITY TO GET IT PER...
...) Migration 6. Experience in working on SharePoint Migration project(s) 7. Knowledge on Migration tools such as Sharegate, Metalogix 8. Hands-on Expertise in Power Platform Governance and Administration 9. Experience in Common Data Service data modelling 10. Experience in creating solutions and custom connectors 11. Experience in creating Power BI reports 12. Knowledge of Azure Services/APIs/Functions Others 13. Strong customer interaction skills and ability to understand and document customer needs from a business solutions perspective 14. Microsoft Certifications (Power Platform/ M365/ Azure) 15. Experience in Nintex workflow and form, InfoPath 16. Experience in PowerShell scripts 17. Good knowledge on SharePoint Integration with LOB (SAP, Oracle, SQL,etc.) Thanks & Be...
We are looking for an expert in strategic analysis and marketing to write an in-depth article covering several key topics. The ideal candidate should have extensive knowledge and proven experience in the following areas PESTLE Analysis: Ability to analyze Political, Economic, Social, Technological, Legal, and Environmental factors affecting a company or industry. Porter’s Five Forces: Proficiency in using Porter’s Five Forces model to assess competition within an industry. Conduct thorough research on each of the topics mentioned above. Write a well-structured and informative article that integrates all required analyses. Collaborate with our team to ensure the article meets editorial and style guidelines. No AI required original text
I am in need of an experienced professional who can help with an enhancement to our powerflow analysis utilizing Power Factory software. This project is primarily focused on conducting a comprehensive powerflow analysis to improve the efficiency and reliability of our power systems. Key Responsibilities: - Conduct a powerflow analysis using Power Factory software - Implement enhancements to improve overall power system efficiency - Ensure compliance with regulatory standards and best practices - Provide a detailed report on the analysis and suggested improvements Ideal Skills and Experience: - Proficiency in Power Factory software - Strong background in power systems analysis - Familiarity with power losses, voltage stability, and power transfer optimi...
I'm in need of a skilled infographic designer to create a detailed, visually engaging presentation comparing five STEM education companie...to create a detailed, visually engaging presentation comparing five STEM education companies. The main objective of this infographic is to provide a comparative analysis, focusing on every aspect including teaching methods, curriculum content, and pricing. I've gathered all the necessary data. Visual elements I'd like to incorporate include, but are not limited to: - Charts and graphs - Icons and illustrations Experience with infographic design and a knowledge or background in STEM education is a plus. The work needs to be completed in a clear, creative, informative, and visually appealing manner. The content and outline f...
I'm looking for an experienced professional in Power Factory and Electronics. The project will involve a mix of tasks such as circuit design, power system analysis, PCB layout design, as well as potentially designing a circuit, simulating power systems, and developing control systems. Ideal Skills and Expertise: - Proficiency in Power Factory and Electronics - Prior experience in circuit design, power system analysis, and PCB layout design - Capability to undertake tasks related to designing circuits, simulating power systems, and developing control systems. - Strong problem-solving ability The task involves working on a project where knowledge and expertise in Power Factory and Electronics is crucial. The right candidate should be able to provide support in a ...
I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure the accuracy and fun...
I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.
I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus
I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing...
I'm in need of a specialist in data analysis, specifically predictive analysis. The purpose of this project is to generate a sales forecast derived from publicly available data. The resulting prediction should aid in budget planning, identifying sales trends, and setting sales targets. IN NEED OF A DATA ANALYSIS PROJECT FOR PREDICTING SALES Ideal Skills and Experience: - Expertise in predictive analysis - Proficient in analyzing publicly available data - Indepth understanding of sales forecasting - Strong statistical and mathematical skills
I'm looking for an experienced Python developer who has previously worked with options Greeks and the Zerodha API. Your main tasks will involve: - add third order greeks to an existing code The ideal candidate should have a strong command over Python, especially the Pandas library, and a thorough understanding of financial markets, particularly options Greeks. Prior experience working with the Zerodha API will be highly beneficial for this role. I look forward to your proposals!
I'm seeking a proficient freelancer to assist in a straightforward yet critical task. The project involves: - Data Entry: You will be required to input simple text or numbers into an Excel sheet. - Data Collection: Sourcing of data forms part of the project. This encompasses the need to gather the necessary information for the task. The ideal candidate for this role should have: - Strong Excel Skills: Proficiency in Excel is a must. You should be comfortable with data entry and basic functions. - Attention to Detail: Accuracy is paramount in this task. - Research Skills: The ability to efficiently source and collect the required data. Candidates with a track record of completing similar tasks efficiently and effectively will be highly regar...
I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into me...
I am in need of a professional who can create a website that perfectly blends modern and traditional design elements, while focusing on providing an informative experience for my visitors. Key Features and Requirements: - The website is primarily informational in nature, so it must be designed with a user-friendly interface and clear navigation. User should be able to find product description using part number - Required to create a digital product catalogue that can also be downloaded as a PDF booklet - The design should be a seamless integration of modern and traditional styles, ensuring an appealing and unique look that stands out. - It is crucial to include product categories and filters, enabling visitors to easily search and navigate through the content. - The website must a...
As the creator of this project, I'm looking for an AI/ML expert to leverage their skills and experience in object recognition and anomaly detection to analyze various types of video footage - from surveillance videos to live streams and pre-recorded videos. Key responsibilities include: * Implementing object recognition and tracking techniques to detect anomalies. * Ensuring real-time alerts for any suspicious activities, amplifying the safety measures. * Aiming for improved accuracy in detecting potential safety hazards. * Enhancing the efficiency of video footage monitoring and analysis. The ideal candidate should be proficient in AI/ML, with proven experience in object recognition, anomaly detection, and video analytics. The ability to provide real-ti...
...pitch deck for my upcoming event. The purpose of this pitch deck is to attract potential investors. - The ideal candidate should: - Have prior experience in designing pitch decks - Be proficient in creating professional and modern designs - Have experience in incorporating financial projections and market analysis into a visual format - Be able to translate complex data into visually appealing infographics - Be able to adhere to strict timelines and deliver quality work within the given timeframe The pitch deck should include: - Financial Projections: This should clearly and effectively present the financial outlook of the event, making it appealing to potential investors. - Market Analysis: A comprehensive and visually engaging representation of t...
