Excel 2016 Spotlight: 3-Course Bundle


SKU: 2736444 Category: Tags: ,


In this 3-course bundle, students will learn focused areas from our Excel 2016 Intermediate course: Advanced Charting, Advanced PivotTables PivotCharts and Slicers, and Analyzing Data with Logical Functions. Advanced Charting: Students will learn to work with Excel’s advanced charting options including filtering a chart, adjusting the numbering, creating dual axis charts, adding trendlines, and displaying trends with Sparklines.Advanced PivotTables PivotCharts and Slicers: Students will learn to use Excel’s advanced PivotTable and PivotChart features. Students will create a PivotChart, modify and format the PivotChart, add Slicers and Timeline Slicers. Students will add calculated fields and items, apply conditional formatting, and use filters with PivotTables.Analyzing Data with Logical Functions: Students will learn to work with Excel’s most common logical functions including AND, OR, and IF, as well as nesting an AND or OR function inside an IF function.