Excel Function

Save and switch between different worksheet views with Excel Custom Views. This tutorial explains how to create custom views, preserve print settings, filters, hidden rows, hidden columns, page setup, and reporting layouts for faster workbook navigation. Ideal for Excel users, analysts, finance teams, admin staff, and professionals who need an easy way to manage multiple views of the same workbook.

Control data entry and reduce spreadsheet errors with Excel Data Validation. This tutorial explains how to create dropdown lists, set input rules, restrict values, show input messages, display error alerts, and manage validation settings across worksheets. Ideal for Excel users, analysts, finance teams, admin staff, and professionals who want cleaner data, better controls, and more reliable spreadsheets.

Filter Excel data more powerfully with the Advanced Filter tool. This tutorial explains how to set up criteria ranges, filter records in place, copy results to another location, extract unique values, and apply multiple conditions to large datasets. Ideal for Excel users, analysts, finance teams, admin staff, and professionals who need a faster way to clean, filter, and analyze structured data.

Create quick grouped summaries in Excel using the Subtotal tool from the Data tab. This tutorial explains how to sort data, apply subtotals, group rows automatically, use outline levels, summarize by category, and remove subtotals when needed. Ideal for Excel users, analysts, finance teams, admin staff, and professionals who need an easy way to summarize large datasets without building formulas manually.

Analyze Excel data faster with the Quick Analysis Tool. This tutorial explains how to use Quick Analysis for conditional formatting, charts, totals, tables, sparklines, and quick data insights without building everything manually. Ideal for Excel users, students, analysts, finance teams, and professionals who want a faster way to format, summarize, and visualize data.

Create quick time series forecasts in Excel with the Forecast Sheet feature. This tutorial explains how to select historical data, generate forecast charts, adjust forecast end dates, review confidence intervals, handle seasonality, and interpret future trend projections. Ideal for Excel users, analysts, finance teams, sales teams, and business professionals who want an easy way to forecast future values without complex formulas.

Analyze different business outcomes with Excel Scenario Manager and what-if analysis. This tutorial explains how to create scenarios, change input values, compare results, generate scenario summaries, and test different assumptions in one workbook. Ideal for Excel users, analysts, finance teams, business owners, and students who want an easy way to evaluate best-case, worst-case, and expected-case scenarios.

Exported reports often put a category label in the first row of each group and leave blank cells below for all other rows in that group. This looks tidy in a formatted report but breaks every formula and PivotTable that expects each row to be self-contained. Fill Down fixes it instantly — it replaces every null with the last non-null value above it, propagating the label through all rows in the group. Fill Up does the reverse, pushing a footer label upward through null cells above it. The critical detail most users miss: Fill Down only replaces null, not empty strings. This guide covers the five-step workflow, how to convert empty strings to null before filling, how to prevent Fill Down from bleeding across group boundaries, and six examples including classic category propagation, merged-cell repair, footer label fill-up, multi-column simultaneous fill, and a running balance using List.Accumulate.

Fifty thousand transaction rows need to become a clean summary — total revenue by region, order count by product, average order value by month. Power Query’s Group By builds this in a few clicks and delivers a real flat table you can load anywhere, merge into other queries, or use as a lookup source. Advanced mode lets you add multiple group columns and multiple aggregations simultaneously. The All Rows aggregation type unlocks custom M expressions for patterns the UI doesn’t natively support — distinct customer counts, SUMIF-style conditional sums, and weighted averages. This guide covers both Basic and Advanced mode, six worked examples including regional revenue summaries, multi-metric aggregations, distinct customer counts, conditional aggregation using Table.SelectRows inside a group, and a revenue-weighted average price pattern.