Excel advanced 2010งาน
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
I'm seeking an experienced video editor who can transform my raw video footage into an informative and educational video with advanced editing techniques. Key Responsibilities: - Cutting, trimming, and merging raw footage - Adding effects, transitions, and titles for increased engagement Skills and Experience required: - Proven experience with advanced video editing - Ability to convey complex information engagingly - Excellent understanding of transitions and visual effects - Proven track record of creating informative and educational video content
I am seeking a skilled individual for basic video editing. The length of the footage to be edited is less than five minutes. The purpose of this video editing project is for personal use. Ideal Skills and Experience: - Proficiency in basic video editing tools and techniques - Efficiency in completing tasks promptly - Experi...project is for personal use. Ideal Skills and Experience: - Proficiency in basic video editing tools and techniques - Efficiency in completing tasks promptly - Experience editing personal or lifestyle-focused footage Responsibilities: - compile and cut video footage - create smooth transitions between clips - enhance video with basic editing techniques Note: while this project does not require advanced editing or color grading, a keen eye for detail is ap...
I am looking for a highly experienced and knowledgeable mechatronics tutor who has experience in Automotive R&D and exposure to Industrial/Production. The ideal candidate for this opportunity is one with advanced expertise in mechatronics 1) Teach me basic and also enable me to be able to look the design,understand and suggest Industrial improvements. 2) Review the Design and suggest improvment
...data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Content Creation with AI Tools: With the basic data in place, the next step involves using advanced AI tools to generate compell...
As the client, I a...enhancing reputation and credibility. The project also includes the design of a letterhead, business card, and invoice, adding a level of professionalism and uniformity to my business. It is preferred that potential candidates should have: - Proven experience in UI/UX design for better website navigation and interface. - Proficiency in social media integration for optimal online exposure. - Advanced understanding of HTML, CSS, JavaScript etc. Given that I require the website to be completed as soon as possible, ideal freelancers should showcase a demonstrated history of timely project execution and delivery. High attention to detail, great communication skills, and the ability to complete tasks quickly without compromising quality are essential. Please bid ac...
...considering adding the feature where a user can add their own photos of wildlife to the app, but again, that needs to wait until I get some feedback from users first. You will be required to: 1. Test out the app to see how it works. 2. Do market research in the safari/wildlife niche. 3. Development a short term marketing strategy to get my first paying users. This is a very niche app and requires an advanced understanding of marketing to get it into the right hands. I would prefer to get it into the hands of KOLs such as safari guides, who can in turn market the app to the in-person safari clients and/or social media followers, but ultimately the goal is to get it into the hands of end-users. Continuing work might include: 1. Giving me feedback on the any videos or Instag...
I am seeking a proficient game developer for my project, which is a PC-based action-adventure horror parkour game...parkour mechanics that are integral to the gameplay, making parkour experience a plus. - Incorporating multiplayer functionality into the game, previous experience with multiplayer game development is beneficial. - Using advanced 3D graphics to capture the horror element precisely and deliver a highly immersive player experience. Ideal candidates should have a strong background in PC game development, particularly in action-adventure games. A firm understanding of horror elements and parkour mechanics is highly appreciated. Experience in multiplayer implementation and advanced 3D graphics utilization is crucial. Previous work in similar projects will be a signi...
I'm eager to commision a proficient video editor to finesse and create a captivating, professional video that runs for more than 3 minutes. The project comprises editing raw interview clips to present a polish...that runs for more than 3 minutes. The project comprises editing raw interview clips to present a polished, final product. Ideal Skills and Experience: - Adept at handling and enhancing interview footage - Capacity to provide creative input will be a bonus - Prior experience in long-form video editing - Meticulous attention to detail - Proficiency in video editing software and tools. Your advanced skills in video editing will be instrumental for this project and your ability to convert raw interview footage into a professional, engaging +3 minute video will be high...
...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...
I'm looking for an experienced Excel whiz to help me organize a sizable amount of data. Specifically, you'll be dealing with multiple data categories that need to be sorted and structured. This calls for a high level of attention to detail and accuracy. Key deliverables include: - Sorting and categorizing the data efficiently - Utilizing conditional formatting and logic functions to make the sheet user-friendly - Ensuring all data is accurately placed Ideal skills for this project include: - Proficiency in Excel, especially with organizing and structuring data - Previous experience dealing with multiple data categories - A good eye for detail to ensure accuracy - Knowledge of conditional formatting and logic functions to make the sheet user-friendly If you hav...
I'm in need of an experienced PowerBI developer to engineer advanced reports and dashboards from data sourced from Excel spreadsheets. Key tasks will involve: - Implementing data modeling to organize and make sense of collected data - Developing detailed and advanced reports with complex calculations and measures - Building intuitive and informative dashboards The ideal candidate should have a strong skill set in PowerBI, specifically in crafting complex reports and dashboards. Experience working with Excel spreadsheets as a data source is necessary. Applicants with demonstrated ability to implement advanced-level calculations and measures are preferred.
I'm seeking an experienced video editor who can transform my raw video footage into an informative and educational video with advanced editing techniques. Key Responsibilities: - Cutting, trimming, and merging raw footage - Adding effects, transitions, and titles for increased engagement Skills and Experience required: - Proven experience with advanced video editing - Ability to convey complex information engagingly - Excellent understanding of transitions and visual effects - Proven track record of creating informative and educational video content
I want to create Basic Vector Logo , A letter Head , And a Membership form FORM is in excel or PDF
...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...
I'm seeking a data aggregator for a unique AI training project. Key Tasks: - Gathering text content from official website/source of the particular product/entity. - Focusing specifically on product descriptions, specifications, price and other attributes. Ideal Skills: - Basic searching skills - Able to follow given format of data collection - MS Excel or Google Sheets This project requires precision, and the information gathered will contribute to an AI's learning process. Accuracy in aggregation is, therefore, key.
...shipping module with automated return feature for product returns, automated printing of return shipping label, exchanges & advances shipment tracking & refund Customer registration & login Save shopping cart Heading categories with sub pages: about us, shop, my account, help, support & coupon and so on Live chat / chat bot Social media integration Cross Listing Plugin Guest checkout Advanced Coupon with updatable code Pop up coupons Show savings when coupon is entered Pop up - on home landing page offering coupon when entering email address Order tracking and notice when order shipped and delivered Pop up coupon offering discount when shopping cart is abandoned and closed & cart abonnement recovery email Secure payment gateway Site guarantee 6 ...
I need help from an Excel specialist who can help me identify who has opened a shared Excel document that is located on Onedrive. I am trying to see when an employee accessed it last. - You'll need to create a solution that can track and log users who access the file. - The document is accessed by 2-5 people. - It would be beneficial if you could also provide a report or dashboard that can show this access data in a clear and concise manner. Please provide examples of similar work you've done in the past, and any relevant experience that you have.
I am seeking a developer proficient in Microsoft Visual Studio 2019 with deep understanding of DAX formulas and tabular model building. My project involves developing complex measures in a data model with multiple related tables. Key Responsibilities: - Utilize Microsoft Visual Studio 2019 to create advanced DAX formulas for complex measures within our tabular model. - Implement solutions that cater to our multi-dimensional data model, which involves multiple related tables. - Ensure the performance and efficiency of the tabular model through well-structured DAX formulas. Ideal Candidate: - Proficient in Microsoft Visual Studio 2019, and specifically in DAX formula creation and tabular model development. - Previous experience working on complex data models with multiple related ta...
Um Trabalho, que foi nescessario fazer uma contagem de pessoas e lugares influentes, e Tambem somar e totalizar, contagem de votos e estimativa de média e total de pessoas e votos. Dando atratividade a alguns nomes mais influentes
As an advanced Angular/Javascript/Typescript developer with a deep understanding of NX, I'm looking for an expert to help me adjust my Jest-Angular configuration specifically for integrating with code coverage tools. Key requirements include: - Experience with Jest-Angular and its configuration - Proficiency with NX as the project structure is based on it - Proven track record of improving test execution speed - Familiarity with code coverage tools to enhance their integration Your responsibilities will include: - Tweaking the Jest-Angular configuration to comfortably work with code coverage tools - Ensuring that the test execution speed is significantly boosted post-configuration If you have worked on similar projects and are confident in your ability to meet these require...
I have an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the documen...
Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.
I'm seeking an advanced C# developer with prior experience in creating desktop applications on Windows. Familiarity with TWAIN integration is crucial. Key Requirements: - Advanced C# Knowledge: The ideal candidate should be comfortable and well-versed in advanced concepts. - Windows Desktop Application Development: Previous experience in developing desktop applications on Windows is a must. - TWAIN Integration: You should have prior experience integrating TWAIN for image scanning functionalities. This is a challenging project that requires a high level of expertise in C# and experience in developing Windows desktop applications, particularly with TWAIN integration. If you're confident in your skills and have a solid track record in similar projects, I'...
I'm looking for an expert in Photoshop who can seamlessly integrate a person into a group photo. - You should aim to create a 'natural' look, as if the person was originally part of the group. - The end result should demonstrate a high level of detail to ensure the edit is believable. This includes closely matching th...aim to create a 'natural' look, as if the person was originally part of the group. - The end result should demonstrate a high level of detail to ensure the edit is believable. This includes closely matching the lighting and shadows of the existing photo, as well as integrating subtle details like clothing wrinkles and hair strands. Ideal candidates have applicable experience and a mastery of advanced Photoshop techniques. Please, includ...
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be deliver...
I'm in the technology industry, and I'm looking for a skilled SEO expert to help bolster the online presence of my website. I need someone with a good understanding of SEO, particularly link building, to help me acquire high-quality DA backlinks. My website is Key requirements: - Advanced knowledge of SEO and backlink building - Proven track record of successful SEO projects - Understanding of quality content production and consumer-focused link building Your tasks will include: - Conducting a thorough analysis of my website and target audience. - Developing a backlink strategy tailored to the technology sector and my consumer audience. - Implementing the strategy by acquiring high-quality backlinks from reputable sources. The ideal freelancer for this project would
I'm currently on the lookout for an expert in Excel 2016, with a specialized focus on the creation of VBA. The end goal? Correct spelling mistakes across multiple worksheets in my data set. Given the language locale, proficiency in English (USA) is essential. In addition to this: - Strong attention to detail and accuracy skills are needed. - Proven experience of using Excel, especially dealing with multiple worksheets. - Experience in creating and executing VBAs effectively for similar problems. Do you believe that your expertise aligns with these requirements? If so, consider submitting a proposal.
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers ...
...the stages! Key Requirements: - Data Integration: The main task is to bring in public datasets and integrate them into the data warehouse. - Reporting & Visualization: The data warehouse primarily serves as a hub for reporting and data visualization using Microsoft Power BI. Ideal Skills and Experience: - Proficient in data integration and ETL processes. - Experience with public datasets. - Advanced knowledge of Microsoft Power BI. - Solid understanding of the business needs behind data warehousing. What exactly I will need you to deliver in the 1st stage: -EXPECTATIONS AND DETAILED NEEDS FOR DECISION SUPPORT -SCOPE OF ANALYSIS – ASPECTS EXAMINED -DATA SOURCES -LOCATION, FORMAT, AVAILABILITY -DATA SOURCE BASIC INFORMATION -DATA SOURCE INITIAL ASSESMENT (ADDITIONAL IN...
Looking for a CRM expert who can help me streamline my workflow by setting up 3 boards with advanced automation features. Key Responsibilities: - Implement automation to streamline repetitive tasks, thus increasing efficiency and minimizing human error. - Configure the system to trigger actions based on specific events/actions. - Automate the process of task assignment, status updates and data syncing, making every step in the project lifecycle transparent and traceable. - Create a robust system for sending notifications and reminders, thus ensuring no important deadline is missed. Ideal Candidate: - Extensive experience with CRM, particularly with advanced automation features. - Track record of excellent problem-solving skills, attention to detail, and the ability
...feature-rich, with a high level of interactivity. This includes implementing live chat functionality and real-time updates, underscoring the advanced nature of the project. - The ideal candidate should be well-versed in app development for both iOS and Android platforms. - Experience in creating apps with similar levels of interactivity is highly preferred. - A strong understanding of user experience and interface design is crucial to ensure the app is user-friendly and engaging. - The end product should be scalable, accommodating future updates and new features. If you have a proven track record in developing cross-platform apps that are advanced in terms of interactivity, I'd love to hear from you. Please provide examples of your previous work and detail your ...
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
