Lessons database in ms excel jobs

Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I wo...

I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.

I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data ty...

I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a t...

We are seeking an experienced penetration tester to join our team. As a penetration tester, you will be responsible for identifying and exploiting vulnerabilities in our systems to ensure they are secure. Your main tasks will include conducting vulnerability assessments, performing penetration testing, and providing recommendations for remediation. To excel in this role, you should have a strong understanding of various testing methodologies, possess analytical skills to interpret test results, and be familiar with a wide range of penetration testing tools and techniques. Skills required: - Penetration testing - Vulnerability assessment - Ethical hacking - Knowledge of network protocols - Familiarity with security frameworks - Strong problem-solving skills This is a...

...a robust background in social media management spanning over 5 years, I am confident in my ability to drive engagement and elevate your online presence effectively. Throughout my career, I have honed my skills in creating compelling content, implementing strategic campaigns, and fostering meaningful connections with audiences across various platforms. My experience extends to crafting tailored strategies based on analytics insights, ensuring optimal performance and ROI. I excel in staying abreast of emerging trends and algorithm updates, enabling me to adapt strategies swiftly and capitalize on growth opportunities. Moreover, my strong communication skills and a keen eye for detail empower me to maintain brand consistency and uphold the highest stand...

I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.

...finance and production advice. I'm in need of a talented web designer to create an engaging informational website specifically for Australian agriculture broad acre farmers. The site should serve as a detailed resource, highlighting key aspects of our work and organization. Key Features: -A professional look and feel `-Wordpress based - A comprehensive "About Us" page to outline our mission, goals, and team. - A clear display of our contact information on every page. - Easliy updated by ourselves with graphics based on data collected and stored in MS Excel -Potential for client login The perfect candidate for this job would be an individual with a keen eye for modern web design, experience building informational websites, and ideally some k...

I'm looking for an Excel expert to help me clean up a dataset. I have a large dataset that contains both text and numeric data that needs to be cleaned up. The specific issues I'm facing are: - Text Data: There's a need to find and remove any duplicated values, missing values, and correct any formatting issues. - Numeric Data: The numeric data in the dataset has inconsistent decimal places and a few outliers that need to be identified and adjusted. Ideal skills for this project include: - Proficiency in Excel, particularly in data cleaning and data analysis. - Experience in handling both text and numeric data. - Strong attention to detail to identify and rectify issues within the dataset. Please, only apply if you have experien...

I'm looking for a professional who can carry out a transformation of a PDF file to a Word file. The goal is to preserve the file's genuine formatting as much as possible. The PDF document comprises both text and images/charts, and you must be adept at maintaining their arrangement in the Word format. I also require basic formatting like font adjustments, bold and italic applications in the Word document. The ideal candidate should have relevant experience in similar projects and a keen eye for detail. Mastery in MS Word and PDF tools is a prerequisite.

I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.

I'm looking for a skilled professional who can assist me in entering text data into our project reports. Ideal Skills and Experience: - Experience working with project reports - Proficient in digital data entry - Attention to detail The reports will be provided in digital format, such as Excel or Word. The main task will be to ensure all text data is accurately entered. Additionally, the ideal candidate should be able to ensure the report maintains a professional and consistent format throughout. You may be asked to apply company branding or use specific fonts and sizes. The ability to work with minimal supervision and meet deadlines is a plus.

...Mobile APP, Control Pannel Application + It must fully SAAS Based means related to the SAAS Based all the screen to be designed and implemented + CRM (Register Company, Lead, Converted, Communcation, Win Deal , Create Quotation and Invoice) + Access Control Management for all the SAAS Based module wise , user wise rights + We want to use MS SQL Server on the windows using Stored Procedure and required API is prefered Let me know your expertise in this and same time propose me your quotation with timetable to proceed. A Complete Control Pannel on Web based as application along with the Mobile APP + Desktop APP. With the below added features.:- + We will require you to make one Form Generator for the Grid and whole project will be made from this + We will require you to ...

