Excel Hours

Course 1:

Hidden Mysteries of Data Analysis with

Microsoft Excel

Duration: 12 Hours; Course Fees: Rs. 5000

Who Should Attend

Managers and Executives, who have to manage, analyze and prepare reports using data downloaded from systems. They must have some basic to intermediate knowledge of Excel i.e. navigate around a worksheet, format cells, auto-filter, sorting, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.

Learning Objectives

Upon completion of the course, participants will be able to:

ü Apply useful built-in functions in Excel to process data and enhance the usefulness of the data.
ü Apply the function learnt to consolidate records.
ü Acquire skills to analyze the records for operations and reporting purposes.
ü Employ new ways of tabulating and managing data.

Course Outline

Manage the Usage of Dates & Data’s

MONTH, YEAR, DAY, DATE, COUNTIF, SUBTOTAL, DATEDIF formula, Advanced Auto-Filter Function, Absolute and relative reference

Quick and Accurate Way to Select Records

GOTO function

Building Complex formulas

MID, SEARCH, FIND, SUBSTITUTE, LARGE, SMALL

Merging 2 Lists into One

VLOOKUP, HLOOKUP, SUBTOTAL, REPLACE, MATCH, INDEX, INDIRECT, CHOOSE and more…

Unleashing the Power of Formulas

SUMIF Formula, SUMIFS, SUNPRODUCT, ARRAY, TEXT TO COLUMN Function

Analyzing Business Data in Double Quick Time

PIVOT TABLE function

Tapping the Power of Pivot Chart

Recording Macros to Speed Up Repetitive Tasks

Use Relative References

Course 2: Interactive Excel Dashboard Reporting