Excel 2010 slicer dashboard jobs

Expert in MS excel for automation of sheets

I'm looking for a skilled freelancer to help me customize my Excel alerts with WAV files. - I have the specific sounds in mind for each type of alert, but I need someone who can skillfully integrate these into Excel's alert system. - You should have experience in both Excel and sound file manipulation, in order to create a seamless and professional system. - Please provide examples of past work to showcase your compatibility with this project.

I'm in need of a talented web developer to enhance my website with a user-friendly dashboard and a payment gateway. The tasks needed are as follows: - Implementing a Dashboard: - The dashboard should include a client order system with features like status tracking and feedback submission. - Other basic functionalities in the dashboard include order status, feedback, and a few more elements to be discussed. - Payment Gateway Integration: - The website should be equipped with a secure payment gateway for processing user payments. - Frontend to Backend Integration using JS: - You'll be required to ensure a seamless integration between the frontend and backend of the platform using JavaScript. Ideal skills and experience for this project inc...

Please Sign Up or Login to see details.

I have an Excel file that I'd like to convert to a Google sheet. I need the Google sheet to keep all the formulas that are present in the Excel file. Key Requirements: - The Google sheet should have all the formulas intact from the original Excel file. - Include Data validation rules to ensure the data entered is accurate and meets certain criteria. - Implement Conditional formatting to visually highlight important information. - Custom scripts or functions to automate certain tasks and enhance the sheet's functionality. - Preserve font styles and retain cell borders from the original Excel file. - Maintain the column widths as in the original Excel file. Skills and Experience: - Proficiency in Excel and Google Sheets, including advanc...

I'm looking for a professional who can help me develop a comprehensive Excel workbook for RFQ analysis and purchasing. The primary goal of this tool is to streamline our purchasing process. Key Responsibilities: - Develop an Excel spreadsheet for RFQ analysis and purchasing. - Implement basic formulas and functions to automate data analysis. - Ensure the tool is user-friendly and easy to navigate. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of its functions. - Experience in developing purchasing and analysis tools. - Ability to streamline processes through automation. This is an exciting opportunity for someone with a keen eye for detail and a strong understanding of purchasing processes. Looking forward to your proposals.

Dashboard for Admin

I'm looking for a diligent researcher who can compile a list of tire processors across different US states and organize the information in an Excel spreadsheet. Key Responsibilities: - Conducting online research to identify tire processors in each state. - Collating specific information (company name, contact person, phone number) for each processor. - Inputting the data into an Excel spreadsheet with consistent formatting. The ideal candidate should have: - Proficiency in web research and data entry. - Excellent attention to detail. - Strong Excel skills, with knowledge of maintaining consistent formatting. - Prior experience in conducting similar research would be an added advantage. The final list should be organized by state, with each entry clearly indicat...

I'm in need of a comprehensive dashboard that will allow me to manage a multi-platform e-commerce operation. Key Features Required: - **Product Posting:** The central feature of this dashboard would be the ability to post my products across different platforms. I'd like to be able to create listings on Amazon, eBay, and Walmart all from a single, unified interface. - **Order Management:** It's essential that the dashboard also provides an intuitive order management system. This system should allow me to view, process, and manage orders received from the different platforms. - **Payment Method Integration:** I've decided to use Stripe as the payment gateway for my business. This dashboard should be seamlessly integrated with Stripe to facili...

I'm looking for an expert in data analysis to assist with a project in Excel. The data provided is well-structured and needs extensive examination to extract meaningful insights. Ideal Candidate Skills: - Proficient in Excel and its data analysis tools - Strong analytical abilities - Excellent understanding of data organization Deliverables: - Clear analysis of the structured data - Relevant insights extracted from the data - Detailed reporting on the findings This project is particularly suited to those with a keen eye for data and the ability to utilize Excel's functionalities efficiently. Thanks!