I am currently running my vendor payments process using a combination of Excel, MS Forms, and Power Automate. I'm now seeking an expert to transform and advance this process using options such as Sharepoint List and Power Apps. The mission encompasses three critical areas: • Automating data entry and validation: Reducing manual input ensuring that the data fed into the system is accurate and up-to-date. • Approval workflow: A simplified yet efficient approval process ensuring no delays or oversights. • Payment generation: Timely and well-coordinated payment processing for a smooth and organized operation. Capabilities Required: • Handling high volumes: I am dealing with more than 50 vendors. So, proficiency in handling such a scale is a m...

I need a freelancer to enter numeric data into Excel from digital sources. Key Requirements: - Proficient in data entry - Expertise in working with Excel - Attention to detail The task is straightforward and simply requires the accurate transfer of numeric information into a pre-existing Excel template. I will provide the data in digital format (Excel, CSV) and expect it to be entered systematically according to the format provided.

I have a PDF document that is a mix of scanned and text-based content that I need converted into an editable Word or Excel format. I need this completed as soon as possible. The output needs to be fully editable, meaning that the text should be recognized and convertible to a format where I can change, add or remove text as needed. This means the scanned parts should be OCR-ed accurately.

I'm seeking an experienced freelancer for a data entry project. The task involves converting PDF files containing mixed data, both textual and numerical, into Excel. Ideal Expertise: - Proven experience in data entry - Proficiency in Excel and PDF conversion - Accuracy and attention to detail Please ensure all data in the PDF files is correctly transferred to the specified Excel format. I'm looking to post this project up to 100 Rupees. If you have the skills and can handle this type of work, I encourage you to bid.

I have a need for a comprehensive listing of Oracle EBS customers within the manufacturing sector in USA. This is a sizable task as it requires the creation of a list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelanc...

I have a small set of textual data that needs to be typed into an Excel sheet. The purpose of this project is to prepare the data for analysis. Key responsibilities: - Type less than 100 rows of textual data into an Excel sheet. - Ensure data accuracy and consistency. Ideal skills for this project include: - Experience with data entry. - Proficiency in Excel. - Attention to detail to avoid errors. The successful freelancer will need to deliver the Excel sheet with the data accurately typed within the given timeframe.

I'm in need of a skilled developer to create a robust course management database for our educational institution. Key Functionalities: - Student Registration and Enrollment: The database should be able to store and manage student information. - Grades and Transcripts Management: The system should have a feature to track, store, and manage students' grades and transcripts. - Attendance Tracking: The database needs to have a reliable attendance tracking system. - Multiple Courses: The system should be designed to manage multiple courses efficiently. Expectation: - The database should be able to handle 50-100 users accessing it simultaneously. - It needs to be user-friendly, secure, and scalable for future expansion. - Preferably, a responsive d...

I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Su...

I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tun...

I'm in need of a skilled freelancer to scrape data from car Website . The specifics of the data extraction are as follows: - I require product details and price information from the site. - The main task involves capturing a comprehensive car database, including all car brands and models present on the site. The focus here is on the complete car directory, not just specific brands or models. If you have experience in web scraping, particularly in the automotive sector, this project is for you. Accuracy and completeness are key, as the success of the project hinges on the comprehensive nature of the dataset. I attached RAR file (Scraping code). by running this script, fetching yourself full database of cars. pocketbase queries to supoprt filter...

The project entails accurate entry of numerical data into an MS Excel spreadsheet, with a focus on report generation. The ideal freelancer should be well-versed with basic Excel functionalities, such as simulations and formulas, to ensure efficient data processing. Key responsibilities would include: - Accurate and efficient numerical data entry - Setting up Excel to run basic simulations and formulas - Generating effective and accurate reports from entered data The freelancer should have strong attention to detail to maintain data accuracy and proficiency in MS Excel, specifically in creating basic simulations and formulas. Previous experience in data entry and report generation is highly preferred.

...experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new database system. The project involves working with Microsoft SQL Server Analysis Services in an Azure SQL environment. Key Responsibilities: - Designing a new database system - Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Experience working in an Azure SQL environment - Expert coding skills in...

