Excel pivot tabelle database connection jobs

I'm looking for an experienced PHP developer to work on a new E-commerce website. The project involves: - **Website Development**: You'll be responsibl...E-commerce website. The project involves: - **Website Development**: You'll be responsible for creating a complete E-commerce platform. This includes setting up the necessary pages, product listings, and a user-friendly interface. - **Database Management**: Besides building the site, you'll also be in charge of managing its database. This involves ensuring data integrity, proper storage, and efficient retrieval. Ideal candidates for this project should have: - Proven experience in PHP development, specifically in E-commerce platforms. - Strong database management skills. - Understanding and e...

I need a professional, polished website with an interactive quiz designed specifically for lead generation. This site should be a duplicate of but with different content (I do have permission from that site owner) Any bids received in the first 15 minutes will not be reviewed. It will take you at least that long to review to u...websites being a big plus. - Proficiency in creating quizzes and implementing clickfunnels to capture and manage leads effectively. - A keen eye for design and user experience, with a proven ability to create professional and polished interfaces. If you can bring creativity, technical expertise, and a strategic approach to this project, I'd love to hear from you. Bonus points if you have a connection to the disabled community.

I'm looking for an experienced PostgreSQL professional capable of analyzing and generating reports from sales data. Key Responsibilities: -Analyzing sales data stored in PostgreSQL -Generating insightful reports based on analysis Ideal candidate should excel in PostgreSQL and possess strong data analysis skills. Previous experience with sales data is an advantage, however, specific functionalities required for the analysis have been left open-ended for your expertise to fill. Please outline in your proposal any relevant experience and your approach to this task.

If C4 and D4 have no entries, make E4 blank. If C4 and D4 have values, perform C4/D4 in E4.

I need an expert in data formatting to help me clean and organize a large Excel file. The file currently contains unformatted data that needs to be segmented into distinct columns. I need the data separated into the following categories: - First Name - Last Name - Company Name - Position The ideal candidate for this job should have: - Proficiency in working with large Excel files - Experience in data segregation and formatting - Attention to detail to ensure data accuracy - Ability to follow instructions and deliver in an Excel file format Given that there are more than 500 entries in the file, efficiency and accuracy are key. The final deliverable should be an Excel file with the formatted data ready for use. If you have read till and reviewed the file, wr...

I am looking for a skilled developer to enhance my site by integrating Google Meet API functionalities. The ideal candidate will be responsible for creating a seamless connection between our site and Google's services, enabling automated event management and notifications. Key Responsibilities: • Develop and integrate a feature to create Google Calendar events directly from the my platform. • Implement a system to receive push notifications on my site when an event is canceled. • If feasible, establish a method to generate and retrieve Google Meet links for these events. Requirements: • Proficiency in API integration, especially with Google APIs. • Understanding of authentication mechanisms, specifically bearer tokens. • Ability to work with...

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.

I'm in need of a professional who can efficiently handle data entry tasks into a database. The source of the data will be a mix of physical documents, digital files, and potentially web sources. Key Requirements: - Experience in online data entry. - Proficiency in database handling. - Strong attention to detail. - Ability to work with a variety of data sources. Your primary responsibilities will be: - Entering data accurately into a database from various sources. - Ensuring the integrity of the data being entered. The ideal candidate should be able to demonstrate a high level of focus and accuracy while working at a reasonable pace.

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...

I am looking for a professional who can create an Excel sheet that will help me manage my product list and other essential production data. The excel file requires: - Filtering and Sorting Capabilities: The sheet should be able to sort and filter data easily. - Inventory Tracking: It is crucial that the sheet can track inventory levels to prevent overstocking or shortages. - Report Generation: The ability to generate reports will help me keep track of my production and make informed decisions. I need the excel file to have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is accurate. Idea...

I'm looking for someone to create an API connection between Zapier/google sheets and Hubstaff. Our end goal is to automate the creation of client, project and geofence locations in Hubstaff whenever a row gets filled with data in google sheets, essentially populating Hubstaff with the same jobs as what is in google sheets. Currently I have an automation which copies the job name and location from into a google sheet so I am hoping you are able to set up an API that can read this Google sheet and create a client, job, geofence location (100m radius)m Select all team members, automatic timer to start and stop upon entering/leaving radius. Key Project Requirements: - Transfer of job details and customer information from Zapier to Hubstaff. - A good understanding of Zapier and ...

