Excel vba dashboard jobs

Hiring a hybrid NYC remote assistant for a clean energy company. Job is Mond...calling) Job includes: -Scheduling clients with company for installs via phone calls -Keeping track of installs and inventory -Updating information for bookkeeping -Simple accounting and invoicing -Appointing clients to their appropriate sales rep -Social media management -Answering calls and relaying messages Must: -Speak English -Live in NYC -Have knowledge about common use of simple apps like excel, google drive, word, Gmail, WhatsApp -Organized Preferred: -Spanish / Chinese / Russian speaking -Website building, data security, tech -Photoshop -Living in Brooklyn or Queens Type : NYC only to show not a bot Please include a 15 second audio of your speaking voice to show you have english of working pr...

I am in need of an expert Excel VBA programmer who can enhance my existing proposal workbook. The primary focus of this project is to integrate xlookup functionality and to enable the workbook to generate additional rows and tabs that pull data from various sources. Key Tasks: - Implementing xlookup function: The freelancer is expected to introduce this specific function into the workbook, allowing for efficient data retrieval. - Generating additional rows: The workbook should seamlessly add rows as needed, ensuring comprehensive data management. - Pulling data from tabs: The expert should enable data extraction from various tabs within the workbook, ensuring a streamlined process. - Generating additional tabs: The workbook should be equipped to create new tabs as required,...

I require an Excel expert to assist with a complex data analysis. The dataset is quite large (more than 1000 rows) and involves matching combinations. Key Requirements: - Data Analysis: The main purpose of your task is to help me analyze the data available. This will involve identifying patterns and matching combinations. - Excel Skills: You are expected to have advanced Excel skills to handle this large dataset effectively. - Combination Matching: The combinations you will be working with are complex, and may require manipulation of the data. I'm looking for someone with extensive experience in Excel, particularly in data analysis and matching complex combinations. Your ability to efficiently handle large datasets and work through complex data structures...

Hi , Developers skilled in Node.js who can complete the first stage within 3 days should apply. If you can integrate TypeScript applications from GitHub and have previously integrated GPT-4, feel free to make an offer. You are free to determine the timeline for subsequent stages. 1. Stage One: • Basic: Login via GitHub or Google, registration, and forgot password • Admin Basics: Dashboard displaying new registrations (daily, weekly, monthly, and total) and active user stats • Admin Medium: Modify user info (delete or suspend) • Pricing: Stripe integration to facilitate monthly premium subscriptions • ChatBot: Create a page where users can upload PDFs, access chat history, modify chat names, delete chats, create new chats, and select chat models (free users ...

I need an expert in Power BI to help me visualize sales data. The project will mainly have two tasks: - Dashboard design - Report creation The ideal freelancer for this project should have: - Advanced skills in Power BI - Experience in sales data analysis - Proficient in dashboard and report design, - Excellent in data visualization The main objective of this project is to visualize data insights from the sales information provided. Your work will be instrumental in plotting our sales strategy and informing key business decisions.

I need a freelancer to gather contact info for 42 recruitment companies based in UAE. This information will be used for job seeking purposes. Key Requirement: You will need to find the contact name and e... Irwin & Dow - Premier Recruitment - ManpowerGroup - Mark Williams - Robert Murray - Future Tense - Black & Grey - Education 1st recruitment - Results should be in an excel sheet format, outlining the name, position, email address for each contact. Contacts for each company should be grouped together, end file should be in 1 sheet, not separate sheets.

I'm in need of a console script that can scrape specific details from the dashboard page of a desktop game, focusing specifically on the game progress. The script should be able to fetch the required data and store it in a CSV format. Key Requirements: - The script should be able to scrape the game progress statistics from the desktop game dashboard. - The extracted data must be saved in a CSV format. Ideal Skills: - Proficiency in developing console scripts for data scraping. - Experience in handling game data and understanding game progression. - Capability to save the scraped data in a CSV format. Overall, I intend to use the scraped game progress data to monitor and adjust the game's difficulty, so it's essential that the script can reliably pull this ...

...give informations like website or phone number/email. So the goal would be to add more informations to the pappers scrapping with google maps. The issue here is it would take a lot of time to type the companies names found with pappers inside google to get the additonnal information. So there is, maybe, a way to "sychronize" the export (scrapping) of the two plateform and merge them into one excel table, or maybe to automatically enrich the pappers scrapping result with google maps. Key requirements for the job include: - Proficiency in data scraping from Google Maps and Pappers - Ability to work with API's - The ability to sort and categorize leads as per the indicated criteria - Experience with automation tools and scripts - Strong analytical skills to ensu...

i will create 1 power power point and 1 excel sheet adding the equations

i will make excel and power point files

I need to extract data from multiple Excel files and visualize them in a separate sheet using line charts. This project involves: - Creating a separate sheet in Excel to display the data from several Excel files - Implementing a system to automatically update the data - Generating line charts based on the data Ideal skills and experiences for this project include: - Proficiency with Excel, including data handling and visualization - Experience with data extraction and integration - Expertise in creating and customizing line charts The project requires high attention to detail and the ability to work methodically with large datasets.

As someone looking to hire a talented content writer, I have a variety of assignments that'll involve writing content within a word limit of 500-1000 words. I didn't specify the exact type of content since the tasks may vary. However, a strong command of English and the ability to write engaging, quality content are essential. Ideal Skills and Experie...content since the tasks may vary. However, a strong command of English and the ability to write engaging, quality content are essential. Ideal Skills and Experience: - Excellent writing skills - Versatility in content writing - Ability to generate creative ideas - Experience in varying styles and formats of writing - Understanding of SEO is beneficial, but not required If you believe you would excel at this, I encourage ...

I'd like to request a quote for "xl heet and powerpoint".

We're looking for a web developer to refine an existing HTML page! You'll take a previously converted Excel sheet (.html) and enhance its visual appeal. This involves adding CSS styling to improve the layout, formatting, and overall aesthetics of the page. Experience with HTML and CSS is a must, and an eye for clean and user-friendly design is a plus!

I'm in need of an experienced Tableau Developer/Analyst/Designer to help me enhance an existing dashboard, and improve its performance and functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am lo...

I'm looking for a skilled Laravel and Vue JS developer to create a real-time Sales Report. Key Features: - The main feature of the report is the ability to display sales data by product. - The data for the report comes from an existing database, so the ideal candidate should be comfortable working with database integration. Key Requirements: - You will need to ensure that the report updates in real-time as transactions happen. - The data presentation should be clear and user-friendly. Ideal Skills and Experience: - Strong knowledge of Laravel and Vue JS is essential. - Prior experience with real-time data updates and database integration. - Experience in creating sales reports or similar data-driven projects would be a plus.

I'm seeking a skilled developer to create a website where users can generate customized Excel tables. Below are the key project requirements: Key Functions: - The website should allow users to generate customized Excel tables based on specified criteria such as user input, date range, and data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering: - The system should offer a subscription model w...

The project requires a freelancer with exceptional attention to detail and expertise in Excel to conduct a thorough review of a spreadsheet for any data inaccuracies and anomalies. The primary tasks involve identifying and rectifying incorrect or illogical entries, ensuring the consistency and integrity of the data, and highlighting any variables that require correction. The ideal candidate for this role should have strong proficiency in Excel and data handling, as well as experience in data quality assurance. This meticulous review is crucial to maintaining the accuracy and reliability of the data, which is essential for making informed decisions based on the spreadsheet information. Attached with the details is a sample of the spreadsheet with 20 participants. The complet...

...individual who can handle a medium-sized excel database (1000-5000 rows) that comprises of numerical, categorical and textual data. Key Tasks: - Data Entry: The selected candidate will need to input some outstanding data into the excel database accurately. Great attention to detail is vital for this task. - Data Analysis: I want someone who can decipher patterns and trends from raw data. This may include evaluating figures, trends, and other areas to draw practical insights. - Data Visualization: After carrying out an in-depth analysis, I want the extracted information to be presented visually to aid understanding and decision-making. Desirable Skills: - Proven experience in data entry, analysis, and visualization - Proficiency in using excel for data tasks...

As a beginner, I'm in need of someone skilled in typing data into Excel spreadsheets. The data entry will involve basic formulas and functions for simple data analysis, and I'm looking for someone who can make this process easy to understand and execute. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Able to explain basic formulas and functions in a clear and concise manner - Attention to detail to ensure accurate data entry - Patience and understanding of beginner level tasks

...accurately entered into an Excel spreadsheet. This will be done manually, so you must have excellent typing skills and attention to detail. - **Turkish Characters Proficiency**: An essential requirement for this job is a strong proficiency with Turkish characters. As some of the books will have titles and authors in Turkish, you should be able to accurately interpret and enter these characters. - **Handling Missing Data**: In the event that a book's details are missing or illegible, I would like you to search online for the information. If this is not possible, then the field should be left empty. Please note that I do not want placeholders like "Unknown" used in the spreadsheet. Your responsibilities will include: - Typing in the book title and author accuratel...

...of a freelancer who can help me create a visually appealing PowerPoint presentation and handle some moderate data analysis in Excel. PowerPoint: - Your role will be to make my content visually engaging through simple transitions and animations. - Creativity and a good eye for design are essential to make the presentation impactful for the audience. Excel: - You will also be tasked with handling moderate levels of data analysis and visualization. - I will require you to work with pivot tables, conditional formatting, and possibly other mid-level Excel skills. Ideal Skills: - Proficient in PowerPoint with a strong design sense. - Comfortable working with Excel and able to handle moderate data analysis tasks. - Excellent communication skills to understa...

I'm looking for a Python programmer who can create custom code to extract text, numerical data and dates from an Excel spreadsheet and populate PDF fields using the PDFMiner library. You should be confident writing Python scripts and have experience manipulating Excel and PDF files. Familiarity with PDFMiner is a essential. - Must Haves: - Proven Python programming experience. - Familiarity with the PDFMiner library. - Ability to extract and manipulate data from Excel. - Experience in PDF field population.

I require proficient help to tackle a substantial data cleaning and organization job. The task involves over 2000 records that must be meticulously cleaned and streamlined. You'd be working directly in Excel, so a thorough knowledge of this software is essential. Understanding of data organization, deduplication, and data cleaning is required. Aptitude for managing large quantities of data would be advantageous. A keen eye for detail and commitment to delivering high-quality results are crucial.

I'm looking for someone proficient in data entry to help me transform scanned PDF documents into an organized spreadsheet format. Ideal Candidate: - Proven experience in data entry from PDF to excel or similar - Precise attention to detail to ensure accuracy of the data - Efficiency to meet deadlines with minimal supervision Principal Duties: - Convert scanned PDFs into an Excel spreadsheet - Focus on extracting and entering text content from the PDF documents - Maintain the overall integrity of the original information - Ensure the accuracy and reliability of the final spreadsheet data

I'm in need of an experienced data entry specialist to input text-based data from typed documents into an Excel spreadsheet. I have a series of typed documents that need to be transferred into Excel. The data consists entirely of text, with no specific formatting required. It's important that the freelancer pays close attention to detail in order to ensure the accuracy of the data entry. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong attention to detail - Previous experience in data entry - Time management skills to meet deadlines - Ability to do research - Fluency in English

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...

Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from...financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal years. Requirements: - Certification in financial analysis. - Experience in creating consolidated financial statements. Note: - This pro...

I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.

...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...

I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and manipulation of complex datasets. -...

My WordPress website is currently displaying "Error establishing a database connection" and I can't access the admin dashboard. I need an experienced freelancer with deep expertise in WordPress troubleshooting and database issues resolution. Tasks will include: - Diagnosing the cause of the database connection issue - Fixing the problem to get the website back online - Ensuring all website features are functioning as they should post-fix I'm using a Cpanel on Godaddy for hosting. So, familiarity with Cpanel and Godaddy is a requirement for this task. Also, I'd prefer someone with immediate availability as this is a high-priority issue. Skills required: - Advanced WordPress proficiency - Strong understanding of databases - Experience with Cpanel and God...

I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyze the extracted data - Devel...

Power bi dashboard creation as per the user requirements

I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.

I'm in need of a skilled individual who can create and manage a dashboard style report in looker studio based on data from our SIS. The dashboard will need to integrate data from our SIS, which includes details on work provided to students across the state. The attached example report is a previous statewide report. We will need one for each school district and a few custom reports for funders. These only need to be updated once per year to be ready by the end of May. The ideal candidate for this project should have: - Expertise in Google Looker Studio - Proficiency in working with SIS databases. - Experience in data visualization, especially in creating dashboards on Google Data Studio/ Looker Studio. - Strong understanding of data security and privacy best practi...

I'm seeking an Arduino developer who can provide me with a simple code for the 'ESP-WROOM-32' board. My project requires configuring the Arduino to produce a specific light blinking pattern. The trigger for this action will be a warning light in my dashboard. Details: - The ESP-WROOM-32 board is my Arduino of choice. It should be programmed to perceive the status of my dashboard’s warning light. - Once the Arduino detects that the warning light is on, it must signal for another light to blink. -I want to splice into another warning light on my car instrument panel and use the power feed on that as my input signal for the arduio - I prefer the blinking pattern to constitute 5 blinks, followed by going out. -I can power the board from a 9v battery if using the...

I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.

We have a web application in which we want to enhance the overall visual appeal, specifically focusing on the dashboard. We are looking for experts in React and who can bring a fresh perspective to our user interface. Your tasks will include: - Visually enhancing the dashboard. Bring creativity and flair, while maintaining an intuitive layout. - Writing unit tests to ensure robust functionality. We require: - A strong understanding of React/, with experience in designing attractive and effective UI. - Proven record in UI/UX design and improvement. - An eye for aesthetics, understanding of color schemes, typography and overall design principles. - Experience in writing unit tests within a React/ environment. Overall, the aim is to refine the visual appearance of our

I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos To find all the state outlines, you will need to Googl...

...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. Ideal Qualifications: - Proficiency in Data Analysis: You should have a strong background in data analysis and an ability to extract key insights from complex data sets. - Expertise in Google Analytics: Experience with Google Analytics is essential for this pro...

Using a data set filter data to another set to show case dashboard metrics and KPIs

I am looking for a specialist to design and implement a water level monitoring system specifically for the water tanks present within moving vehicles. The ultimate aim of this system is to ensure an adequate and consistent water availability via continuous monitoring. Key Features and Requirements: - ​​The system should provide visual alerts on a dashboard and in case of low water levels, alerts must be generated. - This will require a familiarity with employing appropriate sensors, embedded systems, microcontrollers storing data in cloud, LoRa WAN, SIM communication and designing intuitive user interfaces for non-technical personnel. Ideal Candidate: - Experience in the design and development of monitoring systems., industrial grade embedded system, cloud storage, LoRa communic...

I have a level sensor which is currently sending data to a local Wi-Fi network, accessible through a web brows...through a web browser using the sensor's IP. I'm seeking assistance to automate this process and have the following requirements: 1. Data Fetching: The sensor is measuring liquid levels. This specific information needs to be fetched and transferred directly to an Excel sheet. 2. Data Update Frequency: The data should refresh in the Excel sheet every minute. 3. End Goal: The collected data will be used to generate a chart in Excel. Ideal skills for this project would include extensive experience with automation, proficiency in Excel, and understanding of level sensor operations. Knowledge of networking would be a plus. Are you the right p...

...well-versed in to streamline our boards and processes. This includes: - Establishing connections for our 'Leads', 'Scheduling', 'Patients', 'Reports', and 'Billing' boards. - Incorporating vital automations in our system such as task assignment, deadline triggers, document creation and reminder notifications. - Designing insightful dashboards namely, a Sales performance dashboard and a Financial dashboard. The ideal person for this job should have extensive experience and a proven track record in implementing and enhancing systems in monday.com. Their capabilities should extend to interpreting our company's needs into automated processes, and creating intuitive dashboards that help in monitoring our business perform...

...Comprehensive experience in building authentication and authorization systems. - Knowledge of implementing role-based access control. 1 Registration Screen for Admin & User UserID Password Confirm Password FirstName MiddleName LastName Email Phone Sex Company Date Created Date Updated 2 Forgot Password Email 3 Change Password Old Pass New Pass Confirm Pass 4 Admin Dashboard Screen to manage Users and User Roles a. Admin User have permission to create an another user. Page #1 can be used. b. View of Users and Assign Roles, Permission. Status, Last Login, Date Created/Updated/Deleted. 5 Logs - Admin to view the logs of all the users - like when they logged in , what actions they did for audit purpose. Just a view and search scr...

I'm in need of a proficient Smartsheet expert to assist me in recommending and developing multiple program and project plans. I want to work with expert on a shared screen to help me to learn as we go. I need someone fluent in English - I have a little hearing loss Key responsibilities will involve: -Building SMARTSHEET plans -- Linking to External data (i.e. Excel) that will be used in updating the SMARTSHEET plans. - Utilizing SMARTSHEET Functions: Proficient use of formulas and calculations is essential for this project. - Building Reports and Dashboards: Experience in creating comprehensive and visually appealing reports and dashboards is necessary. The primary goal for this project is to efficiently and accurately track the progress of different projects within the ...

*** US CANDIDATES ON...background to manage various tasks. Key Responsibilities: - Budgeting: You'll be responsible for creating and monitoring budgets to ensure financial health. - Expense Tracking: Accurately log and keep track of expenses to maintain a clear financial picture. - Invoicing: Prepare and send invoices to vendors and clients in a timely manner. Your Experience: - Proficiency in Excel: Since I currently handle finance using Excel, it is essential that you are comfortable with this software. - Previous Finance Management: Experience in budgeting, expense tracking, and invoicing is a must. - Strong Communication: Being able to keep me updated and informed on financial matters is key. Please highlight your relevant experience and how you can support me in ...

I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.

I'm looking for an expert in Excel to build a comprehensive 'Team Scorecard' for my team. This sheet will be used to track a range of tasks and behaviors to ensure the team is performing at their best. Key Features: - The project involves tracking various tasks and behaviors including daily reports, client communication, social media postings, timekeeping, invoicing, and meeting attendance. - I need the sheet to calculate total and average points automatically. This will be based on the tasks completed and the quality of those tasks. - It should also include conditional formatting to highlight outstanding performances. This will help us recognize and reward exceptional work. - Data validation is important to ensure accuracy and consistency in point entries. - Visu...