I need an expert to design a fully customizable Word document template for me. I need a simple clean professional looking template ...placeholders for inserting images Also, the design should have a cover page which must contain the project title, my company's logo, as well as date and version number. Within the custom header and footer, the template should have provisions to include company's name, office address, the document title, and some contact details. The ideal freelancer for this job should have a solid understanding of MS Word functions and a knack for tidy, clear layout design. A portfolio demonstrating similar experiences would be greatly appreciated. Please note that I'd also require a brief run-through on using the template once it's completed, ...

I require a professional with a keen understanding of both Excel and iOS Numbers to convert a single-sheet Excel spreadsheet into an iOS Numbers document. The converted document will need to retain multiple functionalities including: - Basic calculations - Data visualization - Conditional formatting No data interdependency or connectivity with other aspects is required in this case. The ideal candidate should have significant experience with data conversion between these two platforms and a solid grasp of maintaining functionalities in iOS Numbers. Familiarity with creating visually engaging spreadsheets will be highly regarded. I would like to have conversation with someone to make sure I am asking for something reasonable and to clarify exactly whats neede...

I want to rank in the top three google results on average for the following keyword phrases Target Country is USA 1 - Accident Lawyers 2 - Truck Accident Lawyers 3 - Car Accident Lawyers 4 - Boat Accident Lawyers 5 - Construction Accident Lawyers 6 - Lyft Accident Lawyers 7 - Uber Accident Lawyers 8 - Pool Accident Lawyers 9 - Personal Injury Lawyers 10 - Motor Vehicle Accident Lawyers 11 - Personal Injury Lawyer Near Me 12 - Lawyer For Car Accident 13 - Personal Accident Lawyer 14 - Car Lawyer Accident 15 - Attorney Personal Injury Near Me 16 - Accident Lawyers Car 17 - Personal Injury Lawyer Attorney 18 - Car Accident Attorney Lawyer 19 - Accident Lawyer Near Me 20 - Lawyer For Auto Accident This is for the website The ranking must hold for 1 month before escrow

I'm in need of an MS Office expert, specifically proficient at Microsoft Word. The primary mission is to guide and collaborate with me in exploring advanced features within this application. Key Tasks: - Provide robust understanding of advanced MS Word features - Work collaboratively to implement these features Ideal Skills: - Comprehensive understanding of MS Word - Practical experience in using advanced features - Good communication and explanatory skills NOTE: As the specifics concerning these advanced features were not provided, a versatile skill-set and willingness to adapt are key.

...a baseline construction schedule built already; it has around 1000 activities, the schedule is cost & resource loaded. I will provide the update in excel (actual start, actual finish, actual cost), the monthly activities that needed to be updated (actual date & Cost) around 100 activities every month. Please note sometimes I need to provide you comments on the schedule update, so you need to fix the comments. I need you to update the start/finish date and insert the actual cost monthly (once every month). Plus, prepare small narrative report including some P6 PdF. I have the P6 layouts I will share with you. I have the report and layout built in already and I will share it with you. Finally, send me XER file, and Narrative report every month. It is very i...

I am looking for an experienced developer to set up an Airtable Database for me. This project involves creating a systematic way to handle, organize and manage our client information, employee management details, and project tracking. Key tasks include: - Setting up an Airtable Database - Enabling specific functionality such as data import/export - Custom form creation for easy data entry and extraction - Integration with other apps for streamlined operations Ideal Skills and Experience: - Proven experience in using and setting up Airtable databases - Strong understanding of data integration and manipulation - Familiarity with custom form creation - Experience with app integration for seamless data sharing - Knowledge in handling sensitive data with an emp...

I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.

...it, is to create a compelling proposal essay for my professional/technical writing class. The challenge at hand is the housing discrimination faced by people on parole. The crux of the issue, as I see it, is the bias encountered during rental applications. This keeps parolees stuck in a cycle of inconsistency, making it harder for them to re-integrate into society. This paper should aim to construct a new method to tackle this problem. Your proposed solution should predominantly aim to reduce discrimination in the housing sector. How we plan to achieve this is through community awareness programs. You need to build a case for educating the public and reducing prejudices, arguing that information and understanding can be a powerful tool against discrimination. Your ...

