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 [...]

Microsoft SharedView

sharedview sign in

{lang: ‘ar’}Microsoft SharedView allows you to collaborate with up to 15 people and conduct remote sessions over the internet  such as holding meetings, exchange notes, and conduct training sessions etc. Windows Live ID (such as Hotmail, MSN, or Passport) is required to start sessions. No Windows Live ID is required to join. The following Windows Operating [...]

Track Change Feature PowerPoint 2007

Comment Box

{lang: ‘ar’} Track Changes is a feature that helps keep track of the revisions made to a document and is commonly used when a document passes through a review cycle. How to enable Track Change feature in PowerPoint? Like the 2003 version, PowerPoint 2007 also does not have a track change feature similar to that [...]

Office 2007 Ribbon Keyboard Shortcuts

ribbon keyboard shortcut

{lang: ‘ar’}Ribbon is new in Office 2007 and represents a collection of tabs and their associated commands or activities. Refer to this article on Office 2007 Ribbon. The Ribbon tabs can also be accessed by using the keyboard. Open Word 2007 document (or Excel 2007) Press and release the Alt key. Note the shortcut key displayed [...]

Office 2007 Ribbon

Office 207 Ribbon

{lang: ‘ar’}Ribbon is new in Office 2007 and represents a collection of tabs and their associated commands or activities. The menus and toolbars of Office 2003 are now represented by the Ribbon in Office 2007. Each tabbed region such as Home, Insert, Page Layout only displays groups of activities that are pertinent to the selected [...]

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 [...]

Split Zip files using 7-Zip

add to archive

{lang: ‘ar’}Using Archive utilities it is possible to split a large Zip file into multiple smaller zip files. For example, e-mail servers may have a limitation as to the size of attachments that can be sent or one would like to offer multiple files to facilitate download via FTP. This article outlines the process of [...]

Replace, insert, or delete pages in Adobe Acrobat

replace pages

{lang: ‘ar’}Adobe Acrobat, Standard or Professional versions provides the feature to replace, insert, or delete pages. The following are the steps: Replace Pages Open the PDF document in which you wish to replace pages Select Document > Replace Pages from the menu Select the File With New Pages and click Select. Replace Pages window is [...]

Using Windows 7 Snipping Tool

snipping tool

{lang: ‘ar’}Windows 7 has a Snipping Tool, which can be used to perform screen capture operations. The captured snip can be saved in file formats such as JPEG, GIF, and PNG. Additionally, the snip can also e-mailed to recipients. The following types of screen capture can done: Free form Snip Rectangular Snip Window Snip Full-screen [...]

Setting Brother MFC – 490CW Wireless Printer

mfc490cw

{lang: ‘ar’}Brother MFC – 490CW is a multi-function printer with fax, print, photocopy, and scan features. It can be connected either in wired or wireless.  Only one mode can be used at a time. This article outlines the steps to setup in wireless mode that enables more than one PC to utilize the services. Image: Used from [...]

Page optimized by WP Minify WordPress Plugin