Using dat files excel jobs

I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics

I'm looking for an experienced professional to assist with reconciling my business bank account using Microsoft Excel. This task involves reviewing deposits, withdrawals, and transfers. Key Responsibilities: - Bank Account Reconciliation: You will be responsible for ensuring all transactions are accurately recorded and accounted for. - Invoice

We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.

I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the s...Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and Dir...

I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.

...me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data analysis, particularly with Excel - Experience with QI projects - Ability to presen...

...ensure deadlines are met. 5. Sugarcrete Initiative: Research and compile a list of bagasse suppliers in Belize for future brick manufacturing. Track costs related to Sugarcrete separately from gym expenses. Ideal Skills & Experience: Strong project management and organization skills. Experience with branding, marketing, and social media management. Proficient in financial tracking tools like Excel or Google Sheets. Familiarity with website development, online payment systems, and POS systems. Great communicator and skilled at keeping others on task. Resourceful with research and able to present clear recommendations. Scope & Budget: Scope: Ongoing, with a focus on the gym setup and other key projects in the first few months. Estimated Hours: 15–20 hours per week...

Freelance Opportunity: AP Script Expert for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow and id...

...Status Updates: Requests should have statuses: Pending Under Process (after Engineering Manager approval) Completed Status changes should trigger notifications. Dashboards & Reporting: Basic dashboard with the following insights: Request counts (by status, department, and priority) Average lead time (from submission to completion) Filter requests by department, category, status. Export reports to Excel/PDF. Access Control: Only authorized roles can approve/reject requests. Unauthorized users should see appropriate error messages. Custom request forms based on department/role. Technology Preferences: Web-based (accessible via PC & mobile). Simple UI with minimal complexity. Hosted online for real-time access. Suggested stack: Node.js (), MongoDB (or simple JSON storage...

I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.

I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience

I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets

...Operational analysis Which areas of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk management (1-2 indicators). 2. Describe the perspective of the customer selecte...

...application. This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Responsibilities: - Collaborate with me in developing a web application using Java. - Implement features such as user authentication and database interaction. - Create engaging weekly content to facilitate the learning and development process. Ideal Skills: - Proficiency in Java and experience in web application development. - Familiarity with Visual Studio Code (VSC). - Experience in implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel...

I need a professional who can help me extract data...POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, with taxes and fees itemized separately. This is essential for my accoun...

I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets

Professional Template Design and Optimization

...contracting business. The ideal candidate will have experience in the construction and real estate industry and be proficient in using Excel for financial modeling, reporting, and analysis. Key Responsibilities: Prepare and maintain annual budgets, revenue forecasts, and expense tracking using Excel. Analyze cash flow and ensure liquidity to meet operational needs. Assist in financial decision-making by providing insights and recommendations. Monitor project budgets and ensure financial alignment with company goals. Develop financial models to forecast project costs and returns. I am looking for an experienced financial analyst who can help prepare a comprehensive Excel workbook that includes all necessary formulas for financial analysis across vari...

I'm looking for a professional teste...my website before we go live. The testing should cover both the front-end and back-end, with all glitches and errors documented in an Excel sheet, categorized, and using Scrum methodology. Front-End Testing: - Usability testing: Assess the user experience and interface design. - Performance testing: Measure the responsiveness and stability. - Cross-browser testing: Ensure consistent functionality across multiple browsers, specifically Chrome, Firefox, and Safari. Back-End Testing: - Security testing: Identify any potential vulnerabilities. Ideal candidates for this project should have extensive experience in website testing, and be proficient in using Excel for documentation and Scrum for project management. Experie...

I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.

...top-tier professionals who excel in designing as well as creating captivating product images and brand content, including A+ Content and Brand Stores. We are particularly interested in working with forward-thinking designers who use AI tools for bulk image generation like Midjourney, Dezgo, Adobe Firefly, and equivalents to create compelling, emotion-driven product visuals —without the need for complex photoshoots. Bonus points if you also have expertise in digitally creating product videos to enhance listings further. What we’re looking for: - Extensive experience in designing Amazon-specific content. - A deep understanding of Amazon’s ecosystem—this includes knowing how to optimize visuals to boost conversion rates and align with platform guidelines. -...

Redesign - full logo pack with all the different files and formats, brand guidelines, media pack.

I need an expert in Excel 365 who can link two sheets for me. The first sheet should update the second in real-time. - Data Type: The data to be linked is mixed, consisting of both text and numerical data. - Version: The linking has to be done in Excel 365. Please only reach out if you're proficient in Excel and can ensure real-time data linking. Thank you.

...Delta Exchange using Tradetrone. Below are the specific requirements: Buy Entry Conditions: - A green candle is detected; execute Buy trade at market price after candle close. - Check difference: Close Price minus Low Price <= 3 points. - Stop Loss: Set at 3 points. - Trailing Stop Loss: Based on the lowest price of the previous candle. Sell Entry Conditions: - A red candle is detected; execute Sell trade at market price after candle close. - Check difference: Close Price minus High Price <= 3 points. - Stop Loss: Set at 3 points. - Trailing Stop Loss: Based on the highest price of the previous candle. Additional Conditions: - If a Buy position is active, do not execute Sell trades, and vice versa. Ideal Candidate: - Expertise in Python programming and strategy automati...

I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of end of day to late evening Sunday, 01/26/25. Key...

...c. Contact Information: i. Contact Person’s Name ii. Contact Person’s Title iii. Mobile Number iv. Main Number v. Email Address 2) Specific NGO Focus: Ensure the search targets Muslim-based NGOs only. 3) Use array aggregation to optimize credit usage, grouping multiple data points into a single data object. 2. Output Requirements: 1) Export the aggregated data into Excel format. 2) Automatically upload the Excel file to a designated Google Drive folder. 3) Provide sample outputs for the following locations: a. Malaysia, Selangor b. Indonesia, Jakarta c. Thailand, Bangkok d. England, London 3. Documentation: 1) Create a Microsoft Word instruction manual covering: a. How to run the workflow. b. Adjusting search parameters for countries, states, and categories. c...

