Module 1 - 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. Intellezy Spotlight courses are designed to offer students instruction on focused areas of interest in lieu of the more comprehensive training available in our complete courses. Module 2 - 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. Module 3 - 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.