How to make a balance sheet in excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ทำ 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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
...delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน 1.1.3 แสดงข้อมูล 1 sheet ต่อ 1 ยี่ห้อ 1.2 Upload excel file การกำหนดราคา รถยนต์มือสอง 1.2.1 สามารถ Upload การกำหนดราคา รถยนต์มือสอง จาก excel file ในขั้นตอน Download เพื่อเพิ่มหรือปรับปรุงราคา รถยนต์มือสอง ...
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I am seeking a detail-oriented freelancer to assist with entering customer feedback data into an Excel spreadsheet. Your main task will involve collecting data from online survey results and precisely transferring them. Ideal Skills: - Proficient in Excel data entry - Ability to work accurately and efficiently - Experience in handling customer feedback data Your goal will be to help me organize these crucial insights to enhance our customer's experience. Accuracy, attention to detail and discretion with confidential information will be critical.
I am seeking a talented image editor to erase Apple Watches from various photos. This is a crucial step in creating a clean look for my project. The core responsibilities of the project are: - Removing the Apple Watch from each picture with precision. - Ensuring the edited area matches and blends with the surrounding environment. - Avoiding any distortion or degradation in the image quality. - Adjusting the edited images to maintain natural color levels. The ideal candidate for this project will have: - Proven experience in photo editing. - Excellent skills in using editing software. - An excellent eye for color balance and detail. - Ability to deliver edited photos in JPEG format. Please, share your p...
I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.
...instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your refer...
I'm in need of a writer who's proficient in corporate finance to create a concise paper focusing on the fundamental concepts in this domain. The audience for this paper will be graduate students, so the content should be engaging and informative for individuals familiar with the field. Key requirements: - Create an overview of key corporate finance concepts: I'm looking for a paper that covers the primary theories and principles that underlie corporate finance, but in a way that's accessible and easy to understand for graduate students. - Target the graduate level: While the paper should provide a comprehensive understanding of the subject, it should avoid delving into unnecessary complexity. ...
I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.
...scientist or AI specialist to assist with evaluating a Korean dataset using OpenAI API calls. my goal is to set up a good testing template I can repeat Key Aspects: - Inference Speed: Achieving a balance of optimal inference speed is vital for this project. The desired inference speed for the evaluation stands at a moderate level when considering 2000 users. - Total Processing Accuracy: I'm looking to ensure the total processing accuracy of this evaluation is high. - TPA (Total Processing Accuracy): Aspects of TPA are crucial for this project; we aim for a balanced importance between total processing accuracy and inference speed. - Implement this on a shared googleColab or Jupyternotebook for on-demand use of th...
We are a leading recruitment and resourcing specialist in Australia, specialising in both temporary and permanent recruitment. We are dedicated to finding great candidates, and matching the right candidate to the right role and company, quickly. Operating across sectors such as Transport, Logistics, Education, Manufacturing, and Construction, we’re keen to build a brighter future for candidates and companies alike. Over the years, we have built a large candidate pool in several industries, but in some cases, have lost touch with some candidates. As such, we have legacy candidate data – and this is where this project comes in! We will provide a specific list of legacy candidates, and we need...
I am looking for assistance in creating a visually engaging, professional PowerPoint presentation, using a provided style template, based on a 64 double side page Word document. Key details: - Extract key points and messages to form a summarized version of the Word document's content. - Encompass a range of 50 to 80 slides with a balance between text and relevant images to ensure readability and viewer engagement. - Align with pre-existing PowerPoint template aesthetic. Ideal candidate should have: - Excellent summarization skills and attention to detail. - Proficiency in PowerPoint. - Experience in creating engaging corporate presentations. Presentation would need to be done ...
I'm seeking a social media expert who can assist in promoting crypto coin, which is currently in presale. Key Responsibilities: - Utilize organic strategies to boost visibility of the coin on Facebook, Twitter, and Instagram. - Create and post informative content that raises awareness about the coin while maintaining authenticity and engagement levels. - Develop interactive polls and quizzes that encourage user participation, helping to create a buzz around the coin's unique features and benefits. I'm looking to strike a balance between informative posts and interactive content, and this role would suit someone with a good understanding of crypto and social media marketing. Experience in the pro...
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR an...
I'm in need of a writer who's proficient in corporate finance to create a concise paper focusing on the fundamental concepts in this domain. The audience for this paper will be graduate students, so the content should be engaging and informative for individuals familiar with the field. Key requirements: - Create an overview of key corporate finance concepts: I'm looking for a paper that covers the primary theories and principles that underlie corporate finance, but in a way that's accessible and easy to understand for graduate students. - Target the graduate level: While the paper should provide a comprehensive understanding of the subject, it should avoid delving into unnecessary complexity. ...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate r...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant approvals. The Grant Writer MUST be Canadian or have the expertise and experience with the Canadian government, ideally living in Canada and speaks and writes English Fluently. They MUST specialize in IT/digital marketing/ ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for finding funding opportunities for our organization and writing polished pr...
I am in search of a skilled shoe designer with a keen interest and experience in designing sneakers and sports shoes of premium quality. This project focuses specifically on the male consumer market, so an understanding of the preferences and aesthetics of men's athletic footwear is a must. Key Requirements: - Design sporty, functional, and stylish athletic sneakers suitable for men. - Good understanding of footwear design principles and trends in men's sports shoes. - Ability to create designs that balance aesthetic appeal and functionality well. Preferred Experience: - Prior experience in designing men's athletic shoes or sneakers. - A good knowledge of sneaker cultures and trends. - Proficiency in...
...seeking a creative professional to design a flyer primarily for product advertisement. This flyer is targeted towards middle-aged adults, hence it should exude an elegant and sophisticated appeal while effectively showcasing the product. • Design Aesthetics: The design should be elegant and sophisticated. It must attract and appeal to middle-aged adults. I would encore you to look at our Instagram page @countrysidecontracts • Primary Purpose: The flyer would be used mostly for advertising our services/product. Therefore, the design should highlight the products quality optimally and trigger a buying decision. • Ideal skills: A good understanding of color harmony, aesthetic sense, and experience in creating sophi...
I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in ...
I am in need of a construction logo that has a modern and sleek feel. The name is “Maroon Construction Group”. The color scheme should be predominantly burgundy, or a shade of maroon, coupled with grey. For visuals, I envision a combination of building silhouettes and elements of commercial construction to be incorporated. An understanding of how to balance modernity with the clear depiction of a construction firm is essential for this project. Prior experience in graphic design, specifically in logo creation, is highly desirable. Knowledge in construction-related symbology will be of benefit. It must be shown in full colour and in black and white - and you need to be...
...seeking a virtual assistant to help me with my job hunting in the technology sector. The role of the virtual assistant will primarily involve: - Job application submissions: The ideal candidate should be proficient in submitting job applications online, particularly for senior-level positions in the technology industry. This includes customizing cover letters to match job descriptions and ensuring that all required documents are submitted. Sharable resources: - resume - guide doc. Salary: $25 per week Responsibilities: - open job board platform accounts with my profile - apply for 200 proper jobs matching my profile every weekday - record them in the google sheet. Requirements: - fluent English is a must - prior experien...
...am looking for someone experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to deta...
how to decode : All report content comes from the json data we provide, I explain the logic details in report logic.pdf., please check its content. I also attached a json data and a tire report , they come from one scan, you check its content to verify the report logic. we have to make similar script to generate report from our system
I would like to design standard operating procedure (rules of lead engagement) based on large medium and enterprise segments- 1) how should sales consume the leads once a lead is assigned to the sales reps. 2) Define the stage movement timeline from one stage to another in salesforce based on which stage the lead is in. 3) How long to wait to send a follow up email /call after the two way connection has been established. 4) Reason to close or recycle the lead 5) Activities logged in salesforce. etc.
I'm seeking an illustrator to create 5-10 engaging and age-appropriate cartoons for each issue of our children's magazine. Key requirements: - The cartoons must be suitable for an elementary school-age audience (6-12 years old). This will involve striking the right balance between being entertaining and educational. - The cartoons should be diverse in style and content to cater to a broad range of young readers. Ideal candidates should have: - Prior experience in creating children's illustrations, especially in a magazine context. - A portfolio that showcases a variety of styles and content that would resonate with an elementary school-age audience.
...help me create a unique and engaging diary book YouTube channel. Key Responsibilities: - Design a visually appealing and user-friendly mockup for my YouTube channel that's themed around a diary book - The mockup should effectively blend elements that are both visually appealing and functional, ensuring it resonates with the target audience - We need to maintain a balance between entertainment and educational aspects as this is a diary book themed channel Ideal Skills and Experience: - Proven experience in designing YouTube channel mockups - A creative flair for creating visually appealing designs - Previous experience with designing for vlogging, educational, or entertainment channels is desirable, especially for ...
...developer who can help me in building a server-side API and real-time applications. Key Responsibilities: - Develop server-side API: You will be responsible for creating a robust server-side API that can handle data requests efficiently. - Build real-time applications: You should have experience in developing real-time applications that provide seamless user experience. Ideal Skills and Experience: - Hands-on experience with Node.js and server-side development. - Familiarity with real-time application development. - Proficiency in using frameworks like , , and will be a plus. - Prior experience in building scalable and performant applications. - Intermediate level of experience and expertise in Node.js development. If you hav...
...seeking a skilled graphic designer to create an icon-based logo for my company. The desired logo should meet the following criteria: - Style: The overall aesthetic should be casual, veering away from the rigid structure of formal styles. I'm interested in a more relaxed, amusing approach that embodies a cheerful spirit. - Color Scheme: Adorn the logo with bright and vibrant colors. These colors should bring the logo to life, making it more appealing and eye-catching to the audience. - Type: The logo should largely be icon-based, focusing more on imagery than text. Ideal Skills: - Graphic Design skills are necessary, notably in creating logos. - Familiarity with designing icon-based logos. - An ability to balance...
...looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowled...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It i...
