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: PivotTables
PivotTables: A comprehensive guide (part 2 of 2)
In the last post, we covered the fundamental principles that supported PivotTables, and reached the stage at which the frame of the PivotTable was built. This post will introduce you to the analysis itself. So now, we have the wireframe … Continue reading
PivotTables: A comprehensive guide (part 1 of 2)
If you are anything more than a very basic Excel user, then this post is important to you. It introduces undoubtedly the most powerful single element of Excel: PivotTables. If you're new to them, this is one post I heavily … Continue reading