Professional Training

মাইক্রোসফট এক্সেলে হাতেখড়ি

5
25 ratings
  • Date: 18 & 19 Feb 2022
  • Time: 8:00 PM - 10:00 PM
  • Total Hours: 4
  • Class Schedule: Friday & Saturday
  • Registration deadline: 19 February 2022
  • No. of Classes/Sessions: Total 2 classes
  • Venue: Online (Live Class on Zoom)
  • Price: BDT 400

    Enrol

    What you will learn

  • After completion of the training, participants will be able to do basic calculations and report as per business requirements.
  • Those who are already in the job market/involved in business will be able to make a business report on their own.
  • The training will make the attendees confident in MS Excel before entering the job market.
  • Who should attend the program?

    • Anyone who has very minimal or zero knowledge of MS Excel
    • Someone who wants to start from the basic elements of MS Excel

    Training content

    Session 01

    1. Getting Started with Microsoft Office Excel 2016

    • Navigate Excel User Interface
    • Keyboard Shortcut Key
    • Create and save a basic workbook

     

    2. Modifying a Worksheet

    • Insert, delete; adjust Cells, Columns, Rows
    • Search for/replace data

     

    3. Performing Calculations

    • Difference between function and formula
    • Functions: Session One:

     i) IF
    ii) SUM
    iii) COUNT
    iv) COUNTA
    v) VLookup

     

    Session 02

    1. Performing Calculations: Functions

    IFERROR

    SUMIF

    COUNTIF

    HLookup

    Text Formula (Trim, Left, Right, CONCATENATE, LEN, etc.)

     

    2. Performing Calculations

    Combination of Formulas and Functions

     

    3. Formatting a Worksheet

    Apply Text Formats

    Apply Number Formats

    Align Cell Contents

    Apply Basic Conditional Formatting

     

    Instructor's Profile

    Md. Rashedul Islam

      Md. Rashedul Islam is working as a BI Analyst at DARAZ Bangladesh Ltd. Previously, he worked at Sheba Platform Ltd., Shohoz Ltd., Kazi...

    Mentor Details

    Certificate Preview

    Student Feedback

    Recommended Courses

    Md.Mehanazuddin Rupom

    5
    MS Excel
    Total 3 Sessions
  • 13, 20 & 21 May 2022
  • Microsoft Excel Foundation to Pro Level

    BDT 1000

    Enrol

    Nusrat Huda

    5
    Email Writing
    Total 1 Session
  • 10 Mar 2022
  • Professional Email Writing

    BDT 600

    Enrol

    Md. Mohiman ACMA

    5
    Corporate Tax
    Total 2 sessions
  • 07 & 09 Jun 2022
  • কর্পোরেট ট্যাক্স রিটার্ন তৈরি কর্মশালা

    BDT 500

    Enrol

    Asad Zaman

    5
    MS Excel
    Total 4 classes
  • 30 Dec 2021 & 01, 02, 04 Jan 2022
  • MS Excel - আপনার পেশাজীবনে এগিয়ে যাবার হাতিয়ার

    BDT 600

    Enrol