Date : Fri, 25 Aug 2017 - Sat, 26 Aug 2017 Last Date of Registration : Thu, 24 Aug 2017
No. of Classes/ Sessions : 2 Total Hours : 16
Duration : 2 Day Time : 10AM-5PM
Category : Motivational
Resource Person
Md. Mohin Chowdhury

View Profile
Associate Resource Person

Training Details

Start Date: Fri, 25 Aug 2017
Last Date of Registration: Thu, 24 Aug 2017
Training Fee: 3000.00
Vanue: Bangladesh Skill Development Institute (BSDI) House #2B, Road #12, Mirpur Road, Dhanmondi, Dhaka - 1209,


Who Can Attend?

Basic operational skills in excel and should be a regular Excel user.

Methodology

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

Special Note

15% Weaver || Where we have conducted our training programs: Dhaka University, Jahangir Nogor University, Jagannath University, Daffodil International University, Super Star Group, Eastern Bank Limited,

TRAINING ON ADVANCED EXCEL FOR PROFESSIONAL, STUDENTS
Objective of this Training

Excel for Human Resources Planning

While database systems like Oracle (ORCL), SAP (SAP)and Quick books (INTU) can be used to manage payroll and employee information, exporting that data into Excel allows users to discover trends, summarize expenses and hours by pay period, month, or year, and better understand how yourworkforce is spread out by function or pay level.

HR professionals can use Excel to take a giant spreadsheet full of employee data and understand exactly where the costs are coming from and how to best plan and control them for the future.

Why you will learn excel?

  • To Employable.
  • To have more time for the good things in life.
  • You Will Have More Value to Employers.
  •  To enhance your practical Knowledge and Management Skills.

Training Overview & Outline

SESSION 1

In this session participants will know the essential utilities, ranges 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 latter part of the course.

Understanding of Excel Objects:

  1. Introduction to MS Excel Sheet
  2. Moving along/across MS Excel Sheet
  3. Entering and Editing Data into Cells
  4. Naming cells
  5. Copy/Cut and Paste
  6. Format Painter
  7. Ranges of Paste Special
  8. Font & Font size changing
  9. Fill Color & Font Color
  10. Applying Borders
  11. Alignment
  12. Orientation changing
  13. Wrap Text & Merging Cells
  14. Increasing & Decreasing decimals
  15. Row/Column Inserting & Deleting
  16. Filling Cells
  17. Sorting & Filtering
  18. Finding & Selecting
  19. Hiding Cells and Gridlines
  20. Naming, Adding, & Deleting Worksheets
  21. Changing Worksheet Tab Color
  22. Linking and Referencing inside and across worksheets
  23. Relative and Absolute Referencing
  24. Linking Across Different Files
  25. Row Height & Column Width
  26. Hiding and Unhiding Rows and Columns
  27. Insert Copied Cells
  28. Rows and Column functions
  29. Understanding Functions and Formula in Excel
  30. Operators for Writing Formulas
  31. Types of Functions in Excel
  32. Copying Formulas and Functions

SESSION 2:

Knowing different customization options in Excel can put you in charge of your 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.

Customization of Wordbook/Sheets/Data

  1. Conditional Formatting
  2. Format as Tables
  3. Cell Styles
  4. Inserting Photos, Smart Arts & Shapes
  5. Number Formatting
  6. Forcing text to appear on a new line within a cell;
  7. Trick to input data into multiple cell simultaneously;
  8. Entering the current date or time into a cell.
  9. Data Cleaning
  10. Making Charts &Sparklines
  11. Freeze Panes
  12. Go To Special
  13. Using Hyperlinks

SESSION 3

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.

