How to find data analysis in excelงาน
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) จะรับพิจารณาเป็นพิเศษ
...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...
ทำ 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 วิเคราะห์เนื้อหา บริการ สินค้า ผลิตภัณฑ์ ทุกอย่าง ว่ามีข้อดี ข้อเสีย ประโยชน์ที่จะได้รับมีอะไรบ้าง เป็นต้น
...needs or project goals, and how to implement It Works:Consultation & Briefing: Share your vision, brand values, and goals with us. Our team will use this information to understand your needs Writing: Our team will assess your business and write your AI Action your report: You receive a report containing an analysis of your business and recommendations to supercharge your business with Features:In-depth Business analysis: Gain a comprehensive understanding of your business AI recommendations: Our AI experts will analyze your specific needs and goals, then recommend actionable AI solutions.Future-Ready AI Solutions: Stay ahead of the curve with business recommendations utilizing the best advancements in : FREE - Inclusive
I'm looking for a professional to assist with the management of my product data. Key Responsibilities: - Data Entry: Inputting product data accurately and efficiently. The ultimate goal of this project is to identify trends within the product data. Therefore, the ideal candidate should be skilled in: - Data Entry: Fast and precise data entry is crucial. - Data Analysis: Ability to spot trends and insights from the data will be highly beneficial. Experience in working with product data is a plus. Please provide examples of similar projects you've completed in the past.
...With expertise in ghostwriting and editing, I’ve crafted engaging content across multiple formats, including biographies, memoirs, e-books, fiction, non-fiction, websites, blogs, and product descriptions. Since 2016, I’ve been a full-time freelance copywriter with double Digital Marketing certifications. With a keen eye for detail and a passion for linguistic precision, I am well-equipped to undertake the comprehensive proofreading and editing of any book. I have a proven track record in editing various written materials, including books, with a focus on preserving the author's voice while refining clarity and coherence. With a decade of hands-on experience in the book world, I am eager to provide valuable suggestions to improv...
I'm seeking a professional who can help boost my website traffic primarily through organic search and on-page SEO optimization. Key Areas of Focus: - SEO: Enhance on-page SEO for better visibility and ranking. - Di...Marketing: Increase overall web traffic via effective digital marketing strategies. - Design & Canva: Create appealing designs that align with our brand and marketing efforts. - SEMrush: Utilize SEMrush for comprehensive SEO and keyword analysis. - Website Keywords: Optimize our website with relevant keywords to enhance searchability. The ideal candidate should have a strong background in SEO and digital marketing, with proven experience in on-page SEO optimization. Skills in designing, particularly with Canva, and using SEMrush f...
I'm looking for an expert in Burp Suite to assist with a betting project that involves opening multiple tabs for simultaneous monitoring. The primary focus is to analyze betting odds and optimize strategies, while also identifying issues related to bet rejection. Key Tasks: - Multi-tab setup for Burp Suite to facilitate real-time betting data analysis. - Identification and troubleshooting of issues impacting the betting process, particularly bet rejections. Ideal Skills and Experience: - Proficiency with Burp Suite for automated testing and user session simulation. - Strong background in betting odds analysis and strategy optimization. - Experience in troubleshooting system glitches during betting sessions. You...
...engineer's expertise to help us transition to a more suitable email service and implement a local storage system for offline mail archiving. Your responsibilities will include: - Assessing our current email usage and future needs - Identifying and facilitating the transition to a new email service with larger storage capacity - Setting up a local storage system for offline mail - Ensuring a seamless transition from Zoho to the new service Ideal candidates should have: - Proven experience with email service migration - Strong knowledge in network engineering - Experience with setting up local storage systems - Excellent problem-solving skills Please note, we are not just looking to upgrade our current Zoho plan. The goal is to ...
We already have a MySQL cursor with a loop set up to fetch values and perform certain calculations. We need an experienced MySQL developer to extend this cursor with additional logic to populate more values into the table in the most efficient way possible, with minimal overhead on the database. I will provide an Excel spreadsheet with simple formulas required to replicate the logic. The extension involves implementing approximately 9 additional calculations and updating a different table using simple IF statements based on the calculated values. Key Requirements: • Extend the existing MySQL cursor, which already has a loop set up for fetching values. • Implement about 9 additional calculations based on simple formulas provided in...
I'm seeking a PostgreSQL DBA expert to help me become professional in database tuning and optimization. Focus Areas: - Query Performance Analysis: Understanding how to assess and improve query efficiency. - Index Management: Learning how to create, modify and delete indexes for optimum performance. - Configuration Settings Adjustments: Gaining skills in fine-tuning database settings for peak performance. The ideal candidate would be one who can deliver personalized one-on-one training sessions tailored to my learning pace and style. Please include your relevant experience and approach to teaching in your proposal.
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
...programmer to create a version 6 code for TradingView. This code will implement the following: - Draw a Simple Moving Average (SMA) with a period of 20 on the main chart (overlay = true). - Draw two Exponential Moving Averages (EMA), one with a period of 5 and another with a period of 25, below the main chart (overlay = false). - Draw an upward arrow if one the the two conditions was fulfilled: a. If the last closed candle's EMA(5) has crossed above EMA(25) while the closing price of that candle is already above the SMA(20), or b. If the closing price of the last closed candle is above the SMA(20) while the EMA(5) of that closed candle is above EMA(25). The default colors for the indicators are: - EMA(5): Blue - EMA(25): Orange - SMA(20): Blue In addition, I ne...
I need a data analysis expert to compare the outcomes of 5 patients who underwent sleeve gastrectomy for weight loss, then after 3 years of weight regain, underwent OAGB (One Anastomosis Gastric Bypass). The analysis should focus on comparing the excess weight loss after one year between the two surgeries and the changes in weight and Body Mass Index (BMI). I have access to patient medical records in digital format (spreadsheets, databases). The metrics to be compared include: - Excess Weight Loss (EWL) - Body Mass Index (BMI) - Overall weight loss Ideal Skills: - Proficiency in data analysis and statistics - Experience in comparing surgical outcomes - Familiarity with medical data ana...
We are seeking skilled Czech voiceover artists for an exciting project to create high-quality audio samples as we are developing a cutting-edge text-to-speech model. This exciting role requires producing 1 hour (up to 5 hours) of clear, well-recorded voice samples, adhering strictly to our technical and quality guidelines. Essential Requirements: 1. Recording Format: 48 kHz in Mono audio format. 2. Frequency: Ensure a minimum of 20 kHz. Recordings below this will be rejected. Your microphone and software must meet this requirement. (Please review the attached image below. Ensure you self-check the audio quality using the Ocenaudio app. Share a screenshot of your audio analysis.) 3. Sound Quality: Audio must have NIL echo and be completely free...
We are seeking skilled Dutch (Belgium) voiceover artists for an exciting project to create high-quality audio samples as we are developing a cutting-edge text-to-speech model. This exciting role requires producing 1 hour (up to 5 hours) of clear, well-recorded voice samples, adhering strictly to our technical and quality guidelines. Essential Requirements: 1. Recording Format: 48 kHz in Mono audio format. 2. Frequency: Ensure a minimum of 20 kHz. Recordings below this will be rejected. Your microphone and software must meet this requirement. (Please review the attached image below. Ensure you self-check the audio quality using the Ocenaudio app. Share a screenshot of your audio analysis.) 3. Sound Quality: Audio must have NIL echo and be comple...
We are seeking skilled Romanian voiceover artists for an exciting project to create high-quality audio samples as we are developing a cutting-edge text-to-speech model. This exciting role requires producing1 hour (up to 5 hours) of clear, well-recorded voice samples, adhering strictly to our technical and quality guidelines. Essential Requirements: 1. Recording Format: 48 kHz in Mono audio format. 2. Frequency: Ensure a minimum of 20 kHz. Recordings below this will be rejected. Your microphone and software must meet this requirement. (Please review the attached image below. Ensure you self-check the audio quality using the Ocenaudio app. Share a screenshot of your audio analysis.) 3. Sound Quality: Audio must have NIL echo and be completely free...
We are seeking skilled Vietnamese voiceover artists for an exciting project to create high-quality audio samples as we are developing a cutting-edge text-to-speech model. This exciting role requires producing 1 hour (up to 5 hours) of clear, well-recorded voice samples, adhering strictly to our technical and quality guidelines. Essential Requirements: 1. Recording Format: 48 kHz in Mono audio format. 2. Frequency: Ensure a minimum of 20 kHz. Recordings below this will be rejected. Your microphone and software must meet this requirement. (Please review the attached image below. Ensure you self-check the audio quality using the Ocenaudio app. Share a screenshot of your audio analysis.) 3. Sound Quality: Audio must have NIL echo and be completely f...
I'm looking for a skilled professional to assist with advanced Excel tasks, day-to-day inventory management, and voucher entries. The candidate should be proficient in VLOOKUP, charts, and pivot tables, and adept at removing duplicates. Key responsibilities include: - Utilizing advanced Excel functions for data analysis and visualization. - Regularly updating stock levels and performing inventory reconciliations. - Assisting with various voucher entries, including expenses and income, purchases and sales, and journal entries. - Maintaining comprehensive account books, including cash and bank, sundry debtors and creditors, current assets and liabilities. - Performing BRS and journal entries, as well as managing credit and debit notes a...
I'm looking for a comprehensive list of Honda 2-wheelers dealers across India, extracted from the provided website. The data should be organized in an Excel file with the following characteristics: - Specific Details: For each dealer, I need the dealer name and address, as well as their contact numbers and email. - Geographic Scope: The list should cover all of India. - Data Organization: The dealers should be organized in the Excel file by state. Ideal skills for this job include data extraction, proficiency in Excel, and attention to detail. Previous experience in compiling similar lists would be an advantage.
I'm seeking a detail-oriented freelancer for a project involving manual data entry from PDF files. The primary purpose of this task is to prepare the data for analysis, so accuracy and attention to detail are crucial. Key Responsibilities: - Manually entering mixed data (numerical and textual) from PDFs into a specified format or database - Ensuring the accuracy of the data entry to facilitate reliable data analysis Ideal Skills: - Proficiency in data entry - Strong attention to detail - Familiarity with handling mixed data types - Capability to work with PDF files Experience: - Prior experience in manual data entry is highly preferred - Experience in da...
...talented freelance developer to lead the development of a platform aimed at simplifying the management of multiple supplier. The platform will serve as a central hub for our business to efficiently oversee and coordinate various suppliers, incorporating manual data feed capabilities, API & Webhook integrations, and Shopify integration among other functionalities. Key Responsibilities: • Supplier Onboarding and Management: Develop features to register and manage supplier profiles, including catalogues and contact details. • API, Webhooks, and Automations Integration: Create integrations with suppliers to automate data exchange. • Manual Data Feed Options: Implement options for suppliers who lack automated systems. &bull...
We are seeking skilled Greek voiceover artists for an exciting project to create high-quality audio samples as we are developing a cutting-edge text-to-speech model. This exciting role requires producing 1 hour (up to 5 hours) of clear, well-recorded voice samples, adhering strictly to our technical and quality guidelines. Essential Requirements: 1. Recording Format: 48 kHz in Mono audio format. 2. Frequency: Ensure a minimum of 20 kHz. Recordings below this will be rejected. Your microphone and software must meet this requirement. (Please review the attached image below. Ensure you self-check the audio quality using the Ocenaudio app. Share a screenshot of your audio analysis.) 3. Sound Quality: Audio must have NIL echo and be completely free f...
We are seeking skilled Malay voiceover artists for an exciting project to create high-quality audio samples as we are developing a cutting-edge text-to-speech model. This exciting role requires producing 1 hour (up to 5 hours) of clear, well-recorded voice samples, adhering strictly to our technical and quality guidelines. Essential Requirements: 1. Recording Format: 48 kHz in Mono audio format. 2. Frequency: Ensure a minimum of 20 kHz. Recordings below this will be rejected. Your microphone and software must meet this requirement. (Please review the attached image below. Ensure you self-check the audio quality using the Ocenaudio app. Share a screenshot of your audio analysis.) 3. Sound Quality: Audio must have NIL echo and be completely free f...
I'm seeking a local camera operator in the Irvine, CA area (preferrably a high school or college student willing to learn about videography, photography, marketing, and how to speak to people with confidence. I will be conducting professional interviews outdoors, (sometimes indoors) and I need someone to hold the camera for me. All equipment will be provided by me, and I will handle the setup myself. My goal is to find millionaires in person and interview them with business questions. This will be for a YouTube channel.
Project Title: Development of an Accurate Solana Wallet Scanner for Profitable Wallet Analysis Project Overview: I am seeking a skilled blockchain developer to rebuild and set up a wallet scanner specifically for the Solana blockchain. The scanner’s primary purpose is to identify profitable wallets worth copying, based on reliable data metrics such as Profit and Loss (PnL), win rate, and performance over weekly/monthly timeframes. The current implementation is plagued by inaccurate or false data, resulting in wallets with near-zero balances being reported as highly profitable. Despite trying multiple APIs (Solana public API, GMGN API, and BirdEye API) and even scraping data from relevant websites, the results have been incons...
I'm in need of an AI agent tailored for market research purposes. This agent will be responsible for scraping specific product pricing from Australian supermarkets, focusing on household items. The data collected should encompass a comprehensive set of product details including price, promotional price, weight, dimensions, colour, and additional product information. Ideal Skills: - AI/ML Development - Web Scraping Expertise - Data Analysis - Market Research Understanding The AI should collect this data on a monthly basis. Prior experience in developing similar projects would be highly regarded, as well as a deep understanding of market research methodologies and requirements.
...every edit completed✨ Are you a skilled short-form video editor who knows how to turn real estate talking head content into engaging videos under 60 seconds? Do you excel at delivering scroll-stopping edits quickly while maintaining quality? We’re looking for someone who specializes in short-form content that captures attention and drives engagement! What We’re Looking For: Expertise in editing short-form real estate talking head videos (less than 60 seconds) Strong knowledge of platform-specific trends (Instagram Reels, TikTok, YouTube Shorts) Ability to create dynamic captions, transitions, and hooks that capture viewers' attention in the first 3 seconds Efficient workflow with quick turnaround times Proficiency ...
I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros