Lock formula in excel shortcut jobs

I have a database that I need to extract specific textual information from, in a one-time extraction. The data needs to be structured in an Excel file. Key Requirements: - Extracting Textual Data: You'll need to retrieve text from the database. - Data Structuring: The extracted data should be organized and presented in an Excel format. Ideal Skills and Experience: - Database Scraping: Experience in extracting information from various types of databases. - Data Structuring: Proficiency in organizing and presenting data in Excel. - Attention to Detail: Ensuring that all relevant text is accurately extracted and included in the final Excel sheet.

In the zipped folder, it contains - sample of 2 months dummy data - each file contain IND and ENT sheets, some files may only contain either or - "consolidate" excel file is the sample outcome for reference The VBA should work as per below - an input to insert month (free text) e.g. 202301, 202302 etc - choose destination folder and files (in some of the months it contain unnecessary files) - IND sheet to consolidate only IND data from selected files - ENT sheet to consolidate only ENT data from selected files - 'Summary' sheet to provide number of rows overview for both Challenge - whether consolidation outcome can be done in 1 excel - whether it would work with a password encrypted files (please advice any workaround)

...template in Microsoft Excel. The template should be specifically designed to provide an intermediate level of detail - think monhtly breakdowns and categorized expenses. Key Responsibilities: - Develop a comprehensive, user-friendly cashflow forecast template in Excel - Ensure the template can handle a monthly breakdown of cashflow - Categorize expenses in a clear and structured manner - Make the output visually appealing and easy to read Ideal skills: - Proficiency in Microsoft Excel - Experience in creating cashflow forecasts - Ability to design and structure data in a logical and visually appealing manner - Attention to detail in categorizing expenses - Understanding of financial concepts and terminology, partic...

I need assistance in managing my customer data effectively. The ideal candidate needs to set up a system that allows me to keep track of my customer data and generate Excel reports based on this data. Requirements: - Set up a system for me to input and manage customer data - Ensure the system generates Excel reports with the necessary fields - Ensure the system is user-friendly and easy for me to use The ideal candidate will have experience in: - Database management - Excel report generation - User interface design for data management systems Please only apply if you have demonstrable experience in these areas.

...communications agency based in London, specialising in public affairs, policy analysis, media relations, and crises communications. We also organise events on behalf of European trade bodies including an annual awards ceremony for a leading sports nutrient association which takes place in London. We are looking for an experienced Event Organiser to provide essential administrative and logistical support for the team in the UK and EU either on a freelance or fixed term contract to deliver an awards ceremony in London in December 2024. You will need a positive, can-do attitude, and be able to flex your approach and make decisions at speed when required. You will perform well under pressure and possess great attention to detail. This is...

I'm in need of a skillful web designer to craft an engaging and functional eCommerce platform. The website is primarily meant for eCommerce operations, so a significant focus on user-friendly and secure shopping experiences is vital. Key Features: 1. Shopping Cart: Enable customers to add multiple items and proceed to checkout when they finish shopping. 2. Payment System: Must support diverse payment options and ensure secure transactions. 3. Product Review System: Customers should be able to leave, read, and respond to product reviews. 4. Ease to track stock count [Critical] 5. Ease to add and remove products [Critical] Special Requirement: 1. Excel Sheet Collation: The site should be programmed to automatically update Excel sheets with appropriate site data. ...

I need a freelancer preferebly someone with experience in Zoho books. I need to you to add some data from excel to zoho books. You can use the bulk upload feature or do a manual entry. Just need to make sure you are not doing thing in a hurry & adding wrong entries. Each transaction has to go to some expense segment/vendor, must have some experience of doing accounting work. The whole work might take 2 full days, please bid accordingly, you should be able to work between 11 & 8 PM IST & available on call & with remote desktop view.

We want the freelancer to understand our requirement and complete it on time

I’m currently in need of a top-notch professional who is skilled in data entry, particularly in Excel. Key responsibilities will include: - Data entry into Excel from Word - Regular upkeep of the database I require someone with the following skills and experience: - Proficient in using Excel and Word - Attention to detail - Data management skills - Dependable and reliable Experience with data entry in Excel is crucial for this project. It's important that you can efficiently transfer data from Word. If you meet these requirements, I’d love to hear from you.

...i am looking with someone with great knowledge of amazon seller central, list process and product creation using excel spreadsheets and xml imports we have a lot of data and a bank of 50k products we really need an individual with great knowledge of amazon any selro knowledge will be a bonus Key Responsibilities: - Accurate and detailed listings for a range of products within the home and kitchen category - Ensuring that all product details are correctly populated - Adherence to Amazon's guidelines and policies for product listings - Regularly updating and managing existing product listings Ideal Skills and Experience: - Proven experience in listing products on Amazon UK - In-depth knowledge of the Home and Kitchen category on Amazon - Familiarity with Amaz...

I need a new Excel flowchart that's designed to include symbols like the ones in the attached Visio file. I just wa The ideal freelancer should be proficient in: - Excel: Demonstrated experience creating complex flowcharts in Excel is a must. - Technical Illustration: Capable of replicating and customizing symbols from a provided example. - Attention to Detail: Able to create a clear, legible flowchart that can be easily understood by others. Your application should include: - Examples of your past work, especially any Excel flowcharts or technical illustrations. - Relevant experience that demonstrates your capacity to complete this task. - A detailed project proposal outlining your approach to creating this flowchart.

Please Sign Up or Login to see details.

I want to design a vba code where i can send text or whats app message

I'm seeking an individual proficient in copying and pasting data from various sources into an Excel spreadsheet. While the complexity of the data isn't explicitly defined, a basic understanding and familiarity with Excel are a necessity, so you can format and organize the data accordingly. Key Responsibilities: - Transferring data from different sources to Excel - Basic manipulation and organization of data in Excel Ideal Skills and Experience: - Proficiency in Excel - Previous experience in data entry - Excellent attention to detail

I'm looking for a professional data entry specialist to assist with the input of textual data in an Excel format. The key requirements of this task are as follows: - Experience in carrying out text data entry tasks. - Ability to methodically input less than 1,000 entries. - Knowledge and proficiency in using Excel for data input. - High attention to detail and accuracy for data input. Please ensure that your bid includes an estimation of time required to complete less than 1,000 text data entries in Excel.

I'm seeking an experienced Microsoft Excel professional to assist with visual data representation in my Excel sheets. - My primary need is for the successful candidate to help me create clear and comprehensive visual representations of my data using Excel's charting and graphing capabilities. - The ideal candidate should have a solid understanding of various data visualization techniques and be able to recommend the most appropriate type of visualization based on the nature of the data. - Experience with Excel's chart customization features is a plus.

ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)

My Food & Beverage venture needs a talented designer to ...perfectly embody our brand. The right candidate for this job would have experience in branding and a strong portfolio that demonstrates creativity and an understanding of the Food & Beverage industry. Key Points: - Design of a unique and memorable logo that reflects the fun and vibrant nature of the brand. - The logo should be versatile and suitable for a variety of uses, from packaging to online marketing. - Understanding the Food & Beverage industry and being able to translate this into the design is crucial. - Proven experience in branding and logo design is a must. This job may also open up further opportunities for future branding and design projects. If this sounds like a project you can exce...

I have a PDF document containing numerical data that I need entered into an Excel spreadsheet. Ideal skills and experience: - Proficiency in data entry - Experience working with numerical data - Familiarity with Excel and PDF - Attention to detail and accuracy

We need to fetch data from the website to excel sheet in desired format. Its a quick job. Someone with experience can apply.

Hello, I am looking for an experienced data analyst to help me out with a project. I am hoping to find someone to do a statistical analysis on my data set which consists of 1000-10,000 records. The analysis needs to be completed in Microsoft Excel. I am looking for someone with extensive knowledge and understanding of data analysis, as well as the software. Ultimately, I need accurate information to make informed decisions. If you think you have the skills and knowledge to help me out, please reach out! Thank you.

...User Authentication: - Email and password - Phone number and OTP - Google login - Apple login (iOS APP/device) Detailed project description below: Build Scalable, Responsive and Dynamic website, and mobile app (iOS and android): Key requirement from developers: • Looking for a team of qualified developers with knowledge of all the functionalities required for this project • Must have expertise in building website as well as android and iOS apps • The scope of the work may increase as we learn more about the users of the website. • Please send your price quotations with detail of language/tools you will use and the timeframe you will need to complete this project. Functionalities to build: • Book meeting function that automatically check calenda...

...sending of multiple emails from an excel spreadsheet, with a PDF attachment. Key requirements include: - Using Gmail as the email service provider. - The emails will be sent to multiple recipients with the same content. - The frequency of sending emails is irregular. The main responsibilities of the program are: - Extracting email addresses and any other necessary information from the spreadsheet. - Attaching a PDF to each email. - Sending out the emails. Ideal skills: - Proficiency in Python or similar programming language. - Experience in working with Gmail API. - Proven track record in developing email automation tools. Please note that while personalization is not currently required, the program should be built in a way that adding personalizat...

I'm seeking a freelancer skilled in Excel, Numbers, and Constant Contact, to collaboratively prepare and execute a one-time mail merge email campaign. Key Requirements: - Use the provided Excel list to create a mail merge email. - The purpose of the email is to promote a product or service. - Assistance in designing the email content is needed. The ideal candidate should have: - Proficiency in Excel or Numbers for mail merging - Experience with Constant Contact, particularly in executing mail merge - Ability to design visually engaging email content Your role will be paramount in ensuring a successful email campaign. Please include examples of previous work, particularly in email marketing, in your bid.

I have a sizeable amount of data that I need inputted into Excel to generate reports. This data is a mix of textual information and numerical data. There are numerous columns that this data needs to be sorted into. The ideal candidate for this job will have: - Proficiency in Excel and experience in data entry - An understanding of how to organize mixed data into clear, readable reports - Strong attention to detail to ensure accuracy of the entries - Good time management skills to complete the task in a reasonable timeframe. I need the output to be organized, coherent, and easily understandable, so please only apply if you have a strong background in Excel and data entry.

I am in search of creative designers who excel at crafting whimsical, cartoon-style characters, specifically, rubber hose characters. While I have skipped specific details about design features and character attributes, I will be open to your individual style and interpretation. Key Requirements: - Proficiency in cartoon-style character design - Strong creative instincts - Ability to incorporate your individual flare while balancing the foundational aesthetics of rubber hose characters Please share your portfolio when bidding, especially any work related to cartoon style characters. This will help me assess if your style could be a great fit for this project.

I need a professional who can help me recover a password for an Excel XLSM file. Key Requirements: - Recover a lost password for an Excel XLSM file - Ensure the process is secure and compliant with standard security practices - Maintain the integrity and functionality of the document post-password removal Ideal Skills: - Proficient in password recovery methods for Microsoft Excel - Experience in data security and encryption - Strong knowledge of Excel XLSM file structure

I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all t...

I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import

... - Develop a core concept that emphasizes endless gameplay, where players can test their skills against increasingly challenging waves of zombie pets without a set endpoint. - Design a game structure that loops through waves of escalating difficulty, offering replayability and the potential for continuous improvement. - Incorporate mechanics that reward players based on their performance in surviving and progressing through the endless waves of zombie enemies. 2. Gameplay Mechanics and Features: - Implement a procedurally generated system for enemy waves to ensure each playthrough is unique and offers varying challenges. - Introduce scaling difficulty that dynamically adjusts to the player's skill level, providing a continuously engaging experience. - Inclu...

...a specific website on a daily basis. The scraped data should be compiled and delivered in a spreadsheet. Key requirements include: - Daily scraping of text content from the designated website - Compilation and formatting of this data into a spreadsheet Your experience in web scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached excel file. Go to the website

..., only certain locations or only scheduling). Teacher Management Teacher Data Upload: Module to add and update teacher information, including: First and last name Email Phone number Subjects taught (both theoretical and practical) Hourly and daily availability Locations where the teacher is available to teach Intuitive interface for quick data entry with the ability to import data from CSV or Excel files. Tabular view of teachers with search and filter functionalities. Hourly and Daily Availability: Interactive calendar to set daily and hourly availability of teachers. Drag-and-drop functionality for easy time adjustments. Ability to set recurring availability (e.g., every Monday from 9:00 to 11:00). Option to add notes or comments for each availability block. Selection of loca...

I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail and good communication skills.

...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Famili...

Project Details $30.00 – 250.00 USD I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By ...

...expertise in building website as well as android and iOS apps • The scope of the work may increase as we learn more about the users of the website. • Please send your price quotations with detail of language/tools you will use and the timeframe you will need to complete this project. Functionalities to build: • Book meeting function that automatically check calendars of team members and shows available slots to external users to make booking with our experts - Admin can sync several calendars (of team member/experts) to one calendar booking form and the form will show availability for all the hours any of the linked expert calendars show available time. • Blog section - All type of Users can read, like, share on multiple social media platforms, and add comme...

I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed and analyzed wit...

I am currently dealing with a troublesome iCloud activation lock on my iPhone. Unfortunately, I don't have access to the Apple ID or password that's linked to this lock. On my own, I've attempted a few online methods to dismantle this lock, but none have been successful. I'm seeking a freelancer who has: • Expertise in iOS systems • Proven experience in iCloud activation lock removals • Ability to troubleshoot and resolve Apple ID issues This project will be considered successful upon removal of the iCloud activation lock in a manner that leaves the device in full working order. Your understanding of Apple's security infrastructure would greatly benefit this project.

I am looking to significantly revamp my home's exterior in order to increase its curb appeal. The remodel should reflect a modern rustic style. The specific changes I intend to make include: - Window replacement: To maintain a unified style, the new windows should complement the modern rustic look. - Addition of front dormers: Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this project. Critical abilities include an eye for design, detail-oriented work, and th...

I'm looking for a professional who can help me generate contac...contact information (name, email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliver high-quality, targ...

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.

I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.

I am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must...

...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within AutoCAD ...

I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text an...

Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.

Hired already client is aware of details

I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the...