How to link sheets in excel to a master sheet jobs

I'm looking for a Power BI expert to help me visualize inventory data from Excel spreadsheets to better understand our current stock levels, trends, and make informed decisions accordingly. Key Responsibilities: - Utilize Power BI to create visually appealing and interactive dashboards based on the inventory data from Excel spreadsheets. - Implement appropriate visualizations that can effectively communicate inventory-related insights to stakeholders. - Ensure the final output is user-friendly and allows for dynamic exploration of the data. Ideal Skills and Experience: - Proficiency in Power BI. - Extensive experience in data visualization, specifically with Excel data. - Strong understanding of inventory and stoc...

I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel...

I'm on the lookout for a reliable virtual assistant who can assist with email handling and data update tasks. The successful candidate will primarily be working with Google Suite (Gmail, Google Sheets). Key Responsibilities: - Manage a high volume of emails on a daily basis (more than 100) - Update databases as required - Manage and update spreadsheets - Implement content updates on a website The ideal candidate should be organized, detail-oriented and have a strong grasp of both email management and data entry. Proficiency in Google Suite, specifically Gmail and Google Sheets, is essential for this role. Experience in website content management is a plus. This is a long-term opportunity for the right ind...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

Develop macro-enabled Excel file to handle CSV

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience ...

I have written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folde...

I need a professional and impactful Google Slides presentation designed for an information memorandum. The aim of this presentation is to effectively represent: - Our company's business and main history milestone - Our mission and core values - Our company's business performance data - Our future business strategies A broad understanding of business analytics is essential as business performance data will be central to the presentation. Expertise in chart and graphics creations within Google Slides would be useful—it's important that the data is easy to digest and visually appealing. A creative outlook would also be beneficial to deliver our strategies in an engaging way and to help articulate our ...

...objective is to create short duration (5-10 minutes) documentary-style videos showcasing interesting video footage of your local models for our platform. We are hiring freelance video photographers like you, to shoot easy fashion style video shows with local female models you recruit for each project. You will be shooting projects where you are now located, with local women you invite to model for you, and we pay you from US$500 per shoot project, more once you become familiar with shooting for us. ModelsUpClose are video entertainment producers,  hiring video photographers from across the world in fashion style General Exhibition video shows since 1997.   It is essential we agree on your proposed model before starting a project. ...

Need only Indian Freelancers and need freelancer should have minimum 5 years of advising business clients I'm managing a partnership firm with 100 members, where the membership is anticipated to be changing every quarter. We're currently operating under a master agreement that every member signs upon joining. (Not all the partners signs the same agreement . new partner signs in new agreement print out )I'm seeking a skilled legal professional to review this agreement and provide their expert opinion. Opinion Should be Given in Writing in a Letter pad with Seal signature and Digital Signature Person signing should have valid registration certificate and must be attached with the Opinion Letter. Key C...

I am in search of a proficient writer to develop a book targeted at novice teachers. The central theme revolves around teacher empowerment. The selected writer should be able to present concepts in an inspirational and motivational style. Focussing on early years - Image of the child, relationship between educators, families, children and communities, rights of children and inclusive and democratic learning style Key Responsibilities: - Break down complex empowerment strategies into simple, actionable steps. - Use compelling and motivational language to inspire new teachers in their journey. Ideal Skills: - Proven experience writing in an inspirational and motivational style. - Familiarity with the field of education, specifi...

Need someone to go through one of my company bank statements for the last 8 months and prepare both years financial statements (profit/loss and balance sheet).

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

I'm in need of an expert who can help me set up a multi-master Docker Swarm cluster across Delhi and Mumbai regions in an e2e network. The cluster should be designed primarily for disaster recovery, with specific requirements as follows: - **Cloud Provider**: I'd like the cluster to be set up in an e2e network. - **Network Type**: I need a public e2e network for this cluster. - **Primary Goal**: The main focus of this project is disaster recovery, so the cluster should be designed keeping this in mind. The ideal freelancer for this job should have in-depth knowledge and experience with Docker Swarm, network setup across regions, and disaster recovery strategies. Proficiency in setting up clusters on e2e netwo...

I require the expertise of a proficient Odoo ERP freelancer to assist in migrating data from an old system to a new one. Key Requirements: - Expertise with Odoo version 15. Familiarity with the ins and outs of this system version is crucial to successfully migrate the data without loss or corruption. - Extensive experience is paramount. I'm eager to hear about the similar data migration projects you've handled in the past and the results you've achieved. - A deep understanding of the Accounting module which the data is primarily focused on. Ensure you are adept at dealing with figures, financial data, balance sheets and other financial reports. Best suited freelancers would be detail-oriented, meticul...

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data en...

I have a 5-10 minutes MP3 file that needs to be transcribed urgently. I need the transcription to be accurate and in a sheet format. Ideal Skills and Experience: - Proven experience in audio transcription - Ability to deliver high-quality work under tight deadlines - Proficiency with sheet formatting - Strong attention to detail This is an urgent project, so I am looking for someone who can start right away and deliver the transcription quickly. If you have the required skills and can meet this deadline, please bid on this project.

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

...tracking system on Google Sheets. The system should automatically calculate total hours worked, allow for marking employees as present or absent, and have fields for project number and name. Key Features: - Automatic Calculation: The system should calculate the total hours worked by every employee within the specified date range. - Attendance Tracking: There should be an option to mark employees as present or absent. - Project Details: Each row should contain fields for the project number and name. - Multi-employee Handling: The system should accommodate multiple employees' data in a combined sheet. Skills and Experience: - Proficient in Google Sheets - Experienced in creating automated time tracking systems - Familiarity wi...

We are building a financial application whereas you can put money hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to r...

