Microsoft Excel® 2016/365: Data Tables & PivotTables Featuring PowerPivot
Open Enrollment Course Dates: 4/2, 11/6, 12/11
Course Length: 1 day
Delivery: Instructor Led/Group Live
Prerequisites/ Advanced Preparation: Excel Intermediate or equivalent knowledge
Course Level: Advanced
Course Fee: $395/single participant (call for group and/or on-site pricing)
Course Hours: 8:30 a.m. – 4:15 p.m.
Recommended CPE: 8 hours
Prerequisites: Working with Excel Data Lists and Tables
Course Level: Intermediate
Description: This course is the combination of two half-day split sessions. The first half is designed for those who have a general aptitude with Excel functionality when it comes to working with data lists and tables. There will be a brief review of the basic concepts of sorting and filtering data along with subtotaling data lists before one-dimensional PivotTables will be developed. This will morph into multi-dimensional PivotTables, using filters and slicers, and creating Pivot Charts.
The second half features and Excel Add-In called PowerPivot which delves deeper into PivotTable usage by expanding such capabilities as advanced calculations, grouping functionality, working with large data sets, and connecting to external data sources.
Highlights: Identification of Excel data lists, simple sorting of data, complex data sorting, filtering data, subtotaling data, converting data lists into data tables, creating PivotTables, reorganizing data pivots, filtering and slicing data, developing Pivot Charts, creating PowerPivot calculations, reports, and distributing PowerPivot data.
Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.
For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22
Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Concerns regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:www.nasbaregistry.org.