This online course will teach you how to utilize the numerous pivot tables to develop useful analysis models and reports within your company. Impress your coworkers by learning how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers. You will discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items. You will learn how to use Excel's Table function to efficiently manage changes to the pivot table's source data in order to avoid making mistakes when data is added or deleted. Software Requirements: The latest version of Google Chrome or Mozilla Firefox. Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Office 2016 (not included in enrollment). The "Starter", "Web App", and "Office Mac Home" versions of Microsoft Excel will not work with the full version of Excel taught in this course. Adobe Acrobat Reader. Software must be installed and fully operational before the course begins. The instructional materials required for this course are included in enrollment and will be available online. 6 Weeks/Online Course/ 24 Course Hours. Offered in partnership with ed2go.

Spring 2023
Noncredit 0.0
Class Fee: $115.00
Status Days Times Location Instructor Books / Materials Ticket # CRN
Open -
Course Location

Online

Instruction occurs exclusively online, through the Canvas learning management system, for the duration of the course. Online courses are delivered in an asynchronous manner, which means that students learn from instruction, such as prerecorded video lessons and assigned learning tasks, that is not delivered in-person or in real-time.

Staff -
232CIS909.920
Meets between: Jan. 18-Feb. 24
Open -
Course Location

Online

Instruction occurs exclusively online, through the Canvas learning management system, for the duration of the course. Online courses are delivered in an asynchronous manner, which means that students learn from instruction, such as prerecorded video lessons and assigned learning tasks, that is not delivered in-person or in real-time.

Staff -
232CIS909.921
Meets between: Feb. 15-March 24
Open -
Course Location

Online

Instruction occurs exclusively online, through the Canvas learning management system, for the duration of the course. Online courses are delivered in an asynchronous manner, which means that students learn from instruction, such as prerecorded video lessons and assigned learning tasks, that is not delivered in-person or in real-time.

Staff -
232CIS909.922
Meets between: March 15-April 21
Open -
Course Location

Online

Instruction occurs exclusively online, through the Canvas learning management system, for the duration of the course. Online courses are delivered in an asynchronous manner, which means that students learn from instruction, such as prerecorded video lessons and assigned learning tasks, that is not delivered in-person or in real-time.

Staff -
232CIS909.923
Meets between: April 12-May 19