Advanced Statistical Methods Using Excel

Course details

Microsoft Excel needs no introduction to anyone using computers. It is generally used to prepare tables that include basic calculating functions. There are very few that know the enormous number of functions, tools and options that Excel has to offer and is seldom recognized as a powerful application for analysis using statistical functions.

Expected BccompUshments

• Create more effective and detailed reports within a short period of time
• Do complex conditional calcJation
• 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

Who Can Benefit

• Accountants
• Supervisors/Officers/Managers
• Anyone using Excel with its basic functions

Related Training

• MS Office Applications

Mode

• Consultant led classes including theory, tutorial exercises and lab practicals.

Prerequisites

• Knowledge of Excel spreadsheet using basic functions such as sum, max, min, average and count, using sort, autofilter, subtotal, etc.