Charts
How to Create a Chart in Excel: the 5-step method for any chart
How to create a chart in Excel: arrange the data, select it, pick the chart type that fits, then title, label and tidy — the same five steps for every chart.
Learn Excel the easy way.
Short, plain-English tutorials on formulas, shortcuts, charts and everyday Excel tasks. No jargon. One idea per post.
Start here Get Daily One LessonLatest tutorials
Charts
Excel Bar Chart: make one, sort the bars, and label them
Make an Excel bar chart in four steps, put the biggest bar on top, add data labels, change the colour of one bar, and choose bar vs column.
Dates & Times
Excel Date Format: change how dates look, and fix dates that won’t change
Change the date format in Excel — dd/mm/yyyy, 29 Sep 2026, day names — with Ctrl+1 and custom codes, and fix dates that refuse to change because they are text.
Formatting
Excel Freeze Top Row: lock the header row while you scroll
Freeze the top row in Excel with View › Freeze Panes › Freeze Top Row. Freeze two rows or a column too, unfreeze, and the difference between freezing and locking for editing.
Formulas & Functions
How to Count Cells with Text in Excel (any text, or specific text)
Count cells that contain any text in Excel with COUNTIF and a wildcard, count cells with specific text, and count non-empty cells including numbers.
Dates & Times
How to Make a Calendar in Excel (monthly, with formulas)
Make a monthly calendar in Excel that rebuilds itself when you change the month: one date cell, one formula, conditional formatting for today.
Pivot Tables & Tables
How to Make a Table in Excel: from a blank sheet to a proper table
How to make a table in Excel from scratch: type the headings, enter data, press Ctrl+T, then sort, filter, total and style it.
Data Cleaning
Convert Text to Number in Excel: 4 ways, fastest first
Convert text to numbers in Excel: the green-triangle button, Paste Special multiply, VALUE, and Text to Columns — and how to tell text from numbers.
Print, Share & Protect
How to Print Labels from Excel (with Word mail merge)
Print address labels from an Excel list using Word's mail merge: set up the sheet, pick the label size, map the columns, preview and print.
Showing 199–207 of 294 tutorials · Page 23 of 33
