How to link two excel files in sharepoint 2013 jobs
Proposal and Proof of Work Requirements for Dynamic Excel Sheet Development We are seeking an experienced Excel developer to create a dynamic, visually appealing, and proprietary tool for our loan officers. This tool will enable our team to present purchase and refinance scenarios to clients, offering detailed calculations, comparisons, and insights. It should reflect Cohen Mortgage branding, include precise mortgage insurance premium calculations for different loan programs, and be protected to maintain its proprietary nature. Project Scope and Features: 1. User Data Entry Inputs: - Property address - Purchase price - Down payment percentage - Loan amount (calculated automatically) - Interest rate (fixed or adjustable options) - Loan term (e.g....
I need an Excel Catalogue converted into a visually appealing, professional PDF Catalogue for customer showcase, print and online publication. Key Requirements: - Transforming an Excel Catalogue into a PDF - Designing a professional and formal layout - Incorporating product images, detailed descriptions, and pricing information - Image high resolution Ideal Skills: - Proficient in Excel and PDF design software - Excellent graphic design skills - Experience in creating product catalogues Please only apply if you can demonstrate a strong portfolio in similar projects. The file work on is in this google drive link: Please give me your best quote
Fashion Spokesperson 1) emails to PR company 2) buyers meetings 3) coordinate photo shoots 4) have a uk passport and right to work in uk 5) available to travel for work trips Requirements: 1) Uk passport holder 2) Should be excellent at writing emails and conveying the exact message 3) Should be able good at Microsoft work – excel,google drive, we transfer 4) Assist me back stage for fashion shows 5) Good communication skills to talk and convey clear points across on my behalf 6) Needs to sign NDA 7) Available to attend relevant meetings to assist me
...students in XXX between May-July, 2024. Registered and attending classes in the 2023-2024 spring semester at state universities in XXX, to be a 3rd and 4th year student in the nursing department and students who volunteered to participate in the study were included. 2.2. Data Collection Tools It used the “Student Identification Form", “Casey-Fink Practice Readiness Scale", “Student Self-Efficacy Scale”, and “the Nursing Students’ Perceptions of Clinical Stressors Scale” (NSPCSS) as data collection tools. 2.2.1. Student Identification Form This form consists of seven questions, including age, gender, marital status, class, family income, family type, and the students' desire to...
I'm seeking a beginner-level assistant for my regular work. Your primary tasks will involve conducting research and creating simple PowerPoint presentations on given topics. Key Responsibilities: - Researching topics and creating simple PPTs - Managing existing team, project and content in excel or in team management app Skills and Experience: - Proficiency in Excel and PPT and notion or project management software Ideal Candidate: - A college student with a working computer - Looking for long-term work - Flexible with working hours Please note: - We will connect over a call on Saturdays or Sundays for planning and learning sessions.
I'm seeking a Power BI expert to create a simple model from a small dummy dataset which will be provided. Need this completed as soon as possible. The model should generate reports for trial balance, cash flow, balance sheets, and P&L from a small dummy dataset in Excel which will be provided. Key Requirements: - Create visually appealing and informative reports using charts and tables. - Highlight specific metrics and KPIs, namely revenue growth, net income, and cash flow status. Ideal Skills and Experience: - Proficiency in Power BI, with a strong portfolio of similar projects. - Excellent understanding of financial metrics and reports. - Ability to create engaging visual elements.
Update the Products weight on my website from the Provided Excel file.
Excel VBA Macro Debugging - Compiler Error Fix I'm encountering a compiler error while running a macro in Excel VBA. The macro is primarily designed for data manipulation and includes various functions. I need assistance to diagnose and fix this issue so the code can run without errors. Ideal Candidate: • Extensive experience with Excel VBA and macros. • Strong troubleshooting skills to resolve compiler errors. • Proficiency in data manipulation using macros. • Ability to maintain existing code functionality while fixing errors. Important Instructions (Read Carefully): 1. To Be Considered: You must resolve the error and provide the complete, functional code. I will test the code, and payment will on...
We are looking for companies with expertise in various Microsoft Technologies for a long-term partnership. Key Technologies: - Dynamics CRM - Azure - SharePoint - Dynamics 365 BC - Power Platform - .Net - Microsoft AI Application Instructions: Please start your application with "We are specialized in Dynamics CRM,....[tech stack 1],[tech stake 2... listed above]" and "we are based in [State],[Country]." Has to be in which tech you are specialized. Important Note: - Responses generated by AI will be eliminated immediately. - If you don't fit to budget, avoid applying Ideal Skills: - Deep knowledge of the listed Microsoft Technologies. - Strong software development capabilities. - Experience in long-term ...
I'm looking for a skilled professional to automate the generation of historical data reports for NSE Nifty option contracts. The primary purpose of this automation is to facilitate report generation, which should be delivered in Excel format. The reports need to be generated at very specific intervals—every 5 minutes. Ideal candidates for this project should have: - Proficiency in data automation tools and programming languages such as Python or R - Experience with financial data, particularly options contracts - Excellent skills in Excel and report generation - Ability to deliver work on a tight schedule In your proposal, please provide examples of similar projects you have completed.
Trasfering arabic information in PDF to Excel data Manually (Example attached). This project for arabic speakers only
I need an Excel Catalogue converted into a visually appealing, professional PDF Catalogue for customer showcase, print and online publication. Key Requirements: - Transforming an Excel Catalogue into a PDF - Designing a professional and formal layout - Incorporating product images, detailed descriptions, and pricing information - Image high resolution Ideal Skills: - Proficient in Excel and PDF design software - Excellent graphic design skills - Experience in creating product catalogues Please only apply if you can demonstrate a strong portfolio in similar projects. The file work on is in this google drive link: Please give me your best quote
I'm looking for a dedicated professional to assist me with various data entry tasks. Key Responsibilities: - Inputting data into spreadsheets - Managing databases - Providing transcription services Ideal Skills: - Proficient in Microsoft Excel - Experience with Spreadsheet data input, Database management, and Transcription services - Attention to detail and ability to work independently.
...construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create...
...setting up our SharePoint Online Document Library. The task involves configuring permissions for two groups based on metadata attributes of each document. Key Requirements: - Set permissions for two groups to view or not view documents based on metadata. - Metadata types include Document type, Department, and Confidentiality level. - The primary metadata determining viewing permissions is the User Type. User Access: - The Document Library will cater to both internal employees and external partners. Metadata Definition: - The library owner will manually define the metadata for each document. - Ideal skills include proficiency with SharePoint Online, experience with setting permissions based on metadata, and good understanding of document mana...
I am looking to build a relationship with a reliable online P.A., so that, as my business grows, and becomes busier, you will be able to handle the increased amount of Admin duties. This will allow me to focus on my performances and event production, coordination and management. This will be an on-going, long term relationship. We will be developing and improving these processes as we go. This is mostly an ‘as needed’ / freelance / casual opportunity. The hours are NOT guaranteed. There will usually be 2 - 4 hours per week of work every week. There are on-going tasks which can be done when you have finished the admin tasks that require doing that week. These on-going tasks will ensure that you can usually have 2 – 4 hours work each week. But if...
Cricket ball Logo. I have between 4 low-quality PNG images that need to be transformed into high-quality, editable CDR (CorelDRAW) files. These files will primarily be used for printing, so they need to match the originals closely with sharp edges, clear details, and scalability for print. Key Requirements: - Skilled professional with experience in creating vector designs. - Special attention needed for text elements within the PNG images. - Timely delivery of the completed project. - Can suggest more enhanced designs Please include samples of similar work you've completed in the past.
I have several PDF files I’ve converted to DOCX. There is a total of 143 pages. Each file contains subtle errors and formatting issues that need to be corrected. I need someone with a keen eye for detail to go through the original PDFs and compare them to the Word documents to spot and correct discrepancies. The primary type of content in these PDFs is textual documents. You should expect to encounter: - Font style and size inconsistencies. The corrections should be marked as follows: - Using 'Track Changes' in Word. Ideal Skills and Experience: - Excellent command of English language. - Prior experience in proofreading and formatting. - Proficient in using Microsoft Word, particularly the ...
...I need assistance in verifying the completion of 22 Python coding assignments by my students. The assignments are at a very beginner level and are located in Python/Jupyter notebooks. Your task will be to check that each student has completed their respective assignment. There is no need to grade the submissions for accuracy, simply confirm whether each assignment has been completed or not. Requirements: - Provide each student's name and their corresponding grade on a separate sheet. - The format of the student names and grades can be in any form (Excel spreadsheet, CSV file, or even handwritten/scanned). - No specific comments are required on the assignments, just a confirmation of completion. - Results can be organized in any ord...
...help me streamline our HR processes using Microsoft Forms and Excel. The main aim is to utilize Microsoft Forms for case raising, where employees can report various issues. Key Responsibilities: - Set up Microsoft Forms for case raising - Utilize Excel to track each client, employees, auto send email notification with a unique ID - Implement direct data import from Microsoft Forms to Excel and a dashboard -Excel dashboard for clients and employees Ideal Skills: - send email via outlook to each client absence data weekly -Excel invoice system - Save files auto from email to drive or excel - Proficiency in Microsoft Forms and Excel - Experience with HR processes - Ability to crea...
I'm looking for an expert in Excel who can help me analyze some racing data. The main tasks will be comparing performances and identifying trends. Ideal skills and experience for the job include: - Proficiency in Excel - Experience with data analysis - Knowledge of racing data is a plus.
...Google for National Facility Management Companies in the U.S. Description: We are looking for a skilled freelancer to scrape Google and compile a comprehensive list of national facility management companies operating in the United States. The goal is to identify businesses similar to the following examples: • The Centurion Group • Broadway National Deliverables: A complete list of facility management companies, including the following information for each company: 1. Company Name 2. Website URL 3. Phone Number 4. Email Address 5. Headquarters Address (if available) 6. Other Relevant Contact Information (e.g., contact person, LinkedIn profiles) Requirements: • Scrape Google, business directories, or other publicly available r...
I'm seeking a professional to assist with my eBay listings and dropship product sourcing. Your tasks will include: - Locating Amazon U.S. suppliers for specific product categories - Extracting dropship products into an Excel spreadsheet - Creating custom eBay template descriptions - Optimizing draft listings and making auction posts live The ideal candidate should have prior experience with eBay product sourcing and listings, and be proficient in Excel. Understanding of product categories and ability to create appealing product descriptions will be a plus. Your primary focus will be on specific product categories, so familiarity with these categories will be beneficial. You will need to extract the following information for each dropship p...
I have multiple Excel files that contain customer details such as name, address, suburb, postcode, and telephone number as part of delivery manifests for a freight provider. I'm looking for an Excel expert who can help me consolidate these files into a single, clean customer database. There are approximately 75 separate excel files and about 600 customers. Key Tasks: - Extract contact details from all files - Merge all files into one without duplications - Count and record how many times each customer appears across the separate freight manifests The final merged file should be in Excel format and include the contact details along with an appearance count for each customer. Ideal Skills & Experience: ...
I'm looking for an Excel wizard to craft a reconciliation tool for two payment datasets - our Genie Ledger and Payment Gateway Data. Key Tasks: - Identify critical data fields for reconciliation, focusing on Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a user-friendly tool that compares both datasets and displays all calculations on a dedicated front cover sheet. - Spot any discrepancies and highlight them in red on the front cover sheet. Ideal Candidate Should Have: - Extensive experience with Microsoft Excel, particularly with macros and VLOOKUP. - Strong analytical skills and attention to detail. - Ability to present data clearly and in a list format. I need a straightforwar...
I'm looking for a web interface to help soccer coaches and parents track player training progress. This platform will monitor multiple soccer and kinesiology metrics, providing a comprehensive view of each player's development. The dashboard will need KPI summaries, time-series trend analysis, peer comparison charts, and gamification widgets. The goal is to deliver a storytelling-driven experience that cleanly displays each player's progress, compares them to peers or bio groups, and helps parents and coaches quickly get actionable insights. Key Features: - Tracking of various soccer and kinesiology metrics - User-friendly interface for coaches and parents Ideal Skills: - Figma Design - Web Development - Data Integration - User Interface Design Your d...
I will migrate blogs from the old website to the new website, add the AdSense feature to WordPress, and change a link.
Features 1. Announcement Broadcasting • The bot will allow admins to send announcements with text, images, or videos. • Admin Command: /send • After using the command, the bot will: 1. Prompt the admin to input the message and attach any media (optional). 2. Ask if the message should be sent immediately or scheduled for later. • For scheduled messages, the admin specifies the date and time. • Once the broadcast is sent: • The bot generates an Excel report showing: • Total number of recipients. • Names and usernames of users the message was delivered to. 2. User Management • The bot will keep a record of all users who activate it. • Admin Command: /users • Generates an...
We have an existing Google Sheet that we want to turn into an Excel Sheet, but when we download it and open in excel the formulas to not come with it properly. Wanted to see if y'all could help us with it?
...assistance in collecting and organizing product information for a new online store. I have a spreadsheet with 2475 product lines distributed across five suppliers. Each product line includes a direct URL to the supplier's product (search) page. Your task will be to extract product images, descriptions, and any relevant details from these pages. If a product is no longer available, it should be skipped, and this should be noted in the spreadsheet. Supplier Breakdown: Casu: 136 products DCT: 327 products Kama: 294 products Max Fritid: 1169 products Movera: 545 products Deliverables: Structured Data: Use the provided Excel sheet and fill in the designated columns with extracted information, including: 1) Product Name 2) Description 3) Produ...
I need an expert in Microsoft Power Automate and C# to help me automate my weekly email process. Currently, I manually prepare emails in MS-Word, pulling customer data from MS-Excel, and sending through MS-Outlook using mail merge. I utilize 25 different email accounts, sending 2000 emails from each account to my customers, with the content being a price list with images. I want a system that automates this process. The emails should be sent from the 25 accounts to the customers from the Excel file automatically, with each account sending out 2000 emails. Skills and experience required: - Proficiency in Microsoft Power Automate - Experience with C# for custom scripting - Familiarity with mail merge in MS-Word, MS-Excel...
I need a SharePoint site designed as an Intranet portal primarily for external partners. The site should incorporate functionalities such as file sharing and project management tools. Key Requirements: - Design a SharePoint Intranet portal - Implement file sharing capabilities - Integrate project management tools into the portal Ideal Skills and Experience: - Proven experience in SharePoint site design - Strong understanding of project management tools - Ability to create user-friendly, secure, and efficient portals for external collaboration.
I'm seeking a Python developer proficient with the Deepgram API to create code that extracts VAD variables from WAV files. The extracted data should be displayed against the corresponding sound files. Key Requirements: - Implement using Python, as it's my preferred language for this project. - Use the Deepgram API to extract VAD variables. - Include Speech-to-text transcription in addition to the VAD variables. Ideal Skills: - Deepgram API experience - Python programming - Audio processing knowledge - Speech-to-text transcription skills Please note, I will be providing WAV sound files for this project.
I'm seeking a meticulous freelancer for manual data entry tasks. You'll be working with provided PDF files and inputting data into an Excel spreadsheet. Key Responsibilities: - Carefully extracting and entering data from PDF files into an Excel spreadsheet - Ensuring accuracy and attention to detail throughout the process Ideal Skills: - Proficient in Excel - Excellent attention to detail - Previous experience in manual data entry - Comfortable working with PDF files.
I can write more articles of the same kind for you.
I have a WooCommerce platform for selling registrations for sports events, and I need to create a conditional form during the checkout process to determine whether the person making the payment is the athlete or someone else paying on their behalf. This is crucial because I need to collect the athlete’s personal information, and often, the payer is not the athlete, making it difficult to identify who the competitor is. Key Requirements: Conditional Form Logic: At the beginning of the checkout process, the form should ask if the person filling out the form is the athlete or another person paying on their behalf. If the payer is someone else, an additional form must appear to collect the athlete’s personal information. If the payer is the athl...
Please Sign Up or Login to see details.
I need a proficient developer specializing in Microsoft technologies to implement a system that syncs my emails between Outlook and SharePoint. We need a add-in to outlook, so we can see all sharepoint folders etc in outlook, so we easily can drag email, attachements both ways. Easy access
I'm an advanced user of Microsoft Excel, seeking assistance with some issues I'm encountering. You will need: - Extensive knowledge of Microsoft Excel - Experience with troubleshooting complex spreadsheet problems - Ability to communicate solutions clearly and effectively
Hi, I'm looking for someone to do online research to find pricing on equipment and make phone calls as needed to get quotes from equipment owners. I will pay you bonuses for finding better deals. Must have strong English. Must work between 9am-5pm Eastern Standard Time First job is to look for a used tanker truck. I'm going to use the truck to transport used cooking oil. Please find all vehicles from all of these sites and add one row per each vehicle into the attached Excel sheet. Fill out just the price, year, mileage, and link columns: 1. 2. 3. Facebook marketplace 4. https://www.ironplanet.com/Tanker+Trucks 5.
I need assistance with importing our sales leads from an Excel file into our CRM system, Recman. Key Requirements: - The Excel file is stored on Drive and needs to be accessed, processed and imported. - The specific data fields to be imported include: Contact information, Lead source, and Sales history. - No specific data transformation or mapping is required, the data can be imported as is. Ideal Skills: - Proficient in handling Excel files, particularly in a Drive environment. - Familiarity with Recman CRM is a plus. - Good attention to detail to ensure all relevant data fields are correctly imported.
I'm in need of a SharePoint expert to assist in enhancing my SharePoint site to help finish a project. The primary focus will be on improving the site's functionality and features. Key Requirements: - Expert in SharePoint with a focus on functionality and features - Experience in managing permissions - Skills in preparing the site for further expansion - Ability to troubleshoot and provide ongoing support This project is crucial for helping me complete my current task. Your proficiency in SharePoint and your availability is very important to me.
I need a comprehensive movies list exported into a CSV from IMDB. list should include key details like title and release year, director and cast, as well as genre and rating. Ideal skills and experience for the job include: - Proficiency in data management and export - Extensive knowledge of movies and film industry - Skilled in using Excel or CSV formatting.
I have 12 months worth of bank transactions from three different accounts that need to be consolidated into a single spreadsheet. Key Responsibilities: - Convert transaction logs from PDF to Excel format - Create a spreadsheet that includes: - Account name - Date - Description (only keywords from the full transaction description) - Address - Amount - Balance of each transaction Required Skills: - Advanced Excel - PDF Conversion Software Please note: I will categorize the transactions once all data is combined into one document. The freelancer will not need to do anything besides conversion and/or copy from one format to another.
... automated notifications, staff/vendor management, analytics, data import/export, and robust security measures. Initially, we’ll focus on a web-based solution using React (front-end) and Node.js + PostgreSQL (back-end). We also plan to future-proof the system for possible expansions to desktop and mobile platforms. If you have experience building complex, secure, and scalable SaaS/web apps, we’d love to see your proposal! Key Features & Modules 1. Property & Unit Management • Track properties, define units (rent amount, occupancy status). • Link units to tenants, show vacancy vs. occupied, manage lease details. 2. Tenant & Lease Tracking • Store tenant info (contact, lease agreements), set lease start/end d...
I'm looking for someone skilled in Excel to help me with a data transfer task. I need to pull information from one spreadsheet and add it to a column in another. Key Requirements: - Transfer of text data between two simple spreadsheets (comprising simple rows and columns) - Matching of data based on an exact match in a single column Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks
EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected i...