Project dashboard excel vba jobs

I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer dat...require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term coll...

This job requires programming experience to create and design an app based on the attached PowerPoint where I have detailed each page of the app. The data needed for the app will be supplied in an Excel file. The bid is to create the app for both iPhone and Android. App programming and graphic design experience is mandatory for this project and will require more than a basic knowledge of app creation. The rough project should be completed in 1-2 months. Please review the PowerPoint as it has very detailed information and don't hesitate to ask any questions.

macro based excel project with auto copy data and paste in chrome through selinium

Please Sign Up or Login to see details.

I need an expert to set up a Zoho CRM dashboard for my employees. The dashboard should be designed to provide real-time sales data, task management, and lead tracking. Here's a more specific rundown of what's required: Dashboard: - Display real-time sales data - Implement task management components - Incorporate lead tracking KPIs: - Track revenue generation - Monitor conversion rates Reports: - Create a system for generating sales performance reports - Enable the creation of lead conversion reports - Allow the generation of task completion reports The ideal freelancer for this job would be well-versed in Zoho CRM and have strong experience in dashboard setup and customization. A background in sales analytics would be a plus.

Your report/dashboard should answer the following questions posed by the sales director of the client: 1. What is the total number of orders catered by the firm? There should be a date filter in the dashboard. 2. What is the revenue earned by the firm? 3. What is the total discounted value (base price - check out price) * number of orders? 4. What is the overall discount %? 5. What are the top 5 selling categories? 6. Does the operational area of the store influence number of orders? 7. Are emails & product features on the homepage an effective mode of promotion? 8. What will be the next 5 weeks forecasted weekly quantity sold for each center, city, and meal category (you may use a simple trend-based forecasting method)? You need to submit your PBIX file work as a zip.

I'm in need of a proficient Data Entry operator who can efficiently handle tasks like data entry, content management, and file organization on a daily basis. The job requires some familiarity with basic Web and Network technologies like Wordpress, Godaddy, etc . General understanding of website operation are needed. Wo...handle tasks like data entry, content management, and file organization on a daily basis. The job requires some familiarity with basic Web and Network technologies like Wordpress, Godaddy, etc . General understanding of website operation are needed. Workloads will vary, as the work requirements are not on a fixed schedule or volume. Proficiency with data related software is highly advantageous. Excel knowledge is must. If worked on Tools like Zoho etc, it wil...

I need a thorough data collection process to collect Ceramic & Porcelain Tiles Importers within Vietnam. This project requires: - Collection of contact information and company details. - The data needs to be organized in an Excel spreadsheet. - Include data for all importers, regardless of volume or frequency of importing. Ideal skills and experience for the job: - Strong data scraping and crawling capabilities. - Proven experience with swift and accurate data entry. - Proficiency in Excel.

I need a system that will automatically log in to the income tax portal and download my income tax notices. These will include demand notices, assessment notices, and penalty notices. This information should be organized into a user-friendly dashboard and classified by: - Notice type - Date received - Severity level The system should be able to set reminders for me based on the severity level and deadlines on the notices. Ideal skills for this job are programming, database management, and experience with automation of tasks. Knowledge of tax procedures and documents is a big plus, as this will aid in the proper classification and understanding of the downloaded notices. Your bid should clearly explain how you can meet these requirements in the most efficient way possible.

I'm in need of a Python programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requir...programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requirements: - Extensive experience in Python and specifically Python libraries for web scraping. - Should deliver the extracted text content in an Excel file. Ideal Skills: - Experience in PDF scraping, especially text-based. - Strong Python programming skills. - Excel file formatting. This will involve working with mostly text-based PDFs and programming a Python script to scrape the text content, and subsequently placing that data into an Excel file. Experience with similar projects will be highly advantageous. The ability...

Is a task require basic Excel skills with four tasks in total need it in 5-6 hours

I require a qualified specialist to generate sales leads for my green fertiliser project targeted at farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website coding in PHP - Creating engaging and informative web content and blogs - Using LinkedIn Sales Navigator for lead generation Your understanding of the farming world will be a great asset for this project. Delivery of the sales leads should be through an Excel spreadsheet, Emails, and my CRM platform. Past experience in a similar role, particularly within the agricultural industry, will be highly regarded.

I am looking for a developer to create a multilingual WhatsApp chatbot. The chatbot must be built on Twilio, and should be capable of answering user queries promptly and effectively in both Arabic and English. Skills and experience needed for this project: - Proficiency in chatbot development, specifically on the Twilio platform - Experience in designing chatbots that excel in query resolution - Strong command of both Arabic and English in a development context Please make sure to highlight any similar projects you've completed in your proposal, with specific details on chatbot functionality and multilingual support.

