Students learn how to use multiple worksheets and workbooks efficiently, and start working with more advanced formatting options including styles, themes and backgrounds. They create outlines and subtotals, create and apply cell names and work with tables. Students save workbooks as Web pages, insert and edit hyperlinks, and share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, students learn to work with PivotTables and PivotCharts.
Fall 2019, Spring 2019, Fall 2018, Spring 2018, Fall 2017