Calculation sheets different excel files macro jobs

I am in need of a proficient Excel Expert for data filtering and formatting. You must exhibit exceptional skills in the mentioned areas: - Filtering: Your role will include filtering my data sheets as per specific conditions. Mastery in this area is a must. - Formatting: I need my numbers formatted in a general fashion for proper import. Therefore, a comprehensive understanding of number formatting is necessary. This project requires advanced working knowledge of Excel and a meticulous eye for detail. For successful completion, you need to display exceptional proficiency in Excel's data filtering and a deep understanding of general number formatting.

...avoid backend work. These providers offer a user-friendly interface and pre-built connectors for various data sources, including Google Analytics 4, Search Console, and social media platforms. Here are a couple of options: • NoCodeAPI: Offers connectors for Google Sheets, Airtable, Google Analytics, Twitter, and more, allowing you to manage APIs without any backend code • Apipheny: Provides a list of free APIs for testing and an API integrator for Google Sheets, which can be useful for connecting different data sources without the need for backend development These services simplify the process of integrating various data sources into your application, making it accessible even for those with limited coding experience. • Tableau: Known

I'm looking for a meticulous data entry specialist adept at managing Excel files. Your responsibilities will include: - Copying and pasting information; - Organizing and cleaning the data; - Verifying the accuracy of the data. Specific skills and experience required for this project include: - Proficiency in Microsoft Excel; - Experience in data cleaning and organization; - Competence in data verification. Your objective will be to manage and improve the overall quality of our Excel data and to carry out your tasks efficiently. Consideration will be given to freelancer applicants with proven track records in similar projects.

