Microsoft Office

Page Layout Tab

Orientation

Margins

Size

Columns

Selection Techniques

Mouse and keyboard

How to select a word, sentence & all select

What does drag / drop mean?

File Tab

How to Save/Save as a File?

How to Create a New Document?

How to Open a Saved File?

How to Create a Password for a File?

Formatting Text

Apply font styles

How to Increase & Decrease the Font Size?

Bold, Italic & Underline

Change Font color

Highlight text color

How to Used Bulleting text & numbering text?

Clipboard Command

Copy & Paste

Cut & paste

Moving and Copying Text Using the Mouse

Delete

Undo & Redo

Review Previous Class

Paragraph Group

Alignment:

Left, Right, Center & Justify

Changing Line Spacing, Changing Spacing Between Paragraphs

Using Left and Right Indents

Adding borders, Page Border and shading.

Add watermark to the document

Review Tab

Check spelling and grammar in word file

Adding Thesaurus to Word file

View word file details with word count

Protect Document

View Tab

Learn about print layout

Why is Ruler used? How to hide and show Ruler?

Give knowledge about Zoom, One Page, Two Page, and Page Width

Review Previous Class

Find / replace

Blank page / Page Break

Tables

Creating tables

working with table content

Changing table structure

Add a picture to the document

Drawing with Shapes in the document

How to present a topic in Smartly by

SmartArt?

Using Headers and Footers, Page numbers

Save from Word file to .Pdf file

Review Previous Class

Insert Hyperlink

Insert screenshot

Format

Edit

Text Box

Date and Time

Equation

Symbol

Mailings Tab

The mail merge List

Review Previous Class

Curriculum Vitae/Resume

Review Previous Class

Bangla Typing

Review Previous Class

Bangla Typing

Review Previous Class

MICROSOFT EXCEL

Navigate the Excel User Interface

How many Rows & Columns in a Worksheet?

( 10,48,576 & 16,384 )

The Cell, cell address, active cell, cell pointer, Moving around the worksheet, To Move the Cell Pointer:

Enter Cell Data

Introduction to Autofill? How can we use it by showing examples?

About Formulas (+, -, /, *, =)

Excel requires every formula to begin with an equal sign (=).

How can we calculate Addition, Subtraction, Multiplication, Division, Average Value, Percentage, Count Numbers, and Maximum Minimum Value?

To Edit Information in a Cell

Direct Cell Editing.

Review Previous Class

Cash Memo & Balance Sheet

Cells formatting

Review Previous Class

Salary Sheet

Review Previous Class

Apply Basic Conditional Formatting

Create and Modify Tables

Working with Lists

Sort Data

Filter Data

Data validation

Visualizing Data with Charts

Create Charts

Modify and Format Charts

Review Previous Class

Printing Workbooks

Preview and Print a Workbook

Set Up the Page Layout

Review Previous Class

Printing Workbooks

Preview and Print a Workbook

Set Up the Page Layout

Excel project

Review Previous Class

How to get started with PowerPoint

Introduction of MS PowerPoint & Interface.

View a Presentation

Create and Save a PowerPoint Presentation

Select a Presentation Type

Advanced Text Editing Operations

Format Characters

Format Paragraphs

Format Text Boxes

Adding Graphical Elements

Insert Images

Insert Shapes

Review Previous Class

How can I add Background?

How can I show the slides without clicking or automatically?

Apply Transitions

How to create a Text Animation?

Animation Speed

Print Your Presentation

Deliver Your Presentation

Review Previous Class

MS Access

What is Access & Why we used it?

How to Create a Database?

Give knowledge about “Report” & “Form” Options?

Which ways we are used to Show a Database?

Create an “Employee” or “Student” Database.

Review Previous Class

MS Access

What is Query? Why we used it?

How can find out a specific data from a Database using “Query” Option?

Review Previous Class

Control Panel

Review Previous Class

Internet Technology

Introduction to Internet, Web Browsers, Searching Techniques

How to Download from YouTube?

 How can see the Web Radio & TV?

Online Shopping/E-Shopping

  Gmail/Yahoo & Facebook.

Review Previous Class

Problem Solution of Full Course.

PC Setup