Excel vba dashboard project data jobs
I'm in need of a proficient Excel specialist to help me with data analysis and entry. The task involves handling mixed data (both numeric and text) and providing valuable insights from analysis. This is a remote role, so email will be our preferred mode of communication. Ideal Skills and Experience: - Advanced Excel proficiency - Previous experience with data analysis and data entry - Ability to work with mixed data types - Strong analytical skills - Excellent communication through email
I'm in need of a custom bill format in Excel that incorporates my company's logo and branding. The bill should have automated calculations for the ease of use. Key Requirements: - A customized Excel bill format with a professional finish - Integration of the company's logo and branding into the bill - Automation of calculations within the bill Ideal Skills: - Proficiency in Excel, including advanced formula creation - Experience in design, particularly in creating professional, branded documents - Understanding of automated calculations and their implementation within Excel Upon completion, I expect to receive the Excel file with the custom bill template.
I'm currently in need of a professional with strong experience in CodeIgniter + Bootstrap, for an urgent task. I need the person for complete redesigning of dashboard, The code is of codecanon you can find that here demo code is Just look at the website carefully, before placing the bid. I will also provide you the html template of dashboard to change I need someone who can complete the work asap. Note:- kindly check the above code carefully and all my simple requirement is written above, so don't try to place low bid only to come into inbox, just place your final price bid else i will directly stop replying you in inbox if you will change your bid amount there.
I'm looking for a professional who can assist in converting screenshots, which already depict data set in tables, into Excel tables. The purpose of this task is to better analyze the data, which is purely textual in nature. The ideal freelancer for this job would be experienced in data entry, with a particular emphasis on Excel, and have an eye for detail to ensure all data is transferred accurately. There's no requirement for interpretation or analysis, I simply need the information from the images moved into an Excel format. Attached is a sample of the screenshot.
I have Excel sheet in the are all products added with all the categories in it. I will also share a word file in which I will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This
I need a proficient freelancer to help convert my Excel files, containing both numerical and textual data, into Word documents. The aim of this conversion is to ease the process of creating reports. The data should be precisely formatted into tables in the Word documents for a cleaner presentation. The ideal candidate would require: - Excellent skills in Microsoft Excel and Word. - Proficiency in data conversion and formatting. - Attention to detail to maintain data integrity. - High regard for timeliness and efficiency. Understanding the importance of report creation in business communication, this work must be meticulously done, reflecting professionalism in every converted document.
I'm keen on gathering a cus...to 50 nano or micro influencers who are distinguished in the pet food product niche. The preferred influencers are mainly those active on IG, FB or YouTube. To attract quality bids, freelancers should possess: - Expertise in Social Media and YouTube data gathering. - A strong understanding of the pet products industry. - Ability to identify key influencers in the pet products niche. - Tracking and reporting capabilities. Freelancers with current experience in influencer research will be given priority. The deliverable is a Report (Excel format preferably) that includes: - Full Name of the nano/micro Influencer - Profile Link - Username - Channel Name - Channel Type (IG, FB, YT, etc) - Email (must be current and valid) - Engagement Rat...
...of a professional who can create an extensive dashboard to visualize our sales data. Key Responsibilities: - Design a visually appealing dashboard to showcase our sales data in a comprehensive manner - Implement interactive functionalities to help us gain insights and make informed business decisions - Ensure that the dashboard is user-friendly and accessible Ideal Freelancer: - Proficient in data visualization tools like Tableau, Power BI, or similar - Experience in creating interactive dashboards - Strong understanding of sales data and metrics - Ability to translate complex data into clear, easy-to-understand visual representations This is a great opportunity for a freelancer with a keen eye for detail and a passion for tra...
I'm seeking a talented designer to create a distinctive and functional outfit for women's competitive tennis. SINGLET AND SKIRT Key Points: - The outfit will consist of a singlet and skirt. The specific fabric for the outfit is yet to be decided. - It shoul...appealing, suitable for the competitive tennis environment. Requirements: - Strong design skills, particularly in sportswear. - Experience in creating custom clothing for sports. - Knowledge of functional and performance-enhancing fabrics. - A keen eye for fashion and current trends in sportswear. Your task is to develop a unique and high-performing outfit that will help a female tennis player excel in competitive play. The successful design should not only enhance performance but also make a distinct fashion sta...
...development of a full-featured online ordering platform that emphasizes on streamlining orders and deliveries. Primarily, the platform should be designed to : - Excel on both desktop and mobile devices ensuring a smooth customer experience on all interfaces. - Prioritize on real-time scheduling functionality that optimizes order fulfilment with exemplary efficiency. -Connect to Service Monster API -Use as payment gateway. Ideal candidates should possess profound expertise in AI coding specifically in enhancing online platform functionalities. Experience with building real-time scheduling systems is critical for this project. Furthermore, a strong background in mobile and desktop compatibility is essential. The aim is to create an ordering system that not only bring...
I am seeking an experienced RPA Developer to automate tasks relating to Excel and Web interaction. Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink you will open a broswer tab with that link analize the result of the web programming 1 or 2 IF statements Proceed to generate the unatended "clicks" in that web close the tab iterate with the next excel cell (in this case d6) repeat the web process Until Excel's data EOF Everything configurable via external TXT file - name of the excel file - starting cell - basic hyperlink - how to compose the final hyperlink - the IFs statements - the sequence of clicks for each IF condition Immediate offers after posting will be...
I am in need of a skilled bookkeeping specialist proficient in Tally data entry and Excel data entry and formatting. Key Tasks: - Entering less than 100 entries per week into Tally. - Formatting and managing Excel data. The work will be ongoing, with updates and reports required weekly. Ideal Candidate: - Must possess extensive experience with Tally and Excel. - Proficiency in bookkeeping and data entry. - Ability to handle tasks efficiently and with a high degree of accuracy. - Understanding of financial reports and data reconciliation. The ideal freelancer will be able to deliver clean, well-organized data, and provide timely reports. If you have the skills and experience required, please get in touch.
I am looking for someone proficient in typing to convert content from a 30 page PDF into Word and Excel documents. The majority of the content will go in Word with a few items to be transcribed into Excel. Requirements: - High typing accuracy and speed - Familiarity with Word and Excel formatting Specific instructions: - For Word, the content should be formatted in Calibri 12 point font and single spaced. - For Excel, maintain one row per entry for optimal readability. Ideal candidates should have prior experience in similar data entry tasks. Familiarity with PDF conversion tools, text formatting, and spreadsheet management would be a plus.
...text and numeric data from a PDF table into an Excel spreadsheet. I would like the Excel data to be organized according to the fields in the PDF table. All fields in the PDF table should be included in the Excel sheet. Key requirements: - Export text and numeric data from a PDF table into an Excel spreadsheet - Organize the data on Excel according to the fields in the PDF table - Include all fields in the PDF table in the Excel sheet Ideal Candidate: - Proficient in PDF to Excel data transfer - Excellent attention to detail for verifying and cross-checking data - Familiarity with text and numeric data formatting in Excel - Capable of delivering accurate and organized final results...
...diligent freelancer with strong attention to detail and experience with Microsoft Excel and Shopify for a data entry project. Having a deep understanding of these two platforms is crucial to the seamless execution of the task. The project involves: - Using a spreadsheet to find and identify approx 4500 books on Amazon. - Using an online import tool to bring book data into a Shopify website - Adding extra product information in the shopify website from the spreadsheet about the book. - Determine the genre of the book and categorising in shopify accordingly. The ideal candidate should have: - Proven experience in data entry, preferably within Shopify. - Access to US version of Amazon. - Proficiency in Microsoft Excel. - High level of acc...
As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. Key Features: - Automatic Calculations: The plugin should be capable of performing automatic calculations, saving time, and minimizing any possible errors. - Data Validation: Ensuring data accuracy is crucial, thus the plugin should include data validation steps that help identify and correct any inaccuracies promptly. - Customizable Formatting: To enable smoother navigation and interpretation, the plugin should allow for customizable formatting tailored to my data and personal preferences. - Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me ...
I have a list of addresses for invitations that need to be transcribed from a handwritten list into an Excel spreadsheet. The addresses should be formatted consistently in the following structure: Name, Street Address, City, State, Zip Code. - Handwritten list will be provided, and should be transcribed accurately - Standardize the address format for consistency - No correction needed for typos, just ensure the format is standardized The ideal freelancer for this project would have: - Proficiency with Excel for data entry and formatting - Attention to detail to ensure accuracy and consistency - Experience with handling addresses or similar data is a plus
...:: Email templates not working :: Rabbitmq is installed and configured. 7. A Click on Unsubscribe in the transactional email footer should uncheck the subscribe mark in user's account. 8. Confirming subscription in the user's inbox with the transactional email should auto login to the user's account and show message "You are now Subscribed" or "Thank you for Subscribing" in user's dashboard. :: User should then get the Subscribed Transactional Email. 9. Fedex shipping rate does not show despite api and secret code are entered. 10. Shipping Tracking plugin not working 11. Logged user out of account after 15 minutes of inactivity.&nb...
I am in need of an experienced ASP.NET MVC C# developer to create a web application that connects to AWS RDS OpenSearch. The project is focused on a read-only dashboard. The key requirements for this project are: - User Login: The application should allow for user to login, with different roles such as Admin, Regular User, and Guest. - Dashboard: The dashboard should be read-only and include elements such as charts and graphs, recent activities, notifications, reports, and filters. The ideal freelancer for this project should have: - Proven experience with ASP.NET MVC C# - Strong understanding of AWS RDS and OpenSearch DB - Experience with login systems and user policies - Previous work involving the creation of read-only dashboards If you ha...
I'm seeking an experienced Excel professional to assist with the implementation of various financial formulas and functions in my spreadsheets. I am trying to create an excel sheet for sales people to put some data entry and get final pricing. i have the basic excel sheet ready, and if you willing to work on it i can share it and explain in more details In particular, I need help with: - The execution and application of financial functions specifically. - An ability to accurately conduct cost and estimating calculations. - Strong problem-solving skills to fine-tune formulas for efficiency and accuracy. A background in finance and substantial experience with Excel's wide array of financial functions would be very advantageous for the successful compl...
...uploaded to it – including PDF, Excel, and Word files. Here is what I am expecting: Document Interaction: • Extract information from PDF, Excel and Word files • Provide document descriptions that enable efficient and informative interactions Graph Generation: • Generate graphical representations from data extracts • Capable of creating bar charts, pie charts, and line graphs Desirable Skills & Experience: • Expertise in Django is a must • A good understanding and experience of GT4 API • Knowledge of ORM and DRF • Familiarity with data visualization may come in handy To recap, I'm seeking a Django chatbot that is able to interact with various document types, provide descriptions based on the documen...
...dev. The goal is to handle incoming data from Instagram and automatically respond using chatgpt. Key tasks will include: - Writing clean, optimized TypeScript code - Debugging and fixing any errors that may arise - Implementing complex algorithms to process data accurately and quickly In terms of functionality, the application should be able to: - Monitor Instagram messages and comments in real-time - Set up a webhook to receive Instagram data - Reply automatically to the messages received using OpenAI Assistant Ideal skills and experience for this project include: - Proficiency in TypeScript and SaaS architecture - Experience integrating with Instagram's API - Familiarity with chatgpt or similar AI tools - Background in setting up webhooks for d...
...and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data...
I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.
I'm looking for a skilled web developer to create a platform where users can submit enquiries about their need for accountants. Key Features: - Users will be required to provide basic information about their business when making enquiries. - The platform should include a dashboard for me to manage the enquiries effectively. I'd like to view, respond, and track them easily. - Users should be able to search for accountants based on location. Ideal Skills: - Proficient in web development and design with experience in creating user-friendly, intuitive interfaces. - Strong understanding of database management and backend development to facilitate the enquiry management system. - Familiarity with search functionality integration, particularly based on user-specified location....
As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling...
I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases
I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer shou...
I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double o...
I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples ...
I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to en...
In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with your expertise.
I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?
We're seeking a skilled freelancer to enhance our current React site with the following tasks: - Connect two existing forms on our website to our backend dashboards and email inbox, ensuring seamless data transmission. - Address layout issues to optimize site responsiveness across all devices. - Enhance the code structure to improve maintainability and scalability. We are working with: - React - AWS Server - Node - MongoDB
I'm in need of a skilled data analyst who can help me analyze our sales data. Your main task will be to focus on our sales performance by region. Budhet is 100CAD Key responsibilities: - Analyzing sales data, with a focus on regional performance - Generating insights from the data - Creating an insightful dashboard Your deliverable will be an interactive Excel/Google Sheets document. This should clearly present the insights you've uncovered, particularly the regional sales performance. Ideal skills and experience: - Proficiency in data analysis, especially with sales data - A track record of creating insightful dashboards - Familiarity with Excel or Google Sheets, and the ability to create interactive documents
My Excel file is very heavy and unorganized. I want it to get cleaned and effecient
I'm seeking a skilled data analyst to meticulously assess my website's performance through the data I provide. Key Project Details: - Analysis Focus: The data to be analyzed includes website traffic, user behavior, and conversion rates. You're expected to provide a thorough and insightful examination of these aspects. - Data Collection: Data collection for the website is currently managed via Google Analytics. Your experience and proficiency with this tool is crucial. - Deliverables: I'd like the results of your analysis to be presented in written reports and clear visualisations ( an interactive dashboard maybe). These should be detailed, accurate, and accompanied by valuable visual representations of the data....
I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a definitive plus.
I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes
I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation
I'm looking for a skilled WordPress & App developer to create a dynamic web application and corresponding iOS/Android apps. The project is aimed at developing an Events and Staff Management application. The main features of the application will include: - Event Scheduling: The application should allow for the smooth scheduling of events. - Staff Scheduling: The application should facilitate in allocating staff to the scheduled events. - Attendance Tracking: The app should track the attendance of staff and participants at events. - Embed Video Call Platform: I'd like the application to have the ability to embed a video call platform for virtual events, such as Zoom. - Access Pass Creation: The app should be capable of creating unique 'Access Passes' for users...
summarize in a specific table in Excel
...The deliverables should include 2 Neural Network and 2 autoregressive models (ARIMA, SARIMA etc…). The validation should demonstrate each model performance. - **Dynamic Dashboard**: I'm looking for a dashboard that's dynamic and interactive. It should display the forecast for the Twitter data using a visually appealing interface. - **Real-time Data Updates**: The dashboard should be capable of updating in real-time to reflect any changes in the forecast. The ideal freelancer for this project should have proven experience in time series forecasting, Python programming, and developing interactive dashboards. A solid grasp of data visualization principles would be a plus. The output should be in a form of a python file with...
I'm in need of a Zoho Analytics expert to create a comprehensive dashboard for my business. The dashboard should utilize Charts and Graphs, Drill-down capabilities, and Data filtering features that Zoho Analytics offers. Key aspects of the project include: - Integrating data from Zoho CRM and Zoho Desk - Focusing on tracking Sales revenue Your role will involve: - Designing and developing the dashboard to visualize the data in an intuitive and informative way - Ensuring the dashboard is user-friendly and allows for easy drill-down into specific details - Implementing data filtering options to allow for customization based on user requirements Ideal candidates should: - Have extensive experience with Zoho Analytics, incl...
Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .
I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data
I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively hand...
...skip a few questions outlining the exact changes needed, we expect the developer to be proficient in: - User authentication - Dashboard layout design - Payment integration - Permissions - SaaS Development - Laravel and Vuejs expertise Ideal candidates should be able to confidently handle these listed tasks and possess the ability to suggest and implement improvements. Prior experience customizing these elements and a keen eye for detail are highly desired, to ensure the finished product aligns with our vision. Please approach this task with adaptability and a problem-solving mindset, as specific customization requests will be discussed during the course of the project. Experience in implementing social media logins, two-factor authentication, and custom user roles and...