Please Sign Up or Login to see details.

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful c...

I need an expert UI/UX designer experienced in Figma to create a design for a Quiz App. The app will be aimed at the general public and should have a minimalist design to enhance user experience. It will be accessible both on Android and web platform. Looking for the following pages 1. Login/Signup 2. Profile 3. Dashboard 4. Normal Quiz page 5. Rank list 6. Reward page 7. Quick Quiz Page Main requirements include: - In-depth understanding of UX principles. - Proficiency in Figma for designing interfaces. - Experience designing for both Android and web. - Ability to design minimalist and user-friendly interfaces. - Previous experience in designing Quiz Apps will be beneficial. Your main task will be creating an initial design, gathering feedback from our team, and applying rev...

I need help to complete an almost ready Single Sign-On (SSO) system. The remaining tasks include: - Integrating with an AWS S3 bucket for both uploading and fetching files - Incorporating SSO into our current apps - Developing an admin/accounts dashboard The ideal candidate should have experience with mern stack and SSO systems, AWS S3 buckets, and dashboard development. Familiarity with our existing apps is a plus.

...insightful dashboard. Here's a brief of what I need: - Implement Interactive Dashboards: With emphasis on user engagement, the dashboards should be interactive and user-friendly. - Data Visualization: The dashboard should visually represent the data from Excel spreadsheets in a clean, easy-to-understand format. - Interactive Charts & Drill-Down features: I want a dashboard where users can interact with charts and explore detailed views of our data. Ideal Skills: - Experience in Power BI - Proficient in data visualization - Deft with interactive chart development, and drill-down feature set up Your task is to guide me on how to create this, using an existing example as a guide. Your expertise in Power BI and data visualization would play a...

i have excel framework that contains multiple user inputs the convert the outputs to a graphs and charts i need to convert the excel sheet to a website.

I am in need of an Excel expert who can successfully create rows in an Excel sheet with a dropdown list that allows multiple choices. These choices should be exclusively filled with text data. Key project tasks include: - The text data should be extracted from pre-existing Excel sheets that I will provide. - Any row that utilizes these dropdown lists must be color-coded differently, with the format contingent on differing data values. Ideal skills for this job would primarily include advanced knowledge of Excel or a similar spreadsheet software. Familiarity with text data extraction and color-based conditional formatting would also be of advantage. Previous experience managing similar tasks and a keen eye for detail would make you a standout c...

I am in need of an experienced Microsoft Excel expert who can create a specialized personnel cost budget template. This template should include: - Automatic calculations. - Cost categories for Salaries and Wages, along with Benefits and Bonuses. Experience in financial modeling and budgeting would be ideal to ensure accurate automatic calculations are set up. You will be creating this from scratch, so creativity and attention to detail are also required. Please provide samples of similar Excel projects you've completed in the past. Adequate knowledge of personnel finance management is a plus.

...extensive experience in creating e-commerce websites. Specifically, my project needs a customizable User Registration system integrated into it. Key Features: • User registration: Users must be able to register using their emails that will be verified or directly sign up with their social media accounts. Experience in developing these features is crucial. Qualifications needed: • Extensive experience in e-commerce web development • Proven experience in creating secure and effective user registration systems Comapny side dashboard to upload products and edit it user can buy and also send personalizsed request • Experience with email verification integration • Experience with social media signup integration The goal of this project is to ...

I am in need of data entry and web scraping experts who can assist me with a project. The tasks that need to be completed include both data entry into a spreadsheet and web scraping for specific information. The final data should be delivered in Excel format. I have a specific deadline for the project and it needs to be completed within a week. Ideal skills and experience for this job include: - Proficiency in data entry and web scraping techniques - Experience with spreadsheet software such as Excel - Knowledge of web scraping tools and techniques - Attention to detail and accuracy in data entry - Ability to meet tight deadlines and work efficiently If you have the necessary skills and experience, please submit your proposal.

I'm in need of an Excel programmer who is proficient with VBA. The task involves creating a VBA scroll bar that changes values within a specific cell. The cell's contents should be adjusted in increments of 0.01 through the scrollbar's activities. - Proficiency in Excel and VBA is a must. - An understanding of user interface designs with Excel is ideal. - The candidate should be capable of testing and debugging functions within Excel. Your main goal is to create a VBA scroll bar that can accurately manipulate cell contents. Your work will be deemed successful when the scrolling alters the cell value as per the increment specified. Reach out if you have the necessary skills and can get this job done.

