Import, Export & Convert
CSV to Excel: open it without breaking the numbers
Open a CSV in Excel properly: keep leading zeros, stop dates flipping, handle a file where everything landed in one column, then save as .xlsx.
All tutorials
Pivot Tables & Tables
How to Make a Pivot Table in Excel: summarise 1,000 rows in 30 seconds
How to make a pivot table in Excel step by step: sales by region, count by category, drag fields, refresh when data changes.
Charts
Excel Gantt Chart: build a project timeline from a bar chart
Build an Excel Gantt chart in eight steps from a stacked bar chart: tasks, start dates, durations, and the one trick that hides the first bar.
Excel Basics
Excel for Beginners: the 10 things to learn first
Excel for beginners: cells, typing, the fill handle, your first formula, saving — the ten things to learn on day one, in order, each with a link to its lesson.
Formulas & Functions
IF Function in Excel: one result if true, another if not
The IF function in Excel with one example: pass or fail, then two conditions with AND, and several outcomes with nested IF or IFS.
Macros & VBA
Record a Macro in Excel: automate a task in 2 minutes
Record a macro in Excel with no code: turn the Developer tab on, record a formatting task, replay it with a shortcut, and save the file so the macro survives.
Sorting, Filtering & Lists
Sort in Excel: A to Z, by number, by date, by two columns
Sort in Excel without scrambling your data: one column, two columns (by city then name), by date, and put it back the way it was.
Formulas & Functions
Excel MID Function: pull text from the middle of a cell
The Excel MID function with LEFT and RIGHT: extract characters from the middle, start, or end of a cell — product codes, area codes, years.
Pivot Tables & Tables
Excel Table (Ctrl+T): the feature beginners skip and experts use daily
Turn a range into an Excel Table with Ctrl+T: automatic stripes, filters, formulas that copy themselves, and a total row.
152 tutorials · Page 13 of 17
