Excel Dexterity - Database Techniques
CPE 2 | Computer Software & Applications | Self-Study

$49.00 each

Course ID: CPE Credits Field Of Study Author or Speaker:
DR-618.19  2 Credits   Computer Software and Applications  David Ringstrom 
Instructional Method: Advanced Preparation: Program Prerequisites: Experience Level:
 Interactive Self Study  None   Experience with Databases   Intermediate


Excel Dexterity: Database Techniques
Presented by David Ringstrom, CPA

The process of culling data from text files or from databases, such as Access or SQL Server, can be intimidating to Excel users. In this comprehensive course, Excel expert David Ringstrom, CPA, shows you how to get the data you need into Excel where you then can work with it a variety of ways, including 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 your attention to 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.