I'm in need of an Excel expert who can help me create a sophisticated formula for data analysis. The data I'm working with is moderately complex, involving multiple variables. It's all housed in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, with a focus on complex data analysis - Experience in creating advanced formulas for data manipulation - Strong understanding of data structures in Excel and how to work with multiple variables - Previous projects involving statistical analysis would be an advantage I'm looking for someone who can not only create this formula, but also explain its function and how to adjust it for future data sets. Please provide examples of similar project...

I am in need of a seasoned Microsoft Access developer to create a comprehensive database solution for my business needs. Key Project Details: - I require a robust database with more than 10 tables. - The database should feature data entry forms for easy information input. - It should have advanced error-checking capabilities to ensure data integrity. - Reporting and analytical functionalities are essential for tracking business performance and making informed decisions. Ideal Skills and Experience: - Proficiency in Microsoft Access and database design. - Strong track record of developing complex databases with user-friendly interfaces. - Experience in data validation, error checking, and report generation. - Excellent understanding of b...

I'm in need of a Java developer to create a standalone application for a small school. The application will be used to manage student records, various school resources, and facilitate communication with parents. Key Features: - Student Records: The application should be able to manage and track student progress through interactive line charts. - School Resources: The app should also help in handling school resources such as time, costs, and salaries. - Parent Communication: There should be a feature to enable communication with parents in a structured and efficient way. Ideal skills for this project include: - Proficiency in Java development - Experience in creating standalone applications - Knowledge of building HTTP connections - Strong underst...

I'm currently in the process of creating a cost items database for residential electrical service items. I would like someone who has previous experience with similar work. I will need the database to be input into my management software called "Contractor Foreman". This database will need assemblies of materials assigned to each task. Key Requirements: - Cost estimates for lighting fixtures, electrical outlets, circuit breakers, and all other necessary items for a residential electrical service and remodel with adjustments for different types of condition that can e encountered. - A detailed breakdown of costs for each category is essential. - Extensive experience in providing accurate and reliable cost estimates for electrical syst...

...an intricate Excel model to calculate a cumulative threshold commission scheme, tailored to three varying levels of seniority: Junior, Mid-level, and Senior. The model needs to be exceptionally flexible and versatile to allow for easy manipulation and scenario planning. Key Requirements: - Create a multi-level commission scheme: The model should have different commission percentages for each level of seniority. - Cumulative Threshold Calculation: Incorporate a mechanism to calculate cumulative thresholds. - Revenue Generation Calculation: Develop an accurate formula that calculates the revenue generated. - Flexibility in Threshold Percentage: Ensure that the threshold percentage can be flexed. - Cash Retained in the Business: The final model should account for cas...

...need an expert in Excel spreadsheet and dashboard creation to help me with a project related to the management of properties. The project involves the following tasks: - Data analysis - Formulas and calculations - Data visualization The data to be used in this project will mainly revolve around a situation room containing property under management status and updates. Specifically, the dashboard should track and monitor the following key metrics: - Rent collection and payout status - Tenant and business complaints - Contacts details - Contracts status - Property profits - Property location - Owner notes - Comments If possible to have it as geolocation kml as a copy I'm looking for someone with strong experience in creating dashboards and spreads...

...expertise in using Python for backend development, JavaScript and HTML for frontend. Key Components: - Backend programming using Python - Frontend programming implemented with JavaScript and HTML Key Functionalities: - Database Integration: The software developer should be able to create a seamless link to an existing database and enable secure data exchanges. there is already excel .xlsx file in the folder - API Integration: The project includes integration of specific APIs to provide essential functionality for the Web Application. Purpose of the Project: - The main goal for this project is to develop a functional web application and host it either on a server or GitHub. The application isn’t static and employs IT-technical features. Idea...

I have the attached images , I need it to be in excel form.

