
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 22-lesson course built from Satish Dhawale's 3h 34m of YouTube video. 2 days at 90 minutes a day, with study notes and a quiz in every lesson. A 2-minute placement test skips what you already know.
Taught by Satish Dhawale on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Learn data preparation rules (no merged columns, unique headers) and insert a Pivot Table using the Insert tab or keyboard shortcuts.
Create a 2-dimensional report by dragging Country to Rows, Sales to Values, and Region to Columns; use expand/collapse buttons for drill-down.
Add Slicers for interactive filtering (Country, Region), configure multi-select, resize, hide headers, sort items, and hide items with no data.
Connect a single Slicer to multiple Pivot Tables via Report Connections and customize Slicer styles, button sizes, and caption settings.
Insert a Timeline for date filtering, configure header/selection bar visibility, scrollbar, and link it to multiple Pivot Tables.
Group Order Date automatically into Months/Quarters/Years, switch grouping levels, create custom 7-day groups, and ungroup via right-click.
Switch to Classic Layout for separate group columns, enable 'Show Details' to drill through to source records on double-click.
Configure Grand Totals, Repeat Row Labels on printed pages, Print Titles, disable Expand/Collapse buttons, Save Source Data, Enable Show Details, Number of items to retain per field, and Alt Text for documentation.
Change value display to percentages (% of Grand Total, Column Total, Row Total, Parent Row/Column Total) via Value Field Settings.
Apply Difference From (base item), % Difference, Running Total, and Rank (Smallest to Largest/Largest to Smallest) calculations.
Create a Calculated Field named 'Incentive' using formula =Sales*1% without modifying source data.
Build a Calculated Field with nested IF: 2% incentive if Sales>50000 else 1%, using formula =IF(Sales>50000, Sales*2%, Sales*1%).
Create a Calculated Item for Debit percentage using formula =IF(Debit=0,0,Debit/(Debit+Credit)) and format as percentage.
Define a Dynamic Named Range with OFFSET(COUNTA, COUNTA) to auto-expand Pivot Table source data; refresh adds new rows/columns automatically.
Combine Jan/Feb sheets into one Pivot Table via Data > From Table > Power Query Editor > Append Queries > Close & Load to Pivot Table.
Use GETPIVOTDATA with dynamic dropdowns (Brand, Month) and OFFSET/MATCH/INDEX logic to pull specific Pivot Table values into a dashboard.
Write a Worksheet_Change event macro (ActiveWorkbook.RefreshAll) to auto-refresh all Pivot Tables when source data changes; save as .xlsm.
Build a dashboard: insert Pivot Table/Chart, add Spin Button shapes, record macros to toggle Chart visibility (Visible=True/False), assign macros to buttons.
Add Top 10/5 Value Filter, record macro to change filter count (Top 2,3,4,5), assign to Spin Button; duplicate chart toggle logic for multiple charts.
Review all 13 chapters covered, save macro-enabled file, and explore advanced Excel courses for certification and automation mastery.
Review all 13 chapters covered, save macro-enabled file, and explore advanced Excel courses for certification and automation mastery.
Review all 13 chapters covered, save macro-enabled file, and explore advanced Excel courses for certification and automation mastery.