I am looking for an Excel expert who can assist with implementing logical formulas and calculating percentage-based results for different strategies. There are three key strategies that require your attention: Strategy A, Strategy B, and Strategy C. Your tasks would include the following: - Implementing logical operations to enhance data organization. - Entering information pertinent to each strategy. - Calculating and displaying the percentage of each strategy. Ideally, you should have extensive experience in Excel calculations and logical operations. Proficiency in data analysis and reporting is also a plus. I am in need of an individual who can accurately interpret and implement my strategy-focused approach in Excel. Your output will provide a foundation for cru...

As the client of this project, I'm looking for a proficient AWS, Python, and QuickSight expert to implement a solution for my video stream processing requirement. The task involves: - Taking a video stream link from YouTube or Twitch and ingesting it into AWS Kinesis. - Providing this video stream as input to a code already written in Python, waiting in EC2 instances. The Python code's workings are already handled and won't need adjustments. - Producing an output in CSV file. The CSV file should be structured in three columns that include 'face', 'emotion', and 'confidence'. - Finally, ingest this CSV output in QuickSight and build a website showcasing these embedded insights. The ideal freelancer for this job should have: - Proficien...

Core Functionalities 2.1 User Authentication and Management User Registration: New users can register in the system. Login/Logout: Users can log in or out of the system with their credentials. Profile Activation: Admin will activate newly registered users in the system....Earnings Management: Specific earnings will be assigned to users upon task completion. Withdrawal Requests: Users can request to withdraw their earned amount once it exceeds a predetermined minimum balance. 2.4 Financial Reporting and Admin Panel Earnings Reports: Admin can view total earnings, user-wise earnings, and date-wise earnings. Export to Excel: Admin can export financial reports to Excel. Admin Dashboard: Admin can use a central dashboard to manage all aspects of the CRM add more ...

...multiple payment gateways, - Real-time order tracking for customers, - Availability of a restaurant management dashboard for easier management, - Rapid delivery tracking system, - Feedback and review provisions to enhance user satisfaction, - Social media integration to encourage digital marketing and user engagement. - I can create those restaurant with their domains - Maybe to get Commission fee from each restaurant. I'm the principal of this comprehensive project, aiming to build a robust food delivery website and application that caters to numerous restaurants. It's paramount that the system is user-friendly, intuitive, and aesthetically pleasing. Ideal freelancers for this project should have substantial experience in cross-platform development, ...

Hello Team, Wanted to create a user profile based consulting website whe...encrypted • International Payment Options • Multi Filter Search option where user can shortlist consultants based on reviews, Background, experience, location etc • Email/Mobile Verification • Account Verification through Documents for consultants only then the account goes live • Consultant Ratings by the other users who have used their consultation • A separate section for blogs • A consultant dashboard, showing how many consultations they have provided, their user profile details, experience and how many articles they have written etc • FAQ Section • Chat Option to connect with the Us (Support Team) for any issues • Legal Agreements to be added while user ...

As an individual heavily invested in financial tasks, I need assistance with advanced Excel functions. My project focuses on two main areas: data analysis and usage of specific formulas. Tasks include: - Data Analysis: This entails financial analysis and data visualization. You'll be dealing primarily with fiscal data and you'll need to make the data meaningful and easier to understand. - Formulas and Functions: You'll be carrying out tasks that require an expert knowledge of VLOOKUP and IF functions. An ideal freelancer would be one who's proficient in Excel, specifically with experiences in handling VLOOKUP and IF functions, and someone who has a strong grip on financial analysis and data visualization. A keen eye for detail and ability to del...

I'm in need of a data scraping expert to extract specific baseball statistics from a certain website. () - **The job will include:** Creating a file that can be executable on command. Could be excel or other that pulls the data required from website ( see file for details). I should be able to pull this data repeatedly over time with the fresh data of the day. - **Ideal skills and experience:** Candidates should have experience in web scraping, especially with sports data, proficiency in a programming language suitable for data scraping (such as Python) and a good understanding of baseball statistics. The website requires a login to get in. This task requires precision and an analytical mindset to ensure the accuracy and relevance of the data scraped. If all goes wel...