webscraping cdiscount using python and export it into excel

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...

Do you understand instructions when given and can do tasks on excel? Are you a beginner? Are you free right now to work with me and read the data in pdf so I can write it on excel? If your answer if yes to all of that question bid by asking any question regarding this post to make your bid high quality. NEEDS TO BE DONE TODAY. WILL TAKE 3-4 HOURS APPROXIMATELY. (just an approximation)

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I want to use Microsoft power automate for a simple RPA on my desktop browser. I want to repeatedly run a search on 6 websites which are ...extracted from individual PDF documents by going into each individual case docket and opening a certain document called a summons, which will have the defendant's address usually in the middle of the page, but always on the first page of the summons. Some of the summons are not PDF readable so I will need OCR functionality. Finally, when the data points are extracted, they can be exported into an excel file for mail merge and printing (that the easy part). The objective is to create about 7,000 individual mailings each month and to run the automation about twice per week. I need help finding the right OCR tools to work with power automate. ...

...license keys for an Excel template product. Key responsibilities are: * Design and develop a License Key Generator using Python. * Create it to have the flexibility of generating unique license keys, verifying these keys, and, if necessary, deactivating them. * Design and implement an API that allows the integration of generated license keys with my existing Excel templates. * Each license key must validate properly in Excel Template PRO. Besides, your work must include: * Order form * Implementing a MySQL database to store all generated license keys. * Building a response system that displays license keys on a 'Thank You' page after purchase. * Setting up an automated email system that sends emails to the customers with their unique license key ...

...making some changes to the the user interface of my healthcare database website. The primary goal of the changes is to significantly enhance the user experience and make it more userfreindly. This is not a "redesign" task! The staff have learnt how to use the database and I don't want them to have to need to learn their way around a whole new database... not requesting any major changes, but a few points which are mostly related to the way the information is displayed not being user friendly. I need specific changes made. Please see document attached. I'm hoping to work with someone who has experience in both database website development and user interface design. It's important to me that you understand that the way the databa...

I'm looking for an Excel file that contains a list of companies in Dubai, specifically from the Technology and Hospitality industries. The file should include the following information for each company: - Company name - Address - Phone number - Category of business Key requirements: - Data should be accurate and up-to-date - Companies must fall into the Technology or Hospitality industry

I am in need of an experienced freelancer who can assist in data analysis and Excel formula troubleshooting. Key Tasks: - Perform qualitative textual analysis on both textual and numeric data - Spot inconsistencies, errors and trends in the data - Troubleshoot any issues with Excel formulas and functions Ideal Skills and Experience: - Proficient in using Excel for data analysis - Exceptional skills in data interpretation and reporting - Strong problem-solving skills, specifically for Excel formulas and functions troubleshooting - Proven expertise in qualitative textual analysis.

...can assist me with various tasks in Microsoft Excel and content writing. The ideal candidate should be proficient in Python and C programming languages. In Excel, I require help with: - Data entry and organization: Assisting me in organizing existing data and entering new data into specific format. - Formulas and calculations: Creating formulas and performing calculations on the data. - Power point: Making power point presentation. - Programming: Automating specific tasks using Python and C programming. In terms of content writing, I need support with: - Copy paste: Help me in copy paste some data. - Story: Writing a story. - Resume: Writing a professional resume. The ideal candidate for this project should have a good understanding of Excel and programming, p...

I'm looking for an expert in Excel who can assist me with data analysis and spreadsheet design. The main objective of this project is to create compelling data visualizations. Key Tasks: - Analytical reviewing and summarizing of data - Design of clear and comprehensive Excel spreadsheets Objective: - Creating simple charts and bar graphs for data visualization The ideal freelancer for this project should exhibit solid skills and previous experience with data insights extraction, spreadsheet design, and data formatting. Familiarity with basic data visualizations such as charts and bar graphs is essential.

