Attendance sheet in excel with formula jobs

I have some work, in an Excel spreadsheet.

...from Accounting Basics to Final Accounts. The course should be structured in chapters and professionally recorded with high-quality video, clear audio, and live Tally software demonstrations. Course Structure: (Expected Topics) 1. Introduction to Accounting & Tally Prime Basics of Accounting (Concepts, Principles, Double Entry System) Accounting Terms (Assets, Liabilities, Capital, Income, Expenses, etc.) Types of Accounts (Personal, Real & Nominal) Introduction to Tally Prime Installation & Activation of Tally Prime 2. Tally Prime Interface & Features Understanding the Tally Prime Dashboard Company Creation, Alteration & Deletion Configurations & Settings in Tally Data Security & Backup in Tally 3. Masters in...

I'm seeking an Excel Online expert to help me set up individual spreadsheets for each of my collaborators, linked to a global billing spreadsheet. Key Requirements: - Create separate, individual Microsoft Excel Online spreadsheets for each collaborator. - Each spreadsheet should have 'Edit permissions' for the respective collaborator, allowing them to input their own data. - The data from the global billing spreadsheet should be reflected in the individual sheets automatically and in real-time, without the collaborator having access to the global spreadsheet. Ideal Skills: - Proficiency in Microsoft Excel Online. - Experience with setting up complex spreadsheet systems. - Knowledge in automating data updates across sp...

Data gathered to an Excel file. Data gather to excel file

I am seeking a qualified auditor to review my company's financial statements. This includes the Balance Sheet, Income Statement, Cash Flow Statement, and any Other Reports Required by Investor's Auditor. Key Purpose: - The primary objective of this audit is for investor reporting. Industry: - This audit pertains to the Real Estate sector, so familiarity with this industry would be advantageous. Ideal Skills and Experience: - Certified Public Accountant (CPA) or equivalent credential. - Proven experience in auditing financial statements, particularly in the Real Estate sector. - Excellent understanding of financial reporting and compliance standards for investor reporting. - Ability to produce clear, comprehensive audit reports.

I'm in need of an Excel sheet specifically designed for calculating construction costs. The sheet should encompass: - Material Costs - Labor Costs - Total Project Cost In addition, I'd like the sheet to incorporate specific Excel functions and formulas such as: - Sum and Averages - Conditional Formatting Ideal candidates for this project should have a strong background in Excel, particularly with creating complex sheets for cost analysis. Experience in the construction industry would be a plus. Please bid with a brief overview of your relevant experience and examples of similar projects you've completed.

I'm a university student seeking a mentor to help me navigate my data module. The focus is primarily on using Excel functions to sort numerical data. Key Responsibilities: - Interpret and explain the tutorials provided - Help me understand and apply Excel functions to sort numerical data - Provide guidance on data analysis techniques Ideal Skills: - Proficient in Excel - Strong understanding of data analysis - Previous experience tutoring or mentoring university students Looking forward to your bids.

Financial Model Brief: National Export of Cattle with Financial Analysis Objective: We require a detailed financial model that provides a comprehensive national overview of cattle exports, with a specific focus on individual exporters. This model should integrate financial ratios and performance metrics for individual exporters, offering insights into profitability, liquidity, efficiency, and financial stability. The model should allow for accurate assessments of export trends, market health, and financial viability, with room for ongoing updates and scalability. The model should also support reworking and enhancement of an existing model to better suit the current requirements. Scope of Work: National Cattle Export Overview: Volume & Value of Cattle Exports: Fo...

I'm in need of a skilled software engineer who can help me fix my JSON parser (implemented in Excel/VBA). The parser is encountering crashes and unexpected behavior when dealing with a new format of JSON. Key Requirements: - Diagnose and fix bugs in the JSON parser - Ensure the parser can handle the new JSON format Ideal Skills: - Proficient in debugging software - Experienced with JSON data and parsers - Familiar with the specific issues of crashes or unexpected behavior

