Advanced excel questionsงาน
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
Are you a skilled scri...and the ability to gather and synthesize information from reliable sources. Strong writing skills with a keen eye for detail, grammar, and narrative structure. Familiarity with SEO best practices and the ability to optimize scripts for searchability is a plus. A passion for storytelling and a genuine interest in technology, business, and related topics. Feel free to reach out if you have any questions or need further clarification about the project. We're excited to find a talented scriptwriter who can help us elevate our channel with compelling and insightful content! We are open to negotiating a competitive rate based on the scope of work and the level of expertise demonstrated by the candidate. No AI content accepted (ChatGPT or any other AI will...
To create a canvas powerapps screens similar to the Excel provided to Florian.
I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.
I am seeking a data visualization expert who can help adjust a stacked bar chart within a Power BI framework to display only the top 3 products based on the quantity issued. The ideal candidate should be proficient in Power BI and have a keen eye for detail. Here are the specifics: - Show only the top 3 products; no other product related data should be visible on the chart. - The user skipped the determinant of a product making it into the top 3. Considering default standards of product performance, consider factors such as total sales volume, number of units sold, or frequency of purchases. - Display method for the top 3 products was also not specified. I'd appreciate creative input, such as side-by-side bars, stacked bars, or individual bars. Please submit your bid if you're ...
As one aiming to maximize my productivity, I'm in need of a proficient data entry professional who can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale data volume, approximately between 100-1000 records. - Processing data I have currently stored in an Excel Spreadsheet. Freelancers with the following skills are ideal for this job: - Expertise in Excel and data entry practices. - Experience in data validation. - Strong attention to detail. Your primary responsibility would be to ensure the accuracy and usefulness of my data efficiently. Your proficiency and speed are key to the success of this project.
I am looking for a designer to create a modern typographic logo. We have a version already (at...(although we would like more orange included). It should be bright and vibrant. The logo uses the letters "HHRC" and there shouldn't be any other design elements. It's important that the letters are in a bold and thick design, using a "bubble" style font (but nothing cartoonish). Ideal Skills: - Logo design proficiency - Strong typographic technique - Mastery in projecting modern aesthetics - Advanced knowledge of color theory and application - Experience in creating designs that appeal to a broad audience Final Deliverable should include: - High-quality, print-ready files - Source files Note: Please include similar past works in your bid so I can better ...
...sb=t These are my details Name - PUNEET BAJAJ ACHIEVEMENTS JEE Main 2023 : Achieved a 99.29 percentile, reflecting dedication and effort. JEE Advanced 2023 : Among top 11k students out of 1.9 lac test takers NAEST 2022 : Among only 1000 students selected out of 1.15 lakh from 8th to M.Sc. IOQM 2022 : Qualified Part A of toughest Math exam for students & wrote INMO . Harvard Ready Player 50 : Among only 3700 across the world to solve all 7 levels . CERTIFICATIONS: Google Advanced Data Analytics Professional Certificate | Google - View Credential Google Cybersecurity Professional Certificate | Google - View Credential Machine Learning Engineering for Production (MLOps) Specialization | - View
My project revolves around the conversion and enhancement of specific JPEG images. The enhancements needed pertain to retouching, color correction, background removal in addition to change of format. Ideally, I require someone skilled in photo editing and proficient in using Excel, to transcribe these reformatted images into an Excel document. I would like my JPEGs converted into the Excel , if you have a keen eye for detail and the necessary expertise, I would love to hear from you.
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
I need assistance with data cleaning, data analysis, and pivot table creation in Excel. Project specifics: * Work with a large dataset containing more than 1000 rows * Data type: Mixed (both numerical and text) Ideal freelancer skill set: * Proficiency in Excel data management and analysis * Proven experience with pivot tables * Strong understanding of data cleaning processes * Attention to detail and maintaining accuracy Great results in this complex project will open up opportunities for longer-term work in our data management and analysis team. Are you the Excel expert I'm looking for?
Hi, I need someone with solid SEO experience to have a short consultation with me and answer a couple of questions. Website is built with Wordpress Silos structure Linking between pages / posts The consultation needed for maximum of 1 hour. Thanks
I am in search of an experienced AutoHotkey developer to customize the Texter application, a text automation tool, to enhance its functionality significantly. The objective is to enable quick switching between different tabs (bundles) based on user-defined abbreviations, among other features. Detailed Requirements: Multiple Tabs Support: Implement up to 15 different tabs, each selectable via specific user-defined abbreviations. Configuration in Preferences: Allow users to define and modify abbreviations for switching tabs in the application's Preferences menu. They should follow the format xyz{Enter}, and should trigger both the tab switch and the expansion of the respective abbreviation at the cursor's position. Instant Tab Switching: Tab switching must be instant and should i...
...developer capable of creating a tool to store data in bulk and automatically remove duplicates each time new data is added to the existing database. Storage of large datasets: The tool should allow for storing a large quantity of data. Duplicate removal: It should be possible to remove duplicates in the Excel files to maintain a clean and organized database. In addition to these features, it would also be necessary to be able to edit data in the tool and export the changes made to an Excel file. Furthermore, an archiving feature would be desirable, allowing for downloading of the used data for future reference. I would appreciate it if you could confirm whether you are able to develop such a tool and provide me with a quote at a reasonable rate. Thank you in advance fo...
I'm seeking a proficient AI researcher. The main focus is to research all the AI tools and suggest best tools for the following activities, 1. PPT, Excel & word document creation 2. Prompt engineering for Chatgpt & similar 3. Project management : Auto schedule creation, task tracking, followups, resource management, report generation, auto reply for emails, risk management 4. Sentiment analysis of text 5. Engineering document creation : System Requirements, SW Requirements, Architecture creation, software detailed design, software coding, Test case creation. 6. Images, Animation creations Your primary task will be to understand different AI tools, create a list of all the AI tools, its corresponding usage for both free & paid tools. The industry targeted is automo...
I need an expert in Telegram bot creation to build me a bot with advanced sorting and resending functionality. Key Points: - The bot should be able to sort messages based on keywords or phrases, and resend them to a new group or channel. - The exact criteria for sorting should be solidified based on your expertise and recommendations. - Please ensure that the bot is able to handle this complex task efficiently and effectively. Ideal Skills and Experience: - Proficient in Telegram bot creation with a proven track record of creating bots with advanced functionalities. - Strong understanding of message sorting algorithms and experience in implementing such features in bots. - Ability to advise on and implement effective criteria for message sorting.
...interior design and final construction plans. • Space Optimization: Given the limited space, the design should cleverly utilize the area to maximize both functionality and aesthetic appeal. Submission Guidelines: Please provide an initial rough sketch or concept of the planned modifications. This will help us assess your understanding of the project requirements. Feel free to ask any questions you might have; all questions and answers will be added to the project details to help clarify the requirements. Midjourney and Dalle Descriptions: a realistic villa enclosed within a barrier with a front yard (veranda and a garage) and On the roof of the front yard there's a swimming pool. Above the backyard, a second floor . ...
I'm looking for a skilled web designer to create a website that serves as an examination system. This system will be used by more than 500 users and will include the following features: - Multiple choice questions - Essay questions - Time-limited exams The primary aim is to have an interface that's user-friendly, secure, and intuitive for users to interact with, especially during exam times. The layout and design must be professional and responsive to guarantee a smooth user experience. Ideal skills for this job include: - Proficient in web design - Previous experience in creating similar systems - Understanding of user experience principles - Strong communication skills to understand requirements and provide updates on progress. Please provide examples of pre...
We are in search of a meticulous researcher adept at data compilation within Excel sheets. Your primary task will involve sourcing, researching, and organizing data for a designated list of company names provided. The role entails gathering contact details and accurately inputting them into the provided spreadsheet under relevant column headings such as email, phone number, address, country, buyer name, buyer Linkedin profile link and buyer contact number. The scope of the project requires data collection for a minimum of 1000 companies, predominantly from the United States, along with other specified countries. Upon data entry, you will be responsible for sorting and categorizing companies based on size (large, medium, small), while ensuring the removal of duplicate entries for cl...
I'm seeking an expert in Python programming, specifically proficient in Jupyter notebook, with a solid understanding and experience in credit card fraud and Reducing credit card, both from a theoretical and practical perspective. Your role involves: - Developing Python codes in Jupyter notebook for credit card fraud detection, reduction and Reducing credit card. Demonstrate excellent coding skills, with a focus on creating efficient, scalable and maintainable codes. - Writing academic level, research-intensive articles on credit card fraud prevention and Reducing credit card. These articles should delve into different types of credit card fraud and Reducing credit card, elaborate on various methods and techniques to prevent these frauds, and provide case studies and real-life ex...
looking some professionals to answer the questions about a supply chain management case study.
I require a freelance bookkeeper who can assist me with my accounting needs. - You will primarily be responsible for bookkeeping tasks, ensuring that all financial tra...that all financial transactions are properly recorded in my accounting software. - As a bookkeeper, you should have a keen eye for detail, be organized, and have prior experience in bookkeeping. - Familiarity with popular accounting software like QuickBooks and Excel is a must, as I currently manage my bookkeeping through these platforms. The ideal candidate for this job should have a strong background in accounting, specifically bookkeeping. Relevant certifications or degrees in accounting are a plus. Experience with QuickBooks and Excel is a must. I'm looking for someone who is detail-oriented and c...
I require an expert in SAS for a statistical analysis project. The main task is to conduct exploratory data analysis. This will include: - Identifying trends and patterns within the data - Understanding the distribution and characteristics of variables - Detecting outliers and anomalies - Summarizing the main features of the data The ideal candidate should have: - Extensive experience in SAS, particularly in statistical analysis. - Strong knowledge and experience in exploratory data analysis. - Excellent data interpretation and communication skills. This is a pivotal project and I am looking for someone who can provide solid insights. Further details will be provided to the chosen freelancer.
I'm seeking a professional to create a custom VST quite similar to RC20. The following features are a must: - Sound Effects: Distortion, Vinyl simulation, Noise generation, along with a digital, space, and magnetic sounds. - Clean and Minimalist Interface: I prefer straightforward design keenly focused on simplicity and function. - Advanced Sound Effects: Feature Echo/Delay, Reverb, Modulation, EQ Cuts, Gain. Ideal candidates should possess a deep understanding of sound engineering, the ability to design user-friendly interfaces, and prior experience in creating VST plugins. I look forward to your innovative proposals.
I am seeking a creative and proficient hand to enhance two of my existing logos. I do possess the original files for reference and desire the improvements specifically in their sharpness and resolution. Aside from the color alteration capability, no other design modifications are required. The skillset crucial for this project includes: - Advanced Photoshop or Illustrator expertise - Proficient understanding of image resolution - Superior attention to detail Upon completion, I will need the final copies of the logos in both Adobe Photoshop Format (PSD) and Portable Network Graphics (PNG). Your ability to seamlessly deliver these specific file formats will be valuable for this project. Ensure your bid incapsulates your talents and commitment to recreate these logos with the mentione...
I'm in dire need of an experienced online English teacher who can effectively instruct my students to advance their proficiency in English. - Mode of Instruction: The teaching will solely be online. Knowledge in utilizing different types of educational tech platforms for teaching is preferred. - English Proficiency: The goal is to elevate my students to an advanced level of English. Previous experience in teaching English at an advanced level will be given precedence. - Area of Focus: Instruction should concentrate on improving conversation skills, grammar, and vocabulary. Hence, someone who is adept at teaching these areas is strongly desired. Applicants with a track record of successfully teaching these aspects via online platforms will be significantly advantage...
I'm seeking a proficient PowerBI expert who can create a simple dashboard with 2 tables and 6 card. Data is in excel and requirements will be shared in a doc file with all details. Needs to be build today.
I'm looking for a skilled mobile app developer, particularly one with experience in hybrid app development. This app's crucial features would include: - A smooth functioning payment gateway - An innovative design that would aid archives and research The specific functionalities required for serving this purpose are noted below: - Advanced search functionality - Document categorization and tagging - Annotation and note-taking capabilities This project would significantly benefit from a developer who understands the peculiarities of creating an app for research and archival purposes. Your proficiency in hybrid application development and prior experience with similar projects will be ideal for this job.
I'm in need of a creative and experienced video editor for ongoing, advanced YouTube video projects. - Video Type: The videos to be edited are mainly YouTube content. - Editing Complexity: I'm looking for a high level of editing proficiency. This includes incorporating animations and special effects into the videos. - Frequency: I'll require your services on a frequent basis. Ideal skills and experience for this job include: - Proficiency in video editing software, particularly with complex editing features - Prior experience working on YouTube videos - Strong portfolio demonstrating previous work with animations and special effects - Ability to work to a deadline - Good communication skills, as I'll need to brief you on project specifics. Looking for som...
I have a PDF list which contains text and numbers. The list is structured with columns and rows. The task is to convert this list into an Excel sheet. The Excel list should be organized in a sorted manner, either alphabetically or numerically. Ideal Freelancer: - Proficient in data entry and conversion - Experience in handling PDF to Excel conversion - Excellent understanding of sorting data appropriately - Attention to detail is crucial
...site featuring an X Y axis for data visualization. something similar to this: But with draggable points like this: Displaying data like this: It is a user survey to capture a users response on the axis. Once they have selected their input, they will answer 3 text box questions, and add their email and click send. 1. Experience must be responsive 2. Form must have a captcha 3. All deatils must be stored in the backend as well as emailed to us. We must be able to filter responses in the backend. Key Responsibilities: - Design a visually appealing one-page WordPress site - Implement an X Y axis for data visualization - Ensure the X Y axis is responsive and functional
...experienced Google Excel expert to assist me in refining and optimizing my current Excel tables for business purposes. Key Requirements: - **Formatting**: I need assistance in improving the aesthetic appeal and readability of my tables. This includes changes to font style and size, cell borders, and background color. - **Formulas**: The expert should be proficient in implementing essential formulas such as Sum, Average, and Count. They will play a crucial part in calculating and managing data effectively. - **Data Validation**: I need guidance on implementing data validation processes to ensure the accuracy and consistency of my data entries. Ideal Skills and Experience: - Proven experience in working with Google Excel and enhancing its functionalities. - Profici...
