Excel spreadsheet data miningงาน
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...
สวัสดีค่ะ รบกวนสอบถามหน่อยนะคะ พอดีจะให้ช่วยวิเคราะห์งานเพิ่มเติมหน่อยนะคะ แต่ทำในส่วน code python ไปบ้างแล้วนะคะ
ทำ 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 ที่กำหนดให้
I need you to fill in a spreadsheet with data. ทำงานค้าขายตามตลาดนัด
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I am seeking an AI coder for the development of a full-featured online ordering platform that emphasizes on streamlining orders and deliveries. Primarily, the platform should be designed to : - Excel on both desktop and mobile devices ensuring a smooth customer experience on all interfaces. - Prioritize on real-time scheduling functionality that optimizes order fulfilment with exemplary efficiency. -Connect to Service Monster API -Use as payment gateway. Ideal candidates should possess profound expertise in AI coding specifically in enhancing online platform functionalities. Experience with building real-time scheduling systems is critical for this project. Furthermore, a strong background in mobile and desktop compatibility is essential. The aim is to create an ordering
I am seeking an experienced RPA Developer to automate tasks relating to Excel and Web interaction. Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink you will open a broswer tab with that link analize the result of the web programming 1 or 2 IF statements Proceed to generate the unatended "clicks" in that web close the tab iterate with the next excel cell (in this case d6) repeat the web process Until Excel's data EOF Everything configurable via external TXT file - name of the excel file - starting cell - basic hyperlink - how to compose the final hyperlink - the IFs statements - the sequence of clicks for each IF condition Immediate offers after posting will be...
...Dollars). Responsibilities: - Data entry and file management: The ideal candidate will be responsible for inputting, updating, and maintaining data accurately and efficiently. - Email and calendar management: Handling and organizing emails and managing calendars, scheduling appointments and meetings. - Customer service and support: Providing excellent customer service, addressing queries and concerns. Software and Tools: - Microsoft Office Suite: Proficiency in Word, Excel, and PowerPoint is required. - Vettrak Student Management System: Experience with this software is beneficial but not mandatory. - Dropbox: Familiarity and experience with file management on Dropbox. - Facebook and Instagram. Ideal Skills and Experience: - Previous experience in administration,...
I am in need of a skilled bookkeeping specialist proficient in Tally data entry and Excel data entry and formatting. Key Tasks: - Entering less than 100 entries per week into Tally. - Formatting and managing Excel data. The work will be ongoing, with updates and reports required weekly. Ideal Candidate: - Must possess extensive experience with Tally and Excel. - Proficiency in bookkeeping and data entry. - Ability to handle tasks efficiently and with a high degree of accuracy. - Understanding of financial reports and data reconciliation. The ideal freelancer will be able to deliver clean, well-organized data, and provide timely reports. If you have the skills and experience required, please get in touch.
I am looking to hire a resume design professional capable of creating an impactful, mid-level professional resume for the mining industry. It should be tailored to highlight relevant skills, experience, and career progression, providing me with a competitive edge. Key requirements: - Expertise in resume writing specifically for the mining industry - Ability to effectively highlight mid-level professional experience - Strong design skills to create an engaging, easy-to-read resume format The final deliverable should be a high-quality, polished professional resume in PDF format. Your bid should reflect your understanding of this specific industry and mid-level experience resumes. Prior work in similar projects will be a plus.
I need a skilled professional who can compile a comprehensive spreadsheet of massage and beauty therapists. The data will come from provided databases which include salon details. Key Requirements: - Compile names, addresses, and phone numbers from the databases. - Organize the data in the spreadsheet by type of service (massage or beauty). The ideal candidate for this job should possess: - Proficiency in data entry and management. - Excellent attention to detail to ensure accuracy in the information gathered. - Familiarity with Excel for organizing the data by type of service. - A good understanding of the beauty and massage therapy industry would be advantageous. Please note that the final deliverable should be in Excel format.
I'm seeking a virtual assistant with excellent data entry and mining skills to help me manage a project. The ideal candidate should have experience in handling complex data entry tasks. Key Responsibilities: - Conducting thorough data mining to gather needed information. - Entering the mined data accurately into the system. The source of the data can be diverse, ranging from websites, PDF documents, to social media platforms. I'm looking for someone who can assist me efficiently with these tasks, ensuring that the data is accurately entered and organized. Previous experience in a similar role would be beneficial.
I am looking for someone proficient in typing to convert content from a 30 page PDF into Word and Excel documents. The majority of the content will go in Word with a few items to be transcribed into Excel. Requirements: - High typing accuracy and speed - Familiarity with Word and Excel formatting Specific instructions: - For Word, the content should be formatted in Calibri 12 point font and single spaced. - For Excel, maintain one row per entry for optimal readability. Ideal candidates should have prior experience in similar data entry tasks. Familiarity with PDF conversion tools, text formatting, and spreadsheet management would be a plus.
I'm looking for a skilled individual who can help me read a file and extract specific data from it. Key Requirements: - Extraction of File names, File sizes, File creation dates, and messages stored in the DB file. - Ability to adapt to extracting all messages or specific ones, depending on my future needs. - Delivery of the extracted data in a Spreadsheet format, preferably Excel or Google Sheets. Ideal Skills and Experience: - Proficiency in reading and interpreting files. - Advanced skills in data extraction, particularly from database files. - Experience in delivering data in a spreadsheet format. - Flexibility to accommodate future changes in the extraction requirements. - Strong communication skills to clarify requirements an...
...text and numeric data from a PDF table into an Excel spreadsheet. I would like the Excel data to be organized according to the fields in the PDF table. All fields in the PDF table should be included in the Excel sheet. Key requirements: - Export text and numeric data from a PDF table into an Excel spreadsheet - Organize the data on Excel according to the fields in the PDF table - Include all fields in the PDF table in the Excel sheet Ideal Candidate: - Proficient in PDF to Excel data transfer - Excellent attention to detail for verifying and cross-checking data - Familiarity with text and numeric data formatting in Excel - Capable of delivering accurate and organized...
...diligent freelancer with strong attention to detail and experience with Microsoft Excel and Shopify for a data entry project. Having a deep understanding of these two platforms is crucial to the seamless execution of the task. The project involves: - Using a spreadsheet to find and identify approx 4500 books on Amazon. - Using an online import tool to bring book data into a Shopify website - Adding extra product information in the shopify website from the spreadsheet about the book. - Determine the genre of the book and categorising in shopify accordingly. The ideal candidate should have: - Proven experience in data entry, preferably within Shopify. - Access to US version of Amazon. - Proficiency in Microsoft Excel. - High level of acc...
As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. Key Features: - Automatic Calculations: The plugin should be capable of performing automatic calculations, saving time, and minimizing any possible errors. - Data Validation: Ensuring data accuracy is crucial, thus the plugin should include data validation steps that help identify and correct any inaccuracies promptly. - Customizable Formatting: To enable smoother navigation and interpretation, the plugin should allow for customizable formatting tailored to my data and personal preferences. - Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me ...
I have a list of addresses for invitations that need to be transcribed from a handwritten list into an Excel spreadsheet. The addresses should be formatted consistently in the following structure: Name, Street Address, City, State, Zip Code. - Handwritten list will be provided, and should be transcribed accurately - Standardize the address format for consistency - No correction needed for typos, just ensure the format is standardized The ideal freelancer for this project would have: - Proficiency with Excel for data entry and formatting - Attention to detail to ensure accuracy and consistency - Experience with handling addresses or similar data is a plus
I need a lead generator extraordinaire to compile urgent, organized leads. The following specifics are must-haves: • Contact Information: Name, Phone, Email • Company Information: Name, Industry, Size • Industry-Specific Information: Relevance to Australian trade shows This is a draining task pulling resources from various databases and websites. Knowledge in research, data mining and excellent attention to detail are significant for this role. Previous experience in lead generation specifically for trade shows is a bonus. Understanding the nature and the dynamics of various industries in Australian trade shows would enable more efficient and accurate results. Since time is of the essence, I need someone with a quick turnaround without compromising the ac...
I'm seeking an experienced Excel professional to assist with the implementation of various financial formulas and functions in my spreadsheets. I am trying to create an excel sheet for sales people to put some data entry and get final pricing. i have the basic excel sheet ready, and if you willing to work on it i can share it and explain in more details In particular, I need help with: - The execution and application of financial functions specifically. - An ability to accurately conduct cost and estimating calculations. - Strong problem-solving skills to fine-tune formulas for efficiency and accuracy. A background in finance and substantial experience with Excel's wide array of financial functions would be very advantageous for the successful compl...
...uploaded to it – including PDF, Excel, and Word files. Here is what I am expecting: Document Interaction: • Extract information from PDF, Excel and Word files • Provide document descriptions that enable efficient and informative interactions Graph Generation: • Generate graphical representations from data extracts • Capable of creating bar charts, pie charts, and line graphs Desirable Skills & Experience: • Expertise in Django is a must • A good understanding and experience of GT4 API • Knowledge of ORM and DRF • Familiarity with data visualization may come in handy To recap, I'm seeking a Django chatbot that is able to interact with various document types, provide descriptions based on the documen...
I'm searching for an experienced developer to build an Engineering Resource Plan...projects seamlessly. - A refined reporting feature, to deliver accurate representation of the resources at disposal on a regular basis. Your ability to utilize historical data currently in spreadsheet format to create this planner is crucial. Hence, I'm majorly looking for individuals with an understanding of data handling/analysis and system development. I anticipate your expertise will bring accuracy and efficiency to our resource planning and reporting operations with this tool. Your contribution will be critical in improving decision-making processes. Ideal Skills: - Resource management - Spreadsheet data handling - Report generation - System deve...
...in the conversion of a PDF and an Excel file into a CSV format, specifically tailored for WIX integration. Key Requirements: - Conversion of a PDF file into a CSV format. The PDF contains crucial information that needs to be extracted and transformed into an easily readable and usable format for WIX. - The Excel file contains customer data, specifically including names, email addresses, and phone numbers. This information should also be integrated into the CSV file. Ideal Skills and Experience: - Strong expertise in data conversion, particularly from PDF and Excel to CSV. - Familiarity with WIX Integration - including the ability to format the CSV file in a way that is ready for immediate use in WIX. - Experience handling customer data and ma...
I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.
I'm seeking a data-savvy freelancer with a deep understanding of Instagram, to create a well-organized spreadsheet of micro influencers. There are three crucial components needed for each influencer: 1. Instagram Handle 2. Number of followers 3. Their Email Search Criteria - Dieticians and Nutritionists - Pregnancy and infertility - Mums / Working Mums 500 - 5000 followers only. Australian-Based Accounts
As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel...
I need help fetching influencer data from Instagram, YouTube, and TikTok. There are other platforms, and the influencers required here are trading influencers. 1 - Those who sell trading indicators. 2 - Who have special channels for trading.. 3 - Who have bots for automated trading Basic skills and experience required: - Deep understanding of Instagram, YouTube and TikTok – Experience in data mining or web scraping - Good at analyzing data - Flexible and adaptable working approach I will attach a file I created as an example of the requirements I want. If you see yourself as suitable for this job, create an example of the same file sent to you, but with different information, and send it to me
I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases
I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should incl...
I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double o...
I'm looking for a ...help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, sp...
I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the over...
In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with your expertise.
