Apps 2-B

Day #1 – Excel Project #6 – Creating, Sorting, and Querying a Table

Create and Format a Table
Use Lookup Tables in the worksheet
Insert Calculated Fields using structured references
Apply Conditional Formatting and icon sets
Sort Tables
Query a Table
Extract records with criteria ranges
Use Database functions and Conditional Functions
Display automatic subtotals, outline and treemap chart

Chapter Directions – Coffee Craft Daily Services
Lab #1 – City Market Complete