Teach word excelงาน
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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
2 document to Translate from English to Thai 1. 930 word 2. 717 word ไฟล์ส่งให้อีกทีนะคะ
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Job Title: Copywriter Needed for Transcribing Storybook into Word Document Description: We are seeking a skilled copywriter to transcribe a storybook into a Word document. The job involves typing out the entire content of a storybook into a digital format. The storybook is approximately 100 pages long and contains a mix of text and illustrations. Responsibilities: - Type out the entire content of the storybook into a Word document. - Ensure accurate transcription of text, including proper formatting and punctuation. - Maintain consistency with the original text and illustrations. - Complete the task within the specified deadline of 1 day. Requirements: - Proficiency in English language and grammar. - Excellent typing speed and accuracy. - Experience in copywriting o...
I'm seeking a professional to convert my PDF file into a Word document. Key Requirements: - The final output should be a fully editable Word file. - It's crucial that the text conversion is accurate, with no room for errors. - While the text itself is of utmost importance, an identical formatting to the original PDF is not necessary. Ideal Skills and Experience: - Proficiency in PDF to Word conversion. - Attention to detail to ensure accurate text transfer. - Strong grasp of English to maintain the text's original meaning and structure. - Ability to maintain a professional and consistent format in the Word document. Please provide your relevant experience and a quote for this project.
I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...
I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I woul...
I'm seeking a freelancer who can convert PDF files to Word documents. The primary aim of this project is to enable me to edit the content within the Word documents. Key Requirements: - Conversion needs to retain images: I want the images within the PDF to be included in the Word document exactly as they are in the original PDF. - Formatting: I need the Word document to match the PDF as closely as possible. I'm looking for an experienced individual with strong attention to detail and exceptional skills in PDF to Word conversion. The ideal candidate should also be proficient in managing images within documents and maintaining accurate formatting. A demonstrable history of completing similar tasks with precision is highly desirable. Looking ...
I have several PDF files in English that I need to be converted into Word files. I want the Word files to have the exact formatting as the PDFs. Ideal Skills and Experience: - Proficiency in English - Expertise in PDF to Word conversion - Attention to detail to ensure accurate formatting transfer - Experience in working with various document types.
I'm seeking a professional to convert my PDF file into a Word document. Key Requirements: - The final output should be a fully editable Word file. - It's crucial that the text conversion is accurate, with no room for errors. - While the text itself is of utmost importance, an identical formatting to the original PDF is not necessary. Ideal Skills and Experience: - Proficiency in PDF to Word conversion. - Attention to detail to ensure accurate text transfer. - Strong grasp of English to maintain the text's original meaning and structure. - Ability to maintain a professional and consistent format in the Word document. Please provide your relevant experience and a quote for this project.
I need a freelancer who can convert my PDF files into editable Word documents. These are mainly text documents that require basic formatting. Key Requirements: - Ensure that the content is accurately transcribed from PDF to Word - Preserve the original formatting of the text, but no need to replicate complex layouts - Comply with my instructions for the basic formatting and text focus - If applicable, include any images or tables that are present in the PDF documents The ideal candidate should be proficient in using Microsoft Word and Adobe Acrobat, and have experience with document conversion projects. Accuracy and attention to detail are crucial for this task.
I have a set of handwritten documents that I need to be typed up in a Word document. The data is not complex and is mostly text with a few tables and bullet points. Key Requirements: - Typing handwritten text into a Word document. - Ensuring the text is accurate and complete. - No need for any data analysis or interpretation, just straightforward transcription. Ideal Skills and Experience: - Proficiency in typing and experience with data entry. - Attention to detail to ensure all content is accurately transcribed. - Familiarity with Word processing to deliver the final documents in a clean and professional format. I'm not looking for any specific formatting, just a clean and legible Word document with the content from the handwritten documents. The budge...
necesito un Software punto de venta con estas caracteristicas Especificaciones • Software de escritorio • Base de datos mariadb • Control de Licencias de manera remota con servidor • Demo de presentación • Grabado de videos de su desarrollo paso a paso Menú principal • En forma de pestañas • iconos e...teléfono 6. Correo 7. Sitio web 8. País 9. Departamento 10. Ciudad 11. Creador de moneda 12. Logo foto 13. Facturas tamaño carta y recibo 14. Creación de formas de pago 15. Creador de impuesto porcentaje de uso RESPALDO DE BASE DE DATOS 1. Respaldo de base de datos manual 2. Respaldo de base de datos al cerrar programa Configuración 1. Subida y bajada de productos de forma masiva con tablas de ...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm looking for a professional who can create job ad templates for me in both Word and PDF formats. 6 ads to copy paste to 6 templates I can share few samples you can use the same to design. All contents, logos, images & similar editable formats will be shared. Will award for the lowest price with reviews.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I require a skilled designer to create a professional datasheet in Word. The datasheet will be an essential marketing tool for our business, so it needs to be both visually appealing and easy to comprehend. Key Requirements: - The design should be Corporate, aligning with our brand identity. - The specification content that I'll provide must be effectively incorporated and highlighted in the design. - You'll need to source stock photos or graphics that complement the overall look of the datasheet. Ideal Skills: - Proficiency in Word, and experience in creating professional documents. - Strong design skills, especially in a corporate context. - Ability to source and incorporate suitable stock photos. - Good communication to understand and deliver on our specificat...
I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
I require assistance in converting a variety of file types including Word, Excel, and PowerPoint files, into PDF format. Here are some specifics about what I need: - I need the original formatting from the source files to be preserved during the conversion process. This will ensure that the PDF versions closely resemble the original documents, without any loss of visual integrity. - The files for conversion will be provided via a cloud storage link, such as Google Drive or Dropbox. I expect the freelancer to be proficient in accessing and handling files from these platforms. Ideal candidates for this project should have: - Proficient experience in converting different file types (e.g. Word, Excel, PowerPoint) into PDF format. - Strong attention to detail to en...
I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I should ...
We have a 6,000 word copyediting task available for native, US based teams. The SME is financial/medical and we are hoping to have this project completed by 5/8/24 and will be completed in our online CAT tool. If you have an interest in this project, please reach out and let us know and we will be in contact with more details. Thank you!
...need of an expert in ASP.NET Core 8, visual studio 2022, and ChatGPT 4 for a unique project. I require a tool/webpage that can seamlessly re-write chapters of my book for me. My book has 25 chapters. Each chapter contains between 10 and 30-pages. Each chapter is written in MS Word (.docx) document and must be converted into FORMAL and PROFESSIONAL-style content. This project requires the following key features: - **Input & Output Format**: - The system must take a Word document as input. - The output should be a Word document while preserving all the original formatting. - **Language Support**: - The tool should be able to rewrite the document in both English and Spanish. - **ChatGPT Version**: - I prefer the latest ChatGPT 4 for the rewriting task...
I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.
...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement adv...
I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This project requires a meticulou...
...file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is to transfer data,...
I am in need of a skilled professional who can assist me in setting up th...creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requirements...
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...
Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...
I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...
...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...
I'm looking for a skilled writer to craft 20 engaging, 100-word paragraphs . The topic of the paragraphs is yet to be determined, as I'm open to suggestions, but should be suitable for a general audience. Ideal skills and experience: - Proven experience in creative writing - Ability to write engaging, concise 100-word paragraphs - Versatile writing style that can adapt to different topics - Understanding of how to tailor content for a general audience
I'm a highly fluent speaker of Chinese, but I lack the ability to read and write the language. I'm seeking a skilled private tutor who can help me bridge this gap and teach me how to read Simplified Chinese. Ideal Skills and Experience: - Proven experience in teaching Chinese, ideally to non-native speakers - Ability to assess my current language skills and design a tailored learning plan to improve my reading proficiency - Patience and good communication skills to guide me through the learning process - Knowledge of Simplified Chinese script - Understanding of how to structure lessons for effective learning The successful candidate should be able to provide a structured and engaging learning experience to help me achieve my goal of reading and writing in Chinese - my ma...
I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.
