Excel macro chinese textpráce

I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of end of day to late evening Sunday, 01/26/25. Key...

I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.

...Constraints: The report will be provided to the manager within 3 seconds. The report will include all tasks marked as "Completed" or "In Progress." Displaying the report: The system will present the report clearly and orderly, including graphs and statistics. Constraints: The system will ensure the report loads within 5 seconds without delay. The system will allow downloading reports in PDF or Excel format. 6. Use Case: Smart Recommendations for Employees or Managers User Actions: Requesting a smart recommendation: The manager or employee can request the system to provide a suggestion for improving or optimizing work. Constraints: Recommendations will be provided only after the system has gathered sufficient data on projects and tasks. System Actions: Collec...

Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: ...data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First phase within 2-...

# Job Title: Submit Job Applications on Job portals using my Resume # Job Description: I am looking for a reliable freelancer to submit job applications on my behalf usi...postings on Linkedin, Glassdoor, Workday and Indeed that match my experience and skills. - Submit my resume to the job listings - Ensure each application is relevant to my background and experience. - Track and report the total number of applications submitted using MS Excel or Google Sheets # Requirements: - Strong attention to detail and understanding of different job roles. - Ability to follow instructions and submit applications appropriately. - Good communication skills for reporting progress. - Experience using MS Word, MS Excel, Google Doc, Google sheets. # Compensation: - $10 for every 100 applic...

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points f. Co...

Necesito un macro para uber para que me muestre cuanto gano por km recorrido en total para saber si me sale a cuenta o no el viaje

...A clean, polished, and user-friendly design that reflects our credibility and expertise. Service Pages: Clear and detailed sections to highlight our Web3 and fintech legal services, tailored for businesses, startups, and individuals. Jurisdictional Guides: Interactive, easy-to-navigate guides on digital asset regulations across different regions, helping visitors quickly find what they need. Macro Legal Compliance: A dedicated section that explains broader global compliance requirements in simple, digestible terms. Insights and Analysis: A blog-like section with articles and deep dives into fintech topics like ICOs, cryptocurrencies, and other key trends. News and Updates: Regularly updated news and insights on legal changes and developments in the industry. Media and Publi...

I'm seeking a skilled Excel programmer to create a macro. This macro should compile various employee data from different sheets into a new Excel sheet. The task involves data cleaning, analysis, and report generation. Key Requirements: - Experience in Excel macro development - Understanding of data cleaning and analysis - Ability to generate summary reports, pivot tables, charts and graphs - Familiarity with handling employee data Please note, the goal is to create a macro that can automate this process, saving time and ensuring consistency in data compilation.

I'm looking for someone to create several spreadsheets that display various financial metrics related to shipments of multiple grades across different countries. The sheets should track specific details for each shipment and highlight key insights. Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong understanding of financial data - Ability to visualize data clearly and concisely Specific Requirements: - Track shipment dates - Monitor product grades - Keep a record of destination countries - Provide an overview of which grade has moved the maximum - Include quantities and other relevant data - Need charts and graphs to represent the data as well - Pivot tables and more. These spreadsheets will be instrumental in helping me understand the financia...

I'm seeking a professional with extensive experience in cybersecurity and data analysis to build a consolidated vulnerability report and accompanying dashboard. Requirements: - The report should encompass ne...professional with extensive experience in cybersecurity and data analysis to build a consolidated vulnerability report and accompanying dashboard. Requirements: - The report should encompass network, application, and database vulnerabilities. - The final report should be delivered in Excel format. - The dashboard should visualize: - Vulnerability trends over time - Severity of vulnerabilities - Overview of affected systems Ideal Candidates: - Proven experience in cybersecurity. - Proficient in data analysis and Excel. - Previous work with creating security...

I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.

I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.

Project Brief: Engaging IELTS Learning Platform for Chinese Students Objective: To create a vibrant, fun, and engaging IELTS-focused online learning platform tailored for young Chinese students, fully integrated with the WeChat ecosystem. The platform should leverage gamified elements, live streaming, and social interaction to make IELTS preparation enjoyable and interactive. Key Features: 1. Platform Concept: A fun, youthful online platform with a cool name The platform should exude modernity, resonate with the target audience, and feel like a mix of edutainment and serious preparation. 2. Live Streaming: Integration of a live streaming feature similar to popular Chinese platforms like Douyin or Bilibili. Teachers will host live classes, Q&am...

