Class Start: January 24, 2020 (Friday)
Seats Available: 10 only (First come first serve)
Admission Deadline: January 20, 2020
Duration: 12 Weeks
Class Time:  11:00 AM To 12:30 PM

Course Fees – 6,000/- Tk.

Early Bird Registration Going on Valid till 15 January, 2020 Tk. 5,500/-

MICROSOFT EXCEL OUTLINE

  • Quick Access Toolbar
  • Tabs              
  • Ribbon         
  • 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
  • Concatenate
  • TRIM
  • PROPER       
  • UPPER          
  • LOWER        
  • Sumif
  • Sumifs
  • Countif
  • Countifs
  • AVERAGEIF
  • AVERAGEIFS
  • Minifs
  • Maxifs
  • Large
  • Small
  • Data Validation
  • Whole Numbers
  • Text Length
  • Date
  • Drop Down List
  • Input Messages
  • Error Messages
  • Stop
  • Warning
  • Information
  • VLOOKUP
  • VLOOKUP ( EM)
  • VLOOKUP (AM)
  • Quiz
  • Vlookup Advanced – 1
  • Vlookup Advanced – 2
  • Vlookup Advanced – 3
  • Match
  • Vlookup + Match
  • Vlookup + Match Advanced
  • Vlookup + Match Advanced 2
  • Hlookup + Match Advanced 1
  • Nested Vlookup
  • Nested Vlookup Advanced
  • Index Function
  • Index Function 2
  • Index Function 3
  • Paste Special
  • Values
  • Values 123 + Number formatting
  • Picture
  • Picture linked
  • Linked source
  • Transpose
  • Formatting
  • Conditional Formatting
  • Advanced Conditional
  • IF
  • If Case
  • If and
  • If or
  • Nested IF
  • Filter
  • Chart
  • Pie
  • Bar
  •  Column
  • Line Chart
  • Map
  • XY Scatter Chart
  • Spark Line Chart
  • Treemap
  • Combo
  • Dashboard
  • Pivot Table
  • Pivot Chart
  • Advanced Pivot Table
  • Slicer
  • Pivot Table Dashboard

MICROSOFT POWERPOINT OUTLINE

  • Getting Started with PowerPoint
  • Navigate the PowerPoint Environment
  • View and Navigate a Presentation
  • Create and Save a PowerPoint Presentation
  • Developing a PowerPoint Presentation
  • Select a Presentation Type
  • Edit Text
  • Build a Presentation
  • Performing Advanced Text Editing Operations
  • Format Characters
  • Format Paragraphs
  • Format Text Boxes
  • Adding Graphical Elements to Your Presentation
  • Insert Images
  • Insert Shapes
  • Adding Tables to Your Presentation
  • Create a Table
  • Format a Table
  • Insert a Table from Other Microsoft Office Applications
  • Adding Charts to Your Presentation
  • Create a Chart
  • Format a Chart
  • Customized Professional Slides
  • Animation customization
  • Designing Slides

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)