Macros dashboard excel jobs
...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 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.
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 seasoned expert in both SAP Cloud ALM and Grafana to help me build a resourceful dashboard for optimal data visualization. Given my beginner's level in using Grafana, I'm looking for clear, thorough guidance to navigate through this tool effectively. **Your Main Task:** 1. Tutoring on how to construct a Grafana dashboard with a SAP Cloud ALM data source **Intended Metrics:** - System performance metrics - Custom metrics from calm logs and calm LMS **Skills and Experience Needed:** Preferably, you have: - A solid understanding of Grafana and how to use it for data visualization - Significant experience working with SAP Cloud ALM data sources - Proven ability to provide step-by-step instruction catered to a beginner - Patience and pas...
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...
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.
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...
hello i need an app mobile ios and android , i need someone with experoience and you can send me your work plz , is a serious project . Client Interface: Post ads and receive ... Basic user account features (signup, login, profile management, notifications). supplier Interface: Create and publish content. Manage profile and audience interaction. Request invoice generation. View collaboration opportunities and analytics. Receive notifications and reminders. Basic user account features (signup, login, profile management, notifications). Admin Interface: Centralized dashboard for application management. User and content moderation. Financial transaction management. Analytics and reporting. Security management. Basic user account features (signup, login, profile management, notif...
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...
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
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.
I urgently require assistance in setting up a user-friendly, manual payment gateway dashboard for my e-commerce website. The payment methods must include credit card and debit card transactions. I don't have a preference for the payment processor at this moment and am open to suggestions. Ideal candidates will: - Have an intricate understanding of Payment Gateway Integration - A background in e-commerce website management is an added advantage. - Possess advanced skills in relevant programming languages. - Be able to complete this project ASAP. Your duties will involve: - Establishing a responsive, manual payment dashboard. - Ensuring the integration of credit and debit card payments. - Recommending and integrating a reliable payment processor if needed. Speed and ef...
Develop macro-enabled Excel workbook
...locations and precise boundary definitions for target areas. Includes visual enhancements for clustering data and map filtering. 2. Data Integration: Integrate web scraped data into geospatial existing datasets. Ensure seamless integration and compatibility with mapping and visualization tools. Enhancing our overall data analytics capabilities. a. Integrate the processed data into a centralized dashboard and reporting system, optimizing for performance and user experience. b. Incorporate predictive analytics and AI/ML models to uncover deeper insights and trends within the data. 3. Chart and Visualization Tools: Develop interactive and informative charts, graphs, and visualizations based on geofenced data. Utilize tools such as Tableau, Power BI, or similar platforms to convey ...
I'm in need of an intermediate level Tableau developer to wor...data, and generate reports. Key Requirements: - An intermediate level of Tableau expertise is required for this project. Please only apply if you're confident in your Tableau skills. - The project entails developing 7 or more dashboards. These dashboards will involve a mix of data analysis and report creation. Ideal Skills: - Proficient in Tableau with a strong portfolio showcasing your prior dashboard development experience. - Strong data analysis and report creation skills are necessary as you'd be working on these aspects. - Ability to understand the project requirements and deliver the dashboards in a timely and efficient manner. I'm looking for someone who can take on this project and deliver...
Data Entry from Scanned Business Cards to Excel We are looking for a highly meticulous data entry specialist to transfer information from approximately 2400 scanned business cards into an Excel spreadsheet. === Data Points to Include for Each Card: 1. Name, Position, Company, Phone (include all numbers, Fax (if available) and correct country code, Emails, Websites, Social Media Links, Address, City, Country ,PO Box, category of company 2. AND Any other available information on the cards === Requirements: * High accuracy is crucial; entries will be checked for spelling and number accuracy. * The partner needs to speak English fluently and in writing as well. * Images will need to be renamed at the end of the project to match the row of the card on the sheet * The proj...
...and Filtering: Visitors need to be able to filter and search for products easily. - User Registration and Login: A secure system where users can create their own profiles and log in securely. - Payment Gateway Integration: The site needs to securely handle payments. The developer should have experience dealing with a variety of payment gateway integrations. - Resellers Dashboard: Resellers should have their own dedicated dashboard for business purposes. - Other Features: Conversations will be necessary to discuss additional features required for the site. The ideal candidate should have solid experience in building custom e-commerce websites and a portfolio to showcase their previous work. Experience in UX/UI design is highly important to ensure the website is user-friend...
As an AI Engineer, I'm looking for a specialist to develop an AI system that is proficient in machine learning and computer vision. In particular, I need the system to excel in image recognition and data analysis. Ideal Skills: - Proficiency in machine learning and computer vision - Extensive experience with image recognition and data analysis - Skilled in Python, TensorFlow, and PyTorch The AI Engineer must also have a solid understanding of the Python programming language, as well as experience working with TensorFlow and PyTorch frameworks. The ideal candidate will be able to demonstrate a strong track record in developing and implementing AI systems that can successfully perform image recognition and data analysis tasks.
I require an extensive and careful research task to be undertaken for a list of 8,000 businesses across a region of the UK. I am looking for specific data points, such as: - Names of Managing Directors - Their respe...in accurate data collation and verification and be well-versed with up-to-date UK business registries or databases which must include the businesses website and LinkedIn. A keen attention to detail is necessary, as I require accurate, reliable data. Prior knowledge of UK businesses, particularly management hierarchy, would be advantageous. All information is to be delivered in an easy-to-read Excel spreadsheet format. Note: For the task at hand, focus needs to be put on only current Managing Directors and/or Business Owners. I do not require information on any other ...
I am in need of a skilled professional who can provide the following accounting services using Excel: - Preparation of Financial statements - Cash flow analysis - Financial statements analysis You will be ideally proficient in Excel-based financial modeling and analysis, understanding how to manipulate and interpret data to present clear, concise, and informative reports. A solid background in accounting will ensure accuracy in financial statement preparation and analysis. Your ability to meet deadlines with minimal supervision will be a crucial factor for success. Existing familiarity with my current accounting software, Excel, is mandatory. A background in business finance or related fields and demonstrated experience in similar roles will be viewed favorably. ...
I'm in need of a skilled website developer proficient in creating E-commerce websites. Here's what is essentially required for my project: - Develop an E-commerce website - Integrate user-friendly functionalities such as customer login and personal dashboard - Incorporate an efficient inventory tracking system to keep tabs on product availability and sales The website will host a range of 50-100 products. Hence, the system should be robust enough to handle this volume seamlessly. Prior experience in developing similar e-commerce websites is much preferred. Understand that this is a critical factor for my project's success, so your quality of work matters above everything else.
I'm looking to establish an online tutor mark...Integration with Bigbluebutton tool - Payment options through Stripe Connect, Google and Apple Pay, among other methods - Calendar synchronization with Google and Apple. For Tutors (as a minimum): - Functionality to create and manage profiles - Ability to set availability and schedule - Receive tutoring session bookings - Opt in for subscription for repeated lessons. For Admin (as minimum): -Dashboard -payout Ideal freelancers for this project will be proficient in not only the development of digital marketplaces but also in integrating third-party tools such as Bigbluebutton, Stripe Connect, and Google/Apple API's for payment and calendaring functions. The project will be: Website + Android App+ IOS App. Please stick to...
I need an iOS app developed that allows for data entry, spreadsheet viewin...viewing, and data manipulation. The design should be colorful and vibrant to make it visually appealing, yet simple to use. Authentication will not be required as all data should stay on the device, ensuring privacy. I need to get a finance tracker for all my personal accounts. I need a place to input values from banks, fund houses, sips etc, which would be stored in the file and give me nice dashboard of my funds, current and previous month comparison and growth calculations. I already have a sheet that I use, which can be a starting point. Ideal Skills: - Swift or Objective-C programming - UI/UX design with an eye for vibrant color schemes - Experience with data manipulation and presentation on mobil...
The client portal dashboard is experiencing an issue where the graphs and charts are no longer displaying. Ideal Skills and Experience: - Strong experience in debugging front-end issues - Proficiency in JavaScript and data visualization libraries - Knowledge of client portal systems Key Points: - The issue is limited to the graphs and charts not displaying. Other elements appear to be functioning correctly. - The problem is consistent across all web browsers. - No recent updates or changes have been made to the dashboard that could have triggered this issue. You will be expected to: - Identify the root cause of the problem - Implement a solution that will restore the proper display of graphs and charts without affecting other elements of the dashboard.
I'm seeking a skilled freelancer to create a visually appealing dashboard in Power BI. The data itself is straightforward, but I'm really looking for someone who can create an aesthetically pleasing design. **Key Requirements:** - **Power BI Expertise**: You must be proficient in Power BI and have experience designing and building dashboards in the tool. - **Aesthetic Eye**: I'm looking for someone with a knack for design, who can create a visually appealing dashboard layout that is easy to interpret. - **Strong Communication Skills**: It's essential that you can understand and interpret my needs effectively to bring them to life in the dashboard.
We are looking for a Looker Studio expert to help us develop a new dashboard feature. The ideal candidate will have experience connecting to backend systems via API and displaying data in Looker Studio dashboards. We'd like to start with a consultation to discuss our vision for the feature and determine if it's a good fit for both parties. Important note: Due to possible personal contact, we prefer only freelancers from Europe. Looker portfolio examples are necessary.
I need a skilled web developer to duplicate 785 WordPress pages within 1 hour. The project involves customization of the URL and page title to align with specific city names provided in an Excel sheet. Key Requirements: - Duplicate 785 WordPress pages quickly and accurately - Customize the URL and title of each page according to its respective city - Ensure that the formatting and layout of the duplicated pages remain consistent with the original - Provide a high level of detail and accuracy to maintain the integrity of the multi-location business promotion strategy Ideal Skills and Experience: - Proficiency in WordPress and web development - Ability to work quickly and accurately under time constraints - Strong attention to detail to ensure correct customization of each page - Ex...
I'm seeking a competent developer to construct an AI-powered chatbot for my WordPress website. This project requires a colorful and creative design that can effectively balance its vibrant nature with its functions. This chatbot should excel in: - Customer support: Ability to resolve queries, troubleshoot, and provide live assistance to customers. - Lead generation: Capability to initiate conversations and attract potential customers. - Appointment scheduling: Seamless calendar synchronization for hassle-free appointment bookings. - Marketing & Promotion: Efficient in promoting services or products, generating interest, and ushering in sales. - Order Exchange & Processing: Capability to handle orders, process them and ensure smooth transactions. - FAQs: Encompasses a...
I'm seeking a competent developer to construct an AI-powered chatbot for my WordPress website. This project requires a colorful and creative design that can effectively balance its vibrant nature with its functions. This chatbot should excel in: - Customer support: Ability to resolve queries, troubleshoot, and provide live assistance to customers. - Lead generation: Capability to initiate conversations and attract potential customers. - Appointment scheduling: Seamless calendar synchronization for hassle-free appointment bookings. - Marketing & Promotion: Efficient in promoting services or products, generating interest, and ushering in sales. - Order Exchange & Processing: Capability to handle orders, process them and ensure smooth transactions. - FAQs: Enco...
As an organization, we are seeking an experienced Data Analytics & MIS Executive to handle critical tasks in the realm of data analysis and MIS. Key Responsibilities: - Conduct in-depth data analysis - Generate regular and ad-hoc reports - Optimize our data systems Skills & Experience Required: - Proficiency in Excel - Proficiency in Power BI - Experience in working with sales data - Experience in working with customer data - Experience in working with EV Car booking data Your role will involve using your analytical skills to interpret complex data and generate insightful reports. You'll also be responsible for ensuring that our systems are optimized for maximum efficiency. The ideal candidate for this role should be a highly skilled professional with a proven track...
You will be required to Copy technical part number from PDFs to excel file. Most of the files have copy paste enabled. I have around 400 PDFs. The brief provided will be very precise and easy to follow. Its a long term project. Will have projects on monthly basis If you understand what we are looking for. A fairly simple project with easy guide to follow through
I have a pressing need to transfer a large quantity of image files. Key Requirements: - Data Transfer: You will be tasked with swiftly transferring a substantial number of image files. - Organization in Excel: Following the transfer, you should organize these images in an Excel document. While this is not a conventional method for handling images, it is a specific requirement for my project. Ideal Skills: - Proficient in Data Transfer: You need to be skilled in transferring data swiftly and accurately. - Excel Expertise: You should have experience in using Excel to organize and manage files. Timeframe: - I would prefer this project to be completed as soon as possible. Please only apply if you have the necessary skills and capacity to deliver on this urg...
I need a Excel macro that can scrape data from a https://www.ebay.com. The Excel macro should be set to run whenever want to update the data in my spreadsheet. Excel should have Product Name Product UPC Product SKU It will then go to find that Product I want excel macro - list with the number of watches/shoes for that item
...with a runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models into Ex...
...data studio dashboard that I need assistance in resolving. These are: - My data is not updating as expected - I am experiencing inconsistencies with the visualizations - My dashboard is not loading at all at times The primary data source giving trouble is Google Sheets. To rectify the situation, an expert is required to restore my confidence that my dashboard will operate as expected. Moreover, it seems the tables of data specifically are not displaying correctly. This might entail performing checks, and implementing changes to the manner in which this particular format of visualization operates. Ideal Skills: - Proficient in Google Data Studio and Google Sheets - Experience in troubleshooting and resolving data visualization problems - Familiarity with data ...
I'm looking for a Power BI expert to help me with creating engaging visualizations, specifically a comprehensive dashboard. The focus of this project will be capturing and presenting customer demographics data. Key responsibilities: - Understanding the provided data and its potential uses - Designing and developing an intuitive and interactive dashboard - Ensuring the dashboard effectively displays demographic data Ideal skills: - Expertise in Power BI - Excellent understanding of data visualization techniques - Ability to interpret complex data - Experience creating focused dashboards. This project is a great opportunity for someone who loves dissecting data and converting it into beautiful, informative visualizations.
Create a public dashboard from Looker Studio reading data from excel / google sheets.
ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.
I'm looking for an Excel expert to create a custom software for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understandi...
I am in need of a Power BI specialist to create a dashboard using data from Excel spreadsheets. The primary goal for this dashboard is to provide insights based on geographic location and contacts made with organisations. Specifically, I would like to include locations of contacted organisations. Key requirements: - Proficiency in creating Power BI dashboards - Experience in working with Excel spreadsheets - Understanding of market analysis and KPIs - Ability to transform raw data into meaningful insights Your role will be to take the Excel data I provide and create a dynamic, visual dashboard that effectively communicates market share by location. Your expertise in Power BI, data visualization, and market analysis will be crucial for this pr...
things to be include in that - Register and login option with forget password and reset password with sendinblue email integration - After login redirect to dashboard (empty page, only need to show user name) - If user open login page and he already login must be redirect to dashboard and wise versa - Profile page -> with image upload Needed basic UI for frontend, we will use boostrap, no other UI lib with mysql must use with proper middleware must be secure way of write the database query need to create from scatch, do not use any ready made template No un-necceeory plugin install Auth must be handle is proper, if requires use redux, no context
I'm looking for a professional who can proficiently split Column D in my Excel spreadsheet into columns E, F, G, H . This data must remain on the same sheet post-split progression. I have provided an example in row 2 Key requirements: - Excel proficiency with experience in splitting columns - Ability to deliver quality work in a timely manner - Must respect data privacy Any freelancer applying for this project should include their relevant Excel experience to demonstrate their skill. This task needs to be completed quickly and correctly, so I need someone who knows their way around Excel. Let me know if you're up for it, I'm eager to get started on this as soon as possible.
