Date : Fri, 20 Oct 2017 - Wed, 20 Dec 2017 Last Date of Registration : Sun, 15 Oct 2017
No. of Classes/ Sessions : 16 Total Hours : 32
Duration : 2 Month Time : 6.00 pm - 8.00pm
Category : Personal development
Resource Person
Md. Sowkat Hasan

View Profile
Associate Resource Person

Training Details

Start Date: Fri, 20 Oct 2017
Last Date of Registration: Sun, 15 Oct 2017
Training Fee: 2400.00
Vanue: 225 A. K. Tower (1st Floor), SK Mujib Road, Chowmohuni, Chittagong, Bangladesh


Who Can Attend?

Operational and management level professionals in services and manufacturing business and non-profit organizations. University students.Fresher.Any other interested person can also join this workshop. Prerequisites - Basic operational skills in excel and should be a regular Excel user.

Methodology

Linear Demonstration - 50%, Case and Practice Exercise - 50% Assessment: They'll be a standard test that will assess the skills developed in the participants in the following areas: Data Entry & Validation Techniques (20%) Excel Functions and Formulas (20%) Advanced Tools (20%) Analysis and Reporting (20%) Risk Assessment and Management Tools (20%)

ADVANCED EXCELL SKILLS FOR BUSINESS EXECUTIVES!!: (Course Under Scholarship Project. For Chittagong)
Objective of this Training

Microsoft Excel is a great tool for operation, management and even in strategic level of a business organization. Effective utilization of the spreadsheet application brings productivity at workplace and accelerates growth in career.

This course is specially offered for the graduating students of Daffodil International University but the course is designed in a way so that everyone inside a workplace can be benefited. The course starts from very basic level and concludes at an advance intermediate stage of Microsoft Excel 2007


Training Overview & Outline

Key Topics (The major contents of the sessions)

Session 1 (Introduction to Microsoft Excel)
In this session participants will know the essential utilities and necessities of Microsoft Excel. Most of us know the basics of Excel. However, there’re few basics that are unknown to many of us. Knowledge of these unknown basics would change your idea about the power of Excel. This session intends provide the participants about these basics that will build a foundation of the advance Excel skill at later part of the course.

Understanding of Excel Objects:

  • Entering and Editing Data into Cells;
  • Naming cells and ranges of cells;
  • Copy and Paste;
  • Paste Special;*
  • Data Type* & Alignment;
  • Fill Color and Borders;
  • Hiding Cells Data and Grid;
  • About Worksheets;
  • Naming, Adding, & Deleting Worksheets;
  • Changing Worksheet Tab Color;
  • Linking and Referencing inside and across worksheets;
  • Relative and Absolute Referencing;
  • Linking Across Different Files;

Building Blocks of Excel – Rows & Columns:

  • Row Height & Column Width;
  • Hiding and Unhiding Rows and Columns;
  • Inserting and Deleting Rows and Columns;
  • Insert Copied Cells;
  • Rows and Column functions.

Understanding Functions and Formula in Excel :

  • Difference between Functions and Formulas;
  • Writing Functions and Formulas;
  • Operators for Writing Formulas;
  • Types of Functions in Excel*;
  • Copying Formulas and Functions;

Session 2(Advance Excel Options and Customization) :

Knowing different customization options in Excel can put you in charge of you spreadsheet model. It can save your time and improve your quality of work significantly. This session will provide an extensive idea of all different tools in Excel and all different customization options in Excel.

  • Toolbars and Add-ins in Excel
  • Standard Toolbar;
  • Formatting Toolbar;
  • Borders and Chart Toolbar;
  • Control Toolbox and Forms; Drawing Toolbar;
  • Customization Options in Excel
  • View Options;
  • Calculation Options;
  • Edit Options;
  • General Options;
  • Spelling Options;
  • Save Options;
  • Security Options;
  • Useful Data Entry Tips
  • Simplifying data entry by using a form*;
  • Forcing text to appear on a new line within a cell;
  • Using Ctrl+Enter to Place information into multiple cell simultaneously;
  • Entering the current date or time into a cell.

