কম্পিউটার অফিস অ্যাপ্লিকেশন

MICROSOFT OFFICE

ALL YOU NEED TO KNOW

CLASS LECTURE

MICROSOFT WORD

Lecture-1

  • About Computer
  • To Start your Computer
  • To Shut Down your Computer
  • Run MS-Word
  • Exit from MS-Word
  • Cursor movement
  • Make a document
  • Save a document
  • Close a document
  • Open a document
  • To block the text
  • Cut
  • Copy & Past
  • Cut & Paste
  • Clear the Text

Lecture-2

  • To Select All
  • Font
  • Paragraph
  • To Change Case
  • Undo
  • Redo
  • Zoom
  • Full Screen
  • Lecture-3

    • Insert New Page
    • Inset/ Remove Page Number
    • Go To Page/Line/Column…
    • Insert Date & Time
    • Insert Symbol
    • Insert Footnote
    • Remove Footnote
    • Auto Numbering
    • Removing Numbering

Lecture-4

  • Border and Shading
  • Bangle Writing
  • Find the Text
  • Replace the Text
  • To Change layout
  • Show/Hide Ruler
  • Show/Hide Toolbar
  • Header and Footer

Lecture-5

  • Set Tabs
  • Remove Tabs
  • Set Drop Caps
  • Remove Drop Caps
  • Insert Background

Lecture-6

  • Insert Picture from Clip Art
  • Format a Picture
  • Insert Auto Shapes
  • Format Auto Shapes
  • Inset Word Art
  • Format Word Art

Lecture-7

  • To Open a New Document
  • Insert Column
  • Remove Column
  • Insert Chart
  • Insert a Diagram
  • Insert Text Box
  • Text Direction
  • Insert object
  • Insert Equation

Lecture-8

  • Insert Table
  • Select Cell/ Row/Column/Table
  • Cut Cell/ Row/Column/Table
  • Insert Cell/Row/Column/Table
  • Draw Table
  • Marge Column/Row
  • Split Column/Row
  • Table Auto format

Lecture-9

  • Auto Fit Table
  • Distribute Columns/Rows
  • Table Properties
  • Set a Row for Heading
  • Use Formula
  • Sorting
  • Split Table

Lecture-10

  • Set Language
  • To Spelling the Document
  • Word Count
  • Auto correct Options
  • Changing Options
  • Water Mark
  • Give Password for a Document
  • Remove Password
  • Window menu
  • Help menu
  • Page Setup
  • Print Preview
  • Print a Document
  • Short cut menu & command
  • Work without mouse

MICROSOFT EXCEL

Lecture-1

  • What is Excel?
  • Excel শুরু করার নিয়ম । 
  • Document Area 
  • Column, Raw, Cell, Pointer 
  • Pointer, Move 
  • Project (Score Calculation)
  • Calculation বণর্না (+, -,´*,/, Max, Min, Average)
  • Delete 
  • Edit 
  • Saving File
  • Close Book 
  • New Word Book Set 
  • Save Book – Open 
  • Excel Program Exit 
  • Cell Range, Select 
  • Multiple Cell Range, Select
  • Text, Delete 
  • Delete By Range
  • Undo/Redo
  • Editing, Worksheet Data
  • Coping Data
  • Cut & Paste
  • Copy & Paste

Lecture-3

  • Project- (Salary Sheet)
  • Cell Format (Font)
  • Cell Format (Number)
  • Cell Format (Alignment)
  • Cell Format (Border)
  • Cell Format (Fill)
  • Bangla Font

Lecture-4

  • Project (Electric Bill)
  • Create Standard Width of Column
  • Rename a Worksheet
  • Hide a Worksheet
  • Un-Hide a Worksheet
  • Format a Tabular Report
  • Cancel a Auto Format
  • Change Auto Format Option
  • Create Worksheet Auditing