I am looking for a dedicated and detail-oriented data entry operator to assist with a large volume of data entry tasks. Key Responsibilities: - Typing, copying and pasting, data validation - Handling a large volume of entries Ideal Skills and Experience: - Proven experience in data entry - Expertise in handling large datasets - Proficiency with text documents (Word, PDF) and spreadsheets (Excel, Google Sheets) - Attention to detail and accuracy - Time management skills to handle large volumes of data

I need an Excel spreadsheet that allows me to input a starting point's latitude and longitude, a heading (in degrees), and a distance (in kilometers), and then calculates the new latitude and longitude based on a rhumb line calculation. This tool will be primarily used for navigation purposes. Key Features: - Input fields for starting latitude, starting longitude, heading, and distance (all in kilometers) - Calculation of a new latitude and longitude based on the input - Utilization of the Rhumb line formula for the calculation Ideal Skills: - Advanced Excel proficiency - Understanding of geographical coordinate systems and navigation - Experience with mathematical calculations in Excel - Prior experience in developing navigation tools would be a plus This proj...

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

I'm seeking a proficient solution architect to develop an automation that transfers text, numerical, and date/time data from Excel to SharePoint, to Google Colab, and finally to Power BI. A recurring data transfer will be needed, though the frequency will vary based on our ongoing needs. I already have the google colab script ready and I have the excel files on sharepoint. So once i add a row to the sharepoint list, the automation should trigger and the changes should be reflected on power bi dashboard Ideal Skills and Experience: - Proficiency with Excel, SharePoint, Google Colab and Power BI - Solid experience in data management and automation - Detail-oriented with problem-solving skills Project Responsibilities: - Set up an automated system for data t...

I am seeking an expert in Splunk who can help set up a visualization dashboard. This dashboard will monitor several AWS resources, which are Lambda, SNS, State Machine, S3, and APIGateway. Key Dashboard Benefits: - Track the execution time of tasks. - Monitor errors with comprehensive details. - Overview of invocations, cost, and general usage. Design Preferences: - The dashboard design should be simple and clean without any complexity. Skills and Experience Required: - Expertise in Splunk is paramount. - Deep understanding of AWS resources (Lambda, SNS, State Machine; S3; APIGateway). - Familiarity with information tracking (executions, errors, invocations, cost, use). - Strong UX/UI design sensibilities (specifically for simple and clean aesthetic). If...

need to websrapp amazon , flipkart and get current prices of sa list of laptop models on an excel sheet

...intuitive, comprehensive online exam system similar to that of IELTS. Key Features and Interface Requirements: - User registration and login: Prospective test-takers should be able to register themselves and log in independently. - Payment platform integration: Users should be able to pay directly on the website before taking the examination. -Ability to import questions and exam material from excel or csv - Exam result delivery: Post-exam, users must receive their scores directly presented as a percentage score on their screens and via email. Successful applications to work on this project should include past work that directly speaks to these requirements. Experience in developing online exam systems or similar educational platforms will be a strong advantage. A thorough...

...Brokerage website, grab financial statement data and inject that data into an Excel worksheet. Key Requirements: - The program should be able to access Fidelity Brokerage website. - It should grab financial statement data and inject it into Excel. - Specifically, the program should insert this data row by row into a Microsoft Excel Worksheet. - Each stock symbol which the program should enact on will be in one column - The data rows should be organized by having one row per stock symbol. Ideal Skills: - Experience in API and data extraction. - Strong proficiency in Python, VBScript or other programming languages suitable for this task. - Prior experience in creating Excel macros or programs that interact with Excel. - Knowledge of finan...

Extract data from pdf documents into an excel template. No software needed for the job. This is a complex project that requires accuracy and being organised. Must have strong numeracy and proven track record of attention to detail. Knowledge of European languages an advantage. We have over 100 files that will be allocated depending on ability and capacity. If you are interested please get in touch. Work will begin in April.

