Excel is a

v Microsoft Excel is a spreadsheet application used to process business and financial transactions of various kinds. It is important to know and analyze the application as a software product and as a Windows application.

Excel , a product of Microsoft , is an immensely powerful , popular and easy-to-use spreadsheet package which integrates worksheet , graphics , and database management to a single program. It has a comparative large worksheet to do calculation both scientific & financial.

Excel orga

Ø To carry its various tasks, Microsoft Excel organizes each one of its workbooks into worksheets. You can have just one worksheet in a workbook or you can have a lot of worksheets in a workbook.

Excel etc

Typical uses are financial records, scientific analysis and database tasks. The essence of a worksheet is the ability to input formula among the rows & columns of numeric data. In software market there are many brands of spreadsheet packages available. E.g: VisiCalc , SuperCalc , Symphony , Multi – Plan , Spread load , Lotus 1-2-3 , Microsoft Excel etc.

Excel a

Excel , a product of Microsoft , is an immensely powerful , popular and easy-to-use spreadsheet package which integrates worksheet , graphics , and database management to a single program. It has a comparative large worksheet to do calculation both scientific & financial.

Excel is

v Microsoft Excel is a spreadsheet application used to process business and financial transactions of various kinds. It is important to know and analyze the application as a software product and as a Windows application.

Ms Excel

Microsoft Excel

Introduction

v Microsoft Excel is a spreadsheet application used to process business and financial transactions of various kinds. It is important to know and analyze the application as a software product and as a Windows application.

Excel , a product of Microsoft , is an immensely powerful , popular and easy-to-use spreadsheet package which integrates worksheet , graphics , and database management to a single program. It has a comparative large worksheet to do calculation both scientific & financial.

Typical uses are financial records, scientific analysis and database tasks. The essence of a worksheet is the ability to input formula among the rows & columns of numeric data. In software market there are many brands of spreadsheet packages available. E.g: VisiCalc , SuperCalc , Symphony , Multi – Plan , Spread load , Lotus 1-2-3 , Microsoft Excel etc.

Ø To carry its various tasks, Microsoft Excel organizes each one of its workbooks into worksheets. You can have just one worksheet in a workbook or you can have a lot of worksheets in a workbook.

Excel

Microsoft Excel

Introduction

v Microsoft Excel is a spreadsheet application used to process business and financial transactions of various kinds. It is important to know and analyze the application as a software product and as a Windows application.

Excel , a product of Microsoft , is an immensely powerful , popular and easy-to-use spreadsheet package which integrates worksheet , graphics , and database management to a single program. It has a comparative large worksheet to do calculation both scientific & financial.

Typical uses are financial records, scientific analysis and database tasks. The essence of a worksheet is the ability to input formula among the rows & columns of numeric data. In software market there are many brands of spreadsheet packages available. E.g: VisiCalc , SuperCalc , Symphony , Multi – Plan , Spread load , Lotus 1-2-3 , Microsoft Excel etc.

Ø To carry its various tasks, Microsoft Excel organizes each one of its workbooks into worksheets. You can have just one worksheet in a workbook or you can have a lot of worksheets in a workbook.

Ms Access

Setup and use databases (Microsoft Access)


DATABASE

A database is an object which holds processed & organized data (collection of logically related records of file.)E.g. A list of students names, addresses, in a school database, or A/C number, name, A/C type, balance in bank database etc…

The following diagram shows the structure of a database.




DATABASE --- A collection of Tables, Forms, Reports and Queries.

FILE --- A collection of records.



RECORD --- A row in a table.

FIELD --- A column in a table.

Access

Setup and use databases (Microsoft Access)

DATABASE

A database is an object which holds processed & organized data (collection of logically related records of file.)E.g. A list of students names, addresses, in a school database, or A/C number, name, A/C type, balance in bank database etc…

The following diagram shows the structure of a database.

DATABASE --- A collection of Tables, Forms, Reports and Queries.

FILE --- A collection of records.

RECORD --- A row in a table.

FIELD --- A column in a table.

Power Point

Microsoft PowerPoint

Multimedia Presentation

Multimedia Presentation to go far beyond traditional forms of numeric, text and graphic presentations. Multimedia methods of Presentation give end users information in a variety of media, including text and graphic displays, voice and other digitized audio, photographs and video clips. However, many multimedia systems go beyond one way information presentation.

Terminology

v Text- Written (typed) or printed words, phrases, Sentences, Paragraphs.

v Graphics- Visual symbols-diagrams, drawings, lettering.

v Video- Moving Picture

v Sound-

v Animation- given the appearance of movement

Introduction to Presentation

Presentation graphics enables users to create highly stylized images for slide shows and reports. The software includes functions for creating various types of charts and graphs and inserting for text for text in a variety of fonts. More systems enable you to import data from a Spreadsheet often called business graphics. Some of most popular software are MS Power Point, Lotus freelance graphics, etc

Ms

