Excel Macros Jobs

I need a Power BI expert to create an operational performance dashboard specifically for tracking inventory management. Key Requirements: - The dashboard will focus on: - Stock levels - Order fulfillment time - Inventory turnover Ideal Skills and Experience: - Proven expertise in Power BI - Strong background in dashboard creation - Experience with operational performance metrics - Familiarity with inventory management processes Please provide examples of previous work and relevant experience.

Project Title: Advanced Automated Sales, Payments & Package Tracking Dashboard Project Overview: We are looking for a top-tier Excel/VBA expert to develop a comprehensive, automated financial tracking and reporting system for our business. The goal is to create a powerful tool that not only provides a high-level dashboard but also automates our entire workflow, from sales and payment reconciliation to tracking pre-paid packages and dynamically sorting orders into status-specific sheets. This project involves integrating data from three separate raw data exports and requires significant automation to link payments, update order statuses, and generate filtered reports automatically. Key Deliverables: Interactive Dashboard Sheet: The primary interface, providing a clear,...

I need a Windows desktop application for a simple and compound interest calculator. The tool should facilitate easy monthly and quarterly calculations, as well as track payment history. Key Features: - Simple and compound interest calculations - Monthly and quarterly calculation options - Payment history tracking Ideal Skills: - Experience in developing Windows desktop applications - Proficiency in financial calculation software - UI/UX design skills for user-friendly interface Looking forward to your bids!

DATA ANALYST 1. Essential Job Functions A. Collate data (manually in MS-Excel format) from various departments/ agencies in offline mode. B. Create a database with data points from the knowledge repository of previous editions/ years. C. Online integration of various geographically dispersed nodes (presently in stand-alone mode) to ensure seamless connectivity and flow of information/ data on a real-time basis, with a good user interface. D. Create dashboards using Power BI tools for analysis of current and historic data points and visual representation of key statistics and analyses per client requirements. E. Create customizable codes using advanced Excel macros for further and continuous refinement/ improvement of the model structure in the future as well. F. Accomplish and present fo...

I need a comprehensive HR management system for my small company. The system should include: - Employee database: A centralized database to store employee information. - Payroll management: Automate salary calculations, deductions, and generate payslips. - Attendance tracking: Monitor employee attendance, leaves, and absences. The system should support role-based access control to ensure data security and privacy. Ideal skills and experience: - Proven experience in developing HR management systems. - Strong understanding of payroll and attendance tracking mechanisms. - Expertise in implementing role-based access control. - Familiarity with database management and user interface design. Please provide samples of similar work done. Looking forward to your proposals!

I need a desktop application project planner focused on progress tracking. Essential Features: - Progress Reports: Detailed, customizable reports to monitor project advancement. Ideal Skills: - Experience in desktop application development. - Strong design skills for user-friendly interfaces. - Ability to create customizable reporting features.