Excel expert. In excel, I have the following columns: Tasks, Responsible, Workload hours, and one column for each month with deadlines. For each responsible, I need the summarized workload by week. This is to be able to evaluate (based on the estimated workload-hours) if each responsible has enough available hours to deliver the tasks.

I am seeking a detail-oriented freelancer with experience in data entry and Excel to assist with a daily task of analyzing company data. Requirements: - Daily data entry in Excel for each company, including: - Financial statements - Stock prices - Market trends Ideal Candidate: - Proficient in Excel and data entry. - Experience with financial data analysis. - Ability to perform the task daily with accuracy and consistency.

I'm in search of an a...comprehensive business application for my enterprise. The primary aim of the application is to enhance our e-commerce operations to provide excellent digital experiences for our clients. Key Project Features: - User registration and login - An intuitive product catalog and browsing capability - Secure payment processing Integrations: - The app should be integrated with popular payment gateways - Connection with our existing social media platforms is a requirement - Integration with our email marketing services is also vital Ideal Skills: - Experience in app development - Proficiency in coding and using no-code platforms - Experience with implementing third-party integrations If you have the necessary skills and experience, please feel enc...

I'm urgently in need of a bookkeeper who can accu...a bookkeeper who can accurately categorize my last financial year's bank transactions and prepare them for inclusion in the General ledger. This task is primarily for tax filing purposes. My business currently operates on Quickfile so proficiency in this software is essential. Transactions classification is available in Excel, I'll be prioritizing freelancers who can demonstrate: - A strong background in bookkeeping - Knowledge of tax preparation, ideally within EXCEL - Quickfile experience - Proven ability to meet stringent deadlines. Your role will involve the correct categorization of numerous transactions, ensuring everything is in order for tax filing. Please be ready to start this project immediate...

I'm in need of an Excel expert with experience in Visual Basic scripts for a data extraction project. Here are the specifics I require: - Ability to handle 10-50 Excel files - Proficiency in extracting text, numeric, and date/time data - Creation of scripts for automating said data extraction Ideal candidates must have a strong understanding of Excel data manipulation and the ability to automate tasks using Visual Basic scripts. This project's success relies on your seamless extraction of diverse data types and transformation of Excel datasets into efficient, automated processes. Let's boost productivity together!

I am seeking a dedicated freelancer with relevant skills and experience in data entry to help me enter text data from multiple Excel spreadsheets. Here are the project specifics: - Data Source: The data needing entry is sourced from digital files, specifically Excel spreadsheets. - Data Type: The core of this task is the entry of text data. Ideal Experience and Skills: - Proficiency in Excel - High-speed typing - Accuracy and attention to detail - Confidentiality and trustworthiness Your responsibility will be to meticulously enter the text data from the given Excel files. As thoroughness and accuracy are key in this project, I would appreciate a freelancer who can guarantee this. Please bid if you feel fit for the project.

I am looking for someone to assist me with data entry and related tasks in Excel and Word. I need some typing, copy and paste type of data, that needs to be entered in systematic way. Skills and Experience: - working in Excel/Word - Attention to detail - Experience with data entry or typing - Ability to follow instructions and work independently Preferred Format or Template: While I don't have a specific format or template in mind, I have a rough idea of how I would like the data to be arranged. I am open to suggestions and willing to collaborate on finding the most useful format for the data. If you have experience in data entry and are comfortable working with Excel and Word, please submit your proposal and include any relevant experience. Thank you!

I'm on the hunt for a proficient typist with an eye for detail. Your task will be to manually convert a PDF document ...with an eye for detail. Your task will be to manually convert a PDF document into a Word file. The document is less than 10 pages long, but your accuracy in transcribing it is paramount. The requirements include: * Transcribing basic text from the PDF to Word. * Using a specific font style and size, to be exact, Times New Roman size 12. Ideal candidates will have a good record in data entry, Excel, PDF, and Word tasks. A fast typing speed, a sharp eye for detail, along with a strong grasp of English spelling and grammar are crucial for this job. Please bid if you're ready to start immediately, and able to deliver accurate work swiftly. Looking forwar...

