Adavanced Statistical Methods using MS Excel

COURSE OVERVIEW

Anyone using a computer doesn’t require an introduction to Microsoft Excel. Generally speaking, it is used to create tables with simple calculation functions. Excel is a very powerful application for statistical function analysis, but very few people are aware of its vast array of features, tools, and possibilities.

COURSE PREREQUISITES

Knowledge of Excel spreadsheets using basic functions such as sum, max, min, average and count, using sort, auto filter, subtotal, etc.

EXPECTED ACCOMPLISHMENTS

Create more effective and detailed reports within a short period

Do the complex conditional calculation

Handle text, date and numeric data

Check and resolve the errors

Create simple macros by recording

COURSE OUTLINE

Understanding the Excel 2007 screen

Conditional Functions

Lookup Functions

Conditional Formatting

Working with Pivot table

Protection

Functions

Cell Restriction

Auditing

What-if Analysis

Macros