WARD’s Training on Advance Excel

WARD's Training on

Advance Excel

Date: March 20,2015

Venue: Kings School,Tanin Centre,Asad gate,Mohammad pur.

OUR UNIQUENESS

Time: 9 .30 a.m. to 5.30 p.m. Registration deadline: March 17,2015

We customize the session as the needs of customers We concentrate on the satisfactions of the customers We follow the participatory methods mostly We encourage the criticism

TRAINING OVERVIEW

Microsoft Excel provides a grid interface to organize nearly any type of information. The power of Excel lies in it's flexibility to define the layout and structure of the information you want to manage. Excel is used widely in any financially-related activity. The ability to create new spreadsheets where users can define custom formulas to calculate anything from a simple quarterly forecast to a full corporate annual report makes Excel highly appealing. Excel is also used widely for common information organization and tracking like a list of sales leads, project status reports, contact lists, and invoicing. Finally, Excel is a useful tool for scientific and statistical analysis with large data sets. Excel's statistical formulas and graphing can help researches perform variance analysis, chi-square testing, and chart complex data.

Outcome of the Program:

After participating in the training you will be able to 1. Do some analytical activities through excel 2. Save time for working in excel 3. Use various methods for data analysis in excel 4. Use different formulas, logic for various purposes

Target Participants

Training Methodology:

Persons from any department and

Hands on participation

any level who are using excel

One to one session

Topics to be covered:

Functions (Math and Statistics logical Financial ) Adding all numbers in a range using SUM Function Counting total numbers or texts with COUNT-COUNTA function Finding smallest and largest values with MIN- MAX function Summing data with multi conditions and criteria using SUMIF-SUMIFS Finding statistical Mode and Median Lookup vertically using VLOOKUP,

PivotTable and PivotChart Arranging Pivot Fields in Report Layouts (Row Label, Column Label, Values) Working with Report Filter options Working with Subtotal, Row Total and Grand Total options Working with PivotTable Options Charts and Trend Lines Working with Chart Components (Axis, Categories, Series, Legend) Resizing, Moving and Copying Charts Working with Macros Difference between Macros and VBA Record and run a macro. Understand and edit simple recorded macros Run a macro by using a shortcut key

Resource Personnel:

Mr. Md. Saidul Arefin,

Senior faculty member, Democracywatch in Computer teaching section, Former Faculty Member of Bhuiyan Computers Private Limited

Mr. Md. Saidul Arefin is a senior faculty member in Democracywatch in Computer teaching section since 2007. Previously he worked as a Faculty Member of Bhuiyan Computers Private Limited on full time basis from 1998 to 2007. He used to design lessons, modules and materials and facilitated different training and workshop on different computer applications like: Microsoft Office , Page Maker, Adobe Photoshop , Adobe Illustrator , Quark Express , Visual Basic , Microsoft SQL Server2000 , C, C++ , HTML , Flash5 , Windows 2003 server.

He has experience in Advance excel training for different organizations. He also conducts session on Advance excel as well as other MS Office applications as facilitator in open training session.

Course Fee (Excluding VAT & Tax)

Regular Fees: BDT 3,000 Per person (10 % discount for 3 or more from same organization)

Seat Limit: Maximum 15 [the lab has 15 laptops]

Fees include snacks, and training materials.

Certificate will be awarded

How to apply

For Registration ,

visit ---

Hotline: 01753 88 11 77

Payment Process: A/C Payee cheque in favor of `World Academy for Research & Development' or deposit directly to any branch of DBBL (A/C: 115.110.18888; DBBL) and send us the deposit slip through mail

OR- bKash to 01753 88 11 77

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download