Data Management, ...
Follow
Find tag "fascinating"
826 views | +0 today
Your new post is loading...
Your new post is loading...
Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

New emotion Excel charts for Linea

New emotion Excel charts for Linea | Data Management, Data Quality | Scoop.it

La Linea chart illustrations - Have fun!


Via Kris
more...
No comment yet.
Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

Excel Dynamic Data Validation Lists

Excel Dynamic Data Validation Lists | Data Management, Data Quality | Scoop.it
Create a data validation list that is dependent on another list using formulas that dynamically update when the source data changes.

 

Easy-to-use data validation. The formula is complex, but you can easily use the file! :-)

And there is a great trick with ! for advanced users :-)


Via Kris
Oz du Soleil's insight:

Dependent and dynamic dropdown lists in Excel are so valuable in controlling inputs and keeping your source data clean.

more...
No comment yet.