Excel create database summary tableงาน

I'm looking for a skilled professional to improve the accuracy of my cloud-based database. To achieve this, the tasks at hand include: - Identifying and removing duplicate entries - Standardizing data formats to ensure consistency - Conducting routine data cleaning checks to maintain accuracy Ideal candidates should have: - Proven experience in data cleaning and management - A deep understanding of cloud-based database systems - Strong communication skills as I prefer to get updates and progress reports through an instant messaging app.

...or Amazon VA. • Excellent verbal and written communication skills in English with clients • BSc/BA in Business and/or Marketing from an English speaking institute preferred • Solid organizational skills to timelines, tasks and documentation across multiple accounts • Expert knowledge of Amazon flat file upload (Seller Central & Vendor Central) • Advanced knowledge of Microsoft Office (expert in Excel) • Experience using project management platforms (Trello) • Able to analyze workload and tasks to estimate turnaround times • Fluent in English, other EU languages is a plus • Strong attention to detail • Analytical skills • Research and Problem solving skills • Strong interpersonal skill • Most importantly be passi...

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meaning to raw data is desired.

I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

Project Description Objective: Conduct a detailed analysis of several 3D planner software platforms to compare their offerings and pricing structures. The goal is to provide a comprehensive, visually appealing summary that highlights key features, subscription plans, and costs associated with each software. Scope: Competitors: The platforms to be analyzed include Saninet 3D Planner, MATICAD DOMUS3D, PALETTE CAD, TILE LOOK, VISOFT, and SPARK VISION. Data Collection: Extract detailed information from the competitors' websites, focusing on: Price Features Customer Support Compatibility Cost Type of Subscription What is included in each type of subscription 3D Modeling Costs: Gather information about the costs associated with 3D modeling for new products, including the data requi...

...Strong communication skills to effectively engage potential testers. Ability to manage and motivate a group of testers. Familiarity with mobile app testing processes is a plus. Access to various platforms and communities to reach potential testers. Deliverables: A list of at least 20 testers who have opted-in to the closed test. Documentation of the engagement and feedback provided by testers. Summary report of the testing phase, including key insights and suggestions from testers. Project Timeline: Recruitment of testers to be completed within 7 days. Closed testing phase to run for 14 days after the recruitment period. How to Apply: Please submit your proposal with the following details: Your experience in recruiting testers or similar roles. Your strategy for finding and e...

I am looking for someone that has listened to the Drake vs Kendrick Diss tracks many times. I need someone that is very active with the culture & knows almost everything thats going on in this beef. I need someone that has seen all the memes around the beef. And knows the history of the beef. I'm looking to put together some content around this beef. And I need someone that can guide me. 1. How old are you? 2. Where do you live? 3. Who do you think won the battle and why? 4. If I needed you to defend the loser, could you do so? 5. Tell me something interesting about this beef? 6. What social media platforms are you active on? 7. Did you auto generate this application you sent me, or did you type it out?

I'm in need of a skilled developer to create a score card module using MAUI. This module should allow for the following: - **Score Entry**: Users should be able to input scores into the system. - **Calculation of Scores**: The module should be able to process the inputs and calculate the final scores. - **Display of Scores**: The final scores should be presented in form of summary reports. This module is designed for administrators, so it should only be accessible by those with administrator privileges. Ideal candidates for this project should be proficient with MAUI and have experience with creating data-driven modules. You should be able to integrate various data input methods, develop calculations and create concise, visually appealing reports. Kindly pro...

I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.

I need a proficient Microsoft Word expert to design a comprehensive report template that contains all the requisite sections for a detailed report. The ideal freelancer for this project should have: - A solid understanding of Microsoft Word. - Previous experience in creating professional templates or reports. The key sections that the report template should include are: - Title page - Table of contents - Introduction - Body - Conclusion - References Each section should be clearly defined and easy to navigate. For the title page, it should encompass the following elements: - Project title - Client's name - Date - Project logo - Project description - Title block I require standard formatting and styling for the title page and the entire document. It's crucial that the ...

...composes CG characters into a live-action MP4 video scene in AI and Machine learning. Build AI based tool for auto dubbing, close captioning text, Create Professional custom 3D Character animates, lights, and composes CG Robot and Alien and creates custom Voices for the video 3D Robot & Alien characters. You will need to help me create any needed AI access and License accounts. I am seeking a proficient developer to create an AI-based tool that automatically animates, lights and composes CG characters into a live-action scene using AI and Machine learning. Using all the proper rigging of the the 3D Characters. I'm also needing you to create an AI-powered video dubbing feature for this software that can operate smoothly on Windows OS. This...

