Loading...

Course Description

Capture data from various sources and “clean it” for data analysis purposes in Excel. Upon successful completion of this course you will be able to use Microsoft Excel tools to manipulate and cleanse massive volumes of data. Graduates of this course will be able to work with a variety of data sources including .txt, .csv, and Excel sheets, apply merging datasets, and filter, combine, and mash-up data using Power Query Language “M”. Using Excel’s Add-in feature PowerPivot, you will be able to apply your knowledge of working with Pivot Tables. With the skills gained in this course, you will be able to work with large volumes of data beyond the normal limits of Excel, combine data from multiple sources, and use DAX formulas and KPIs. It is recommended that you complete Microsoft Excel Levels 1, 2, and 3 or equivalent prior to enrolling in this course.

Course Information

CCTO 342

Applies Towards the Following Certificates

Loading...

Enroll Now - Select a section to enroll in

Section Title
Data Analysis with Microsoft Power Query and PowerPivot
Type
Discussion
Days
F
Time
6:00PM to 9:30PM
Dates
Dec 11, 2026
Type
Discussion
Days
Sa
Time
8:00AM to 4:00PM
Dates
Dec 12, 2026
Type
Discussion
Days
Su
Time
8:00AM to 11:30AM
Dates
Dec 13, 2026
Schedule and Location
Contact Hours
14.0
Location
Delivery Options
Online w/instructor, set times  
Course Fee(s)
Tuition non-credit $500.00
Drop Request Deadline
Dec 10, 2026
Transfer Request Deadline
Dec 10, 2026
Withdrawal Request Deadline
Dec 11, 2026 to Dec 13, 2026
Section Title
Data Analysis with Microsoft Power Query and PowerPivot
Type
Discussion
Days
F
Time
6:00PM to 9:30PM
Dates
Mar 19, 2027
Type
Discussion
Days
Sa
Time
8:00AM to 4:00PM
Dates
Mar 20, 2027
Type
Discussion
Days
Su
Time
8:00AM to 11:30AM
Dates
Mar 21, 2027
Schedule and Location
Contact Hours
14.0
Location
Delivery Options
Online w/instructor, set times  
Course Fee(s)
Tuition non-credit $500.00
Drop Request Deadline
Mar 18, 2027
Transfer Request Deadline
Mar 18, 2027
Withdrawal Request Deadline
Mar 19, 2027 to Mar 21, 2027
Required fields are indicated by .