Date : Fri, 13 Oct 2017 - Sat, 14 Oct 2017 Last Date of Registration : Wed, 11 Oct 2017
No. of Classes/ Sessions : 2 Total Hours : 16
Duration : 2 Day Time : 10AM-5PM
Category : Microsoft
Resource Person
Md. Mohin Chowdhury

View Profile
Associate Resource Person

Training Details

Start Date: Fri, 13 Oct 2017
Last Date of Registration: Wed, 11 Oct 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