Microsoft-Office Course in Chittagong

Overview:

Microsoft Office products help improves work efficiency with user-friendly features that enable easy and secure information sharing. Microsoft Office products provide resources for professional presentation of data that is compatible with most operating systems. Whether you are looking to expand your Microsoft Office skills for personal use, embarking on a new career, or working towards career advancement, ChangeTech BD has the Microsoft Office training that you are looking for. ChangeTech BD designs its Microsoft Office classes to get the student engaged in real life situations so that you or your team can take the skills learned and apply them to everyday scenarios. In fact, over 98% of New Horizons students indicate higher job productivity levels.

Course Duration

2 months 24-26 Classes

Course Fee

2500 BDT

Key Features:

  • Windows 7 Introduction
  • Microsoft Word Basic
  • Microsoft Word Intermediate
  • Microsoft Word Advanced
  • Microsoft Excel Basic
  • Microsoft Excel Intermediate
  • Microsoft PowerPoint Basic
  • Microsoft PowerPoint Advanced
  • Microsoft Outlook
  • Microsoft Access
  • Internet Basics

Contents of Training:

1. Explore Windows 7
· Logging On to Windows 7
· Exploring the Desktop
· Using the Start Menu
· Using the Windows Taskbar
· Exploring Control Panel
· Finding Information about Your Computer
System
· Updating Windows System Files
· Ending a Computing Session

2. Manage User Accounts
· Understanding User Accounts and Permissions
· Creating a User Account
· Managing a User Account
· Limiting Computer Access
· Disabling or Deleting a User Account

  1. Manage Your Network
    · Connecting to a Network
    · Creating a Home group
    · Working with a Home group
  • Sharing Files on Your Network

4. Navigate Windows and Folders
· Working with Windows
· Understanding Files, Folders, and Libraries
· Finding Your Way around Your Computer
· Connecting to Network Resources
· Finding Specific Information

5. Manage Folders and Files
· Viewing Folders and Files in Different Ways
· Working with Folder and File Properties
· Creating and Renaming Folders and Files
· Moving and Copying Folders and Files
· Deleting and Recovering Folders and Files
· Creating Shortcuts

1. Explore Word
· Working in the user interface
· Creating, editing text and saving documents
· Opening, moving around in and Closing Documents
· Viewing documents in different ways
· Accessing help feature

2. Editing and Proofread Text
· Making text changes
· Office clipboard
· Find and replace text
· Fine-tuning text
· Correcting spelling and grammatical errors
· Viewing document statistics
· Inserting saved text
· Inserting one document into another

3. Changing the Look of Text
· Quickly formatting text
· Changing a documents theme
· Manually changing the look of characters
· Manually changing the look of paragraphs
· Character formatting and case considerations
· Find and replace formatting
· Creating and modifying lists
· Formatting text as you type

4. Organizing Information in Columns and Tables
· Presenting information in columns
· Creating tabbed lists
· Presenting info in table’s
· Performing calculations in the table’s
· Other layout options
· Formatting tables

5. Add Simple Graphic Elements
· Inserting and modifying pictures
· About ClipArt
· Changing a document background
· Inserting Building Blocks
· Drawing text boxes
· Adding Word Art
· Formatting the first letter of a paragraph

  1. Preview, Print and Distribute Documents
    · Previewing and adjusting page layout
    · Controlling what happens on each page
    · Printing documents
    · Preparing documents for electronic distribution
  1. Creating Diagrams
    · Creating and Positioning a diagram
    · Using the text pane
    · Inserting shapes into a diagram
    · Promoting and Demoting shapes in the diagram
    · Change a diagram’s layout, colours and shapes
    · Use picture diagrams to show photographs
    2. Insert and Modify Charts
    · Insert a chart into a document
    · Customize a chart, and save it as template
    · Plot Excel data in a chart
    · Formatting a chart
    · Changing chart types
    · Adding axis titles and labels
    3. Use other Visual Elements
    · Adding text and graphic watermarks
    · Insert a symbol
    · Building an equation and add it to the equation
    gallery
    · Draw and manipulate shapes
    · Insert a screen clipping
    4. Organize and Arrange Content
    · Reorganize a document but adjusting its outline
    · Arranging multiple pictures
    · Insert and format nested tables
    5. Creating Documents for Use Outside of Word
    · Save files in different formats
    · Creating and modifying web documents
    · Create and publish blog posts

