Day of the week from date in Excel
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.
Excel Basic
Keep track of rows in a knitting pattern in Excel
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.
Insert MULTIPLE ROWS or COLUMNS in Excel
How to add multiple rows or columns into an Excel spreadsheet
Make columns the same width in Excel
How to make all columns the same width in excel, by selecting a range of columns/rows, and dragging a column/row divider.
Excel IF function
To test IF a value matches a condition, and return one result if TRUE, and another if FALSE.
CELL references and ranges in Excel
Absolute and relative cell references, and ranges in Excel
Insert current DATE and TIME in Excel
How to display today’s date and time in Microsoft Excel
Insert current DATE in Excel
How to display today’s date in Microsoft Excel
COMPARE more than two values in Excel
To compare more than 2 cells to check if they are equal.
=(A1=B1)*AND(B1=C1)