...Linux-based barcode printing application that supports both QR codes and 1D barcodes. The application must also be capable of importing data from Excel/CSV files. Key Components: - A Linux-based application: The application should be specifically designed to run on Linux operating system. - QR Codes and 1D Barcodes: The barcode printing application should support both QR codes and 1D barcodes. - Excel/CSV data import: The application should be able to import data from Excel/CSV files for generating barcodes. Ideal Skills: - Proficiency in Linux application development. - Experience with barcode generation and printing. - Ability to work with Excel/CSV data import. - Understanding of QR codes and 1D barcodes. If you have prior experience in developing sim...

I'm looking for an experienced programmer who understands MATLAB inside and out. Specifically, I need someone capable of optimizing a data analysis script. This script primarily uses arrays and matrices as its predominant data structures. It's crucial that you excel in: - MATLAB programming - Optimizing code for efficiency - Deep knowledge and understanding of working with arrays and matrices data structures If you are an expert with these requirements and have the know-how to streamline and optimize for speed and stability, your skills are highly valuable in this project. I look forward to reviewing your bid!

I'm seeking an expert in Excel who can efficiently merge two sets of numerical data sourced from different spreadsheets. Key tasks include: - Cleaning similar columns to create a unique identifier for perfect merging - Conducting statistical analysis on the merged data to find the mean, median, mode Ability to analyze data meticulously, professional experience in using Excel and familiarity with advanced statistical functions are essential for this project. Stringent attention to details is appreciated, as the data to be handled is delicate and the outcomes crucial. An understanding of data cleaning techniques in Excel would be an added bonus.

I need Backend developer for my social media app with flutter background to connect the front with the backend I will provide you the full Frontend to connect it with backend you will create. Features: Replace Events (calendar) Tab with Reels Tab . Like, comments, share posts(images, videos, written posts), reels, stories, live, like and reply...videos via chat Video call Group chat archived chats, online or offline time ago . Friends only can send messages or contact to each other . User profile info (edit profile pic or bio, private profile or public profile, details section for work education etc. and all normal features inside it) . Settings (Delete or deactivate account etc. , edit account information, birth, name, Email). .Dashboard to delete or deactivate posts, accou...

Proyecto de automatización con sharepoint, Excel, power automate y power bi

I am seeking an Excel expert capable of preparing a comprehensive document comprising more than 10000 rows and columns. The scope of the project involves processing substantial data sets, namely: Organizing Scanned documents and extracting the data, organizing the data in different corporations by department and years. Be able to extract a P/L and AR for all companies. Project is to be done in stages - Text - Numerical data - Date Information The ideal candidate for this job should have: - Expert knowledge of Excel and related functionalities. - Strong attention to detail. - Proven experience of data entry in large volumes. - Familiarity with basic mathematical operation functions within Excel. The deliverable will be a well-structured Excel document cr...

...expired, how many people redeem your voucher Admin - Admin help vendor key in vendor company detail (name, address, phone, email, state ) -Admin manually help vendor create cash voucher - company name - address -State - Expired date voucher - Voucher amount or % Discount - Phone - Point deduct when redeem - Vendor joining until when - Admin dashboard will display who vendor will expired joining, or coming soon. Must have report -Admin can Disable/Enable vendor joining if no make payment. -Admin can do checking whether the OCR scan data is correct or not. If wrong can "EDIT" I'm in a bit of a hurry and would appreciate getting this done within a month. Ideal Skills: - Proficiency in web development - Experienc...

I have to download everyday +- 3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where: - I'll write the day, month and year - I'll write the first invoice number and last invoice number that I want your tool to search - I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL. The URL for these files is a standard URL. It's always an URL like this: The only part that changes is day, month, year and invoice number. Example: if I want to download any available invoices between numbers 5000

