Excel vba accounting formatงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถ 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 ที่กำหนดให้
Write a contract แปลสัญญาต่างทางธุรกรรมกฏหมาย เช่น สัญญากู้ สัญญาซื้อขาย ค้ำประกัน จำนอง จำนำ ครับ
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
ต้องการด่วน คนที่เข้ามาปิดบัญชีและเรื่องการเงินของบริษัท ด่วนที่สุด สามารถปิดจ้อบงานได้ภายใน 7 วัน ติดต่อ ด่วน URGENT !!!! NEED data entry support for journal entry to close month End accounting statements within 7 days.
I would like the assistant to do research about accounting services provided by the accounting offices in Thailand. I would like only Thai person since you have to search information in Thai. From the attached file, I would like you to search website of these accounting offices and provide me the information about their services e.g. the list of services provided by these offices, service rates. I would like you to prepare in in structure manner that I will provide template later. Freelancer who has an accounting background would be advantage.
ต้องการคนที่เข้าใจและสามารถแนะนำวิธีการใช้ โปรแกรม xero accounting softwar และมีความรู้เกี่ยวกับระบบบัญชีในประเทศไทย
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Need an accountant who can use Xero accounting program and can help reconcile and tax. Monthly pay between 600-900USD for the right person. ใช้ xero program ได้เปนอย่างดี กระทบยอดบัญชีได้ทุกหมวด ปิดงบการเงิน ต้นทุน
I have 5 voice files in Thai that I needed translated in the format given below. I : น้องเคยค้นหาแอคเคาท์ใครในออนไลน์ป่ะ อย่างเฟซบุค Have you ever try to look for someone or search for an account online? Or in Facebook S : เคย Yes I : เหมือนฉันชอบคนนี้ ฉันไปตามล่าหา If I like this person I would look for him/her. S : โอ้ย เอาทุกสเต็ปเลย โพสต์รูปอะไรเซฟมาให้หมด Everything from posting to taking picture. S2 : โมเม้นต์นี้ เคยครับ คือคนที่เราอยากจะรู้จักใช่มั้ยครับคนที่เราแอบชอบนั่นแหละ เราจะคอยส่องเฟซเค้า ไปดู If i like that person i would peek at her Facebook. I : ไปแอดเค้ามั้ย Did you add her? S2 : เป็นเพื่อนกันอยู่แล้ว ก็ดูว่าเค้าลงรูปอะไรมั่ง กดไลค์ให้เค้า นั่งดูภาพเค้าอยู่คนเดียวอะไรอย่างงี้ We are already friend. Most of the time just likes and ...
...attempt in Odoo (only the first time). Upon successful validation, update the user's password in Odoo using the standard Odoo password hashing method. Ensure compatibility and seamless integration between Magento 1.9 and Odoo 16 CE. Provide documentation and support for the developed module. Note well: Magento customers are already loaded into Odoo. Magento passwords can be stored in an encrypted format in a new field in Odoo for the initial login check and subsequently deleted for security reasons. We aim to grant portal access to Magento customers without requiring them to receive invitation emails to create a user account. The ideal candidate for this project should possess: Expertise in Magento 1.9 and Odoo 16 CE, with a strong understanding of their respective archit...
...requirements for the project are as follows: - The template should accommodate between 5 and 10 pages. - It will be for a store featuring physical goods. - I would like a landing page similar to this below, including a rolling banner For you to know this is a current website with products already on offer, they will need to be adapted to fit in with the new format. - I require functionality on my product pages, including: - Customer review features - Size/color selection options - Product videos - Selection based on product type (e.g. red, black, blue) The ideal candidate for this project has a solid experience in Shopify development and a keen eye for detail. A strong understanding of the platform and its functions is a must, as are
I require a skilled professional to meticulously edit and proofread my undergraduate academic paper. Key Responsibilities: - Thoroughly proofread the document, ensuring it is free of spelling, grammar, and punctuation errors. - Edit for clarity, coherence, and flow, to ensure the paper is a seamless and engaging read. - Ensure adherence to the required academic writing style and format. Ideal Candidate: - Proven experience in editing and proofreading academic papers, particularly at the undergraduate level. - Strong understanding of academic writing conventions and the ability to maintain the paper's academic integrity. - Excellent attention to detail and a keen eye for errors. Please submit a proposal detailing your relevant experience and approach to this project.
My requirements for this project are to create a food label designed for adults and seniors. The design must encompass the following requirements: - The food label must be compelling, clean, and easy to read and under...Nutritional Facts, Allergen Information, and Ingredient list as per regulations, in an uncluttered yet comprehensive way. - Must design with the understanding that the target audience are adults and seniors. Ideal skills for this project include, but are not limited to, previous experience designing food labels and a mastery in being able to visually communicate information in a concise and easy-to-read format. Knowledge of regulatory requirements for food labels is also a plus. Creativity to achieve an engaging design tailored for adults and seniors is of utmost i...
I have an original album cover in SVG format that was used for the song "Inside Out". This June a remix of the same song will be released. The idea is to give the current album cover a fresh, modern and professional touch. It will also be necessary to add "Twilight Remix" to the title (side note: the full name of the release will be "Ge & Luke - Inside Out (Twilight Remix)"). Feel free to experiment with the current cover (you can change the color scheme, change some design elements, change the typography). The overall style should lean towards a minimalist design, staying clear, crisp and visually impactful. However, the design of the old album cover should still be recognizable. The ideal freelancer should have - Proficiency with design tools ...
I NEED TO JOB READ Pl...i need to find freelancering job I am Professional and i can do your work goodly im new in freelancer As a photo and videographer with 18 years of experience, I have extensive knowledge of camera settings, lighting techniques, and composition principles. I am proficient in software programs such as Photoshop, Premiere, Davinci, and Lightroom for editing and color grading. I am creative and excel at coming up with unique ideas, and I love working with clients to understand their needs and bring their ideas to life. Communication is key to my work, and I am committed to providing excellent customer service and ensuring that my clients are completely satisfied. I am also highly skilled at time management and always deliver high-quality work on time and with...
For my Google Business listing, I'm seeking a professional who can proficiently incorporate a phone number to foster better communication with our customers. The key requirements for this job are as follows: - Knowledge and experience with Google Business listings. - Ability to add a phone number using the local format. - Proficiency in editing and curating business descriptions. The addition of the phone number to the Google Business listing will offer a more straightforward point of contact for our customers, hence improving our customer service. Alongside this, I need the description of our services to be updated as well, thus enhancing the detail and clarity of what we offer. Please apply if you're well-versed in the functionalities of Google Business and be ready t...
Hi Freelancers, I have up to 30 Stock videos I need for a non-profit Docuseries, and I’m looking to work with someone who can do the following: 1. Download videos in HD quality from various links provided, and AI remove any w?️terⓂ️arks. 2. Crop to vertical 9:16 phone size, based on the guides I provide you. 3. Provide final files in HD, full res format for me to use accordingly. I’m willing to pay up to $7.50 per video, totaling $225 for 30, and paid in milestones per file over time. This should be easy work for a freelancer with experience in this particular area, as I had a sample done in less 10 mins earlier. Let me know if you can help. Regards, Dallas.
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.
For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets. This analyst should prioritize accuracy, prec...
I am in need of a JavaFX expert to help me create a data visualization application. The main aim of the application is to visualize data in a graphical format. Key Requirements: - The application must be compatible with Windows - The main function of the application should be data visualization - The data visualization should include the ability to paste array lists Ideal Skills and Experience: - Proficient in Java and JavaFX - Strong understanding of data visualization techniques - Experience with creating GUIs in Java - Knowledge of array handling in Java Please note that the primary task is to create a JavaFX application to visualize data and allow for front-end pasting of array lists. Your experience in these areas will be crucial for the successful completion of this projec...
...need of an experienced SEO specialist to enhance the online presence of my 4 accounting websites. My main goal is to increase the traffic to these websites. Key Responsibilities: - Conduct a comprehensive keyword research: Identify the most relevant and high-traffic keywords for the accounting industry. - Implement effective on-page and off-page SEO techniques: Optimize the websites' content, meta tags, and backlinks to enhance search engine rankings and attract more organic traffic. - Monitor traffic and analytics: Regularly track and analyze website traffic to evaluate the success of the implemented SEO strategies and make necessary adjustments. Ideal Skills and Experience: - Proven experience in SEO for accounting and financial websites. - Extensive know...
I need a professional to scrape specific...professional to scrape specific details from a website directory for a one-time project. - Specifics: The data of interest includes the company names, their URLs, and their expertise. This information is laid out in rows on the website. - I wish for the freelancer to carefully extract this data, ensuring no errors or omissions are made. - The final output is essential to be in a CSV file format. I require this scraping to be done just once, and I do not foresee a need for ongoing scraping after this initial task. As the data is crucial for my business development, I am seeking someone who can deliver accurate and complete results in a timely fashion. Prior experience with web scraping and proficiency in data management are highly ...
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and excellent communication skills will be hugely ben...
...in Word format into Ailken format. The main reason for this is that I'm creating a quiz and need the questions in a specific format that I can easily work with. Your job is not only to convert them but also to find the answers for all the questions. This can be done using Chat GPT or any other suitable tool you're comfortable with. To ensure the correctness of the answers, I prefer a combination of manual review by experts and automated checks. Key Responsibilities: - Convert 1000 questions from Word to Ailken format - Source answers for all questions using Chat GPT or similar tools - Verify the correctness of the answers through a combination of manual review and automated checks -Need to source question and answers from an online workbook. Ideal ...
I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up ...
...clear reference and idea of what we want, and we need someone who can bring that vision to life. Responsibilities: - Create a high-quality promotional video based on our reference and idea. - Edit and enhance video and audio elements to produce a compelling final product. - Incorporate feedback and revisions to ensure the video meets our expectations. - Deliver the final video in the required format for website integration. Requirements: - Proven experience as a video editor with a strong portfolio showcasing similar work. - Proficiency in video editing software such as Adobe Premiere Pro, Final Cut Pro, etc. - Ability to understand and execute creative briefs effectively. - Strong attention to detail and excellent communication skills. - Ability to meet deadlines and work in...
Hi, Job Title: Senior Developer - SQ...for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Developer has to be at the ON SITE Dubai office. - Work Location - Dubai - Number of Working Days - 6 days ( Monday to Friday ) - Number of Working Hours - 10hrs per day - N...
Looking for a freelancer with expertise in managing and manipulating numeric data sourced from Excel spreadsheets. The work involves: - Efficient management of extensive numeric data - Organizing the data effectively onto separate worksheets according to their specific types Ideal candidates are those with previous experience in data entry and strong proficiency in Excel. Your responsibility would not only be to perform accurate data entry, but also structure it logically and intuitively. It requires excellent attention to detail, precision, and the ability to understand data categories. We value those with a proactive approach who can offer insights into improved data organization. Solid experience in similar projects is preferred.
As the owner of a Flutter Android application, I am in search of an adept developer capable of modifying some existing features to enhance user experience and overall functionality. The primary task includes: - Transitioning from an image tile format to a more dynamic and interactive image slider. The ideal candidate for this task will possess: - Proficient experience in Flutter development - Strong understanding of how to manipulate UI components in Flutter - Experience in changing app functionality and adding new elements - Expertise in creating interactive, user-friendly interfaces Please have portfolios or work samples ready for review. Your bid should reflect a complete understanding of the task at hand. Thank you for your interest in this project.
...need a professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistical analysis - Prior experien...
I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.