I'm looking for a skilled HTML/CSS designer to produce a visually appealing report. It should include an executive summary. Key Requirements: - Design a report, not just a website - Primary focus is the Executive Summary - Use HTML/CSS to create a visually appealing, easy-to-read document. Ideal Skills: - Strong command in HTML/CSS - Ability to create clean, modern designs - Experience in designing reports is a plus

I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.

Graphic Design for 3m x 3m gazebo and a 1.8m long table table cloth Looking to use the attached logo in the middle of the designs This will be for a NAIDOC event (please google NAIDOC week to get an idea of what this means) Australian Indigenous designs/ patterns with reds, oranges and yellows Thank you.

...registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel upload integration: Experie...

...Dashboard Pages: • /signup • /signin • /forgot-password • /reset-password o Authentication logic with two roles: user and admin o Forget / Reset password logic required • /home o Accessible to logged-in users only o Displays bot updates and useful links o Updates data retrieved from the database • /profile o Accessible to logged-in users only o Contains a user profile data form o Displays database data upon form submission • /subscription o Contains one disabled “Buy now” component with Free plan • /admin o Table of users with 3 fields (email, name, phone) and pagination All features should be implemented with server and client side input data validation, adhering to best practices for security, performance, and ex...

Create Microsoft Planner without SharePoint site or MS Teams

I require a freelancer skilled in survey design and impactful visual content to make changes to an existing electronic survey I have in Survey Monkey. Here is some insight into the specific tasks you'll be undertaking: - Update and enhance the current survey: This involves infusing fresh content by updating existing questions, introducing new questions, and replacing the current graphics. - Create an entirely new survey: This will include a mix of existing and new questions, along with logos and product images. The goal of this survey will be to gather customer feedback, so creating questions that retrieve valuable customer insights will be essential. - Build a survey flow and link answers for follow up automated EDMS and other forms of communication. - Survey results will...

I'm in need of a comprehensive Business Evaluation report. This report is meant to serve as an evaluation of a company's performance. - Contents: The report should include the following sections; - Executive Summary: A summarized version of the main findings. - Company Description: A detailed account of the company under evaluation. - Industry Analysis: A comparison of the company's performance within its industry. The ideal freelancer for this task would have substantial experience in business report writing and the ability to present data in a clear, readable manner. Expertise in Microsoft Word is a must. A deep understanding of industry analysis and company description is also desirable.

I need a professional to prepare my income statement and balance sheet according to IFRS standards. My records are ready, and I only require a summary-level of detail. Ideal skills and experience include: - Proficiency in IFRS (International Financial Reporting Standards) - Proven track record in preparing financial statements, especially income statements and balance sheets - Detail-oriented and able to work with a high level of accuracy - Good communication skills to clarify any details for a summary-level reporting. This is a one-time project, but if successful, there may be more in the future.

I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.

I'm in need of a skilled video editor who can help me bring my creative stories to life. I have some great ideas that I want to turn into engaging videos, and I need someone who can help me with this. Key requirements: - Proficient in video editing software - Ability to turn raw footage into a polished, engaging final product - Creative and able to bring fresh ideas to the table - Strong storytelling and narrative skills - Experience with editing videos longer than 5 minutes If you have a keen eye for detail, a passion for storytelling, and enjoy bringing creative ideas to life, I would love to work with you on this project.

