Start Date :
Last Date of Registration :
No. of Classes/ Sessions : 16
Duration : 2 Hours
Total Hours : 200 hours
Time : 6.00 - 8.00 pm
Cinque Terre
Resource Person
No Image


View Profile

Course Details
Start Date:
Last Date of Registration:
Course Fee: 1000
Vanue: Daffodil Family Tower (Level-7), House # 11, Road # 14, Dhanmondi, Dhaka- 1209.


Who Can Attend?

This course is designed for the professionals who want to be faster and better than any other in GRAPHIC DESIGNING and smarter - make the difference clear ahead in INNOVATIVE DESIGN CREATOR.



Methodology

Interactive Lecture, Power Point Presentation,Lab Classes, Case Study,Group Work,Real Time Projects, Handout etc



Special Note
Registration:
Interview: /td>
Admission: 1000
Certificates: Daffodil Family Tower (Level-7),House # 11, Road # 14, Dhanmondi, Dhaka- 1209.


Basic Microsoft Excel Skill



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. The course starts from very basic level and concludes at an advance intermediate stage of Microsoft Excel 2013.


Training Overview & Outline

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

  1. Entering and Editing Data into Cells;
  2. Naming cells and ranges of cells;
  3. Copy and Paste;
  4. Paste Special;*
  5. Data Type* & Alignment;
  6. Fill Color and Borders;
  7. Hiding Cells Data and Grid;
  8. About Worksheets;
  9. Naming, Adding, & Deleting Worksheets;
  10. Changing Worksheet Tab Color;
  11. Linking and Referencing inside and across worksheets;
  12. Relative and Absolute Referencing;
  13. Linking Across Different Files;
  14. Building Blocks of Excel – Rows & Columns
  15. Row Height & Column Width;
  16. Hiding and Unhiding Rows and Columns;
  17. Inserting and Deleting Rows and Columns;
  18. Insert Copied Cells;
  19. Rows and Column functions.
  20. Understanding Functions and Formula in Excel
  21. Difference between Functions and Formulas;
  22. Writing Functions and Formulas;
  23. Operators for Writing Formulas;
  24. Types of Functions in Excel*;
  25. 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.

  1. Toolbars and Add-ins in Excel
  • Standard Toolbar;
  • Formatting Toolbar;
  • Borders and Chart Toolbar;
  • Control Toolbox and Forms; Drawing Toolbar;
  1. Customization Options in Excel
  • View Options;
  • Calculation Options;
  • Edit Options;
  • General Options;
  • Spelling Options;
  • Save Options;
  • Security Options;
  1. 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
  1. If and nested if functions.
  2. And & Or logics; Using If and nested If with And & Or
  3. Practical exercises and business case
    • Statistical Functions
  1. Summing and Averaging
  2. Median and Mode
  3. Counting numbers, texts and blanks
  4. Practical Exercises and business cases
    • Combined Functions
  1. Sumif and Sumifs
  2. Countif and Countifs

SESSION 4 (ADVANCE SKILLS ON EXCEL FUNCTIONS – II)

This session is a continuation of the last session.

    • LOOKUP FUNCTIONS
  1. Lookup function
  2. Vertical Lookup Function
  3. Horizontal Lookup Functions
    • WORKING WITH DATES
  1. Special case of dates in Excel
  2. Date functions & shortcuts
  3. Arithmetic operations on dates
  • WORKING WITH TEXTS
  1. Different Text functions
  2. 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.

  1.  Data Validation Techniques
  2.  Data sorting
  3.  General Filtering
  4.  Advanced Filtering
  5.  Subtotal
  6.  Pivot Table
  7.  Indexing and Hyper linking

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.

  1.  Goal Seek for seeking target values
  2.  Simulation for Reaching Optimum Solution
  3.  Advance Conditional Formatting