Excel 2016: Database and Statistical Features

ISBN-13: 9781544033631 / Angielski / Miękka / 2017 / 108 str.

Dr Luther M. Maddy III

Opis

Excel 2016: 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 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. Perform Regression Analysis Compute Descriptive statistics and regression analysis