I need a freelancer who can design 3 steel connections for machine frame assembly using Ideastatica or any other reputable software. Key Requirements: - Design 3 welded connections, specifically fillet welds - The connections are to be used in machine frame assembly Ideal Skills: - Proficiency in steel connection design - Experience with Ideastatica or similar software - Understanding of fillet welds - Previous work in machine frame design would be a plus

I'm looking for someone who can convert my handwritten sheets into an Excel spreadsheet. - Purpose: This is purely a data entry task. I don't need any analysis on the data, just a simple data entry from the sheets to Excel. - Detailed Formatting: I only require basic formatting. This means simple lists or tables, no need for any formulas, data sorting, or complex formatting. Please note: I will provide physical copies of the sheets to be converted. Ideal skills and experience: - Proficiency in data entry, specifically using Excel - Attention to detail and accuracy - Ability to follow clear instructions - Previous experience in similar tasks would be an advantage.

I am in need of a skilled Excel expert capable of understanding and applying advanced conditional formatting. The project entails: - Data analysis related tasks - Comprehensive use of both pivot tables and Excel formulas/functions - The main focus will be on setting conditional formatting based on both cell values and any contained text Here’s what you’ll need to do specifically: - Configure Excel to change the text color if certain conditions, related to cell value or text, are met - Set Excel to change the background color under the same conditions Ideal skills for this job would include: - Previous work with complex Excel functions and data analysis - Hands-on experience with conditional formatting - Detail-oriented approach to...

I am seeking a detail-oriented freelancer with experience in data entry and Excel to assist with a daily task of analyzing company data. Requirements: - Daily data entry in Excel for each company, including: - Financial statements - Stock prices - Market trends Ideal Candidate: - Proficient in Excel and data entry. - Experience with financial data analysis. - Ability to perform the task daily with accuracy and consistency.

...need a professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistical analysis - Prior experien...

I have a bulk of printed documents containing textual information that need to be accurately entered into Excel spreadsheets. Key requirements: - Input textual data from printed documents into Excel spreadsheets. - Ensure data accuracy and consistency. - Formatting of text to fit Excel cells may be needed. Ideal skills and experience: - Proficiency in data entry. - Strong attention to detail. - Familiarity with Excel spreadsheets. - Prior experience with similar data entry tasks is a plus. - Ability to work with printed documents is essential. Please provide an estimate of the time required to complete this task.

...script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, D...

I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...

I have a project that involves entering text data from printed documents into a database. Ideal Skills and Experience: - Proficiency in data entry and accuracy in transcription - Experience working with printed documents - Knowledge of database management - Attention to detail to ensure complete and accurate data input Key requirements for the job include: - Efficiently entering text data from printed documents into a database - Ensuring the highest level of accuracy in transcribing the information - Organizing the data in the database in a logical and coherent manner - Completing the task in a timely manner without compromising accuracy. Your understanding of the importance of this task in the overall project and your commitment to quality and efficiency w...

...Project Requirements: - **Data Import/Export**: The add-on should facilitate the smooth import and export of data in and out of Google Sheets. - **Custom Formatting**: The tool should allow for flexible, user-defined formatting options for the data within the sheets. - **Plaid API Integration**: The developer should be well-versed in integrating with the Plaid API, ensuring a seamless and reliable connection. Ideal Skills and Qualifications: - Proven experience in Google Sheets Add-On development. - Strong background in custom software development and API integration. - Familiarity with Plaid API is a significant advantage. The successful candidate will have an eye for detail, a commitment to quality, and be able to provide a user-friendly solution for data management in Google...

I'm seeking assistance with a aspect-based sentiment analysis project. I have an Arabic dataset with less than 10,000 entries in an Excel format. The goal is to train this dataset on the araBERT model for ABSA aspect-based sentiment analysis. Key Requirements: - Implementing Machine Learning: You should have a strong background in ML and experience with training models, particularly in the context of aspect-based sentiment analysis. - Expertise in NLP: Familiarity with Natural Language Processing techniques and Arabic language processing would be a significant asset. - Data Handling: Proficiency in handling Excel datasets, processing text data and preparing it for ML model training. The dataset is ready, Your role will include: - Model training: Implementing the araBER...

