Excel data manipulation courseงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I need a Python developer to create a tool for me that can convert different file formats. Although I did not specify the particular formats, I am looking to convert at least two different formats. The tool should have a user-friendly interface and be able to handle these conversions seamlessly. Ideal skills and experien...least two different formats. The tool should have a user-friendly interface and be able to handle these conversions seamlessly. Ideal skills and experience for this job include: - Proficiency in Python - Experience in creating file conversion tools - Knowledge of different file formats - Strong problem-solving skills - Ability to create a user-friendly interface - Understanding of data handling and manipulation Complete details will be provided to shortl...
...extract this data and compile it into an Excel sheet for easier analysis and management. Key Components: - Extraction: The data extraction process will include obtaining text, tables, and images from the PDF files. - Formatting: The extracted data needs to be accurately placed in an organized and understandable format in Excel. - Consistency: As the PDFs are from a consistent source, it's crucial that the freelancer ensures the extraction is consistent across all files. Skills and Experience: - Proficient in PDF data extraction tools and techniques. - Strong familiarity with Excel and ability to organize and format data efficiently. - Attention to detail is key to ensure accurate extraction and consistent formatting. - Pre...
...registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel upload integr...
I need an Android or PC based applica...The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old Quotations: Users should be able to access and make changes to previous quotations. - User Management: The system will need to support 1 admin user with the ability to add unlimited users. The admin should have visibility over all user data. Ideal skills and experience for this project include: - Strong knowledge and experience in Android app development, possibly with PC based development skills as well. - Proficiency in creating apps with offline functionality. - Prior experience in developing quotation, invoicing, and tax receipt systems. - Familiarity with data storage and ...
...preparing for the NEET exam. The primary goal of this course is to equip students with the necessary knowledge and skills to successfully pass the NEET exam. Key requirements for this project include: - Experience in developing educational content for college-level students, preferably in the field of Biology. - A thorough understanding of the NEET exam and its requirements. - Ability to break down complex concepts into easy-to-understand and engaging video lectures. - Good speaking and presentation skills. - Previous experience in creating video lectures, especially for online educational platforms, would be a great advantage. If you think you have what it takes to create a top-notch Biology course aimed at helping college students excel in their NEET exam, I...
I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.
I'm in need of an experienced audio technician, preferably with a background in voice manipulation and sound editing. As per the requirements of my project, I'm attempting to alter my voice recording to emulate that of another person, whom I have vocal samples from. Qualifying candidates should be adept at manipulating aspects such as pitch, tone, and accent to make my voice a convincing replica of the target voice. Key skills and experience: - Proficiency in sound editing - Prior experience with voice alteration tasks Please include the following information in your application: - Examples of past work, preferably including voice alteration projects. Despite the technical requirements being unspecified, proficient knowledge and use of appropriate software are unequivoc...
I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue(&quo...
I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry
I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your b...
...to develop a comprehensive golf course review platform that is akin to IMDb but dedicated exclusively to reviewing golf courses in depth. Key Functionalities: - User registration and login: Enabling members to create and access personal accounts. - Course search and filtering: Letting users perform refined searches based on different criteria. - Course rating and reviews: Providing users an outlet to leave their feedback and ratings on various golfing courses. - Live world and regional leaderboards: Offering up-to-the-minute rankings of the best golf courses worldwide and by regions. - User profiles: Granting users a personal space where they can view and manage their reviews, handicap, location, and golf club membership. Extra Features: - Personalized course...
I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.
I need to create full screen map using nextjs and map...full screen map using nextjs and mapbox The map have to cover full screen When a user click on a point on the map, the application will request a GeoJson dataset of points. Although the GeoJSON requested will be a whole dataset, the application should only display the pins within a 1km radius of the clicked point. Of course, the 1km is not fixed. I need a slider component that the user can change the radius of the circle, instead of 1km fixed. In project, don't use any other material library. You need to use Radix UI for further integration. Because my prev guy said he used headless (I'm not sure) UI. Also, It should be responsive for mobile and tablet.
Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. W...show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel fil...
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
I'm in need of a skilled professional who's proficient in working with the Turvo TMS Rest API for a project that involves its integration....need of a skilled professional who's proficient in working with the Turvo TMS Rest API for a project that involves its integration. The main goal of this project is to leverage the capabilities of the Turvo TMS Rest API to streamline and enhance our shipping processes. Key responsibilities of this role will include: - Working on the setup and authentication of the API - Handling data retrieval and manipulation - Implementing effective error handling and debugging mechanisms If you've got proven experience with the Turvo TMS Rest API and are confident in your ability to help us automate our shipping processes ef...
I'm looking for an expert in SCARA robot manipulation to construct an assembly line. - Robot Task: The SCARA robot will need to accurately perform insertion and dispensing tasks. - Object Specifications: The robot will be working with small objects weighing less than 1 kg. Ideal skills for this project include: - Extensive experience in robotic assembly, specifically using SCARA robots. - Strong understanding of manufacturing processes and assembly line automation. - Expertise in robot programming for precise, small-scale tasks.
The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, but not necessary.
I'm looking to create a WordPress website that will serve as a platform for listing both academic and professional courses. Courses will be paid, offering a revenue stream for the website. Key Requirements: - Wordpress Expertise: I need ...Courses will be paid, offering a revenue stream for the website. Key Requirements: - Wordpress Expertise: I need a professional who is well-versed in WordPress, and can ensure the development of a user-friendly and engaging website that is easy to navigate. - E-commerce Experience: As this website will be offering paid courses, knowledge of e-commerce integration and payment gateways is crucial. - Course Management: The platform needs to support the categorization and easy management of courses, both academic and professional. Similar :
As a frequent Instagram user, I am in need of a skilled photo editor who can make improvements to my personal images. The main tasks involved are: - Cropping and resizing photos to fit Instagram's format - Adjusting brightness and contrast ...who can make improvements to my personal images. The main tasks involved are: - Cropping and resizing photos to fit Instagram's format - Adjusting brightness and contrast to enhance the overall look of the images - color correct images The ideal candidate for this job will have a good eye for detail and be familiar with the Instagram platform. They should also possess strong skills in photo manipulation and an understanding of aesthetic trends among regular Instagram users. A background in personal photography enhancement would be ...
I need a skilled Wordpress expert to address a migration i...the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP, theme and plugin compatibility issues. Your ability to troubleshoot and resolve migration issues will be crucial. I'm looking for a professional who can efficiently tackle this issue and ensure a smooth, seamless t...
...reliable virtual assistant to assist me with a range of tasks. Here's an overview of the key responsibilities and requirements: - Data Entry: The ideal candidate will be comfortable handling medium volume data entry tasks. This may include various forms of data manipulation, collection, and input. - Email Management: You'll be responsible for managing my email inbox. This includes reading, responding, and flagging important messages for my attention. - Appointment Scheduling: The role will also involve coordinating my schedule and setting up appointments. To excel in this role, you should have experience with: - Microsoft Office Suite, including Word, Excel, and PowerPoint. - CRM Software: Knowledge of Customer Relationship Manag...
I'm in need of a skilled Unity developer who can bring to life a 3D visuali...visualization of moving points. The purpose of this visualization is educational, aimed at explaining the concept of trajectory. Key requirements: - The visualization will involve moving points in 3D, following a trajectory that's dictated by data in an Excel file. - The movement of these points should be adjustable by the user in terms of speed. The ideal freelancer for this job would have: - Proficiency in Unity, with a strong background in 3D animations. - Experience in creating educational visualizations. - The ability to integrate data from an Excel file into the Unity project. Please note that while the visualization is primarily educational, it should also be visu...
...beyond Shopify's default settings, pushing the boundaries of the platform. Here's what we need: Shopify Expertise: In-depth understanding of Shopify's file structure, directories, and templating system (Liquid). Experience manipulating orders, grabbing data from the database, and crafting custom views using Liquid shortcodes. Proven ability to develop custom Shopify plugins to achieve complex functionalities. Technical Skills: Proficiency in Shopify development languages (Liquid, JavaScript, HTML, CSS). Experience with database manipulation (likely MySQL). Communication & Collaboration: Excellent written and verbal communication skills in English. Ability to clearly explain technical concepts to non-technical stakeholders. Comfortable participating ...
...Your primary responsibility will be to carry out intensive product research, which will position my e-commerce business to take full advantage of market trends and competitive landscape. Your tasks will include: - Intensive product research on Amazon Even though you won't be analysing pricing trends, competitor analysis and customer reviews, you may need to delve into these aspects during the course of your work. Therefore, familiarity with these areas will be an added advantage. I anticipate that I'll need your services for more than 20 hours per week, therefore the ability to dedicate that amount of time weekly is crucial. Successful candidate should have excellent research abilities and a comprehensive understanding of the Amazon platform. If you are detail-or...
...assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting...
I have a fairly complex Autohotkey script that customizes the behavior of an application. This script involves some advanced functions like Windows API calls and file manipulations, and I need it to be converted to C# code. The C# application doesn't need to have a GUI, it only needs to replicate the functionality of the Autohotkey script. API used - Ge...advanced Autohotkey script that customizes application behavior to C# code - Ensure the C# code replicates the original Autohotkey script's functionality - No GUI is required in the C# application Ideal skills and experience for this job: - Proficient in both Autohotkey and C# - Experience in converting complex scripts between different programming languages - Familiarity with Windows API and file manipulation in bo...
Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination of commissions, hence accuracy and precis...
Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamlessly integrates...
I am looking for a skilled developer to create a system that can manage and sell chatbots with AI. Th...update, and manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms like Facebook, Instagram, or WhatsApp. It should be easily configurable for clients and capable of pulling data from databases, Excel, or Google Sheets. Ideal candidates for this project should have a strong background in software development, particularly in AI and chatbot technology. The ability to create a user-friendly interface is crucial, as the goal is to make the system accessible to a wid...
