Build engaged audiences through publishing by curation.
Sign up with Facebook
Sign up with Twitter
Sign up with Linkedin
I don't have a Facebook, a Twitter or a LinkedIn account
Start a free trial of Scoop.it Business
Microsoft Excel charts and data visualization tools
Check out these unique and interesting Excel charts. And be sure to comment in the visitor's book.
Are you sure you want to delete this scoop?
Excel chart gallery opened. We would be happy if write your comments in the Visitor's book.
How to use Advanced Filters in Excel. Find exact text using Advanced Filters with formula criteria.
Formulas in criteria - Great!
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 :-)
Dependent and dynamic dropdown lists in Excel are so valuable in controlling inputs and keeping your source data clean.