Apps 2-B

By tiwema | April 15, 2019 |

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