Session 3(Advance Skills on Excel Functions – i) :

Functions are the sources of popularity of Microsoft Excel. Excel provides different types of formula for different types of people at different profession. However there’re few categories of functions essential for all groups of people. Efficient usage of these functions can change your productivity, revolutionize your career and make you successful at work. This session and next session are intended to provide the world best knowledge on Excel functions.

Logical Functions in Excel

  • If and nested if functions.
  • And & Or logics;Using If and nested If with And & Or
  • Practical exercises and business case
  • Statistical Functions
  • Summing and Averaging
  • Median and Mode
  • Counting numbers, texts and blanks
  • Practical Exercises and business cases
  • Combined Functions
  • Sumif and Sumifs
  • Countif and Countifs

Session 4 (Advance Skills on Excel Functions – II) :
This session is a continuation of the last session.

  • Lookup Functions
  • Lookup function
  • Vertical Lookup Function
  • Horizontal Lookup Functions
  • Working with Dates
  • Special case of dates in Excel
  • Date functions & shortcuts
  • Arithmetic operations on dates
  • Working with Texts
  • Different Text functions
  • Concatenation operation on text

Session 5 (Advance Database Utilities in Excel) :
Relational databases are the building blocks of today’s IT success. Microsoft Access is one of the common RDBMS used in office environment. However some people found the secret of Excel that provides most of the utilities of a simple RDBMS. This session will bring your confidence on Microsoft Excel and after this session you’ll forgot about your need of learning Microsoft Access or any other RDBMS.

  • Data Validation Techniques
  • Data sorting
  • General Filtering
  • Advanced Filtering
  • Subtotal
  • Pivot Table
  • Indexing and Hyperlinking

Session 6 (Optimization and Risk Management Tools in Excel) :
For a strategic decision maker its essential to know the solution that maximizes his return, optimizes his cost and minimize losses. For investment appraisal problems, its essential to different risks of an investment. This section will give participant an excellent idea of optimization and risk management using excel.

  • Goal Seek for seeking target values
  • Simulation for Reaching Optimum Solution
  • Sensitivity Analysis
  • Advance Conditional Formatting
  • Question and answer