I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.

...Constraints: The report will be provided to the manager within 3 seconds. The report will include all tasks marked as "Completed" or "In Progress." Displaying the report: The system will present the report clearly and orderly, including graphs and statistics. Constraints: The system will ensure the report loads within 5 seconds without delay. The system will allow downloading reports in PDF or Excel format. 6. Use Case: Smart Recommendations for Employees or Managers User Actions: Requesting a smart recommendation: The manager or employee can request the system to provide a suggestion for improving or optimizing work. Constraints: Recommendations will be provided only after the system has gathered sufficient data on projects and tasks. System Actions: Collec...

Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First phase within 2-3 hours. Thank you,

# Job Title: Submit Job Applications on Job portals using my Resume # Job Description: I am looking for a reliable freelancer to submit job applications on my behalf using my resume on various platforms, like Linkedin, Workday and Indeed. Your task will involve searching for relevant job postings that match my qualifications, and submitting my resume for each opportunity. # Responsibilities: - Search for job postings on Linkedin, Glassdoor, Workday and Indeed that match my experience and skills. - Submit my resume to the job listings - Ensure each application is relevant to my background and experience. - Track and report the total number of applications submitted using MS Excel or Google Sheets # Requirements: - Strong attention to detail and understanding o...

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points f. Co...

I'm seeking a skilled Excel programmer to create a macro. This macro should compile various employee data from different sheets into a new Excel sheet. The task involves data cleaning, analysis, and report generation. Key Requirements: - Experience in Excel macro development - Understanding of data cleaning and analysis - Ability to generate summary reports, pivot tables, charts and graphs - Familiarity with handling employee data Please note, the goal is to create a macro that can automate this process, saving time and ensuring consistency in data compilation.

