Microsoft Office

PowerPoint is a presentation program that allows you to create dynamic slide presentations. These presentations can integrate charts, videos, images, narration and much more.

MS PowerPoint provides you with an extensive range of options for making your presentations highly impressive, flexible and exciting. Here we will provide you step by step instructions on how to use Home feature with every tool in PowerPoint for drafting impressive presentations.

Step 1: Go to the “Start Menu”.

Step 2: Type in “Microsoft Office PowerPoint” in the “Search Programs and Files” space and select Microsoft Office PowerPoint 2007 by clicking on it. (Check the Screenshot Below)

Step 3: For inserting a table, click on the “Insert” tab on the Microsoft Excel menu bar.… Read the rest

Microsoft Excel is no doubt the most popular spreadsheet software in the world. It can be used for creating detailed lists, keeping a track of addresses and numerous other tasks. Microsoft Excel is much easier to use as compared to a word processor, especially when you need to carry out frequent changes in your saved data; you can edit or sort the cell data effortlessly by learning how to use Editing Tool in MS Excel.

Working with data in a Microsoft Excel sheet requires you to first enter the data in the cells on the worksheet. Then, you might want to adjust the data such that it displays the information just the way you want.… Read the rest

Developed by Microsoft, Microsoft Excel is a spreadsheet application, which is generally included in the Office package along with other word processing tools. Excel comprises of graphical interfaces, various calculation features, macro programming, etc.

Microsoft Excel is used for generating spreadsheets calculation data on the fly. It can purely be used for data compilation in a table, creating graphs or for compiling financial reports. The basic tools contained in Microsoft Excel sheet include, home, page layouts, insert, data, view, formulas and review.

Working with these data formulas and functions is a step by step process as mentioned below:

Step 1: To get starts, go to the “Start Menu”.… Read the rest

Custom views in MS Excel are used a great deal by professionals who deal with Excel sheet on a daily basis. This feature makes it easy for you to save a set number of display and print settings as “MS Excel Views.” These settings can be readily used by anyone at a later stage. Here is a step-to-step guide on how to work with basic functions and data formulas in MS Excel: Step 1: Go to the “Start” menu and type in Microsoft Excel. Double click on the “Microsoft Office Excel” option to open an MS Excel sheet. (Check the screenshot below)   With MS Excel, you can use one more highly useful option in view – you can also work with workbook views.… Read the rest

PowerPoint is presentation software which is generally used to create impressive slide shows for web-based display, printing or on-screen projection.

If you wish to drive home your message, you can effectively create customized animation effects and play it while delivering the presentation. In addition, to create a lasting impression, you can also make use of professionally designed animation effects. But before you do all that, it’s important that you understand how to use basic animation features with every tool in MS Office PowerPoint. In this post, we will explain just that.

Using Microsoft Office PowerPoint is the easiest way to create effective and understandable presentations.… Read the rest

Countless formatting challenges can be resolved or simplified to a great extent by using the Table insertion feature in Word. In this post, we will demonstrate how you can easily insert a table in a Microsoft Word document.

Essentially, a table can be classified as a series of cells that are very much like a spreadsheet in Excel, except that the layout part and the formatting of a table is a lot more flexible.

MS Office Word 2007 lets you insert a table by choosing from a range of pre-formatted tables.

Alternatively, you can also create your own table by selecting the total number of columns and rows that you require.… Read the rest

MS Word is a popular word processing program used to create documents such as brochures, letters, activities, tests, assignments, etc. Of the many useful features available in Microsoft Word, in this post, we’ll be discussing about how to insert and format Footnotes and Endnotes in a Word 2007 document.

If you follow through the below step by step guide (with screenshots) on inserting footnotes/endnotes in MS Word 2007, you will realize just how easy it is!

“Footnotes” and “Endnotes” are generally displayed in printed documents in order to explain, provide text references, or to insert comments in a document.… Read the rest

When you insert pictures, tables and any other objects in your MS Word document, you’ll certainly want to add captions to it. Captions help to clarify the objects and also make it convenient for you to refer to specific objects within the document. In this post, we will explain how you can insert captions in MS Word with great ease.

Fortunately, MS Word grants the flexibility to easily insert captions for your pictures and tables. Simply follow these simple steps to learn how to insert Caption in Microsoft Word:

Step 1: To get started, go to the “Start Menu”.

Step 2: Type in “Microsoft Office Word” in the “Search Programs and Files” space and click on the Word option.… Read the rest

Pictures can liven up any document. They help in reinforcing your message and give peoples’ eye a welcome rest. But the true reason you’ll want to add pictures, drawings, clip art and more is that it’s super exciting and fun to add life to your pages. In this step by step tutorial, we will demonstrate how you can insert images in Microsoft Word documents.

Pictures or clip-art can be inserted in an MS Word document from various different sources (online or on local hard drive, for example).

For instance, they can be downloaded from website, inserted from a saved folder or even copied from a web page.… Read the rest

MS Word is the most popular word processing program used by students, professionals and businesses all over the world. It is used to create different types of documents including but not limited to flyers, brochures, pamphlets, applications, tests, assignments, lists etc.

In this post, we will be demonstrating how you can insert watermarks in MS Word 2007 documents.

Why are Watermarks Used?

