Excel Macros Jobs

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...

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

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...

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...

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.