MAWbiz ad

Professional Training

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

3.5
15 ratings
  • Date: 14 & 15 Jan 2022
  • Time: 8:00 PM - 10:00 PM
  • Total Hours: 4
  • Class Schedule: Friday & Saturday
  • Registration deadline: 15 January 2022
  • No. of Classes/Sessions: Total 2 classes
  • Venue: Online (Live Class on Zoom)
  • Price: BDT 350

    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