I'm seeking a professional photographer who specializes in macro/detail shots to capture my handmade bags. The primary purpose of these photos will be for my social media platforms. The ideal candidate will have: - A portfolio demonstrating experience with product photography, particularly with fashion items. - An eye for detail and ability to capture the intricate features of the bags. - Understanding of how to create engaging, high-quality images suitable for social media. Please include examples of your previous work with similar products in your proposal.

I'm looking for a comprehensive search for M&A advisory firms across Southeast Asia, specifically in Singapore, Malaysia, Thailand, Indonesia, Philippines, and Vietnam. Key Requirements: - The search should encompass all types of firms: local, international with local offices, and boutique firms. - The information gathered shoul...and boutique firms. - The information gathered should include, for each firm: - Name of company - Contact details - Services offered - Client portfolio - The final output should be a detailed spreadsheet with all the information. Ideal Skills: - Proficient in internet research - Experience in business analysis - Familiarity with M&A advisory firms is a plus - Proficient in Microsoft Excel or similar spreadsheet software. Lookin...

I'm in urgent need of an experienced professional who ...Your main task will be to find data on mortgage foreclosures sold within the past 90 days. Key Responsibilities: - Collect data from public records, real estate websites, and county auctions. - Input data into an Excel sheet with a flexible structure. Key data points include: date of sale, foreclosed address, city, county, state, owner name, phone, email, opening and closing bid. - Leave cells blank for missing data. Ideal Skills and Experience: - Previous experience in data collection, particularly in real estate or mortgage foreclosures is preferred. - Proficiency in Excel with a keen attention to detail. - Strong understanding of honesty and accuracy in data reporting. Please do not waste my time if you cann...

...products (InDesign, Acrobat, etc.) and Microsoft Office (Word, PowerPoint, etc.). Your role will be to ensure that documents meet WCAG 2.1 standards, providing accessibility for all. Key Responsibilities: Format and remediate PDF documents to meet WCAG 2.1 standards. Ensure accessibility compliance for Microsoft documents (Word, PowerPoint, Excel) and export them correctly to accessible PDFs. Use Adobe Acrobat and accessibility tools to add tags, alt text, and fix reading order. Conduct accessibility checks and resolve issues flagged by tools like Adobe Accessibility Checker and Microsoft Accessibility Checker. Key Requirements: Proficiency in Adobe InDesign, Acrobat Pro, and Microsoft Office tools. Strong knowledge of WCAG 2.1 standards and document accessibil...

...PowerBI dashboards and reports. There are about 9 fields from Autotask, 3 from Quickbooks Online, and 4 fields from Excel which I need to have all in one place for analysis. At this point, to start, I'm just looking for customer data - income, expenses, status, and a few other fields both numberical and descriptive Key Responsibilities: - Consolidate data from diverse sources, including Excel files, Google Sheets, Autotask, and Quickbooks Online. - Focus on Financial and Sales data primarily. - Ensure the data is clean, well-structured, and ready for analysis. Ideal Skills: - Proven experience with data consolidation from multiple sources. - Strong proficiency in Excel and working with Google Sheets. - Familiarity with Autotask and Quickbooks Online is a ...

...remote job. MS-SQL database expertise is required. The office hours are from 9 A.M. to 6 P.M., and lunch is complimentary. The project involves: - Implementing new features. - Bug fixing. - Performance optimization. The new features to be added include: - Customizable reports. The level of customization for the reports includes: - User-defined filters - Customizable layouts - Export options (PDF, Excel) Ideal candidates should have: - Extensive experience in raw PHP - Proven track record in developing reporting panels - Ability to work under pressure and meet deadlines - Excellent problem-solving skills for bug fixing and performance optimization - Experience in implementing new features in a timely manner - Skills in developing customizable reports - Familiarity with creatin...