I need expert help with formatting documents across Microsoft Word, Excel, and PowerPoint. The key tasks include: - Formatting text: Ensuring consistency, readability, and visual appeal for all text elements. - Tables and charts: Skillfully organizing and presenting data in tables and charts. - Page layout and design: Creating visually engaging and professional layouts. - Resume: Crafting a creative resume with a professional touch. Ideal candidates should have: - Proficiency in Microsoft Office suite, with a focus on Word, Excel, and PowerPoint. - Proven experience in text formatting, table/chart creation, page design, and resume formatting. - A keen eye for detail, design, and visual presentation. - Ability to work efficiently and meet deadlines. - Familiarity with modern...

In need of an Excel whizz to immediately help in cleaning up my spreadsheet which has become cluttered and confusing. The main task will be: - Formatting cells and columns: Your experience in making spreadsheets intuitive, organized, and easy-to-read will be key. Expertise in creating visually appealing and easy-to-navigate cell and column formats is crucial. Though the specific type of cell and column formatting was not specified, the ability to quickly adapt and modify to different formatting styles would be a plus. Please note, this task is time-sensitive and requires prompt completion. If you have a proven track record of quick turnaround times on similar projects, don't hesitate to apply. Your efficiency and attention to detail will be prized.

link my shopify site to instagram and pinterest. I already have a meta dashboard and would love help creating and posting ads for me on both of these platforms.

I'm looking for a web developer to create an advanced dynamic website dashboard. I have already created a website dashboard. I am attaching a video and implementation report. The website dashboard that I have is static and does not have any user interactions and features. I need features like; 1) The user can manipulate the graphs 2)user can filter on months and years of graph 3)interactive graphs 4)add more dynamic features You don't have to create a new dashboard; you just have to update it. I will give you online database access and this website dashboard code.

I'm in need of a programmer skilled in pine scripts (tradingview). I am looking for someone who can create an alert in my script that is triggered when all specified conditions (Multiple conditions) are met. The conditions were not delineated in the planning phase. The key task for this project is that for example when the first condition met shou...this project is that for example when the first condition met should keep a record of that value and then use that value to another condition to trigger the alert. The ideal freelancer would: - Have experience in building complex alert systems - Understand and be able to work with the existing code - Be able to complete this task within the given time frame - Have great attention to detail and excel under limited supervision My...

I'm seeking an Excel specialist who can help automate the process of managing my inventory. The main task includes creating a function that calculates and displays the number of pieces in boxes on pallets. This project mainly revolves around calculative automation and descriptive statistics. Key responsibilities: - Developing an Excel function that calculates the number of items in the boxes on pallets - Automating descriptive statistics to make the process more efficient An expert with profound knowledge in Excel and a strong background in performing operations associated with calculation automation and descriptive statistics would be the ideal fit for this task. Your role will revolve around simplifying my procedures and making my work a lot more manageab...

I am looking for an experienced Power BI developer to transform my Excel spreadsheets into an interactive sales performance tracking dashboard. Key Responsibilities: - Utilize Power BI to create a visually appealing dashboard from Excel data. - Ensure the dashboard accurately reflects sales performance. - Develop the dashboard to provide a static report for easy viewing. Ideal candidate should have: - Proficient in Power BI to effectively transform Excel data to a user-friendly dashboard. - Strong analytical and visualization skills to accurately represent sales data. - Excellent attention to detail for accurate tracking and data representation.

I am looking for a freelancer to create a pricing spreadsheet based on the specific website, which is Format and Structure: I am ...quantity. The spreadsheet should output the price of the product with tiered discounts based on quantity. The desired outcome would function like but on a spreadsheet. ***A future project will integrate this spreadsheet into a website for live front end pricing.** Ideal Skills and Experience: - Proficiency in spreadsheet software such as Microsoft Excel or Google Sheets - Experience in data entry and organizing information - Attention to detail to ensure accurate pricing information - Ability to work independently and efficiently in completing the task.

