Microsoft Office is a proprietary commercial office suite of inter-related desktop applications, servers and services for the Microsoft Windows operating systems, introduced by Microsoft in 1989. Initially a marketing term for a bundled set of applications, the first version of Office contained:
- Microsoft Word
- Microsoft Excel
- Microsoft PowerPoint
Microsoft Excel is a spreadsheet application. It features calculation, graphing tools, pivot tables and a macro programming language called Visual Basic for Applications. With its powerful functions, Excel has been a very widely applied spreadsheet in many fields.
Excel provides a large number of built-in functions that can be used to perform specific calculations or to return information about your spreadsheet data. These functions are organised into categories (text, logical, math, etc.) to help you to locate the function you need from the Excel menu.
- A workbook is a group of worksheets.
- We can write formulas or functions in a cell with “=” sign.
- Charts are created using chart wizard.
- Formatting does not affect the actual cell value only the appearance change.
Basic Formulas / Functions:
|Name of Formulas||Formula||Description|
|SUM||=SUM ( Number1, Number2, … )||Add all numbers within range resulted into the sum of all numbers. This function is extremely useful for calculating totals across data tables.|
|SUMIF||= SUMIF(range, criteria,[sum_range])||SUMIF extends the logical formulations within IF even further, allowing you to take the sum of items in a range of values contingent upon a given external criteria. For example, if you have a list of sales by date and customer, you could use SUMIF to sum the revenue from sales to a particular customer while ignoring the rest.|
|AVERAGE||=AVERAGE(number1, [number2],…)||Calculate average numbers in a range|
|MAX||=MAX( Number1, Number2, … )||Calculate or find the largest number in a specific range|
|MIN||=MIN( Number1, Number2, … )||Calculate or find the smallest number in a specific range|
|TODAY||=TODAY()||Returns the current date|
|Now||=NOW()||Returns current date and time|
|UPPER||=UPPER(text)||Converts text to uppercase.|
|LOWER||=LOWER(text)||Converts text into lowercase.|
|Countif||=COUNTIF(range, criteria)||This function counts the number of cells within a range that meet a single criterion that you specify.|
|counta||= COUNTA(value1, [value2], …)||This function counts the number of cells that are not empty in a range.|
|ABS||= ABS(number)||returns a value of the same type that is passed to it specifying the absolute value of a number.|
|CONCATENATE||= CONCATENATE (text1, text2)||Excel’s most basic string function, CONCATENATE allows you to combine two strings of text together.|
Microsoft Word Processor is a Software package that enables you to create, edit, print and save documents for future retrieval and reference. Creating a document involves typing by using a keyboard and saving it.
One of the main advantages of a word processor over a conventional typewriter is that a word processor enables you to make changes to a document without retyping the entire document.
- You can change the font, color, size and other style settings for text using Word’s built-in options.
- WordArt is a good option to create and decorate a slogan, quotes in the documents in Microsoft Word. To use this you only need to select the piece of text then select the appropriate color style or decorative text.
- Thesaurus in MS Word helps give you different words with the same meaning (synonym) and words with the opposite meaning (antonym) for the particular word(s) you have typed.
- The mail merge tool in Word can be used to quickly and easily send personalized e‐mails via your Outlook e‐mail application to individuals whose names and e‐mail addresses are contained in an Excel file.
“PowerPoint” refers to Microsoft PowerPoint, a program that allows the user to design a presentation that consists of multiple slides. These slides may contain images, text, video clips, and related types of information. PowerPoint is useful for delivering a speech, because the user can utilize text on the screen to remind him or herself of the information to be conveyed to the audience or to summarize his/her dialogue into more manageable and “friendly” sizes, as well as to entertain or explain graphs, charts, and related data.