How to get the weekday number and day of the week from a date in Excel. Examples with syntax including how to use the WEEKDAY() and TEXT() functions and errors to watch out for.
A basic worked example of how to create a row by row tick list for a knitting pattern, to keep track of rows and stitch counts. We use simple commands like copy and paste, flash fill, running total, rotate text and print preview to produce our knitting pattern instruction list.
How to add multiple rows or columns into an Excel spreadsheet
To equalise column widths or row heights in Excel, by selecting a range of columns/rows, and dragging a column/row divider.
To test IF a value matches a condition, and return one result if TRUE, and another if FALSE.
Absolute and relative cell references, and ranges in Excel
How to display today’s date and time in Microsoft Excel
How to display today’s date in Microsoft Excel
To compare more than 2 cells to check if they are equal.