Part 2: Data Analysis with Excel 2007

Part two of the book Excel 2007 with Excel Master is concerned with data analysis. The book takes you through some of the fundamentals of data analysis both with and without Excel 2007. However, the main emphaisis of the chapter is the part that Excel 2007 can play in your data analysis life!

Contents of Part Two of the Book

At the time I am writing this, I have not finished writing the book and so what you are about to read is still subject to change. However, it gives you a good idea of what I am preparring. Here is the content of part two of the book:

 

Data Analysis

 

  • Chapter 4
  • Chapter 5
  • Chapter 6
  • Chapter 7

Looking up data: the LOOKUP functions

  • The VLOOKUP Function
  • The HLOOKUP Function
  • The LOOKUP Function
  • The LOOKUP Wizard

Pivot Tables 2

  • Expense account analysis
  • Double entry bookkeeping
  • Trial balance
  • Final accounts/reports

Ratio and Other Company Analysis

  • Ratio analysis of company information ranging from the simple to the complex
  • Common size statements
  • Growth ratios in ratio analysis
  • Z Score analysis
  • Using the ToolPak Add-In that comes with Excel
  • Descriptive statistics
  • Histograms
  • Correlation analysis
  • Ordinary least squares (regression) analysis
  • There is a database of company data to accompany this chapter and the detail of the chapter will refer to that database throughout.

Statistical Analysis

  • This chapter enhances the work started in chapter 5 above and includes
  • t statistic
  • Standard Error
  • P Value
  • F statistics
  • Confidence intervals
  • Multiple regression analysis
  • The relevant range
  • Chi square test
  • Non parametric tests
  • The Box and Whisker Plot
  • Linear Estimation with =LINEST()
    • The Data
    • The Basic Result
    • Understanding the Result
    • What Happens when Observed t is less that Critical t?
      • =TINV()
  • Using LINEST with Polynomials
  • LINEST and Other Functions
  • LINEST and Multiple Regression
  • The Chi Squared Test
  • More Useful functions for analysis
  • INDIRECT
  • INDEX
  • OFFSET
  • MATCH

 

 

Once the table of contents has been finalised, there will be a PDF Format copy of it available here