I need someone to help me with my weekly projects that involve Quality Assurance Testing and Consultancy services for a few major international tech firms. Projects and work are continuously available so there is plenty of work weekly We will work through remote working software to connect to our local machines using this software, not the other way around so there is nothing to worry about your privacy. Testing will be done on Windows desktop and will mainly involve QA checks and regression Testing of certain software. All testing done are on confidential pre-release test builds so discretion of what you test IS IMPORTANT. Please acknowledge this in your proposal. An NDA will be signed in this regard. I require someone with excellent IT ...

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

I'm looking for a skilled professional who can assist me with updating product information on two PDFs. Additionally, I need a one-page "specials" sheet created with a professional and corporate style. This sheet should be in line with our company's branding guidelines. Key Tasks: - Update product information in two PDFs - Design a one-page "specials" sheet - Ensure the design is professional and corporate, adhering to our branding guidelines Ideal skills and experience: - Proficient in Adobe Acrobat for PDF editing - Strong graphic design skills and experience in creating corporate designs - Ability to follow existing branding guidelines while designing new assets - ...

Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for ...

I'm in search of an experienced architect who can design a master bathroom suite for me. The suite will be 8 ft by 16 ft in size. Here are the specifics: - Features: The bathroom should include a double vanity and a walk-in shower, but no Jacuzzi tub is needed. - Style: The overall design should be in a contemporary style. This includes a modern, minimalist approach, with sleek lines and a clean aesthetic. - Materials: The bathroom will feature quartz countertops. A minimum 60-inch vanity with a double sink A toilet separated from the rest of the suite by a wall and door. A tiled shower with subway tiles for both the walls and floor, possibly with a built-in ...

I need a virtual assistant for a daily one-hour task to input visitor information into a Google Sheet. Key Requirements: - Attention to Detail: It's important that all information is entered accurately and completely. Ideal Candidate: If you are a detail-oriented individual with prior data entry experience and can commit to a daily one-hour task, I'd like to hear from you.

More details: *What specific type of claims do you expect the expert consultant to identify? Delays, Cost overruns, Scope changes *How many projects do you need the expert consultant to review? 4 *Project documents will be supplied. *Reference Contract: FIDIC Red Book *How soon do you need your project completed? ASAP

I'm looking for a skilled Power BI developer who can create detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project re...

House plans to be completed. Mark ups provided in 2 stages. DWG provided. You need to have experience in completing drawings for building approval. This job may need revisions once submitted for building permit. After revisions the job will be complete. Mark ups need to be reflected on entire set of plans (10 sheets in all) We will need to have at least one phone call to clarify the job.

...with websites in various industries to place links to my three websites. I'm willing to reciprocate by placing links to your site on my platforms. The primary objective of this project is to enhance my website's traffic through valuable backlinks. $3.00 for 1 website, $5.00 for 2 websites or $10.00 for 5 websites, Not Negotiable. Key Requirements: - You should have websites from different industries - You should be willing to place links to my 3 websites on your platform - I will reciprocate by placing links to your websites on my platforms - The primary aim is to increase my site's traffic Ideal Skills: - Proficiency in SEO and backlinking strategies - Prior experience in link b...

I'm looking for a skilled SAP FICO consultant with expertise in the Financial Accounting (FI) module. The selected professional will primarily handle: - General Ledger (GL) management - Accounts Payable (AP) - Accounts Receivable (AR) - Bank-related activities Additionally, you will be required to generate key reports including: - Profit and Loss Statement - Balance Sheet - Cash Flow Statement Ideal candidates should have in-depth experience managing the above tasks within the FI module. Extensive knowledge of SAP FICO and a keen understanding of financial reports are vital for this role.

...someone who can create a database in MS Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a login page. After Login, there should be a a Main Page, with link to the above mentioned list pages plus, Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice...

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. ...

I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround

...for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract the required data and compile it into an Excel file with separate sheets for doctors' information and

I'm looking for a skilled developer who can link our existing Google Sheet with Tranferz API. We need the API to retrieve and update data on our sheet based on the following specifications: - Fetching and updating Driver Information: The API will need to fetch and update data related to drivers. This includes their availability, current location, and other relevant details. - Displaying Ride Details: The API should be able to fetch and display ride details for each driver. This information is crucial for the drivers to efficiently manage their schedule and assignments. - Updating Payment Information: It is essential that the API updates payment information in our Google Sheet. This includes payments received...

I'm in need of a skilled freelancer who can assist me in collecting contact information for recruitment companies specifically operating in Saudi Arabia. Those companies are NOT necessarily based inside Saudi Arabia, could be based anywhere in the world, but they recruit for companies/entities inside Saudi Arabia. Please note that I do not need recruitment people in certain sectors such as Oil, Gas, IT, Engineering, Aviation, Procurement, Transportation, Architecture and Finance. Everyone else is yes needed. Key Requirement: You will need to find the contact name, position, email and LinkedIn account for each and every recruitment/HR/Headhunting person within each company. This could be anywhere between 10 to 30 people per comp...

Create a simple Sheets spreadsheet that tracks dates, deadlines, categories of tasks, and tasks. Needed by tomorrow morning us time. Should take under 2 hours.

...looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge o...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to hav...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is e...

Money and all it takes to make it in easy steps even a 14 y/o can deal with

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. ...

I need an AutoCAD expert to help me make some modifications to existing DWG drawings. - The main task is to flip and rotate the drawings so that the garage is on the right side. - The title blocks also need an update to complete the modifications. Additionally, the foundation sheet must reflect a 3-course stem wall with footer. Ideal skills: - Proficiency in AutoCAD - Experience with architectural drawings - Ability to update title blocks - Attention to detail for flipping and rotating drawings - Ability to accurately reflect a 3-course stem wall with footer on the foundation sheet

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

...someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs an...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.