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

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” […]

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.