5 Course Excel Bundle: Microsoft Excel, Pivot Tables, Power Pivot Tables, Power Query & Power BI (Excel 2007-2019, O365)
InstructorMyExcelOnline John Michaloudis
Free
Editorial course preview
These 2 complementary views highlight concrete, legible examples from the course presentation.
This screenshot displays the Excel interface with the Edit Default Layout dialog box open, demonstrating how to adjust PivotTable settings like subtotals and report layout.
This Excel interface demonstrates configuring a PivotTable by highlighting the 'SALES PERSON' field in the field list, illustrating how users select data categories for reporting.
The curriculum moves from standard Pivot Table customization to advanced data modeling with Power Pivot, transformation via Power Query, and visualization in Power BI.
Instruction utilizes industry-themed scenarios, such as accounting revenue margins and financial variance reports, to demonstrate tool application.
Lessons are described as clear, concise, and easily digestible, supplemented by helpful shortcut key handouts.
The Power BI content is noted as being too brief for full utilization, and some users found the material insufficiently advanced. These signals were recorded prior to the displayed update; while the update may have addressed this, the label itself does not prove a correction.
Instructional material may rely on older Office versions, which can lead to slight discrepancies in tool locations or naming compared to current Office 365 environments. These observations predated the displayed update; while a more recent update might have resolved these differences, the label does not guarantee it.
The curriculum aligns with the goal of moving from basic to intermediate data management using Excel-based tools.