Excel pivot table data raw dataงาน
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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์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 วิเคราะห์เนื้อหา บริการ สินค้า ผลิตภัณฑ์ ทุกอย่าง ว่ามีข้อดี ข้อเสีย ประโยชน์ที่จะได้รับมีอะไรบ้าง เป็นต้น
I need a skilled developer to create an ASP.NET Web Forms project that connects with Power BI. The requirements are as follows: 1) Establish a connection between ASP.NET and Power BI. 2) Implement a login system where each user has a unique username and password and can only access their own information. 3) Ensure the display of user-specific data (Pid, Job_Name, Email, location) in Power BI in table format. I will provide the necessary SQL queries, but feel free to create stored procedures if you see fit. Ideal skills and experience for this job: - Proficiency in ASP.NET Web Forms. - Experience with Power BI integration. - Strong SQL skills. - Knowledge of creating secure, user-specific access in web applications.
I'm in need of a professional who can create a Classified Balance Sheet in Excel for internal review purposes. The balance sheet should be comprehensive and include the following sections: - Assets and Liabilities - Current and Non-Current - Equity The ideal freelancer for this project should have extensive experience in Excel, finance, and balance sheet preparation. The ability to present complex financial data in a clear, understandable manner is crucial.
I need help with data entry into my CRM system. The data consists of customer contact information, which is currently stored in Excel spreadsheets. Please note that the specific CRM system has not yet been determined, so flexibility and adaptability are key for this project. Ideal Skills: - Proficient in data entry - Familiarity with various CRM systems - Strong attention to detail - Excellent knowledge of Excel - Good understanding of customer contact information
I'm looking for an Excel expert to create a comprehensive workbook for analyzing our sales data. The primary purpose of this Excel book will be to aid in sales forecasting. Key Requirements: - Design and build an Excel workbook tailored for in-depth sales data analysis - Incorporate advanced Excel functions and techniques for accurate sales forecasting - Ensure user-friendly layout and functionality for office use Ideal Skills and Experience: - Proficient in Excel with a strong background in data analysis - Experience in creating tools for sales forecasting - Able to present complex data in a user-friendly manner
...platforms (YouTube, TikTok, Instagram, LinkedIn, Facebook, Twitter/X, Threads, and Bluesky). We’re looking for someone who: ✔ Understands the latest social media trends and algorithm updates ✔ Can create a content strategy that aligns with our business goals ✔ Knows how to optimize posts for maximum engagement, SEO, and virality ✔ Can analyze content performance and adjust the strategy based on data insights ✔ Is familiar with career coaching, job search trends, and professional growth content Responsibilities: ✅ Develop monthly content calendars and strategic posting schedules ✅ Research & apply viral trends (especially for TikTok, YouTube Shorts, and Instagram Reels) ✅ Optimize hashtags, captions, and social copy for each platform ✅ Track key performance metrics (re...
I need help with extracting text from a PDF document and organizing it into specific columns in an Excel spreadsheet. The task involves: - Text extraction: Pulling relevant text from a PDF file - Data organization: Sorting this text into designated columns in an Excel spreadsheet. The ideal freelancer for this project should have experience in data entry, particularly with PDF to Excel conversions. Attention to detail is crucial as the data needs to be accurately placed into specific columns.
...Level2:2000 Level3:5000 Level4:10000 Level5:20000 Level6:30000 Level7:40000 Level8:50000 no need to pay after level 8. 2. After transferring the amount to up-line user’s UPI transaction details need to submit the screen shots of payment 3. After approve from up-line user (confirm payment), registered user can move to further level Dashboard 1. Down-line list 2. User view their down-line user in the table view 3. Total amount available in wallet to each user 4. Total number donation credited from each user based on level. E-pin 1. 10digit e-pin Generated by admin and transferred to the user 2. Need active E-pain and inactive e-pin details 3. Up-line users can add the down-line user by purchase of e-pin from admin 4. At the time of registration user need to take E-pin...
...to guide me through analyzing data in Excel in a structured and professional way. My goal is to improve my Excel proficiency and learn practical techniques while working on my existing data. What I Have: • An Excel sheet with data ready for analysis. • Basic knowledge of Excel. What I Need: • A professional to guide me step by step in: • Data cleaning and preparation. • Using advanced formulas and functions. • Creating pivot tables and charts. • Analyzing trends and insights. • Other relevant professional techniques based on my data. Requirements: • Expert-level proficiency in Microsoft Excel. • Ability to teach and explain concepts clearly and pati...
Position Summary: We are looking for a rigorous and competent data entry professional to ensure the entry, processing and management of data in our systems. The ideal candidate will be proficient in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic documents and media using Adobe In...
I'm looking for a PHP expert to help modify my existing system. The project involves renaming elements and enhancing a form. The scope of work includes: - Renaming: Change all table and variable names from 'member' to 'beneficiary'. - Form Enhancement: Add additional questions regarding contact details, personal information, and beneficiary preferences to the 'add beneficiary' form. - Layout Changes: Implement specific layout changes on the pages form, which includes rearranging the order of form fields, changing the form style or theme, and adding sections or tabs to the form. Please note, I will need client-side validation for the new form fields. The ideal freelancer for this project should be proficient in PHP and have experience with form...
I need an experienced video editor to transform my drone footage into a polished video of my personal event. Ideal Skills: - Proficiency in video editing software - Experience with drone footage - Creative storytelling through editing Please note, no special effects like slow motion or time-lapse are required. The focus is on creating an engaging and memorable video from the raw drone shots.
I'm in need of a s...thorough skip tracing. Currently, my focus is on six counties in my state: St. Louis City, St. Louis County, Lincoln County, Jefferson County, and Warren County. However, as my business expands, so will the scope of this project. This is an ongoing opportunity, with added cash bonuses for quality work. The data I require for each lead includes: - Name and last known address - Phone number and email - Property details and foreclosure status - Date of foreclosure All leads must be delivered in an Excel spreadsheet. Accuracy is paramount, and I'm looking for someone who can grow with my company. Ideal skills for this job include: - Proficiency in skip tracing - Experience with mortgage foreclosure overages - Exceptional attention to detail - Abil...
I'm seeking a skilled video editor for my YouTube channel, which primarily focuses on gaming content. The main aim of the channel is to boost subscriber count, so the editor should have a keen understanding of what makes a gaming video engaging, shareable, and appealing to the YouTube audience. Key Responsibilities: - Edit raw gaming footage into enticing, fast-paced videos that hold viewer attention - Incorporate sound effects, voiceovers, and subtitles where needed to enhance the viewing experience - Understand and implement trends in gaming content on YouTube to keep the channel relevant and engaging Ideal Skills: - Proficiency in video editing software such as Adobe Premiere Pro, Final Cut Pro, or similar - A good understanding of gaming and gaming culture - Previous exp...
We currently use MS Fabric to house Procore analytics; however, bidboard does not have analytics and we must download an excel file. I'd like to set up a Lakehouse to manually import these excel files and then give our data analyst access to query the information. As a bonus it would be nice to be able to set up this information to share with Salesforce. This would be our first bit of outside data that we would be able to collaborate with our Procore data so I'd like some help setting it up correctly the first time. I'd also like to set it up with the Powerbi model so that when we add a new excel file it removes duplicates and I am able to slice by month, quarter, year. and custom date range.
I'm seeking a data entry clerk who can help me extract salah timetables from images and websites of approximately 50-100 mosques around the UK every month. This task involves: 1. Visiting the website of each mosque to screenshot the timetable for the current month. 2. Using any reliable tool to extract the data (I can provide access to ExtractTable if needed). 3. Copying and pasting the table columns into a provided template file. 4. Ensuring that the formatting is correct, with columns in the right order and times in 24h format. 5. Sending the completed file back to me. It takes approximately 2-5 minutes per mosque and so, I will pay £0.10 - £0.20 per file completed correctly. That means if you complete 50 timetables over 2 hours, you will earn &pou...
I'm in need of a tool that can take engine sound ramps (from idle to redline) and extract constant RPM sounds into looped samples. Key Requirements: - Input: RAW WAV engine sound ramps - Output: Separate files for each RPM, specifically every 500 RPM intervals Ideal Skills: - Experience with audio processing and sound engineering - Proficiency in software development for audio tools - Familiarity with engine sound characteristics and requirements for RPM sound extraction. example:
I'm seeking a professional to compile Material Safety Data Sheets (MSDS) for all raw materials required in the production of memory foam. The MSDS should cover commonly used materials, not specific formulations. Key Requirements: - MSDS for all raw materials used in memory foam production - Focus on commonly used materials - Delivery of MSDS in PDF format Ideal Skills and Experience: - Proficiency in compiling or sourcing MSDS - Familiarity with manufacturing materials, particularly in the foam industry, is a plus - Excellent attention to detail and ability to meet deadlines. Please ensure that all MSDS are comprehensive and adhere to standard safety regulations. Thank you.
I'm looking for a financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts...financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts in both Argentina and the USA into a single Excel sheet or similar. Key Requirements: - Automatic linkage of all my checking, credit card and savings accounts. - Consolidation of expenses into a clear, comprehensible format. - Support for specific banks from Argentina and the USA. Ideal Skills and Experience: - Proficient in financial software and Excel. - Experience with linking bank accounts and credit cards for expense tracking. - Knowledge of specific Argentine and USA banks. - Ability to present data...
I'm looking for a Microsoft Excel expert to create a macro-enabled workbook for me. This workbook should have the capability to calculate CRC8 and CRC16 on user-specified hexadecimal strings. Key Requirements: - The CRC8 polynomial is x8 + x2 + x + 1. - The CRC16 polynomial is X16+X12+X5+1. - The workbook should be semi-automated, meaning it prompts users at certain stages but doesn't require constant interaction. - I want the hexadecimal strings to be inputted in user-specified cells upon execution, rather than fixed cells or a designated input sheet. As an example, this input string 20 00 00 C1 58 99 7D 3B 9F 00 01 yields a CRC8 value of 51 (all in hex) This input string 31 AF 20 00 00 C1 58 99 7D 3B 9F 00 01 51 yields a CRC16 value of FE 81 (both can be checked usi...
as discussed in private chat - amended pouch size for design - update all information, - nutritional table - artwork update on back and front (small changes to bring theme into brand) - ensure all Labelling information is correct and up todat - barcode space ? (where to acquire a barcode)n
...operations and coordinating logistics. This includes managing a system where users can log in, upload documents, and access shared resources. Key Responsibilities: - Oversee login system which includes standard email and password login and Multi-factor Authentication (2fa) for enhanced security. - Facilitate the upload of various document types including PDF files, Image files (JPEG/PNG), and Excel sheets. - Manage access to uploaded documents, ensuring they're available to designated specific user groups. Ideal Skills: - Experience in operations coordination. - Proficiency in managing document systems. - Understanding of security measures in login systems. Please note, a crucial part of this role is to ensure smooth operation and coordination of logistics, wh...
I'm in need of a skilled video editor for my reality show concept. All of the footage was captured On “Zoom“ And screenshots. The editing style should be "raw and unfiltered", capturing the true essence of the footage. Ideal skills and experience for the job: - Proficient in video editing software (e.g. Adobe Premiere, Final Cut Pro) - Prior experience in editing reality shows or similar content - Ability to work with unfiltered, raw footage - Strong understanding of pacing and rhythm to maintain viewer engagement - Excellent communication skills for discussing edits and feedback.
...Precise Cuts: Make clean, precise cuts to improve pacing, ensuring the video is dynamic and engaging throughout. Applying Colour Grading: Apply basic colour grading to ensure the video has visual consistency and a polished, professional look. Skills Required: Medium-level experience with video editing software (e.g., Adobe Premiere Pro, Final Cut Pro, or other equivalents). Ability to work with raw footage and enhance it by following guidelines for smooth pacing, flow, and visual consistency. Attention to detail to ensure all edits align with the channel’s style and tone. A basic understanding of pacing, visual storytelling, and the YouTube audience. This is a great opportunity to grow your skills and work on a consistent basis with the potential for more projects down the...
...marketplace, can distribute his songs via our platform and get daily & monthly reports on his tracks using official SPOTIFY API. User can also pay to order a custom artwork for his album/single. Can withdraw his stream earnings and so on. Must be done a complete & custom back-end to handle users modules such as distributed songs, stats and so on and admin modules such as earnings, reports, stats, excel exports, invoices and settings. Payments gateway, social logins etc must be integrated and implemented. Multi languages support. Laravel 8 & latest tecnologies must be used. Supporting cross website and devices. Eloquent Master & Seo friendly. Modern stylish & material design website. Must be used only up-to-date libraries. Must be provided an API to connec...
I'm looking for a professional video editor to refine my product assembly footage. The final edit should be an instructional video with a step-by-step guidance style. Key Tasks: - Shorten the raw footage (1 hour 30 minutes) into a concise, clear video. - Cut and arrange clips for a smooth flow. - Add simple text overlays labeling part names and sizes as mentioned in the video. - Remove unnecessary pauses and redundant sections. Final Deliverable: An MP4 or widely used format is good, video that is well-structured, professional, and easy to follow. Ideal Skills and Experience: - Proven experience in video editing, preferably for instructional content. - Proficient in adding text overlays. - Ability to maintain a clean, professional look throughout.
...will serve as a tool to manage information about cars, service jobs, and associated costs. It should also support multimedia attachments such as photos and videos. ### Requirements: 1. **Car Details Table:** - Fields: Car Make, Model, Year, VIN, License Plate, Purchase Date, and other relevant details. - Multimedia: Allow uploading photos and videos of the cars. 2. **Service Job Table:** - Fields: Date of Service, Job Description, Labour Cost, Parts Cost, and Total Cost. - Multimedia: Allow attaching photos and videos showing the work done. 3. **Summary Table:** - Automatically calculate and display summaries, such as: - Total spending on labour and parts. - Breakdown of costs per car. - Total number of servi...