...Options for users to access extra content or subscriptions. - Course Creation & Posting: A feature allowing users to add courses and subscribe to watch them. - Subscription Management: A system to handle user subscriptions to various added services or course offerings. - Discord Integration: A link allowing users to connect to Discord, enhancing communication and interaction. - Admin Backend Dashboard: A comprehensive control panel for administrative use. The ideal candidate for this job will possess extensive experience with cross-platform mobile app development, a deep understanding of in-app purchase systems, Discord integrations, user authentication, subscription management and back-end administration systems. They should also appreciate the importance of educational too...

As a client deep within the Arts & Entertainment industry, I'm on the hunt for a seasoned professional. Whether it's a full-time, part-time, or freelance job you desi... or freelance job you desire, this could be your opportunity. Ideal Candidate: - Has significant experience or background in the Arts & Entertainment field. - Can demonstrate their expertise through their previous works and accomplishments. Application Requirements: - It is crucial to list your relevant experience. This shows me your readiness to take on the tasks at hand and your ability to excel in this field. Please note that skipping the type of job you're looking for won't affect the hiring process; what matters most is your capability to deliver, whether as a full-time employee,...

I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.

Please Sign Up or Login to see details.

...an expert in Excel to help me create a jobmatch system. This project involves listing various workfields like a hotel, restaurant, bar, coffeeshop, warehouse, detailsshop, and customer service, and their related job roles on an Excel sheet. The complex part of the project is, each job role needs to be evaluated for similarity with a focus on three major elements: - Hardskills, Softskills and qualifications - Experience and education - Personality traits Moreover, these elements should not bear equal weight but must be individually customized. The weight for each criterion in a jobmatch process should be custom-tailored. Chat GPT can be used to understand the weights for each workfield Ideal candidates will possess: - An in-depth understanding of data ...

I'm seeking a...business analyst, skilled in MS Visio, to convert my existing Excel diagram of a business process into the latest version of MS Visio. Specifically, your task will be: - Shifting flowcharts and swimlane diagrams from Excel to MS Visio - Implementing color formatting and thoughtful annotations to the converted diagrams - Ensuring all diagrams maintain a professional and corporate style throughout. The ideal fit for this project would be detail-oriented and have excellent knowledge in MS Visio and business process modelling. Their expertise should be evident in providing sleek, professional, and corporate-looking diagrams. Prior experience in working with similar projects is a significant advantage. NOTE: I will provide the excel file and ...

I require a seasoned HTML designer to build an engaging, streamlined dashboard for my School ERP Project. Basically need to convert an existing designed UI in a real html coded format. This design is required to be crisp and professional in look, and resonate with our corporate colors. Major components to include are: - Student Information - Attendance Tracking - Gradebook - Homework/Assignments Please provide a dynamic and interactive interface that intuitively presents these modules. Do note that my team will handle the integration of your design into our Laravel-based software. Hence, expertise in html and experience with professional, corporate-styled dashboard designs would be ideal for this task.

...data into Microsoft Excel spreadsheets. * Ensuring adherence to specific formatting requirements, details of which will be provided upon project commencement. A deep understanding of Microsoft Excel and precision in data entry is crucial for this role. Experience with processing invoices is highly desirable. Attention to detail and maintaining the integrity of confidential information are also essential for this project. Project Description: We have a pressing requirement for a meticulous and detail-oriented freelancer to assist us with data entry tasks. We possess over 150 Invoice Documents related to Cargo shipping, which primarily come in PNG format. Our objective is to compile the essential data from these documents into a structured spreadshee...

I'm seeking a skilled individual who can scrape text content from a PDF. A high level of attention to detail is needed as the data must be ac...skilled individual who can scrape text content from a PDF. A high level of attention to detail is needed as the data must be accurate. Key Project Requirements: - Excellent web scraping skills specifically around extracting text data from PDF files. - Ability to deliver scraped data in Excel format. - Efficient and accurate data extraction is a priority. Ideal Skills and Experience - Proven experience in web scraping, especially from PDFs. - Knowledge of saving data into Excel. - Capable of maintaining data accuracy. - Familiarity with captcha handling. I'm looking forward to your bid and answering any questions ...

I am in need of a service that includes text data entry into Microsoft Excel. The specific requirements are as follows: - Expertise in text data entry. The data to be entered is purely textual, no numbers or alphanumeric data are involved. - The text data needs to be organized in Alphabetical order. A systematic and meticulous eye for detail is required to ensure accuracy and consistency in the arrangement of the text data. - You must have a thorough understanding and extensive experience working with Microsoft Excel. It is the platform where the text data will be entered, sorted, and stored. Accuracy, efficiency, and confidentiality are paramount in this project, hence, the ideal freelancer is a seasoned professional with above reproach data entry skills and a ste...

