Learn how to use the data validation tools in Excel 2016 to control how users input data into workbooks and ensure data is entered consistently and accurately.
Learn easy-to-use commands, features, and functions for managing and analyzing large amounts of data in Excel 2016.
Learn how to quickly feed real-time data from an API directly into Excel using WEBSERVICE and FILTERXML functions, enabling powerful insights and real-time analytics.
“lynda.com has made it possible and affordable to retool and get back to work after raising my kids. I can't imagine working without this resource now.” —Maureen C.
more from our members »