fbpx

Microsoft Office

Microsoft Office2021-03-18T10:15:57+00:00

Project Description

Course Plan

Microsoft Office

 Course Duration: 75 Hours
 Class Duration: 3 Hours

Instructor Profile

Microsoft Windows-7

Course Overview

Students will log on to Windows 7, explore its interface, identify the different components in the interface, customize the Windows 7 desktop, manage files and folders, use the common tools and programs available in Windows 7, and browse the Internet.

Lesson 1: Exploring Windows 7

  • Identify Personal Computer Functionality
  • Log On to Windows 7
  • Explore the Desktop
  • Work with Windows
  • Access the Help and Support Feature
  • Turn Off the Personal Computer

Lesson 2: Customizing the Windows 7 Desktop

  • Customize the Start Menu
  • Customize the Taskbar
  • Personalize the Desktop
  • Add Gadgets to the Desktop

Lesson 3: Managing Folders and Files

  • Navigate to Folders Using Windows Explorer
  • Work with Folders and Files
  • Secure Folders and Files
  • Organize Folders and Files
  • Search for Folders and Files

Lesson 4: Using Common Tools and Programs in Windows 7

  • Create a Document in WordPad
  • Work with the Calculator
  • Capture Screens Using the Snipping Tool
  • Customize a Graphic with the Paint Tool

Lesson 5: Browsing the Internet

  • Get Familiar with the Internet
  • Browse Websites Using Internet Explorer 8
  • Download and Install a Gadget

Microsoft Word 2013 Part-1

Course Overview

In this course, you’ll learn how to use Word 2013 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

Prerequisites

Using Microsoft Windows 7

Lesson 1: Getting Started with Word

  • Identify the Components of the Word Interface
  • Create a Word Document
  • Help

Lesson 2: Editing a Document

  • Navigate and Select Text
  • Modify Text
  • Find and Replace Text

Lesson 3: Formatting Text and Paragraphs

  • Apply Character Formatting
  • Align Text Using Tabs
  • Display Text as List Items
  • Control Paragraph Layout
  • Apply Borders and Shading
  • Apply Styles
  • Manage Formatting

Lesson 4: Adding Tables

  • Insert a Table
  • Modify a Table
  • Format a Table
  • Convert Text to a Table

Lesson 5: Managing Lists

  • Sort a List
  • Renumber a List
  • Customize a List

Lesson 6: Inserting Graphic Objects

  • Insert Symbols and Special Characters
  • Add Images to a Document

Lesson 7: Controlling Page Appearance

  • Apply a Page Border and Color
  • Add a Watermark
  • Add Headers and Footers
  • Control Page Layout

Lesson 8: Proofing a Document

  • Check Spelling and Grammar
  • Other Proofing Tools

Lesson 9: Customizing the Word Environment

  • Customize the Word Interface
  • Additional Save Options

Microsoft Word 2013 Part-2

Course Overview

Students will learn to use Word more efficiently by automating some tasks and creating complex documents that include lists, tables, charts, graphics, and newsletter layouts and will merge data to personalize correspondence and labels.

Prerequisites

Word 2013 – Part 1

Lesson 1: Working with Tables and Charts

  • Sort Table Data
  • Control Cell Layout
  • Perform Calculations in a Table
  • Create a Chart

Lesson 2: Customizing Formats Using Styles and Themes

  • Create and Modify Text Styles
  • Create Custom List or Table Styles
  • Apply Document Themes

Lesson 3: Using Images in a Document

  • Resize an Image
  • Adjust Image Appearance
  • Integrate Pictures and Text
  • Insert and Format Screenshots
  • Insert Video

Lesson 4: Creating Custom Graphic Elements

  • Create Text Boxes and Pull Quotes
  • Draw Shapes
  • Add WordArt and Other Text Effects
  • Create Complex Illustrations with SmartArt

Lesson 5: Inserting Content Using Quick Parts

  • Insert Building Blocks
  • Create and Modify Building Blocks
  • Insert Fields Using Quick Parts

Lesson 6: Controlling Text Flow

  • Control Paragraph Flow
  • Insert Section Breaks
  • Insert Columns
  • Link Text Boxes to Control Text Flow

Lesson 7: Using Templates

  • Create a Document Using a Template
  • Create a Template

Lesson 8: Using Mail Merge

  • The Mail Merge Features
  • Merge Envelopes and Labels
  • Create a Data Source Using Word

Lesson 9: Using Macros

  • Automate Tasks Using Macros
  • Create a Macro

Microsoft Excel 2013 Part-1

Course Overview

In this course, students will use Microsoft® Office Excel® 2013 to create spreadsheets and workbooks that you can use to store, manipulate, and share your data.

Prerequisites

Lesson 1: Getting Started with Microsoft® Excel® 2013

  • Identify the Elements of the Excel Interface
  • Create a Basic Worksheet
  • Use the Help System