Watermarks are very helpful if you need to manage multiple versions of Word documents or in case you need to add special messages (“Confidential Information,” for example) for others dealing with these documents. For instance, you can distinguish between the original and duplicate copy by marking them with watermarks.… Read the rest

For in-depth analysis of numeric data or to answer unanticipated questions about your worksheet data, it is important that learn how to create a Pivot Table report or a Chart report in MS Excel.

What Use a Pivot Table and Chart Report?

Pivot Table report is an interactive way to quickly summarize, explore, analyze and present summary data. A Chart report, on the other hand, can help you visualize the summary data of Pivot Table report such that you can easily point out the comparisons, trends and patterns. Both the Pivot Table and Chart reports enable you to make informed decisions regarding any critical data in your organization.… Read the rest

Microsoft Word allows users to create and share documents, but often we need to point readers to some source of information on the internet, external files or some other application. The links to such other data sources are known as hyperlinks. By learning how to use hyperlinks in MS Word, you can actually enrich your documents a great deal.

Hyperlink is used to create a sort of shortcut that can be used to open a document stored on the Internet, a network server or the intranet. The moment you click on a Hyperlink function, Windows will try opening the destination file (a web page opened in a web browser, for example).… Read the rest

Developed by Microsoft Corporation, MS Excel is a feature-rich spreadsheet application used by everyone from clerks and accountants to senior management officials in thousands of companies, non-profits and government agencies around the globe. It provides a user with several handy features such as graphing tools, pivot tables and calculation. There are numerous basic tools on an Excel spreadsheet, including home, page layouts, insert, formulas data, view, and review.

Here is a step-to-step guide on how you can use proofing tool in MS Excel:

Step 1: Go to the “Start” menu and type in Microsoft Excel. Double click the option to open an MS Excel sheet.… Read the rest

SharePoint is a product of Microsoft Server. It is normally accessed using a web browser. It is often regarded as the “New moneymaker” of Microsoft. Now the company is trying its best to integrate this feature into the Microsoft Office Suite.

In Access 2007 Help, SharePoint has already been mentioned as the most significant collaboration tool. Many other important changes have also been made to Access, making it function with SharePoint exactly the way it does with multi-valued fields and macro improvements.

These are some easy steps to use SharePoint List feature of External Data Menu in Access 2007:

Step 1: Click on the “External Data” option.… Read the rest

Microsoft PowerPoint is the most commonly used presentation software. You can use it to make slides for on-screen projection, printing, and web-based display. It is a tool which offers ample scope for innovation while creating slides. One of the most useful features of PowerPoint 2007 is its step-by-step instructions on how to perform all popular functions, including the addition of audio elements in PowerPoint 2007.When it comes to creating effective and simply comprehensible presentations, Microsoft Office PowerPoint 2007 is always the first and best choice of a user. Interestingly, you can add sounds to your PowerPoint presentation as well.

Here is how to add audio in PowerPoint 2007:
• Go to the “Start” menu.… Read the rest

As we know, records are usually shown in the same order as they were entered in the database in the beginning.
For example, the entire data coming from the Registrar’s Office is always placed in ‘Student Number’ order. This is the reason why it often becomes difficult to search for a particular name by simply scrolling through the whole records. It is like searching a big library to find a specific book when all the books were listed according to their date of purchase!
However, if the whole data is properly sorted, you can easily find a particular book by scrolling through the records.… Read the rest

A database is software program that helps users store crucial information in a simple retrievable form. Organizations use it majorly to keep record of text, numbers and other such data. The Library Catalogue in a database, for instance, may include the author, title, accession number, and class number.

The latest databases allow storage of many other information types such as dates, pictures, hyperlinks, and sounds. In addition to storage, a database allows you to choose information quickly and effortlessly; choosing from a list of books on a certain subject written by a particular author, for instance.

Above all, it allows you to generate printed summaries of your chosen information.… Read the rest

In this tutorial, we will learn to use the “Tables” feature in Access 2007. Here is a step-to-step guide to the same:

Step 1: Go to the “Start” menu and type in “Microsoft Office” in the “Search programs and files” bar.

Step 2: Click on the “Create” button. As you can see, there are various options to choose from. Pick the one that you need.

Step 3: Click on the “Create” button and go to the “Table” option.

Step 4: Go to the “Create” tab and click on the “Table Templates” button.

Step 5: Now, you can add data using different templates.… Read the rest

In Access 2007, The “Collect” feature is of one of the most important and useful features. As an Access user, you can utilize this feature to make it way easier to keep data organized.

Here is a guide on how to use the Collect Data feature of External Data in Access 2007:

• Click on the “External Data” tab. Now, go to the “Collect Data” option. Here, you can collect data in the form of emails. Check the screenshot below.

How to Collect Data through Email Messages:

• Click on the “Create Email” option.
• This will create an email message including a form for collecting information from users to fill the database.

Like the ‘Collect Data’ feature, the ‘Export’ feature is a highly useful feature of Access 2007.

Here is a step-to-step guide to using the Export feature of External Data in Access 2007:

• Go to the “External Data” tab in MS Access. Here you can easily find the “Export” feature.

• Go to the “External Data” tab and click on the “Saved Exports” option if you want to save the Export files.
• Here you can also view and export all your previously run and saved operations.

• Select the “Destination for the Data” option if you want to export.
• You can also save the sheet or spreadsheet in the same way, as well as export the file.