ADVANCE SKILLS ON EXCEL FUNCTIONS – I

  • Logical Functions in Excel
  1. IF and nested IF functions
  2. And & Or logics
  3. IFERROR.
  • Statistical Functions
  1. Summing and Averaging
  2. MIN & MAX
  3. Counting numbers, texts and blanks
  • Financial Functions:
  1. NPV
  2. IRR
  3. PMT
  4. CUMIPMT
  5. CUMPRINC
  6. Bond Valuation.
  7. FVSCHEDULE
  8. Depreciation calculation.
  • Text Functions
  • CONCATENATE
  • PROPER, UPPER, LOWER
  • LEN, LEFT, RIGHT
  • TEXT, TRIM

SESSION 4:

ADVANCE SKILLS ON EXCEL FUNCTIONS – II

This session is a continuation of the last session.

  1. LOOKUP function
  2. Vertical LOOKUP Function
  3. Dynamic VLOOKUP
  4. Horizontal LOOKUP Functions
  5. Variations of Date functions
  6. INDEX Function
  7. MATCH Function
  8. INDIRECT Function
  9. SUMIF and SUMIFS
  10. COUNTIF and COUNTIFS

SESSION 5:

ADVANCE DATABASE UTILITIES 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.

OPTIMIZATION AND RISK MANAGEMENT TOOLS IN EXCEL

  1. Goal Seek for seeking target values
  2. Scenario Analysis
  3. Use of Solver
  4. Use of Macro
  5. Use of Developer Tab
  6. Data Validation Techniques
  7. Data sorting
  8. General Filtering
  9. Advanced Filtering
  10. Grouping & Ungrouping
  11. Subtotal
  12. Pivot Table
Registration
Application Log
Timestamp Level Category Message
20:00:28.961348 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
20:00:28.961499 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
20:00:28.961601 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)
20:00:28.961891 trace system.web.filters.CFilterChain
Running filter JbTrainingController.filteraccessControl()
in /var/www/html/careerbd/index.php (15)
20:00:28.961935 trace system.CModule
Loading "user" application component
in /var/www/html/careerbd/index.php (15)
20:00:28.961980 trace system.CModule
Loading "session" application component
in /var/www/html/careerbd/index.php (15)
20:00:28.962064 trace system.CModule
Loading "db" application component
in /var/www/html/careerbd/index.php (15)
20:00:28.962126 trace system.db.CDbConnection
Opening DB connection
in /var/www/html/careerbd/index.php (15)
20:00:28.962615 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1529416828
in /var/www/html/careerbd/index.php (15)
20:00:28.962945 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1529416828,
:id='v07fe2bt2e78o9ntr4hsqlk2j3'
in /var/www/html/careerbd/index.php (15)
20:00:28.963191 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)
20:00:28.963310 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)
20:00:28.963407 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)
20:00:28.963617 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)
20:00:28.964198 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)
20:00:28.964348 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)
20:00:28.964449 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)
20:00:28.964736 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)
20:00:28.965158 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)
20:00:28.965277 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)
20:00:28.965325 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)
20:00:28.965615 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)
20:00:28.965934 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)
20:00:28.966085 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)
20:00:28.966136 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)
20:00:28.966424 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)
20:00:28.966463 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)
20:00:28.967083 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)
20:00:28.967252 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_training` `t` WHERE `t`.`id`=89 LIMIT 1
in /var/www/html/careerbd/protected/controllers/JbTrainingController.php
(57)
in /var/www/html/careerbd/index.php (15)
20:00:28.967566 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)
20:00:28.967991 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)
20:00:28.968106 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)
20:00:28.968152 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_training` `t` WHERE `t`.`id`=89 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)
20:00:28.968384 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)
20:00:28.968580 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)
20:00:28.968769 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)
20:00:28.969227 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)
20:00:28.969417 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='16'
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)
20:00:28.969724 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)
20:00:28.969767 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)
20:00:28.970335 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)
20:00:28.970494 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_resource_person` `t` WHERE `t`.`id`=15
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)
20:00:28.970835 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)
20:00:28.971788 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)
20:00:28.971838 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)
20:00:28.972469 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)
20:00:28.972516 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)
20:00:28.973053 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)
20:00:28.973112 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)
20:00:28.973963 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)
20:00:28.974303 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)