Practice File: Data_Tab_Fundamentals_Practice.xlsx

Create a Sales Data Management Workbook.

Dataset

Students Must Perform

1. Import data.
2. Review Queries & Connections.
3. Sort the dataset.
4. Apply filters.
5. Create an Advanced Filter.
6. Use Text to Columns.
7. Use Flash Fill.
8. Remove duplicate records.
9. Create Data Validation rules.
10. Create drop-down lists.
11. Review/use Consolidate with suitable sample ranges.
12. Create a basic What-If model.
13. Test Goal Seek.
14. Create a simple Data Table.
15. Create scenarios.
16. Create a Forecast Sheet from a separate historical series.
17. Group and Ungroup rows.
18. Apply Subtotal.
19. Refresh connected data where applicable.
20. Prepare the final cleaned report.

Final Output

A professional Data Tab Practice Workbook demonstrating the complete Data Tab workflow.