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.