Business Excel

Business Excel

In the Bangladesh and Abroad, millions of job advertisements requiring Excel skills are posted every day.

course at a glance

  • Date : 21 Feb - 21 Feb 2020
  • No. of Classes/ Sessions : 1
  • Total Hours : 8
  • Last Date of Registration : 21 Feb 2020
  • Class Schedule :
    • Friday - 9 AM - 5 PM
  • venue : RH Home Center, Level#5, Suite#539, 74/B/1 Green Road, Tejgaon, Dhaka-1205 Contact: 01841801180

Price: TK. 2,000
(Excluding VAT & TAX)
1500 TK ( 500 Tk Special Discount )


This workshop is jointly organized by  BITM & PONDIT. Training will be held in  PONDIT.


This course is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the Bangladesh and Abroad, millions of job advertisements requiring Excel skills are posted every day. Research shows that digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others.


  1. INTRODUCTION
  • Introduction
  • Interface
  • Tabs and Ribbons
  • Document Windows
  • Navigation Tips
  • Office Button and Save

 

  1. ENTERING, EDITING AND FORMATTING DATA
  • Introduction
  • Entering Data
  • Fonts, Fills, and Alignment
  • Cut, Copy, and Paste ***
  • Paste Special ***
  • Undo and Redo
  • Moving, Finding, and Replacing a Value
  • Comments

 

  1. FORMATTING NUMBERS
  • Introduction
  • Currency Format ***
  • Format Painter
  • Formatting Dates
  • Custom and Special Formats

 

  1. MANAGING WORKSHEETS
  • Introduction
  • Naming and Moving Worksheets
  • Copying Worksheets
  • Adding, Deleting and Hiding Worksheets
  • Moving, Copying, Deleting and Hiding Grouped Worksheets ***

 

  1. MODIFYING ROWS AND COLUMNS
  • Introduction
  • Inserting and Deleting Columns and Rows
  • Inserting & Deleting Cells
  • Inserting Multiple Columns & Rows
  • Modifying Cell Width and Height
  • Hiding and Unhiding Rows and Columns

 

  1. UNDERSTANDING FORMULAS
  • Introduction
  • Using Operations
  • Creating Formulas
  • AutoSum ***
  • Common Formulas
  • Searching for Formulas
  • Copying Formulas
  • Using Relative and Absolute References

 

  1. CHANGING VIEWS
  • Introduction
  • Workbook Views
  • Show/Hide
  • Zoom Features
  • Freeze Panes ***
  • Split Windows
  • Viewing Multiple Windows
  • Minimize The Ribbon
  • Worksheet Backgrounds

 

  1. CONDITIONAL FORMATTING
  • Introduction
  • Highlight Cells Rules
  • Custom Formatting Rule

 

  1. TABLES
  • Introduction
  • Insert a Table and Style Options
  • Add Rows and Columns
  • Perform a Function in a Table
  • Summarise With Pivot Table

 

  1. DATA TOOLS
  • Introduction
  • Data Validation ***
  • Drop-Down Lists
  • Removing Duplicates
  • Text To Columns

 

  1. REFERENCING FORMULAS
  • Introduction
  • Multiple Sheet References
  • Trace the Precedents and Dependents

 

  1. RANGES AND DATES
  • Introduction
  • Cell Names
  • Formulas with Cell Names
  • Date Formulas

 

  1. LOOKUPS
  • Introduction
  • VLOOKUP ***
  • HLOOKUP

 

  1. CONDITIONAL LOGIC
  • Introduction
  • IF Statement / Nested IF
  • AND / OR / NOT
  • IFERROR
  • SUMIF / SUMIFS
  • COUNTIF & COUNTIFS

 

  1. TEXT FORMULAS
  • Introduction
  • Case Formulas
  • Fix Number Fields
  • Trim Spaces

 

  1. INTRODUCTION TO CHARTS
  • Introduction
  • Chart Types
  • Instant Chart
  • Update Chart
  • Column Chart
  • Picture Fill
  • Adjust Chart Size
  • Line Chart, Scatter Chart

 

  1. FORMATTING CHARTS
  • Introduction
  • Chart Styles
  • Chart Layouts
  • Add Labels
  • Axis Options
  • Chart Title
  • Legends
  • Data Labels

 

  1. ADDING GRAPHICS TO SPREADSHEETS
  • Introduction
  • Insert Pictures
  • Modifying Pictures
  • Insert Shapes
  • Insert SmartArt

 

  1. OUTLINE, SORT, FILTER, AND SUBTOTAL
  • Introduction
  • Group and Ungroup
  • Sort Data
  • Sort Multiple Levels
  • Filter Data ***
  • Advanced Filter

 

  1. PIVOTTABLES
  • Introduction
  • Creating PivotTables
  • Choosing Fields
  • PivotTable Layout
  • Filtering PivotTables
  • Modifying PivotTable Data
  • PivotCharts

 

  1. PROTECTING DATA
  • Introduction
  • Workbook Passwords
  • Protecting Workbooks
  • Unlocking Cells

 

  1. PRINTING
  • Introduction
  • Page Orientation
  • Print Area ***
  • Margins
  • Headers and Footers
  • Scaling

 

  1. SAVING A WORKBOOK
  • Introduction
  • Save As Previous Version
  • Templates
  • Save As PDF ***

 

  1. MACROS
  • Introduction and Macro Security
  • Recording a Macro
  • Assign a Macro to a Button or Shape
  • Run a Macro upon Opening a Workbook

Curriculum

Module Business Excel 8 Hrs

Tentative Class Start

21st February, 2020

Available Seat

10 / 20

who can join

This course is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today.

Meet the Instructor