Reconciliation vba excel macro työt
I'm looking for a skilled expert in excel Pivot tables. To help me create an excel master sales file where i can get my stores to fill a template and email it over to me and i could put that template in a folder and that would auto feed my master sales dashboard. - Analyzing product sales by category, and store sales from the EPOS data. - Identifying the sales trends per week/month/qtr - Focusing on the product sales data, specifically looking at the highest revenue-generating items. Ideal skills and experience for this job would include: - Proficiency in Excel and pivot tables, as the analysis will involve working with a large dataset. - Previous experience with EPOS data analysis would be highly beneficial. - Strong analytical skills and the ability to draw m...
I am looking for a QuickBooks Desktop 2023 specialist to assist me with data entry and reconciliation tasks for entries exceeding 100 in number. SKILLS AND EXPERIENCE: - Proficiency in QuickBooks Desktop 2023 is non-negotiable. - Prior experience with large scale data entry and reconciliation tasks. - Familiarity with handling electronic records and financial institution statements is a must. TASKS: - An accurate data entry of electronic records and financial institution statements into QuickBooks. - Ensuring proper reconciliation of these entries. Please highlight your relevant experience in your proposal. Proven track record in similar tasks will put you in a privileged position. I am aiming for a smooth, error-free process and your expertise can make that ...
More details: What specific tasks do you want to automate in Excel? Data entry, Data cleaning and formatting, Data analysis How many Excel files do you need to automate? 1-5 What is the approximate size of each Excel file? Less than 1MB
Am nevoie de transcrierea unor date de pe anumite documente intr-un fisier excel. Este vorba de doar 4 campuri (data, pret, serie, numar identificare) iar toate documentele au exact acelasi format. Documentele sunt in format fizic in Cluj-Napoca, Romania.
...title, I'm facing a problem with some Microsoft Excel files that have become corrupted and can no longer be opened. Key Requirements: - Expertise in recovery and repair of corrupted Microsoft Excel files - Proven background in data recovery projects - Possesses a good understanding of Microsoft Excel file structures and data - Ability to perform tasks without causing further data loss Here's a short overview of the issue: - The corrupted files were all made in Excel and I'm currently unable to open them Due to the nature of this work, discretion and confidentiality are critical. If you have the right skills and can handle this kind of sensitive project, let's talk. Your mission, should you choose to accept it, is to take these corru...
Seeking an experienced professional to provide data entry, copy pasting, excel work, typing, and processing of word documents. While the main focus is text data handling, a variety of other computer-related tasks may also be assigned. I Need: - Data entry: Inputting text data into a preferred system - Copy paste: Replicating and transferring data from various sources - Excel: Managing data and performing calculations or analysis if needed - Typing: Creating or editing text documents - Word document: Crafting and managing Word files effectively - Other: Additional tasks relating to computer skills Ideal Candidate: - Experienced in data handling tasks - Proficient in using Microsoft Excel and Word - Strong typing skills Freelancers should highlight their relevant pa...
We have 2 excel files. Where file nr 1 is having new article numbers for pricelist. File nr 2 has some of the same articles but not the new take the new prices on file 1 and update that same articles with new prices in file nr 2. And also transfer the articles that is not in file 2. This is express job and needd to be done today.
I am looking for a freelancer with expertise in Excel to type and arrange data precisely as provided. Specifically, here's what you would need to do: - Type text data onto an excel sheet - The data should be inputted in lists - The data should be arranged exactly as provided, not in any specific order Ideal applicants for this task have precision and attention to detail. Mastery of Microsoft Excel is also required to ensure accuracy in typing and data hold. If you take pride in meticulous work, I'd be thrilled to have you on this project.
I need your help to add the names of LLC owners to an Excel spreadsheet. The purpose of this is purely for identification purposes. The names should be sourced from public records and the final file format should be .xls. Ideal Skills & Experience: - Proficiency in Excel and data entry - Understanding of and experience with public records - Attention to detail in accurately transcribing names - Prior experience in legal or administrative data handling is a plus
I want a Power Automate workspace delivered that will ingest multiple images, convert the area specified on the image to columns in Excel. Sample files can be provided
For an upcoming task, I need a detail-oriented worker to parse data from around 400-450 resumes in PDF format into an Excel file. My task requires you to: - Extract specific information from each resume, specifically: contact information, work experience, educational background, and date of birth. - Accurately enter the data into a given Excel template, ensuring no data loss or misplacement. The ideally suited freelancer for this job should have: - Extensive experience with data entry and PDF manipulation - A meticulous eye for detail - A solid understanding of resume contents and structure If you possess these skills, and the task fits your abilities, please demonstrate in your application your relevant experience in similar roles. I look forward to receiving your bids!
I'm seeking a proficient and detail-oriented freelancer to execute a critical cleanup process on my Excel spreadsheet encompassing 1000 lines of data. This role requires the incumbent to perform the following tasks: - Sorting and filtering Name, Date, Number, Price, and Uber data fields - Identifying and executing operations on specific calculations – particularly focusing on sums The ideal freelancer should possess outstanding Excel literacy and a keen attention to detail. Proficiency in data management with an ability to identify trends, anomalies or data discrepancies is also crucial. Prior experience with similar tasks will give candidates a competitive edge.
I require the creation of an employee database focusing on fresh graduates with 2-3 years of experience in the Technology and Finance sectors. The database needs to be structured and delivered in an Excel spreadsheet format. It should contain the following information for each candidate: - Name - Education qualifications - Work experience details - Phone number The ideal freelancer for this project should demonstrate strong data entry skills and have a firm grasp of Microsoft Excel. A background in recruiting, HR or a related field, and knowledge about the Technology and Finance industries would be beneficial. Efficiency, meticulous attention to detail and respect for confidential information are also critical for this project. Prior experience in developing such databases ...
...Scope of work – Survey platform is an android based mobile application. Survey creation and management to take place on web. Survey Creation and Management: Should offer intuitive survey builder functionalities – Bulk Import of Choices: Streamline the creation of detailed surveys by allowing users to import extensive lists of options (SKU names, outlet names, brand, categories, etc.) directly from Excel or CSV files. Integrated Skip Logic and Branching: Utilize advanced conditional logic to guide respondents through customized paths based on their answers. This includes dynamically filtering choices for subsequent questions based on previous responses taking bulk imports into consideration. Question Types: • Invoice Scanning (employing third-party SDK, finaliz...
Immediate need for data entry specialist highly proficient in Excel. Your task will involve: - Web research to gather names of colleges, their respective majors and professors. Skills & Experience Required: - Proficiency in Excel and web research. - Accuracy and attention to detail. - Able to deliver high-quality work as soon as possible. Please note, you will only be gathering names, no additional information is needed. Bid now if you are ready to start immediately. So the task is to bring from the internet list of college, major, professor list for the missing one in the application. check the app in app store Professory app
I'm seeking an experienced professional who is proficient in Arabic and English for a data entry project. You will be inputting simple data in Excel form, such as names and addresses. The data is currently stored in digital files. Required Skills: - Proficiency in Arabic and English languages - Experience in Excel data entry - Attention to detail Experience with similar data entry projects before would be ideal. The Task we have an excel sheet which has list of professors for a Kuwait University, and we have images of the updates professor list. We want you add in the table the missing people from the images. Attached the excel sheet and the images. What you will do is, open an image check which major it is, then apply major filter in the sheet,...
I need a skilled professional to update my website's stock prices in real-time using excel. The project primarily involves: - Updating numerical data on my website - Ensuring accuracy and real-time updates - Using excel as the data source Ideal candidates will have: - Experience in data updating on websites - Proficiency in excel and data management - A good understanding of stock prices and real-time data management The goal of this project is to enhance the user experience on my website by providing accurate and real-time stock prices.
a single strategy via Excel so if you're interested then message me
More details: How would you like the PDF files to be named? This question was skipped Are there any specific formatting requirements for the PDF files? This question was skipped How soon do you need your project completed? This question was skipped
I have code for login trading accound and fetch token data. I need to update code 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 5 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 an intelligent programmer, who can see future problems and solve them clever and independently. 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 Budet is 600 INR and Good review,...
Address labels to be made Over 100 different addresses Font and layout should be all correct Addresses on excel spread sheet Label template will be provided and is on Microsoft word Labels made should not be duplicated
Address labels to be made Over 100 different addresses Font and layout should be all correct Addresses on excel spread sheet Label template will be provided and is on Microsoft word Labels made should not be duplicated
The project is an excel test. The attached file contains the test. It requires medium level skills. All the details are in the file More details: What specific calculations do you need to perform in Excel? Formulas to consider using - IF, VLOOKUP, SUMIF, SUMIFS, INDEX How familiar are you with using Excel formulas? Intermediate (comfortable with commonly used formulas) Which Excel features beyond basic formulas are you interested in incorporating? Pivot Tables, Conditional Formatting
I'm seeking a highly-skilled freelancer with a deep understanding of Excel for a data entry project. This is not your typical data entry job as it requires knowledge of complex formulas and data manipulation. Key Responsibilities: - Enter data from Excel spreadsheets - Create complex formulas within Excel - Use data manipulation techniques to ensure data integrity Ideal Candidate: - Advanced understanding and experience with Microsoft Excel - Proven experience with complex data entry - Attention to detail is paramount - Strong organizational skills - Ability to meet tight deadlines Join me in this challenging yet rewarding project and let's make a difference together.
I have code for login trading accound and fetch token data. I need to update more details incode 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 5 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. Automate the buy/sell Trade I need an intelligent programmer, who can see future problems and solve them clever and independently. 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...
Hi, I have 6 excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver. Using an excel model to adjust subcontracting and demand. Note: Need it done within the next 20 hours.
Necesitamos personas que cierren ventas de préstamos de Infonavit. Las comisiones se entregan de 15 a 22 días hábiles después de finalizar un trámite. Ofrecemos: •Trabajo 100% en línea (tú decides cuando trabajas). • 100% Comisionista (tú decides cuanto ganas). • Ganancias previstas desde 8,800$mxn hasta ...100% en línea (tú decides cuando trabajas). • 100% Comisionista (tú decides cuanto ganas). • Ganancias previstas desde 8,800$mxn hasta 44,000$mxn. • Excelente ambiente laboral. Responsabilidades: - Buscar, filtrar y cerrar clientes. Requerimientos: - No se requiere experiencia (nosotros te capacitamos). - Pasión por las ventas. - Habilidad para comunicarse tanto verbal co...
6 excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver
This take is to take a list of URLS (as in the URLS spreadsheet attached) and create a Power Automate flow to extract the following from each URL: • Previous Close • Open • Bid • Ask • Day’s Range The output should be in a separate spreadsheet (‘output’). In the sample ‘output’ file attached, this shows the result for ‘MMM’. Other URLs will follow. I should be able to run the Power Automate workspace at any point to scan the URLS. The URLS may change (added or removed).
Hello I do sales for a tobacco company and I need to enter all my sales for January February March. I need three different Excel files. All it is is the name of the store the amount that I sold and the address.
...concreto necesitamos: • Automatizar la exportación de datos de facturas emitidas (y su estado, canal de entrada, consultor asignado) y gastos, y preparación de los mismos desde HOLDED. • Automatizar la exportación de datos (presupuestos lanzados y vendidos, potenciales clientes y comerciales asignados) y preparación de los mismos desde HUBSPOT. • Automatizar la cumplimentación Excel de RRHH mediante un Excel que nos pasa la gestoría cada mes, con todos los datos de las nóminas y costes laborables de cada trabajador. *****Importación e integración de todos datos y modelado de un cuadro de mando en Microsoft Power BI con las siguientes funcionalidades: Facturación Mensual, anual,...
I'm seeking a freelancer with advanced Excel and Power Query proficiency to provide essential data extraction, transformation, cleaning, and combination services for an Excel Report. Qualified candidates must demonstrate: - Advanced understanding of Excel and Power Query - Experience in extracting data from diverse sources - Capability for cleaning and transforming data for optimal utility - Aptitude for combining data from various sheets effectively In your proposal, include details about your relevant experience. Your hands-on experience and proven record of similar projects will secure your success in this job.
As a busy professional, I'm on the lookout for an Excel pro who can assist in organizing my dataset of less than 1,000 rows. The data is moderately complex, with multiple columns of various types. The ideal freelancer will: - Have experience with Data Entry and Organization. This includes swiftly inputting data and structuring it for optimal accessibility and productivity. - Possess Data Analysis and Reporting Skills. I'm keen on meaningful insights from the data and require straightforward, compelling reports. - Excel proficiency is a must, with strong attention to detail, and ability to handle moderate complexity data. By bringing your advanced Excel management and analysis skills, you'll be delivering order to chaos, and helping drive more informed ...
...date, most recent, i dont want to have old people who dont work there anymore or invaild emails, i'll check for that Data Points to Include: Full Name of the HR contact or recruiter Their Position/Title within the company Gender (if available and relevant) Company Name Professional URL (e.g., LinkedIn profile) Contact Email Address Contact Phone Number (if available) Deliverable: A completed Excel or Google Sheets database that is well-organized and easy to navigate. Timeline: Please provide an estimated time of completion. I am looking forward to working with someone who has excellent research skills and a keen eye for detail. This project could potentially lead to further work if done successfully. When applying, please include examples of similar work you have comple...
See the attached File. Simple project here. If any of the words in column A, sheet 2 are in column D, Sheet 1, then delete the entire row (in Sheet 1) (Delete the entire row, not just the cell) No macros Likely conditional formatting, new rule is the best. This will be used on multiple files so it needs to be quickly applied. New words will be added to the list to filter for. The filter list can be added to each new file. No Macros Type :Sponge Bob" in your bid (to sort through the spammers) This should be a very low cost bid and delivered today.
I need an Excel expert who can craft 4 meaningful bar charts to visualize several health metrics. The foremost tasks required would include: - Visualizing perceived health data acquired from various sources namely, self-assessment questionnaires and participant interviews - Converting raw data of percentage changes in health into impactful insights using Excel It's pertinent that the freelancer has a good grasp of Excel and data visualization. A comprehensive understanding of health metrics would be appreciated, but not compulsory. Your role will aid in the better comprehension of health improvement or decline, ultimately guiding decision-making based on these observations.
I am looking for a skilled individual to create 4 bar charts in Excel for the purpose of showcasing percentage changes in perceived health over time. Key requirements: - Using perceived health data, generate 4 bar charts showing changes over time. Ideal Skills: - Proficiency in Excel - Understanding of data visualization - Ability to depict percentage changes in a clear and accessible manner. Please provide examples of your past work in your bid.
I need an Excel file created with text, numbers, and formulas. The data should be organized using rows and columns, across 6-10 tabs/sheets, and include pivot tables. Ideal skills and experience for this project include: - Advanced Excel knowledge - Experience in creating organized and visually appealing Excel files - Proficiency with pivot tables and formulas - Attention to detail and ability to follow specific instructions If you have experience with similar projects and can deliver a well-organized Excel file with the specified features, I'd like to hear from you.
...from an Excel file. The automation should be set up to run on Windows operating system using Power Automate. Requirements: - Automate creation of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in project management software I am looking for someone who can create a reliable and efficient automation system that can seamlessly...
I am looking to automate email sending through Excel. I have a list of email addresses and the same message to send to all recipients. However, there are certain conditions to consider: Firstly, as shown in the screenshot below, there are checkboxes with options (OUI ou NON) YES or NO. If the checkbox is marked with a "YES", the email will be sent. Otherwise, it will not be sent. Secondly, another condition relates to the frequency of email sending: Once a week Twice a week Once every two weeks Once a month I would like to establish an automated process that takes these conditions into account to send emails according to the specified parameters. Thank you for your assistance in implementing this solution." This version of the message is clearer and more precise,...
In t...business analytics and data visualization to achieve multiple objectives: - Identifying key trends and patterns - Making data-driven decisions - Enhancing data presentation and communication The primary data sources for this project will be Excel spreadsheets, social media platforms, and analytical software, such as PowerBI and Tableau. The desired insights from this project are specifically: - Analyzing closing prices - Gaining a clear perspective of the stock market trends Ideal applicants for this job should be highly skilled in use of Excel, PowerBI, Tableau, and social media analytics. A keen understanding of revenue performance, stock market trends, and closing price analysis is also crucial. Proficiency in communicating data-based insights effectively is ...
...addresses, phone numbers, and business addresses. The targeted businesses should be choose through a defined criteria: location and industry. Your responsibility will not stop there. You will also need to compile the acquired data into a well-organised Excel spreadsheet - ensuring information is accurately represented and easy to navigate. A meticulous attention to detail is vital in this role, alongside experience in similar data scraping tasks. Skills: - Experience with data scraping - Proficiency in collating and organizing data - Excellent Excel skills - Attention to detail - Familiarity with Shopify and Zomato platforms This is not a short-term project. I'm looking for someone willing to establish a long-term business relationship, maintaining and regularly...
I'm in need of an expert in VB/VBA development to assist with my software solution, primarily dealing with a scale system for a food company. Understanding Macola software would be highly beneficial. The core focus will be on: - Error fixing in current functionalities when they occur like label printing and commimocation errors - Developing and integrating new features into the system - troubleshooting errors as there arent many but I need the person to be able to support US EST (East coast US) hours The exact errors to address are not currently available, but a strong analytical mindset will be crucial in tackling this project. The ideal candidate should be knowledgeable in VB/VBA, demonstrate solid problem-solving skills, and have experience working with Macola softw...
I'm in immediate need of a Linux expert with advanced problem-solving skills to assist with multiple tasks involving CentOS. - The right professional should excel in troubleshooting and debugging, Linux server administration, and Linux programming. - As the tasks are of an advanced nature, a strong background in Linux systems, particularly in CentOS, is essential. - Prior experience with complex issues is a must. Your challenging role will involve locating and fixing faults, managing the Linux server, and coding in the Linux environment. - If you feel you fit this profile, please apply, detailing your previous similar experience. Your commitment to a streamlined and effective Linux operation will be welcomed here.
...of a VBA Excel expert to automate key aspects of my inventory management. The primary goal of this project is to create an effective material management system. Task Description: - Automate data entry and generate regular reports - Update inventory levels regularly - Implement an efficient inventory tracking system within the operation Key Feature: The main feature that this project should hold is inventory tracking. Inventory Tracking System: - The inventory tracking should be innovative, able to adjust stock depending on the inventory levels. - Implement an automatic reordering system that triggers when stock is low. This will ensure that the operation runs smoothly without the worry of running low on inventory. Ideal candidate: The ideal candidate should be a...
I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find
I need a skilled Excel data analyst to work on sales data. Requirements: - Experience: Please include your previous experience with similar data analysis projects in your application to be considered. Please submit your bids along with a summary of your experience in this field. I will share the specific data once we are in contact.
I have a black and white Excel sheet that dosent look Professional ... I need it to be Colorful and attractive
I need a data entry specialist to compile an Excel spreadsheet database of addresses and opening times relating to approximately 400 branches of the Citizens Advice Bureau. The data will be collected from URLs that I will provide. Ideal Skills and Experience: - Proficient in data entry and Excel - Experience with web research - Attention to detail - Ability to meet tight deadlines - Previous experience with similar projects is a plus This is an urgent project and I need it completed as soon as possible. Thank you.
