Perfect for the classroom or self-paced, this step-by-step course is designed to give users and understanding of database analysis in Excel 2016 for Windows. This workbook will provide a firm grasp of Excel's many features designed to analyze data. This and the other workbooks in this series are designed for "learning by doing." After completing the lessons you can continue to use this book as a reference. This course covers: Creating databases in ExcelUsing Excel's Database functions: DSUM(), Dcount(), & moreCreating and using PivotTables and PivotChartsAdding hyperlinks to an Excel workbookUsing Excel's Data Analysis ToolPak.Regression AnalysisDescriptive statistics