Chapter 5 - Projects 5A and 5B

Managing Large Workbooks and Using Advanced Sorting and Filtering

Project 5A

Outcomes

Manage and format large workbooks and save workbooks to share with others.

Objectives

• Navigate and Manage Large Worksheets
• Enhance Worksheets with Themes and Styles
• Format a Worksheet to Share with Others
• Save Excel Data in Other File Formats

Project 5B

Outcomes

Analyze information in a database format using advanced sort, filter, subtotaling, and outlining.

Objectives

• Use Advanced Sort Techniques
• Use Custom and Advanced Filters
• Subtotal, Outline, and Group a List of Data

Assignment

• Complete Project 5A on pages 316 thru 337
  • Submit only three Project 5A files: Class Schedule workbook, Schedule_PDF, and Schedule_CSV 
• Complete Project 5B on pages 338 thru 354
  • Submit the Project 5B Fall Sections workbook

How do I submit my assignment files?