Excel crm workflowงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
กำลังทำธุรกิจเกี่ยวกับแพลตฟอร์มการท่องเที่ยว มีทีม dev แล้ว และอยากได้คนที่จะมาวิเคราะห์ วางแผน ออกแบบ structure / architecture / workflow / logic ต่างๆและแตกเป็นงานย่อยให้แก่ developer เพื่อที่จะได้เห็นภาพชัดขึ้น และ developer ทำงานง่ายขึ้นด้วยเช่นกัน
...สามารถ 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
ต้องการ Implement ระบบ OPENERP ODOO ตอนนี้องค์กรณ์ต้องกรใช้ระบบดังนี้ 2.CRM Warehouse สามารถเชื่อมต่อระบบคลังสินค้ากับ Prestashop ได้ และ สามารถสร้าง SO มายังระบบ Odoo ได้ ปัจจุบันใช้ระบบดังนี้ 1.โปรแกรมบัญชี Express CRM Prestashop สิ่งที่ต้องการ 1.ทำ Work flow หรือ Standard Work สำหรับงานแต่ละแผนก 2.ย้ายข้อมูลจากระบบ Express แลพ CRM มายัง Odoo 3.เชื่อมต่อข้อมูลกับระบบ Prestashop และ สอยวิธีการเชื่อมต่อข้อมูลเนื่องจากมีหลายเว็บไซต์
ทำการเรียกข้อมูลไปยังหน้าเว็บโดยใช้ Stored Procedure ที่ทางเรากำหมดให้ โดยใช้ Component ของ DevExpress
I'm launching a donut shop in a shopping mall, and I'm looking for a professional to help set up the shop and its operations. - I'll be offering a variety of donuts, coffee, and smoothies. A key expectation is for the freelancer to help incorporate these offerings seamlessly into the shop's workflow. - The target audience for this establishment is wide, catering to adults, children, and all age groups. It is important that the shop's design and services reflect this inclusivity. - I need someone experienced in the food retail industry, especially in setting up and running a donut shop. Knowledge of the local market and shopping mall culture is a big plus. - Design skills are also valuable as I'd like the freelancer to help in creating a welcoming and ...
I'm in need of a skilled email template designer to create a responsive email template that fits the Zoho CRM. Key Requirements: - The email template needs to be compatible with Zoho CRM. - It should be responsive, ensuring that it displays correctly on various email clients, including Gmail, Outlook, and Yahoo Mail. Application Requirements: - Please include your experience in designing email templates.
...equal to the status drop down list in the National Skills Competition module. - add page number for the existing report Key Areas: - Sales and Invoicing - Inventory Management - CRM One must possess robust experience in these areas and be prepared to handle multiple tasks efficiently. I'd appreciate if applicants could showcase their proficiency in Odoo development, preferably through examples of past work. Any relevant certifications or endorsements are a considerable plus. Ideal Skills: - Experience in Odoo development - Ability to handle multi-faceted tasks - Proficiency in Sales, Inventory Management, and CRM modules of Odoo. If you believe you fulfill these criteria, I'd love to hear from you....
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
I currently use Hawksoft CMS and Marketing 360 CRM. My project requires a platform that integrates these systems with a document signer and a calculator. Key Features: - A user-friendly log in system with multiple users. - Integration of Hawksoft CMS and Marketing 360 CRM into the platform. - A document signer with the ability for electronic signatures and document tracking. - A calculator that includes formulas for interest and payment schedules. Ideal Skills: - Proficiency in CMS and CRM integration, particularly with Hawksoft CMS and Marketing 360 CRM. - Experience in developing document signing features with elements such as electronic signatures and document tracking. - Strong background in building calculators with advanced financial for...
I'm seeking a skilled HubSpot professional to provide me with training. Although I'm a beginner, I'm eager to get up to speed on Marketing and Sales Hubs. My primary goals for using HubSpot are to enhance our lead generation, customer relationship management, and sales pipeline management. Key Requirements: - Strong experience with HubSpot, specifically Marketing and ...and Sales Hubs. - Prior training experience, especially with beginners. - Ability to tailor the training to my goals. Your responsibility will be to provide clear, engaging, and actionable instruction to help me utilize Hubspot effectively. You should be patient, good at explaining complex concepts simply, and able to adapt to my pace and learning style. A background in marketing automation and CRM...
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.
Project Overview: We are looking for a talented web developer or development 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 with...
I require assistance with building financial reports specifically targeting balance sheets within SAGE Intacct. The perfect freelancer for this project would possess the following skills and experience: - Deep understanding of SAGE Intacct software, - Proficiency in designing financial reports, - Solid knowledge in standard balan...specifically targeting balance sheets within SAGE Intacct. The perfect freelancer for this project would possess the following skills and experience: - Deep understanding of SAGE Intacct software, - Proficiency in designing financial reports, - Solid knowledge in standard balance sheets creation. The final product should be a standard balance sheet report that can integrate seamlessly into my workflow. Individuals with keen attention to detail are highly ...
...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...
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 an adept software developer to create a complexity logistics software. It will cater to various roles within our organization: from Admin users, Warehouse managers to tecnical team, and servicces. MAIN FEATURES: - Service Requirement Management: The software should effectively capture and communicate service requirements. - Feasibility Evaluati...SKILLS & EXPERIENCE: - Proven experience in software development - Knowledgeable of PostGREST for backend - Proficient in Angularand Ionic for mobile and web application developmen - Previous experience in creating logistics software will be an advantage I look forward to working with a developer who shares my vision of creating a system that efficiently manages logistics while ensuring smooth workflow amidst vari...
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
requerimos un experto en el proceso de marketing basado en google ads, creación de campañas, crear u optimizar una página web inmobiliaria, generar leads y alimentar los lead en una crm que puede ser lofty, implementar zapier... Que nos enseñe a manejar y hacer la alimentación de estas plataformas para que a los clientes le lleguen los correos automatizados, generemos llamadas. Con el fin de que vendamos propiedades en Los cabos, Mexico.
...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...
We are looking for a technical recruiter who can work for our company. The main responsibility might be looking for candidates on LinkedIn platform, give introduction to candidates, scheduling technical interviews, filter candidates based on their skills and English speaking etc. We already had an existing workflow on Trello and more details would be shared on chat.
...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 and ma...
I am in need of a skilled outbound appointment setter to assist in generating leads for my ERP solutions, specifically Zoho and Odoo. Key Responsibilities: ...requirement, preference will be given to candidates with experience in Zoho and Odoo, as they will be able to provide a deeper insight into our ERP solutions and potentially answer any preliminary questions that may arise. Ideal Skills and Experience: - Proven experience as an outbound appointment setter, preferably in the tech industry - Strong communication and negotiation skills - Familiarity with CRM tools and ERP systems - Knowledge of Zoho and Odoo (preferred) - Ability to work independently and meet targets If you're a self-motivated, results-driven professional with a knack for setting up quality appointments...
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.
...discuss case strategies, and receive personalized guidance without the need for physical meetings, saving time and enhancing accessibility. Case Organization and Management: The platform offers comprehensive tools for organizing and managing legal cases efficiently. Lawyers can create case profiles, store relevant documents, record meeting notes, and track billable hours seamlessly, streamlining workflow and enhancing productivity. Benefits for Clients: Enhanced Accessibility: Clients can access their case information and communicate with their legal team from anywhere with an internet connection, eliminating geographical barriers and facilitating quick responses to inquiries. Timely Updates: Clients receive instant notifications and updates on their case status, ensuring they a...
...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...
I need a Notion API expert to customize my Notion pages for a smoother workflow and integration with other apps. Key requirements: - Integration with other apps: I'm looking to connect my Notion pages with an email client, specifically Microsoft Outlook. The goal is to automatically create draft emails in Outlook whenever new orders are created in Notion. - Automation of tasks: The freelancer will need to create a system that automates the email creation process. This should be seamless and require minimal manual intervention. - Email drafts customization: The only specific requirement for the email drafts will be the Email body. Ideal skills and experience: - Strong knowledge of the Notion API - Experience with integrating Notion with external apps, particularly email clie...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
