Grader Instructions Excel 2019 Projects Equipment

Grader Instructionsexcel 2019 Projectmos19 Xl Proj3 Equipmentprojec

Identify and remove duplicate records, create, format, and modify Excel tables, sort and filter data, convert tables to ranges, and ensure worksheet order for a project involving equipment and safety inventory data. Save and submit the final file following specified instructions.

Paper For Above instruction

The Excel project outlined involves creating and formatting tables, managing worksheet data, and ensuring proper data organization to meet specific objectives of an Excel MOS Associate exam practice. The process begins with opening a provided Excel file named Student_MOS19_XL_PROJ3_Equipment.xlsx, saving it under the user's name, and then performing data cleansing by removing duplicates in the Equipment worksheet's Item column.

Next, a new worksheet titled Safety is created by copying the Equipment worksheet. The Safety worksheet mandates formatting a data range (A4:G64) as an Excel table with headers, applying the Teal, Table Style Medium 18, and removing a specific row. The table is further enhanced by applying the First Column Table Style Option and inserting a Total Row. This totals the number of Items and identifies the maximum item cost. To facilitate data analysis, users sort the Item column in ascending order using filter arrows and then sort the Stock Level column based on font color, highlighting items that require reordering at the top of the list. Filtering the table to show only items within the Safety category helps isolate relevant inventory data.

Subsequently, the Safety worksheet's table is converted back to a normal range, and the worksheets are reordered as Equipment, Safety, and Order to meet project specifications. The process concludes with saving the modified file and closing Excel. This type of project emphasizes skills critical for data management, including duplicate removal, table formatting, sorting, filtering, and worksheet organization, which are essential competencies for effective spreadsheet data analysis and reporting in professional settings.

References

  • Chapple, J., & Black, C. (2018). Microsoft Excel 2019 Data Analysis and Business Modeling. Pearson Education.
  • Coulston, T., & Silver, M. (2019). Mastering Excel Formulas and Functions. Wiley.
  • Gaskin, J. (2020). Excel Data Analysis for Dummies. For Dummies.
  • Walkenbach, J. (2019). Excel 2019 Bible. Wiley.
  • Microsoft. (2023). Create and modify tables in Excel. Microsoft Support. https://support.microsoft.com
  • Jelen, B., & Alexander, M. (2019). Excel PivotTables and Power Pivot. Wiley.
  • O'Brien, J. (2020). Advanced Excel Reporting and Analysis. Academic Press.
  • Turban, E., et al. (2017). Information Technology for Management: Digital Strategies for Information Systems. Wiley.
  • Hansen, M., et al. (2018). Data Analysis Using Microsoft Excel: Updated for Office 365. Cengage.
  • Schwarz, S. (2019). Effective Data Management with Excel. Packt Publishing.

Related Assignments