Course Name: Excel: Database Techniques
CPD hours: 2
Type: Online/Video
Price: $120 $108
Description:
For many Excel users, the process of extracting data from text files or from databases, such as Access or SQL Server, can be intimidating. In this comprehensive course, We 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.
We 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. We also provides an Excel workbook that includes most of the examples he uses during the webcast.
Upon completion of this course, the learner will be able to:
- Identify worksheet functions you can use to summarize data extracted from databases and text files.
- Define how to use the SUMIF function and the SUMIFS function.
- Identify the Microsoft Query command that sends data to an Excel worksheet.