Excel for reporting and 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...
ทำ 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 ที่กำหนดให้
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
analysis raw data to information วิเคราะห์เนื้อหา บริการ สินค้า ผลิตภัณฑ์ ทุกอย่าง ว่ามีข้อดี ข้อเสีย ประโยชน์ที่จะได้รับมีอะไรบ้าง เป็นต้น
...Optimization, and Lead Generation Specialist Description: I am seeking a skilled freelancer to help launch and grow my AI-powered virtual assistant business, Last Employee. We provide an AI virtual employee service at $297/month to small businesses, and I need to acquire my first 70 paying users quickly. This role requires expertise in branding, website optimization, lead generation, and sales-focused marketing. Responsibilities: and Website Optimization: Redesign and enhance branding to appeal to small business owners. Optimize the WordPress website for lead generation and user conversions. Create landing pages, calls-to-action, and high-converting copy. Generation and Outreach: Identify and build a list...
I'm seeking a skilled developer to create a Minimum Viable Product (MVP) with an AI-driven Software as a Service (SaaS) dashboard. Key requirements: - The primary function of the AI will be conducting data analysis and predictive tasks. This will include interpreting operational data and utilizing Internet of Things (IoT) data. - The dashboard should be capable of real-time monitoring, analyzing historical trends, and facilitating comparative analysis. Ideal skills and experience: - Proficiency in AI and data analysis - Extensive experience in developing SaaS platforms - Ability to create comprehensive, user-friendly dashboards - Familiarity with IoT data interpretation - Experience with real-time monitoring systems
-Need an accident reporting app Following are the bullet points. Landing Page: 1. User-Friendly Interface: Use clear and concise buttons with icons for Report, Track, and Complaint for easier navigation. Include a short message explaining the purpose of the app on the landing page. 2. Quick Access Options: Add an emergency call button for severe animal cases. Provide language options for broader accessibility. --- Report Button Flow: 1. Authentication: Verify the mobile number using OTP for security. Allow optional social login (Google/Apple ID) for quick access. 2. Incident Reporting: Fields to include: Dog Picture: Enable image upload with a preview option. Location: Use GPS or manual pin-drop o...
...in human and natural sciences, language, and/or advanced mathematics to review and validate a set of college-level questions. The task involves providing solutions to ensure the accuracy and integrity of the material, as if creating a comprehensive answer key for an advanced-level assessment. Key Responsibilities: - Review and validate a set of complex questions - Provide solutions to ensure accuracy and integrity - Create a comprehensive answer key for an advanced-level assessment Timeline: - Questions will be available on January 11th - Quick turnaround required on the same day Due to the nature of the project, timely and precise responses are critical to meet the project timeline. This task is part of an ongoing effort...
Excel Spreadsheet & Invoice Creation Assistance Excel Spreadsheet & Invoice Creation Assistance
YOUR TASK Identify an area of administrative or policy change to civil and/or criminal justice systems relevant to managing terrorism (i.e., justified by politicians in relation to counter-terrorism needs). Your goal is to investigate the impact of that change to the policing-management of ‘terrorism’ and its impacts upon wider civil society. NOTE: NON-AUSTRALIAN EXAMPLES ARE ACCEPTABLE. Some examples of areas of focus can include: Intensive screening of asylum seekers and migrants for ‘terrorism-related’ connections Meta-data retention laws (e.g., Telecommunications (Interception and Access) Amendment (Data Retention) Act 2015 (Cth)) Dual citizenship-stripping of returning foreign fighters Increased surveillance and...
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
I need assistance with managing hospital paperwork and invoicing using Microsoft Excel. Requirements: - Managing patient records and billing/invoices in Excel - Utilizing an existing template for patient records - Following a specific format for billing and invoices Ideal Skills: - Proficient in Microsoft Excel - Detail-oriented with ability to follow specific formats and templates - Experience with hospital paperwork and invoicing preferred.
I'm seeking a professional to create a compelling pitch deck for my healthcare innovation, aimed at attracting investors. The deck should include all essential components, with specific emphasis on the Executive Summary, Revenue Model, and Competitive Analysis. Key Components: - SAM, TAM, SWOT analysis - Clearly articulated Executive Summary - Detailed and persuasive Revenue Model - Comprehensive Competitive Analysis Ideal skills and experience include: - Previous experience in creating pitch decks, particularly for the healthcare industry - Strong understanding of investor expectations and requirements - Excellent design skills to create visually appealing slides - Ability to communicate complex concepts in a clear an...
Hello, I am looking for a professional to create a structured and clear document that adheres to the following guidelines for a project intended for the 3MI group. The document should include the following sections: Introduction: An overview of the topic and the objectives of the document. Photo of the robot in its reference configuration: An illustrative image clearly showing the initial configuration of the robotic arm. Kinematic diagram: A graphical representation of the robot’s kinematics, highlighting its joints and movements. Simplified diagram (if applicable): A simplified version of the kinematic diagram to enhance understanding, if relevant. Reference positioning: Description and illustration of the reference points used in ...
I'm in urgent need of a dedicated professional to help me track down sellers on Temu and SHEIN who are misusing my content to sell counterfeit versions of my clothing. Key responsibilities: - Identify sellers using my photos to replicate and sell copies of my clothes - Report each case as an Intellectual Property infringement through the official forms on the respective platforms Compensation: - I will pay for every case resolved Ideal skills and experience for this job: - Familiarity with e-commerce platforms, particularly Temu and SHEIN - Prior experience in IP monitoring and infringement reporting - Attention to detail to recognize misuse of content - Good understanding of the process of reporting through official p...
I'm looking for an expert in keyword research to help improve the search rankings of my tutorial and how-to videos on YouTube. The primary goal is to identify effective keywords that will enhance visibility and ranking on YouTube's search platform. Ideal Skills and Experience: - Proficient in YouTube SEO and keyword analysis - Experience with tutorial and how-to video optimization - Familiarity with YouTube's search algorithms - Ability to deliver actionable insights and strategies Steps: - Find keywords in VidIq, All the keywords has to scored above >70 only to be accepted - Ensure The keywords are relevant to stock market only - The keywords has to be not the one we already have here :
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
Link Posting (Bilingual: English and Chinese) Publish 20 SEO-optimized links daily on our website using the provided affiliate marketing materials. Ensure each link complies with SEO standards, embedding relevant keywords and descriptions. Provide detailed descriptions for each linked tool, including: Tool introduction. Feature breakdown. Free usage details. Paid usage details. Application scenarios. Blog Writing (Bilingual: English and Chinese) Write 2 high-quality blog posts daily, focusing on either the website's overall theme or specific tool-related topics, and ensure compliance with SEO requirements. Each blog post must be at least 1000 words, with appropriate images (we will provide the image resources). Task Requirements: High-Quality Blog Ar...
...dynamic and passionate freelancer to be our representative in Israel. This is an exciting opportunity for someone with a love of travel, strong networking skills, and a desire to promote Vietnamese tourism to the Israeli market. Job Description: Build Relationships: Establish and maintain strong relationships with key players in the Israeli tourism industry, including travel agencies, tour operators, and airlines. Generate Leads: Identify and pursue opportunities for collaboration, partnerships, and joint marketing initiatives. Market Research: Stay informed about travel trends, competitor activities, and the evolving needs of Israeli travelers. Provide Support: Assist with the development of marketing materials and...
I'm seeking a data analyst ...help me investigate factors affecting the retention of engineering students. The analysis should cover academic performance, student engagement, and the utilization of support services. Key Data Sources: - Grades and academic records - Survey responses - Support services utilization records Deliverables: - A comprehensive research report - Detailed technical documentation - A presentation slide deck Ideal Skills and Experience: - Proficiency in data analysis techniques - Experience with academic performance data - Ability to create clear and concise documentation - Skills in preparing presentation materials - Familiarity with student retention research Please ensure to include all relevant documentation...
We’re looking for a company or an individual who can develop a Saas product for event organisers. It would include a CRM for businesses and a customer portal. It will have 30 pages with different functions and all pages should be responsive. Pages will include but won’t be limited to: Business portal/CRM - Registration. - Settings (with business info.) - Login. - Events (where businesses can see all there events) - Create an event. - Edit event. - Create a menu. - Event summary and food order. - Individual food order. - Exports to excel - Food orders(sorted by course and table). - seating management Customer portal - Register. - Login. - Register and create an event. - Login and create an event. - C...
I'm looking for an ethical hacker to help identify security vulnerabilities in my web applications, with a primary focus on API security. Key Tasks: - Conduct a thorough assessment of my web applications to identify potential security threats and vulnerabilities. - Pay particular attention to the API security, as this is the primary focus area. - Provide a detailed report of findings and recommendations for security improvements. Ideal Skills: - Extensive experience in ethical hacking, specifically with web applications. - In-depth knowledge of API security. - Strong analytical skills to identify potential vulnerabilities. - Excellent communication skills for reporting findings and recommendations.
We're seeking a seasoned digital marketing consultant with 3-5 years of experience to review and enhance our Google and Facebook marketing strategies. Key Responsibilities: - Google Ads: Primarily focusing on refining our Keyword Strategy to increase our visibility and reach. - Facebook Ads: Conducting a thorough Performance Analysis to identify strengths, weaknesses, and areas for improvement. Ideal Skills: - Extensive experience with Google Adwords and Facebook Ads - Strong analytical skills for performance evaluation - Proficiency in keyword strategy development - Excellent understanding of target audience identification
...predefined, dynamic sampling logic as per business requirements. Examples for AR process: High aging claims (<30 days aging excluded). High-value claims (criteria defined by the client). Complex/Denied claim categories (exclude in-process, paid, zero-out claims; include "paid but not posted" claims aged 90+ days). Sub-process categories (e.g., Exception/Tasking). Insurance and time-stamped claims (if available). Duration-based sampling (time taken to complete the claim). Examples for Posting process: Manual batches. Denial/Correction batches/entries. ERA batches sampled minimally or excluded as per requirements. Sampling interface for QA Manager to: Set weightages (e.g., 20%, 30%). Enable multiple selection options for modifi...
...skilled Python programmer to help me automate the order placement on Interactive Brokers. Key Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result wi...
...Services is seeking native or fluent speakers of German for a conversational recording project involving two-person scripts. This project requires that you bring a recording partner who meets all of the requirements listed below. The recordings will be used for Text-to-Speech (TTS) research and development purposes and will not be broadcast or used in any public or paid media. Recording can be done in person or virtually. You can use your own recording software or our client’s recording platform. Scripts will be provided on a Google sheet with multiple tabs, with each tab including a separate script. Each Google sheet file will take approximately 10 hours to read with one recording file submitted per Google sheet tab. Each recording pair (you and...
I'm seeking a professional for a 3-day evaluation test on a React-based financial chart. The primary objective of this project is to enhance the usability of the chart, specifically focusing on the user experience. Key Responsibilities: - Conduct thorough usability tests over a 3-day period. - Identify potential areas of improvement within the user interface and ease of navigation. - Provide actionable recommendations to enhance the overall user experience. Ideal Skills and Experience: - Extensive experience with React and financial charting tools. - Strong background in user experience design. - Proven track record of usability testing and implementing improvements. - Excellent communication skills for clear reporting. The primary...
...strong background in managing and optimizing online stores across various platforms, ensuring growth and profitability. I specialize in driving traffic, enhancing customer experience, and increasing sales through strategic online marketing and data-driven decision-making. Key Skills and Expertise: E-commerce Strategy: Expertise in developing comprehensive eCommerce strategies that align with business goals, optimizing product listings, and improving conversion rates. Product Management: Proficient in managing product catalogs, ensuring accurate descriptions, pricing, and inventory control to deliver an excellent user experience. Online Marketing: Experience with SEO, SEM, email marketing, and social media campaigns to drive traff...
I need a macro or script for my Google Sheets and Excel to automate data entry. Specifically, I want it to automatically pull bold information from a specified source into designated columns, as demonstrated in a provided video. Ideal Skills: - Proficient in creating macros in Excel and scripts in Google Sheets. - Strong understanding of data entry processes. - Able to follow visual instructions precisely. Please note, the exact source of the bold information will be provided in the video.
...functionalities and links to the same database. The new design should align with the provided Figma prototype (but with old website data and sections and with new design) in terms of colors and modern aesthetics, with an emphasis on ease of navigation and responsiveness. old web site: figma design: Key Requirements: - All components from the old site must be retained and linked to the same DB, but with a new identity. - The design must be compatible with the Figma design and implemented
