Convert xls to xlsm excel 2010งาน
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
More details: Which version of Excel are you using? Excel 2016 What type of data processing do you need? Data sorting, Data filtering What specific criteria will you use for sorting the data? Numerical order It is required to set up a script that will process an Excel file every day, filter the file according to an algorithm and leave the necessary data in the file.
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I need a skilled and experienced transcriber to convert a live recording of pop music into sheet music for my personal study. This initiative requires: - Proficiency in transcribing live recordings to written format - Familiarity with pop music genre to capture unique elements accurately - Ability to complete the task timely without compromising quality. I don't have an ear for music but play piano and guitar. Bruce Springsteen, from his Broadway recording, performs a piano version of "My Hometown" and I'd like to learn it, but don't have the sheet music.
I need a data entry specialist to help me with a simple task of entering data into spreadsheets. Ideal Skills and Experience: - Proficient in data entry, specifically into spreadsheets, with a keen eye for detail - Experience working with Excel or similar tools - Ability to maintain accuracy and meet deadlines - Good communication skills and reliability Looking forward to working with a professional who can complete the task efficiently and accurately.
I require a skilled translator to convert a Settlement Agreements from English to Arabic. The written agreements are between 10-20 pages long. Ideal Skills: - Mastery of English and Arabic languages, both written and spoken - Prior experience in translating legal documents Experience Required: - Understanding of legal terminology is essential, as the document includes specialized legal jargon. A precise and accurate translation is of utmost importance for this task. I look forward to working with a professional translator who can fulfill these requirements.
I have been doing online business for more than five years. The 2023 revenue is $4.5 millions. I'm on the hunt for a professional high ticket sales closer with an in-depth understanding of the e-commerce industry. I'm launching an online school focusing on teaching individuals how to build successful multi-million-dollar e-commerce businesses. My target audience is motivated individuals eager to learn the e-commerce ropes and willing to invest in high-level education. Key Responsibilities: - Convert interested prospects into students - Possess persuasive consulting services skills - Foster relationships with potential clients Ideal Skills and Experience: - In-depth knowledge of the e-commerce industry - Proven track record in high ticket sales -...
I seek guidance from an experienced ecommerce consultant to establish my first online store. Your expertise is desired to direct me through each step of setting up the storefront, from selecting a suitable platform to designing an aesthetically pleasing and fully functional website. Your skills are needed to configure the backend and optimize the front end experience for customers. It is also important to me that the site is built with search engine optimization top of mind. Proper implementation of SEO best practices during the development phase, such as appropriate metadata, hyperlinks and responsive design, will help ensure our products are easily discoverable online from launch. User experience must be smooth across all devices. Your guidance on prici...
In this project, I need a freelancer who can meticulously manage data entry tasks. Ideal Skills: - Strong data entry skills, specifically with text data. - Advanced knowledge of Excel and data management within it. - Ability to understand and follow custom data organization instructions. Job Summary: - Enter text data into Excel format, understanding the importance of accuracy. - The data must be organized in a specific, custom order that I will provide. - Experience in similar jobs and a keen eye for detail will be highly beneficial.
I have a PDF document that I need converted to a Word document. After the conversion, I'll need you to add three pages of purely textual content to the document. Additionally, I want you to create a petition document for signatures. The petition should be designed for manual signing, not digital. Key Responsibilities: - Convert a PDF document into a Word document. - Add three textual pages to the converted document. - Create a petition document for manual signatures. Ideal Freelancer: - Should have experience with document conversion and editing. - Ability to design a petition document. - Familiarity with creating documents for manual signatures. - Good communication skills to ensure the job satisfies my requirements.
I'm in urgent need of a skilled content writer who possesses strong proficiencies in Microsoft Excel. The primary task will involve generating written material for my organization, with an additional responsibility requiring accurate invoice creation. Your responsibilities in detail: - Generate compelling content that aligns with my organization's goals and objectives. - You would also be responsible for creating invoices using Microsoft Excel. Ideal qualifications and skills: - A strong grasp of the English language with excellent writing skills. - Prior experience with content writing and invoice creation. - Expert understanding of Microsoft Excel, particularly when it pertains to invoice creation.
I'm aiming to build out and boost sales on my Payhip site by enhancing its online visibility and attracting more persons to the platform. The primary goal is to increase traffic and generate leads that eventually convert into sales. Key Points: - The main objective is to enhance sales on my Payhip site, which is why I need a proficient and experienced SEO specialist who can help me achieve this goal. - I am specifically interested in leveraging SEO to drive traffic, boost leads, and increase sales. - The target demographic for this project is 18-65. Hence, the successful freelancer will need to be familiar with marketing strategies that cater to this particular audience. Ideal Skills and Experience: - Proven track record in ...
...objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024inv...
...pay bc I am required to list that, skip to the end for compensation information. I am looking for a skilled developer who can convert my existing website to a web3 platform. You’ll also be required to design and develop a professional, user-friendly decentralized app (dapp) that mirrors the functionality and aesthetics of the original site as closely as possible. This app will aim to be hosted on the Pi Network Blockchain and must be functional and flow as they will Do manual checks and demo the app in the process of checking functionality Key Project Highlights: - This dapp will come with a few specific functionalities such as user registration and login, payment processing and also payment privacy capability - the user wallet withi...
...that can’t convert to sales. Key Deliverables: - Strategies to effectively use Instagram for marketing. - reach and attract Targeting audience on instagram page - Run ads - Reach more genuine and compatible clients Ideal Skills and Experience: - Extensive experience in SEO and social media marketing. - Proven track record in using Instagram for marketing. - Understanding of Clients demands. - Marketing to attract people all over the world. - use all the strategies that helps to reach the most targeted interested people. The ultimate goal is to establish a strong online presence that resonates with more particular and interested audience and keeps them engaged. This project requires a combination of technical, marketing and creative sk...
...generation using AI. Your expertise will contribute to a cutting-edge project that combines music generation with voice cloning to create songs sing by virtual persons. We want our app to have the following features. - Create unique music based on user input information (speed, type, length...). - Create music based on the voice provided by the user - Change the voice of music provided by the user to the voice provided by the user Frontend is already done. The model we want must be able to perform two large functions. 1. Generate a song based on the text entered by the user using the sample voice selected by the user. 2. Converts the voice of the song uploaded by the user to the voice selected by the user. To achieve this, the deve...
I'm in need of a professional who ...professional who can remove FairPlay DRM from an Apple iBook and convert them to ePub format. Key Requirements: - Remove FairPlay DRM: I have only one Apple iBook that are locked by FairPlay DRM. I need these files to be stripped of this DRM while preserving the book content intact. - Conversion to ePub: The final format I require for these files is ePub. The files should maintain their original quality and formatting post conversion. Ideal Skills and Experience: - Prior experience working with FairPlay DRM removal is highly preferred - Proficiency in converting files to ePub format - Attention to detail to ensure that the book content isn't altered during the process Please reach out if you...
I'm seeking a skilled developer to help create a professional real estate website with integrated CRM capabilities. Key Requirements: - Website to primarily focus on showcasing real estate listings. It should be visually appealing, user-friendly, and easily navigable. - Integrated CRM system to manage and track leads effectively. This system is crucial for our business to convert leads into sales. - The CRM should include sales pipeline management functionality, allowing for easy tracking of prospects through the sales cycle. Ideal Skills & Experience: - Proficiency in web development, with a strong portfolio of real estate websites. - Expertise in CRM integration, particularly with sales pipeline management. - Experience in building lead gener...
...detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - E...
Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. Looking forward to you...
...require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for managing and sending out newsletters. - Strong understanding of the freelance industry and the needs of experienced freelancers. This is a long-term project, so I'm looking for a freelancer who can...
I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas acr...
I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands ...license renewal costs. As someone who understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my f...
As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality
is New York based Ecommerce company involved in processing of online print orders since 2010. Key Responsibilities - We are looking for AWS Linux Web Administrator to set up new and modify the existing AWS EC2 instance running Laravel application on Bitnami LAMP stack. Set up new dev server on AWS or Digital Ocean. Skills and Experience: - Minimum 3 years verifiable experience as Linux Web Administrator in creating and managing existing and new LAMP EC2 instance. Laravel application hosting experience preferred. Duration: Permanent: assignment and based on completed work items
As the client, I am search of a seasoned virtual assistant to support me during typical work hours, 9am to 5pm (UTC +1). The ideal candidate will possess the following expertise: CRM MANAGEMENT: Monitor and manage follow-ups and sales activities within the CRM. Update and maintain accurate records of customer interactions and sales leads. Assist in developing strategies to improve CRM processes and efficiency. Customer Service: Respond to customer inquiries and resolve issues promptly and professionally. Maintain a high level of customer satisfaction through effective communication and problem-solving skills. Liaise with other departments to ensure customer needs are met. Email Management: Monitor and manage the CEO's email inbox, prioritizing and...
I'm urgently needing a skilled graphic designer to convert my existing EPS file into both a Corel file and a PDF file that can be opened in Corel. See the critical details below: - The final files must maintain all the existing layers of the EPS file. - The Corel and PDF files must allow full text editing. - The project needs to be completed ASAP due to urgent demands. Ideal skills for this job include familiarity with Corel, Adobe Acrobat and Illustrator, experience with graphic file conversion, and a strong understanding of preserving layers and text editing capabilities during the conversion process. Your quick response is appreciated. Please only apply if you can meet the tight timeline.
I have a simple design in Corel Draw and need it converted to Illustrator. This includes adding a cutline around the design. - I have two designs. Very, very simple. One is the tree. The other is 400 leaves that need to be cut. - The primary task is to convert the entire design from Corel Draw to Illustrator format. - The secondary task is to add a cutline around the design. This will serve as guidelines for future cutting of the file. - You will be required to work with precision, as the cutline needs to be accurate and well-aligned with the design. - Experience with both Corel Draw and Illustrator is essential. Ideal Skills and Experience: - Proficiency in Corel Draw and Illustrator. - Attention to detail for precise cut...
I'm seeking a highly skilled digital advertising contractor to manage and drive a targeted campaign on social media and via email marketing. The successful applicant should have: - A proven track record in digital advertising, specifically in social media platforms and email marketing. - An understanding and ability to successfully target business professionals. - Tactical skills at creating and managing effective, results-driven advertising campaigns. This job is ideal for professionals who are adept at developing captivating advertising campaigns that resonate with a business-focused audience. They should also excel in consumer profiling and targeted content presentation. I look forward to hearing from you!
I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus
...a vodka brand, Lugiavodka.com. To reach a billion-dollar valuation, a startup needs members who are experts in their fields, creating a strong chain where SEO is a crucial link. Criteria: Expert in SEO with solid, proven experience. Ability to develop and implement effective SEO strategies. In-depth knowledge of current market trends and best practices in SEO. Analytical skills to track and improve SEO performance. Excellent communication and collaboration skills. Your Responsibilities: Analyze and optimize our website to improve search engine rankings. Develop SEO content strategies to attract and convert visitors. Work closely with our marketing team to align SEO efforts with our overall goals. Contact Us! We are eager to disco...
I'm looking for a skilled Python developer who can create a tool that can convert VCE (Visual CertExam) files to PDF. The script needs to be compatible with Windows, and ideally, it should: - Provide output in a format that is both viewable and editable - Operate solely via a command line interface Ideal applicants will have experience in Python programming, data manipulation, and an understanding of file conversion processes. A background in creating command line tools is a plus. Your experience in delivering clean, efficient code is highly valued. Please provide examples of previous work when applying. I'm on a tight budget ($10 - $15)
