Advanced excel topicsงาน
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 ที่กำหนดให้
ผมผมทำเว็บบอร์ดโดยใช้ phpBB ผมโหลด extension ชื่อ " recent topics " แต่มันไม่ทำงานในเทมเพลตที่ผมซื้อมา ผมอยากให้มันทำงานได้ phpBBเวอร์ชั่น:3.1.3 ผมดาวโหลดจาก นี่คือลิงค์ของ " recent topics " เทมเพลตของผม : Flatboots
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
We have a secondary dataset and need an experienced researcher with expertise in public health, preferably with knowledge in psychology-related topics, to conduct secondary research. Our focus is on how caring for dementia patients can affect the well-being of informal caregivers. The goal is to produce a manuscript that can be used to write a report in our field.
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/registration to offering profile ...
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
...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 enhancements without disrupting existing functionalities. Key Features to Include: Adva...
I'm looking for an experienced professional to create high-quality video content centered around Vedic Mathematics. The content will be aimed at educating students, hence should be engaging, clear and informative. Key Responsibilities and Requirements: - Develop a series of video content on Vedic Mathematics. This will involve covering a wide range of topics and concepts within the discipline. - Utilize an electronic pen and tab for creating these videos. Proficiency in using this technology is a must. - The primary objective of the videos is to provide educational support to students. Therefore, the content should be presented in a manner that is easy to understand and follow. Ideal Candidate: - Prior experience in creating educational content, particularly in Mathematics, w...
...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 simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
We're on the hunt for an adept copywriter to create educational website content tailored for young adults. This project aims to relay valuable educational information that's engaging and relevant. Skills and Experience Required: • Proven experience in writing high-quality website content for young adults. • A deep understanding of educational topics and the ability to convey them in an exciting and approachable manner. • Strong knowledge of SEO principles to boost our site visibility. • Excellent writing skills with attention to details, grammar, tone and voice. • Familiarity with brand building through website copy The ideal candidate will have an engaging writing style, be able to work within given deadlines, and produce well-researched, e...
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...
I'm seeking a creative professional to craft educational and tutorial videos primarily for university student audiences. The main goal is to inform and educate viewers, breaking down complex ideas into digestible...student audiences. The main goal is to inform and educate viewers, breaking down complex ideas into digestible fragments. Key Responsibilities: - Develop and produce educational and tutorial content - Ensure the content is engaging and helps students grasp tough concepts easily Ideal Skills: - Video production and editing - Knowledge in university-level subjects - Ability to simplify complex topics - Strong creative skills to engage the target audience Experience in educational or tutorial video production, especially targeted towards university students, is hi...
I am looking for a historical archive researcher to look up documents in the National Archives of India. More details: in What specific type of historical documents are you looking for? Culture and tribal records, Persian and Arabian gulf Which specific time periods are you interested in researching? 1600 - 1930 Are you looking for any specific topics or themes within the historical documents? Cultural practices, Tribal migrations, Trade and commerce
...and discussion about the practices of Tantra. This will be a wonderful opportunity for a writer who has a passion for tantra and wants to share information, experiences, and personal insights about it. Previous experience in writing about spirituality, energy work, or similar topics is a big plus. Essential skills include strong research ability, excellent writing, and communication skills, and an inherent talent for storytelling. If you have a deep understanding of the practice of tantra or have written on similar topics, I encourage you to apply. Preferably someone in London, who could attend my monthly London Tantra Retreats to understand the Emotional Detox through Tantric - Tao bodywork which I pioneered over 25 yrs ago and to produce regular SEO rich blogs to promo...
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 writer to create engaging technical content for a security blog. Key Points: - **Topics**: The content will revolve around Cybersecurity best practices, Network security, MDR, EDR. - **Target Audience**: The material should be written with IT professionals, Chief Information Security Officers (CISOs), and CEOs in mind. - **Technical Level**: The content should be at an Intermediate level. It should be detailed, but still accessible to those with a solid background in the field. Requirements: - Thorough understanding of Cybersecurity, Network Security, MDR, and EDR. - Proven experience in writing in-depth technical content. - Ability to simplify complex technical concepts for an audience with varying levels of expertise. - Experience targeting IT profe...
... fraud detection, need my website to be viewed even while customers are at work in a government agency with no restrictions to entering websites. Key Features Needed: - Product Customization Options: The ability for my customers to tailor and personalize their purchases. - User Accounts and Profiles: A seamless system for users to create accounts, save preferences, and view order history. - Advanced Search and Filter Options: A robust search functionality with filters to help customers find products quickly and easily. This project will involve not just the migration of the current site but also the creation of a new domain. I need a skilled web developer who has experience with E-commerce websites, particularly on WordPress. Familiarity with Shopify migration would be a plus...
I'm looking for a professional to assist with the creation of a YouTube channel focused on insurance. The main aim of this channel is to edu...and Medicare. - Ensuring that the content is accurate, up-to-date, and easy to understand for laymen. - Suggesting creative ideas and strategies for content diversification. Ideal candidates should have: - Prior experience in creating content on insurance topics. - An understanding of annuity and Medicare. - Excellent video editing skills to ensure high-quality output. - Strong communication and collaboration skills to work with me in creating a channel that aligns with my vision. Your role is crucial in making complex insurance topics accessible to the public, so a passion for educating and a creative approach to content creat...
I am looking for an SPSS expert who can help me with running Case-Control Matching analysis on my dataset. Key Requirements: - Advanced SPSS skills, particularly in Case-Control Matching. - Ability to troubleshoot and resolve errors efficiently. Your primary role will be to help me run the Case-Control Matching analysis and ensure it is correctly applied to my data.
I'm...Experience: - Proven experience in non-fiction writing, with a particular focus in health-related topics - A deep understanding of nutrition, fitness, and mental health, and the ability to convey this knowledge in an engaging and digestible manner - Excellent ghostwriting skills, with the ability to adopt a 'voice' most suited to the project - Strong research abilities, especially in regards to health-related topics - Previous experience writing for radio would be a bonus, but not mandatory This project is ideally suited to a writer who not only has a passion for health but also a talent for creating engaging and accessible non-fiction content. I'm looking for a writer who can take these topics and turn them into a compelling narrative that w...
I am seeking an experienced professional to assist in importing the current version 4.11 of OpenShift Container Platform (OCP) cluster into a new Advanced Cluster Manager (ACM). - Task Details: - The project primarily entails the import of all resources and configurations from the current OCP cluster to the new ACM. - Once imported, the new ACM should only be accessible to selected users with Full Administrator rights. - Essential Skills: - Knowledge and proficiency in OpenShift Container Platform version 4.11. - Adequate understanding of Advanced Cluster Manager. - Familiarity with administration and user access management in an ACM environment. Please ensure to provide relevant experience and demonstrated ability with the requirements stated above befor...
...who has expertise in the areas of Artificial Intelligence, Cloud Computing, and Cybersecurity. You should be able to write engaging content for two main segments: business professionals who want to stay informed about these technologies, and beginners in tech who need easy-to-understand, entry-level guidance. - Frequency: Weekly articles - Audience: Business Professionals & Beginners in Tech - Topics: Artificial Intelligence, Cloud Computing, Cybersecurity The ideal candidate will have excellent writing skills, a deep understanding of these tech areas, and an ability to make complex ideas accessible for all levels of tech skills. You should also have a keen understanding of the specific needs and interests of business professionals and tech newbies. Previous experience writ...
I'm in need of a virtual assistant to support me with a range of tasks related to real estate and administration. Can work from 12pm spanish time. Ideally from ARGENTINA or an equivalent/closer time zone to Spain. English level: Upper intermediate or higher. Spanish level: Advanced or higher. Key responsibilities include: - Managing my inbox and responding to emails - Handling various administrative tasks - Conducting research on different topics - Organizing information in Excel - Scheduling appointments and managing my calendar The ideal candidate should: - Be able to dedicate between 10-20 hours per week to this role. - You can make calls and videocalls and mantain fluid communication. - Possess strong organizational and time management skills. - Have a ba...
...approach. Each paragraph within the blog should have a clear topic sentence, body, and conclusion with transitions to move from one idea to the next. You will complete a rough draft and a final draft for this assessment. Content: You should focus on the information that you think would be most useful to students. You have two options: You can go for breadth, by including material from multiple topics (weeks) covered in the class; OR You can go for depth and include only material from 1 specific topic covered in the class. To demonstrate originality, include information from at least three sources shared with you within this course or the course you choose to highlight in your blog. You may use any assigned course readings or material shared with you by your instructor. Form...
...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...
As a jewelry aficionado, I'm on the lookout for someone with a cutting-edge and innovative mindset to create a stunning design for a modern ring. Ideal Skills: - Advanced familiarity with 2D jewelry design - Expertise in various styles, specifically modern ones - Sensibility about how different materials affect the look and feel of a ring The material speculated to be used in the ring design is open-ended since the third question was left unanswered. Therefore, freelancers are encouraged to make suggestions based on their professional experience and comprehension of current trends and fashions. Your creativity is much appreciated in the making of a truly one-of-a-kind piece. Take this opportunity to showcase your talents and skills in jewelry design!
...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. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
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 Tables: You will be required to create...
I am searching for an experienced programmer with skills in vb.net or LabVIEW, or Labwindows. Your task will comprise the d...IXXAT USB-CAN Converter. It run on windows 2000 operating system Key Responsibilities: - Develop a program using VB.Net/LabVIEW/Labwindows, capable of implementing the CanOpen protocol - Program must be able to read and write data to the IXXAT USB to CAN converter - The software should control devices using the CanOpen protocol Ideal Skills: - Proficiency in VB.Net, LabVIEW, and Labwindows - Advanced understanding of CanOpen protocol - Experience with IXXAT Converters It's essential that the chosen candidate guide me through the installation and testing process until we have a successful operation. The program must be compatible with Windows 2000 Op...
I'm in need of a skilled UI/UX designer who can use Figma to redesign my current app. Here's a little more detail about what I'm looking for: - **Current Platform:** The app is currently available on bot...the new design. I will provide those examples of other apps and drawings to you. I will also give you access to the current assets we have for our mobile and desktop app now in Figma. The ideal candidate for this project would have: - Expertise in UI/UX design for both iOS and Android - Proficiency in Figma - A portfolio showcasing sleek, clean, and intuitive mobile app designs - Experience in advanced app design would be a plus I'd love to see how you can turn my vision into a visually appealing and user-friendly reality. I believe I need 9 screens for thi...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
