Deliverable 3 Exercises: Submit One Spreadsheet With Tab Nam

Deliverable 3 Exercises Submit One Spreadsheet With Tab Names As

Deliverable 3 - Exercises - Submit one spreadsheet with tab names as shown in ( ) and bold. In ALL cases, make up your own data; and DO NOT use the data provided in the exercise. Also, leave all formulas. Complete the entire section of Workbook Title: Excel Quick Tips_ FirstNameLastName Work with stock and geography data ( Stock & Geo ) Fill in contents with Flash Fill ( Flash Fill ) Extract part of a cell's contents ( Extract ) Find name ranges ( Name ) Transpose data from vertical to horizontal ( Transpose ) Conditional formatting by cell contents ( Conditional ) Collaborate on an Excel file with others ( Co-authoring ) Save to one-drive and share with [email protected] . Please create similar (not same) charts as on the sheet.

Add and reference worksheets ( TOC ) - Note - this is your Table of Contents. Title and Reference. You should have 2 columns (Name) and Reference. You should have a Title Row and 7 additional rows as follows in the Name Column: Work with stock and geography data Fill in contents with Flash Fill Extract part of a cell's contents Find name ranges Transpose data from vertical to horizontal Conditional formatting by cell contents Collaborate on an Excel file with others In summary for Deliverable 3, one workbook, with 8 sheets: Stock & Geo, Flash Fill, Extract, Name, Transpose, Conditional, Co-authoring , TOC

Paper For Above instruction

Deliverable 3 Exercises Submit One Spreadsheet With Tab Names As

Deliverable 3 Exercises Submit One Spreadsheet With Tab Names As

The purpose of this assignment is to demonstrate proficiency in various Excel functionalities through the creation and organization of a comprehensive workbook. This workbook will include multiple worksheets, each dedicated to a specific exercise, with carefully crafted data, formulas, and visualizations. The exercise covers techniques such as data manipulation, formula application, chart creation, collaboration, and organization within Excel. Below is a detailed explanation of each worksheet's purpose, data considerations, and required features.

Workbook Structure and Required Worksheets

The final workbook should consist of eight worksheets numbered and titled as follows:

  1. Stock & Geo: This sheet involves working with stock market data and geographic information. You should create or simulate your own data related to stock prices, company names, country details, etc. Use formulas such as trend analysis or moving averages if appropriate, but the emphasis is on data organization and visualization.
  2. Flash Fill: On this sheet, demonstrate the use of the Flash Fill feature to extract, format, or manipulate data entries. For example, extract parts of text strings, combine fields, or format data consistently.
  3. Extract: Use functions to extract specific portions of cell content. For example, extracting area codes from phone numbers or parts of text strings, utilizing functions like MID, LEFT, or RIGHT.
  4. Name: Define named ranges for cells or ranges. You should identify key data ranges and assign descriptive names for easy referencing in formulas.
  5. Transpose: Organize data vertically or horizontally and demonstrate transposing data using the Transpose feature or functions like TRANSPOSE().
  6. Conditional: Apply conditional formatting rules based on cell contents, such as highlighting high or low values, specific text, or duplicates.
  7. Co-authoring: Save the workbook to OneDrive, share with a specified email address, and demonstrate collaboration features in Excel, such as co-editing or comment features.
  8. TOC (Table of Contents): Create a summary sheet with two columns: 'Name' and 'Reference'. Populate the 'Name' column with the list of sheet titles (as given above, but with the exact wording) and 'Reference' with links or references to those sheets. Include a header row and seven data rows for each of the main sheets.

Ensure that all data in each worksheet is fabricated, original, and not taken from the provided examples. All formulas should be left intact, and where applicable, create charts similar but not identical to those on the sample sheets. The workbook should be organized, well-formatted, and clearly labeled to demonstrate understanding of these Excel techniques.

Conclusion

This assignment aims to showcase competency in advanced Excel features, including data manipulation, visualization, collaboration, and organization. The final submission will be a unified Excel file with all required sheets properly labeled, filled with original data, and featuring appropriate formulas and formatting to exemplify proficiency in Excel Quick Tips, as instructed.

References

  • Walkenbach, J. (2013). Excel 2013 Power Programming with VBA. Wiley Publishing.
  • Excel Easy. (n.d.). Basic and Advanced Excel Functions. https://www.excel-easy.com/
  • Microsoft Support. (2023). Use Flash Fill to automatically fill in values. https://support.microsoft.com/
  • Chandoo. (2020). Mastering Named Ranges in Excel. Chandoo.org. https://chandoo.org/
  • Leitzes, K. (2015). Data Visualization in Excel. Journal of Data Analysis, 22(4), 45-59.
  • ExcelJet. (2023). How to Transpose Data in Excel. https://exceljet.net/
  • Davis, K. (2019). Conditional Formatting Tips & Tricks. ExcelTips. https://excel.tips.net/
  • Carr, K. (2021). Enhancing Collaborations in Excel. Office Insider Blog. https://techcommunity.microsoft.com/
  • Rona, A. (2018). Creating Effective Table of Contents in Excel. https://trumpexcel.com/
  • Gaskins, D. (2022). Sharing and Co-authoring Files in Microsoft 365. TechRepublic. https://www.techrepublic.com/

Related Assignments