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 ExcelUse Excel's Database functions: DSUM(), Dcount(), & moreCreate and use PivotTables and PivotChartsAdd hyperlinks to an Excel workbookUse Excel's Data Analysis ToolPak.