How to make a single cell smaller in excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ทำ 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 need a professional who can help me recover a password for an Excel XLSM file. Key Requirements: - Recover a lost password for an Excel XLSM file - Ensure the process is secure and compliant with standard security practices - Maintain the integrity and functionality of the document post-password removal Ideal Skills: - Proficient in password recovery methods for Microsoft Excel - Experience in data security and encryption - Strong knowledge of Excel XLSM file structure
I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a signific...
I'm in need of a logo for my embroidery business, and I'm looking for a creative individual who can deliver a sophisticated, minimalistic design in black and white. Key Requirements: - The logo should be minimalistic in design, and entirely in black and white. - It can incorporate elements: needles and threads, or an embroidery hoop. - A keen understanding of brand identity, with the ability to create a design that is both elegant and simple is crucial. - As the project is time-sensitive, I need a freelancer who can complete the task ASAP. Ideal Skills & Experience: - Proven experience in graphic design and specifically, logo creation. - A strong portfolio of minimalist, monochrome d...
I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import
I need a professional to handle a single webinar at a time, with Audio/Video interaction enabled. Key Responsibilities: - Manage the live interactions during the webinar - Facilitate smooth Audio/Video discussions - Ensure no technical glitches during the session - Maintain a high level of professionalism and customer service throughout Ideal Candidate: - Proven experience in managing webinars with Audio/Video interaction - Excellent communication and customer service skills - Ability to multitask and manage a dynamic online event - Strong technical skills to troubleshoot minor technical issues - Comfortable handling all responsibilities in a solo capacity Your role will be crucial in ensurin...
...Concept and Design Phase: - Develop a core concept that emphasizes endless gameplay, where players can test their skills against increasingly challenging waves of zombie pets without a set endpoint. - Design a game structure that loops through waves of escalating difficulty, offering replayability and the potential for continuous improvement. - Incorporate mechanics that reward players based on their performance in surviving and progressing through the endless waves of zombie enemies. 2. Gameplay Mechanics and Features: - Implement a procedurally generated system for enemy waves to ensure each playthrough is unique and offers varying challenges. - Introduce scaling difficulty that dynamically adjusts to the player's s...
I'm seeking a talented logo designer to create a visually appealing logo for my website. The following must be taken into consideration: Business name: Classic Motor Trader (This has to be in big writing) Business URL: Colour: #ff4605 Strap Line underneath, or in the logo, it must say: 'Classic Car Marketplace' in smaller writing. It must be clear. Logo dimensions: I prefer landscape logos (better for web UX). This website is a marketplace for buying and selling cars. Thanks, Tom
...Music, LLC, a music production company located in southern California, is looking to offload high-ticket sales of our custom music production service offerings (to serious artists looking to take their careers to the next level) to an experienced individual or team of high-ticket closers. Because their business does not solely focus on a single revenue stream, they cannot adapt the traditional sales funnel model from their homepage. Instead, their main website () segments the appropriate content based on the audience type. ___________________________________________ Their website visitor profiles are as follows: (1) Artists / Vocalists / Singer-Songwriters looking for exclusive licensing of high-quality custom instrum...
...looking for a proficient web scraper who can extract text content from a specific website on a daily basis. The scraped data should be compiled and delivered in a spreadsheet. Key requirements include: - Daily scraping of text content from the designated website - Compilation and formatting of this data into a spreadsheet Your experience in web scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating ...
...with NextAuth and Google: Integration with NextAuth to enable user login via Google. Secure OAuth2 authentication flow to ensure user data protection. User registration through Google account, streamlining the sign-up process. Account and Subscription Management: Each account can manage one school, which can have multiple locations (campuses). Admin dashboard to manage subscriptions and assign school management capabilities to each account. Ability to sell subscriptions, where each subscription corresponds to a single school with its own set of locations, teachers, and resources. Role-based access control: Admin Role: Full access to manage the school, including locations, teachers, classes, and schedules. Manager Role: Lim...
I'm looking for a sales expert that can generate leads and sell an online course on money-making strategies. The course is designed for 18-35 year olds aspiring to achieve financial independence. Key Responsibilities: - Develop a comprehensive sales strategy to effectively market the online course - Utilize your expertise to reach and engage with the target audience - Maximize sales Ideal Skills: - Proven track record in sales, preferably in the online course industry - Familiarity with the target audience and their online behavior - Strong communication and persuasion skills - Understanding of online marketing tools and techniques - Ability to work independently You will be provided with personal discount codes, so that you...
I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail and goo...
Help with repetitive data entry tasks. As a potential programmer, this project involves creating a local program capable of extracting a single line of data with multiple fields from a Google Sheet and transferring it to 10+ different multi-page website forms that require unique login information. Additionally, the program should generate PDF documents on the target websites based on the transferred data and save them with named files corresponding to the original Google Sheet. It is crucial to incorporate error handling, data validation, mapping, and security measures into the program. If you are interested in working on this project, please provide details of your relevant experience and approach for ensuring its successful ...
I'm looking for a skilled web developer to craft an efficient E-commerce website within a one-month timeframe. Key Details: * The platform must include a sophisticated yet user-friendly interface for easy navigation. * It must integrate PayU or other Indian payment Gateway as the preferred payment gateway, ensuring seamless transactions for customers. *Single product category, 5-6 subcategories, 10-15 listings per sub category, in total about 50-70 listings, and my idea of the maximum number of pages on the website all included is 100.
I'm in need of a skilled engineer specialized in load structural calculations and wind assessment. The project involves a rural single-family home in the US. Key Responsibilities: - Conducting load structural calculations for a single-family home in a rural area - Carrying out a comprehensive wind analysis specific to the location of the project Ideal Candidate: - Professional engineer with expertise in structural engineering - Proficient in performing load calculations for residential structures - Capable of conducting wind assessments for rural settings - Previous experience with similar residential projects in the US is a plus Your work will be crucial for ensuring th...
...an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably wi...
Project Details $30.00 – 250.00 USD I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship...
I'm in need of a Spring application that offers a multi-authentication system to allow users to log in using Oauth2, DB username/password, and LDAP, all integrated into a single application. Ideal Skills: - Proficiency in Java and Spring Framework - Experience with Oauth2, LDAP, and database management - Strong understanding of security practices and multi-authentication configurations I would require the following features: - Seamless integration of Oauth2, DB username/password, and LDAP for user authentication
...and mobile app (iOS and android): Key requirement from developers: • Looking for a team of qualified developers with knowledge of all the functionalities required for this project • Must have expertise in building website as well as android and iOS apps • The scope of the work may increase as we learn more about the users of the website. • Please send your price quotations with detail of language/tools you will use and the timeframe you will need to complete this project. Functionalities to build: • Book meeting function that automatically check calendars of team members and shows available slots to external users to make booking with our experts - Admin can sync several calendars (of team member/experts) to...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from the...
...this project. One is a circle decal design, one is a mini excavator and the third one is a logo. I'd like you to merge these two images, placing the text 'LOUEZ MOI' over the excavator. This design will be printed as a 30-inch by 30-inch sticker. It has to include the logo. And it also as to have the text '''', alot smaller, but still visible Key Requirements: - The color preference for this design is green. just like the RRS logo i uploaded. - The level of cartoonization I'm looking for is a moderate cartoon effect, where the design should be clearly stylized but still recognizable. - I'm open to suggestions for additional elements in the design. Ideal Skills and...
...you a video creator with a knack for making informative how-to/tutorial videos or are you more interest in comparing videos? If so, we have an amazing opportunity for you to join our team and showcase your talents on our established YouTube channel. We're looking for individuals who can create engaging step-by-step tutorials for software, apps, and email marketing tools. Please note, these are not animated explainer videos; we require screen recordings. Requirements: - Proficiency in English (native speakers preferred) - Willingness to record your phone/computer screen, along with your voice - Ability to explain concepts clearly and concisely - Access to a high-quality microphone I'm looking for s...
I am seeking the help of a professional for expertise in remodeling my single family raised ranch house. Key areas of the house that need expansion are: - Living room - Kitchen - Bedrooms - Sublevel Although I do not have a specific design style in mind, the expansion should feel natural, complement the existing structure and make efficient utilization of the expanded space. Ideal candidates should possess a diverse portfolio of design styles, have experience in home remodeling, and can make appropriate design suggestions based on the nature of the space and existing structure. Your bid should be inclusive of cost estimations of materials and man-hours. Looking forward to a satisfying execution of the pr...
I'm looking for someone to edit a series of short videos for me. The total duration of the videos is less than 30 minutes in total. Key Responsibilities: - Cut and trim clips accordingly - Add text overlays - Merge multiple clips into one video Requirements: - Proficiency in video editing software - Experience in adding text overlays - Ability to cut and trim clips effectively - Familiarity with merging multiple clips into a single video Please reach out if you have the necessary skills and are interested in this project.
I am looking to significantly revamp my home's exterior in order to increase its curb appeal. The remodel should reflect a modern rustic style. The specific changes I intend to make include: - Window replacement: To maintain a unified style, the new windows should complement the modern rustic look. - Addition of front dormers: Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this projec...
I'm looking for a professional who can help me generate contact information (name, email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the abil...
Each year we do a t-shirt for our American Football event called Champions for Charity. We need an illustrator to make us a new illustration for this year's shirt. This should be a custom illustration, not modification of the provided files. Project details are below. 1. Deliverables - 1 editable illustrator file with illustration for front of shirt. Black and white line drawing with single color fill (red) 2. Last year's shirt is attached for reference. 3. The illustration should be of our mascot kicking a football (American football) over the stadium through the field goal posts (see attached sketch) 4. The stadium is already drawn, pull this from last year's file (attached ). Just need to change the year inside ...
EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.
I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.
