Importing hidden sheets excel sql 2005 jobs
Yesterday, OpenAI released the new module "ChatGPT 4.0". I want to create a video on how to automate and visualize Excel files using this new version. The thumbnail should include my face, the Excel logo, the OpenAI logo, and the text "Automate Excel with ChatGPT 4.0".
I am in need of a professional web scraper with Python expertise, who can scrape data from a website(with filter Options) and convert it into Excel format. Key Requirements: - Expertise in web scraping with Python, including dealing with website search filters. - Proficiency in data extraction and manipulation. - Experience in converting extracted data into Excel format. Please note that the specific website and the type of data to be extracted has not been provided as it was skipped by me. The project can be detailed further with the selected freelancer. If you have the skills and experience in this area, please do apply.
...a logo for the "FCA Jugend Förderverein e.V." The association was founded in 2012 and focuses on nurturing young talent in football. **Brief Overview:** - **Name:** FCA Jugend Förderverein e.V. - **Year Founded:** 2012 - **Colors:** Black and Orange - **Description:** The association is dedicated to promoting youth football development and providing opportunities for young players to grow and excel in the sport. **Design Requirements:** - The logo should reflect the essence of youth, growth, and football. - Incorporate elements that symbolize progress, teamwork, and dedication. - Use the colors black and orange prominently in the design. - Avoid complex designs and aim for simplicity and clarity. **Additional Information:** - Feel free to experiment with...
I'm looking for a virtual assistant to help with email management, data entry, and simple analysis in Excel. Key Responsibilities: - Sorting and organizing less than 50 daily emails - Responding to customer inquiries promptly - Filtering spam emails effectively - Entering new data into Excel - Updating existing records - Creating basic reports and charts The ideal candidate should have: - Excellent email management skills - Strong communication and customer service skills - Proficiency in Excel for data entry and basic analysis - Ability to work accurately and swiftly - Prior experience in similar roles is a plus. This is a long-term project with potential for growth.
I have a detailed list on an Excel sheet that I need converted into an organizational chart. The chart needs to include information like 'Grade', 'Nationality' and 'Occupation' and display them in a visually appealing format. Key Requirements: - Convert an Excel sheet which consists of approximately 140 line items into an organizational chart. - Display the following information in the chart: 'Grade', 'Nationality' and 'Occupation'. - Create visual lines connecting positions to indicate the reporting relationships. - Provide the final output in both PowerPoint and Visio formats. Customization: I am looking for a moderate level of customization in the design of the organizational chart. This includes playing wit...
I'm seeking a skilled individual to assist...spreadsheet will be primarily used for inputting income and expenses and should be updated on a monthly basis. Key requirements: - Design and development of a custom cash flow spreadsheet - Implement budget tracking, expense categorization, and cash flow projections - Ensure ease of use and understandability for monthly updates Ideal Skills: - Proficiency in spreadsheet software (e.g., Excel, Google Sheets) - Experience in creating budget tracking and cash flow projection tools - Strong understanding of financial data and analysis I'm looking for someone who can deliver a high-quality, user-friendly spreadsheet that meets these requirements. If you have relevant experience and think you're a good fit for this pro...
I require a freelancer to assist with a one-time copy typing project. The task involves entering data from a single document into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in copy typing - Proficient in Excel - Attention to detail and accuracy - Previous experience in similar projects is a plus.
I need a deft hand at Google Sheets, capable of mastering complex spreadsheet formatting and implementing powerful formulas. Your role includes: - Applying conditional formatting to enhance data visibility - Using lookup and reference functions to optimise data organisation and retrieval Your skill sets should ideally include advanced understanding of Google Sheets, proficiency in the application of lookup and reference functions along with a design-eye for effective conditional formatting.
ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou
...into various systems, maintaining data integrity. - Appointment Scheduling: Organize my calendar effectively, ensuring appointments are set up in a timely manner with all necessary details. Required Skills: - Proficiency in Microsoft Office Suite: Ability to create, edit, and manage documents, spreadsheets, and calendars in MS Office. - Familiarity with Google Suite: Experience in using Docs, Sheets, and Calendar for effective organization and collaboration. - Knowledge of Customer Relationship Management (CRM) software: Ability to work with CRM tools to manage contacts and interactions. Confidentiality: The tasks involved do not require handling sensitive information. However, a high level of professionalism and discretion in handling all information is crucial. I'm loo...
I'm in need of a Excel setup algo that can execute orders on Zerodha from excel file. I require the following features: - One click button: The system should be able to place and execute my selected orders from excel with one click button. - Customizable Order Parameters: I need to be able to set my own order parameters, including the stock, quantity, price, and other variables. The ideal freelancer for this project should have experience in: - Developing python algo application with excel. - Integrating with Zerodha API. - Implementing automated trading systems. - Creating user-friendly interfaces, with some level of custom design.
Velocity alert analysis and provide actionable insights. Key requirements include: - Proficient in analyzing velocity alerts using SQL or SPL or Python - Capable of translating data from a word file into actionable insights - Experienced in the field of identity analytics, risk engine, authentication channel for the digital banking platforms - Understanding of Account Takeover (ATO) or digital identity compromise - Leverage known data as it relates to the digital customer identity and risk decisioning. - Analyze data logs from customer authentication channels and digital banking applications for malicious use and bad actors. - Create long-term solutions and automation to processes that can be improved when digital member identity is being utilized. Refer to attached document for b...
As a client seeking to improve my understanding of excel, I would like a skilled instructor to guide me through the basics of formulas and functions, data analysis and reporting, as well as formatting and conditional formatting in Excel. Although I don't have a specific completion time, expediency is appreciated. Skills and experiences that would be ideal for this job: - Advanced Knowledge of Excel - Excellent Teaching Skills - Flexibility to cater to learning pace No preference was selected for the type of learning medium, so offering a blend of online videos, live training sessions, and written instructions could be beneficial to cover all bases.
...my HTML website, , to Google Sheets, and set up Recaptcha functionality as well. The ideal candidate should have the following skills and experience: - Proficient in HTML and backend integration - Experience with Google Sheets and its APIs - Ability to set up Recaptcha for form security Key responsibilities for this project will include: - Connecting the contact form on my website to Google Sheets - Ensuring the Recaptcha integration works effectively - Ensuring the data flow to Google Sheets is secure and consistent - Testing the entire system to ensure it is bug-free - Providing documentation for the integration for future reference Please note my server-side language preference is Google Sheets. I am open to suggestions on the best way to integra...
I'm looking for a Zoho CRM expert who can help me automate lead generation and contact management tasks within the platform. I need the Zoho CRM and Google Sheets to be synced forward and backward. I am open to using connector tools like Zoho Flow or Pabbly Connect.
ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou
I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.
I'm in need of a detail-oriented and communicative Virtual Assistant to manage key elem...reconcilliation of payments & invoices - Assisting with keeping track of repairs using Zoho Desk - Handle customer support inquiries via Email, Phone, and Live chat --Respond directly to basic queries --Forward on relevant information to our local staff - Execute order management tasks The ideal candidate should have: - Excellent written and verbal communication skills - Data management and excel skills are critical - Ability to manage multiple tasks simultaneously - Familiarity with various customer support and order management tools - Available for 4-8 hours per day. - Experience with Zoho one - Understanding of laptop parts or experience in the laptop repair industry Please quot...
...freelancer who can handle both video editing and excel management. - Video Editing: I have various types of videos that need to be edited. This includes marketing videos, tutorial videos, event videos, and reels. The ideal candidate is proficient in video editing tools and can create engaging, professional videos that suit different platforms such as social media, websites, and presentations. - Excel Management: On the other hand, I also require assistance in organizing and managing data on Excel. You should have a good grasp of Excel functions and be able to maintain and update spreadsheets effectively. Ideal skills: - Proficient in video editing software - Experience in creating marketing, tutorial, and event videos - Skilled in managing data on Exc...
...entering high complexity data into Excel. The data is scientific research data and involves working with an extensive database. Key Requirements: - High level of attention to detail is crucial, as inaccurate data entry could have significant implications. - Familiarity with Excel and proficiency in data entry. - The data involves scientific research data, so any background in related fields would be beneficial. Tasks: - Entering the data accurately and efficiently. - Applying conditional data validation as required (e.g., specific formats or criteria for entries). - Ensuring the database is updated and maintained accurately. Ideal Skills and Experience: - Proven experience in data entry, ideally with high complexity data. - Strong understanding of Excel, particul...
I'm looking for an expert to scrape data from a website. I will provide the list of data (approx. 16K entries) that will be entered into the search bar and I need 2 fields extracted from each search into an excel sheet. This will be a one-off scrape of the website.
I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong atte...freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatili...
...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and r...
As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable....
As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable....
I'm seeking a proficient bookkeeper to manage my manufacturing company's financial transactions. You'll be responsible for creating income statements, balance sheets and managing our accounts payable. Ideal Skills and Experience: - Demonstrated expertise in QuickBooks - Strong understanding of manufacturing sector financials - Experience preparing income statements, balance sheets, and managing accounts payable Your proficiency with QuickBooks and a firm grasp of the financial demands of the manufacturing industry is crucial for the success of this project.
I'm seeking a proficient Excel expert who can help me create a complex formula for my Excel sheet. The formula will involve an IF statement assessing multiple values and conditions. its one simple formula Key Details: - The formula should be able to evaluate whether a given value is: - Greater than a certain threshold, - Less than a certain threshold, or - Equal to a specific value. - Each of these conditions should trigger a different calculation (to be defined). You should be familiar with creating complex formulas and IF statements in Excel. Your attention to detail and understanding of data manipulation will be crucial in ensuring the formula works accurately. Additionally, your proactive problem-solving skills will be highly valued as you help me d...
...Head Teacher. Key Responsibilities: - Spruce up and share our awesome social media content - Dive into the world of sponsored videos – post, analyze, and keep the momentum going! I expect the selected assistant to be self-motivated and proactive in managing and growing our online presence. - Familiarity with TikTok, CapCut, Instagram, YouTube, Business Suite, and WhatsApp - Basic Excel and Google Sheets skills (don't worry, nothing too fancy!) - Bring your A-game with a friendly, organized, and positive attitude - Ready to soak up knowledge like a sponge and tackle any challenge with a smile Your role as our trusty assistant: - Work your magic by editing and posting videos across our social media platforms, following our director-approved marketing strategi...
I need a professional who can quickly and accurately input less than 100 rows of data into an Excel file. You'll be provided with all the necessary data, so there's no need for additional sourcing. Ideal Skills and Experience: - Proficiency in Excel - Fast and accurate data entry skills - Attention to detail to ensure correctness - Experience in working with data sets This is a straightforward project that needs to be completed quickly, so I'm looking for someone efficient and reliable. If the data entry is done well, there is potential for more work in the future.
...hours for £10, rent for 3 hours for £15, rent for 4 hours for £20, rent for 5 hours for £25, or rent for 6 hours for £30. Instead, could this be a dropdown. Instead, I would like to replace this with a tick box that users tick to bring their own rifle or leave unticked if they would like to rent a rifle. The system should calculate the price automatically. I will give you a wp-content folder and sql file you can import and work with to make these changes. Simply import these folders in the zip to WP Local, which can be downloaded at or use any other software you choose. The maximum deadline where all files should be handed back by is Friday 24th May 2024 at 23:59 BST....
I'm looking for a professional who can take my Google Sheets application and turn it into a fully functional web app, accessible to anyone, without the need for a Gmail account. Key requirements include: - Conversion of the existing functionalities to a fully operational web app - Implementation of data manipulation and calculations on the web platform - Ensuring user-friendly design and intuitive interface - The final product should be easily accessible and usable by a wide audience Technical Skills and Experience: - Proficiency in web development using HTML - Experience in data manipulation and calculations - Prior experience in app development, especially in converting existing tools to web-based platforms - A strong sense of design and user experience - A good understandi...
Hello, we are looking for someone to help manage our Facebook and Instagram account by responding to DMs, comments, and engaging with users. Additional tasks/skills: - Doing research, data processing & analytics - Creating Reels on Instagram / TikTok videos - Gmail, Google Docs (Docs, Sheets, etc.) - Good customer service - General admin - Knowledge of Quickbooks - Has good English and interpersonal skills We are looking for someone who is flexible to work from 5 to 40 hours a week.
I need an Excel expert to help me generate all possible combinations of 12 distinct objects, amounting to 2048 total objects. This will involve the use of Pivot Tables, Macros, and Complex Formulas. Key Requirements: - Proficiency in Excel: You should be highly skilled and experienced in using Excel and its various functions. - Experience with Pivot Tables: You must know how to create and manipulate Pivot Tables to organize the data effectively. - Macro Creation: You will be required to write macros to automate certain processes and tasks. - Strong Command of Complex Formulas: You should be comfortable working with complex formulas to handle the extensive data manipulation required. The end result will be a PDF file containing all possible combinations, derived from...
I'm in need of a skilled PHP developer with experience in PrestaShop 1.6 to add new features to my eCommerce website. Your role will involve: - Implementing new features as dictated by the project roadmap, with one activity being importing orders from a CSV file - Possessing a thorough understanding of Prestashop 1.6 is vital, along with a sound knowledge of PHP development - Demonstrating previous experience with similar projects would give you an advantage - Being proactive and communicative, with the ability to work autonomously and efficiently Please include links or details of previous eCommerce websites and similar projects you've worked on in your proposal.
...speech recognition and natural language processing - Experience in developing software compatible with Windows and Mac - Strong understanding of calendar integration and email automation On-Prem Client: Quivr Agent * Installation * Install Quivr Agent on Windows or macOS * Configure Quivr Agent to connect to local database and file system * Local Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Inclu...
I'm in need of an administrative assistant who is proficient in Microsoft Excel for data entry and updating tasks. Specifically, this role entails managing my product inventory. Your primary responsibilities would involve: - Entering and updating inventory data on a regular basis - Organizing and ensuring the accuracy of each entry - Handling large data sets in Microsoft Excel - Following-up to make sure if the items in the inventory is still available It would be beneficial if you're detail-oriented and have prior experience in this kind of work. Don't hesitate if you have questions. Looking forward to your bids.
We are seeking an experienced [VA] to help us with our company tasks such as social media posts, research data entry etc... The ideal candidate should have a strong background in [LinkedIn Job posting - data entry - Google drive/sheets] The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role
I need a basic template that modifies the existing Chart Trader Panel buttons. Basically, I just want all of the top Buttons to disappear, except the Close Button. Also the Bid and Ask display to be hidden. ===================== All buttons should re appear when the strategy is disabled. Also if we have multiple tabs with different charts. The buttons should only disappear on the tab where the strategy is enabled. The Close button, I just want it to be 1 big button if possible
We're in need of a detail-oriented data entry specialist to enter about 100 entries into Google Sheets. Skills and experience: - Proficient with Google Sheets and its functionality - Sharp attention to details - Excellent time-management and deadline oriented - Experience with numeric and image data entry is useful but not required Main responsibilities: - Accurate data entry within a short deadline - Add data in the correct Google Sheets' fields - Maintain data confidentiality and follow data security protocols If you are committed, dependable, and able to work with less supervision; we would love to hear from you.
I'm in need of an Excel expert to assist in creating advanced statistical or financial functions. Your job will be to help me with these complex Excel tasks and generate charts or graphs as the final output. Key Requirements: - Deep understanding of Advanced statistical or financial functions in Excel. - Ability to generate visual representations through charts or graphs. Your role would entail: - Collaborating with me to understand the data and the desired outcomes. - Leveraging your expertise to implement the appropriate statistical or financial functions within Excel. - Presenting the results in a visually compelling manner through the creation of charts or graphs. Please share your relevant experience and any sample work you've done in the pa...
...for my car rental business. Each tab in the spreadsheet represents a specific car. The app should allow employees to: Select a car category (corresponding to a tab in the spreadsheet). Select a rental date. Input various amounts (e.g., rental income, expenses). Automatically update the corresponding tab in the Google Sheet with the provided data. Requirements: Experience with Python and Google Sheets API. Ability to create a user-friendly interface. Strong understanding of gspread and oauth2client libraries. Good communication skills and responsiveness. Deliverables: A functional app that performs the required operations. Documentation on how to set up and use the app. Support for initial setup and troubleshooting. Budget: [Your Budget] Deadline: [Your Deadline] To Apply: Pl...
I have a requirement for someone well versed in Excel formulas and calculations, specifically with respect to tracking approaching dates. The main objective is to monitor upcoming deadlines. Ideal candidates should have: - Proficiency in Excel calculations and conditional formatting - Expertise in implementing algorithms to track deadlines - Strong attention to detail - Previous experience in project tracking or similar Your role would involve setting up the necessary formulas and conditional formatting to efficiently track these dates. Understanding the importance and urgency of deadlines, your input would greatly assist in managing our tasks better.
I'm experiencing issues with an Excel file that shows as 'We found a problem with some content...' when trying to open it. The file is 99.7 MB, which may be the issue. File is mainly contact details, text and photos. I've tried Excel's 'Open and Repair' tools with no success. I am aiming to work with an Excel expert who can recover the data without loss, if possible. The freelancer should have: - Intensive experience with Excel - A deep understanding of Excel file structures and experience in fixing corrupted Excel files - Familiarity with various recovery methods beyond just 'Open and Repair' I am looking forward to saving my data with your expertise. Let's discuss a potential solution ASAP. Please ...
I'm looking for an Excel expert to repair my medium-sized spreadsheet which is currently corrupted and crashes upon trying to open. Key tasks include: - Diagnosing why the file is crashing upon opening - Recovering both crucial data and restoring the original structure The success of this project is crucial as there is vital information that needs to be salvaged from the corrupted Excel file. Ideal freelancer should have: - Extensive experience working with large Excel datasets - Proven ability to recover corrupted files - Strong attention to detail to ensure all data and structure is accurately restored
I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to link with Quickbooks Online seamlessly, either through Zapier or an SQL database connection. This will allow completed job cards to be sent to Quickbooks for automatic invoice creation. Managers can then authorize on Quickbooks before sending. Key Functionalities: - Creation and Editing of Job Cards: The system should enable the easy creation and editing of job cards through a user-friendly web form by both employees and managers. Employees can then select their name from a drop-down combo box if they have worked on...
I'm in need of a Progressive Web Application (PWA) for collecting survey responses towards an onboarding process. The application will feature: - A mixed set of survey questions, including both multiple choice and open-ended questions. - Responses w...including both multiple choice and open-ended questions. - Responses will be sent to a Google Sheet for easy management. - Integration with a payment gateway after the survey for users to proceed with payment. - Survey responses should not be anonymous. The ideal freelancer for this project should have experience in developing Progressive Web Applications (PWAs) and integrating them with Google Sheets and online payment gateways. They should also be able to implement a mixed survey layout and ensure that the survey responses are...
excel assignment for an event study. template and example below
I'm in need of a professional accountant to handle my quarterly bookkeeping and financial statements. The ideal candidate should be well-versed in accounting principles and practices, have experience in bookkeeping and financial statement preparation. Familiarity with QuickBooks and Excel is crucial. Key responsibilities: - Perform quarterly bookkeeping tasks - Prepare accurate and timely financial statements - Maintain clear and organized financial records The successful freelancer will be consistent, detail-oriented, and able to meet deadlines. Experience with similar projects is a plus. Please provide your relevant experience along with your bid.
