NB: There are Video Tutorials supporting this eBook. Links to video tutorials are inclusive.
Excel 2007: Business Statistics with Cortés Farey shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques. The course covers important statistical terms and definitions, and then dives into techniques using the tools in Excel: formulas and functions for calculating averages and standard deviations, charts and graphs for summarizing data, and the Analysis Toolpak add-in for even greater insights into data. Exercise files are included with the course.
Topics include:
• Understanding statistical terms
• Creating a basic Excel table
• Auditing formulas
• Creating frequency distributions for qualitative data
• Calculating a running total
• Creating a histogram
• Using PivotTables
• Calculating mean, median, mode, and other numerical data
• Using probability distributions
• Population sampling
• Testing hypotheses
• Developing liner and multiple regression models
The skills acquired from this version are mostly applicable to newer versions of Excel.
If you think that Microsoft Excel is only for business purposes, you are wrong. Many use it for various personal needs at home too. Some of the features that you should understand about Microsoft Excel to unlock the potentiality of this application are working with spreadsheets, cell formatting, various menus and toolbars, entering of data and editing the same, navigating between various spreadsheets, formula calculation, inserting various functions like date/time, mathematical functions, using of various charts that are available, inserting, editing and deleting comments on cells, etc.