I need an Excel report that handles financial data, including expense tracking, revenue generation, and profit and loss analysis. The report needs to have interactive features such as pivot tables and interactive charts. Ideal Skills: - Proficiency in Excel, particularly with pivot tables and creating interactive charts - Experience working with financial data - Ability to create comprehensive and easy-to-understand Excel reports

I'm looking for someone to complete an excel spreadsheet with financial data sourced from various company websites. This project will primarily involve researching and collecting data related to property purchase prices, monthly rent amounts, lease start dates, and lease lengths. Ideal candidates for this project should: - Have experience with data collection and Excel - Be detail-oriented and able to work independently - Have a basic understanding of financial metrics and real estate - Be able to source reliable data from company websites Please provide examples of similar projects you have done in the past.

I'm looking for an experienced data analyst or Excel specialist to create a dynamic spreadsheet for me. I have sales data from 5 stores, and I want a spreadsheet that I can upload weekly sales into. This spreadsheet should calculate: - Weekly and monthly running totals for items sold per store - Total sales across all 5 locations The data points I have include: 1. Date of sale 2. Item 3. Transaction number 4. Price sold at 5. Store # If a customer buys 3 of the same item, it will give me 3 separate lines of data (i.e., all sales listed are quantity of 1). I will be uploading my data weekly through a CSV file into Microsoft Excel. The spreadsheet needs to be able to generate the following reports: - Weekly total sales - Monthly total sales - Item-wise sales per store...

I need assistance with filing DMCA requests with Google and Bing. The primary goal is to prevent unauthorized distribution of my text/articles. The infringing content is being hosted on various websites. This project requires: - Proficiency in understanding of the DMCA process - Experience with filing DMCA requests - Ability to identify infringing content - Good communication skills for coordinating updates and progress. Please bid if you have relevant experience and can help protect my intellectual property from being improperly distributed.

I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or 1 another website , VERY easy because 2 /3 brand only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.

I'm looking for a research assistant who can help me collect and analyze both quantitative and qualitative data fo...research assistant who can help me collect and analyze both quantitative and qualitative data for an academic project. Key Responsibilities: - Data Collection: Gather both quantitative and qualitative data relevant to the research. - Data Formatting: Organize and prepare the collected data in Excel/CSV files and Word documents. - Data Analysis: Analyze the data to extract meaningful insights. Ideal Skills: - Proficient in data collection and analysis - Experienced in academic research - Skilled in using Excel and Word - Capable of working with both quantitative and qualitative data. Please, only apply if you're experienced in academic research da...

Key features of your custom CRM 1. User management: • Role-based access for administrators, team members and other user groups. • Secure login and tracking of user activity. 2. Leads and Opportunities Tracking: • Centralized dashb...to assign tasks and leads to team members. 3. Workflow Automation: • Automate repetitive tasks like follow-ups, reminders, and approvals. 4. Communication: • Integration with email, messaging or telephony systems for seamless communication. • Notification system for important updates. 5. Reporting and Analysis: • Customizable dashboards to track key metrics. • Exportable reports (PDF, Excel) for performance reviews. Depict corporate structure: Main business can have multiple subsidiaries, and eac...

I am looking for a macro developer for PC that can help me automate the process of "opening" gifts in Hypixel Skyblock in Minecraft. Ideal Skills: - Experience with creating macros for PC games - Extensive understanding of Minecraft gameplay and mechanics, particularly Hypixel Skyblock - Proficiency in programming languages suitable for macro development - Knowledge of PC gaming hardware and software The macro needs to be efficient and unobtrusive, allowing for smooth gameplay without drawing attention.

I'm looking for a skilled Visual Basic programmer who can help me develop an Excel macro. This macro needs to automate data entry tasks in a spreadsheet. Key Responsibilities: - Develop an Excel macro using Visual Basic. - The macro should be capable of automating repetitive data entry tasks. - Ensure the macro is user-friendly and efficient. Ideal Skills: - Proficiency in Visual Basic, particularly in creating Excel macros. - Experience with data entry automation. - Excellent problem-solving skills and attention to detail.

