Laramie County Community College - Laramie Campus

Ready to “power-up” and perform more advanced data modeling and analytical capabilities beyond traditional PivotTables? This 4-hour in-person course offers comprehensive instruction in Excel’s Power Pivot add-in. Conducted in our hands-on computer lab, you’ll gain expertise in Power Pivot’s mighty features for processing, transforming, and summarizing large datasets, including utilizing the Power Pivot Data Model. Key topics include navigating the Power Pivot interface, managing data relationships for dynamic reporting, creating calculated fields, columns, and KPIs, applying CUBE functions to access multidimensional database information, and an introduction to DAX date and time functions for advanced time-based calculations. Upon completion, you’ll be more equipped to efficiently interpret complex data and deliver informative reports that support sound business decisions. Books provided. Prior completion of Excel Levels 1-3 and PivotTables are highly recommended to get the most out of this course, but not mandatory.