Excel

Group and total data into a summary table. Works without Excel; for a live pivot use Insert Pivot Table

Write a chart out as a picture, for an email or a document where the reader will not have the workbook. Needs Windows with Microsoft Excel installed

Add a real Excel chart to a sheet. Needs Windows with Microsoft Excel installed. Put this step last: a later Excel step rewrites the file and drops the chart

Add a live PivotTable with a field list and slicers. Needs Excel installed on Windows. Put this step last: a later Excel step rewrites the file and drops the pivot

Re-point an existing chart at different data, or retitle it, keeping the position, colours and axis scale a reader set by hand. Needs Windows with Microsoft Excel installed

Show every row again and remove the filter

Empty cells in place. Nothing below shifts up, so formulas pointing at those rows still point at them

Copy cells somewhere else, with or without their formatting. Works even when the destination overlaps the source

Hide the rows that do not match, and collect the ones that do

Replace text across a range. Formula cells are left alone, so a replacement cannot quietly break a calculation

Delete repeated rows, keeping the first or the last of each. A number typed as text matches the same number

Sort rows by one column, then optionally a second. Whole rows move and carry their formatting, and blanks sink

Add a rule that keeps highlighting cells as the data changes, rather than colouring the ones that match today

Widen columns to fit their contents. Widths are estimated from the longest value rather than measured, and rows are handed back to Excel to fit when the file opens

Turn a range into a real Excel table with banded rows, filter arrows and a name formulas can use

Set fill, font, borders, alignment, number format and size on a range. Every field is optional and only the ones filled in are changed

Join a range into one cell, or split a merged one back up. Safe to re-run

Import data from a comma-separated values file

Get data from cells or ranges in a spreadsheet

Read the value from a specific cell in an Excel worksheet, or the formula behind it

Open an Excel file that needs a password and read it into a table

Remove specific columns from a sheet

Remove specific rows from a sheet

Add blank columns to a sheet, moving existing columns right

Add blank rows to a sheet, moving existing rows down

Save and close the Excel file

Turn a .csv file into a .xlsx workbook. Quantities become numbers so they will sum, and reference numbers keep their leading zeros

Save the workbook, or one sheet, as a PDF

Run an automated macro inside Excel

Name a range so formulas can say =SUM(Sales) instead of =SUM(Sheet1!$B$2:$B$500), and keep meaning the right cells when rows are inserted

Recalculate the workbook's formulas and save. Use after writing values other formulas rely on

Run every query, connection and PivotTable cache in the workbook again, waiting for the background ones to finish before saving. Needs Windows with Microsoft Excel installed

Write a copy of the workbook in another format, leaving the original as it is. xlsx and csv need nothing installed; pdf, xls, xlsb and macro-preserving xlsm go through Excel on Windows

Add a new blank sheet to the workbook

Remove a sheet from an Excel workbook

Make a copy of an existing sheet

Keep the headings on screen while the rest of the sheet scrolls

Find where the data on a sheet starts and ends. Worked out from cells that hold something, so a cell that was formatted and then emptied does not count

Hide working rows, columns or sheets without deleting them, so the formulas that depend on them still work

Stop a sheet being edited by accident. This is not security: an Excel sheet password is trivially removed, so use it to protect a report from mistakes rather than to keep a secret

Rename a sheet. Later steps naming the old sheet will not find it

Add a row of values to the end of a sheet

Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row

Copy a cell's formula down the column, like dragging the fill handle in Excel

Write a sheet out as a .csv file. Formulas are written as their answers, since a CSV has nowhere to put a formula

Save data to cells or ranges in a spreadsheet

Write a value, or an Excel formula, to a specific cell