I’m looking for a freelancer with expertise in importing data from Google Sheets into Wordpress. I am launching a large new website on a new domain and I have information on 2,357 government programs in a Google Sheet. My Google Sheet is structured as follows: - Rows: There are 2,357 rows. Each row is a government program. - Columns: There are 21 columns. Thirteen of the columns contain text information on each government program; 8 rows contains tags for each government program. A sample of the Google Sheet is here (note: this is a sample of 100 rows. There are 2,357 rows in the complete sheet): You can see an example of how I want the post laid out here (I own this website and previously

I’m looking for a freelancer with expertise in importing data from Google Sheets into Wordpress. I am launching a large new website on a new domain and I have information on 2,357 government programs in a Google Sheet. My Google Sheet is structured as follows: - Rows: There are 2,357 rows. Each row is a government program. - Columns: There are 21 columns. Thirteen of the columns contain text information on each government program; 8 rows contains tags for each government program. A sample of the Google Sheet is here (note: this is a sample of 100 rows. There are 2,357 rows in the complete sheet): You can see an example of how I want the post laid out here (I own this website and previously

I’m looking for a freelancer with expertise in importing data from Google Sheets into Wordpress. I am launching a large new website on a new domain and I have information on 2,357 government programs in a Google Sheet. My Google Sheet is structured as follows: - Rows: There are 2,357 rows. Each row is a government program. - Columns: There are 21 columns. Thirteen of the columns contain text information on each government program; 8 rows contains tags for each government program. A sample of the Google Sheet is here (note: this is a sample of 100 rows. There are 2,357 rows in the complete sheet): You can see an example of how I want the post laid out here (I own this website and previously

I'm in need of an expe...main features of the app should include: * Cost Calculator: This feature will be designed to estimate moving costs. Users will be able to select pre-defined item categories, making it easier for them to calculate a near accurate moving price. * Moving Company Reviews: Users should be able to read reviews and rate different moving companies within the app. Prospective developers should have previous experience in developing Android apps and incorporating features like cost calculation modules and review systems. A portfolio of related work will be highly valuable in the selection process. Those with a keen eye for user-friendly design will have a definite advantage. With your help, we can make the moving process easier and more enjoyable for i...

Work requirement is to work on excel files to get DCF working

As an organization with multiple employees, we need an expert to perform a detailed audit of approximately 400 of our staff files with a keen eye for detail. Your task would involve verifying existing documents, ensuring that the necessary onboarding documents are present in each file, and noting where they are not, in an organized spreadsheet. The ideal freelancer for this task would have: - High attention to detail - Previous experience in Human Resources and Compliance - A working understanding of necessary onboarding and compliance documentation - previous audit skills are of benefit To be audited: each file should contain: - Employment contracts - Identification documents - Compliance documentation e.g. First Aid Cert, NDIS Worker Screening Check - Recruitment documentati...

This project is about creating a professional yet creative business profile (information memorandum) for a business brokerage, powered by an easily updatable Excel back-end. I'm looking for someone with strong document design and spreadsheet expertise. At the moment we have the attached document that is both out of date (design wise) and requires 100% data input from staff. I am wanting a document that answers can be imported directly from excel. The generated profile will be about 20-25 pages long and include approximately 60 distinct data fields, these fields will be collected from each client and answers stored in an excel sheet. The idea being - we need a beautiful document that can have easily duplicated merge fields. - Company name and summary - Address...

I'm seeking a talented graduate graphic designer capable of creating an appealing, bright, and colorful...And for version two upload it to a standard free media player so subscribers can get it into email. This needs to be print ready and i need fast turn around with few if any back and forth questioning. - Strong grasp on modern design principles and decisiveness - Ability to translate both informal and professional tones visually - Ability to engage with a young, professional demographic To excel in this task, ideally you will have: - Prior experience in designing for print media especially newspapers - Ability to deliver innovative and playful layouts minimalistically - Fluency in Adobe Creative Suite or similar tools I look forward to seeing your fresh, dynamic, and ...

We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.

I need an expert to modify my existing Excel spreadsheet and transform it into a fillable PDF form. The interactive form will contain a description field, checkboxes, date field, price fields, perhaps one calculation but that isn't necessary. I have attached a sample of the excel file. There may be a few changes. Does this sound like something you can do? Here's what I'm looking for: - Ideal Skills: Extensive experience with Excel and PDF form creation is a must. - Experience working with custom fonts and graphics that will need to be duplicated onto the form -Experience: Please include any previous work involving the conversion of an Excel file into a fillable PDF form. Please note that the data that needs to be captured in the fo...

Looking for a professional financial analyst adept in scrutinizing balance sheets. - Your primary task will be financial statement analysis, specifically focusing on the balance sheet. - Proficiency with Excel spreadsheets is crucial as all data will be provided in this format. Ideal Skills: - Comprehensive knowledge of financial statement analysis - Expertise in Excel - Proven experience in financial analysis, particularly balance sheets. The perfect freelancer will have a keen eye for detail and the ability to draw insights from financial data. Budget is 50$

I need assistance in creating a VLookup formula in Excel to fetch matching data from another worksheet. Having already identified the columns, the formula should be designed to fetch data from the specified columns. Freelancers with extensive experience in Excel formulas and in particular, the creation of VLookup functions, are highly preferred. Knowledge, skill, and proficiency in Excel spreadsheet manipulation are essential.

Go over two excel sheets and highlight records from first sheet containing specific text from the second sheet

...statement from PDF to Excel. There are 4 bank accounts, from 2017 to 2023 - totaling 159 files in PDF. - 2 accounts from Santander - 2 accounts form Caixa Economica Please find attached 2 PDF files as an example. For Caixa Economica statements, there are only 2 PDFs (one for each account). For Santander, the PDFs are divided by month. Details: - Critical data fields to be extracted include: transaction date, transaction description, transaction amount, number of destination accounts for PIX, TEDs and DOCs (bank transfers), and account balance. Ensure accuracy in these fields during conversion. - The Excel spreadsheet should have 4 tabs, one for each bank account. - The converter should be designed to handle non-protected PDF files. No provision fo...

I am in need of a proficient Excel expert for some unknown tasks. Since I haven't detailed the specifics, I would like potential freelancers to be adept with: - Formulas and calculations - Data analysis and reporting - Data manipulation and formatting Whether it's creating a new spreadsheet or modifying an existing one, I will need help. Therefore, display adaptability and experience in various Excel scenarios. Your application should include past work, experience and a detailed project proposal despite the brevity of my requirements. Please provide as much detail as possible in your proposal, due to the unspecified nature of the tasks.

I'm seeking a skilled Excel user for formula automation and chart creation in my project. Your role includes: - Creating Excel formulas that automate various functionalities. - Incorporating charts into the spreadsheet to visually represent the data. Although the specific type of charts hasn't been specified, a proficiency in creating diverse types of charts (including bar, line, and pie) will be advantageous. A strong understanding and experience with Excel formula automation and data visualization are essential for this task.

Please create 3d printing files similar to the following for me: 1. 2. 3. (butterfly, AND

I'm in need of an expert with proficiency in Excel and Quickbooks. An Excel spreadsheet needs to be created. The data dump will be provided, your task will be to extract specific information from it. The needed data includes: - Sales data (Date and Customer name, Amount and units sold) - Expense details (Date, Vendor name, and rental paid per unit) Need various information to be in one place and one click. The extraction process must be automated and compatible with Quickbooks for seamless integration. The ideal candidate should have experience in data extraction, Microsoft Excel, and Quickbooks, as well as exemplary accuracy skills to ensure the data is free from mistakes.

I am in need of an expert who can effectively import complex Excel sheets into MS PSA Project Service for a more consolidated and efficient approach to data management. Key Deliverables: 1. Importation of Excel Sheets: - This includes financial data, project tasks, and resource allocation. Your experience in managing and handling these types of data is crucial. 2. Data Structure: - I require all Excel sheets to be consolidated into a single worksheet. Your knowledge in navigating MS PSA Project Services and Excel will be important to ensure that the data will be structured correctly and in a user-friendly way. 3. Permissions: - Every group should have full control over the project's MS PSA, including viewing, editing, and deleting...

I am seeking a freelancer who excels in using Excel to manage large data sets. You will need to perform specific tasks, including: - Data Filtering: Skilled in using various Excel functions to sort and filter large amounts of data. - Basic Arithmetic Operations: Proficient in performing addition operations on the data set. - Statistical Analysis: Capable of conducting descriptive statistical analysis on the data provided. The ideal candidate possesses an excellent command of Excel, and a strong background in statistical methodologies.

Please Sign Up or Login to see details.

I need to redevolop a simple shopping cart based on Excel VBA. Requirement is to rework current design and function. I prefer developer that can with russian and english language, as this would help get some information from former versions. Pls contact me. BR Michael

I am seeking a proficient graphic designer to convert JPEG images into high-quality vector files to improve print quality. I have included the designs, I need the graphics to be turned into vector and the text in an editable format. The word 'STAMTECH' is to be replaced by the 'VINAYAK' on every design with the same font as in the design. Final delivery requirement: 1. All designs to be converted into vectors. 2. Editable text file to be provided 'Preferably .CDR file (version 18 or below) 3. Provide fonts also

I am looking for a dedicated and skilled professional to fill the role of a virtual voice and messaging assistant. Key Responsibilities: - Primarily, you will be tasked with answering customer queries with clarity and precision. - Additionally, you should be able to carry out typing tasks with a quick turnaround time. Required Skills & Experience: - To excel in this role, you should have a strong background in customer service, with exceptional verbal and written communication skills in Spanish. - Experience in related roles, especially as a virtual assistant, is highly desirable. This role will require a firm understanding of my business and the ability to represent it effectively to our clients. If you can handle these tasks competently and professionally, I am eager to he...

I'm looking for a talented graphic designer to create a bold, colorful artist one-sheet for me. The primary focus of the sheet should be my contact information. Key Project Requirements: - Use a bold and colorful design aesthetic - Prioritize the prominence of my contact information - Deliver the final version in JPEG format Ideal Skills for the Job: - ...artist one-sheet for me. The primary focus of the sheet should be my contact information. Key Project Requirements: - Use a bold and colorful design aesthetic - Prioritize the prominence of my contact information - Deliver the final version in JPEG format Ideal Skills for the Job: - Strong grasp of color theory and bold design - Experience in creating artist one-sheets or similar documents - Proficient in working w...

I have to create an exe which contains data in gridview and the data also contains the path of the image. And all the images are saved inside the folder. Whose path is given in the database record. So I have to export excel from gridview. I have attached the files as an example, you can prefer that.

I am looking for a dedicated individual who has strong research skills to find companies on the inte...include: - Identifying such companies - Gathering specific information about them including sales revenue, company name - Collecting their contact details: name, phone number, and email address Ideal candidates for this task will possess the following skills: - Strong research and data entry capabilities - Sound understanding of e-commerce, retail, and manufacturing industries - Proficient in MS Excel or similar data management tools - Exceptional attention to detail to ensure accuracy of gathered data - Excellent communication to report findings promptly. This job requires devoted attention and precision. Please bid if you consider yourself an astute researcher with an eye f...

I am in need of an accounting expert with a minimum of 3 years experience to handle bookkeeping, accounts receivable and accounts payable tasks. The ideal candidate should have excellent proficiency in Excel, Microsoft Access and Netsuite. Your responsibility will include: - Maintaining and updating financial records, invoices and receipts - Performing accounts receivable/payable duties - Handling any other task that involves Excel, Microsoft Access or Netsuite. Strong attention to detail, problem-solving skills and knowledge of accounting principles and laws are required.

As an experienced user of AutoCAD bricksCAD, I am looking for an Autolisp programmer adept with the creation of tailor-made commands to enhance my workflow. Key tasks form the scope of this assignment: 1. Creating a basic electrical single line diagrams using interaction between excel data and predefined blocks in bricksCAD such as transformer, breaker, main switch board, distribution board, busbars,other electrical components.

Develop Excel template for inputs

...thrives on getting everything in order and has the ability to make Excel sing. As an experienced data entry individual, you will be tasked with the following: - Sorting and organizing data into meaningful, easily navigable formats - Mastery in crafting complex formulas to make excel work its magic - Examining and validating data meticulously to ensure cleanliness and accuracy Your extensive experience with handling numerical data, specifically sourced from online platforms, is crucial for this project. Mention your proven track record and provide specific examples of past projects in your application. Show your competence with handling online-sourced data and how you leveraged it to create insightful and efficient Excel documents. Prove to me you can take comman...

I need an expert to swiftly automate my lead nurturing process on Google Sheets utilizing Pabbly Connect. Responsibilities: - Develop an automated system for data entry of leads. This will involve manual entry of data fields per lead (Name, Email, Phone Number). - Design and execute an email automation scheme to engage these leads. - Integrate follow-up reminders within the system. The ideal freelancer should have: - Proven experience with Pabbly Connect and Google Sheets and WhatsApp API and automation - Understanding of effective lead nurturing strategies - Proficiency in data entry automation and email marketing systems I look forward to working with someone who can efficiently optimize my lead nurturing process using these tools.

We are seeking an experienced freelancer proficient in process management and organizational workflows to develop an enhanced new hire onboarding process template in an easy to edit format (Excel, canvas, powerpoint) with a focus on optimizing the HR team's roles. Key Responsibilities: Design and implement a comprehensive workflow that streamlines the new hire onboarding process, specifically addressing the tasks performed by the HR team across different stages. Department Talent Acquisition Team: Screen Candidates Manage the Interview Process Extend Offers Manage Pre-Screening Process Provide First Day Instructions Initiate Pre-Onboarding Packets for Candidate Completion Monitor Completion of New Hire Paperwork Monitor I-9 Section 1 & 2 Completion on First Day C...

I urgently need an expert in automation with a good understanding of Excel and Notepad files to streamline my data entry process. The aim is to allow for efficient and error-free data input to reduce the amount of time I spend manually entering data. Job Requirements: - Creation of an automated system for data entry tasks - Ability to process text input and numeric input - Capability to input data pulled from other files Skills & Experience: - Proven experience in automating Excel and Notepad processes - Strong knowledge of data input methodologies - Exceptional attention to detail and accuracy - Proficiency in creating secure and reliable automation systems - Ability to deliver work promptly Please note, this project is time-sensitive. Therefore, ...

I require a professional with vast experience in data cleaning using Excel. My numeric data, currently less than 1000 records, needs some tidying. Key tasks include: - Removing duplicate entries. - Handling any missing values. - Correcting any inconsistent entries. Proficiency in Excel data tools and understanding of data cleansing methodologies are important. Candidates who have worked on similar projects will likely provide a faster turnaround.

I need an expert in Excel reporting and MIS dashboard creation to analyze and visualize my sales leads data and conversions, need to add all formulas where it I put in the team deatols with their leads and conversions and it automatically gives me the stats eith pie focus areas for tracking would be: - lead generation daily - Revenue - Sales daily Few more parametees Key requirements are: - The ability to handle large volume of data - Efficiency in creating automatic update processes, as the report and the dashboard should update daily when data comes in - Strong understanding of sales and financial metrics - Precision, accuracy, and attention to detail The ideal freelancer would be fast, reliable, and have an outstanding record in Excel and data visualization. Experien...

I am in need of a proficient and meticulous data-entry specialist who can confidently manage text, numbers, and dates in an Excel spreadsheet. The exact volume of columns and rows is yet to be determined, but efficiency and attention to detail will be key. Additionally, the ability to potentially create a working template may be required, as this decision has not yet been finalized. Therefore, experience with Excel template design is desirable alongside robust data-entry skills.

For my project, I am seeking a meticulous freelancer with strength in data entry. Here's what the task involves: - Entering text-based data sourced fro...strength in data entry. Here's what the task involves: - Entering text-based data sourced from various online resources. - Accurately translating the information provided into an Excel spreadsheet format. The ideal candidate should possess solid data entry skills, attention to detail, experience with Microsoft Excel, and an ability to efficiently surf the web to locate crucial data. A basic understanding of the privacy concerns associated with handling online data will also be advantageous. In summary, I need an efficient individual who can quickly turn online text-based data into ordered and professionally fo...

Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, minitab, quantitative and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood

... ## System Requirements ### Admin Features 1. **User Management** - **Description**: Admins can create and delete user accounts, managing access levels within the application. - **Functionality**: Includes forms for entering user information and mechanisms for account deletion. 2. **Lead Management** - **Description**: Admins can upload leads from Excel files or enter them manually into the system. - **Functionality**: Supports Excel file uploads and manual data entry forms. 3. **Email Notifications** - **Description**: Automatic notifications are sent to admins whenever a new lead or user is created. - **Functionality**: Integrates with an email service to dispatch notifications. ### User Features 1. **Dashboard Customization** - **Description**: The u...

...features: - The primary focus should be on buying new homes. Understandably, users have a variety of needs when it comes to home loans. I'm specifically interested in seeing functionalities that cater to new home buyers. - Property-specific. I am planning to buy a detached house. The solution should therefore have features that are tailored to purchasing this type of property. - Mortgage Calculation. I also need the system to include a mortgage calculator to simplify the process for users by giving them an idea of potential monthly payments. Ideally, developers bidding on this project should have prior experience in building similar systems. Experience in finance, real estate or similar fields is a plus. Proficiency in creating user-friendly interfaces and performing com...

I am seeking a dedicated and experienced VBA developer to build an inventory management software that tracks both physical and digital...Features Required: - Inventory Tracking: The system needs to provide accurate and updated record of both physical and digital goods. - Purchase Order Management: An automated reordering function based on predefined parameters is paramount for the efficient operation of our procurement process. The ideal freelancer should have a strong background in building inventory management systems with Excel VBA as well as in-depth knowledge of automated reordering functionalities. This knowledge is critical in order to assure the success of this project. It's also expected that the candidate is proactive and asks any needed question to parse requireme...

I'm looking to collect specific details about farms in the Western Cape. The information will be used for market research purposes and should be perfectly structured in Excel format. Required data include: email & Cell number Experience in data collection, particularly in the agricultural sector, is preferred. Strict attention to detail and high proficiency in Excel are very much required. Knowledge about crops or livestock is advantageous due to the nature of data to be collected. It must be automated.

My project involves three key areas: photo editing, floorplan creation, and NEN2580 measurement...Photo Editing: Freelancer should exhibit proficiency in color correction, background removal, and retouching. Sample works may be required for evaluation. - Floorplan Creation: Must proficiently create room layout, including room dimensions and furniture layout, providing a useful visualization of the space. - NEN2580 Measurement Reports: The freelancer needs to accurately perform total area calculation, offer a detailed floor area breakdown, and measure external spaces. Knowledge and experience in Dutch NEN2580 standards are integral for this role. Ideal candidates should have a solid background in photo editing, architectural design, and understanding of Dutch NEN2580 measurements ...

...collaborate on files or to create and manage lists of information. Create a Team or Communication Site (Video) Create a Site in SharePoint Explore Your Team Site (Video) Move or Copy Files in SharePoint SharePoint Features SharePoint provides a means for shared access, interaction and collaboration among peers. Facilitate teamwork that occurs anywhere and anytime quickly, reliably, and securely by learning more about the following features: Use, Filter, and Update a SharePoint List (Video) Manage Large List and Libraries Restore Items in the Recycle Bin that were Deleted from SharePoint (Video) Add or Remove a News Post (Video) Create a Page (Video) Collaborating in SharePoint With Office and OneDrive or SharePoint, multiple people can work together on a Word document, ...

I need to know if there is a way to automate a process to transfer data from an excel spreadsheet to an organization chart in Visio. Or a way to validate the data that is on an excel spreadsheet matches what is on an organization chart and show any mistakes

I am seeking a skilled Excel specialist to create a sophisticated and intuitive spreadsheet that serves as a project management tool. The spreadsheet must include the following specific features: - Project Tracking: The main feature I need is the ability to track the progress of multiple projects. Main Aspects: - Milestone Achievements: The spreadsheet must enable tracking of various project milestones. It should notify when a milestone is due and when it is achieved. - Task Deadlines: Deadlines for each task must be clearly displayed and flag whenever a task deadline is approaching or missed. Visual Representation: - Progress Bar: The progress of each milestone contained within a project should be visually represented using a progress bar. - Color-Coded Cells: Milestones a...