Select a Category

How to display data from other Excel file in Excel 2010?

Description

There are multiple ways to pull data from one Excel spreadsheet to second Excel spreadsheet. It is up to Excel file author to decide which way to use. Present here is a way to pull data through external source data. External data source gives users control on when to update External data.

Steps […]

November 29th, 2014 | Category: Computer, Excel, Microsoft Office | Comments are closed

How to pull data from Oracle to Excel 2010?

Problem

How to display Oracle data to users without Oracle interface software? Most users have Excel 2010 installed. Excel 2010 can pull data from Oracle for display.

Steps to setup Excel to pull data from Oracle

Click on “Data” tab in Excel and select “From Other Sources” in “Get External Data” ribbon group. Select “Other/Advanced” […]

November 22nd, 2014 | Category: Computer, Database, Excel, Microsoft Office, Oracle | Comments are closed

How to map network drive in Windows 7

Mapping network drive in Windows 7 is easy, right at the start menu:

Follow on screen instructions to finish it.

November 19th, 2014 | Category: Computer, Windows, Windows 7 | Comments are closed
 
  Older Entries »