Class Start: Feb 8, 2020 (SAT)
Seats Available: 10 only (First come first serve)
Admission Deadline: Feb 2, 2020
Duration: 6 Weeks
Class Time: SAT 9:30 AM To 11:00 AM

Course Fees – 2,500/- Tk.

Early Bird Registration Going on Valid till 1 Feb, 2020 Tk. 2,000/-

CERTIFIED MASTER COURSE ON MS EXCEL

During this CERTIFIED MASTER COURSE ON MS EXCEL, you will build a solid foundation. On which you will be able to learn, grow more and be able to build the rest of your Excel experience most importantly. Enroll and we’ll guide you step-by-step, through the basics of working with the most powerful spreadsheet tool on the market. Besides In very little time, you will master the basics of Excel that’ll provide a foundation for more advanced Excel techniques.

Course Content

  • Quick Access Toolbar
  • Tabs               
  • Ribbion          
  • Name Box      
  • Formula Bar  
  • Rows, Columns, Cells
  • Sheets             
  • Zoom              
  • Work book VS Work Sheet
  • Cell VS Range
  • Simple Data Entry
  • Selecting Ranges
  • Saving workbook formats
  • Find & Replace
  • Protection
  • Font
  • Alignment
  • Number
  • Sum
  • Auto sum
  • Shortcut
  • Relative Reference
  • Absolute Reference
  • Mixed Reference
  • Left
  • Right
  • Mid
  • Concatenate
  • TRIM 
  • PROPER        
  • UPPER           
  • LOWER         
  • LEN
  • Separator is Space
  • Separator is &
  • Separator is @
  • Copy
  • Paste
  • Paste Special
  • Copying Cell(s) to One / Many Cells
  • Copying to different Worksheets
  • Using fill for quick copying
  • Hiding/ Unhiding Columns/Rows
  • Freezing Panes
  • Splitting windows
  • Creating Custom Views
  • Displaying Custom Views
  • Deleting Custom Views
  • Add/Subtract/Multiphy/Divide
  • BODMAS
  • Count Formula
  • Counta Formula
  • Countblank
  • Countif
  • Sum
  • Average
  • Max
  • Min
  • Sumif
  • Sumif
  • Sumproduct
  • Countif
  • Chart Management
  • Data Sorting
  • Logical Test
  • If Functions
  • And
  • Or
  • Nested IF
  • VLOOKUP with Exact Match
  • VLOOKUP Approximate Match
  • VLOOKUP Rules
  • VLOOKUP with Trim
  • H-Lookup
  • Advanced Filters
  • Advanced Table
  • Pivot Table with chart

Registration Process

To register your name inbox us for the following information;
Full Name:
Mobile Number:
E-mail ID:
Batch Number:
bKash Number / Trx ID:

(To confirm your seat, you need to send Tk. 1,000 through
#bKash or #Rocket or #Nagad)
bKash: 01733405068 (personal)
Rocket: 017334050682 (personal)
Nagad: 01670031946 (personal)

Contact us
+88 01733405068
E-mail: mhossain@icdb.info
Youtube Channel: Institute of Career Development, Bangladesh – ICDB

#Excel #Training #ICDB