Excel Macros Jobs

Proyección y/o Corrida Financiera para abrir un local comercial ( charcutería y quesos ) Local, Mobiliario, Materia Prima, Sueldos, etc

Has sido contratado por una clínica odontológica de renombre para desarrollar un sistema de agendamiento de citas eficiente. La clínica tiene varios médicos con diferentes especialidades y horarios, así como tres salas de cirugía disponibles. Debes crear una solución que maneje la agendación de pacientes desde una lista inicial y permita agregar nuevos pacientes de manera óptima. Requisitos del Desafío: Agendación Inicial: En este archivo encuentras la información suministrada. Tienes una hoja con información sobre los médicos, sus especialidades y sus horarios de disponibilidad. Hay una lista inicial de pacientes con diferentes niveles de prioridad (baja, media y alta) y sus datos (nombre, te...

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add the Con...

I'm in need of a comprehensive spreadsheet tailored for managing preventative maintenance in a manufacturing setting. Key Features: Equipment Identification: Similar to a preventive maintenance schedule, start by listing all the equipment that requires maintenance. Include details such as equipment name, identification number, and location. Maintenance Tasks: List the specific maintenance tasks that need to be performed for each piece of equipment. This could include tasks such as inspection, cleaning, lubrication, calibration, and part replacements. Frequency of Maintenance: Specify how often each maintenance task needs to be performed. This could be based on factors like manufacturer recommendations, usage hours, or time intervals (e.g., daily, weekly, monthly). Priority and Cr...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS...

As we are Manpower Supply Agency, We would like to incorporate attendance day to day entry of our workers from this info we would like to automate payroll, billing and Government salutatory. and also a dashboard for overall performance of our agency. Skills and experience: - Human Resources and Employee Management expertise - Ability to create user-friendly interfaces - Experience with Single Sign-On (SSO) integration and other login methods - Capable of adding features like search functionality, photo upload, and editable fields - Excellent communication skills to understand our needs and translate them into a functional system.

I need an Excel expert to assist me with various tasks involving data analysis and calculation 1. I have data and you need to do the historical data 2. After that you are required to write report as per requirement and instruction 3. Deadline: you may take 8-10 hours

App iOS with masaniello (money management). I can share a similar example.

I need a proficient developer to create a custom inventory management system that directly caters to the needs of supply chain managers. The following details explain my project requirements: Required Features: - The inventory management system should effectively track inventory in real-time - Maintain up-to-date inventory count instantaneously to avoid running out of stock - Implement intermediate level alerts for low stock to enable proactive inventory replenishment Skills and Experience: - Proven experience in developing inventory management systems is crucial - Understanding of supply chain operations will be beneficial - Demonstrable knowledge in establishing real-time tracking and alert systems The main aim is to optimize inventory control, minimize stockouts, maintain the right...

Looking to automate a data entry process and generate reports on Google Sheets. The ideal candidate should be able to integrate data from Google Forms and CSV files into the Sheets to perform these tasks. The project has to be completed ASAP.

I'm seeking an experienced power app developer to build a small, yet crucial, data-driven application. The app will mainly focus on data input and storage, as well as calculations and analysis. Key Project Details: - The app should be capable of managing both text and numeric data. - The calculations and analysis will be unique, thus the need for custom scripts. The developer should be able to create the necessary algorithms and functions to support this. Ideal Skills and Experience: - Proficient in Power App development - Strong understanding of data input, storage, and calculations - Ability to create custom scripts for analysis - Experience with similar data-driven projects Please note that this project requires a fast turnaround. The right freelancer should be able to complet...

Looking to automate a data entry process and generate reports on Google Sheets. The ideal candidate should be able to integrate data from Google Forms and CSV files into the Sheets to perform these tasks. The project has to be completed ASAP.