Learn to create power data analysis and interactive dashboards in minutes with no coding, using Excel PivotTables
InstructorIan Littlejohn
Free
The curriculum provides dedicated paths for creating functional dashboards in Sales, Finance, and Human Resources domains.
Instruction includes specific methods for trend analysis, contribution analysis, and ranking through date groups and top/bottom rules.
Editorial course preview
These 4 complementary views highlight concrete, legible examples from the course presentation.
This Excel dashboard integrates key metrics, detailed pivot tables, and visual charts to provide a comprehensive overview of sales performance and profit distribution.
This view demonstrates the interactive capabilities of an Excel dashboard by showing a Product Sub-Category slicer actively filtering the displayed data.
The Excel interface displays the Insert Chart dialog box with a line chart preview selected to visualize the trend analysis from the PivotTable.
The image displays the Excel interface with the Create PivotTable dialog open, highlighting the selection of a data range to begin building an interactive dashboard.
Lessons utilize a pattern of article-based instruction paired with video walkthroughs to support active participation.
The focus remains strictly on PivotTable-led dashboarding rather than broader data manipulation or advanced statistical modeling.
The curriculum aligns well with the stated goal of learning dashboard construction via PivotTables.