Microsoft Office is an office suite of interrelated desktop applications, servers and services for the Microsoft Windows and Mac OS X operating systems. Microsoft Office was introduced by Microsoft in 1989 for the Mac OS,[1] with a version for Windows in 1990.[2] Initially a marketing term for a bundled set of applications, the first version of Office contained Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Additionally, a "Pro" (Professional) version of Office included Microsoft Access and Schedule Plus. Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, OLE data integration and Microsoft Visual Basic for Applications scripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications (OBA) brand.
APPLICATIONS:
Microsoft Word
and its SP2 update will support Microsoft Word is a word processor and was previously considered to be the main program in Office. Its proprietary DOC format is considered a de facto standard, although Word 2007 can also use a new XML-based, Microsoft Office-optimized format called .DOCX which has been standardized by ECMA as Office Open XMLODF and PDF. Word is also available in some editions of Microsoft Works. It is available for the Windows and Mac platforms. The first version of Word, released in the fall of 1983, was for the DOS operating system and had the distinction of introducing the mouse to a broad population. Word 1.0 could be purchased with a bundled mouse, though one was not required. The following spring Apple introduced the Mac, and Microsoft released Word for the Mac, which became the most popular Mac application and which, like all Mac apps, required the use of a mouse.
Microsoft Excel
Microsoft Excel is a spreadsheet program. It was originally a competitor to the dominant Lotus 1-2-3, but it eventually outsold it. It is available for the Windows and Mac platforms. The current Mac version (Office 2008) has removed Visual Basic functionality so macros cannot be used and those generated in previous iterations of Office no longer work. Microsoft announced in May 2008, that Visual Basic would be returning to Excel in future versions.
Microsoft Outlook/Entourage
Microsoft Outlook, not to be confused with Outlook Express, is a personal information manager and e-mail communication software. The replacement for Windows Messaging, Microsoft Mail and Schedule+ (Plus) starting in Office 97, it includes an e-mail client, calendar, task manager and address book. Although historically it has been offered for the Mac, the closest to an equivalent for Mac OS X is Microsoft Entourage, which offers a slightly different feature set.
Microsoft PowerPoint
Microsoft PowerPoint is a popular presentation program for Windows and Mac. It is used to create slideshows, composed of text, graphics, movies and other objects, which can be displayed on-screen and navigated through by the presenter or printed out on transparencies or slides. This is convenient for school or work presentations.Office Mobile for Windows Mobile 5.0 and later features a version of PowerPoint called PowerPoint Mobile. Movies, videos, sounds and music, as well as Wordart and Autoshapes can be added to slideshows.
Other desktop applications (Windows version only)
- Microsoft Access – Database manager.
- Microsoft Publisher – software for creating newsletters, business cards, flyers, greeting cards or postcards.
- Microsoft InfoPath – an application to design rich XML-based forms.
- Microsoft OneNote – Note-taking software for use with tablet PCs or regular PCs.
- Microsoft Office SharePoint Designer – a WYSIWYG HTML editor and web design program for customizing SharePoint applications, it replaces Microsoft Office FrontPage (it is not bundled in any Office 2007 suite).
- Microsoft Project – Project management software to keep track of events and to create network charts and Gantt charts (it is not bundled in any Office 2007 suite).
- Microsoft Visio – Diagram and flowcharting software (it is not bundled in any Office 2007 suite).
- Microsoft Office Accounting – a tool for managing business finances (it is not bundled in any Office 2007 suite, except for the Express edition).
- Microsoft Office Communicator – Integrated communications client for conferences and meetings in real time (it is bundled with Office 2007 Professional Plus and Enterprise 2007.
- Microsoft Office Document Imaging – an application that supports editing scanned documents.
- Microsoft Office Document Scanning – a scanning and OCR application.
- Microsoft Office Groove – a proprietary peer-to-peer collaboration software leveled at businesses.
- Microsoft Office InterConnect – Business-relationship database available only in Japan.
- Microsoft Office Picture Manager – Basic photo management software (similar to Google's Picasa or Adobe's Photoshop Elements). Replaced Microsoft Photo Editor.
Basics of Microsoft Word (MS Word)
File:
The collection of records is called file
New:
This is used for taking a new blank document.
Open:
For opening the already saved files
Close:
For closing the existing document
Save: For storing our document in the hard disk.
Save as: When ever we wanted to change the existing file name or location.
Exit: For closing the whole Ms word Application.
Edit:
Edit is used for changing the formats or placements of text.
Undo:
Reverse the last command.
Redo:
This command repeats the undo command.
Cut:For changing the placement of text in a document
Copy:
For copying text, paragraph.
Paste:
Inserts the copied or cut text or objects
Clear:
To remove the selected object or text
Select all:
For selecting all the text and object in a document
View:
Appearance of the document
Print layout:
Prepares the page ready for printing
Ruler:
Shows both horizontal and vertical Rulers, which are used for limitations
Full Screen:
To show our document in the whole screen
Insert:
It’s used for adding files, objects, charts, pictures
Date and time:
For inserting date and time in your document
Picture:
For adding pictures and shapes in the document
Text Box:
For inserting text provided limited area.
File:
For adding other office files to our existing document
Format
This menu is used for changing the formats and styles of text.
Font:
For selecting font styles, sizing, colors and effects.
Bullets & Numbering:
Is used for specifying a line or paragraph
Background:
For changing the color of the background in the existing document
Theme:
For applying already made Background, styles etc.
Tools:
This menu is used for Spelling & Grammar, Word Counting etc.
Spelling & Grammar:
This is used for checking the spelling and grammar of your existing document.
Word Count:
This is used for counting the lines, words, paragraphs and characters in your document.
Table:
For generating or creating a table in your document
raw Table:
For drawing or creating a table manually.
Insert:
For creating a table through giving range.
Delete:
To remove or clear a table(cell, row, column) from a document.
Select:
For selecting a table, row, column and cell.
Window:
This menu is used for Arranging, splitting our documents
New window:
This is used for taking the copy of the existing document as a duplicate.
Arrange All:
For arranging our documents in screen.
Dividing the window in panes
Help:
To solve the problems related to a topic in a document.
Microsoft word help:
Assistance providing by Microsoft
What’s This:
For getting information about a specific topic
About Microsoft Word:
To show all the information about this program, product license agreements
Toolbars:
To make the environment easier for the user so we can display useful toolbars
Standard:
The first standard toolbar in the tools used for displaying different options.
Example: Saving, Opening, Cutting, Pasting etc in a short way
To find out about other options available of the toolbar, take you mouse on each, do not click and just read text that appears for each option.
Basics of Microsoft Excel (MS Excel)
File
It is the first menu of MS EXCEL.
New:
This is used for taking a new blank document.
Open:
For opening the already saved files
Close:
For closing the existing document.
Save:
For storing our document in the hard disk.
Save as:
When ever we wanted to change the existing file name or location.
Exit:For closing the whole Ms excel Application.
Edit
Edit is used for changing the formats or placements of a text.
Undo:
Reverse the last command.
Redo:
This command repeats the undo command.
Cut:
For changing the placement of text in a worksheet.
Copy:
For copying text.
Paste:
Inserts the copied or cut text or objects
Clear:
To remove the selected object or text
Delete Sheet:
Removal of complete sheet
Paste:
Inserts the copied or cut text or objects
View
Appearance of the document
It is a default format for most of the tasks like entering data, charting and formatting.
Formula bar:
They show the current formula.
Status bar
They show current status of the page
Full Screen:
To show our document in the whole screen
Insert
The addition of thing like cells, columns, worksheet and picture
Cell
The combination of rows and columns to make an individual basic unit
Column
The vertically Gridlines which are started from A1 ended with IV.
Row
Horizontal gridlines is called row.
Worksheet
The working area of Ms excel page in which editing, calculation are included.
Picture
The addition pictures and text shapes in the document.
Format
To make the outlook of a page like font style, row and column adjustment.
Cells
They adjust the cell number, alignment, font, border and patterns.
Row
We can adjust row height, auto fit, hide and unhide.
Column
We can adjust column width, auto fit selection, hide and unhide
Sheet
We can change the appearance of the sheet like rename, hide and unhide.
Style
They show all the formats applied on the worksheet.
Tools
This menu provides different options like spelling check, protection etc.
Spelling & Grammar
This is used for checking the spelling and grammar of your existing document.
Share workbook
In this more than one person can contribute in it or change it.
Protection
We can protect sheet, workbook and shared workbook.
Data
Sorting
Arrange the information like alphabets, numbers in selected rows.
Filter
The quickest way to select those items that you want to display in the list.
Table
Table is based on the input values and information & also shows the changes in the database.
Text columns
To convert selected text to a table
Window
This menu is used for Arranging, splitting our documents
New window
The creation of a copy of active window to view different parts at the same time.
Arrange all
Display all the opened files and arrange in a specific format so that dragging can easily be done.
Hide
To hide the window temporarily.
To divide active window into panels
Help
To solve the problems related to a topic or functionality in a Workbook.
Microsoft Excel help (F1)
Assistance provided by Microsoft.
Microsoft Excel help (F1)
Assistance provided by Microsoft.
What’s This?
Information about a specific topic and its functionality
Office on the web
You can take information from Internet to solve your problems.
Detect and repair
This process automatically detect and also trying to repair your errors.
Basics of Microsoft PowerPoint
(MS PowerPoint)
The picture on the right shows the view once you open MS PowerPoint.
Auto content wizard
It is a process through which we can make presentation automatically.
The computer will guide the user through every step to make a presentation.
Design template
Design templates contain predestined formats, styles and color schemes you can apply to any presentation to give it a particular look.
Blank presentation
This type of presentation is completely blank so we can make it on our own choice.
Open an existing presentation
When we want to open an already existing file or presentation to do some changes or enhancement in it.
Slides Types
User can select different type of slides from the following layouts
File
It is the first menu of power point
New:
This is used for taking a new blank presentation page.
Open:
For opening the already saved files or presentation.
Close:
For closing the existing document.
Save:
For storing our presentation in the hard disk.
Save as:
When ever we wanted to change the existing file name or location
Exit:
Using for closing the whole MS POWER POINT Application.
Edit
Edit is used for changing the formats or placements of a text.
Undo:
Reverse the last command.
Redo:
This command repeats the undo command.
Cut:
For changing the placement of text in a slide.
Copy:
For copying text.
Paste:
Inserts the copied or cuted text or objects.
Clear:
To remove the selected object or text.
Delete slide:
Removal of complete slide
View
Appearance of the slide
Normal
It is a default format for most of the tasks like entering data, charting and formatting slide.
Slide sorter
This process shows all slides, text and graphics. It also provides the ability to reorder slides, animation of slides and set timing for electronic slide show.
Slide show
Displays slides in full screen mode in the order specified by user.
Ruler
Specifies the horizontal and vertical position in the slide to user.
Zoom
This option provide full screen to the user.
Insert
The addition of Objects, Slides, charts, tables, pictures…
New slide:
Taking a new slide in your presentation.
Duplicate slide
Taking a similar copy of the current or active slide.
Slides from File
Taking an already made slide from another presentation to current presentation.
Picture
For adding pictures and shapes in the Slide.
Text Box
For inserting text provided limited area.
Table
Inserting a user-defined table in the slide.
Format
This menu is used for changing the formats and styles of text.
Font
For selecting font styles, sizing, colors and effects.
Alignment
To adjust the text in the slide (left, right, center)
Background
Sets background picture, color and texture.
Apply Design Template
Apply pre-defined templates of PowerPoint in the slide
Tools
This menu is used for spelling & Grammar
Spelling & Grammar
Used for checking the spelling and grammar of existing slide.
Language
If a user uses more then one language then they define the language for that slide.
Slide Show
In this menu we can apply animations and timings in a full screen mode to our slide.
View Show
Running our slide in full screen mode in specific order.
Rehearse Timing
User can apply timing to each slide in a presentation.
Hide Slide
Those slide which users don’t want to display in the slide show.
Window
This menu is used for Arranging, Fitting slides…
New window
This is used for taking the copy of the existing Presentation as a duplicate.
Arrange All
Arranging our Presentations in screen
Help
To solve the problems related to a topic or functionality in a Presentation
Microsoft PowerPoint Help (F1)
Assistance providing by Microsoft.
What’s This?
Information about a specific topic and its functionality.
Office on the web
You can take information from Internet to solve your problems.
Detect and repair
This process automatically detect and also trying to repair your errors
Microsoft Access (MS Access)
Blank access database
This option is used for making a new database.
Access Database wizards, Pages, and projects
This option is used for making pages, projects and etc through wizard.\
Open an existing file
We can open already saved file through this option.
Table
Objects
Table, Query, Forms, Report, Pages, Macro, Module.
Database shortcuts
Create table in design view
We can create our tables by designing them manually.
Create table by using wizard
We can create our tables by using wizards.
Create table by entering data
We can enter our data by entering them in a list.
Query
To communicate with the program through a specific language.
Create query in design view
Create a query by specifying the input tables/queries field names filters and sorting.
Create query by using wizard
The computer asks questions and creates a query for the user.
Forms
Create form in design view:
Create a form manually (specifying the record source, control and control properties).
Create form by using wizard
Creating form through wizard options (prompts and asks questions from user).
Report
Taking print outs of the database on daily bases
Create report in design view
Create a report manually (specifying the record source, control and control properties).
Create report by using wizard
Creating a report through wizard options (prompts and asks questions from user).
Pages
User can create a page from the database that accessed effectively.
Create data access page in design view
Create a data access page manually (specifying the record source, control and control properties).
Create data access page by using wizard
Creating data access page through wizard options (prompts and asks questions from user).
Edit web page that already exists
Adding the already present web page in the data access page
Macro
A macro is a set of one or more actions that each performs a particular operation like opening a form or printing a report
Module
A module is a collection of Visual Basic Applications declarations and procedures that are stored together as a unit.
File
It is the first menu of MS ACCESS.
New
This is used for taking new databases.
Open
For opening the already saved files
Close
For closing the existing database.
Save
For storing our database in the hard disk
Save as
When ever we wanted to change the existing file name or location
Exit
For closing the whole Ms Access Application
Edit
Edit is used for changing the formats or placements of a text.
Undo
Reverse the last command.
Redo
This command repeats the undo command.
Cut
For changing the placement of text in a worksheet
Copy
For copying text
Paste
Inserts the copied or cut text or objects
Delete
The removing of any thing from the database like (text, rows and column)
View
Appearance of the document
Table
Create a new table in datasheet view.
Query
Create a new query without using wizard.
Form
Create a new form without using wizard.
Report
Create a new report without using wizard.
Page
Create a new data access page without using wizard.
Macro
How the user apply a set of actions on different operation like on column, rows etc.
Module
They are used to perform actions on operations in MS visual basic.
Tools
This menu is used for Spelling & Grammar…
Spelling & Grammar
This is used for checking the spelling and grammar of your existing document.
Security
They are used to secure the database by using passwords, permissions, encryption or decryption.
Macro
They are used for coding in MS Visual Basic for a particular action.
Window
This menu is used for tile horizontal, tile vertical and arranges icons.
Tile horizontal
They arrange MS Access window is horizontal pane that all windows are visible and cannot overlap each other
Tile vertical
They arrange MS Access window is vertical pane that all windows are visible and cannot overlap each other.
Arrange icon
They arrange all icons of database windows.
Hide
User can hide the current window.
Unhide
User can remove the hide option to see the window.
Help
To solve the problems related to a topic or functionality in a Presentation
Microsoft Access Help (F1)
INTERNET
How to use Internet
BACKGROUND
· The Internet as we know it today began around 1969 with ARPANet, a network created by the United States Department of Defense Advanced Research Projects Agency.
· Originally connecting four universities, the network allowed scientists across the country to share information and resources through their computers.
· In 1983, ARPANet decides to use TCP/IP as a standard protocol for all computers connected to the network to talk to each other.
· In 1993, the World Wide Web (www) came into being.
· World Wide Web uses hypertext transfer protocol (HTTP) and hypertext links that change the way information can be organized, presented and accessed on the Internet.
WHAT IS THE INTERNET?
· The Internet also referred to as the Net, Information Superhighway, or Cyberspace, is the largest electronic network which enables computers connected to the network to share data and resources
· The Internet is not owned by any one organization but rather made up of individual networks which own their own servers (to hold the data) and routers and switches (to allow users to access the data).
WHAT IS A URL?
· Just like every house has a unique address, each web page has a unique address, called a Uniform Resource Locator (URL).
· The first part of the address indicates what protocol to use, and the second part specifies the IP address or the domain name where the resource is located.
· The remaining information identifies specific directories or files within the domain.
· You can display a web page by simply typing its URL into the address line of your web browser (a program or application that uses internet).
· The most popular domain extension is .com for commercial websites. Other extensions include .org for non-profit organizations, .edu for educational institutions, or .gov for governmental sites.
WHAT IS A HTML?
· HTML is short for Hyper Text Markup Language, the language used to write or create documents on the World Wide Web.
· HTML defines the structure and layout of a Web document by using a variety of tags and attributes.
WHAT IS A BROWSER?
· The term browser is short for Web browser, a software application used to locate and display Web pages. The most popular browser is Microsoft Internet Explorer.
THE ISP (Internet Service Provider)
· Your ISP is the gateway (or middleman) that provides connection to the Internet.
· An ISP provides cables, fiber optic, and telephone lines along which data can travel between computers.
· In
OPENING THE INTERNET BROWSER
To open your browser and see all that the World Wide Web has to offer:
· Double-click the Internet Explorer Icon on your desktop
OR
· Choose Start > Programs > Internet Explorer
FEATURES OF A BROWSER WINDOW
TITLE BAR
· It displays the name of the program (Internet Explorer), and the name of the web page.
MENU BAR
· As in all windows-based programs, click a word on the menu bar to display a menu of additional program commands.
STANDARD BUTTONS
· Navigational buttons that aid in viewing, searching, saving and printing web pages.
ADDRESS BAR
· Display the current web page’s URL.
· You can also type a URL into the Address bar and press Enter/Return to view the URL.
PAGE AREA
· The portion of the window that displays web pages
LINKS BAR
· You can use it to add web pages that you visit often.
STATUS BAR
· The status bar has two uses: first it notifies you of the status of loading web pages, and second, the status bar displays the security level
VIEWING TOOLBARS
To display or hide toolbars, choose View > Toolbars and make your selection.
OTHER BROWSER CHARACTERISTICS
· To change the text size, choose View > Text Size and select an option from the submenu
· To change the default font or colors, choose Tools > Internet Options and click the Font or colors buttons on the General tab. Click OK to save the changes.
· To change all fonts and colors, choose Tools > Internet Options and click the Accessibility button. Click OK to save the changes.
Browser standard buttons
· Click the Back button to move to the previously viewed web page Or
· Click the arrow next to the icon to choose any of the previously viewed web pages.
· Refresh button is used to refresh a web page
· Home button is used to go to home page (your default web page)
· Stop button is used to cancel the action of downloading or opening a web page.
· The Search button is used to enter appropriate information and search for it.
· Click the Favorites button to display your list of favorites. You can organize, edit, delete, or view your favorite web pages
· Click History button to get a list of dates and pages viewed on those dates. Click a page and it should appear in the page area.
Other actions for Internet Web Browser include:
· SETTING THE HOME PAGE
· ADDING FAVORITES
· VIEWING A FAVORITE
· ORGANIZING FAVORITES
· SEARCHING OVER THE INTERNET
KEYWORDS
· Most recent browser versions allow you to type keywords into the Address bar, press Enter and the browser itself acts as a search engine.
INTENET EMAIL USING YAHOO
· Yahoo is a facility to open and maintain an E-Mail Account in Internet without paying additional charges.
· The cost is covered within Internet usage charges.
· Yahoo is a web site. To access Yahoo, you must have an Internet connection.
HOW TO OPEN YAHOO ACCOUNT
· Open Internet Explorer Type www.Yahoo.com (in Address Bar) and press Enter
· Click Sign UP now! After some moments, you will see terms and conditions. This is a long page. At the end of the page, click I Accept
YAHOO MAIL REGISTRATION FORM
· You will see a registration form. Follow the instructions of your trainer and fill up carefully. Do not leave any column blank.
· Make sure to remember your Username and Password as these are the two you will use in future to open your email account.
HOW TO ACCESS YAHOO ACCOUNT
· Open Internet Explorer and type www.Yahoo.com (in Address Bar) and press Enter.
· On the yahoo web page, click on Mail using your mouse.
· Type Yahoo ID or Username and Password in the specified boxes and click Sign In or press Enter
· Now click Continue (at the end of the page) that appears when you have signed in for the first time.
· Yahoo will take you to your Inbox. You will see a message from Yahoo Staff. Click Yahoo Staff
HOW TO SEE IN-COMING MAIL
· When you are given access to your Yahoo Account, you are in your Inbox. You can see the list of in-coming messages.
· To read the message, click on relevant message under the heading FROM
HOW TO PREPARE NEW MESSAGE
· To prepare new message: Click New / Compose
· Type E-Mail Address (correct and complete address of the person to whom you want to send mail).
· Click in Subject box Type Subject (Do not leave TO box and Subject box blank) Click in the main box.
· Type the message. Type your name at the end of the message
HOW TO SEND E-MAIL MESSAGE
· After preparing E-Mail message: Click Send from Toolbar above. You will have the following message:
Sent Message Confirmation
Your message has been sent to the following recipients:
emailaddress@yahoo.com
· Click OK
· You will come back to your Inbox
HOW TO SEE SENT MESSAGE
· While you are in Inbox: Click Folders Sent Messages You can also see Drafts (if you have clicked Save Draft in Compose Window).
HOW TO ATTACH A FILE WITH E-MAIL MESSAGE
· You can attach a file (available in your computer) with your E-Mail-mail message. After typing the message:
· Click Attachments and then click Browse. (Select folder .and double click the relevant file)
· Attach to Message and then click DONE
· The file will be attached with your message. Now: Click SEND.
OPEN A FILE ATTACHED TO A MESSAGE IN YOUR INBOX
· Once you open the email, click on the file name that is attached to the message.
· Click Download Attachment
· Click Open or Save to take necessary action for the concerned file.
HOW TO DELETE MESSAGE FROM INBOX
· When the Inbox is open, click in the small box on left of the message(s), which you want to delete. Now: Click Delete.
HOW TO SEE DELETED MESSAGES
· Deleted Messages are stored in Trash Can automatically. To see deleted messages:
· Click Trash Can.
HOW TO MAINTAIN ADDRESS BOOK
· You can maintain address book in Yahoo. This will save your time in typing addresses in Compose Window.
· For this: Click Addresses and Create New.
· Type particulars of the addressee carefully (you can leave some columns blank)
· Click OK In future, when you want to send E-Mail to any person from Address Book: Click Addresses, Click -on the relevant address, under the heading Mail to: Compose Window (with address typed) will open automatically. T
· To delete an address: Click Delete in front of the address (and wait for some moments) Click Delete again
HOW TO CHANGE PASSWORD
· Click Options and then Password. In relevant boxes: Type Old Password and then type New Password. Then type New Password again. You will have the following message:
PASSWORD CONFIRMATION
Your Password has been successfully changed. Please remember your new Password.
HOW TO CLOSE YAHOO
· Click x at top right comer. Internet Explorer will also be closed.
HOW TO SIGN OUT
