| List of skills for final project |
| Chapter 5 |
| 5-3Freezing Rows and Columns |
| 5-4Creating an Excel Table |
| 5-4aRenaming an Excel Table |
| 5-4bModifying an Excel Table |
| 5-5Maintaining Data in an Excel Table |
| 5-5aAdding Records |
| 5-5bFinding and Editing Records |
| 5-5cDeleting a Record |
| 5-6Sorting Data |
| 5-6aSorting One Column Using the Sort Buttons |
| 5-6bSorting Multiple Columns Using the Sort Dialog Box |
| 5-6cSorting Using a Custom List |
| 5-8Session 5.2 Visual Overview: Filtering Table Data |
| 5-9Filtering Data |
| 5-9aFiltering Using One Column |
| 5-9bFiltering Using Multiple Columns |
| 5-9cClearing Filters |
| 5-9dSelecting Multiple Filter Items |
| 5-9eCreating Criteria Filters to Specify More Complex Criteria |
| 5-9fCreating a Slicer to Filter Data in an Excel Table |
| 5-10Using the Total Row to Calculate Summary Statistics |
| 5-11Splitting the Worksheet Window into Panes |
| 5-12Inserting Subtotals |
| 5-12aUsing the Subtotal Outline View |
| 5-14Session 5.3 Visual Overview: PivotTable and PivotChart |
| 5-15Analyzing Data with PivotTables |
| 5-16Creating a PivotTable |
| 5-16aAdding Fields to a PivotTable |
| 5-16bChanging the Layout of a PivotTable |
| 5-16cFormatting a PivotTable |
| 5-17Filtering a PivotTable |
| 5-17aAdding a Field to the FILTERS Area |
| 5-17bFiltering PivotTable Fields |
| 5-17cCreating a Slicer to Filter a PivotTable |
| 5-18Refreshing a PivotTable |
| 5-19Creating a Recommended PivotTable |
| 5-20Creating a PivotChart |
| Chapter 7 |
| 7-3Naming Cells and Ranges |
| 7-3aUsing the Name Box to Create Defined Names |
| 7-3bSelecting Cells and Ranges by Their Defined Names |
| 7-3cCreating Defined Names by Selection |
| 7-3dEditing and Deleting Defined Names |
| 7-4Using Defined Names in Formulas |
| 7-4aEntering Formulas with Defined Names |
| 7-4bAdding Defined Names to Existing Formulas |
| Chapter 8 |
| 8-1Session 8.1 Visual Overview: Logical Functions |
| 8-2Working with Logical Functions |
| 8-2aInserting Calculated Columns in an Excel Table |
| 8-2bUsing the IF Function |
| 8-2cUsing the AND Function |
| 8-2dUsing the OR Function |
| 8-3Using Structured References to Create Formulas in Excel Tables |
| 8-5Session 8.2 Visual Overview: Lookup Tables and the IFERROR Function |
| 8-6Creating Nested IFs |
| 8-7Using LOOKUP Functions |
| 8-7aUsing the VLOOKUP Function to Find an Exact Match |
| 8-7bUsing the VLOOKUP Function to Find an Approximate Match |
| 8-7cUsing the HLOOKUP Function to Find an Exact Match |
| 8-8Using the IFERROR Function |
| 8-10Session 8.3 Visual Overview: Conditional Formatting and Functions |
| 8-11Applying Conditional Formatting |
| 8-11aHighlighting Duplicate Values |
| 8-11bUsing the Conditional Formatting Rules Manager |
| 8-12Using Functions to Summarize Data Conditionally |
| 8-12aUsing the COUNTIF Function |
| 8-12bUsing the SUMIF Function |
| 8-12cUsing the AVERAGEIF Function |
mxrie
ListOfSkillsForFinalProject.xlsx