Microsoft PowerPoint

Multimedia Presentation

Multimedia Presentation to go far beyond traditional forms of numeric, text and graphic presentations. Multimedia methods of Presentation give end users information in a variety of media, including text and graphic displays, voice and other digitized audio, photographs and video clips. However, many multimedia systems go beyond one way information presentation.

Terminology

v Text- Written (typed) or printed words, phrases, Sentences, Paragraphs.

v Graphics- Visual symbols-diagrams, drawings, lettering.

v Video- Moving Picture

v Sound-

v Animation- given the appearance of movement

Introduction to Presentation

Presentation graphics enables users to create highly stylized images for slide shows and reports. The software includes functions for creating various types of charts and graphs and inserting for text for text in a variety of fonts. More systems enable you to import data from a Spreadsheet often called business graphics. Some of most popular software are MS Power Point, Lotus freelance graphics, etc

Ms PowerPoint

Microsoft PowerPoint

Multimedia Presentation

Multimedia Presentation to go far beyond traditional forms of numeric, text and graphic presentations. Multimedia methods of Presentation give end users information in a variety of media, including text and graphic displays, voice and other digitized audio, photographs and video clips. However, many multimedia systems go beyond one way information presentation.

Terminology

v Text- Written (typed) or printed words, phrases, Sentences, Paragraphs.

v Graphics- Visual symbols-diagrams, drawings, lettering.

v Video- Moving Picture

v Sound-

v Animation- given the appearance of movement

Introduction to Presentation

Presentation graphics enables users to create highly stylized images for slide shows and reports. The software includes functions for creating various types of charts and graphs and inserting for text for text in a variety of fonts. More systems enable you to import data from a Spreadsheet often called business graphics. Some of most popular software are MS Power Point, Lotus freelance graphics, etc

Microsoft

Microsoft PowerPoint

Multimedia Presentation

Multimedia Presentation to go far beyond traditional forms of numeric, text and graphic presentations. Multimedia methods of Presentation give end users information in a variety of media, including text and graphic displays, voice and other digitized audio, photographs and video clips. However, many multimedia systems go beyond one way information presentation.

Terminology

v Text- Written (typed) or printed words, phrases, Sentences, Paragraphs.

v Graphics- Visual symbols-diagrams, drawings, lettering.

v Video- Moving Picture

v Sound-

v Animation- given the appearance of movement

Introduction to Presentation

Presentation graphics enables users to create highly stylized images for slide shows and reports. The software includes functions for creating various types of charts and graphs and inserting for text for text in a variety of fonts. More systems enable you to import data from a Spreadsheet often called business graphics. Some of most popular software are MS Power Point, Lotus freelance graphics, etc

PowerPoint

Microsoft PowerPoint

Multimedia Presentation

Multimedia Presentation to go far beyond traditional forms of numeric, text and graphic presentations. Multimedia methods of Presentation give end users information in a variety of media, including text and graphic displays, voice and other digitized audio, photographs and video clips. However, many multimedia systems go beyond one way information presentation.

Terminology

v Text- Written (typed) or printed words, phrases, Sentences, Paragraphs.

v Graphics- Visual symbols-diagrams, drawings, lettering.

v Video- Moving Picture

v Sound-

v Animation- given the appearance of movement

Introduction to Presentation

Presentation graphics enables users to create highly stylized images for slide shows and reports. The software includes functions for creating various types of charts and graphs and inserting for text for text in a variety of fonts. More systems enable you to import data from a Spreadsheet often called business graphics. Some of most popular software are MS Power Point, Lotus freelance graphics, etc

Office Basic

Office Basic

Office Basic 2007 provides office software essentials to homes and small businesses with new computers so that you can perform tasks more quickly and easily. Office Basic 2007 is the office software suite that empowers you to create great-looking documents and spreadsheets. You can also use Office Basic 2007 to efficiently manage your e-mail, calendar, and contacts. With improved menus and tools, enhanced graphics and formatting capabilities, new time and communication management tools, and more reliability and security, Office Basic 2007 makes working at home or at your office easier and more enjoyable.

Microsoft Excel

Microsoft Excel

Introduction

v Microsoft Excel is a spreadsheet application used to process business and financial transactions of various kinds. It is important to know and analyze the application as a software product and as a Windows application.

Excel , a product of Microsoft , is an immensely powerful , popular and easy-to-use spreadsheet package which integrates worksheet , graphics , and database management to a single program. It has a comparative large worksheet to do calculation both scientific & financial.

Typical uses are financial records, scientific analysis and database tasks. The essence of a worksheet is the ability to input formula among the rows & columns of numeric data. In software market there are many brands of spreadsheet packages available. E.g: VisiCalc , SuperCalc , Symphony , Multi – Plan , Spread load , Lotus 1-2-3 , Microsoft Excel etc.

Ø To carry its various tasks, Microsoft Excel organizes each one of its workbooks into worksheets. You can have just one worksheet in a workbook or you can have a lot of worksheets in a workbook.

