Date : 24
- 25 August 2012
Last Date of Registration :14 August, 2012
Shift :Morning
Venue :Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.
Registration Fees :Tk. 8000.00/Participant
Get 5% discount by
paying online
Microsoft
Excel 2007 & 2010: Advanced Application Development
Course Description
Microsoft Excel is not just an Office application. It can itself create applications like Accounting Information System, Performance Monitoring Tool, Forecast and Financial Models, Marketing Planner, Recruitment and Selection Tools, and many other business focused applications for practical use. These applications can be either information providing or decision making. Once these applications are developed, they can be used frequently for many months or years. At the end of this course it is expected that the participants will be able to develop advanced Excel applications and gain outstanding productivity at workplace.
Learning Outcomes:
Skills needed to develop excel based application are advanced understanding of excel objects, advanced logical and lookup functions, data validation and dynamic conditional formatting, forms and control toolbox, macros and VBA programming. Considering these skill needs, the course has four major learning outcomes:
(1) Gain advanced knowledge on Excel objects (object-oriented-model);
(2) Use advanced functions and tools in Excel needed for application development;
(3) Understand behavior of all forms and control tools and make them work with VBA programming;
(4) Develop advanced Excel based applications for practical purposes.
The course is of 2 days and span at least 16 Hours. Various instructional methods will be used based on the type of learning outcomes. The training method would completely interactive and participative. The trainees would receive training booklet that are interactively connected with visual tools. An activity-based learning with video materials would be used.
Contents of Training:Microsoft Excel is not just an Office application. It can itself create applications like Accounting Information System, Performance Monitoring Tool, Forecast and Financial Models, Marketing Planner, Recruitment and Selection Tools, and many other business focused applications for practical use. These applications can be either information providing or decision making. Once these applications are developed, they can be used frequently for many months or years. At the end of this course it is expected that the participants will be able to develop advanced Excel applications and gain outstanding productivity at workplace.
Learning Outcomes:
Skills needed to develop excel based application are advanced understanding of excel objects, advanced logical and lookup functions, data validation and dynamic conditional formatting, forms and control toolbox, macros and VBA programming. Considering these skill needs, the course has four major learning outcomes:
(1) Gain advanced knowledge on Excel objects (object-oriented-model);
(2) Use advanced functions and tools in Excel needed for application development;
(3) Understand behavior of all forms and control tools and make them work with VBA programming;
(4) Develop advanced Excel based applications for practical purposes.
The course is of 2 days and span at least 16 Hours. Various instructional methods will be used based on the type of learning outcomes. The training method would completely interactive and participative. The trainees would receive training booklet that are interactively connected with visual tools. An activity-based learning with video materials would be used.
Day One
09:45 AM – 10:15 AM
Reading real life business cases with trainer
Recognize the need of advanced Excel applications
Discussion on content and developing expectation from the course
10:15 AM – 10:30 AM
Tea/Coffee Break + Group Consultation with Trainer
10:30 AM – 11:30 AM
Understand and identify various objects in Excel
Creating Variables: Naming cells, ranges of cells and worksheets
Understand and apply Absolute and Relative Referencing
Create links between worksheets and workbooks
11:30 AM – 1:00 PM
Get introduced to advanced logical functions
Learn how and when to use basic IF and nested IF functions
Learn how and when to use IF with AND logic and IF with OR Logic
Know the use and application of SUMIF, SUMIFS, COUNTIF, COUNTIFS and similar other functions.
1:00 PM – 2:30 PM
Lunch and Prayer Break
2:30 PM – 3:45 PM
Get introduced to advanced tools in Excel
Understand and apply various data validation techniques
Understand and apply formula based conditional formatting
Understand and apply Advanced Filtering
3:45 PM – 4:00 PM
Tea/Coffee Break + Group Consultation with Trainer
4:00 PM – 5:30 PM
Get introduced to advanced lookup and referencing functions
Understand and apply Vlookup and Hlookup Function
Understand and apply Match, Index and Choose Functions
Understand and apply Row and Column Functions
Day Two
10:00 AM – 11:00 AM
Get introduced to Forms and Control Toolbox
Know how to use Drop-down Box, Combo Box, Option Button and Check Boxes
Know how to use ActiveX controls
11:00 AM – 11:15 AM
Tea/Coffee Break + Group Consultation with Trainer
11:15 AM – 12:45 PM
Know how to record macros and assign macros to Buttons and Control Tools;
Interpret macro codes and VBA environment
Get introduced to VBA programming and writing User-Defined-Functions
12:45 PM – 1:45 PM
Lunch and Prayer Break
2:00 PM – 4:30 PM
Fundamentals of Application Interface Development
Develop Practical Applications (any two of the following)
(a) Data Presentation Application (Market/Sales/Finance/Accounting Data)
(b) Financial recording application (Journal to Financial Statements)
(c) Sales performance dashboard and forecast model;
(d) Business Valuation Application;
(e) Investment Project Selection Application.
4:30 PM – 5:00 PM
Consolidation of learning
Questions and Answers
Training Evaluation
Discussion on future learning initiatives
5:00 PM – 5:15 PM
Certificate distribution and participant speech
Closing Speech
Certificates will be
awarded to participants at the end of workshop
REGISTRATION DETAILS
For Registration
or additional information please call us at 9140345,9117179,
01926673096, 01811 410862
or E-mail at
saleehin@bdjobs.com or arafat@bdjobs.com
To confirm your registration, Please pay the registration fee by 14 August, 2012 at Bdjobs.com Office by A/C Payee Cheque or cash.
Bdjobs.com Ltd.
8 th floor (west), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215
or E-mail at
saleehin@bdjobs.com or arafat@bdjobs.com
To confirm your registration, Please pay the registration fee by 14 August, 2012 at Bdjobs.com Office by A/C Payee Cheque or cash.
Bdjobs.com Ltd.
8 th floor (west), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215
Date :24 - 25 August 2012
Last Date of Registration :14 August, 2012 Shift :Morning
Venue :Bdjobs
Training, BDBL Building
(Level 19), 12 Kawran Bazar C/A, Dhaka 1215.
Registration Fees :Tk. 8000.00/Participant
Get 5% discount by paying online
Get 5% discount by paying online
There is no major difference between MS excel 2007 and 2010 only difference is some advanced features are involved in 2010. Advanced application development could be happen in both 2007 and 2010.
ReplyDeletemicrosoft excel training sydney