Wizard’s tips by email
Search this site
Topics
- Advice (11)
- Formulae explained (12)
- General (8)
- How to (33)
- Quick tips (18)
- Tools (8)
- Uncategorized (5)
Tags
- ACOS
- ADDRESS
- Chart
- COLUMN
- CONCATENATE
- Conditional format
- COS
- COUNTA
- COUNTIF
- Custom View
- Dates
- Dropdown
- Format
- Formulae
- Frequency
- IF
- INDIRECT
- LARGE
- MAX
- MID
- MOD
- Named ranges
- Navigation
- OFFSET
- Paste Special
- Percentages
- PivotTable
- PivotTables
- PRODUCT
- RADIANS
- RAND
- RANK
- Reference
- Ribbons
- ROUND
- ROUNDDOWN
- Shortcut
- Sorting
- Sudoku
- SUM
- SUMIF
- Syntax
- Text to columns
- Trigonometry
- VLOOKUP
Tag Archives: Dates
1900 was not a leap year, despite what Excel might have you think
If you enter 29 February 1900 into Excel, it will recognise it as a date and format it such. But if you can find a calendar dating back that far, you'll discover that 1900 was not a leap year. This … Continue reading