I'm looking for a professional to compile an extensive list of exhibitors from the Fitur trade show. This list will need to be more than 200 exhibitors and should include: - Company name and contact details - Product or service offerings - Booth number and location The final data should be delivered in a Spreadsheet (Excel/CSV) format. Ideal skills for this job include: - Attention to detail: It's crucial that the information recorded is accurate. - Proficiency in Excel: The final product should be well organized and easy to understand. - Research skills: You may need to look beyond the official exhibitor list to get a comprehensive view. Experience in data compilation and familiarity with trade shows will be an added advantage.

I'm in need of a freelancer who can compile a list of exhibitors from Fitur 2025. This list should be formatted in Excel and include: - Company Name - Exhibitor's Country - Email - Phone Number Please note that this list should be sourced from other trusted sources, not the event's official website or a public directory.

Hi! I am looking for a Chinese teacher, zero domain of the language. Please place your price per hour of lesson, it would be good if you speak Spanish but English is OK. Estoy buscando un profesor de chino desde cero, por favor pon tu precio por hora de clase, sería excelente si hablas también español.

I need a dashboard that visualizes and organizes the errors found in the List 1 and List 2 tabs of my Excel file. The goal is to track missing or blank cells within the data. The dashboard should include charts and graphs to clearly display the error data. Additionally, it should feature a mini database section with filters, showcasing the missing data headers and cell references for quick identification and navigation.

I'm looking for an expert in Tableau, specifically for creating interactive dashboards. The data will primarily come from Excel/CSV files, so proficiency with these sources is essential. Ideal Skills: - Extensive experience with Tableau - Proficient in working with Excel/CSV files - Ability to design interactive charts and graphs The dashboard should feature interactive charts and graphs. I'm not looking for a static, one-dimensional dashboard; I need something that can engage users and allow them to explore the data on their own. If you have a proven track record of creating such dashboards and can deliver a high-quality, user-friendly product, I would love to hear from you. My cost is 10USD

We are seeking a skilled freelancer to help transfer and configure macros from one computer to another. The macros are fully operational on the original machine, and we need assistance ensuring they work seamlessly on the new setup. Ideal skills and experience for the job include: - Proficiency in Excel, specifically with macro creation and implementation. - Experience with data manipulation, report generation and task automation. - Ability to troubleshoot and optimize existing macros for efficiency.

I need assistance converting text and numbers from an unstructured PDF into an MS Excel spreadsheet. Key Requirements: - Convert text and numbers from PDF to Excel - Data is unstructured, so adaptability is key - High level of accuracy required, with manual verification Ideal Skills and Experience: - Data entry experience - Proficient in MS Excel - Detail-oriented - Able to manually verify data for high accuracy

I'm seeking a skilled data entry professional with experience in data cleaning. The job will primarily involve cleaning mixed data (text and numbers) sourced from our database. Key Responsibilities: - Identify and rectify inconsistencies within the data - Ensure data integrity and accuracy - Prepare cleaned data for further analysis Ideal Skills: - Proficiency in data cleaning techniques - Experience working with mixed data types - Familiarity with database navigation and Excel/CSV files - Attention to detail and strong problem-solving skills Experience Requirement: Prior experience in data cleaning and verification, particularly with mixed data from a database, is highly desirable. Understanding of common data issues and how to resolve them quickly will be key to yo...

I'm seeking a professional who can provide comprehensive training on Squarespace. The focus areas include basic website maintenance, adding/deleting inventory, and Point of Sale (POS) operations. The trainer must be fluent in Chinese and some English would be helpful but not absolutely necessary. Key Requirements: - Expert knowledge of Squarespace - Fluent in Chinese and speaking some English might be helpful. - Previous experience in delivering website training - Familiarity with eCommerce and POS systems - Capable of providing online training sessions The main objective of this training is to enable me to maintain and navigate Squarespace with ease.

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I need a professional who can help me consolidate numbers from an existing Excel file and distribute targets based on specific priorities. Key Tasks: - Data consolidation from the provided Excel file - Distribution of targets with a focus on specific categories Ideal Skills: - Proficiency in Excel - Experience in data analysis - Ability to follow precise instructions and prioritize tasks accordingly Please note, the rules for data consolidation have not yet been determined and will need to be discussed.