1. Explore More Text Techniques
· Adding hyperlinks
· Inserting fields
· Adding Bookmarks and Cross References
2. Use Reference Tools for Longer Documents
· Adding Footnotes and End notes
· Creating and Modifying Table of contents
· Table of figures
· Table of Authorities
· Creating and modifying indexes
· Adding Sources and compiling bibliographies
· Creating Master Documents
3. Work with Mail Merge
· Understanding Mail Merge
· Preparing Data Sources
· Using an Outlook Contact List as a Data Source
· Preparing Main Documents
· Merging Main Documents and Data Sources
· Printing Envelopes
· Sending Personalized Emails to Multiple
Recipients
· Creating and Printing Labels
4. Collaborate on Documents
· Co-authoring Documents
· Sending Documents Directly from Word
· Adding and Reviewing Comments
· Tracking and Managing Documents Changes
· Comparing and Merging Document Changes
· Password-Protecting Documents
· Restricting Who Can Do What to Documents
· Controlling Changes
5. Working in Word More Efficiently
· Working with Styles and Templates
· Default Program Options
· Customizing the Ribbon
· Customizing the Quick Access Toolbar
· Macros in Word

  1. Setting up a workbook
    · Creating Workbooks
    · Modifying Workbooks and Worksheets
    · Customizing Excel

    2. Working with Data and Excel Tables
    · Entering Data
    · Copy, Cut and Paste
    · Pick from the drop-down list
    · Find and Replace data
    · Spell Check
    · Thesaurus
    · Defining an Excel Table
    · Basic Formulas
    · Basic Functions

    3. Changing Workbook Appearance
    · Format Cells
    · Themes
    · Format Numbers as a percentage, currency and
    general
    · Insert a Picture
    · Picture Styles, remove background, picture
    effects
    · Insert Background
    4. Printing
    · Inserting Headers and Footers
    · Print Preview
    · Page Setup
    · Page break preview
    · Print active worksheets
    · Print entire workbook
    · Print Selection
    · Print titles
    · Set Print Area
    · Centre data on the page

  1. Performing Calculations

Naming groups of Data using Named Ranges
Creating Formulas to Calculate Values
Summarizing data meets specific condition
Using If function
Formula Auditing

2. Changing workbook appearance
· Defining Styles
· Making Numbers easier to read
· Transposing data
· Changing Cell Orientation and Merging Cells
· Change appearance of data based on its value
· Focusing on specific data by using filters
· Data Validation
3. Reordering and Summarizing Data
· Sort Data
· Custom Lists
· Organizing data into levels using subtotals
· Creating an outline
· Lookup Functions
4. Combining Data from Multiple Sources
· Using Excel’s Built-in Templates
· Using workbooks as templates for other
workbooks
· Linking to data in other workbooks
· Consolidating data
· Saving workbooks as a workspace
· Comments in cells and workbooks
· Protection
· Track Changes
· Mark a workbook as final

1. Explore PowerPoint
Working with the user interface
Creating and saving presentations
Compatibility with earlier versions
Opening, Moving around in, and closing
presentations
Viewing presentations in different ways


2. Working with Slides
Adding and Deleting Slides
Adding slides with ready-made content
Slide Libraries
Exporting presentations as outlines
Dividing presentations into section
Rearranging slides and sections


3. Working with Slide content
Entering text into placeholders
Adding text boxes
Changing the default font for text boxes
Editing text
Clipboard
Correcting and sizing text while typing
Checking spelling and choosing the best words
Research information
Find and Replacing text and fonts


4. Format Slides
Applying themes
Using different theme colours and fonts
Changing the slide background
Changing the look of placeholders
Changing the alignment, spacing, size and look
of text


5. Add Simple Visual Enhancements
Insert Picture and ClipArt images
Inserting Diagrams
Graphics formats
Converting existing bullets into a diagram
Inserting charts
Inserting shapes
Connecting Shapes
Adding transitions


6. Review and Deliver Presentation
Setting up a presentation for delivery
Previewing and Printing Presentation
Preparing speaker notes and Handouts
Enhanced Handouts
Finalizing Presentation
Setting up presenter view
Delivering a presentation

1. Add tables
Inserting tables
Formatting tables
Inserting and updating excel worksheets


2. Fine Tune Visual Elements
Editing pictures
Customizing Diagrams
Formatting Charts
Arranging Graphics
Alt Text


3. Add Other Enhancements
Adding WordArt Text
Inserting Symbols and Equations
Insert Screen Clipping
Creating Hyperlinks
Attaching the same hyperlink to every slide
Attaching actions to text or objects

4. Add Animation
Using Ready-Made Animation
Customizing animation effects

