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
- ADDRESS
- CLEAN
- CONCATENATE
- Conditional format
- copy
- COUNTIF
- COUNTIFS
- Custom View
- cut
- Data import
- Dollars
- Editing
- EXACT
- Fill
- filter
- Format
- Formulae
- Frequency
- HLOOKUP
- IF
- INDIRECT
- LEFT
- Mail Merge
- MID
- MIN
- MOD
- Navigation
- paste
- Paste Special
- PivotTable
- PivotTables
- RANK
- RIGHT
- ROUNDDOWN
- ROUNDUP
- Series
- Shortcut
- SMALL
- SUM
- SUMIF
- SUMIFS
- Text to columns
- TRIM
- VLOOKUP
- WEEKDAY
Tag Archives: Custom View
Custom Views: a little-known treasure
I stumbled upon Custom Views in Excel by accident a number of years ago, in the pre-ribbon era. I use them very occasionally, but when I do, they offer lots of power and options. Custom Views allow you to have … Continue reading
Risks and issues registers in Excel
There are two big problems with most risks and issues registers: They’re difficult to read They’re difficult to maintain. Let’s start with the readability. Usually, they’re a lifeless grid in a tiny font with lots of columns and, depending on … Continue reading