
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 28-lesson course built from Chandoo's 3h 57m of YouTube video. 3 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 Chandoo on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Navigate the Excel interface, select data efficiently with shortcuts, and apply filters and sorts to explore datasets.
Use conditional formatting to highlight duplicate values, filter by color to isolate them, and clear rules to reset formatting.
Apply number and date filters (top/bottom, between dates), sort by multiple columns, and clear filters using Alt-key shortcuts.
Connect to a Wikipedia table via Power Query, promote headers, replace characters, fill down nulls, change data types, and calculate percentages.
Remove total rows via filtering, rename queries for clarity, load data to Excel as a Table, and refresh the connection dynamically.
Import data from a local Excel workbook, manage multiple queries, and promote the first row to headers manually.
Assess column quality, trim leading/trailing spaces, replace nulls with 'Missing', and edit or delete applied steps.
Convert text to numbers/dates, add Conditional Columns for Salary Buckets and Employee Type (Full/Part-time), and calculate tenure in years.
Split name columns (first/last), handle middle names via right-side split, use Custom Columns (M code), and Close & Load to Excel.
Build a department summary report using COUNTIFS, SUMIFS, and AVERAGEIFS with structured table references.
Extract dynamic subsets with FILTER, limit columns with CHOOSECOLS, get Top N with SORT/TAKE/LARGE, and link inputs to spill ranges.
Combine multiple criteria in FILTER (gender + salary), filter by month/year using MONTH/DATE functions, and select specific output columns.
Calculate conditional Min/Max by gender, retrieve Top/Bottom N values with LARGE/SMALL, and validate against filtered source data.
Generate unique department lists with UNIQUE, sort spill ranges with SORT, calculate variance from average, and visualize with Data Bars.
Convert data to Excel Table, create Pivot Tables on new sheets, drag fields to Rows/Values, and change aggregation from Sum to Average.
Format pivot table, apply Top 10 Value Filters, insert Slicers for interactive filtering, and connect Slicers to multiple Pivot Tables.
Group dates by Month/Year, show Running Totals, add Fiscal Year column via Power Query/Formula, and build FY Running Total charts.
Add Day-of-Week column, build matrix of Rep vs Day, use % of Row Total and Conditional Formatting Color Scales to identify peak workload days.
Create Duration Buckets and Rounded Rating columns with IFS/ROUND, build Pivot matrix, custom-sort buckets, and apply Color Scales to find satisfaction patterns.
Analyze monthly call volume per Rep, apply Data Bars to spot overload months (e.g. March/April), and derive hiring recommendations.
Load Call Center data to Data Model, create DAX Measures (Call Count, Avg Rating, Total Amount, 5-Star Count), and build base Pivot Tables.
Build Monthly Trend chart with overlapping Area + Line series, format gradients/markers, hide field buttons, and link to Slicer.
Create Day-of-Week distribution chart, fix category order (Sun-Sat) via Reverse Categories, format Gap Width/Data Labels, and layer behind trend chart.
Use a disconnected Pivot to detect selected Rep via XLOOKUP, add 'Selected' series to charts, and apply 100% Overlap + Gradient fill for dynamic highlighting.
Fetch Rep Name/Image via XLOOKUP from Assets sheet, build dynamic detail panel (Call %, Rank, Amount) with TEXT formatting and IF logic for multi-select safety.
Merge cells for layout, add Title, test interactivity, and use Data > Refresh All to update dashboard with new data dynamically.