I'm looking for someone to create several spreadsheets that display various financial metrics related to shipments of multiple grades across different countries. The sheets should track specific details for each shipment and highlight key insights. Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong understanding of financial data - Ability to visualize data clearly and concisely Specific Requirements: - Track shipment dates - Monitor product grades - Keep a record of destination countries - Provide an overview of which grade has moved the maximum - Include quantities and other relevant data - Need charts and graphs to represent the data as well - Pivot tables and more. These spreadsheets will be instrumental in helping me understand the financia...

I'm seeking a professional team to execute a stunning drone light show for a public event or festival. The show will take place in an open field, and its main purpose is to entertain the attendees. Key Responsibilities: - Plan and choreograph an impressive light display using drones. - Ensure the show is suitable for a public event. - Manage all logistics related to the drone light show. Ideal Skills and Experience: - Proven history of executing drone light shows. - Highly creative with a knack for designing entertaining sequences. - Excellent logistical and organizational skills. - Strong commitment to safety and compliance with aviation regulations. Must have experience in skybrush studio and have exisiting shows experience

I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.

I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.

We are looking for an experienced Android developer to create an APK similar, with features like real-time audio communication, text messaging, and a user-friendly interface. The project involves using NIO (Non-blocking I/O) and WebRTC libraries for high-performance, low-latency communication.

I'm in urgent need of an experienced professional who ...Your main task will be to find data on mortgage foreclosures sold within the past 90 days. Key Responsibilities: - Collect data from public records, real estate websites, and county auctions. - Input data into an Excel sheet with a flexible structure. Key data points include: date of sale, foreclosed address, city, county, state, owner name, phone, email, opening and closing bid. - Leave cells blank for missing data. Ideal Skills and Experience: - Previous experience in data collection, particularly in real estate or mortgage foreclosures is preferred. - Proficiency in Excel with a keen attention to detail. - Strong understanding of honesty and accuracy in data reporting. Please do not waste my time if you cann...

...Accessibility Designer/Operator with expertise in both Adobe products (InDesign, Acrobat, etc.) and Microsoft Office (Word, PowerPoint, etc.). Your role will be to ensure that documents meet WCAG 2.1 standards, providing accessibility for all. Key Responsibilities: Format and remediate PDF documents to meet WCAG 2.1 standards. Ensure accessibility compliance for Microsoft documents (Word, PowerPoint, Excel) and export them correctly to accessible PDFs. Use Adobe Acrobat and accessibility tools to add tags, alt text, and fix reading order. Conduct accessibility checks and resolve issues flagged by tools like Adobe Accessibility Checker and Microsoft Accessibility Checker. Key Requirements: Proficiency in Adobe InDesign, Acrobat Pro, and Microsoft Office tools. Strong k...

...PowerBI dashboards and reports. There are about 9 fields from Autotask, 3 from Quickbooks Online, and 4 fields from Excel which I need to have all in one place for analysis. At this point, to start, I'm just looking for customer data - income, expenses, status, and a few other fields both numberical and descriptive Key Responsibilities: - Consolidate data from diverse sources, including Excel files, Google Sheets, Autotask, and Quickbooks Online. - Focus on Financial and Sales data primarily. - Ensure the data is clean, well-structured, and ready for analysis. Ideal Skills: - Proven experience with data consolidation from multiple sources. - Strong proficiency in Excel and working with Google Sheets. - Familiarity with Autotask and Quickbooks Onlin...

I need a tool that can clean my computer from junk files and cookies, cache, etc Desired Programming Language: C# (preferred) * Do not bid if you have under 3 reviews, you will be ignored * Need Source Code when Job is Complete, After any Bug fixes, and Updates * Milestone release upon completion of project & is bug free. * Please post "I've read everything" when applying, so I'll know you actually read this and give you priority response. * I'm looking for best deal possible.

...remote job. MS-SQL database expertise is required. The office hours are from 9 A.M. to 6 P.M., and lunch is complimentary. The project involves: - Implementing new features. - Bug fixing. - Performance optimization. The new features to be added include: - Customizable reports. The level of customization for the reports includes: - User-defined filters - Customizable layouts - Export options (PDF, Excel) Ideal candidates should have: - Extensive experience in raw PHP - Proven track record in developing reporting panels - Ability to work under pressure and meet deadlines - Excellent problem-solving skills for bug fixing and performance optimization - Experience in implementing new features in a timely manner - Skills in developing customizable reports - Familiarity with creatin...

