Reference excel websiteงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Creating the corporate website for a chemical company with eCommerce function. Able to search 300000+ items and show suggested result while typing, login to see price, can generate a quotation online, has add to basket order function and send out email confirmation . If possible, the product data will link to an ERP database ( Winspeed). Has live chat function and customers can subscribe to our newsletter. Back office can pull the quotation data, order data and customer data. The website will have CMS to manages pages like news, promotion, career opportunities. Also include contact form and catalog request form. Also need graphic design for banners. And also do SEO. สร้าง website บริษัทโดยมี eCommerce function สำหรับสินค้าประเภทเคมี 300000 รายการ สามารถ s...
business profit loss reporting excel(Jan, Feb & March)
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static...
I'm in need of a skilled WP Job Manager/Smyles Plugin expert to make some changes and additions to both the back-end and front-end of my website. The primary focus of this project is to modify the back-end using the Smyles Plugin. Key requirements: - Expertise in WP Job Manager/Smyles Plugin: You should have proven experience with these plugins and be able to implement the necessary changes competently. - Back-end Development: You will be tasked with adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new search criteria: Specifically, I need the addition ...
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
...of images in marketing, web, and print materials. Timeline: Photographer Qualifications: Proven experience in architectural and real estate photography. A strong portfolio showcasing similar projects. High qulity camera and lens. ataching example in this link in special for 72-01 Queens Blvd I need whole building shot , Ataching file with reference....
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
I need a modern and minimalist logo designed for my company, 1031 Cap Ex, to be used primarily in marketing materials. NOTES: - only the C and E should be capital like this 1031 Cap Ex - look at uploaded examples for style reference. do not copy. come up with a new logo that follows those styles Key Points: - The logo design should be clean and simple, reflecting a modern and minimalist style. - It will primarily be used on marketing materials, so the design should be versatile and scalable. - The target audience is sophisticated, so the logo should convey professionalism and trustworthiness.
Looking for someone to do full drawing set for gas station design. Must have previous experience. Please provide a previous project as reference when bidding.
I'm looking for a talented graphic designer to create a vibrant, 8k cartoon profile photo for my PUBG account. Key Requirements: - Style: Cartoon - The photo should be in a visually appealing, animated style. - Elements: In-game items - I'd like the photo to include some notable in-game items, which I will provide for reference. - Color Scheme: Bright and vibrant - The overall color palette should be lively and eye-catching. Ideal Skills and Experience: - Strong background in graphic design, with experience in creating cartoon-style artworks. - Proficiency in using design software to create high-resolution, detailed images. - Familiarity with PUBG or similar games to understand and accurately depict in-game items. Note: As the photo will be used as a profile pict...
Hello, I'm looking for a web developer to review and correct the structure of my project. The container, where all the site's content will be, should be 1100px and centered. The font hierarchy should also be corrected and the site should be responsive. In the files, you can see the reference of the main pages for desktop and mobile. It should also be applied to the pages of the three projects.
Company website: Budget: Please provide a detailed quote for the entire project, including any revisions. Job Description: We are seeking a talented and creative graphic design team to create a professional and visually appealing pamphlet. This pamphlet will be used to showcase the various service plans and benefits offered by our HVAC company. The goal is to clearly communicate the value and benefits of our services to potential and existing customers. Project Scope: Design and Layout: Create a visually appealing and professional design that aligns with our brand identity. The pamphlet should be easy to read and navigate, with clear headings, subheadings, and bullet points. Incorporate high-quality images, icons, and graphics to enhance the visual appeal and
...need of a freelancer to assist with labeling text tweets by topic (to aid in machine learning research). Key Requirements: - Labeling 1,000 tweets as to whether they are about the topic sustainability - Must be labeled by hand (no machine learning or AI) by a native English speaker Task: -Open the attached spreadsheet -Read the FULL TEXT of each tweet. Also read the brand handle and sector for reference. Make sure to pay attention to any hashtags included. -You do not need to open any URLs. Make your judgment based only on the text. -If the tweet is about sustainability, enter "1" in column E. If it is not about sustainability, enter "0" in column E. -Note that "sustainability" is a broad topic -- it is often a judgment call as to whether a given...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
...understand our current processes and requirements. Conduct thorough research and gather necessary information. Write detailed, step-by-step instructions and guidelines for various CRM processes. Ensure documentation is easy to understand and follow for both new and experienced users. Organize and structure the content logically for efficient reference. Maintain consistency in writing style, tone, and formatting across all documentation. Study the agency website () to understand the services and sub-services provided. Set up a full database of minimum 30 to 40 demo clients or sample clients in the GrowCRM system, covering all stages from leads to task completion, payment, and ticket management. Create demo data from beginning to end for the demo clients to demonstrate the C...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
...Arizona and our RV resort. We also need you to design 6 billboards and signs for our RV resort. The magazine will be composed of: 1) A 35 page magazine/brochure containing ads for local businesses, small business features, business directory, area information, etc. The design and copywriting for each page, including ads, need to be created by you. We can provide an outline and resources for reference, as well as photos. We can give you some information about the business, some guidance/references, but will need you to write the copy (using AI is fine), 2) Design of clean and modern billboards for our marketing launch, aligning with the design of your previously designed brochure and storage center ad to maintain consistency. For the magazine/brochure, the content wil...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...
We are seeking a talented Houdini/C4D 3D Artist to create captivating animations for our website. The ideal candidate will have a strong background in 3D modeling, animation, and visual effects, with a keen eye for detail and creativity. Proficiency in Houdini and Cinema 4D. Strong portfolio showcasing 3D animation work. Experience with modeling, texturing, lighting, and rendering. Ability to work collaboratively in a team environment. Please reference previous work samples. Good luck.
I'm looking for a seasoned Python developer who can assist in two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer with a solid understandi...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output f...
A general information article is needed on waiting rooms. Key points should be what they are for, where they are found, and what is in them (i.e. what types of furniture and...in them (i.e. what types of furniture and accessories.) Discuss how waiting rooms benefit a visitor to the business and the importance of maintaining a waiting room. - Article needs to be between 1,200 and 1,500 words - Article needs to be written to provide general information about waiting rooms. - Article needs to reference 3 to 5 links that will be provided upon awarding of the project More details: General information for the public that will be available on a website. The winning bidder should have the ability to relay information about waiting rooms in an engaging manner. The project turnaroun...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
