Excel filter multiple columns independentlyงาน
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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
I am looking for a skilled graphic designer to assist with the rebranding of my company, PumpSpec, along with its divisions R&D Pumps & Power, National Mining & Civil Solutions, , and Thinkwater Fleurieu. The primar...desired design style should be bold and modern. The end result should be professional and eye-catching, reflecting our varied yet interconnected business interests. Your task will be to create a visual identity that is both unique and cohesive across all our divisions. I am open to suggestions and will value your expertise in this area. Experience in branding and creating stationery design for multiple business divisions would be an advantage. Your portfolio should demonstrate a strong understanding of modern design principles. Thank you for considering t...
I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so experience with this type of formatting is an...
Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account
I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.
I need an Excel expert to enter a set of numbers and dates into an Excel sheet, and perform some basic calculations. - Data Typing: You'll need to be comfortable working with both numbers and dates, as these will be the primary data types that need to be entered into the sheet. - Calculations: There are two specific calculations that need to be performed on the numbers: - Summation: You will need to calculate the total of all the numbers. - Average Calculation: You will also need to find the average of all the numbers. - Date Formatting: The dates I will provide need to be formatted in both date and time format. This means you should be adept at formatting cells in Excel to ensure the correct display of dates and times. Ideal Candidate: - Proficient in ...
I'm in need of someone to assist me with my job search, primarily by reaching out to recruiters and hiring managers. Key Responsibilities: - Help me in finding job opportunities that match my profile and goals. - Targeted and filtered search - Send LinkedIn messages to recruiters and hirin...writing, LinkedIn profile enhancement, and cover letter customization. - Familiarity with job search strategies and recruitment processes. - Excellent communication skills, particularly in writing compelling and professional messages. - Previous experience in job search assistance and recruiter outreach will be highly valued. - Proactive and self-driven personality, with the ability to work independently towards achieving set goals. Please let me know if you can assist me with this proj...
...If you can demonstrate past success in similar projects, and have the creativity and strategic thinking needed to help us grow, we would love to hear from you. Responsibilities: Develop and Execute Marketing Plans: Create comprehensive marketing strategies to increase brand awareness, drive traffic, and generate leads. Campaign Management: Plan, execute, and optimize marketing campaigns across multiple channels, including digital, social media, email, and content marketing. Analytics and Reporting: Track, analyze, and report on marketing campaigns to measure effectiveness and ROI. Market Research: Conduct market research to identify opportunities and trends within the digital signage and SaaS industries. Collaboration: Work closely with sales, product development, and customer s...
...Facebook, Instagram, Twitter, Pinterest, and LinkedIn. - Develop and curate engaging and shareable content tailored to each platform. - Monitor and respond to audience comments and engagement. - Implement strategies to increase followers and engagement. - Drive traffic to my website through well-planned campaigns. Ideal candidate: - Demonstrable experience managing social media accounts across multiple platforms. - Strong understanding of each platform's analytics and how to interpret the data to make informed decisions. - Proven track record of growing social media followings and driving website traffic. - Excellent communication and writing skills. - Creative and able to think outside the box to engage audiences. - Experience in running social media advertising campaigns ...
I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.
I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...
...professional to develop an engaging medical education website for a written/video format course with an integrated question bank. Here, the primary objective is e-learning of anatomy through a substantial base of over 1000 multiple-choice, true or false questions and short answer questions. Ideal skills and experience to have: - Expertise in e-commerce website development - Experience in creating intuitive, user-friendly layouts - Knowledge of online education or e-learning websites would be advantageous - Familiarity with designing interactive question types, such as multiple-choice and true or false questions - Capacity to handle widespread content effectively Your job will be to incorporate these aspects to ensure the final product is not just functional but also fost...
I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes ov...
I'm in need of a WordPress expert who can ...with migrating my blog articles and enhancing my blog page. Key tasks include: - Moving all blog articles from their current location to a new one on the blog page - Ensuring all URLs are properly redirected (301) to avoid broken links and maintain SEO - Updating internal links in the articles to reflect the new URLs - Implementing a dropdown menu for blog categories - Adding functionality to filter blog posts by category The ideal candidate should have: - Extensive experience with WordPress - Strong SEO understanding - Proven track record of improving blog performance - Expertise in UI/UX design - Familiarity with The Retailer theme If you are creative, detail-oriented, and can take my blog to the next level, I look forward to wo...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
...subpar and we are looking to improve this particularly on Google and Bing. We prefer to work with someone within a nearby time zone. Key deliverables include: - Improving our ranking for 10 keywords in 5 city areas where we operate. The company is targeting the areas around 5 specific cities in Wisconsin, USA. - I can provide direction - such as water testing, water softener, water filter, reverse osmosis filter, legionella testing, etc. Open to suggestions. - Increasing leads through better search engine optimization. As far as type of lead, all homes and businesses use water, but we get most requests from rural homes. Ideal candidates for this project should have: - Proven track record in SEO with similar projects where geolocation is key - Proficiency in SEO tool...
I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.
I'm in the process of setting up a new cafe and I'm looking for a talented web developer to create a website that showcases ...any necessary plugins or tools that could enhance the user experience. Skills and Experience: - Proven experience in web design, preferably with a portfolio showcasing similar projects. - Proficiency in HTML, CSS, and JavaScript. - Understanding of user experience (UX) and user interface (UI) design. - Familiarity with SEO to ensure the website ranks well on search engines. - Ability to work independently and provide creative solutions to design challenges. The project does not have an imminent deadline, but I would appreciate a quick turnaround time. Please share your portfolio or relevant work samples, along with an estimated timeline for this...
I'm looking for a skilled professional to set up a Virtual Box on my dedicated server, running Windows OS. The primary function of this setup is to have multiple virtual terminals of Windows operational. Key requirements: - Installation of Virtual Box on a dedicated server - Configuration for simultaneous operation of 5 virtual terminals of Windows Ideal skills and experience: - Proficiency in Virtual Box and working with dedicated servers - Strong knowledge and experience in setting up and configuring Windows OS - Ability to ensure smooth and efficient operation of multiple virtual terminals
business profit loss reporting excel(Jan, Feb & March)
...Demonstrated proficiency in creating illustrative UI designs - Solid understanding of user-centered design principles Description: Under this project 1) You have to create home page - header with menu navs (parallax effect) to show the sections and login button on right corner - hero section with background image, heading and description of the product - features sections should create multiple sections for each feature with an image and description. - pricing table with 3 variants. - testimonials - footer with company details. 2) Login page - Login page should be divided vertically into two parts left should have a login form with third-party login images like Google, Facebook etc., Right side should be an image showing images in carousel....
I'm in immediate need of a Solidworks expert to assist with multiple tasks related to creating and manipulating sheet metal panel drawings. The work will primarily involve: - Creating 3D models from 2D drawings - Making modifications to these models - Generating flat patterns needed for manufacturing - Setting up configurations and global variances for sizes, materials, and thicknesses Moreover, the final goal is to establish a DriveWorks automation project. I'm looking for someone to ensure it encompasses: - A customizable user interface for parameter input - The ability to automatically generate reports or documentation I need this project to be completed as soon as possible. Ideal candidates should have a strong background in Solidworks, with extensive experience...
-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...
I need an experienced data entry person to perform research on Twitter(X) for crypto/stock twitter influencers/posters with over 1,000 followers who make predictions on crypto/stocks. @CryptoCapo_ is one example of a desired crypto influencer account. I also want you to find stock and crypto prediction Substack accounts, there is no subscriber min...your job to find other similar accounts and make a spreadsheet with two sheets, one for twitter and one for substack. the twitter sheet will include the twitter handle and the link to their profile for each account. The substack sheet will include the link to the main substack page, the number of subscribers, and whether the substack is free or paid. if the substack is paid, please have different columns for the different tiers and the...
I'm seeking an experienced data extraction specialist to scrape both HTML and text files for specific data. Particulars to look for will involve the text content within these files that follows a mixed format structure so would require vast knowledge and understanding of both table format data and paragraph-style d...vast knowledge and understanding of both table format data and paragraph-style data. Key Skills and Experience Required: - Strong abilities in web scraping - Adept with HTML, text parsing - Knowledge of data formats and how to transform data - Proficient in CSV file generation. We need a comprehensive extraction that maintains the integrity and accuracy of the data. As these files do come in multiple formats, versatility and attention to detail are paramount o...
I'm in the process of developing a new platform and need help with the design and user interface. The main goal is to create an engaging and intuitive experience for users. The target...platform and need help with the design and user interface. The main goal is to create an engaging and intuitive experience for users. The target audience will include a wide range of people, and I want to ensure the design appeals to a broad demographic. I need 2 quotations. 1. UI/UX 2. Cost of Development Ideal Skills and Experience: - Proficiency in UI/UX design - Experience in designing for multiple platforms (web and mobile) - Ability to create engaging and intuitive user experiences - Understanding of design principles and best practices - Familiarity with designing for a wide range of t...
ACDP is an enterprise and on the lookout for a skilled IT professional to help bring a variety of projects to life. The scope is broad, encompassing possible website development, software creation, or app building initia...and Expertise:** - Proficiency in relevant programming languages (Must have: Codeigniter, WordPress, Microsoft technologies like Azure, Power Apps) - Strong understanding of the full development cycle - Experience with both front-end and back-end development (specific skills depend on the project type) - Problem-solving abilities and a keen eye for detail This collaboration could span multiple projects, so I'm keen to establish a reliable, long-term relationship. If you're passionate about IT and ready to tackle diverse challenges, I'd love...
As an individual working in the unclaimed funds sector, I'm seeking a seasoned cold calling and appointment setting professional. Your main respo...Extensive experience in cold calling, preferably in the unclaimed funds or similar financial sector. * Familiarity with the North American market, and understanding the nuances involved in setting appointments in this region. * Excellent communication and rapport-building skills. * Experience in dealing with individuals rather than businesses. * Highly organized and able to manage and keep track of multiple appointments. Ultimately, I need a professional that is tenacious, trustworthy, and dedicated to aiding individuals to recover what's rightfully theirs. If you think you're that individual, I'd love to connect and...
I'm in need of a Java developer with expertise in debugging issues related to reading and updating properties files in a runtime environment. Key Requirements: - Your primary task will be to troubleshoot why my application, which updates the properties file during runtime, fails to reflect the updated...properties should ideally be reflected periodically within the application. - The purpose of updating the properties file is to store user preferences. The ideal candidate should have: - Proficient experience in Java programming. - Strong understanding of how to work with properties files. - Proven skills in debugging and troubleshooting. It's important for the candidate to be able to work independently and swiftly identify and rectify the issue. Efficient communication ...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด