Jessica Mankus
The five-week Microsoft® Excel Advanced Reporting and Analytics course consists of 15 contact hours of hands-on instruction by a certified Microsoft® Excel Expert.
Participants acquire the following key competencies during this five-week program:
• Creating interactive dashboard reports and data visualizations
• Building and formatting Power Pivot data modeling including Power PivotCharts and Power PivotTables
• Understanding and implementing Basic Data Expressions Analysis (DAX) Functions
• Use Get & Transform
• Creating individual KPI Power PivotCharts.
To complete the Excel Advanced Reporting and Analytics course, each participant must:
• Complete dataset exercises.
• Complete knowledge checks throughout the course.
• Demonstrate proficiency in course concepts.
• Complete the required coursework at a satisfactory level to earn a passing grade.
This badge was issued to participants upon successful completion of the program during the Spring 2023-Spring 2024 semesters.
Skills / Knowledge
- Power View
- Power Pivot
- Advanced Power PivotTable
- DAX formulas
- Get & Transform
- Query
- Advanced Power PivotCharts
- Dashboard
- KPI Icons