Microsoft office introduction

129411.pdf

Page – 1

Microsoft Office

Microsoft was founded by Paul Allen and Bill Gates on April 4, 1975, Paul Allen and Bill Gates, childhood friends with a passion for computer programming, sought to make a successful business utilizing their shared skills. In 1972 they founded their first company, named Traf – O – Data

Microsoft is an American multinational technology company headquartered in Redmond, Washington,

In 1990, Microsoft introduced its office suite, Microsoft Office. The software bundled separate office productivity applications, such as Microsoft Word and Microsoft Excel Microsoft PowerPoint

Microsoft Office 2007 is a version of Microsoft Office, a family of office suites and productivity software for Windows, developed and published by Microsoft. It was released to volume license customers on November 30, 2006

Microsoft Word

Microsoft Word is a word processor developed by Microsoft. It was first released on October 25, 1983. under the name Multi – Tool Word for Xenix systems. A full – featured word processing program for Windows and OS X from Microsoft. Available stand – alone or as part of the Microsoft Office suite, Word contains rudimentary desktop publishing capabilities and is the most widely used word processing program on the market. Word files are commonly used as the format for sending text documents via e – mail because almost every user with a computer can read a Word document by using the Word application, The Office 2007 button, located on the top – left of the window, replaces the File menu and provides access to functionality common across all Office applications, including opening, saving, printing, and sharing a file. It can also close the application Main article: Microsoft Word

1. New style sheets ( quick styles ) and ability to switch easily among them. 2. Default Font now ‘ Calibri ‘ instead of ‘ Times New Roman ‘, as featured in previous versions of Microsoft Office. Word count listed by default in the status bar. The word count dynamically updates as you type. New contextual spell checker, signified by a wavy blue underline to the traditional wavy red underline for misspellings and wavy green underline for grammar errors, sometimes catches incorrect usage of correctly spelled words Translation tool tip option available for English ( U. S. ). French ( France ). and Spanish ( International Sort ). When selected, hovering the mouse cursor over a word displays its translation in the particular language. Non – English versions have different sets of languages. Automated generation of citations and bibliographies according to defined style rules, including APA, Chicago, and MLA Changing style updates all references automatically. Connect to web services to access online reference databases. Preset gallery of cover pages with fields for Author, Title, Date, Abstract, etc. Cover pages follow the theme of the document ( found under the Page Layout tab ). Document comparison engine updated to support moves, differences in tables, and also easy to follow tri – pane view of original document, new document, and differences Full screen reading layout that shows two pages at a time with maximal screen usage, plus a few critical tools for reviewing. 10. The ability to save multiple versions of a document ( which had existed since Word 97 ) has been removed. 38Page – 2
2. Blog entries can be authored in Word itself and uploaded directly to a blog. Supported blogging sites include Windows Live Spaces. Word Press. SharePoint, Blogger. Telligent Community etc. 12. Drops function for Insert / Picture / From Scanner or Camera. Can be added manually 13. Drops the ” Bullets and Numbering ” dialog boxes and rich, easily controlled range of options for formatting Outline Numbered lists Microsoft Excel Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1 – 2 – 3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office. Main article: Microsoft Excel mr 60 N O
3. Support up to 1, 048, 576 rows and 16, 384 columns ( XFD ) in a single worksheet, with 32, 767 characters in a single cell ( 17. 179. 869, 184 cells in a worksheet. 562. 932, 773, 552, 128 characters in a worksheet ) Conditional Formatting introduces support for three new features — 1. Color Scales, 2. Icon Sets and 3. Data Bars. Color Scales, which automatically color the background of a group of cells with different colors according to the values. 2. Icon sets, which precede the text in a cell with an icon that represent some aspect of the value of the cell with respect to other values in a group of cells, can also be applied. Icons can be conditionally applied to show up only when certain criteria are met, such as a cross showing up on an invalid value, where the condition for invalidity can be specified by the user. 3. Data Bars show as a gradient bar in the background of a cell the contribution of the cell value in the group. 3 Column titles can optionally show options to control the layout of the column. Multithreaded calculation of formulae, to speed up large calculations, especially on multi – core / multi – processor systems. User Defined Functions ( UDF ), which are custom functions written to supplement Excel ‘ s set of built – in functions, supports the increased number of cells and columns. UDFs now can also be multithreaded. Server side UDFs are based on the. NET Managed code. Importing data from external sources, such as a database, has been upgraded. Data can also be imported from formatted tables and reports, which do not have a regular grid structure Formula Auto complete, automatically suggests function names, arguments and named ranges, and automatically completing them if desired, based on the characters entered. Formulae can refer to a table as well CUBE functions which allow importing data, including set aggregated data, from data analysis services, such as SQL Server Analysis Services 9. Page Layout view, to author spreadsheets in a way that mirrors the formatting of the printed document 10. Pivot Tables, which are used to create analysis reports out of sets of data, can now support hierarchical data by displaying a row in the table with a ” + ” icon, which, when clicked, shows more rows regarding it, which can also be hierarchical. Pivot Tables can also be sorted and filtered independently, and conditional formatting used to highlight trends in the data.Page – 3
4. Filters, now includes a Quick filter option allowing the selection of multiple items from a drop down list of items in the column. The option to filter based on color has been added to the choices available. 12. Excel features a new charting engine, which supports advanced formatting, including 3D rendering, transparencies and shadows. Chart layouts can also be customized to highlight various trends in the data. Microsoft PowerPoint Microsoft PowerPoint is a slide show presentation program currently developed by Microsoft. PowerPoint initially named ” Presenter “, was created by Forethought Inc.. Microsoft ‘ s version of PowerPoint was officially launched on May 22, 1990, as a part of the Microsoft Office suite. PowerPoint is useful for helping develop the slide – based presentation format, and is currently one of the most commonly used presentation programs available. Main article: Microsoft PowerPoint
5. Improvements to text rendering to support text based graphics. Rendering of 3D graphics. Support for many more sound file formats such as. mp3 and. wma. Support for tables and enhanced support for table pasting from Excel. Slide Library, which lets you reuse any slide or presentation as a template. Any presentation or slide can be published to the Slide Library. Any custom – designed slide library can be saved. Presentations can be digitally signed. 7. Improved Presenter View 8 Added support for widescreen slides. 9. Allows addition of custom placeholders. 10. Drops function for Insert / Picture / From Scanner or Camera. 11. Allows for duplication of a slide through right – clicking it without having to go through Copy and Paste 6