New Perspectives Excel 2019 Module 7: Textbook Project Nick Venditti 1

New Perspectives Excel 2019 Module 7: Textbook Project

Nick Venditti

1. Use Lookup Functions

To calculate the total engagements per post

To calculate the engagement rate per post

To create the vertical lookup table of engagement levels

To apply the VLOOKUP function with an approximate match

2. Exploring Logical Functions

To nest the OR function in an IF function to display the product's profitability

3. Applying Summary IF Functions

To do conditional counting with the COUNTIF function

To calculate a conditional sum with the SUMIF function

To calculate a conditional average with the AVERAGEIF function

4. Creating PivotTables

To create a PivotTable from the Media table

5.  Formatting a PivotTable

To create a PivotTable that summarizes social media engagement

To create a PivotTable counting the number of social media posts

To create a PivotTable of average engagement rates

To create a PivotTable of engagement level vs. media site

To rearrange the Engagement Level categories

6. Setting PivotTable Options

To set the PivotTable options

7. Setting the PivotTable Design

To apply a design style to a PivotTable

To complete the designs of the remaining PivotTables

8. Introducing PivotCharts

To change the chart type

To name and move the PivotChart

To create the pie PivotChart showing the breakdown of user engagements

To create a PivotChart of the engagement rate per month

To place the line chart in the Dashboard worksheet

9. Using Slicers and PivotTables

To add a slicer for the Topic field to the Engagement Pivot PivotTable

To create the Date timeline slicer

10. Drilling Down a PivotTable