In this 3-course Spotlight bundle by Intellezy Trainers, students will learn focused areas from our Excel 2016 Intermediate course: Advanced Charting, Advanced PivotTables PivotCharts and Slicers, and Analyzing Data with Logical Functions. Our Spotlight courses are meant to educate students on specific course topics. Please note these are shorter courses that do not have any student data resources/files or any assessments required to be taken in order to pass.
Advanced Charting Topic: 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 Topic: 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 Topic: 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.
Like our NEW spotlight content? Check out more of our Spotlight bundles on PowerPoint and Outlook offered by Intellezy Trainers!