...will be the exclusive property of Next. Next project: 1. Create a timeline. 2. Create a wireframe of the project 3. Create the UX of the project while the rest of the project progresses. 4. Create the AWS site, create/set-up the servers and databases while the rest of the project progresses. 5. Create the Affiliates Setup and Control site 6. Create the Affiliate site - xx days 7. Create the Training site – xx days 8. Create the End User site – xx days 9. Create the Customer Management site – xx days 10. Create the Service Ticket site – xx days 11. Create the Routing and Scheduling site – xx days 12. Create the Billing Center site – xx day 13. Create...

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue(&quo...

I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry

I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!

I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.

I'm seeking an experienced software developer with in-depth knowledge of AutoIt EXE files. The main goal is to unpack a specific AutoIt EXE version, 3.3.13 an...version, 3.3.13 and help code in other languages (C# prefered) Skills and experience required: - Proficiency in AutoIt, especially in unpacking and analyzing its executables. - Strong understanding of Windows OS, as the unpacking should be done on a Windows machine. - Experience in producing detailed technical documentation is crucial, as I require comprehensive documentation on the process. In summary, the project involves: - Unpacking an AutoIt EXE 3.3.13 for code analysis. - Documentation of the unpacking process in detail. Please include your relevant experience and the estimated time frame for completing this ta...

Company Overview: is a leading online platform dedicated to providing innovative & effective financial education. Our courses and resources are designed to empower individuals to achieve financial success. Job Summary: We are looking for a versatile and highly organized Digital Marketer to join our team.

As the project owner, I'm looking to transform an image file of a 2D floor plan into a to-scale outline floor plan. For this project, the digitized floor plan should include room measurements. While I didn't specify a preferred software, utilizing a program adept at architectural design, such as AutoCAD or SketchUp, would be beneficial. The ideal freelancer would possess: - Proficiency in architectural drafting software - Experience transforming image files into digital floor plans - Attention to detail, specifically regarding accurate room measurements.

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complex...

I am experiencing slow query processing and management issues with large ...experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall d...

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. W...show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with ...

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, but not necessary.

I need a talented professional to create a modern executive resume for me. The resume will be used to apply for high-level positions in my field. Key Elements: - The resume must include a complete career summary, with a focus on my key achievements and professional experience. - It should follow a professional and modern format; I want a clean and visually appealing design that stands out in a competitive job market. Ideal Skills and Experience: - Proven track record in developing successful executive resumes. - A deep understanding of the technology industry. - Strong grasp of modern resume design principles. I'm looking for a freelancer who can deliver a high-quality, polished resume that effectively showcases my career achievements and aspirations.

I just need one task to be done I'm in need of a PHP Developer for a new project. The parameters and required skills are fairly open, as I've not declared any specific frameworks or preferences. Ideal candidates include those who possess: -...professional to apply. - Experience in both website and web application development. There's an opportunity to work on several PHP development projects, potentially ranging from website building, application creation, to API integrations. - An impressive design eye. I've left the space open for any design style you're confident with - be it minimalistic, bold and colourful, or clean and professional. In summary, if you're a PHP developer keen to work on a myriad of projects, this job is perfect for you. Include ...

I need a skilled Wordpress expert to address a migration i...the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP, theme and plugin compatibility issues. Your ability to troubleshoot and resolve migration issues will be crucial. I'm looking for a professional who can efficiently tackle this issue and ensure a smooth, seamless t...

I'm seeking a professional logo designer to create a wordmark style logo for my company, P32 Capital. The primary color I'm looking for is blue, as it should convey professionalism. P32 Capital is Real Estate Asset Manager company.

I'm in need of an analyst who can work with Excel spreadsheets to provide me with visualizations based on three years worth of data. The focus of this analysis will be to compare regional data against a national average. Key Responsibilities: - Conduct a descriptive data analysis on the provided datasets - Generate Excel charts and graphs that visually represent the insights from the analysis - Highlight significant differences and similarities between regional and national data The ideal candidate for this job should possess: - Strong proficiency in data analysis, particularly descriptive analysis - Proven experience with using Excel for data visualization - A keen eye for detail and accuracy in data interpretation - Ability to clearly present complex data fin...

I'm looking for an experienced professional who can draft a comprehensive privacy policy for my job posting website. Ideally, the freelancer should have: - Proven experience in drafting privacy policies for websites, preferably in the job posting industry - Excellent understanding of legal requirements and regulations related to privacy policies - Ability to ad...understanding of legal requirements and regulations related to privacy policies - Ability to adapt the policy to the specific nature of my website The policy should cover all necessary areas, outline my company's commitment to data protection and privacy, and ensure compliance with any relevant laws and regulations. Kindly provide a brief proposal on how you intend to approach this task and a summary of your ...

I'm looking for a freelancer who can take the annual billing data from my personal business and create a professional, neat invoice from it. Key Details: - Final Format: The final invoice should be in PDF format. - Summary: I'd like the invoice to include a summary of the total income generated over the year. The summary should be kept simple and straightforward with a total sum, without the need for categorization or a monthly breakdown. Ideal Skills: - Strong attention to detail: The invoice should be well laid out and error-free. - Graphic Design: Experience in adding logos and making documents look professional is a plus. - Familiarity with accounting and invoicing: Some knowledge of these areas will be beneficial for understanding the context...

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. ...

...currently in need of a professional who can assist in completing a database for over +14000 companies. The goal of this project is to generate high-quality sales leads. Key Project Details: - You will be required to include accurate and up-to-date contact information including phone numbers and email addresses. - In addition to the contact details, each company's key contact person's name must also be included in the database. The ideal freelancer for this project will have: - Prior experience with database generation and management. - Proficiency in data mining and web scraping techniques. - Exceptional attention to detail to ensure accuracy of information. - Proven track record in generating sales leads through database creation. This project i...

...scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a must. ...

Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination of commissions, hence accuracy and precision are paramo...

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamlessly integrates...