Named ranges

February 17th, 2010 Sam No comments

Names that are provided to a range of cells are knows as named ranges. Named ranges are helpful in referencing a cell or the range in any part of an Excel worksheet. Descriptive names can be given to represent a cell, a range, a formula etc.

  • Share/Bookmark
Categories: Uncategorized Tags:

Cell Style in Excel 2007

February 16th, 2010 Sam No comments

A cell style is a defined set of formatting characteristics available in Excel, such as fonts and font sizes, number formats, cell borders, and cell shading. A cell style is used to apply several formats quickly. It also ensures that cells have consistent formatting. Several built-in cell styles are provied by Microsoft Excel that can be applied on cells. Users can also modify these styles to create custom cell styles.

  • Share/Bookmark
Categories: 77-602 Tags: , ,

Valentine’s Day offer from uCertify

February 15th, 2010 Sam No comments

Valentine’s Day is an annual holiday held on February 14 celebrating love and affection between intimate companions. In the Valentine week, uCertify is also offering discounts on the PrepKits. You can enjoy discount of 45% on the purchase of any 3 PrepKits. This offer is limited to first 300 customers only.

To purchase now, click: https://www.ucertify.com/cart/todays-deal.php

  • Share/Bookmark

Data validation in Excel 2007

February 12th, 2010 Sam No comments

Data validation is a process through which restrictions are applied on the data to be entered in a cell. It is a simple rule, which is applied to a field or an attribute of a cell to validate the data to be entered. Validation ensures that no other content is inserted in the respective cell.

It is the process of ensuring that a program operates on clean, correct and useful data. It uses routines, often called “validation rules” or “check routines”, that check for correctness, meaningfulness, and security of data that are input to the system.

  • Share/Bookmark
Categories: 77-602 Tags:

Index vs Table of Contents

February 11th, 2010 Sam No comments

An index is a list of words arranged alphabetically at the end of a book. Index helps a reader to find the information quickly and easily. The words in the index are given along with the page numbers where they occur to help the reader to quickly go to the desired word.

An index is a list of words arranged alphabetically at the end of a book. Index helps a reader to find the information quickly and easily. The words in the index are given along with the page numbers where they occur to help the reader to quickly go to the desired word.

  • Share/Bookmark

Document Map vs Thumbnail

February 10th, 2010 Sam No comments

Document Map is an alternative to Outline View. It uses the same outline levels as employed in an Outline View. It is shown along the left side of the document window. It is known as Document Navigation Tool. Thumbnail and Document Map cannot be viewed together.

Thumbnail is a pane that appears along the left side of the document window. It shows the pictures of each page in the pane on which a user can click and go directly to the clicked page. It is also known as Document Navigation Tool.

  • Share/Bookmark
Categories: 77-601 Tags: , ,

What is a watermark?

February 9th, 2010 Sam No comments

A watermark is a text or a picture that appears behind the text. It is used for printed documents. A user can add watermarks such as Draft, Confidential, Preview, etc. A watermark does not interfere with the written text and is placed in the background in a very light color. It tells the status of the document such as Draft.

  • Share/Bookmark
Categories: 77-601 Tags:

uCertify’s Microsoft Certified Application Specialist (MCAS) Prepkit

February 8th, 2010 Sam No comments

The Microsoft Certified Application Specialist (MCAS) certification is designed to validate skills in using the 2007 Microsoft Office system and the Windows Vista operating system and meeting the demand for the most up-to-date skills on the latest Microsoft technologies. This certification can help you differentiate yourself in today’s competitive job market, broaden your employment opportunities by displaying your advanced skills, and result in higher earning potential. Candidates who successfully complete the program by passing a certification exam show that they can meet globally recognized performance standards.

To get Microsoft Certified Application Specialist (MCAS) certification, you have to pass any one of the following tests:

  • Share/Bookmark

uCertify’s new 70-633 PrepKit

February 6th, 2010 Sam No comments

uCertify has recently released the PrepKit for the 70-633 Project Server 2007 exam. The test is designed to help project managers apply the leading project management best practices and methodologies as established by the Project Management Institute (PMI), resulting in better project outcomes, greater efficiency, and optimal resource management.

To download the free trial of the practice test go to the link: http://www.ucertify.com/exams/Microsoft/70-633.html

When you pass Exam 70-633: TS: Microsoft Office Project Server 2007, Managing Projects, you complete the requirements for the following certification(s):

Microsoft Certified Technology Specialist: Enterprise Project Management with Microsoft Office Project Server 2007

  • Share/Bookmark
Categories: News Tags: ,

Reading Pane in Outlook 2007

February 5th, 2010 Sam No comments

Reading Pane is a window of Microsoft Outlook 2007. It is used to preview messages and attachments. It is also used to review information of a message. A user can turn off Reading Pane by using the View menu. It is necessary to view a message carefully and safely in Reading Pane.

  • Share/Bookmark
Categories: 77-604 Tags: