Excel 2016 Spotlight: Advanced Functions
Learn about Advanced Charting, PivotTables, PivotCharts, Slicers, and Analyzing Data with Logical Functions.

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.
- Excel Intermediate Functions
Features
Verifiable
Online
Anytime

1
Guide
21
Video

Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they nee...
Read More