Bright Academic Experts

Category: Excel

  • Group 1 Assignment

    • Read the
    • instructions.

    Attached Files (PDF/DOCX): Mod 03_Group_ProblemSet (V01-03).pdf

    Note: Content extraction from these files is restricted, please review them manually.

  • menjurnal dengan excel denga cepat

    Kita sekarang lebih mudah dalm menjurnal di excel, karena suda disediakan kotak kotak nya makan nya kita lebih mudah untuk mengerjakan nya.

    Requirements:

  • Professional task monitoring excel template

    Hi,

    I would like you to develop a Team Task Management Dashboard in Excel. This should not be just a task tracker, but a strategy-driven performance management tool that supports leadership decision-making.

    Key requirements:

  • Each task must be linked to a Strategic Objective and Strategic Pillar (include KPI if applicable).
  • The dashboard should show: overall % completion, tasks by status, overdue tasks, workload by team member, high-priority items, and performance by strategic pillar.
  • Include KPI tracking, milestone monitoring, and traffic light indicators (Red/Amber/Green).
  • Add automatic overdue highlighting, risk flag, and days remaining calculation.

    • Structure:

    * Sheet 1: Data Input (Task List) and Dashboard

    * Sheet 2: Pivot Tables (can be hidden)

    The goal is to provide clear visibility on alignment, performance, risks, and bottlenecks not just operational tracking.

    Please let me know if anything needs clarification.

    Best regards,

    Requirements: Full

  • Ratio Analysis in excel

    Perform ratio analysis to further your understanding of Oceanviews business.perform an initial evaluation of Oceanviews financial condition and ability to continueas a going concern.

    Requirements:

  • Excel Question

    The purpose of this assignment is for you to understand how to export reports from an ERP system and then use Excel to create formula-based templates & pivot charts that allow accountants and managers to analyze the data more easily. After completing this assignment, you should feel comfortable exporting data from an ERP system and using Excel to analyze data further. This assignment will be graded on your ability to export the correct reports and create the templates and pivot charts. Please refer to the recorded for insights on the formulas and templates.

    Part 1

    1. Create a single excel file that includes an exported sales and production report from your ERPSim game. Each report should have their own tab and be labeled Sales Report and Production Report.
    2. Create a tab that will act as a template to analyze the sales report. The tab should include the following details and measures.
      1. Item #: (this can be hard coded for the products in the game) For example AA-F01.
      2. Product (material description): This should be formula-based (xlookup or vlookup).
      3. Total sales orders for each product: Should be formula-based.
      4. Total sales for each product: Should be formula-based.
      5. Total quantity sold for each product: Should be formula-based.
      6. Average sale per order: Should be formula-based.
      7. Average quantity sold per order: Should be formula-based.
      8. Weighted Average Selling Price (WASP): Should be formula-based.
      9. % of total sales by product: Should be formula-based.
    3. Create a tab that will act as a template to analyze sales further for a specific region (No, So, or We). This tab should include the following details and measures.
      1. Item #: (this can be hard coded for the products in the game) For example AA-F01.
      2. Product (material description): This should be formula-based (xlookup or vlookup).
      3. Total sales orders for each product: Should be formula-based.
      4. Total sales for each product: Should be formula-based.
      5. Total quantity sold for each product: Should be formula-based.
      6. Average sale per order: Should be formula-based.
      7. Average quantity sold per order: Should be formula-based.
      8. Weighted Average Selling Price (WASP): Should be formula-based.
      9. % of total sales by product: Should be formula-based.
    4. Create a tab that will act as a template to analyze the relationship between sales and production. This tab should include the following details and measures.
      1. Item #: (this can be hard coded for the products in the game) For example AA-F01.
      2. Product (material description): This should be formula-based (xlookup or vlookup).
      3. Total quantity sold for each product: Should be formula-based.
      4. Total quantity produced for each product: Should be formula-based.
      5. % of inventory sold: Should be formula-based.
      6. Remaining inventory on hand: Should be formula-based.

    Part 2

    Create two pivot charts using the exported sales report from your ERPSim game. 1) Create a pivot bar chart to visualize the top 3 sellers in the North Area, 2) Create a pivot column chart to visualize the bottom 3 sellers in DC12.

    Requirements: Fulfill all of the directions

  • Adding Formulas and corrections in Excel Spreadsheet

    I have an excel spreadsheet that I need formulas added to or corrected. The “DATE RECEIVED” and “DUE DATE”- (30days out) columns are already done however I’m not sure if i did it correctly. I need the “DAYS LEFT” column to have a countdown to 0 and also turn Red when it reaches 15 days since date received, this way the worker knows they have had the case 15 days and need to work it asap. As of now, it is backwards. If you can add a chart that shows how many cases were Closed/Incomplete, Assigned, Pending Records, and Denied by the month, that would be great, (All under Column “DECISION”. One more thing, I need to open this with Google Sheets as well, currently when I email myself a copy and open this version on my PC for work on Google sheets, the DAYS LEFT column will not show up as red.

    Requirements: 300

  • Wk 5 Checkpoint Coded and Uncoded Spreadsheets

    I’m attaching the professor’s examples for what she wants for the spreadsheets. One of them is coded, and one of them is not. I believe the information should be the same for both spreadsheets, the coded one just has the extra filters that she added in the videos. Remember that each review should have the review itself posted, the pro, the con, and advice, so four rows would fall under 1 ID. If a review is missing a pro or a con or advice, just put “No Pro”/”No Con”/”No Advice”. I’m assuming her examples are as far back as 2018 because that’s probably when she created the assignment, but obviously we need to start with the most recent and work backwards.

    Attached Files (PDF/DOCX): HRM 5314 Video Instructions for Week 5 Checkpoint.docx, HRM 5314 Week 5 Checkpoint Instructions.docx, Initial Themes Data Analysis.docx

    Note: Content extraction from these files is restricted, please review them manually.

  • Excel

    Only the Excel part needs to be completed.

  • Excel

    Only the Excel part needs to be completed.

    Attached Files (PDF/DOCX): Lesson 1 Quiz – Introduction and Excel Tutorial.docx

    Note: Content extraction from these files is restricted, please review them manually.

  • excel 2 assign

    Due to a recent change in Yahoo.Finance.com, I decided to download all the stock price data for you. You can find them in the module “.” Note that you will have to find three files: HD, S&P500, and your assigned company data, and combine them into a single worksheet. The data have already been sorted properly.

    You will find your companys ticker symbol in the gradebook (under the “Company” grade item) on CougarView.

    Requirements: complete