Excel 2019: Database and Statistical Features

Perfect for classroom or DIY training, Excel 2019: Database and Statistical Features is designed to give users and understanding of database analysis in Excel for Windows. 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.Perform Regression AnalysisCompute Descriptive statistics