About this course
DMICMA
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.
This course includes:
schedule1.5 hours on-demand video
signal_cellular_altAdvanced level
task_altNo preparation required
calendar_todayPublished At Jul 30, 2022
workspace_premiumCertificate of completion
errorNo prerequisites
lock1 year access