I'm looking for an experienced Excel macro developer to create a macro that will import data from a specific TXT file on my computer and format it to match my PDF example. I currently pull the data from an IBM and it is saved on my windows computer as "AP Data." I then need to be able to open an excel workbook and run a macro that will import "AP Data" and format it so it matches the PDF example identically. All numbers in the excel worksheet after import need to be formatted as accounting so something that appears on the PDF Example as 7.50- will change to (7.50). The print area needs to match the PDF example. There are page numbers at the top right of each page and that needs to be how it prints in excel. ...

I'm looking for a professional with expertise in Bartender Software. I need to create barcodes pulling from specific fields in a Master data spreadsheet. The spreadsheet is located in Egnyte and is co-edited using Microsoft Excel Online. The fields I am interested in include GTIN, Catalog Number, Lot Number, Serial Number, Expiration Date, and Quantity. This data needs to be pulled from filtered data based on a blank Allocation column (see attached spreadsheet) Ideal skills and experience for the job: - Proficiency with Bartender Software. - Experience in barcode generation and software integration. - Attention to detail to ensure accurate data pull for barcode creation. Please reach out if you have the necessary sk...

...Full control over system functions. • Staff (Employees): Can add expenses, view their reimbursements, and check vehicle file status. 2. Vehicle File Management • Ability to create a new file for each vehicle clearance using: o Chassis Number / File Number (Unique Identifier) o Client Name o Vehicle Details o Status: Pending, In Progress, Cleared o Total Expenses Incurred • Staff members can only add expenses if the file is active. • Admin has access to re-open a file in case a staff member forgot to add an expense. 3. Expense Tracking & Reimbursement • Staff members can log daily expenses for each file by selecting: o Chassis/File Number o Expense Type (Custom Duty, Port Charges, Transport, etc.) o Amount Spent o Date & Time (Automaticall...

I'm seeking for a professional who can help me extract contact information from customer accounts on the website www.food-service.de. Key Requirements: - Extracting con...contact information from customer accounts on the website www.food-service.de. Key Requirements: - Extracting contact information from customer accounts on the website - Delivering the extracted data in an Excel spreadsheet Ideal Skills and Experience: - Proficient in data extraction and web scraping - Excellent attention to detail to ensure all relevant contact information is extracted - Experience with delivering data in Excel format Please provide a concise proposal detailing your experience and approach to this project. Show me scraping first 50 details like name,ma...

I am in need of a skilled female Indian professional with expertise in Tally and Excel to assist with data entry and recording. The primary focus will be on tracking expense and income. Key Responsibilities: - Accurate data entry of expenses and income into Tally and Excel - General assistance and guidance in categorizing data Ideal Candidate: - Proficient in Tally and Excel - Excellent attention to detail - Able to provide guidance in data categorization - Female Indian professional

I am looking for a freelancer who can provide me with an email list of AirBnB, VRBO (Vacation Rentals by Owner), and other short term vacation rental hosts in North Carolina, South Carolina, Alabama, and Georgia. in the form of an Excel spreadsheet. All hosts are acceptable and there are no specific criteria for inclusion in the list. The ideal candidate should have experience in data mining and compiling email lists. Attention to detail is crucial to ensure that the list is accurate and up-to-date. The list should contain the following: Name, phone number, and email address, and should all be valid and up to date information. We will need around 1000 leads to start.

...furthest edge of the pool Spreadsheet allows you to pick from a list of material that included the material cost along with a "kit" of other items that are required to complete that Piece of the project.. for example: a pool skimmer kit may include, Skimmer, PVC Pipe, PVC Fittings, Glue, and Labor hours.. All of the items in the Kit need to be easily updated for price. Currently we have all these "kits" pulling from a bunch of columns in the spread sheet that is so wide it is impossible to edit. Guessing there is way to pull this data from a table. We base pricing based of a markup of labor and material that would create a proposal. We need to be able to change the Profit margin in one location, and we also have to be about to s...

I'm seeking a proficient Excel developer to create a quotations maker for me. The quotations should be generated in an Excel format. Key requirements: - The quotations maker needs to have a customer database integration. - The customer database will require manual entry. Ideal skills and experience for the job: - Extensive knowledge and experience in Excel. - Previous experience in developing similar quotation makers. - Understanding of customer database integration in Excel.

I'm seeking assistance with a data entry task involving daily stock prices. Key Responsibilities: - Copy stock prices from the NSE website and Investing.com. - Paste the information accurately into an Excel file. Ideal Skills: - Proficient in Excel. - Detail-oriented to ensure data accuracy. - Familiarity with stock market terminology is a plus. Experience: - Previous data entry experience, particularly with financial data, will be highly regarded.

I'm in need of a Revit professional to create a file for one of our ceiling lights. If the collaboration goes well, there will be more projects to follow. Key Requirements: - Inclusion of light fixture details and all the options in the Revit file - Ability to work from a provided specification sheet for design and material specifications Ideal Skills: - Expert level proficiency in Revit - Previous experience with lighting and/or mirror products - Ability to follow detailed specifications Please reach out if you believe you're a good fit for this project.

We are a local plastering and drylining company in Cannock, Staffs WS11 7LG, currently in need of a qualified freelance Quantity Surveyor (QS). The ideal candidate will be responsible for conducting take-offs for both dry lining and plastering. Key Responsibilities: - Regularly attending our office once or twice a week (local to Cannock is a must) - Conducting accurate take-offs for both dry lining and plastering - Delivering take-offs in digital format (Excel files) Skills and Experience: - Proficient in Excel - Prior experience as a QS in the plastering and drylining industry - Able to conduct both dry lining and plastering take-offs - Local to Cannock and able to attend our office regularly Many Thanks, Chris

I'm seeking a proficient Excel developer to create a quotations maker for me. The quotations should be generated in an Excel format. Key requirements: - The quotations maker needs to have a customer database integration. - The customer database will require manual entry. Ideal skills and experience for the job: - Extensive knowledge and experience in Excel. - Previous experience in developing similar quotation makers. - Understanding of customer database integration in Excel.

...employer with excellent previous ratings and have been awarding projects for 10+ years. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the task ----------------------- Build an AI-enabled application which 1. Recognizes the correct column header and places the correct data in the correct column a. Excel b. Text c. Word document d. PDF 2. Recognizes hand-writing upload from 1. Image files (JPG, GIF or PNG) 2. PDF files 3. Compiles the data into a correct Excel sheet (for students, parent and teacher) 4. Uploads the data into our web application called Kontakkt Please read the attached project file carefully, which explains the output tasks We will provide the winning bidder with ...

I'm looking for an expert in Excel and VBA to help me create a custom workbook. The primary purpose of this workbook is to manage and collate employee time entries. Key Requirements: - Design a workbook tailored for tracking employee time. - Implement VBA code to hide and unhide specific worksheets based on user access. - The VBA code should allow each user to only access the worksheets I define. Ideal Skills: - Proficiency in Excel and VBA. - Experience in designing custom workbooks. - Knowledge in user-specific worksheet management through VBA.

I need assistance with entering numerical data sourced from online databases into an Excel Spreadsheet. Ideal Skills: - Proficiency in Excel - Experience with data entry - Familiarity with online databases Requirements: - Accuracy in data entry - Ability to follow instructions - Attention to detail

I need a skilled app developer to create a robust Android-only application for handling Excel formulas and performing calculations on financial data. Key Features: - The app should generate insightful reports and visualizations from financial data. - Ability to create and edit Excel formulas. - Perform complex calculations with ease. Ideal Candidate: - Proficient in Android app development. - Experienced with financial data processing. - Skills in creating data visualization tools. - Familiarity with Excel and its formulas.

I need an expert in either VBA or Python who can help me search, validate, and compare alphanumeric data in multiple cells in Excel. The results should be shared in another cell indicating whether the data is 'Matched' or 'Not Matched'. Key Requirements: - Proficient in either VBA or Python - Expertise in Excel data manipulation - Ability to implement custom logic for data validation and comparison - Capable of creating clear output in Excel Data Validation: - The data will need to be checked for specific patterns. - The patterns are not standard and will require custom logic to identify. Ideal Skills: - Strong experience with Excel's VBA or Python integration - Excellent problem-solvi...

We are looking for a skilled Design Engineer / CAD Designer with 3-4 years of experience for sheet metal product design (especially in display racks , furniture etc., ). The ideal candidate will have a strong foundation in mechanical design principles and be proficient in drafting software. Key Responsibilities: Design and Drafting: Utilize CAD software (e.g., SolidEdge, AutoCAD, SolidWorks, Fusion 360) to produce detailed 2D drawings and 3D models. Mechanical Design: Apply your understanding of mechanical design principles to create accurate, functional, and manufacturable designs. Sheet Metal based products Design: Design components and systems for sheet metal based products like display racks , billing tables , lab furniture , office...

I need an Excel guru to analyze my bank statement urgently. - Primary Data: The data to be analyzed is my bank statement. - Specific Analysis Required: I need help categorizing my expenses, as well as summarizing my income vs. my debits. - Categorization Method: All expenses should be categorized by merchant name. Ideal candidates for this project should have strong Excel skills, be able to work quickly and efficiently, and have experience in data analysis and expense categorization. Please apply if you can help me with this task urgently.

...operations, such as patient management, medical device connectivity, invoicing, contracts, online booking, user roles and permissions, and detailed medical reports. --- ? Detailed Software Requirements: 1️⃣ Patient Management & Online Booking Patient registration system with full medical history and previous test records. Online appointment booking via website or mobile app with confirmation notifications. Advanced patient search by name, phone number, or ID. 2️⃣ LIS Integration for Device Connectivity Direct connection with laboratory instruments via standard protocols (HL7, RS232, TCP/IP). Automated result retrieval to minimize manual entry errors. Review system before finalizing and releasing results. 3️⃣ Billing & Contract Management Compr...

...Participate in the ME Department Poster Day Dear Graduate Students, I hope this email finds you well. I would like to invite you to participate in the upcoming Poster Day organized by the Graduate Studies and Research Committees in the Mechanical Engineering Department. This is a fantastic opportunity to showcase your research and gain valuable experience in presenting your work in a professional setting. Event Details: Date: Wednesday, April 24, 2025 Poster Submission Deadline: Tuesday, April 15, 2025 Certificate: Each participant will receive a certificate of attendance Awards: The top three posters will be recognized and announced within the department. Attached to this email, you will find the template for your poster submission. Please...

...email. ✔ Sales Closing & Upselling – Convert inquiries into paid coaching clients via DMs & sales calls. ✔ Client Upselling – Offer Hybrid Coaching (PT + Online) based on client goals & budget. ✔ Sales Tracking & CRM – Report daily sales numbers & conversion rates in a Google Sheet. ✔ Follow-Up System – Maintain consistent follow-ups to increase trial-to-paid conversions. ? Requirements: ✅ Experience in fitness sales, lead generation, or high-ticket coaching sales. ✅ Proven ability to close sales (DMs, calls, emails). ✅ Familiar with Instagram/TikTok engagement & fitness sales strategies. ✅ Self-motivated & can work independently to hit targets. ? Salary/Commission Options: ? Option 1: Hourly Rate – ...

I'm looking to work with an experienced Excel specialist who can help me with advanced functions and automation, specifically with sales data. - I need assistance with VLOOKUP and HLOOKUP, PivotTables, as well as Macros and VBA. - The primary goal of the project is to identify trends within the sales data. - I also expect engaging charts, graphs, and summary tables to be created to represent the data visually. - Accuracy and attention to detail are crucial for this project. Ideal candidates for this project should have extensive experience with Excel and data analysis, as well as a keen eye for detail. Skills in creating visually appealing and informative charts and graphs will also be highly valued.

Configuration and integration of Sportspress on WordPress 1 - General configuration of Sportspress - Set up and configure the Sportspress plugin. - Check compatibility with SmartMag theme and other installed plugins. - Activate and optimize performance to avoid site slowdowns. - Develop the player profile using PHP or Python to ensure the site's scalability and avoid any future issues. ________________________________________ 2 - Match sheet configuration - Automatic link between match sheets and player records. - Checks the correct operation of the statistics recorded in the player files. - Automatic synchronization of match data (goals, assists, cards, minutes played, etc.). ________________________________________ 3 - Creating and managing player files Informa...

I'm seeking a skilled Excel VBA developer to create a utility that interfaces with both Serial Communication and IP data, sending the parsed information directly to specific columns in an Excel worksheet for further processing. Key Requirements: - The data being received is mixed, comprising both numeric and text elements. - A significant portion of the project involves data visualization, so experience in working with graphical representations of data in Excel is a must. - The selected freelancer will need to program the utility so that it reflects the parsed data in specific columns of the worksheet. Ideal Skills: - Proficiency in Excel VBA - Experience with data parsing from Serial and IP sourc...

...If you're passionate about teaching and have expertise in SQL, Power BI, Tableau, Python, Machine Learning, R, and Advanced Excel, I’d love to hear from you! Key Requirements: ✅ Extensive experience in Data Analytics, Business Intelligence, or Data Science ✅ Proficiency in SQL, Power BI, Python, R, and Machine Learning ✅ Previous corporate or online training experience preferred ✅ Ability to conduct live online sessions and guide advanced-level students on real-world projects ✅ Excellent communication and mentoring skills What We Offer: ? Competitive Compensation – Get paid per session/hour ? Flexible Schedule – for weekdays and weekend batch ? Engaged Learners – Work with motivated, advanced-level students eager to build...

...the app should be to streamline gym management processes. This includes managing memberships, scheduling classes, tracking attendance, and processing payments. - The app should allow for different user roles, such as gym staff, trainers, and members. Each role should have access to different features, for example, trainers should be able to set up workout plans for members. - The system should be able to generate reports and insights based on the data collected, to help gym owners make data-driven decisions. Ideal Skills: - Proficiency in Android, iOS, and web application development. - Experience in creating management applications or similar projects. - Familiarity with database management and data analysis. - Strong understanding of security and privacy c...

I'm looking for a simple IMEI database with HTML code that I can use for tracking devices. Key Requirements: - The database should allow me to search by IMEI number. The project will involve creating a basic IMEI database that is user-friendly and efficient for tracking device. I get text or excel file with IMEI and its unlocking code. I just want to upload so user just type in imei on page and can get code from that file,

I'm seeking an Excel expert to analyze my sales data. Deadline ASAP Budget is 20AUD

Hello Sophia, Attached is a Excel for translation into Ukrainian. SLA - March 11th. Thank you, G

...Title: Freelance Data Analyst (Advanced Excel & Power BI Expert) Job Description: We are looking for a skilled freelance data analyst with strong expertise in advanced Excel, data management, dashboard creation, and Power BI. The ideal candidate should be able to analyze complex datasets, generate insights, and build interactive dashboards to support business decision-making. Key Responsibilities: Manage and clean large datasets efficiently. Develop and automate dashboards in Excel & Power BI. Perform data analysis to derive actionable insights. Create visual reports and interactive dashboards for stakeholders. Ensure data accuracy and integrity. Requirements: Proficiency in advanced Excel (PivotTables, VLOOKUP, Power Q...

I have a project that involves cleaning mixed data in Excel. Key Tasks: - Remove duplicates - Handle missing values - Standardize formats Ideal Skills: - Proficient in Excel - Experienced in data cleaning - Attention to detail and ability to follow specific instructions

I'm looking for an Excel expert who can make some changes to an Excel file. The task must be completed today.

...313 words) that need to be converted into MP3 audio files. The words should also be translated into Italian. In addition, I have 2 files of phrases (totaling 188 phrases) that need to be translated, though audio is not required for these. Key Requirements: - Utilize an online voice synthesizer as per the attached instructions or any alternative that produces equivalent output. - Deliver the .mp3 files as 3 individual ZIP files, corresponding to each word list. Ideal Skills: - Proficient in Excel - Strong attention to detail (ensuring all output files are consistent in volume) - Familiarity with the Italian language (not compulsory, but preferred) - Native or advanced proficiency in simplified Chinese or Arabic (a plus, as we can discuss exten...

I'm seeking an experienced Excel professional to assist me in creating a dynamic table that will track employee data. Key Requirements: - The table should allow for filtering and sorting of data to facilitate easy navigation and analysis. - Data will be entered manually, so the structure needs to accommodate ease of input and maintenance. Ideal Skills: - Advanced Excel skills, particularly with creating dynamic tables. - Experience with data management, preferably with employee data. - Good communication skills to understand and meet project specifications.

Steps: 1. Go to 2. An Excel sheet with specified columns will be shared with you 3. Search database by state and compile information such as company, contact, url, email address, etc.

...proficient Excel developer to transform an open-source R-Script used for calculating Scope 1, 2, and 3 emissions of buildings into a user-friendly Excel tool. Our clients struggle with R, so it is crucial that the Excel tool has the same functionalities and is easy to use. Key Requirements: - Excel tool must accommodate both numerical and categorical data inputs. - The tool must include the three calculators for Scope 1, 2 and 3 emissions. - Consistency with R-output is vital; the XLS output must match the R-output exactly (see tables 1 to 6). - The interface should be detailed and similar to the R-Script output layout. - Front-end with input and output, backend with calc and datasheets - No VBA/macros, only formulas, VBAs are blo...

Aufgabenbeschreibung: Excel mit VBA-Makros (Datenbank für Venture Capital, Private Equity und private Investoren mit Makros) ? Projektziel: Erstellung einer Excel-Datenbank mit VBA-Makros, die Venture Capital (VC)-Geber, Private Equity (PE)-Geber und private Investoren verwaltet. Die Dateneingabe erfolgt ausschließlich über benutzerfreundliche Eingabemasken. Die Datenbank enthält eine automatische Suchfunktion mit scrollbarer Liste, eine Investitions- und Dealverwaltung, eine Dokumentation der Kommunikation mit Kapitalgebern sowie ein Reporting mit Diagrammen. ? 1. Tabellenstruktur & Funktionen Blatt Funktion Blatt 1: Eingabemaske für Kapitalgeber (VC, PE, Privatperson) Erfassung neuer Kapitalgeber mit Deduplizierung & ID-Vergabe Blatt 2: E...

...professional who can assist me in generating customer invoices in pdf format in bulk using a Microsoft Word 365 template and data from Excel spreadsheets. Your task will involve: - Utilizing a provided Word template to create invoices - Pulling customer contact details, an itemized list of purchases, payment terms and conditions, and a QR code of my company from Excel spreadsheets Ideal candidates should be proficient in Microsoft Word 365 and Excel, with experience in bulk document creation. Attention to detail is crucial to ensure all invoices are accurate and correctly formatted. The deliverable expected is a macro enabled excel which can take the input data from an excel, take the invoice template in...

I need a professional to generate customer invoices in bulk based on a Word template and data in a single Excel sheet. The generated invoices should be in PDF format. Key Requirements: - Proficiency in Microsoft Word and Excel, specifically Office 365 - Experience in bulk invoice generation - Ability to follow a Word template precisely - Skills in converting Word documents to PDF The data is organized in a single sheet with all the necessary information. The ideal freelancer for this project should be detail-oriented to ensure each invoice is correctly generated without errors.

' STRATA COLLECTIONS VERIFICATION TOOL ' This Excel workbook serves as a central verification tool for collections across multiple systems ' Structure and key formulas provided below '============================================== ' WORKSHEET: Import_Controls '============================================== ' Purpose: Tracks import status from multiple systems and standardizes data ' Key components: ' Import Status Tracking Table ' Columns: System_Name | Last_Import_Date | Records_Imported | Exceptions_Found | Status ' Data Source Configuration Table ' Columns: System_Name | Report_Type | Standard_Headers | Column_Mapping ' Import Instructions (Protected cells) ' Step-by-step guide on extractin...