I am seeking an expert with proficiency and accuracy in data cleaning and data entry. The project involves handling a significant dataset of more than 1000 records. The data, currently in Excel spreadsheets, needs proper cleaning—deleting duplicates, handling missing entries—and subsequent entry into a new, streamlined database. Ideal Skills: * Expertise in Excel and spreadsheet management * Proficiency in data cleaning techniques * High-speed data entry with attention to detail Experience: * Experience handling large data sets * Previous work in data cleaning and data entry operations With your help, this project will result in accurate, well-organized, and easily-accessible data, which will make an enormous difference in how we run future analyses and make in...

I'm looking for a skilled Excel expert to help prepare a company operations sheet. The project involves: to Prepare a Small Company Operations Sheet My Budget is fixed . 1000 Rupees I want an auto-calculated Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor Invoice ...

I am looking for a skilled developer to integrate a property management system with our WiFi / Blue tooth Smart Locks. Key Requirements: - Implement a seamless integration between our existing property management system and the WiFi / Bluetooth Smart Locks. - Develop a web-based dashboard that allows for remote access management, real-time notifications, and access history logging. - Ensure that data is accurately and securely exchanged between the property management system and the smart locks. Ideal Skills: - Proficiency in property management system integrations and IoT systems in general. - Experience with developing web-based dashboards. - Strong understanding of security measures for data exchanges. - Familiarity with WiFi / Bluetooth Smart Locks and their capabilities. Pl...

...Python, Excel VBA, and API integration. The primary task is to extract specific data from the API response, and populate it into a designated column in an Excel file. Key Requirements: - Experience in Python programming - Proficiency in Excel VBA - Demonstrable experience with API integration - Ability to parse specific data from an API response from Google Server - Good understanding of automating tasks in Excel Further Details: - The primary purpose of the project is to send API requests with image URLs listed in column A of the Excel file. Upon receiving the API response, the relevant data should be extracted and placed in column D and B/C/E to be populated. - The setup should be easy to execute when needed by click of few buttons and automatical...

I need an Excel workbook that incorporates customer contact information, sales volumes, and insightful visualizations for better decision-making. Key Features Needed: - **Customer Contact Information**: The workbook should include customer names 2 contact info fields (email & phone). Data Representation: - **Sales Data & Customer Slicing**: There should be 3 sheets within the workbook with sales volumes. Users should be able to use a pivot table to filter and slice data by branch and year. - **Customer Variances Year-over-Year**: I need the workbook to show customer variances year-over-year. This should include both percentage change and absolute difference. Visualization: - **Top 10 Customers**: The workbook should contain an Excel table that presents the top 1...

I'm in need of an Excel VBA expert to assist me in my project. I require assistance in writing new code, as well as debugging existing code. Specifically, the VBA code is intended for various purposes: - Automating repetitive tasks - Performing data analysis and manipulation - Creating custom functions and macros I specifically have to macros that I've started working on and need debugging: - Replacing references to cell/range addresses in formulas by their name - Implementing Montecarlo simulations (with automatic creation of histograms and data output) The ideal freelancer would have proven expertise in Excel VBA, with a strong track record of writing efficient, maintainable code. It's crucial that the code is robust, error-free, and easy to understand, ...

I am seeking a professional who is adept at data entry and copywriting. This project will require: - Online form filling using data from existing digital documents. Attention to detail an...Skills in data entry and experience with handling digital documents will be essential. - Copy writing for blog and articles. I am looking for someone with experience in crafting engaging, informative, and high-quality content related to my industry. Expertise in blog and article writing is a must, as well as a strong command of English language and grammar. The perfect candidate will possess Excel skills for the data entry part of the project, and should have a track record of creating enticing blog posts that keep the reader's interest. Your bidding should reflect experience and skills ...

