2018 - Exploring Excel: Accessing Data from SQL, Databases and Text Files

David shares techniques for working with your data in a variety of ways, such as using worksheet functions to summarize data, querying text files and databases from within Excel, creating self-updating links to databases and other data sources, and more.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Learning Objectives:
List data analysis tricks used to query text files and databases from within Excel.
Apply worksheet functions to summarize data extracted from databases and text files.
Apply the Table feature so that supporting formulas update automatically when database query results change.
Learn to sum values based on a single criterion and on multiple criteria.
Learn how to use Microsoft Query to get data from one workbook into another.
Learn how to duplicate columns, rows, or cells within an Excel worksheet.