Lesson 2: Performing Calculations

  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Manipulate Data

Lesson 5: Printing Workbook Contents

  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks

Lesson 7: Customizing the Excel Environment

  • Customize General and Language Options
  • Customize Formula Options
  • Customize Proofing and Save Options
  • Customize the Ribbon and Quick Access Toolbar
  • Customize the Functionality of Excel by Enabling Add-Ins
  • Customize Advanced and Trust Center Options

Insert, Manipulate, and Delete Cells, Columns, and Rows

Search for and Replace Data

Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

Modify Fonts

Add Borders and Color to Cells

Apply Number Formats

Align Cell Contents

Apply Cell Styles

Microsoft Excel 2013 Part-2

Course Overview

Students will build upon the foundational Microsoft® Office Excel® 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering.

Prerequisites

Excel 2013 – Part 1

Lesson 1: Creating Advanced Formulas

  • Apply Range Names
  • Use Specialized Functions

Lesson 2: Analyzing Data with Logical and Lookup Functions

  • Leverage Questions and Testing to Write Formulas
  • Use Logical and Lookup Functions to Find Answers to Questions

Lesson 3: Organizing Worksheet Data with Tables

  • Create and Modify Tables
  • Sort and Filter Data
  • Use Summary and Database Functions to Calculate Data

Lesson 4: Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyze Data by Using PivotCharts

Lesson 6: Inserting Graphics

  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate SmartArt

Lesson 7: Enhancing Workbooks

  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files

Microsoft Power Point 2013 Part-1

Course Overview

In this course, you will use PowerPoint 2013 to begin creating engaging, dynamic multimedia presentations.

Lesson 1: Getting Started with PowerPoint®

  • Navigate the PowerPoint Environment
  • Create and Save a PowerPoint Presentation
  • Use Help

Lesson 2: Developing a PowerPoint® Presentation

  • Select a Presentation Type
  • Topic B: View and Navigate a Presentation
  • Edit Text
  • Build a Presentation

Lesson 3: Performing Advanced Text Editing

  • Format Characters
  • Format Paragraphs
  • ToFormat Text Boxes

Lesson 4: Adding Graphical Elements to Your Presentation

  • Insert Clip Art and Images
  • Insert Shapes

Lesson 5: Modifying Objects in Your Presentation

  • Edit Objects
  • Format Objects
  • Group Objects
  • Arrange Objects
  • Animate Objects

Lesson 6: Adding Tables to Your Presentation

  • Create a Table
  • Format a Table
  • Insert a Table from Other Microsoft Office Applications

Lesson 7: Adding Charts to Your Presentation

  • Create a Chart
  • Format a Chart
  • Insert a Chart from Microsoft Excel

Lesson 8: Preparing to Deliver Your Presentation

  • Review Your Presentation
  • Apply Transitions
  • Print Your Presentation
  • Deliver Your Presentation

Internet Explorer 8.0 – Level 1

Course Overview

In this course, students will use the different features of Internet Explorer 8 to browse the web, communicate with other users of the web, subscribe to newsgroups, and configure security settings to ensure a safe and an enriching browsing experience.

Lesson 1: Getting Started with Internet Explorer 8

  • Overview of the Internet
  • Explore the Internet Explorer 8 Interface
  • Customize the Internet Explorer 8 Interface
  • Use the Internet Explorer 8 Help System

Lesson 2: Browsing Websites Using Internet Explorer 8

  • View Web Pages on Tabs
  • Navigate Through a Web Page

Lesson 3: Acquiring Information from the Web

  • Search the Web
  • Search Within a Web Page
  • Find People
  • Customize Search Settings
  • Download Information from the Web

Lesson 4: Managing Information from the Web

  • Manage Favorite Links
  • Work with History Files
  • Manage Web Slices and RSS Feeds
  • Save a Web Page
  • Print a Web Page

Lesson 5: Communicating over the Web

  • Send and Receive Instant Messages
  • Communicate Using Email
  • Subscribe to a Newsgroup
  • View Newsgroup Messages

Lesson 6: Configuring Security Settings in Internet Explorer 8

  • Configure Browsing History Settings
  • Configure Pop-Up Settings
  • Configure the Smart Screen Filter
  • Configure Internet Security and Privacy Settings

Course Resource Person

Mohammad Shihab Uddin
Mohammad Shihab Uddin
Suman Chakraborty
Suman ChakrabortySenior Technical Trainer
Md. Tawhidul Alam
Md. Tawhidul AlamSinior Technical Trainer, Web Designing & Development
Tanvir Islam
Tanvir IslamTrainer Graphics & Multimedia
BSE in CSE
Shariful Islam
Shariful IslamSinior Technical Trainer, Web Designing & Development
Md. Foysal Wahid
Md. Foysal WahidSinior Technical Trainer, Microsoft Programming.