Registration
Application Log
Timestamp Level Category Message
04:51:05.491238 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
04:51:05.491393 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
04:51:05.491492 trace system.CModule
Loading "urlManager" application component
in /var/www/html/careerbd/protected/components/HttpRequest.php (11)
in /var/www/html/careerbd/index.php (15)
04:51:05.491849 trace system.web.filters.CFilterChain
Running filter JbTrainingController.filteraccessControl()
in /var/www/html/careerbd/index.php (15)
04:51:05.491897 trace system.CModule
Loading "user" application component
in /var/www/html/careerbd/index.php (15)
04:51:05.491940 trace system.CModule
Loading "session" application component
in /var/www/html/careerbd/index.php (15)
04:51:05.492023 trace system.CModule
Loading "db" application component
in /var/www/html/careerbd/index.php (15)
04:51:05.492084 trace system.db.CDbConnection
Opening DB connection
in /var/www/html/careerbd/index.php (15)
04:51:05.492590 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1537656665
in /var/www/html/careerbd/index.php (15)
04:51:05.492901 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1537656665,
:id='grd7gh9fdhsg2eocvs7i407oo0'
in /var/www/html/careerbd/index.php (15)
04:51:05.493148 trace system.base.CModule
Loading "userman" module
in /var/www/html/careerbd/protected/components/Controller.php (325)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(48)
in /var/www/html/careerbd/index.php (15)
04:51:05.493263 trace system.CModule
Loading "assetManager" application component
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (28)
in /var/www/html/careerbd/protected/components/Controller.php (325)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(48)
04:51:05.493359 trace system.CModule
Loading "clientScript" application component
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (30)
in /var/www/html/careerbd/protected/components/Controller.php (325)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(48)
04:51:05.493571 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `userman_actions`
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (57)
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (67)
in /var/www/html/careerbd/protected/components/Controller.php (327)
04:51:05.494179 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `userman_actions`
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (57)
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (67)
in /var/www/html/careerbd/protected/components/Controller.php (327)
04:51:05.494332 trace system.db.ar.CActiveRecord
UsermanActions.find()
in
/var/www/html/careerbd/protected/modules/userman/models/UsermanActions.php
(125)
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (58)
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (67)
04:51:05.494438 trace system.db.CDbCommand
Querying SQL: SELECT id FROM `userman_actions` `t` WHERE
ucontroller=:ucontroller and uaction=:uaction LIMIT 1. Bound with
:ucontroller='jbTraining', :uaction='view'
in
/var/www/html/careerbd/protected/modules/userman/models/UsermanActions.php
(125)
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (58)
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (67)
04:51:05.494719 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `userman_usertypes`
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (69)
in /var/www/html/careerbd/protected/components/Controller.php (327)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(48)
04:51:05.495146 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `userman_usertypes`
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (69)
in /var/www/html/careerbd/protected/components/Controller.php (327)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(48)
04:51:05.495264 trace system.db.ar.CActiveRecord
UsermanUsertypes.find()
in
/var/www/html/careerbd/protected/modules/userman/models/UsermanUsertypes.php
(149)
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (70)
in /var/www/html/careerbd/protected/components/Controller.php (327)
04:51:05.495311 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `userman_usertypes` `t` WHERE
group_name=:group_name LIMIT 1. Bound with :group_name='guest'
in
/var/www/html/careerbd/protected/modules/userman/models/UsermanUsertypes.php
(149)
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (70)
in /var/www/html/careerbd/protected/components/Controller.php (327)
04:51:05.495600 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `userman_permissions`
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (80)
in /var/www/html/careerbd/protected/components/Controller.php (327)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(48)
04:51:05.495919 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `userman_permissions`
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (80)
in /var/www/html/careerbd/protected/components/Controller.php (327)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(48)
04:51:05.496072 trace system.db.ar.CActiveRecord
UsermanPermissions.find()
in
/var/www/html/careerbd/protected/modules/userman/models/UsermanPermissions.php
(104)
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (81)
in /var/www/html/careerbd/protected/components/Controller.php (327)
04:51:05.496121 trace system.db.CDbCommand
Querying SQL: SELECT id FROM `userman_permissions` `t` WHERE
usertype_id=:usertype_id and action_id=:action_id LIMIT 1. Bound with
:usertype_id='2', :action_id='1018'
in
/var/www/html/careerbd/protected/modules/userman/models/UsermanPermissions.php
(104)
in /var/www/html/careerbd/protected/modules/userman/UsermanModule.php (81)
in /var/www/html/careerbd/protected/components/Controller.php (327)
04:51:05.496409 trace system.db.ar.CActiveRecord
JbTraining.findByPk()
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(57)
in /var/www/html/careerbd/index.php (15)
04:51:05.496448 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_training`
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(57)
in /var/www/html/careerbd/index.php (15)
04:51:05.497065 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_training`
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(57)
in /var/www/html/careerbd/index.php (15)
04:51:05.497236 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_training` `t` WHERE `t`.`id`=85 LIMIT 1
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(57)
in /var/www/html/careerbd/index.php (15)
04:51:05.497591 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_training_registration`
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(67)
in /var/www/html/careerbd/index.php (15)
04:51:05.497956 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_training_registration`
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(67)
in /var/www/html/careerbd/index.php (15)
04:51:05.498080 trace system.db.ar.CActiveRecord
JbTraining.findByPk()
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(452)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(96)
in /var/www/html/careerbd/index.php (15)
04:51:05.498128 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_training` `t` WHERE `t`.`id`=85 LIMIT 1
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(452)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(96)
in /var/www/html/careerbd/index.php (15)
04:51:05.498358 trace system.CModule
Loading "themeManager" application component
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(99)
in /var/www/html/careerbd/index.php (15)
04:51:05.498557 trace system.db.ar.CActiveRecord
lazy loading JbTraining.category
in /var/www/html/careerbd/protected/views/jbTraining/details.php (53)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(99)
in /var/www/html/careerbd/index.php (15)
04:51:05.498744 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_training_category`
in /var/www/html/careerbd/protected/views/jbTraining/details.php (53)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(99)
in /var/www/html/careerbd/index.php (15)
04:51:05.499219 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_training_category`
in /var/www/html/careerbd/protected/views/jbTraining/details.php (53)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(99)
in /var/www/html/careerbd/index.php (15)
04:51:05.499416 trace system.db.CDbCommand
Querying SQL: SELECT `category`.`id` AS `t1_c0`, `category`.`name` AS
`t1_c1`, `category`.`image` AS `t1_c2`, `category`.`icon` AS `t1_c3`,
`category`.`status` AS `t1_c4`, `category`.`create_date` AS `t1_c5`,
`category`.`update_date` AS `t1_c6`, `category`.`create_by` AS `t1_c7`,
`category`.`update_by` AS `t1_c8` FROM `jb_training_category` `category` 
WHERE (`category`.`id`=:ypl0). Bound with :ypl0='13'
in /var/www/html/careerbd/protected/views/jbTraining/details.php (53)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(99)
in /var/www/html/careerbd/index.php (15)
04:51:05.499732 trace system.db.ar.CActiveRecord
ResourcePerson.findByPk()
in /var/www/html/careerbd/protected/views/jbTraining/details.php (64)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(99)
in /var/www/html/careerbd/index.php (15)
04:51:05.499773 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_resource_person`
in /var/www/html/careerbd/protected/views/jbTraining/details.php (64)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(99)
in /var/www/html/careerbd/index.php (15)
04:51:05.500315 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_resource_person`
in /var/www/html/careerbd/protected/views/jbTraining/details.php (64)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(99)
in /var/www/html/careerbd/index.php (15)
04:51:05.500480 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_resource_person` `t` WHERE `t`.`id`=40
LIMIT 1
in /var/www/html/careerbd/protected/views/jbTraining/details.php (64)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(99)
in /var/www/html/careerbd/index.php (15)
04:51:05.500823 trace system.CModule
Loading "widgetFactory" application component
in /var/www/html/careerbd/protected/views/jbTraining/details.php (149)
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(99)
in /var/www/html/careerbd/index.php (15)
04:51:05.501769 trace system.db.ar.CActiveRecord
JbTraining.findAll()
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (138)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/main.php (199)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
04:51:05.501817 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_training` `t` WHERE published=1 AND
feature_training=0 ORDER BY id DESC LIMIT 5
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (138)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/main.php (199)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
04:51:05.502635 trace system.db.ar.CActiveRecord
JbTraining.findAll()
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (157)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/main.php (199)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
04:51:05.502681 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_training` `t` WHERE published=1 AND
feature_training=1 ORDER BY id DESC LIMIT 5
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (157)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/main.php (199)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
04:51:05.503283 trace system.db.ar.CActiveRecord
Jobs.findAll()
in /var/www/html/careerbd/themes/eusiajb/views/layouts/newssticky.php (21)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/main.php (204)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
04:51:05.503333 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_jobs`
in /var/www/html/careerbd/themes/eusiajb/views/layouts/newssticky.php (21)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/main.php (204)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
04:51:05.504196 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_jobs`
in /var/www/html/careerbd/themes/eusiajb/views/layouts/newssticky.php (21)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/main.php (204)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
04:51:05.504549 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_jobs` `t` WHERE status="1" ORDER BY
job_publish_date DESC LIMIT 30
in /var/www/html/careerbd/themes/eusiajb/views/layouts/newssticky.php (21)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/main.php (204)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)