Description: Description: Description: Description: Description: C:\Users\Joint Director\images\maintopFinal.jpg

 

4

7

 

Business Reporting and Analysis

(Using MS Excel 2010 & 2013)

 

Course Contents:

 

Module 1: Collecting and Organizing Data in Excel

 

Create a Pivot Table, Pivot Table tool Bar, Sort Grouped and Ungrouped Data, Consolidating Data, Using Calculated items and Fields

 

Module 2: Summarizing Data and Designing Custom Reports

 

Microsoft Query, Application of MS Query, MS Query Example, Consolidation of Data Advanced, Performing Magic with Pivot Table Practical Example

 

Module 3: Using MS Access

 

Tables, Relationship, Summarizing Data using Queries, Types of Queries, Using Criteria, Linking Data to Excel Reporter

 

Module 4: Data Manipulation Functions

 

Logical Functions, Lookup Functions Count Functions, Text Functions, Date and Time Functions, Financial Functions

 

Module 5: Using Controls, Filters and Formula Auditing

 

Controls, Databases and Lists, Advance Filters, Database Functions, Formula Auditing

 

Module 6: Introduction to VBA

 

Introduction to VBA, Macros, Absolute and Relative Reference, Designing Custom Function, Excel Add-Ins, Designing and using Add-Ins

Module 7: Security, Formatting, Charts, Essential Functions

 

Security, Conditional Formatting, Using Group and Outline, Advance Charting, Gantt Chart etc.

 

Module 8: User Form and Custom Menu

 

User Forms, Adding Controls to a User Form, Formatting Controls, Introducing Events, Additional ActiveX Controls, Working with List Boxes and Combo Boxes

 

This training is suitable for:

 

  Directors

  Project Managers

  Senior Executives / Coordinators

  Business Executives

  Operations Managers

  IT Managers

  Bankers

  Fresh Graduates

 

Starting From

Timing

Last Date of Registration

Fee

23-05-15

1000 - 1600

(Saturday only)

21-05-15

RS: 10,000/-

 

* 10% discount for groups only

 

Duration   = 03 weeks

 

 

 

Description: Description: Description: Description: Description: C:\Users\Joint Director\images\leftPortion.gif

Home | Site Map | Contact Us | About Us

SKILL DEVELOPMENT COUNCIL
Plot No: 205, Korang Road, I-10/3, Islamabad| +0331-7888991 - 4
Copyright 2008 Skill Development Council