Microsoft Office Development and Consultancy

Excel

Basic

 -

Getting Started

 -

Analysis-ToolPak - VBA

 -

Analysis-ToolPak Features

 -

Correlation

 -

Regression

 -

Sampling

 -

Moving Average

 -

Random Number Generation

 -

Rank

 -

Percentile

 -

Histogram

 -

Covariance

 -

F-Test Two Sample for Variances

 -

Linear and Exponential Regressions

Function Categories

 -

Date and Time - These are used for entering and for calculating dates and times.

 -

Engineering - These are used to manipulate complex numbers and perform conversions.

 -

Financial - These are used to calculate depreciation, annuities, rates of return.

 -

Information - These are used to identify the contents of cells.

 -

Maths and Trigonometry - These are used for scientific calculations.

Advanced

 -

Anova Single Factor

 -

Anova Two Factor with Replication

 -

Anova Two Factor without Replication

 -

Descriptive Statistics

 -

Exponential Smoothing

 -

Fourier Analysis

 -

T-Test Paired Two Sample for Means

 -

T-Test Two Sample equal Variances

 -

T-Test Two Sample unequal Variances

 -

Z-Test Two Sample for Means

 -

Advanced Techniques

 -

Version Changes

 -

Office Online

 -

Knowledge Base

 -

Knowledge Base - Numerical

 -

VBA Code

Related Sections

 -

Add-ins

 -

Data Analysis