Nothing Special   »   [go: up one dir, main page]

0% found this document useful (0 votes)
270 views6 pages

Notes: (Office Automation Tools)

Download as pdf or txt
Download as pdf or txt
Download as pdf or txt
You are on page 1/ 6

OAT (OFFICE AUTOMATION TOOLS)

NOTES
MICROSOFT OFFICE
Why Ms. office was needed?
 Microsoft Office was created to automate the manual office work with a collection
of purpose-built applications.
 It was first created for MAC Operating system in 1989. And first version for windows
was created in 1990
 It contains variety of applications for creating text documents, spreadsheets,
presentations, databases and many others.
 Different application has existed before the Ms. Office which were used in the office
work.
 In the early 1990s, Microsoft decided to provide all the applications bundled in one
suite. They named this software as Microsoft office.
 Many versions have been made for the computers running windows operating
system and Apple’s MAC operating system.

A Few of the Applications in MS Office and Their Purpose:


Microsoft Word: Helps users in creating text documents.
Examples: letter, application, cv, memo, Research paper etc.
Microsoft Excel: Creates simple to complex data/numerical spreadsheets.
Examples of spreadsheets can be employee salary sheet, daily expense sheets, student
attendance sheet, budget sheet, invoices etc.

Microsoft PowerPoint: Stand-alone application for creating professional


multimedia presentations. Presentations can be about lectures, ideas, products etc.

Microsoft Access: Database management application. A database is structured set


of data. Database let you store data in a logical way.

Microsoft Publisher: Introductory application for creating and publishing


marketing materials. Postcards, flyers, invitation cards and brochures and many other
things can be created with Publisher.
Microsoft OneNote: Alternate to a paper notebook, it enables user to neatly
organize their notes. You can create notes to remember your routine and or any other
task related to your office work.
File Format:
File format defines the type of information a file contains. Format of the file is identified
by the extensions of the file after the name of the file and icon that represents the
software used to open it.

File Extension: a string of characters attached to a filename, usually preceded by a


full stop and indicating the format of the file.
 Extension of MS Word file is .docx.
 Extension of MS Excel is .xlsx.
 Extension of the MS PowerPoint file is .pptx.
Microsoft Word is a word processor created by Microsoft on October 25, 1983. It is one
of the applications of Microsoft suite. Word is used to create documents, either you can
start with blank or with template similar to all other Microsoft Applications. Documents
to create: resume, cover letters, flyers,

 Text and tables formatting and styling.


 Tables of contents, chapters, sections etc. for report structuring and navigation.
 Image insertion and editing.
 Charts - e.g. charts linked to other Microsoft software such as Excel etc.
 Mail options for mail merges.
 Review features - allowing you to review a document and add markup and edits to
highlight amendments to the author.
 Built in themes for different types of documents are present online and offline for
Ms. Word.
 Proof reading for grammar and spellings and built thesaurus are available
 Find and Replace
 Hyperlinks
 Header and footer.
 Citations and bibliography
 Picture captions
 Notes in a document
 Setting layout of the page is easier for the purpose of printing.
 Word provides different views for the document and lets you work with multiple
documents at once.

 The Quick Access Toolbar is located above the Ribbon and contains
commands that users access most often.
 By default, the Save, Undo, and Repeat commands display when you
launch Word.
 You can customize the contents of the Quick Access Toolbar by clicking the
dropdown arrow on the right side of the toolbar and choosing options from
the menu that appears.
 Microsoft Excel is a spreadsheet program.
 Excel is used to record and analyze numerical data.
 A spreadsheet is the collection of columns and rows that form a table.
 Alphabetical letters are usually assigned to columns.
 Numbers are usually assigned to rows.
 The point where a column and a row meet is called a cell.
 The address of a cell is given by the letter representing the column
and the number representing a row.
 Example A2 is the 2nd cell of the column A.
 A workbook is a collection of worksheets.
 By default, the sheets are named Sheet1, Sheet2 and so on.

You might also like