Excel 2010: Database and Statistical Features

Excel 2010: Database and Statistical Features is designed to give users and understanding of database analysis in Excel. This course will you to give you a firm grasp of Excel's many features designed to analyze data. Productivity in Automation workbooks are designed to help you "learn by doing". After completing the lessons you can continue to use this book as a reference. In this course you will learn to:
Create databases in Excel

Use Excel's Database functions: DSUM(), Dcount(), & more

Create and use PivotTables and PivotCharts

Add hyperlinks to an Excel workbook

Use Excel's Data Analysis ToolPak.