I'm in need of an expert excel sheet maker. The primary aim of this project is to create a tool to efficiently analyze sales volume data. It is key for the freelancer to have these specific skills: - Proficiency in Excel with an overall understanding of data analysis - Some knowledge in sales metrics or related field The created Excel sheet should be able to: - Analyze and interpret sales volume data effectively. Prompt extraction of insightful sales volume trends and patterns is key. - The final product should highlight an intelligent layout and dynamic dashboard that aids to easy comprehension. - Be a dependable tool for future records and reference. Anyone willing to take on this project should be experienced and have a track record of creating ...

...-> Footer Along with the Landing page I also need a dashboard where users can see the -> price updates, past data and analytics of the different crops. -> Weekly and Monthly history of the crops data -> Based on the data give predictions of the Crops. Dashboard :- -> Side Menu Shows -> Dashboard - Main Cards with some analytics. -> Crops - Cards with Data Representation Graphs -> Package - 3 Tires Cards Monthly Subscription. -> Settings - Profile details come here -First Name - Last Name - username password, email. Dashboard for use to see the price updates, past data and analytics of the different crops. Weekly and Monthly history of the crops data Based on the data give predictions of the Crops. Pages/ Tabs in Da...

...expired, how many people redeem your voucher Admin - Admin help vendor key in vendor company detail (name, address, phone, email, state ) -Admin manually help vendor create cash voucher - company name - address -State - Expired date voucher - Voucher amount or % Discount - Phone - Point deduct when redeem - Vendor joining until when - Admin dashboard will display who vendor will expired joining, or coming soon. Must have report -Admin can Disable/Enable vendor joining if no make payment. -Admin can do checking whether the OCR scan data is correct or not. If wrong can "EDIT" I'm in a bit of a hurry and would appreciate getting this done within a month. Ideal Skills: - Proficiency in web development - Experienc...

Looking for an experienced web developer to create a map-based public website with the following features: Functional Requirements: • Display locations pin on the map based on Excel/database details (name, Address (or Lat/log), Phone, picture etc. Attributes) • Provide a nearby location list on the left based on the current location or a list of locations based on search and filter criteria. • Enable zooming to the selected location from the list and vice versa. When a map location pin is selected, the corresponding list should be highlighted in the left places list. • Map zoom based on the mouse scroll (Should not be embedded google map) . • The list will include pictures and summaries of the place's rating from Google, cost, number of reviews, addr...

Looking for a seasoned developer experienced in creating custom web-based inventory systems. The system should be user-friendly with capabilities including: -Category Management -Product Management -Dashboard for admin with full access -Dashboard for users with limited access -Comprehensive Reporting System Applicants who have past experience developing similar systems will stand out. Kindly include examples of your previous work in your application for my consideration. Not only would this experience be relevant, but it would also provide me with a level of comfort in your ability to deliver. Understanding the nuances of access-level dependent dashboards will be essential in this role. The perfect candidate will be able to create an easy-to-use interface, optimized for adm...

I need your help in creating an automated script or formula that can run multiple find-&-replace functions, at the same time, on an Excel spreadsheet that could regularly include 1,000 to 5,000+ records. Specifically, I will run this routine on the physical address column of data (not on the Company Name or City or State columns). In the attached .xlsx file, I would run the routine for all of a Column B. Here are the 20 specific tasks involved: 1. If a cell contains the word "Ave" or "Ave.", it should be replaced with "Avenue". 2. If a cell contains the word "Blvd" or "Blvd.", it should be replaced with "Boulevard". 3. If a cell contains the word "Ct" or "Ct.", it should be replaced with "C...

I have a set of scanned images in PDF format that I need converted into an Excel sheet. The job is purely data entry - you are to copy the content from the scanned images into an Excel sheet. The freelancer should have excellent typing skills and attention to detail to ensure that no data is missed or entered incorrectly. Ideal Skills: - Proficiency in Excel - Fast and accurate typing skills - Detail-oriented - Experience with data entry, especially from scanned images - Excellent communication to ensure any questions about the data are clarified before entry

Very simple project - need an excel wiz who can remove some duplicate entries & total up some columns. Only bid if you are an excel wiz & very experiened in excel