I need an Excel report that handles financial data, including expense tracking, revenue generation, and profit and loss analysis. The report needs to have interactive features such as pivot tables and interactive charts. Ideal Skills: - Proficiency in Excel, particularly with pivot tables and creating interactive charts - Experience working with financial data - Ability to create comprehensive and easy-to-understand Excel reports

I'm looking for someone to complete an excel spreadsheet with financial data sourced from various company websites. This project will primarily involve researching and collecting data related to property purchase prices, monthly rent amounts, lease start dates, and lease lengths. Ideal candidates for this project should: - Have experience with data collection and Excel - Be detail-oriented and able to work independently - Have a basic understanding of financial metrics and real estate - Be able to source reliable data from company websites Please provide examples of similar projects you have done in the past.

I'm looking for an experienced data analyst or Excel specialist to create a dynamic spreadsheet for me. I have sales data from 5 stores, and I want a spreadsheet that I can upload weekly sales into. This spreadsheet should calculate: - Weekly and monthly running totals for items sold per store - Total sales across all 5 locations The data points I have include: 1. Date of sale 2. Item 3. Transaction number 4. Price sold at 5. Store # If a customer buys 3 of the same item, it will give me 3 separate lines of data (i.e., all sales listed are quantity of 1). I will be uploading my data weekly through a CSV file into Microsoft Excel. The spreadsheet needs to be able to generate the following reports: - Weekly total sales - Monthly total sales - Item-wise sales per store...

We are seeking a skilled map creator to develop a detailed 50 X 30 grid map for a fantasy world. The map should be based on an existing image and crafted using the Inkarnate map maker. Attention to detail, creativity, and an understanding of fantasy themes are essential. The final output should be visually appealing and aligned with the provided reference image. If you have experience in map making and a passion for fantasy worlds, we would love to see your portfolio. Please apply with your previous work examples and your approach to this project. Please answer this question other I will reject your proposal.... 1) Do you have experience with the Inkarnate map maker software?

I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or 1 another website , VERY easy because 2 /3 brand only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.

I'm looking for a research assistant who can help me collect and analyze both quantitative and qualitative data fo...research assistant who can help me collect and analyze both quantitative and qualitative data for an academic project. Key Responsibilities: - Data Collection: Gather both quantitative and qualitative data relevant to the research. - Data Formatting: Organize and prepare the collected data in Excel/CSV files and Word documents. - Data Analysis: Analyze the data to extract meaningful insights. Ideal Skills: - Proficient in data collection and analysis - Experienced in academic research - Skilled in using Excel and Word - Capable of working with both quantitative and qualitative data. Please, only apply if you're experienced in academ...

Key features of your custom CRM 1. User management: • Role-based access for administrators, team members and other user groups. • Secure login and tracking of user activity. 2. Leads and Opportunities Tracking: • Centralized dashb...to assign tasks and leads to team members. 3. Workflow Automation: • Automate repetitive tasks like follow-ups, reminders, and approvals. 4. Communication: • Integration with email, messaging or telephony systems for seamless communication. • Notification system for important updates. 5. Reporting and Analysis: • Customizable dashboards to track key metrics. • Exportable reports (PDF, Excel) for performance reviews. Depict corporate structure: Main business can have multiple subsidiaries, and eac...

I'm looking for a skilled Visual Basic programmer who can help me develop an Excel macro. This macro needs to automate data entry tasks in a spreadsheet. Key Responsibilities: - Develop an Excel macro using Visual Basic. - The macro should be capable of automating repetitive data entry tasks. - Ensure the macro is user-friendly and efficient. Ideal Skills: - Proficiency in Visual Basic, particularly in creating Excel macros. - Experience with data entry automation. - Excellent problem-solving skills and attention to detail.