Sub Totals In Microsoft Excel

Microsoft Excel has a subtotal feature calculates subtotals and grand totals for columnar data. The feature supports eleven calculating processes: sum, count, average, maximum, minimum, product, count number, and more.

Read More

Hide The Formula From Being Displayed

In Microsoft Excel 2003, we have an option to hide a formula in a cell and make it invisible to others viewing that sheet.

Read More

Fill Color In A Cell or Group Of Cells

In Microsoft Excel we can fill a cell or group of cells with a color. That can be done in two ways.

Read More

Angle Text In Microsoft Excel

We enter text in cells in Microsoft Excel. If we want that text to be rotated in clockwise or anti clockwise we can do the following. 

Read More

Turn TaskPane On or Off

Task pane is a place where we can see the currently running tasks, previous tasks and an option to go online and connect to Microsoft Office site for further queries or document search. It will be there in all the Microsoft Office Programs. 

Read More

How To Get Drawing Toolbar In Excel

Drawing toolbar helps in editing any drawing object or picture that has been put on the document or spreadsheet. In Microsoft Excel it may not be visible by default. We can view it in following ways.

Read More

Merge Cells and Align Text To Center

In Microsoft Excel when we type something to keep as heading we may end up typing the whole thing in one cell and Excel covers it up with the next column. We can make it into a single cell and align it to the center.

Read More

Create A Form Using An Auto Forms

 Auto Forms are the forms that come with the Office while installing it. There will be some pre-created forms that will come with Microsoft Access by default.

Read More

Create A Form Using Table Or Query

In Microsoft Access we can create a form in many ways. One of the simplest ways is to go to the database main window and create a form.

Read More

Modify Hyperlink Stored In A Table

Microsoft Access gives us an option to modify the hyperlink that is there inside a table or stored in a table.

Read More

Modify Hyperlink Of A Label, Picture

When we want to modify the hyperlink of a label or picture of a command button in Microsoft Access we may change either the text or the address that hyperlink points to. 

Read More

Header and Footer

While writing a book or a document we may need to have pages numbers, or the topic name on that page at the top and continuation topic at the bottom at the bottom but not in text document but below that. Microsoft Office has got this need addressed in Word in the form or Header and Footer. This will help in saving the space on the writing area and gives a professional look to document. When we write an email using word mailmerge option this will help the user to set some date in to the header or footer.

Read More

DropCap in Word 2007

Drop cap is the option to make the first letter of the paragraph bigger than the rest of the paragraph in Microsoft office word. These drop caps make the documents look really professional. It works the same way in 2010 version as well.

Read More

New Features in Microsoft Word

Microsoft word 2010 has brought life to documents with its new features and customizations. Some of its features helps in making our life easier, simple and fast.

Read More

Insert slides in Power Point

Microsoft PowerPoint, usually just called PowerPoint, is a closed source commercial presentation program developed by Microsoft. It is a part of Microsoft Office in all versions. This makes our presentation much attractive and more presentable format. We may need to add the slides to our presentation to fill data.

Read More

Uninstall Office using a tool

There is a tool that will help in uninstalling MS- Office even from the registry completely, it is called Revo-Uninstaller. We can get the product for free of cost on internet. This is a powerful tool for uninstalling any program that is installed on the computer.

Read More

Uninstalling Microsoft Office

Microsoft office is a huge software that has lots of data, files, installation packages etc included in it. When we install it, all the required packages get installed on the system. When we need to upgrade, we need to uninstall the older version first and then proceed with the installation of latest version. This applies to any version and to any suite.

Read More

Excel Basic Terminology

Excel helps in making our financial budgets more easier to plan and easy to make. There are few basic terms that we need to learn if we want to use and understand excel. They are necessary as they help in understanding the excel better if we know them. 

Read More

Office Excel

Excel is considered as mathematician of the computer. It performs all the numerical and logical calculations as well. Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. 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. Excel forms part of Microsoft Office. The current versions are 2010 for Windows and 2011 for Mac.

Read More

Microsoft Office

Microsoft Office is a proprietary commercial office suite of inter-related desktop applications, servers and services for the Microsoft Windows and Mac OS X operating systems, introduced by Microsoft in 1989. This has been the backbone of all the office documentations since its inception. 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 brand.

Applications in office suite: 

• Microsoft Word
• Microsoft Excel
• Microsoft Powerpoint 
• Microsoft  Access(new)
• Microsoft Outlook
• Microsoft OneNote 
• Microsoft Publisher(new) 

Some of these are also available in Microsoft Works. Initially, Word is considered as most important program of office. The first version being released in the autumn of 1983, was for the MS-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 none was required. Later on many applications were added and considered as vital in the office package based on their usage and necessity.


Other Desktop Applications of office: 

• Microsoft Access — database manager
• Microsoft InfoPath — an application to design rich XML-based forms
• Microsoft OneNote — note-taking software for use with both tablet and conventional PCs
• Microsoft Project — project management software to keep track of events and to create network charts and Gantt charts (not bundled in any Office suite)
• Microsoft Publisher — desktop publishing software mostly used for designing brochures, labels, calendars, greeting cards, business cards, newsletters, and postcards.
• Microsoft SharePoint Workspace (formerly known as Groove) — a proprietary peer-to-peer collaboration software leveled at businesses
• Microsoft Visio — diagram and flowcharting software (not bundled in any Office suite)
• Microsoft Office InterConnect — business-relationship database available only in Japan
• Microsoft Office Picture Manager — basic photo management software replaced Microsoft Photo Editor

 System Requirements for Latest Standard Version (2010):

1. 500 MHz or faster processor
2. 256 MB RAM; 512 MB recommended for graphics features and certain advanced functionality.
3. 3.0 GB of available disk space
4. Windows XP ( SP3) (32-bit), Windows 7, Windows Vista with Service Pack (SP) 1, Windows Server 2003 with SP2 and Windows Server 2008, or later 32- or 64-bit OS.
5. Graphics hardware acceleration requires a DirectX 9.0c graphics card with 64 MB or more video memory.

Read More