Operations columns excel filesงาน
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'm looking for a skilled developer to help create a custom content management system for my website. Key Requirements: - **Purpose:** The main g...this system is to manage content effectively on my website. - **Primary Users:** The system should be designed for use by the general public. This means it should be user-friendly and intuitive, to cater to a wide range of users. Key Features: - **Automated E-invoicing:** The system should include a function that can automatically issue e-invoices. This is a critical feature for my business operations. Ideal Skills & Experience: - Experience with developing content management systems, particularly for a wide user base. - Proficiency in e-invoicing systems and related technologies. - Strong attention to detail and a solutio...
...aims to provide insights into the logistics and business operations of several industries including Healthcare, Retail, Manufacturing, and Education. Key Tasks: - Data Cleaning and Preprocessing: Efficiently handle large datasets in multiple languages for optimal data quality. - Descriptive Analytics and Reporting: Create insightful reports on the logistics and business data in a clear, concise and actionable manner. - Predictive Modeling and Forecasting: Utilize predictive analytics to forecast future trends and make informed strategic decisions. Ideal Candidate: The ideal candidate should possess: - Proven experience in data analysis, particularly in a multilingual context - Strong understanding of logistics and business operations - Proficiency in English, Spanish, an...
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
I'm on the lookout for an expert who is incredibly adept and experienced in Microsoft SharePoint and particularly MS Viva suites. The need is to improvise and enhance a few specific functions which include: - Document Management: However, it remains undecided whether the structure would be folder-based or metadata-based tagging...coordination. Moreover, a fundamental task would be to automate workflows to increase operational efficiency. The ideal candidate would be someone equipped with a scrupulous understanding of MS SharePoint, a knack to understand workflow design, automation, and proficient in using tools for document sharing, handling team calendars, and discussion boards. Your task would be to streamline all these operations to create an efficient and collaborative wo...
I am seeking an experienced Python Django developer t...of the back-end work for a web application intended for specific industry professionals. The required functionalities include: - User authentication and registration: Candidates should have experience implementing secure user authentication and registration systems. - Database integration and management: We need someone with proficiency in integrating and managing databases, ensuring smooth operations for user data handling. - API Integration: Expert skills in API integration are required to establish seamless communication between applications. Your primary goal is to build a strong, reliable backend for our professional web app. We need an expert who can ensure excellent function and optimal performance. Looking forward to ...
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
...Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amounts: Report on outstanding customer balances. o Receipts: Report on customer receipts. o Sales and Payments Reports: Generate detailed reports on customer sales and payments. Compatibility • The dashboard must be accessible via: o Web browsers (Chrome, Firefox, Safari, Edge) o Mobile devices (responsive ...
I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all informati...
**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and the othe...
...Advertising: Ideas for campaigns that promote my services to a broader or more targeted audience. - Operations and Project Management: Optimization of business processes that can handle larger workloads smoothly. - Client Acquisition and Relationship Management: Strategies for attracting and maintaining profitable relationships with residential, commercial, and industrial clients. My current methods for securing projects consist of word-of-mouth referrals, utilizing online platforms or directories, and direct outreach programs like cold calling. Ideal candidates should have a strong marketing background with a focus in the electrical contracting industry, a solid understanding of operations and project management in the trade business, and proven strategies for client ...
I am in need of a proficient Salesforce Marketing Cloud expert, specifically experienced in crafting effective email marketing campaigns, customer journey mapping, and data segmentation. My primary objective is to understand the best practices, which can bolster my current strategies and efficiencies in my business operations. Key Responsibilities: - Assisting me in designing email marketing processes from scratch. - Guiding through Salesforce features, concerning email marketing campaigns, journey mapping, and data segmentation. Ideal Skills: - Extensive knowledge and experience in Salesforce Marketing Cloud. - Proven expertise in email marketing processes and strategies. - Strong knowledge of data segmentation and journey mapping. Overall, my aim is to leverage Salesforce to dr...
Create a Google Sheets system for managing alcohol inventory. Includes columns for Brand, Name, Number of bottles, Country, Rating. Dropdown for rating (1-10). Show stats: unique bottles, total bottles, countries. whit a front page where i can insert the above items, and get under a reading of stats.
I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not on...
I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.
I have a 120MB JSON file with nested objects, and I am in need of a skilled professional ...file with nested objects, and I am in need of a skilled professional who can convert this data into a CSV format. Specifically, I require the following: - The nested JSON objects should be flattened into single columns in the CSV. - The column headers in the CSV should match the keys in the JSON file. The ideal candidate for this job should have: - Proficiency in handling JSON and CSV data structures. - Experience in working with nested JSON objects and flattening them. - Ability to accurately map JSON keys to CSV column headers. If you've successfully converted complex JSON files into CSVs before and you're confident in your ability to deliver clean, well-structured data,...
As a company in the technology sector, we are looking to expand our operations into the US and Mexico markets. Our primary goal for this project is to attract investors who can support our international growth. Key Objectives: - Develop detailed financial projections: We need a professional who can create a comprehensive and realistic financial model that incorporates various elements such as revenue streams, costs, and growth potential. - Design Go-to-Market Strategy: This will involve formulating a detailed plan on how we can enter and penetrate the US and Mexican markets, highlighting key milestones and tactics. Requirements: - Expertise in Financial Modeling: Demonstrated experience in developing financial projections, especially for technology companies targeting internationa...
I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attention to d...
We are currently experiencing significant performance issues with our Oracle database under heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for database management and optimization -...
I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even i...
...additional features that are essential for improving our business operations and customer experience. Key Features: - **Customer Loyalty Program Integration:** I want this app to seamlessly integrate with our customer loyalty program. This will help us retain existing customers and attract new ones. - **Employee Management:** The app should allow our staff to easily manage transactions, track their sales, and communicate with customers through the app. - **Songs Queue Requests:** It is important that the app allows our staff to manually select songs for playback from a queue of requests. Ideal Skills and Experience: - Proficiency in iOS app development, particularly for iPad - Strong understanding of POS systems and nightclub operations - Experience in integrating custo...
...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Excel a...
I'm looking to develop a new website for my Non-Governmental Organization. Primarily, the website will serve as a platform to share resources and information about our work with the public. The essential features for the website include: - A homepage to showcase our NGO's mission and purpose - Along with Home PAge we want pages like Our Team, Events, Blogs, Join Us, etc....pages like Our Team, Events, Blogs, Join Us, etc. Ideal Skills & Experience: - Strong understanding and experience in website development - Knowledge about non-profit organizations or NGO's is an advantage - Design skills to make the website engaging and user-friendly - Ability to develop a secure website to protect the information shared - High attention to detail to accurately portray our ...
I am in need of a virtual dispatcher and customer service agent who can handle inquiries and coordinate logistics for my business. The ideal candidate should be able to work for 20-40 hours per week. Responsibilities: - Handling customer inquiries promptly and efficiently - Coordinating logistics and ensuring smooth operations Skills and Experience: - Excellent communication skills and customer service experience - Strong organizational and problem-solving abilities - Knowledge of logistics and ability to coordinate schedules - Proficiency in using virtual communication tools and platforms This is a great opportunity for someone who enjoys providing excellent customer service and has a knack for coordinating logistics. If you meet the requirements and are able to commit 20-40 ho...
I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and meticulousness a...
...experienced C++ developer to create an effective Parallel File System based on the Google File System (GFS) - a system we'd like to dub as miniGFS. This project seeks to achieve: - Efficient storage and access of large files: The miniGFS should handle large data quantities seamlessly, allowing both read and write operations swiftly. - Data replication and fault tolerance: This project prioritizes data integrity and availability, necessitating a system designed for data replication and recovery in the occurrence of a fault. - Parallel processing: Optimum speed during file operations can be achieved through parallel processing functionality and the miniGFS should capitalize on this. - Data distribution across multiple nodes: To ensure efficient space use and...
I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.
I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
As someone running a busy marketing agency specializing in the home improvement sector, I need a proficient appointment setter. They'll be key to my operations, handling below tasks: - Cold Calling potential clients - Setting up appointments with qualified leads - Following up with these leads to schedule appointments. I'm looking for someone to work less than 10 hours per week. The ideal candidate will demonstrate excellent communication skills. Experience in appointment setting will make them stand out. They'll be handling a sensitive part of my business, so their communication skills will be vital. Previous experience in the home improvement niche is a bonus but not necessary.
...relevant laws and regulations in North America. Key Requirements: - I want the company to focus on payment processing. - The software must include a mobile-friendly design to cater to the increasing mobile transaction trend. - The payment gateway should be integrated into the system to provide a seamless, secure transaction experience. - An inventory management system is also crucial for our operations. Ideal Skills and Experience: - Proven experience in designing and developing payment processing systems. - In-depth knowledge and understanding of North American regulations and compliance requirements. - Strong background in creating mobile-friendly designs. - Expertise in integrating secure and efficient payment gateways. - Prior experience in implementing and managing invento...
I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. The o...
