Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel xp training - Excel array (using Bloomberg table wizard)

excel xp training - Excel array (using Bloomberg table wizard)

ResolvedVersion Standard

Tue 19 Jun 2007, 14:07 Delegate Ronnie said...

Ronnie has attended:
Excel Intermediate course
Excel Advanced course

Excel array (using Bloomberg table wizard)

How do I amend part of a Bloomberg data array, or set it up to allow amendments in future?

Ronnie

Thu 28 Jun 2007, 16:38 Trainer Anthony said...

RE: Excel array (using Bloomberg table wizard)

Data on share prices, currencies etc that appear on the Bloomberg website can be copied and pasted into Excel and manipulated therein. To amend raw data from a dedicated financial information service such as Datastream you need to work for Datastream! Charts and reports are created on a bespoke basis from proprietory data. To amend it, you need access to the source.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

excel xp training - Excel array (using Bloomberg table wizard)

Excel array (using Bloomberg table wizard)

RE: Excel array (using Bloomberg table wizard)

Excel articles

Excel tip:

Adding date and time