Excel dependent dropdown lists: INDIRECT, Tables, or FILTER
Build a dependent dropdown in Excel three ways: INDIRECT named ranges, Excel Tables, or the Excel 365 FILTER function. See which one fits your data.
Build a dependent dropdown in Excel three ways: INDIRECT named ranges, Excel Tables, or the Excel 365 FILTER function. See which one fits your data.
Excel Power Query for beginners — load messy data, clean it with a few clicks, unpivot a cross-tab into tidy rows, and Refresh All to replay every step next month.
Excel VBA for beginners, the practical way — record a macro, read the code Excel wrote, wire it to a button, and write your first loop to automate repetitive tasks.
Seven pivot table reports every analyst builds in Excel — summary, cross-tab, % of total, top-N, trend, count, and drill-down — each as a quick field-drag recipe.
XLOOKUP in Excel in one formula: look up values left or right, replace #N/A with if_not_found, search in reverse, and match with wildcards.
The Excel keyboard shortcuts worth memorizing — navigation, selection, formatting, and formulas — grouped by job, with a one-week plan to make them stick.
SUMIFS vs COUNTIFS in Excel: SUMIFS totals values that match conditions, COUNTIFS counts matching rows. Syntax, multi-criteria, dates, and wildcards.
Learn why Excel INDEX MATCH is more flexible and reliable than VLOOKUP, with clear examples and step-by-step instructions for real spreadsheets.
Excel pivot tables from first summary to advanced: build with drag-and-drop fields, group by date, filter with slicers, and add calculated fields.