I'm looking for a proficient Data Analyst to assist with generating reports based on our sales data. Key Responsibilities: - Analyze sales data to create comprehensive reports Ideal Skills: - Proficiency in Excel is a must - Previous experience with sales data is preferred - Strong analytical skills - Excellent report writing abilities

I need a freelancer to convert 49 pages of a PDF file into an Excel sheet. The PDF contains mixed data - both text and numeric information. Key Requirements: - Experience with data entry and Excel - Ability to understand and implement custom formatting - Attention to detail to ensure accuracy The Excel sheet needs to be formatted according to specific, custom requirements. This may involve detailed cell formatting, such as merged cells and specific alignments. Please note that this project does not require maintaining the original PDF formatting, but rather creating a unique, custom layout in Excel. Ideal candidates should have strong Excel skills, experience with custom formatting, and a meticulous approach to ensuring data accuracy.

I'm in need of a modern, illustrative logo that incorporates both text and an icon for my company. The ideal logo will seamlessly blend modern design elements with an illustrative icon, creating a unique and appealing brand image. Skills & Experience: - Proficient in graphic design software (e.g., Adobe Illustrator, Photoshop) - Strong portfolio showcasing modern, minimalist and illustrative designs - Excellent understanding of typography and icon design - Ability to translate brand identity into visual elements - Strong communication skills for understanding client feedback and requirements.

extract data from web ejar SA, and put it into excel sheet

I need an application for Breast Cancer Patients In The Radiology Department, where they undergo eight different tests. I want the pateint information the has been inter be able to save then in excel The program should help schedule these tests based on the following basic information: • Patient name • Patient age • Patient file number • Referral date to mammogram • Treating doctor’s name • Patient’s phone number • Treating doctor’s email • A field from which I can send an email from my personal email The first procedure is the mammogram date. The mammogram should be scheduled within 48 hours from the referral date, taking into consideration that the appointment should fall between Sunday and Thursday. The result field is ...

I'm looking for a skilled Excel expert or data analyst to create a dynamic Excel sheet for me. This sheet should generate random pairings between individuals, taking into account specific conditions (cannot be from the same cohort year and cannot be repeat matches). Key Project Details: - Number of Individuals: Between 50 and 100 - Pairing Frequency: 3 times a year - Information to Include: - Cohort year - Full name - Email address - Previous matches Ideal Skills and Experience: - Advanced Excel skills - Data analysis experience - Understanding of creating dynamic and interactive spreadsheets - Prior experience with similar projects will be an advantage. This project will help to facilitate interactions between individuals in a controlled and fai...

I'm looking for...desktop application that can extract text from PDFs of company conference call transcripts in a structured manner. The extracted data should be formatted as a JSON or text file. Key Features: - Text extraction from conference call PDFs - Potential categorization of the text by sections (e.g., opening remarks, Q&A, closing remarks) - Structuring of the extracted text for future use with AI tools like ChatGPT or Deep Seek Ideal Skills: - Proficiency in desktop application development - Experience with PDF text extraction - Familiarity with JSON file formatting - Knowledge of AI tools and their data requirements I am open to the extracted text being categorized, but it is not a strict requirement. The main focus ...

We need Landing page text change that displays Coming Soon for an Architectural Design Company . . Do not chat as you will be blocked immediately

...information (e.g., social media links, addresses). • Ensure data accuracy and relevancy. Qualifications: • Proven experience in market research or business consultancy in UAE • Familiarity with African business networks or diaspora communities, especially in UAE. • Strong organizational and analytical skills. Deliverables: • A comprehensive and well-organized directory in an editable format (e.g., Excel, Google Sheets). • A short summary report of the research process and insights gained during the project. Additional Information: • Preference will be given to candidates familiar with Dubai’s African community or with access to existing networks. • Please include examples of previous relevant projects or research in your proposal. ...

Necesito modificar un Excel para que se vea bien y sea funcional que los requisitos que se han puesto funcionen