Shelly Cashman Excel 2019 Module 6:Textbook Project Preston Sayyah 1

Shelly Cashman Excel 2019 Module 6:Textbook Project

Preston Sayyah

1.Non-graded - Project: Rating Bank Account Managers

2. Creating a Table

To Format a Range as a Table

To Enter New Rows and Records into a Table

To Center Across a Selection

3. Using a Lookup Table

To Create a Table Array Area

To Use the VLOOKUP Function

4. Adding Calculated Fields to the Table

5. Conditional Formatting

To Add a Conditional Formatting Rule with an Icon Set

6. Working with Tables in Excel

7. Sorting a Table

8. Querying a Table Using AutoFilter

9. Using Criteria and Extract Ranges

To Create a Criteria Range

To Query Using a Criteria Range

10. Using Database Functions

To Use the DAVERAGE and DCOUNT Database Functions

11. Using the Sumif, Countif, Match, and Index Functions

To Use the SUMIF Function

To Use the COUNTIF Functions

12. Non-graded - Summarizing Data

13. Treemap Charts

To Create a Treemap

To Move the Chart and Edit Fonts

To Edit Treemap Settings