5. Add Sound and Movies
Inserting and playing Sounds
Inserting and playing Videos
Inserting videos from web sites

6. Share and Review Presentations
Collaborating with other people
Broadcasting presentations
Saving presentations in other formats
Sending presentations directly from PowerPoint
Password Protecting Presentations
Adding and Reviewing Comments
Merging presentations versions

7. Create custom Presentation elements
Creating theme colours and fonts
Viewing and changing slide masters
Creating slide layouts
Saving custom design templates

8. Prepare for Delivery
Adapting presentations for different audiences
Rehearsing presentations
Recording presentations
Preparing presentations for travel
Saving presentations as videos

9. Customize PowerPoint
Change default program options
Customizing the ribbon
Customizing the Quick Access Toolbar

1. Get started with Outlook
Connecting to Email Accounts
Connecting to Hotmail account
Troubleshooting Connection Problems
Connecting to Exchange Accounts
Connecting to internet Accounts

2. Explore the Outlook Window
Working with the Outlook Program Window
Outlook Program Window
Outlook Modules
Working with the Ribbon and Backstage View
Backstage View
Modules and Item tabs
Working in the Mail Module
Navigation Pane Content
Mail Module Views
The Ribbon
Message Windows
Working in the Calendar Module
Calendar Module Content
Calendar Item Window
Working in the Contacts Module
Contacts Module Content
Contact Record Window
Working in the Tasks Module
Task Module Content
Task Window

3. Send and Receive E-Mail Messages
Creating and Sending Messages
Addressing Messages
Troubleshooting Message Addressing
Entering Content
Saving and Sending Messages
Attaching Files to Messages
Troubleshooting File
Types and Extensions
Viewing Messages and Message Attachments
Viewing Conversations
Configuring Reading Pane Behaviour
Viewing Reading Pane Content
Marking Messages as Read
Single Key Reading
Viewing Message Participant Information
Presence Icons
Contact Cards
The People Pane
Responding to Messages

4. Store and Access Content information
Saving and Updating Contact Information
Creating Contact Records
Address Books
Communication with Contacts
Initiating contact information from contact
records
Selecting message recipients from Address
Books
Displaying different views of Contact Records
User Defined Fields
Printing Contact Records

5. Manage Scheduling
Scheduling and Changing Appointments
Adding National Holidays to Calendar
Creating an appointment from a message
Scheduling and Changing Events
Scheduling Meetings
Updating and Cancelling Meetings
Responding to Meeting Requests
Displaying Different Views of a Calendar
Views
Arrangements
Using the Date Navigator

6. Tracking Tasks
Creating Tasks
Creating tasks from scratch
Task options
Creating tasks from Outlook items
Updating tasks
Removing tasks from the task list
Managing Task Assignments
Tasks you assign to others
Tasks other people assign to you

1. Manage Email Settings
Working with New Email Notifications
Creating rules to process messages
Blocking Unwanted Messages
Working with Junk Email Messages
Configuring Junk Email Options
Securing Your Email
Digital Signatures
Encryption
Plain Text Messages
Information rights management’
Blocking External Contents to Protect Your
Privacy.

2. Work Remotely
Working with outlook items while offline
Public Folders
Setting Cached Exchange Mode Options
Managing Download Options for slow
connections
Choosing to work offline
Managing an Offline address book
Automatically replying to messages

3. Customizing Outlook
Personalizing the Outlook environment
Creating and Managing Quick Steps
Customizing the Ribbon
Customizing the Quick Access Toolbar
Customizing the Status Bar
Personalizing the Office and Outlook Settings
Mail
Calendar
Contacts
Tasks
Notes and Journal
Search
Mobile
Language
Advanced
Add-ins
Creating Outlook Forms

4. The Notes and Journal folders
Notes
Creating notes
Forwarding
Customizing Notes

1. Internet Introduction
How Does the Internet Work?
A Tour of a Typical Website


2. Browser Basics
Using Multiple Windows
Using Tabs
Using the Search Box
Downloading
o Saving pictures and files
o Using a Download Manager
Printing a webpage

3. Internet Explorer
Menu Bar
Change your home page
To add a new search provider
To empty the Temporary Internet Files folder
(cache)
Clear the browsing history
To save a webpage onto your computer
Bookmarks

4. Searching
Search Engines
Finding what you need
Useful websites

5. Internet Safety
Storing your passwords and login details
Allowing and blocking pop-ups
InPrivate mode
Parental Controls
Viruses and Trojans

how can we help you?

Contact us at the ChangeTech office nearest to you or submit a business inquiry online.