Introduction

Introduction to word processing packages

What is a Word Processing Package?

The application packages which are developed for preparing, storing and retrieving letters and any other documents accurately, efficiently and attractively are called, word processing packages.

Word processing packages

Word processing packages are computer based system for the entering, editing, storing, and printing of textual materials.

Ø Features of a professional word processing package include;

• Entry of text.
• Formatting of text.
• Editing.
• Output to a printer or a disk.
• Help menus.
• Spell & Grammar checking.
• Thesaurus.
• Pro forma letter templates.
• Mail Merge facility.
• Label printing.

• Introduction to word processing packages
  
  
  
  
  What is a Word Processing Package?
  
  
  The application packages which are developed for preparing, storing and retrieving letters and any other documents accurately, efficiently and attractively are called, word processing packages.
  
  
  
  
  
  
  Word processing packages
  
  
  Word processing packages are computer based system for the entering, editing, storing, and printing of textual materials.
  
  
  Ø Features of a professional word processing package include;
  
  
• Entry of text.
• Formatting of text.
• Editing.
• Output to a printer or a disk.
• Help menus.
• Spell & Grammar checking.
• Thesaurus.
• Pro forma letter templates.
• Mail Merge facility.
• Label printing.

Word

Word Processing (Microsoft Word)

Word processing is a system that processes text, performing basic functions such as paragraphing, aligning, formatting and re-arrangement of a text.

v Word Wrap.

The Automatic adjustment of a line of text to fit in to Pre-specified margins is called word wrapping. When the Cursor meets the end margin the words flew on to new line and continuous,

v Scrolling.

Using the video as a text window and rolling of text up/down or sideways on a screen for viewing long or wider document is called scrolling.

v Soft copy.

A document on the screen is called a Soft copy.

v Hard copy.

Hard copy is a printed document.

v Revising.

The process of editing and if necessary changing the content and/or format of a document using word processing function (Insert, Delete, Move and copy)

v Character.

Any alphanumeric or Graphic symbol

v Word.

Any sequences of a fixed number of characters in a document.

v Line.

A row of characters written, printed or displayed on a VDU

v Sentence.

A piece of writing between two full stops or equivalent pauses.

v Page.

Text in blocks to suit the designed paper length or that, which is written, printed etc. on a page or which fills a VDU screen

v Text.

Data in textual form, especially as stored, processed for displayed in a word processor or text editor.

v Document.

Text-based output created by a word processing program.

Office Basic 2007

Office Basic 2007 provides office software essentials to homes and small businesses with new computers so that you can perform tasks more quickly and easily. Office Basic 2007 is the office software suite that empowers you to create great-looking documents and spreadsheets. You can also use Office Basic 2007 to efficiently manage your e-mail, calendar, and contacts. With improved menus and tools, enhanced graphics and formatting capabilities, new time and communication management tools, and more reliability and security, Office Basic 2007 makes working at home or at your office easier and more enjoyable.

office software

Office Basic 2007 provides office software essentials to homes and small businesses with new computers so that you can perform tasks more quickly and easily. Office Basic 2007 is the office software suite that empowers you to create great-looking documents and spreadsheets. You can also use Office Basic 2007 to efficiently manage your e-mail, calendar, and contacts. With improved menus and tools, enhanced graphics and formatting capabilities, new time and communication management tools, and more reliability and security, Office Basic 2007 makes working at home or at your office easier and more enjoyable.

Office 2007

Office Basic 2007 provides office software essentials to homes and small businesses with new computers so that you can perform tasks more quickly and easily. Office Basic 2007 is the office software suite that empowers you to create great-looking documents and spreadsheets. You can also use Office Basic 2007 to efficiently manage your e-mail, calendar, and contacts. With improved menus and tools, enhanced graphics and formatting capabilities, new time and communication management tools, and more reliability and security, Office Basic 2007 makes working at home or at your office easier and more enjoyable.

Basic

Office Basic 2007 provides office software essentials to homes and small businesses with new computers so that you can perform tasks more quickly and easily. Office Basic 2007 is the office software suite that empowers you to create great-looking documents and spreadsheets. You can also use Office Basic 2007 to efficiently manage your e-mail, calendar, and contacts. With improved menus and tools, enhanced graphics and formatting capabilities, new time and communication management tools, and more reliability and security, Office Basic 2007 makes working at home or at your office easier and more enjoyable.

Office Basic

Office Basic 2007 provides office software essentials to homes and small businesses with new computers so that you can perform tasks more quickly and easily. Office Basic 2007 is the office software suite that empowers you to create great-looking documents and spreadsheets. You can also use Office Basic 2007 to efficiently manage your e-mail, calendar, and contacts. With improved menus and tools, enhanced graphics and formatting capabilities, new time and communication management tools, and more reliability and security, Office Basic 2007 makes working at home or at your office easier and more enjoyable.