Vba word information excelงาน

1) Look-up and update price/NAV of asset based on ticker from Yahoo finance 2) automate Portfolio report as discussed

I'm looking for a freelancer who can create an automatic salary slip in an Excel sheet. The salary slip should include employee details. Please include a detailed salary breakdown in the salary slip.

Write a book on a victim of the Australian mafia with a point of the victims ultimate revenge The book should be written in the non-fiction genre. The book should have 50,000 to 100,000 words. The book should be written in the first person narrative style. The book should be tailored towards an adult audience. Include some historical context. The book should have a suspenseful and thril...written in the first person narrative style. The book should be tailored towards an adult audience. Include some historical context. The book should have a suspenseful and thrilling tone. The book should be completed within 1-2 months. Please include minimal historical details. The historical details should involve basic research for accuracy. The final deliverable should be in manuscript format (PDF/...

I'm in need of a Power BI expert who can handle, visualize, and present my financial data sourced from Excel spreadsheets. Key Responsibilities: - Transform and visualize financial data using Power BI. - Create intuitive and insightful data visualizations. - Ensure effective presentation of the data. Ideal Skills: - Proficiency in Power BI, particularly in data visualization. - Strong understanding of financial data. - Excellent Excel skills for data sourcing and preliminary handling.

NEED TO DEVELOP A MACRO WITH VBA SCRIPT TO CREATE AUTOMATIC PROCESSING OF PROCESS WHICH IS LINKED WITH AUTOCAD AND STAAD PRO ANALYSIS SOFTWARE, SAMPLE PROCES INTRODUCTION WILL BE PROVIDED WHICH ARE DONE IS INITIAL TRIALS.

I need an Excel dashboard that will help me visualize and track my staff costs. I have a video and a template that I can provide. This dashboard will specifically compare budgeted staff costs versus actual costs. Ideal Skills: - Proficient in Microsoft Excel - Experience in creating complex Excel dashboards - Knowledge in budget tracking - Ability to interpret and visualize financial data Thank you Please incorporate charts and graphs to visualize the data. The dashboard should cover monthly time periods.

I'm looking for a proficient data extractor who can help me collect text from specific pages of a website, and organize it into a specific Excel template. Key Requirements: - Extract text from product pages of a website - Organize data into a provided Excel template Ideal Skills: - Experience in web scraping and data extraction - Proficient in Excel Chat for more information

I need a freelancer who can extract plain text data from specific web pages of a website and input it into a provided Excel sheet. Ideal Skills and Experience: - Proficient in data extraction and web scraping - Excellent attention to detail - Familiarity with Excel - Good understanding of handling plain text data

I'm looking for a freelancer to create a personalized Excel invoice template for me. The template needs to include: - My Company logo and name - Client details - Product/service descriptions - As per an example invoice (which I will provide) The template should also come with: - Automatic calculations - Customizable fields - An integrated payment link Ideal skills for this project include advanced Excel knowledge, design skills for creating a professional looking invoice, and experience with invoice template creation. Please include samples of Excel invoice templates you have created in your proposal. Use neutral tones for the template.

I need help with data analysis in Excel for Cost Estimation and Analysis. Need this done in 40 mins Ideal Skills: - Proficiency in Excel - Experience with data analysis - Knowledge of statistical testing - Ability to interpret and communicate findings clearly

I'm in need of a dynamic dashboard that can track findings based on certain questions. The dashboard should be capable of connecting to my WordPress website and be integrated as a plugin. Key Requirements: - The dashboard should be able to connect to Excel/CSV files, Databases, and APIs. - It should be a WordPress plugin that allows users to filter through the data. - Users should have access to a custom search filter. - The dashboard should support real-time data updates for continuous monitoring. Ideal Skills and Experience: - Proficiency in WordPress plugin development. - Experience in creating interactive dashboards. - Ability to integrate various data sources. This project is perfect for someone with a strong background in data visualization and WordPress. The dashboar...

I'm in need of a dynamic dashboard that can track findings based on certain questions. The dashboard should be capable of connecting to my WordPress website and be integrated as a plugin. Key Requirements: - The dashboard should be able to connect to Excel/CSV files, Databases, and APIs. - It should be a WordPress plugin that allows users to filter through the data. - Users should have access to a custom search filter. - The dashboard should support real-time data updates for continuous monitoring. Ideal Skills and Experience: - Proficiency in WordPress plugin development. - Experience in creating interactive dashboards. - Ability to integrate various data sources. This project is perfect for someone with a strong background in data visualization and WordPress. The dashbo...

...evoke a "wow" feeling at first glance. - Versatile design that works well in both digital and print formats. 2. **Color Palette:** - Use vibrant and appealing colors that grab attention (e.g., gradients, pastel tones, or a mix of bold colors). - Open to suggestions, but avoid overly dark or dull shades. 3. **Typography:** - Clean, modern font with a unique twist. - The word "Woow" can be in uppercase, lowercase, or a combination (depending on the creative idea). 4. **Symbol/Icon (Optional):** - You may include a symbol, shape, or graphic that complements the name. - The icon can be abstract, geometric, or directly inspired by the concept of "wow" moments. 5. **Delivery:** - Provide files in multiple...

I need a program that can: - Crawl daily - Scrape Primary Sponsor contact information (name, phone, email) - Capture Study Title - Populate this data into an Excel file with separate columns for each piece of contact info. Ideal candidates should have experience in web scraping, Python or similar programming language, and Excel data management. Please note, the program needs to operate on a daily basis, so it should be efficient and reliable. Please include an email alert system for notification if the scraper encounters an issue. The scraped data should be stored in a single sheet within the Excel file.

I need an expert in DAX queries within Power BI to assist with the creation of reports. The primary focus will be on utilizing data from Excel files. Key Responsibilities: - Develop DAX queries for effective data reporting with group by conditions. - Create visualizations including Bar/Column charts, Pie charts, and Line graphs. Ideal Skills: - Proficiency in DAX queries. - Experience with SQL Databases and Excel files. - Ability to create various types of visualizations in Power BI. The reports need to be updated weekly.

...to link a predefined SAS code (a2) with an Excel spreadsheet. Here's a brief of the project: - I have a SAS macro (a1) and a SAS code (a2) ready for use. - The SAS code (a2) has 5 user-defined variables that need to be populated from an Excel sheet. - The Excel sheet is in .xlsx format. - The variables in the SAS code can handle any type of data - numeric, string, or date. - The column names in the Excel sheet exactly match the variable names in the SAS code (a2). Your primary task will be to create SAS code that reads the .xlsx Excel sheet and fills the details of the variables in the SAS code by matching the column names in the Excel sheet. Ideal skills and experience for the job include: - Proficient in SAS programming - Experience w...

I am researching retail pricing and the impact of returns on profitability. This project requires a programmer to help me gather various types of da...so that additional locations can easily be added in the future. The ideal freelancer for this project should have experience in web scraping, data analysis, and Excel and be able to deliver the gathered data in Excel format. The data needs to be updated daily. Key Responsibilities: - Create automation to collect data from all of a given retailer's locations daily - Focus on product prices, product availability, and discounts/promotions - Deliver data in an Excel format - Set up a mechanism to ensure the data is accurate Skills Required: - Proficient in programming for automated web scraping - Experience with da...

...questions. The title of the questions is determined and more than one question is placed and permissions are placed for the answer, whether it is a number, writing, date, etc. He can add more than one title within each title. More than one question (These questions will appear to the person who will use the system in the form of boxes that are filled out (each title for the questions has its own Excel file or design form. The number of question titles exceeds 60 or more titles and each title falls under it. Each title has a means and each title has its own form or model that differs from the other. When downloading, you will be provided with that (you will be provided with all the files and we want you to enter them directly into the system) Statistics box: You can choose one of ...

I need a solution for handling a daily email containing an Excel CSV file. This will involve renaming the file using a custom name followed by a timestamp and then uploading the file to a specified FTP folder. This needs to be done within 15 minutes of receiving the email. Specific Requirements: - The solution should be an Outlook macro that runs on my PC. - The macro should be able to handle the renaming of the file using a specified custom name + timestamp naming convention. - The macro should upload the renamed file to a specified FTP folder. Ideal Skills and Experience: - Proficient in creating Outlook macros. - Experienced in handling file automation tasks. - Understanding of Excel CSV files would be beneficial.

We’re seeking an experienced WordPress developer to finalise our filmmaker resource website. This site aims to be a one-stop shop for filmmakers, providing rankings and resources to make informed decisions on festivals, courses, schools, and distributors, supported by valu...Melbourne, Australia business hours. Ideal Candidate: • Proven experience with WordPress, Astra, Elementor, and Spectra. • Strong understanding of Adsense preparation and website monetisation. • Excellent skills in UX/UI, website speed optimisation, and security. • Ability to meet tight deadlines and deliver quality work. Read attached full brief and sitemap. To apply, start your proposal with the word “FJOURNEY” so we know you’ve read the instructions. We look fo...

...goal is to gather detailed information about 3 Chinese companies. Key Requirements: - You must either reside in Hong Kong or Mainland China, or have a +86 or +852 country code for your telephone. - You will be provided with phone numbers to research. - The information obtained should include basic contact details (name, email, phone) and job titles of sales professionals. - You should be able to present the information in either an Excel spreadsheet or a plain text email. Ideal Skills: - Bilingual in English & Mandarin - Experience in telephone marketing research - Ability to gather specific information on very particular sales professional contacts (verified email, name, title) - Proficient in using Excel is helpful but not necessary - ...

I'm looking for an expert in Excel who can create a comprehensive dashboard for my preconstruction department. This dashboard should track various preconstruction metrics, including: - Total revenue / budget for fiscal year -Workload and resource planning for each estimator - Preconstruction performance - Resource planning - Financial performance - Departmental forecasting I would like the dashboard to present this data visually using charts, graphs, and tables. Ideal skills for this job include a deep understanding of Excel, experience in creating similar dashboards, and a strong ability to present data visually. Previous experience with sales data would be a significant advantage.

...·        Support the accounting team by ensuring accurate and timely client billing information and assisting with cashflow forecasting and financial management. ·        Support the President in his effective management and control of the company’s day-to-day operations and growth.  Responsibilities: ·        Client Onboarding: o  Gather and enter key client information to set up each new client and task in PulseIQ’s CRM and process workflow management system. o  Draft service agreements for review/approval and maintain a repository of all signed agreements. o  Draft and send clear proj...

I'm seeking an experienced JavaScript developer to convert my Excel file into a JavaScript application. The application needs to retain and enhance several key functionalities, including: - Data manipulation: The ability to process and analyze data should be preserved and improved. - Graphical representation: The application's visualisation capabilities need to be upgraded for better insight display. - User interface improvements: The UI should be reworked for better usability and accessibility. The input data for this application will be provided via uploaded files. Therefore, experience with file handling in JavaScript is crucial. Ideal candidates for this project should have: - Strong proficiency in JavaScript - Prior experience with data manipulation and graphical r...

I'm looking for someone to help me with data entry from a portal into an Excel spreadsheet. The data consists of text and is formatted in structured tables on the portal. Ideal Skills and Experience: - Proficient in Excel - Detail-oriented - Fast and accurate data entry skills

I'm in need of a professional with experience in email marketing and SendGrid to craft a one-time marketing email for me. The aim of this email is to promote a product/service, so it needs to be compelling and well-structured. The project involves: - Designing an engaging email template from scratch - Utilizing an Excel file I will provide, containing 5 columns of unique data for individual users, to create dynamically personalized content. Ideal Skills and Experience: - Proficiency in email marketing platforms, particularly SendGrid - Experience in designing email templates - Ability to handle dynamic email content - Strong understanding of product promotion through email marketing Please get in touch if you can help with this project!

I have completed this job outside of the marketplace. Welcome to my description. Hello, I am a passionate Digital Marketing expert with a wealth of experience in helping businesses excel in the online space. My expertise covers key areas such as WordPress, WooCommerce, SEO, YouTube marketing, and video editing. With professional training from the renowned Outsourcing Institute, I have built a strong foundation for delivering measurable and impactful results. My focus is on crafting and executing customized Digital Marketing strategies designed to meet your business objectives and resonate with your target audience. Staying ahead of industry trends and adopting the latest best practices is at the heart of my approach, ensuring you benefit from innovative and effective solutions. W...

I'm looking for an Excel expert to create two graphs (a bar chart and a bubble chart) from a provided dataset. The data spans a four-year period from January 2020 to December 2023 and includes various categories such as total reports by year and month, precinct, borough, location of incident, and specific CCRB dispositions. Key Requirements: - Data Wrapping: Use appropriate data wrapping techniques to prepare the data for graphing. - Bar Chart: Categorize this graph by the total reports per year. -Bubble Chart: We will discuss how to categorize this chart, but it will involve the total reports, precincts, boroughs, and locations of incidents. - CCRB Dispositions: These need to be displayed separately by type in the graphs. Ideal Skills: - Proficient in Excel, with a so...

I'm looking for a reliable, detail-conscious desk researcher with an understanding of small business development to assist with compiling a database of business development service providers (BDSPs) in South Africa. This will include SMME incubators, trainers, mentors and consultants (business...South Africa. This will include SMME incubators, trainers, mentors and consultants (business plans, marketing etc). The ideal candidate will have a research and data-gathering background, with knowledge of the entrepreneurship / SMME ecosystem, nationally and locally (municipality level). This will require online and data-gathering research. Attention to detail, good Excel skills and the ability to present complex information in a clear and concise manner are essential. Must be ...

...generation and outreach through social media platforms. What We Offer: Competitive monthly payout ranging from $1200 to $2000. A flexible work environment that supports creativity and independence. Opportunities for personal growth and development in a fast-paced, innovative company. If you’re passionate about making a difference in the lives of learners worldwide and have the skills to excel in this role, we’d love to hear from you! The engagement is long-term, lasting 6 or more months. The target market for this role is primarily in North America. The sales representative should be proficient in using spreadsheets for detailed lead tracking. The sales representative will have monthly enrollment targets to achieve. The sales representative is expected to wo...

I'm seeking a proficient Excel expert to develop a formula that automates the calculation of the debt service cover. The formula should specifically focus on: - Total Debt Service The ideal candidate for this project should have: - Extensive experience with Excel - Strong understanding of debt service cover calculations - Ability to create comprehensive and easy to use formulas. - High attention to detail to ensure accuracy in formulas I want this formula to be able to calculate the Total Debt Service automatically. The data for the Total Debt Service will need to be calculated rather than manually entered, imported from another file, or fetched from an online source. Please provide a bid if you have the necessary skills and experience. The data for Total Debt Serv...

I'm looking to create a spreadsheet for my choral anthem library. The spreadsheet needs to be comprehensive, including details about each piece in the collection. Ideal Skills: - Proficiency in Excel or similar spreadsheet software - Attention to detail - Experience with music libraries or music-related data entry would be a plus. The final deliverable should be a neatly formatted printout of the spreadsheet in portrait orientation. Please include the title, composer, and genre for each piece in the collection.

I need an expert to use Excel to analyze the provided A-Series model sales data. The task involves: - Creating pivot tables to summarize sell-in and sell-out by quarter and full year - Including year-on-year (YoY) comparisons - Calculating the portion of total sales for each period Visualization is key in this project. You will need to create: - Bar charts - Pie charts - Line charts All data is provided in Excel format. You do not need to perform any region-based or product type grouping, but you should have a strong understanding of how to manipulate and interpret sales data. Your ability to create clear and insightful visual representations of the data will be crucial to the success of this project.

I am seeking a research project report focusing on enhancing fault detection in aviation maintenance using AI techniques, particularly statistical analysis. The final report should be delivered in a Word document format. Key Requirements: - In-depth research on AI applications in fault detection within aviation maintenance - Comprehensive exploration of statistical analysis techniques - Ability to compile findings into a clear, concise and well-structured Word document - In-depth case studies of successful AI implementations in aviation maintenance. - Comprehensive literature review on existing AI solutions in aviation maintenance. Ideal Skills and Experience: - Strong background in aviation maintenance - Proficiency in AI and statistical analysis - Excellent research and t...

I'm seeking a software ...stakeholder requirements. - Enable user-specific access controls to ensure data security and confidentiality within the platform. - Include features that track regulatory compliance to ensure all ESG data meets national and international standards. - Create automated performance benchmarks to compare the company's ESG data against industry standards. - Provide multiple data export options (e.g., CSV, Excel, PDF) for offline analysis and sharing purposes. Ideal skills for this project: - Proficiency in software development with a focus on data management systems. - Prior experience in creating ESG reporting software is a significant advantage. - Understanding of the manufacturing industry would be beneficial. Example:

...company has developed the Excel-to-Word Document Automation Office add-in that seamlessly integrates Excel content into Word and PowerPoint documents. The calculations and data come from an Excel spreadsheet and then our add-in updates that information into a Word or PPT document. We are seeking an expert to locate Excel-Word and/or Excel-PowerPoint template pairs that we can showcase on our website to demonstrate the capabilities of our add-in. App Overview - Current Template Examples - We have outlined various use cases here - The ideal candidate will find a template pair based on one of these use cases. The Excel template will be linked to the corresponding Word or PowerPoint document

I'm looking for a freelancer proficient in data extraction and Excel to help me aggregate data from PDF files into an Excel spreadsheet. The PDF files contain information on tract ownership, and I need the following data points extracted: - Owner's name - Tract number - Ownership percentage - Net acreage ownership Ideal candidates should have excellent attention to detail, experience with data entry and Excel, and should be able to deliver accurate work within a set timeframe.

I am looking for an experienced Power BI professional to assist m...will meet on Microsoft Teams and do the work live. The dashboard will mainly focus on tracking expenses. Ideal Skills and Experience: - Proficiency in Power BI - Good design taste to help design a professional looking dashboard - Experience in building financial dashboards - Using Microsoft Teams to attend virtual meetings Key Tasks: - Collaboratively build a financial dashboard - Pull data from Excel spreadsheets and Google Sheets - Provide expert advice on Power BI functionalities Your role will be to guide me through the process, providing your expert insight and helping me to understand how to use Power BI effectively. I am particularly interested in tracking our expenses, so experience in this area will be b...

...script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. i need it like application Broker: Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task ...

I need assistance in exporting emails from my Outlook account to an Excel file. The emails should be categorized by the sender. The specific information I want included in the Excel file are: - Sender's email address - Email body content - Attachment names Ideal skills for the job include proficiency in data handling, familiarity with Outlook and Excel, and experience in email data extraction.

I need assistance with a task of data entry involving copy-pasting. The data is sourced from multiple Word documents, and it needs to be pasted into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in copy-pasting tasks - Familiarity with Word and Excel - Attention to detail to ensure data is copied accurately

Please see the attached PDF. I need a freelancer to convert this PDF into a Word document. Update the table, the header/footer according to the word document that we will provide.

I'm looking for a seasoned web developer to create a custom-built web application for managing a medicine/drug bag system. This system should incorporate a subscription-based billing model. I've begun outlining the concept in an Excel spreadsheet, detailing the necessary actions and content. Key Features: - User Roles: The system will have two types of user roles. An Admin role, which I will manage, and a Customer role, representing the end-users. - Core Functionalities: The web app should include inventory management, subscription billing, and user account management. - Maintain detailed logs of user activities and access times. - Ensure the app is fully responsive and optimized for mobile devices. - Integrate secure payment gateways for easy subscription purchasing and ...

I need a skilled professional who can convert a Word document (Thesis)into LaTeX format. The LaTeX document should have the same formatting as the Word document, including all text, paragraphs, mathematical equations, images, figures, footnotes, and references. Key requirements: - Proficiency in LaTeX - Attention to detail for formatting - Experience in converting Word documents to LaTeX - Ability to accurately convert special elements like mathematical equations, images, and footnotes. The Word document is between 50 and 100 pages. The deadline for this project is 1 week. Use the university's specific thesis template for LaTeX.

I'm looking for an expert in Google Sheets and scripting who can help automate data entry for my project. The primary task involves importing data from external sources, specifically CSV or Excel files. We want someone that can get us a name of someone working at a specific company. It should work on Google Sheets. When we put a company variable it should get us one specific name of someone that works there. Key Requirements: - Proficiency in Google Sheets and its scripting capabilities - Experience with data automation - Ability to work with CSV and Excel files - Attention to detail to ensure accurate data entry The goal is to streamline the process, saving time and reducing the possibility of human error.

...detail-oriented freelancer to assist with data entry from PDF files. The data consists of a mix of text and numerical information. Ideal Skills and Experience: - Proficiency in data entry - Familiarity with handling mixed data - Attention to detail - Experience with PDF data extraction - Ability to maintain confidentiality and handle sensitive data responsibly. Please ensure you can handle mixed data types and have experience working with PDF files before bidding. Thank you. The project involves entering data from less than 100 pages. The final data should be in an Excel file. The final Excel file should have a detailed level of organization with categorized and labeled sections. The final Excel file should organize data in chronological order. The prefer...

I'm seeking a professional to help optimize my hotel's pricing strategy. The project will involve: - Analyzing historical booking data, market trends, and competitor pricing data to develop a more effective pricing strategy. - Implementing this strate...professional to help optimize my hotel's pricing strategy. The project will involve: - Analyzing historical booking data, market trends, and competitor pricing data to develop a more effective pricing strategy. - Implementing this strategy in a way that maximizes revenue. The ideal freelancer will have extensive experience in revenue management, particularly in the hotel industry. Proficiency in Excel/Google Sheets is a must, as this is the primary tool I currently use for this project. The goal is to increase th...

I'm seeking a proficient web scraping developer to assist in extracting publicly available news data from various newspaper sites. The data will be formatted as text only, and will need to be populated into a PHP/SQL site that I maintain. Key ...services to solve captchas - User-agent rotation Ideal Candidate: - Extensive experience in web scraping - Proven ability to overcome anti-scraping measures - Proficient in PHP and SQL - Available for 3-4 hours a day over the next 6-12 months The project is built in Symfony PHP I want to work with an INDIVIDUAL, not a company, so please only apply if that applies to you. Also, make the first word of your bid the name of a famous electric car company, so I know you read this. Please include a list of past projects (urls of sites ...

I'm in need of a data scraping expert to extract insights from online for...feel are lacking - Common complaints that consumers have - Desired improvements that are frequently mentioned The final deliverable should be an organized Excel spreadsheet containing this data. Ideal skills and experience for this job include: - Proficiency in web scraping tools and software - Ability to analyze and categorize data effectively - Prior experience in product research and consumer analysis - Competence in Excel and data presentation This project is crucial for identifying potential product development opportunities and understanding consumer sentiment towards air fryers. Your ability to uncover and present this information clearly will be key to its success. Please focu...

I'm in need of a skilled Google Sheets expert to set up a table for me. The table should utilise tools like VLOOKUP, SUMIF, QUERY, and INDEX/MATCH to pull data from a large...The table should utilise tools like VLOOKUP, SUMIF, QUERY, and INDEX/MATCH to pull data from a larger table containing dates, values, and categories. The end goal is to have a summarised data table that is organised by date range, category type, and value range. the data and table are on two tabs of the same google sheet Ideal freelancer should have: - Advanced knowledge in Google Sheets and or EXCEL - Proficiency in using VLOOKUP, SUMIF, QUERY, and INDEX/MATCH - Experience in data handling and summarisation - Ability to deliver clear, summarised data in an organised manner. Link will be provided to the ...