Excel vba format data seriesงาน
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)
Thai และ ENG format WAV (PCM,8kHz, 16 bit, Mono, Max size 100MB) ถ่าใด้ครบทุกภาษา ต่อลองราคาใด้คับ
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
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 ...
I'm in need of a talented and experienced narrator for a series of adult fiction romance stories. The ideal candidate should have a knack for the romantic genre, and be able to captivate audiences with your voice. Key Requirements: - Specialization in fiction narration, particularly in the romance genre - Experience with adult audience storytelling - Ability to convey a romantic tone The ideal candidate should be able to deliver a narrative that is engaging, emotional, and captivating. You should be able to make the listeners feel the love and passion portrayed in the stories. If you're a storyteller with a sultry, romantic voice and experience in this genre, then I would love to hear from you. Please provide samples of your past work, specifically in the romance genre...
I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.
I'm looking for an efficient and knowledgeable freelancer to complete a 5-page research paper on the topic of Mac...basic nor overly complicated. Sources Preference: - The research should be backed by credible sources mainly including: 1. Journal articles 2. Online databases Ideal Candidate: - Familiarity with biochemistry or related fields - Experience in academic writing and research - Ability to explain complex scientific concepts in a digestible manner. Documented in text and references APA format (google Owl Purdue, for assistance). Remember the title page. The title page and reference page are not included in the five pages you will owe me. The total number of pages submitted will be at least 7: the title page, five single-spaced typed pages, and the ref...
...implementing robust data visualization tools and platforms. A strong background in JavaScript, d3.js, data interpretation, and user-friendly interface design is highly sought after. The project involves: - Developing an interactive and intuitive web-based platform that will visualize multidimensional data on a map of the USA. - Allow users to select which data dimensions are shown, enabling a customizable experience and how they are shown, such as Scatter Map, Contour Map, Area Map, Bubble Map, and more. - Simple Interactive Elements Concerning the data format, I am currently uncertain whether it will be provided in a specific format or requires preprocessing. Therefore, adaptability and problem-solving skills will be advantageous in ...
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
I am seeking a talented Graphic Designer to help me with a project. The project is in its nascent stages, so I may need help in deciding the style and theme. Your past work experience and detailed project proposals will be useful in determining if you can help me. Redesign the attached file in vector format - EPS or AI Need to 2 versions Version 1 - Exact replica Version 2 - Minus the hand (ards will be there) and change word t-shirt to hat
...hour podcast. I am in need of assistance with some of the audio quality (extraneous noises, variable volume, and some low quality areas). I have done the editing parts. Key Responsibilities: - Enhance and balance audio by mixing and mastering using professional audio software - Ensure the highest audio quality, minimize noise and enhance clarity - Deliver finished output in Audacity Project File format Ideal Skills and Experience: - Proven experience as an audio engineer working specifically with podcasts - Expertise in handling Audacity software - Strong knowledge of audio mixing and mastering techniques - Excellent attention to detail in balancing sound and eliminating background noise I'm keen to find a specialist who can help in delivering crisp, clear, and immersiv...
As the client, I'm asking for a proficient graphic designer to recreate and digitally repair an old book cover. The successful freelancer should: - Have excellent skills in digital restoration and creativity, to maintain the original's charm. Requirements are as follows: - The recreated book cover needs to be in JPEG format. - The design should be a mix of exact replication and creative modifications. - More emphasis should be placed on the main title and cover art, ensuring they stand out in the final design. Candidates with a demonstrated history in book cover redesign, restoration, or with great passion for literature will have an edge in the selection process. Your portfolio showcasing similar projects would be appreciated.
...able to communicate in a professional manner and be smart and well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorization, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and easy, as we give you the form and you only have to ask the TCA/manager all the questions exactly as they are written and take a few pictures. The fee is $125 for the visit, which lasts four hours in total. Note that you will need a valid, photo and signature bearing ID for this visit. If you are int...
...able to communicate in a professional manner and be smart and well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorization, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and easy, as we give you the form and you only have to ask the TCA/manager all the questions exactly as they are written and take a few pictures. The fee is $125 for the visit, which lasts four hours in total. Note that you will need a valid, photo and signature bearing ID for this visit. If you are int...
...able to communicate in a professional manner and be smart and well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorization, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and easy, as we give you the form and you only have to ask the TCA/manager all the questions exactly as they are written and take a few pictures. The fee is $125 for the visit, which lasts four hours in total. Note that you will need a valid, photo and signature bearing ID for this visit. If you are int...
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
I need a data entry freelancer who can help me transfer 100 emails onto my website. - I'll provide you with the source of the data in PDF format. - You'll need to accurately copy and paste the emails onto the designated sections on the website. - The data should be organized in a way that's user-friendly for visitors. Ideal skills for this job include: - Proficiency in data entry, particularly copying and pasting. - Attention to detail to ensure the emails are transferred correctly. - Familiarity with website data entry would be a plus, but not mandatory.
...for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules ...
...clustering in Orange data mining software with the aim to segment and profile the churners in Customer Churn file. By applying the k-Means clustering you need to explore how many types of churners exist and what characterizes those types. More specifically, this assignment consists of two tasks: Task a (Segmentation): Establish how many types of churners there are and the size of those types. This involves dividing the churners into segments. Task b (Profiling): Profile and appropriately name the identified types of churners based on the values of their shared characteristics, i.e. variables. Your submission ought to include: 1. Orange workflow1 containing the k-Means clustering analysis of segments and profiles. 2. Summary file (max. 600 words; in PDF format) present...
...and TikToks - Videos should be concise, engaging, and relevant to the platform they are intended for - Ability to maintain a consistent brand voice across all videos Ideal Skills and Experience: - Proven experience in creating engaging social media videos - Expertise in video editing software - Understanding of social media best practices - Familiarity with Instagram, TikTok, and YouTube's video format and style - Strong communication skills to understand and implement my vision for the videos. The ideal candidate should be able to showcase a strong portfolio of previous work. Please include links or attachments to previous social media videos you've edited in your bid. Thank you for considering this project. This will be ongoing weekly. Video quantity will vary week...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
I am running a short-format content agency that edits videos for various coaches, businesses and podcasts. *The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging.* *I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth.* *You will be paid 7usd for every video-edit.* *The process is super streamlined.* *All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbnail that fits the ratio 1:1 on Instagram feed. All videos should be edited in 9/16 format for...
I'm in need of a proficient typist for creative writing projects, specifically in the narrative genre. Key Responsibilities: - Transcribing creative content into digital format - Typing up documents with attention to detail and accuracy Ideal Skills and Experience: - Proven experience with transcribing or data entry - Excellent typing speed and accuracy - A passion for narrative creative writing Looking to hire someone who can take on a variety of creative writing materials and provide accurate and efficient typing services.
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enh...
I'm looking for an experienced professional to create high-quality video content centered around Vedic Mathematics. The content will be aimed at educating students, hence should be engaging, clear and informative. Key Responsibilities and Requirements: - Develop a series of video content on Vedic Mathematics. This will involve covering a wide range of topics and concepts within the discipline. - Utilize an electronic pen and tab for creating these videos. Proficiency in using this technology is a must. - The primary objective of the videos is to provide educational support to students. Therefore, the content should be presented in a manner that is easy to understand and follow. Ideal Candidate: - Prior experience in creating educational content, particularly in Mathematics, w...
I am looking for a talented designer to create a series of vintage-inspired t-shirt designs for my t-shirt business. The designs should predominantly incorporate retro fonts. Key Requirements: - Style: Vintage - Target Audience: Adults Deliverables: - Several unique and appealing t-shirt designs - Designs should be suitable for adult audience Ideal Skills: - Proficiency in graphic design and creation of vintage aesthetics - Experience in designing for the apparel industry, particularly t-shirts - Ability to create attractive, retro-style fonts - Understanding of adult market preferences and trends Please note that while I have specified the use of retro fonts, I am open to other design elements as long as they align with the vintage theme.
...eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simulta...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
...franchises. - Branding & Templates for Social Media: Create cohesive branding materials and templates for social media platforms that embody the themes of Sci-fi, Fantasy, Cyberpunk, and Horror, with a specific focus on Machines & gears. - Static & Animated Visual Elements for Videos and Posts: Develop a range of static and animated elements that can be seamlessly integrated into both long and short format videos and posts, specifically: - video frames, - subtitles stylings, - thumbnails, - background images, - circular character frames. These elements should be eye-catching, diverse, and tailored to each franchise's unique visual identity. - We are 2 people in this project, and we each need a thematic personal profile picture as well (current, non-thematic ...
NO 3D LOGO RENDERS. NO AI GENERATED LOGOS. I am seeking a skilled graphic designer to recreate a existing logo from a PNG file. The goal is to have the logo look completely identical but with editable text. It is critic...you are experienced in creating logos with editable text and have an eye for detail, this project is for you. Please note that I do not have the font file for the text, so a match will need to be found or a very similar looking font used. Please start your bid with "Celebrate little victories", otherwise it will be ignored. You will have to deliver the final version of the logo in an editable format (.ai, .psd or .cdr), all the fonts used in the design, the final palette with hexadecimal codes as well as printable files. We will select a bid today (...
I'm urgently looking for a professional who can create a customizable resume builder for me. It needs to be a simple and effective tool that allows users to easily input their information and then customize which sections and res...to choose responsibilities to add for each employer from a list of responsibilities that can be added to. - The following sections are to be included: (1) Name/Contact information (2) Summary (3) Professional Experience (4) Technical Skills (5) Professional Designations (6) Education (7) Certifications. Export formats: - PDF - Word Not sure what format this would best be suited for. Could use Excel, Access, Word (as long as can select the data ie check box or something similar), or AI. The project is on a tight deadline, so I would a...
