Excel data conversion macroงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ 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)
ตอนนี้ผมลองเริ่มทำ google ads สำหรับเว็บไซต์ที่ทำด้วย wordpress และ plug-in แต่ติดปัญหาตรงเรื่องการทำ conversion tracking เลยอยากหาคนมาสอนการ set up ให้ครับ นอกเหนือจากนั้นอาจจะให้แนะนำเรื่องการทำ SEO เพื่อให้ติดด้านบน ออฟฟิตอยู่แถวๆกรุงเทพกรีฑาครับ
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
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.
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I am currently in need of a Photoshop or Illustrator wizard who can convert an existing image into a .ph or .ai file, and can do it fast. While the exact details of what to retain have not been visually mapped out: I need everything layered from the image - It's important that your work revolves around the graphic design. - Although I haven’t outlined which specific elements to keep, a keen eye for design and the ability to intuitively understand what needs to be done is appreciated. Skills and experience: - Exceptional skills in Photoshop or Illustrator. - Quick turnaround time, as I need it done ASAP. Your precision, speed, and creativity will be greatly appreciated in helping me get this design together in a tightened timeline.
I'm seeking a capable Shopify expert to address issues with slow page loading times and a high bounce rate on my web store. Despite prior attempts to improve performance, the issue remains unabated, particularly on the homepage. The ideal consultant for this project will: - Have a strong un... - Have a strong understanding and experience in Shopify speed optimization - Be able to identify and resolve issues causing slow page load times - Recommend and implement ways to improve bounce rate - Conduct necessary adjustments and interventions specifically on the homepage The ultimate aim of this project is to significantly enhance user experience and consequently increase my site’s conversion rates. I am specifically interested in professionals who have had proven succes...
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.
...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 ...
I need help with uploading an ODT file to IngramSpark. Key tasks include: - Aiding in the conversion of the ODT file to the format required by IngramSpark, if needed. - Ensuring the final file is correctly formatted. I don't need assistance with understanding IngramSpark's file format requirements, but any additional insights would be appreciated. Ideal freelancer should: - Be experienced with IngramSpark's file formats and specifications. - Possess skills in file conversion, particularly from ODT to other formats. - Be meticulous and detail-oriented to ensure the final file is correctly aligned with IngramSpark's requirements. Please note that I will be uploading the file myself, but require assistance in preparing it for upload.
I have a project that demands the skillful conversion of Figma designs into Adobe Illustrator (AI), while preserving the gradient effects. I've attempted exporting my design to SVG before importing it into AI, but observed that some gradient effects get lost. Here are the main project requirements: - The successful conversion of Figma designs into AI. - The ai file should have an identical appearance of gradients as seen in Figma. Ideal skills and experience: - Proficient in both Figma and Adobe Illustrator. - Experience in file conversion between different design tools. - Good understanding of gradient effects and how to maintain them during conversion. Your understanding of gradients and their seamless transition between Figma and AI will be the key ...
Budget is max $350. so don't ask me. I will provide end point and key info, I have needs for 4 things - 1) E* Trade API integration (take data from them). - Easy if you know API/OAuth - 2) Text to Voice Conversion. - This is where you skills will be. 3) Emailing file.- Easy 4) Learning from me about financial lingo. = time sensitive if you can not work next 7-9 days no need to bid. I need this project to be over by 4/28/2024.
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.
As a business focused on making data-driven decisions, I am seeking an expert to create a data analytics tool from scratch using ReactJS and AWS. The tool will analyze an array of data sources and present the results using insightful visualization techniques. Here are the requirements: - Implement Amazon Cognito for user authentication and authorization - Utilize AWS Amplify for the app's development and deployment - Integrate AWS API Gateway for efficient data exchange - Integrate Stripe for payments. Need complete flow Our tech stack looks like: - Amazon Amplify for app backend, and front end - Gatsby JS coupled with AppSync for front end - Amplify UI and MUI Material for UI components Features that I need: - End to end user journey - from login/regis...
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 enhancemen...
...are currently hiring for multiple positions within our expert team: Content Marketing Connoisseur: Are you passionate about storytelling and creating valuable content? Join us to develop and execute content marketing strategies that resonate with our target audience and drive engagement. CRO Expert: Do you have a keen eye for optimization and improving conversion rates? Join our team to conduct in-depth analysis and implement conversion rate optimization strategies that enhance user experience and drive conversions SMM Guru: Do you live and breathe social media? As our social media marketing expert, you'll craft engaging campaigns that captivate audiences and drive brand awareness. Email Marketing Extraordinaire: Are you skilled in crafting compelling email campai...
...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...
As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...
I need to convert my Wordpress website into mobile apps for both iphone and android. I require the converted apps to have push notifications features. Key Requirements: - Convert my Wordpress website to both iPhone and Android apps. - Implement push notifications feature for the mobile apps. Ideal Skills: - Proficiency in converting websites to mobile apps. - Experience in adding push notifications to mobile apps. - Familiarity with both iOS and Android app submission process.
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I'm in need of a skilled typist who can help me convert my PDF documents into editable text. The primary language of the documents is English. Requirements: - Type all the content in the PDFs accurately into a Word or Google Docs file. - Ensuring that there are no typographical or grammatical errors. - No specific formatting is needed, just plain text. Ideal Skills: - Proficiency in Engli... The primary language of the documents is English. Requirements: - Type all the content in the PDFs accurately into a Word or Google Docs file. - Ensuring that there are no typographical or grammatical errors. - No specific formatting is needed, just plain text. Ideal Skills: - Proficiency in English language. - Fast typing speed with high accuracy. - Experience in PDF to Word/Google Docs ...
...of the Saarey Music app store listing on Google Play Store. The current Store Listing Conversion Rate is 30%. The goal is to be >60%. See: The engaged freelancer must: - Enhance the existing app description with more captivating and engaging text which aligns well with the audience of South Asian classical music. - Create new, exciting promotional banners, graphics that illustrate the essence of Saarey Music and South Asian classical music. - Redesign the app screenshots, making them more attractive and appealing to capture the interest of potential users. - Make any other changes necessary to achieve the >60% conversion target. A reference listing is:
I'm looking for an expert in digital marketing. Your role will be focusing heavily on converting leads to purchases and optimizing landing pages for enhanced User Experience (UX). Our mobile pages should be optimised to REDUCE BOUNCE and RETAIN CUSTOMERS. Key Responsibilities: - Develop highly effective digital marketing strategies - Lead generation and conversion through Google Ads - Optimizing landing pages for UX Ideal Candidate: - Proven experience in the above. Send examples of Landing Pages that you have designed. Your expertise with our target audience will be crucial for our campaign success. Let's convert leads into sales together!
Professional Designer Needed for Amazon A+ Content Creation Project Description: We are looking for a creative and experienced graphic designer to create engaging and visually appealing Amazon A+ content for our product listings. Our goal is to enhance brand story, showcase product features, and ultimately increase conversion rates through high-quality images, comparison charts, infographics, and tailored branding elements. Responsibilities: • Design visually appealing graphics that align with our brand identity. • Create detailed infographics that highlight product benefits and features. • Develop comparison charts to differentiate our products from competitors. • Work with our marketing team to ensure the content aligns with our promotional strategies. ...
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
...from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tab...
I'm looking for a functional implementation utilizing AWS media convert in a .NET core environment, with a specific focus on video transcoding. - Functionalities: The main functionality to be implemented is video transcoding with the target being MP4 format. - Desired Output: The desired output resolution for the transcoded videos should be 1080p. Ideal Skills and Experience: - Significant experience with AWS Media Convert - Proficient in .NET core programming - Experience with video transcoding technologies - Understanding of video formats, particularly MP4, and resolution settings.
I need an experienced AutoCAD professional to convert 4 hand-drawn sketches to accurate, scaled engineering blueprints. Requirements: - The focus will be on creating basic outlines with dimensions, as opposed to full detail or annotations. - The sketches will need to include Mechanical Symbols. - Additionally, I need a PDF copy of each sketch, scaled to 11"x17" paper size. Ideal Skills and Experience: - Proficiency in AutoCAD for creating engineering blueprints. - Familiarity with Mechanical Symbols and notations. - Ability to work from basic hand-drawn sketches to generate high-quality, accurate plans. - Previous experience in creating scaled PDF copies would be an advantage.
