Build Professional Dashboards with No Formulas. Rapid Step by Step Beginner to Advanced. Get & Transform Data with Ease
InstructorJonathan NgInstruction covers using Power Query to automate refreshes and merge data or entire folders of files as an alternative to VLookups.
The curriculum includes driver-based modeling using named ranges alongside specialized visualizations like Sunbursts and 3D Maps.
Editorial course preview
These 3 complementary views highlight concrete, legible examples from the course presentation.
The Excel Power Query Editor window displays a dataset being transformed, showing the Applied Steps panel on the right where operations like filling down values are tracked.
This Excel dashboard features a detailed treemap and a complex sunburst chart to visualize hierarchical data for various government departments.
The Excel 3D Maps interface displays a globe with blue data points plotted over a geographic region, while the right-hand pane shows layer settings for location and height.
Some signals suggest the instruction moves too quickly through Power Query and pivot tutorials, making it difficult to understand the underlying logic.
Learners have noted a lack of provided sample data files and structured quizzes to facilitate hands-on practice.
Selected from the course's public promotional preview. These images document visible presentation material only; they do not represent the complete paid curriculum.
The curriculum aligns with the target audience of dashboard builders, though some learners suggest more transitional modules for neophytes.
Free