Dashboard macro excel jobs
Go over two excel sheets and highlight records from first sheet containing specific text from the second sheet
I require a tool or script that can effectively convert my checking account bank statement from PDF to Excel. There are 4 bank accounts, from 2017 to 2023 - totaling 159 files in PDF. - 2 accounts from Santander - 2 accounts form Caixa Economica Please find attached 2 PDF files as an example. For Caixa Economica statements, there are only 2 PDFs (one for each account). For Santander, the PDFs are divided by month. Details: - Critical data fields to be extracted include: transaction date, transaction description, transaction amount, number of destination accounts for PIX, TEDs and DOCs (bank transfers), and account balance. Ensure accuracy in these fields during conversion. - The Excel spreadsheet should have 4 tabs, one for each bank account. - The converter should be de...
I am in need of a proficient Excel expert for some unknown tasks. Since I haven't detailed the specifics, I would like potential freelancers to be adept with: - Formulas and calculations - Data analysis and reporting - Data manipulation and formatting Whether it's creating a new spreadsheet or modifying an existing one, I will need help. Therefore, display adaptability and experience in various Excel scenarios. Your application should include past work, experience and a detailed project proposal despite the brevity of my requirements. Please provide as much detail as possible in your proposal, due to the unspecified nature of the tasks.
I'm seeking a skilled Excel user for formula automation and chart creation in my project. Your role includes: - Creating Excel formulas that automate various functionalities. - Incorporating charts into the spreadsheet to visually represent the data. Although the specific type of charts hasn't been specified, a proficiency in creating diverse types of charts (including bar, line, and pie) will be advantageous. A strong understanding and experience with Excel formula automation and data visualization are essential for this task.
I'm seeking an expert to personalize our company's Zoho CRM, aligning it with the unique demands of a real estate firm dealing in properties from various developers. We have a team of about ten agents that will be utilizing this platform. Key Features Required: 1. Integration of Zoho CRM with Facebook, Instagram, and LinkedIn for real-time lead capturing and management. 2. A comprehensive dashboard for our administrators, managers, and agents, encompassing: - Sales pipeline view - Lead tracking - Performance analytics - Campaigns overview - Agents tracking - Information on leads both qualified and contacted 3. Implementation of a round-robin system for equitable, real-time lead distribution. Ideal bidders should possess noteworthy experience in CRM cu...
I'm in need of an expert with proficiency in Excel and Quickbooks. An Excel spreadsheet needs to be created. The data dump will be provided, your task will be to extract specific information from it. The needed data includes: - Sales data (Date and Customer name, Amount and units sold) - Expense details (Date, Vendor name, and rental paid per unit) Need various information to be in one place and one click. The extraction process must be automated and compatible with Quickbooks for seamless integration. The ideal candidate should have experience in data extraction, Microsoft Excel, and Quickbooks, as well as exemplary accuracy skills to ensure the data is free from mistakes.
...and netbanking. • A user-friendly dashboard displaying pertinent data based on the user's role. • Report upload and download capability. • Wallet balance check and refill functionality. Login Requirements: • Registration to store user data, barcode and patient ID in the database. • Login is also facilitated using barcode verification for admins. • Distinctive user entry points for patient, admin, doctor, and board member. Ideal candidates for this project should have a strong background in healthcare-related application development and a firm grasp of the technologies listed (JAVA, Spring boot microservices, MySQL, Node.js, React). Your portfolio should display prior work in mobile OTP-based authentication, payment gateway integration, and rol...
I am seeking a freelancer who excels in using Excel to manage large data sets. You will need to perform specific tasks, including: - Data Filtering: Skilled in using various Excel functions to sort and filter large amounts of data. - Basic Arithmetic Operations: Proficient in performing addition operations on the data set. - Statistical Analysis: Capable of conducting descriptive statistical analysis on the data provided. The ideal candidate possesses an excellent command of Excel, and a strong background in statistical methodologies.
...can put job offers. 2) another user can apply to the job offers if they want. • Cart: cart icon can be on top of shop like in ; User can add desired items to cart , and proceed to payment; • Payment: Payment should be only online like using UPI, cards, etc. ; Buyer pays the artist (seller) and buys his/her item ; Part of payment should go to admin; • Admin Panel/Dashboard: This should be accessible only to admin. To get insights of the activities in the main page . and also receive part of payment. • About, Help, Terms of Service: Take a look at , top right corner 3 dots for an idea. i can edit the information for these. So, this was the brief of the website. I don't need a complicated one. And again do watch the demo video. Please...
I am looking for an experienced developer to develop a logistics aggregator that will be accessible on web and Android platforms. This project requires: - A feature for real-time tracking - Integration with multiple couriers - A user-friendly dashboard to manage shipments - User registration and login capabilities Prior experience with similar projects is preferred. Mastery of Android development, web development, and experience in integrating with third-party courier APIs is essential.
I need to redevolop a simple shopping cart based on Excel VBA. Requirement is to rework current design and function. I prefer developer that can with russian and english language, as this would help get some information from former versions. Pls contact me. BR Michael
I am looking for a dedicated and skilled professional to fill the role of a virtual voice and messaging assistant. Key Responsibilities: - Primarily, you will be tasked with answering customer queries with clarity and precision. - Additionally, you should be able to carry out typing tasks with a quick turnaround time. Required Skills & Experience: - To excel in this role, you should have a strong background in customer service, with exceptional verbal and written communication skills in Spanish. - Experience in related roles, especially as a virtual assistant, is highly desirable. This role will require a firm understanding of my business and the ability to represent it effectively to our clients. If you can handle these tasks competently and professionally, I am eager to he...
I have to create an exe which contains data in gridview and the data also contains the path of the image. And all the images are saved inside the folder. Whose path is given in the database record. So I have to export excel from gridview. I have attached the files as an example, you can prefer that.
I am looking for a dedicated individual who has strong research skills to find companies on the inte...include: - Identifying such companies - Gathering specific information about them including sales revenue, company name - Collecting their contact details: name, phone number, and email address Ideal candidates for this task will possess the following skills: - Strong research and data entry capabilities - Sound understanding of e-commerce, retail, and manufacturing industries - Proficient in MS Excel or similar data management tools - Exceptional attention to detail to ensure accuracy of gathered data - Excellent communication to report findings promptly. This job requires devoted attention and precision. Please bid if you consider yourself an astute researcher with an eye f...
I am in need of an accounting expert with a minimum of 3 years experience to handle bookkeeping, accounts receivable and accounts payable tasks. The ideal candidate should have excellent proficiency in Excel, Microsoft Access and Netsuite. Your responsibility will include: - Maintaining and updating financial records, invoices and receipts - Performing accounts receivable/payable duties - Handling any other task that involves Excel, Microsoft Access or Netsuite. Strong attention to detail, problem-solving skills and knowledge of accounting principles and laws are required.
As an experienced user of AutoCAD bricksCAD, I am looking for an Autolisp programmer adept with the creation of tailor-made commands to enhance my workflow. Key tasks form the scope of this assignment: 1. Creating a basic electrical single line diagrams using interaction between excel data and predefined blocks in bricksCAD such as transformer, breaker, main switch board, distribution board, busbars,other electrical components.
...thrives on getting everything in order and has the ability to make Excel sing. As an experienced data entry individual, you will be tasked with the following: - Sorting and organizing data into meaningful, easily navigable formats - Mastery in crafting complex formulas to make excel work its magic - Examining and validating data meticulously to ensure cleanliness and accuracy Your extensive experience with handling numerical data, specifically sourced from online platforms, is crucial for this project. Mention your proven track record and provide specific examples of past projects in your application. Show your competence with handling online-sourced data and how you leveraged it to create insightful and efficient Excel documents. Prove to me you can take comman...
We are seeking an experienced freelancer proficient in process management and organizational workflows to develop an enhanced new hire onboarding process template in an easy to edit format (Excel, canvas, powerpoint) with a focus on optimizing the HR team's roles. Key Responsibilities: Design and implement a comprehensive workflow that streamlines the new hire onboarding process, specifically addressing the tasks performed by the HR team across different stages. Department Talent Acquisition Team: Screen Candidates Manage the Interview Process Extend Offers Manage Pre-Screening Process Provide First Day Instructions Initiate Pre-Onboarding Packets for Candidate Completion Monitor Completion of New Hire Paperwork Monitor I-9 Section 1 & 2 Completion on First Day Candidat...
I urgently need an expert in automation with a good understanding of Excel and Notepad files to streamline my data entry process. The aim is to allow for efficient and error-free data input to reduce the amount of time I spend manually entering data. Job Requirements: - Creation of an automated system for data entry tasks - Ability to process text input and numeric input - Capability to input data pulled from other files Skills & Experience: - Proven experience in automating Excel and Notepad processes - Strong knowledge of data input methodologies - Exceptional attention to detail and accuracy - Proficiency in creating secure and reliable automation systems - Ability to deliver work promptly Please note, this project is time-sensitive. Therefore, a quick turnar...
I require a professional with vast experience in data cleaning using Excel. My numeric data, currently less than 1000 records, needs some tidying. Key tasks include: - Removing duplicate entries. - Handling any missing values. - Correcting any inconsistent entries. Proficiency in Excel data tools and understanding of data cleansing methodologies are important. Candidates who have worked on similar projects will likely provide a faster turnaround.
I need an expert in Excel reporting and MIS dashboard creation to analyze and visualize my sales leads data and conversions, need to add all formulas where it I put in the team deatols with their leads and conversions and it automatically gives me the stats eith pie focus areas for tracking would be: - lead generation daily - Revenue - Sales daily Few more parametees Key requirements are: - The ability to handle large volume of data - Efficiency in creating automatic update processes, as the report and the dashboard should update daily when data comes in - Strong understanding of sales and financial metrics - Precision, accuracy, and attention to detail The ideal freelancer would be fast, reliable, and have an outstanding record in Excel and data visualiza...
I am in need of a proficient and meticulous data-entry specialist who can confidently manage text, numbers, and dates in an Excel spreadsheet. The exact volume of columns and rows is yet to be determined, but efficiency and attention to detail will be key. Additionally, the ability to potentially create a working template may be required, as this decision has not yet been finalized. Therefore, experience with Excel template design is desirable alongside robust data-entry skills.
For my project, I am seeking a meticulous freelancer with strength in data entry. Here's what the task involves: - Entering text-based data sourced fro...strength in data entry. Here's what the task involves: - Entering text-based data sourced from various online resources. - Accurately translating the information provided into an Excel spreadsheet format. The ideal candidate should possess solid data entry skills, attention to detail, experience with Microsoft Excel, and an ability to efficiently surf the web to locate crucial data. A basic understanding of the privacy concerns associated with handling online data will also be advantageous. In summary, I need an efficient individual who can quickly turn online text-based data into ordered and professionally fo...
Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, minitab, quantitative and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood
...upload leads from Excel files or enter them manually into the system. - **Functionality**: Supports Excel file uploads and manual data entry forms. 3. **Email Notifications** - **Description**: Automatic notifications are sent to admins whenever a new lead or user is created. - **Functionality**: Integrates with an email service to dispatch notifications. ### User Features 1. **Dashboard Customization** - **Description**: The user dashboard is tailored to focus on leads, hiding unrelated modules like tasks or projects. - **Functionality**: Displays only lead-related information, with other modules accessible through the main navigation menu. 2. **Lead Management** - **Description**: Users can edit and update lead details, with new leads highlighted ...
I am looking for a highly skilled full-stack web developer proficient in PHP. Your objective will be to construct a Webapp or Webpage for statistical. Skills and Experience: * Prof...system and the data is saved in a csv file and from this moment on, the processing of data generated by the system takes place. Among the statistical data it will be necessary, for example, to know which document was added, read, modified, deleted, the same for folders according to dates. And also users will want to know how many users are or are online on a specific date. So it will be like a Dashboard, with the possibility of changing the graphic representation from a button (bar chart, histogram, circular chart and polygon) if you are interested, write to me and let me know how much you need for ...
I am seeking a dedicated and experienced VBA developer to build an inventory management software that tracks both physical and digital...Features Required: - Inventory Tracking: The system needs to provide accurate and updated record of both physical and digital goods. - Purchase Order Management: An automated reordering function based on predefined parameters is paramount for the efficient operation of our procurement process. The ideal freelancer should have a strong background in building inventory management systems with Excel VBA as well as in-depth knowledge of automated reordering functionalities. This knowledge is critical in order to assure the success of this project. It's also expected that the candidate is proactive and asks any needed question to parse requireme...
...mention the specific features, I'm highlighting some key functionalities which I expect you to remarkably implement: - User Dashboard Interface: Your expertise in developing comprehensive and intuitive user dashboards is crucial. The dashboard should offer a smooth user experience, easy to navigate features, and seamless integration with other system functionalities. - Reporting & Analytics System: Monitoring user activity and gathering insights from data is a must. Hence, the platform should have a robust reporting and analytics system. Requirements: - Proven experience in web development, specifically, with similar projects. - Excellent understanding of User Dashboard Interface, Reporting & Analytics System design and implementation. - An ability...
...v=c_EUheea_Yk&ab_channel=OneCupCards -A subscription based system Monthly/Annually to access your account. - Mobile wallet integration: Compatibility with Apple Wallet and Google Wallet - Notifications: A service to push notifications to users holding the loyalty card - Admin Console: Businesses need a dashboard to manage loyal customers, view real-time customers analytics, customize loyalty & discount cards, and the ability to push notifications to customers' smartphones. Admin Console (Dashboard) should look like - Be passionate about creating user-friendly interfaces with a focus on minimalist design. - Mobile responsive Technology Stack (open for better options): - Firebase for backend and data storage - ReactJS for frontend
I'm looking to collect specific details about farms in the Western Cape. The information will be used for market research purposes and should be perfectly structured in Excel format. Required data include: email & Cell number Experience in data collection, particularly in the agricultural sector, is preferred. Strict attention to detail and high proficiency in Excel are very much required. Knowledge about crops or livestock is advantageous due to the nature of data to be collected. It must be automated.
I'm seeking a skilled developer to create an Order Management System focusing mainly on efficient customer management. Presently we are using JOTFORM to take order online via form, than the orders are categorized on basis of date and time giving our team a dashboard and than those orders are processed. We want a system whereby Customer place order online via web or app. We get the data, the data is displayed in a calender manner so we know number or orders per day. Than relevent data is then converted to reports and sent to production for making the order, to dispatch team to deliver the order. Few additional add-ons will be needed like QR code, auto sms , auto email, auto calls for order confirmation. We can provide further details if required
... and securely by learning more about the following features: Use, Filter, and Update a SharePoint List (Video) Manage Large List and Libraries Restore Items in the Recycle Bin that were Deleted from SharePoint (Video) Add or Remove a News Post (Video) Create a Page (Video) Collaborating in SharePoint With Office and OneDrive or SharePoint, multiple people can work together on a Word document, Excel spreadsheet, or PowerPoint presentation at the same time together. Collaborate in SharePoint Create and Share Files in a Library (Video) Share SharePoint Files and Folders Document Collaboration and Co-authoring Please note that no interactive elements, like quizzes or polls, are to be included in the slides. The ideal candidate for this job will have extensive experience with Of...
I need to know if there is a way to automate a process to transfer data from an excel spreadsheet to an organization chart in Visio. Or a way to validate the data that is on an excel spreadsheet matches what is on an organization chart and show any mistakes
I am seeking a skilled Excel specialist to create a sophisticated and intuitive spreadsheet that serves as a project management tool. The spreadsheet must include the following specific features: - Project Tracking: The main feature I need is the ability to track the progress of multiple projects. Main Aspects: - Milestone Achievements: The spreadsheet must enable tracking of various project milestones. It should notify when a milestone is due and when it is achieved. - Task Deadlines: Deadlines for each task must be clearly displayed and flag whenever a task deadline is approaching or missed. Visual Representation: - Progress Bar: The progress of each milestone contained within a project should be visually represented using a progress bar. - Color-Coded Cells: Milestones a...
...listing and payment gateways in that. My requirement is below Using mobile number only they can login and register. As an admin once i approve then only able to use the application. As an admin I can able to add/remove any user and also possible link to WhatsApp for sending notification or message. Need for ipl betting within friends. Need it in 2 mode 1st mode - App have to show the dashboard how many people participate in particular match and the amount. Need to participate they have to select the scheduled matches. We need a time cut off to participate on daily basis. It means before 7.30 only they can bet post that it will not allow to enter like that. Second mode is based on player performance on every match points have to be added. So finally who leads the points...
I'm seeking an expert familiar with Power Automate to help create a flow that initiates when a new form...initiates when a new form submission occurs. The specifics of the job include: - Trigger Event: The flow must activate upon each new form submission. - Desired Action: After each trigger, I want the flow to capture all answers from the form submission and automatically perform data entry into an Excel sheet. Following that, the system must load the sheet into a specific workbook in SharePoint. Ideal Skills and Experience: - Experience in setting up Power Automate flows - Proficiency with Excel and SharePoint - Strong understanding of data collection and processing from form submissions If you are capable and experienced in these areas, I encourage your bid on th...
I am looking for someone proficient in Excel and familiar with MySQL databases to assist me with data collection, manipulation, and analysis. The ideal freelancer would - Have proven experience in Excel, specifically in data manipulation and analysis. - Be familiar with MySQL databases or apache spark - Understand how to generate comprehensible reports. - Possess an analytical mind to identify trends and patterns from the data collected. The purpose of collecting, manipulating, and analyzing the data is to have a single type of database for all the data-driven decisions I need to make. As such, knowledge in building and working with databases is an added advantage. To make a convincing proposal, show me how you've done something similar in the past. I&#...
I'm experiencing an "HTTP ERROR 500" on the admin dashboard of my WordPress site, predominantly when I attempt to delete a user. The root cause is unsure but could potentially be due to a plugin conflict or a recent update. The ideal candidate will have: - Substantial experience resolving HTTP errors on WordPress - Expertise in troubleshooting potential and resolving plugin conflicts - Pragmatic approach to problem solving to avoid future occurrences of the error. Please note, however, the error doesn't affect the front end of my site. My main aim is to maintain continuity for my site's users while this issue is being resolved.
I'm in need of an experienced financial analyst who can provide comprehensive financial analysis for my firm. The scope of the work hasn't been strictly defined yet, so I would appreciate if the freelancer is f...analysis, and financial statement analysis. Key Role Responsibilities: - Conduct comprehensive financial examinations. - Develop detailed financial reports and statements. Ideal Skills and Experience: - Proven work experience as a financial analyst. - Deep experience in financial forecasting and analysis. - Expertise in various financial analysis types. - Knowledge in a finance software like Excel, QuickBooks or SAP would be a plus, but isn't strictly necessary. Please submit your application with detailed project proposal and portfolio showcasing your ...
PDF to Excel Data Conversation Data looks like same as PDF to Excel
...cloud-based dashboard. **Functionalities Required**: - Enhance repair efficiency - Reduce leakage - Enable GIS mapping - Accurate water supply line assessment The dashboard should be intuitive and user-friendly, able to provide clear visualizations of the pertinent data that supports decision-making. **Data Accessibility**: While I did not specify the data sources to access for accurate water depletion assessment, it would be advantageous for the chosen freelancer to have experience with various data sources, including weather, water usage, geographic, and sensor data. **Project Deadline**: I require this project to be completed within a month. The freelancer should have strong project management skills to ensure the timely development and delivery of the ...
I am looking for freelancers to help with data entry work. It's a simple and boring work. You simply have to enter data from photographs into an excel sheet.
I am looking for a professional who can efficiently extract and copy all information from a PROTECTED Airtable sheet to Excel. No adjustments or specific arrangements on the data are required - I just need all the values intact and legible. Key responsibilities: - Extract all data from the PROTECTED Airtable sheet: - Copy data to Excel without any modifications This is a one-time task, so timeliness and accuracy are essential. Ideal freelancers are those who have extensive experience with both Airtable and Excel, as well as a deep understanding of data extraction principles. Strong attention to detail is an asset.
I am looking for a professional who can efficiently extract and copy all information from an Airtable sheet to Excel. Key responsibilities: - Copy/Extract all data from the Airtable sheet: - Copy data to Excel without any modifications
I'm in need of a top-notch Excel freelancer, a pro at data analysis. I have sales data that needs to be accurately analyzed. Key Responsibilities: - Analyze sales data - Foresee future sales It is critical that you're proficient in: - Excel for data analysis - Financial forecasting - Understanding of sales trends and patterns Your insight will be used to forecast our future sales based on our past data. It is essential that you are meticulous, have a strong attention to detail, and can provide accurate forecasting. Being able to work efficiently and meet deadlines is also a must. Excel experts only.
As a client, I am urgently hunting for a professional with advanced proficiency in both Vue.js and Python development. I am focused on building an automated tasks script and require an expert to make this a reality. Here's a highlight of what you'd be doing: - Imple...full-stack development and ensuring seamless integration. The ideal freelancer for this project: - Has extensive experience in Vue.js and Python development. - Comes with a refined understanding of automated task scripting in Python. - Is able to work independently and efficiently. - Is known for timely deliveries and effective communication. I already have script which is written python and dashboard is vue js. Its trying to items to basket. For increase the speed , ım trying to way. So I have to make r...
We are looking for an efficient Spanish and English speaking professional in Customer Support and Virtual Assistant, to work 40 hours per week monday to friday 9 to 5 (Colombia Time), that can manage: - email handling - Calendar Management - inbound calls - proficiency in Office Suit mostly in Excel - data entry - administrative tasks IT Requirements: A Desktop pc or laptop with: Processor: Intel Core i5 or AMD Ryzen 5 or better RAM: 8GB or more Operating system: Windows 10, macOS, or Chrome OS Noise-cancelling headphones Fast internet connection: Speed: 100 Mbps or more Type: Fiber optic or cable The VA should be prepared to work 40 hours per week. Proficiency in English and Spanish is crucial to effectively bridge communication between our global customer base and our...
Hello, I need assistance with sorting text data in an Excel spreadsheet. My requirement involves the combination of two worksheets. I am hoping to find a solution that expertly filters and sorts data as per my instructions. Here are my requirements: - Proficiency in Excel formulas; - Ability to sort text data; - Skills to combine two worksheets. Should your expertise align with my needs, please consider applying. Experience in dealing with large datasets is a bonus. Thank you.
