Analyze Data with PivotTables

pivot table example

{lang: ‘ar’}PivotTable helps organize data from an existing data source to facilitate analysis. The data source can be either an Excel workbook (stored locally) or it can be from an external data source such as a relational database, or a Sharepoint list etc.  This article relates to Excel 2007 and uses an internal data source. For OpenOffice [...]

Customize Quick Access Toolbar

word options customize

{lang: ‘ar’}Quick Access Toolbar in Word 2007 displays commands that can be quickly accessed irrespective of the currently displayed tabbed location. Each tabbed region such as Home, Insert, Page Layout only displays activities that are pertinent to the selected tab.  This collection of tabs is called a Ribbon and is new in Office 2007. Frequently [...]

Track items by Active or Closed in Sharepoint Discussion Board

content types

{lang: ‘ar’}[table-of-content] Scenario In Sharepoint Team Discussion Board you have a Status column with values Active and Closed and would like to track the items based on Status and find that it is not possible as the change in status id not reflected in all the threaded items. The output from a sample item is [...]

Disk cleanup utility in Windows 7

diskclean

{lang: ‘ar’}Disk Cleanup utility allows you to delete temporary internet files, recycle bin contents, temporary files, web client files, as well as compress files that have not been accessed for a while to free up space on your hard disk. Starting Disk Cleanup Select Start  and enter cleanmgr in the Search program and files box and [...]

Track Changes in Word 2007

track_changes_toolbar

{lang: ‘ar’} Track Changes, as the term suggests, is a feature in Microsoft Word that helps keep track of the revisions made to a document. This feature is commonly used when two or more users work on the same document or when a document passes through a review cycle. Let us assume that you work [...]

Mail Merge Word 2007

mailmerge_toolbar

{lang: ‘ar’} Mail merge denotes the generation of multiple documents to different recipients from a standard template. The template is a standard Microsoft Word document and the recipient details are typically sourced from a spreadsheet. Example Sales Manager sending out promotional details to all the Dealers listing out the events planned for the dealership area. [...]

Create Macro Button in Excel 2007

office icon menu

{lang: ‘ar’}This article outlines the steps required to create macro button. For example, if you have a macro enabled worksheet and would like the user to have the option to refresh data as required, have a macro button in the worksheet to initiate refresh of the data. The refresh data cited is just an example. [...]

Sharepoint Row Highlight using Behaviors

behavior

{lang: ‘ar’}If you have a long list of items in a Sharepoint list, you may find it convenient to highlight the current row the cursor is on. While there are couple of ways of accomplishing this, this article explains the method of highlighting using Behaviors in Sharepoint Designer. Several tasks can be done using Behaviors, [...]

Disk Cleanup utility in Win XP

{lang: ‘ar’} Disk Cleanup utility allows you to delete temporary internet files, recycle bin contents, temporary files, web client files, as well as compress files that have not been accessed for a while to free up space on your hard disk. Windows 7 Disk Cleanup functions similarly.

Conditional and Auto Formatting in Excel

{lang: ‘ar’}Formatting Microsoft Excel documents with alternate row colors makes it easy to read, especially if there are several rows with varied information. Formatting in Excel can be done by one of the following methods:   Using AutoFormat Using Conditional Formatting

Page optimized by WP Minify WordPress Plugin