I have a son, he's 15 years old. I want him to study as a supplement geology, namely Economic Geology (mining of minerals such as...he's 15 years old. I want him to study as a supplement geology, namely Economic Geology (mining of minerals such as petroleum, gases, coal, etc.) I need a teacher who: 1) understands the subject himself; 2) is able to present these topics to the student in a competent way. The lessons will be done online, and the expected workload is +-5 lessons per week, one and a half hours each. The teacher will be responsible for the development of the course. We live in Chicago. - Desired Skills and Experience: Deep understanding of and experience in Petrology, Paleontology, Mineralogy, and Economic Geology are a must. Previou...

I am in need of a proficient data entry operator, for a smaller task of less than 100 entries. The data will be provided to you in the form of scanned documents and you will be required to interpret and enter this data accurately into an Excel worksheet. - You should have experience with data entry from scanned documents into Excel and attention to detail is of utmost importance here. - Understanding of Excel basics is also required for successful execution of the task. - The format of data delivery will be an Excel worksheet. Proficiency in English and a strong attention to detail would be ideal attributes for this task.

I'm in need of a skilled Excel professional to assist with data analysis tasks. The primary focus will be on trend analysis and results should be presented in the form of detailed reports. Key requirements include: - Proficient in data analysis using Excel - Experience with creating reports - Attention to detail - Ability to communicate complex data in a clear and concise manner Please only apply if you have experience in trend analysis and report generation using Excel.

Edison Robotics Online Curriculum Development (E-Learning) Grade Level: Age 7 to 17 year School student 36 lessons x 1 hour per level ( intermediate and advance) Content Needed: Interactive Activities and Videos The estimated duration of this project is 1.5 week per level I am looking for organisation or freelancers to create an online e-learning curriculum (Edison Coding and Robotics ) for students focuses on coding and robotics. Course delivery Must include : -modify/create online instructional lesson (step by step) into our LMS for students self learning (elearning) - modify/create Quiz and interactive gamification during the learning . - modify/create Assessment and upload of project at this end of the day - modify/create Lesson plan briefing guide - modify/create Teacher Pla...

I am in immediate need of an Excel specialist who is well-versed in formula troubleshooting and fixing. There are 4 formulas that require attention; unfortunately, I am unable to enumerate them as I skipped that information. However, here's what I can provide: - Detailed description of how each formula should function - Expectations for the fixes I'm looking for individuals who are confident they can rectify the issues and can offer neoteric solutions. This project requires more than just experience, a resourceful approach to problem-solving is necessary. The application must include: - Detailed project proposal The proposal should provide clear insight into your troubleshooting steps, planned adjustments, and method of testing the new formulas. Tim...

We have a requirement for somebody with MS Flows experience in 365 to troubleshoot and fix and possibly create additional flows in 365. Currently 2 issues, with forms and flows failing but would like to have it as an ongoing replationship.

I am looking for a freelancer to assist me with a typing project. The project involves typ...typing project. The project involves typing more than 100 pages of PDF documents. Requirements: - Proficient in typing and attention to detail - Ability to follow instructions and work independently - Experience with typing PDF documents is preferred but not required Specifics: - The documents do not require any specific formatting and can be typed in any standard format. - The freelancer has the freedom to choose the most suitable formatting for the documents. Skills and Experience: - Excellent typing speed and accuracy - Strong attention to detail - Ability to work independently and meet deadlines Please provide a sample of your previous typing work. Thank you for your interest...

I am seeking a developer to create an Excel-based order placement tool for TradeStation, utilizing EasyLanguage. This tool will be designed to execute trades based on alerts from a specific indicator and strategy. Key functionalities should include support for OCO (One Cancels the Other), OSO (One Sends Other), and Basket orders. This is a fixed-price project. Payments will be released upon successful completion of predefined milestones. Please contact me if you're interested in this opportunity.

As a beginner seeking to master Dynamics 365, I am in need of an experienced trainer to equip me with essential skills and knowledge through live interactive sessions. I am particularly interested in learning about: - Dynamics 365 Customization and Configuration An ideal trainer for this project should be: - Proficient in Dynamics 365, with a specialization in customization and configuration - Experienced in conducting live interactive training sessions for beginners - Excellent communicator, capable of simplifying complex concepts into understandable lessons - Patient and passionate about empowering others with new skills - Training should include below, topics at minimum and more details in attachment: - Creation of Dummy Accounts ...