How to link two excel files in sharepoint 2013 jobs
I'm looking for an expert in Excel who can help me manage various aspects of my business using this powerful tool. Key Responsibilities: - Inventory Management: Track and manage stock levels, shipments, and purchases. - Financial Calculations: Assist with budgeting, forecasting, and expense tracking. - Data Analysis: Examine sales data, transportation costs, administrative expenditures, and stock valuations to derive actionable insights. Ideal Skills and Experience: - Proficiency in Excel with a strong understanding of custom formulas. - Experience with creating automated reports and dashboard visuals. - Background in accounting and customer relationship management (CRM) is a plus. - Ability to create user-friendly dashboards for eas...
I need a skilled Python programmer to help me automate the order placement on Interactive Brokers. Key Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll...
I am working on a MATLAB project that involves curve fitting and deducing a transfer function from measured data. I need help with: - Reading data from an Excel sheet and plotting the graph between two variables. - Reconstructing a curve that fits the measured data. - Fitting a higher-order transfer function to this curve. I plan to use the Optimization Toolbox for this project. I would appreciate your assistance in completing this project effectively. I will provide multiple measurements in form of excel sheets(along with the basic code) and fitted curves along with MATLAB codes are required .
i need to build 2 product ecommerce, i will give more info
...professional to create a Power Automate flow for my SharePoint lists. This flow will be essential for calculating the balance of two types of leave: Sick leave and Personal leave. Key Requirements: - The flow has to be based on two SharePoint lists. - It should accurately add any forms through our SharePoints. I should also have the ability to add forms and choose who can approve from my Azure. - Configure notifications that are triggered under specific conditions. ِ- Archive all documents on our folders Conditions that should trigger notifications: - Leave balance falling below a certain threshold - Approval or rejection of leave requests - New leave requests being submitted Ideal skills for this job would include: - Expertise in...
I need someone to extract data from my invoices and enter it into Microsoft Excel and then into both a desktop and a cloud-based application. Key Tasks: - Extract data from invoices - Paste data into Excel - Enter data into a desktop app and a cloud app Ideal Candidate: - Familiarity with data extraction and Microsoft Excel - Experience with both desktop and cloud-based applications - Attention to detail to ensure data is entered accurately
...skilled Excel expert who can transform my investment portfolio data into a user-friendly, dynamic spreadsheet. Key Requirements: 1. Create a comprehensive, dynamic Excel table capturing all of the client's investment positions. 2. Organize information into dedicated columns for each data point (e.g., ISIN, Name, Price, etc.) 3. Utilize advanced graphic design skills to present the data in an intuitive and visually appealing manner. The aim is to create a UX-friendly information table suitable for individual investors. 4. Include a dedicated column with links to Yahoo Finance or Investing.com. Each link should correspond to the historical chart data of each investment position. Ideal Skills: - Proficient in Microsoft ...
I'm seeking an expert in online marketing, specifically in Search Engine Advertising (SEA), to assist with a campaign focused on a donation link. Key Responsibilities: - Create and manage a Google Ads campaign aimed at promoting a donation link. - Optimize the campaign for maximum reach and effectiveness. Ideal Skills: - Proven experience with Google Ads - Strong understanding of SEO and SEA principles - Excellent analytical skills to assess campaign performance - Creative mindset to develop engaging ad content My goal is to increase visibility and drive traffic to the donation link through this campaign. The ideal freelancer for this project will have a track record of successful Google Ads campaigns, with the ...
I need immediate assistance in resolving some issues in Power BI. Main issues: - Dates not displaying in correct order in a chart. - Need help with displaying employee hierarchy data in an organizational chart. Data Source: - Current data source for my Power BI report is an Excel file. Ideal skills and experience: - Proficiency in Power BI is a must. - Experience with Excel as a data source. - Ability to create and troubleshoot organizational charts. - Strong problem-solving skills for date sorting issues.
...looking for a graphic designer to modify the wording on my existing business logo. - Modify existing text: The designer will need to adjust some of the current text. - Provide new wording: I will supply the new wording which needs to be incorporated into the logo. - Keep the same font: The existing font style will remain unchanged. In addition to the text modification, I require: - All high definition files of the modified logo. - Copies of the modified logo on both a black and white background & transparent. Ideal candidates will have a strong background in graphic design, with experience in logo modification. They should have the ability to deliver high-quality files and provide the logo on different backgro...
I'm looking for a professional who can proficiently analyze data using Excel, specifically looking at descriptive statistics. In addition, I need assistance with managing and strategizing my social media ad campaigns. Ideal candidates should have: - Strong expertise in Excel, particularly in data analysis - Experience in working with descriptive statistics - Proven track record in managing social media ad campaigns - Skills in creating compelling ad content - Ability to interpret data and adjust campaigns accordingly Please provide examples of your previous work related to this project.
I need a freelancer to scrape 30,000 records of contact information from a provided URL within 48 hours. The information will specifically consist of names, email addresses, phone numbers, and mailing addresses. The final output should be in an Excel format. Ideal skills and experience for the job include: - Proficiency in web scraping - Experience with Excel - Attention to detail - Ability to meet tight deadlines
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
...looking for an Excel sheet that generates newspaper bills for approximately 150 houses on a weekly basis. This should include the delivery charge and provide a total for each week, as well as a 4-week total, excluding holidays or days when the paper isn't delivered. Key Requirements: - The bill should include the house number and address, total number of papers delivered, and the week's total cost including the delivery charge. - I need to manually enter non-delivery days. - The final summary of the total weekly and 4-week costs should be displayed in the same Excel sheet. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in creating complex sheets with formulas and functions. - Previous experience ...
Remove background noise and vehicle honking, Improve voice clarity so it can be heard clearly. There are around 3 short video files you need to clear the audio. Note: This is a long term project. These kind of regular editing will be required. Here is the link of the sample video file.
...experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are easy to navigate and understand. 3. **Data Analysis:** - Perform in-...
...seeking a skilled Android & iOS developer to create an event registration app with the following features: 1. Registration: - User account creation via email or social login. 2. Agenda Management: -Display event schedules with session details (title, speakers, time, location). -Add sessions to a personal calendar or create a custom agenda. - Real-time updates to agenda (push notifications for changes). 3. Lead Scanner: QR code scanning for exchanging contact information between users (attendees, exhibitors, and organizers). Store scanned leads in a dedicated section. Export leads to Excel or other formats. The app should have a manual form entry system for event registration. The ideal candidate for this project should have a strong back...
I'm in need of a professional who can extract data from a corporate website and compile it into an Excel spreadsheet. Key Requirements: - Extract data from a corporate site. - Data includes: Shopping Centre Name, Street Address, Suburb, State, and Post Code. - Focus on all store locations in New South Wales (NSW). - Use web scraping techniques for data extraction. Ideal Skills: - Proficiency in web scraping. - Experience with data extraction from corporate sites. - Excel spreadsheet management skills. - Familiarity with New South Wales geography is a plus.
I need a proficient Excel expert to help me with a VLOOKUP task involving my inventory data. Specific task: - The VLOOKUP function needs to match exact quantities within my inventory. Ideal Skills: - Advanced proficiency in Excel, particularly in using VLOOKUP. - Prior experience in inventory management is a plus.
I'm in need of a proficient freelancer or a professional agency capable of curating and delivering a detailed database of 7,000 US companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully bef...
I'm looking for an expert in financial modelling to create a comprehensive Excel model for my new business. The model will be used primarily for an investor presentation, so it needs to be robust and compelling. Key Requirements: - Inclusion of all essential financial statements: Income statement, Balance sheet, and Cash flow statement. - Projections covering a period of 5 years. Ideal Skills: - Expertise in financial modelling and Excel. - Experience with investor-focused financial presentations. - Ability to create clear and precise financial statements.
I'm in search of an extensive Indian Grocery Items Database suitable for an online app and website. The database needs to be in Excel format, and must include: - UPC, Bar code - Product Name - Product description - Unit - MRP - Multiple high resolution images The database should cover all branded standard grocery items across the following categories: 1. Fruits 2. Vegetables 3. Grocery & Staples 4. Breakfast & Dairy 5. Biscuits & Snacks 6. Beverages 7. Personal Care 8. Home Care Ideal Skills: - Database Management - Data Entry - Research Please note: - The data should be free from copyright restrictions and not sourced directly from Google. - I will need an initial sample to assess the quality of the information and images. - Data ...
I need an Excel file containing my bank transactions converted into a QFX file, which can be imported into Quicken. Ideal Skills and Experience: - Strong proficiency in Excel - Experience with file conversion to QFX - Familiarity with Quicken software - Attention to detail to ensure all transactions are accurately converted.
I have an Excel file that contains crucial customer information. I need it organized correctly to facilitate better understanding and accessibility. Requirements: - Primary focus on organizing Names and Contact Details. - Each contact's item should be in its own column: Name, Email, Street, City, State, Post Code, and Country. Ideal Skills and Experience: - Proficiency in Excel - Experience in data organization - Attention to detail
I'm in need of a comprehensive operating and financial model in Excel for a new venture. The model should encompass an operations section, a financing component (balancing both Debt and Equity), and generating complete Profit & Loss and Balance Sheet outputs. Key Requirements: - Detailed representation of production costs, sales volume, employee expenses, and capital costs in the operations section. - Consideration of daily hire rates, income from asset disposal, build period expenses, and utilisation metrics. - The financing section should adequately reflect a mixture of Debt and Equity. - Major sensitivities to be clearly presented within the model. Ideal Skills and Experience: - Proficiency in Excel with a strong background ...
I need an Excel dashboard created to track H2S material limits. The primary data source will be Excel Spreadsheets. The dashboard should allow me to monitor: - Material Suggestions I would like the data to be visualized using Pivot charts. Attached file has some created dashboard but they do not provide accurate data. Need to modify it and make more accurate. Ideal skills for this job include Excel proficiency, data visualization, and experience with dashboard creation.
I'm in need of an Excel expert who can help me build a comprehensive workbook to capture end of shift data from multiple locations. Key categories to include: - Delays OS&D - Scanning/PLS Cube Outs - Equipment Issues - Driver Issues - Safety Crucial categories for reporting: - Delays OS&D Specifics for managing Delays OS&D: - I need to be able to list specific delays Ideal skills and experience: - Proficient in Excel - Data management experience - Ability to create user-friendly and efficient workbooks.
I'm seeking help with ICDL programming, specifically focusing on Excel, Word, and PowerPoint. Ideal Skills: - Proficient in Excel, Word, and PowerPoint. - Experienced in teaching or tutoring ICDL content. - Able to prepare for certification assessments. Key Tasks: - Assist with understanding and practical application of ICDL concepts. - Provide targeted help with Formulas and Functions in Excel. - Support with general use of Word and PowerPoint. - Prepare for certification.
...assistance with Microsoft Excel and PowerPoint. Microsoft Excel: - Data Entry & Formatting: I have a lot of data that needs to be entered and formatted correctly in Excel. - Creating Formulas & Functions: I need someone who is skilled in Excel to create appropriate formulas and functions to manage my data. - Data Analysis & Visualization: The project will require some data analysis and I would appreciate help visualizing the data using Excel tools. Microsoft PowerPoint: - Creating a Presentation: I need a PowerPoint presentation to accompany this project, so experience in creating engaging and clear presentations is a must. Ideal candidates should have: - Advanced skills in Microsof...
I need assistance with an Excel spreadsheet. The task involves adjusting column D to ensure all wrapped text is readable. - Number of Rows: The column contains between 100 and 500 rows. - Software: The file is in Microsoft Excel. - Specifics: Only column D needs to be adjusted, not the entire spreadsheet. Ideal skills for this project include proficiency in Microsoft Excel, attention to detail, and experience with data manipulation and formatting in spreadsheets.
I'm looking for an Excel expert to help me with a task related to tracking revenue. The primary focus will be on creating projections based on available market growth data. Key Responsibilities: - Analyze market growth data to create revenue projections - Use advanced Excel skills to apply necessary equations and techniques Ideal Skills: - Proficient in Excel, particularly with financial equations - Experience in revenue tracking and forecasting - Strong analytical skills to interpret market data
I'm looking for an Excel expert to help me create a comprehensive inventory management spreadsheet for my business. Key Requirements: - Inclusion of all our supplier's items that we sell - Categorization of items by product type The ideal freelancer for this project should have extensive experience with Excel and inventory management systems. They should be able to create a user-friendly, efficient, and organized spreadsheet that meets these requirements.
...seeking a software developer to create a Windows-compatible solution for managing estimates, sales/purchase orders, and invoices for our dealer network. Key Requirements: - Create a user-friendly interface for managing estimates, sales orders, purchase orders, and invoices. - Design the software with a primary focus on generating estimates. - Incorporate customizable templates for the estimates, ensuring they can be tailored to specific needs. - Ensure compatibility with the Windows operating system. The ideal candidate will have: - Extensive experience in software development, particularly for Windows. - Proven skills in designing user-friendly interfaces. - Prior experience in developing software for managing sales and purchase orders, and invoices...
...experienced Solidworks professional to convert our STEP files into 2D drawings using our custom Solidworks templates. Key Requirements: - You will be working mostly with A, B, or C sized sheets, depending on the part size. - Each drawing should include a minimum of three views plus an isometric view, all fully dimensioned. - The project consists of approximately 300 parts, with an estimated average of 15 minutes per part. - Please use a drawing scale of 1:1, but no smaller than 1:2. Do not crowd pages. - All parts and dimensioning will be in inches. - It is crucial to employ the parallel dimensioning technique wherever possible. - The general tolerance is +/-.002", with shaft OD at +0.0/-.002" and bore ID at +.002/-0.0". - Surface finish deta...
ISP1 (Primary or principal) - Connected to ether1. ISP2 (Backup) - Connected to ether5 The failover must switch to ISP2 only if ISP1 loses actual internet access, not only if the gateway is unreachable, because could the Gateway answer but without internet access. For example, Pings to 8.8.8.8 should be forced through ISP1 to confirm real internet loss. Once ISP1 is restored, the system should automatically switch back to ISP1. It's important to make sure the ISP1 has real internet connection for example Pings to 8.8.8.8.
I have STEP files for various parts we are manufacturing and need them converted into technical drawings suitable for manufacturing. The drawings should include detailed dimensions, tolerances, and annotations. I require the final output to be in PDF format. Ideal skills and experience for this job include: - Proficiency in CAD software - Experience in creating manufacturing technical drawings - Understanding of detailed dimensions, tolerances, and annotations - Ability to convert CAD files into PDF format
...an expert to update my Excel dashboard. This dashboard is currently used for reporting the daily status of equipment. The update should streamline the process, making it faster and more convenient. Key Tasks: - Revamp the Excel dashboard to improve its efficiency - Incorporate equipment status and availability as primary data points - Ensure the new setup accommodates future needs - Due to much formula, the sheet is slow to navigate Currently, I manually input the status and availability of equipment into the dashboard. The updated dashboard should ideally reduce the manual workload and make the reporting process more efficient. Skills and Experience Required: - Proficiency in Excel, with a strong understanding of dashboard cre...
Need two very small business websites' review to ensure efficiency and new information is updated. Need knowledge of Squarespace and Constant Contact
I need an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports will need: - **Better formatt...
1) Collect data, examine it, and identify any duplicates or outliers, ensuring its completeness and accuracy. 2) Create a table and organize the data in a clear and easy-to-understand format. 3) Provide statistical analysis using mean, median, mode, variance, standard deviation, and other relevant metrics. 4) Present charts that illustrate the relationships between variables 5) Present charts that help predict future trends, identify gaps, and improve performance and operational efficiency.
It is a busy spell for me, and I haven’t got the time to complete this questionnaire sheet this weekend, so may I request your professional English writing expertise. Fill out the attached sheet to provide input for this comedy writing material based on rationality in everyday life. I welcome you to read the following first, then check out the sheet, place a bid. It would be kind of you to provide the answers using quality English grammar in the attached Excel spreadsheet within 2 days. Allow me to observe your progress after the first hour so I can provide early feedback on your answers. Get into the spirit of comedy writing, consider all the witticisms and wordsmith techniques, and provide your best answer to each of t...
I need assistance with my Excel workbook. - Software: The data is in Excel. - Tabs: The workbook contains 1-5 tabs. - Specific Columns: Only column D is being checked for hidden text. The project involves going through the rows on each tab and widening the rows in column D so all of the wrapped text can be read.
I'm looking for a one-time web scrape of an eBay page containing 5,500 products. The products do not have any variants, which should simplify the task. Data to be scraped: - Product name, price, category, subcategory, brand - Product description and images The final deliverable should be an Excel/CSV file containing all the scraped data. Ideal skills for this project include: - Proficient in web scraping - Experienced in data organization and Excel/CSV Please, only bid if you can deliver quality work in a timely manner. Thank you!
I'm looking for a proficient Python developer who can create a script for me. The sp...the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Budget is 30 usd it could lead to long ter...
I need assistance with renumbering my Excel file. The task involves: - Sequentially numbering all rows in column B with simple integers (1, 2, 3, ...). The freelancer should be proficient in Excel and have experience with data manipulation and formatting.
I'm looking for a social media expert who can help me boost my referral link organically on Facebook and Instagram. Key Responsibilities: - Create engaging and shareable content that encourages my network to click and share the referral link. - Strategically time posts to reach maximum audience. - Use insights and analytics to monitor progress and adjust strategy as necessary. Ideal Skills: - Extensive experience with Facebook and Instagram. - Strong understanding of social media trends and algorithms. - Excellent content creation and copywriting skills. - Ability to analyze data and adjust strategies accordingly.
I have an Excel sheet locked with input data that needs adjustment for proper calculations. The sheet is primarily for data analysis. Key Tasks: - Unlock the sheet to facilitate modifications - Adjust specific numbers to correct data input errors - Modify calculation formulas to ensure accurate outcomes Ideal Skills and Experience: - Proficiency in Excel, including unlocking sheets, modifying data, and adjusting formulas - Strong attention to detail to identify and correct data input errors - Experience in data analysis to understand the context and purpose of the adjustments
Project Overview: We need to develop a solution for dynamically maintaining an employee list in Microsoft 365 and automatically updating organizational charts for departments and HQ. Due to limited admin access, the solution must rely on the tools available to a SharePoint site admin, avoiding dependencies on Admin Center or Azure AD. Objectives: 1. Centralized Employee List: o Create a central repository (e.g., SharePoint List or Microsoft Lists) to store employee data, including: Employee Name Job Title Department Manager Other relevant fields as needed 2. Dynamic Updates: o Automate data management using Power Automate workflows to: Handle new entries, updates, and deletions from the employee list. Notify specific use...
I need mixed data (text and numbers) from a PDF entered into an Excel spreadsheet. The ideal freelancer should be proficient in data entry, have excellent attention to detail, and be experienced in working with both PDFs and Excel. Key Requirements: - Entering mixed data (text and numbers) from a PDF into an Excel spreadsheet - Formatting the data into standard tables - Applying conditional formatting as per the requirements Please ensure you have a strong understanding of how to implement conditional formatting in Excel, as this will be a crucial part of the task.
