Home
Guidelines
Bibliography
Blog
Connexion
Services
About
FAQ
Links
Contact
Home
Excel University
Excel University
Enter Part of Title
Filter
Clear
Display #
5
10
15
20
25
30
50
100
All
Clean up reports with IFERROR
Formula override Conditional Formatting alert
Outline groups
Retrieve values from many workbooks
Slicers as an alternative to conditional drop downs
Table total row
Unique Data Validation drop-down from duplicate table data
VLOOKUP on two or more criteria columns
Search
Search
New
We keep making the same mistakes with spreadsheets, despite bad consequences
The Norwegian sovereign wealth fund's $92mn Excel error
Data clones
Spaces in formulae
Why spreadsheets have errors
Keep formulae simple
Detecting table clones and smells in spreadsheets
Introducing our spreadsheet good practice guidelines
Target audience
Basis for these guidelines
Spreadsheets are not as simple as we think