I need help with entering simple text-based data into Excel. Additionally, I need data validation to ensure the accuracy and integrity of the data. Key Requirements: - Expertise in Excel data entry - Ability to handle simple text-based data - Proficiency in implementing data validation - Attention to detail to ensure data accuracy This is a straightforward task, but accuracy is of utmost importance. Please only apply if you have experience in Excel data entry and data validation.

Hi Md I., I have another data scraping job, I need a list of all the address - seperated by street number with street name, suburb, state and postcode in excel. The suburb is Hope Island QLD 4212 in australia. Are you able to assist?

I am organizing The Wholeness Expo, a dynamic event set to energize and educate attendees about the intricate connection between the mind, body, and spirit. The foremost goal of this project is to promote holistic wellness by providing a diverse range of activities and workshops all under one roof. I aim to attract wellness enthusiasts and consumers interested in personal growth and wellbeing. As such, the ideal professionals for this venture are those who resonate with holistic principles and practices. The expo will host the following activities: - Yoga and meditation classes, which require an experienced instructor with sound knowledge of various yoga styles and techniques. - Nutrition and healthy cooking workshops; a seasoned nutritionist or health conscious cook would be per...

I require an expert in Excel to assist with the reformatting of dates in one specific column of my spreadsheet. The current date format is MM/DD/YYYY, and I need to modify this to DD/MM/YYYY (01/05/2024). The project involves approximately 150 records. The ideal candidate for this task would possess strong Excel skills and attention to detail. No additional modifications are required. Some 150 records.

I have around 70-80 tabs in excel that have projects and some other tabs that it’s not projects and I don’t need them . If I can give you list of tabs that I need to combine they all have same format but first 3-4 rows there is miscellaneous things that I don’t need to combine I’ll combine starting row 5 as example , is there a way to do that and if so what’s the best way ? Knowing that I might add new tabs in future or if a project is done , the person who maintain the excel will replace tab name and put new information . In combined sheet it will give a column at end or beginning of the information I’m combining . What’s the best way to do that ? The main tasks required are: - Merge the selected tabs into one sheet - Organize the ...

I'm seeking a skilled developer to help build a dynamic and secure social registry database. The primary purpose of this database will be to store specific categories of user information, making it a critical data backbone for our social business operations. Key features will include: - Storage of Personal Identities: User's demographic and identity-related data. - Interaction Histories: Tracking user interaction data for better service delivery. - Location Data: Storing user location data to improve geographically targeted offerings. Moreover, I envision a flexible data entry process encompassing: - Manual Data Entry by administrators: Option for admins to input data manually, ensuring the correct configuration and verification of user information. - Automated Da...

I'm in need of a VBA Excel expert to assist with generating weekly financial reports. Key Requirements: - Weekly Reporting: The expert should be able to create efficient and accurate VBA scripts that will automate the generation of excel charts based on our csv files reports downloaded from our service management software on a weekly basis. The chart is basically to display the Technician's daily sales of labour and material sold (shown in separate charts. - Financial Data: These reports will be based on our financial sales data, so the expert should be comfortable working with and manipulating this type of information. Ideal Skills: - Proficient in VBA for Excel: The ideal freelancer should have a deep understanding of VBA and Excel and be able to l...

I'm seeking a skilled data analyst to delve into 10,000 Blackjack hands for com...dealer's advantage: I require in-depth insights into the win rate and dealer's advantage across these hands. - Excel expertise: The data is in Excel format, therefore proficiency in this tool is essential. Desired Experience: - Statistical analysis: Extensive knowledge and experience in statistical analysis is crucial to provide accurate insights. - Gambling or gaming industry: Background in the gambling or gaming industry would be advantageous to understand the context of the data. The goal is to extract valuable statistical insights to further understand the dynamics of these Blackjack hands. A freelancer with the right skills and experience in statistical analysis and working...

Will develop tool in Python (with GUI), to extract images from excel file, based on user input. Will feature log system as well. More details as discussed. Expect quality work as always. Thanks for choosing me once again!