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.
Learn how you can easily search, access, and analyze data within and outside your organization in just a few clicks with Power BI—the business intelligence features that lie inside Microsoft Office.
“Since joining lynda.com, my technical skills and creativity have improved tremendously. Kudos for making learning fun.” —Jim F.
more from our members »