Seeking a detail-oriented freelancer to help with a data entry project. The ideal candidate should have: - Knowledge and experience entering text data from digital files into Excel. - Experience in Excel table formatting, ensuring the structured and organized presentation of data. - Skilled in data management, able to maintain integrity and accuracy of the information. - Attention to details to avoid mistakes during data entry. This project requires specific skills in Excel and keen attention to detail. Make sure you are comfortable with handling and managing digital files and you’re equipped with good typing speed and accuracy.

I require a meticulous professional to aid in text and numerical data entering into an Excel file. - Data Entry Scope: The workload involves entering 850 rows/5 columns of data into 1 workbook/28 sheets . This is a one-time assignment needing immediate attention. - Skill Set: The ideal candidate would have experience in data entry and a keen eye for detail to ensure accuracy. Proficiency in Excel is a necessity. Looking forward to a productive engagement.

I need an Excel whizz capable of effectively entering and organizing both numerical and textual data in my spread-sheet. You should have: - Proficiency in Excel, particularly with data entry and organization functions. - Exceptional attention to detail, ensuring no data is mismanaged. - A good understanding of organizing data chronologically. Your task will involve: - Inputting a mix of textual and numerical data in an Excel sheet. - Organizing this data chronologically. - Ensuring data accuracy and integrity. Your keen eye for order and structure alongside your Excel proficiency will be crucial to the successful completion of this project.

Data entry project requiring transcribing documents into Excel spreadsheets. Ideal candidate should have experience in accurately transcribing a large number of documents. Preferred format for the transcriptions is Excel Spreadsheet. Project involves transcribing more than 20 documents.

I have attached my excel doc I created but am having trouble getting the results in require. I am looking to implement formulas and pivot tables to an existing Excel document for more sophisticated data analysis. The primary focus is on electrical energy usage. The ideal candidate will have strong skills in Excel with a special ability to effectively use pivot tables and understand energy consumption data. Expected Deliverables • Add formulas, including but not limited to pivot tables. • Design pivot tables to analyse patterns in electricity usage. Skills and Experience Required • In-depth understanding of Excel formulas and pivot tables. • Experience in working with energy consumption data is a plus. I look forward to working with so...

I am presently in need of a experienced Python developer for a project centered around Data Analysis, specifically focusing on Financial Data. Your responsibility will be to write a Python script on the dataset provided. Key responsibilities: - Reading from Excel or other data files and process them into Python data objects (such as a dictionary) - Write the code to process data as fast as you can - Interpret complex customer data, analyze results using statistical techniques - Develop and implement data collection systems and other strategies for predictive analysis - Assuring the quality of the data used for analysis is optimal - Building algorithms and developing automated processes - Test and QA the software you write and assist with integration if required Ideal Skills...

..., where customers can select, review, and purchase a antivirus of products. The must-have features include: All Basic Set Up for SEO Theme like buyantiviruskey Automatic plugin set up where I can store key customer can buy automatic like buyantiviruskey. Just I need a website similar buyantiviruskey with slight modification. I have domain name, web hosting plan I am in wordress dashboard. I need only 10 page set up and fully functional, I will add other pages. The website must prominently showcase products, offers, and customer reviews. It should be responsive, user-friendly, and secure. I am looking for a custom design that reflects the uniqueness of my product range. Ideal freelancers for this job should have evident experience in e-commerce website design and knowledge

I'm in need of an expert in Power BI who can create daily updated reports sourced from both Excel spreadsheets and SQL databases. A successful freelancer should be resourceful in presenting the data using specific visualization tools like bar charts and line graphs. Ideally, I would want to work with someone who has a good understanding of data analysis and can deliver accurate reports promptly. Key responsibilities: - Source data from Excel Spreadsheets and SQL databases - Create bar chart and line graph data visualizations - Ensure the Power BI report is updated daily Preferred skills: - Proficiency in Power BI - Experience with SQL and Excel - Strong problem-solving skills - Excellent time management skills - Ability to work independently and with limited ...

...navigates to to include every document that is opened within a section. I would like to discuss if there is a way to have a log if he wants to access all of his notes or have me login and look at his notes without having to click on every single button and document and picture in the entire brief in order to find out where he left notes where he did not. 5. Lastly, if possible I would like to have a dashboard or something for the lack of a better term to be able to see when he logs in and how much time he is spending looking over the website as well as each document. This would give me a very good understanding of How serious he is taking the matter. I suggest an initial zoom call where I can share my screen and walk one through how it has been organized. This is a private post...