Lecture-5

  • Project (Result Sheet)
  • Create Data Sorting
  • Create Data Filtering
  • Show all Filtering Data
  • Create a Custom Auto-Filter
  • Remove Data’s From filtering
  • Create Text to Column
  • Arrange all Window
  • Insert Chart
  • Create Header & Footer
  • Change Page Setup
  • Worksheet Title (Freezing)
  • Worksheet Title (Un-Freezing)
  • Cell & Worksheet Protection
  • Cell & Worksheet Un-Protection
  • Set password in a File
  • Retrieve the password file
  • Delete Password in a file
  • Work Sheet Preview
  • Printing

MICROSOFT ACCESS

Lecture-1

  • Microsoft Access এর সংজ্ঞা ।
  • Database কি?
  • Access ডাটাবেসের বিভিন্ন অবজেক্ট
  • Data 
  • Record
  • Field
  • Access শুরু করা 
  • Access তৈরি করা ।
  • Design View-তে Customer টেবিল তৈরি করা ।
  • Primary Key সেট করা ।
  • Order টেবিল তৈরি করা । 
  • Design View Products 
  • Products টেবিলে ডাটা এন্ট্রি করা ।
  • Products টেবিল । 

Lecture-2

  • Data Sort
  • Acending Order Sorting
  • Decending Order Sorting
  • Sorting Delete Kiv
  • Query 
  • Design View -তে Query তৈরি করা ।  
  • Field List
  • Design Grid
  • Query
  • Field
  • Table
  • Sort
  • OR

Lecture-3

  • Credits ফিল্ডের বিভিন্ন কুয়েরী তৈরি । 
  • OR স্টেটমেন্ট ব্যবহার করে কুয়েরী তৈরি ।
  • OR এবং AND ব্যবহার করে কুয়েরী । 
  • Form তৈরি করা । 
  • Report তৈরি করা । 
  • Auto Report তৈরি করা । 
  • Label তৈরি করা । 
  • Switchboard তৈরি করা । 
  • Macro তৈরি করা । 
  • Visual Basic কোড সংযোগ করা

Additional Skills 

MICROSOFT PowerPoint

Lecture-1

  • Microsoft PowerPoint Of Elements
  • Slides
  • Presentation
  • Hand Outs
  • Speaker Notes
  • Outlines
  • Create PowerPoint Slide.
  • Start PowerPoint Slide.
  • Add Slide.
  • View All Silde.

Lecture-2

  • Add Animation 
  • Add Transition 
  • View Button 
  • Menu Button
  • Outline View
  • Slide Sorter View
  • Note Page View
  • Slide Show
  • Change Layout
  • Preset Animation
  • Continueosly Slide Show
  • Slide automatically transition
  • Timing Set. 

Windows 

Lecture-1

  • About Operating System
  • Change Desktop Background
  • Screen Saver
  • Appearance
  • Settings
  • View/Hide Icon
  • Taskbar-in Top/ Auto hide
  • Show small Icon/ Show clock
  • Introduce My Computer
  • Create Folder
  • Copying File/Folder
  • Delete File/Folder
  • Re-name File/Folder
  • Cut & Past Folder
  • Recycle Bin

Lecture-2

  • Find File/Folder
  • Control Panel
  • Mouse Pointer
  • Multimedia
  • Playing Audio/Video Songs
  • Date & Time Settings
  • Installing New Programme
  • Uninstall a programme
  • Add Printer
  • Scan Disk/Disk Defragmenter
  • Disk Clean

Internet Browsing

  • What is Browser?
  • What is Google?
  • How to Search Google.
  • What is E-mail?
  • How to Create Email?
  • How to Use Email?
  • How to sent Email?
  • What is Yahoo?
  • Yahoo! Account Create.
  • How to sent mail using Yahoo!
  • Using Yahoo! 
  • Create Facebook Account
  • Browsing Facebook.
  • How to find job in google. 
© 2021 All Rights Reserved.