Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Excel advance

excel consultants - Excel advance

ResolvedVersion Standard

Wed 19 Sep 2007, 16:33 Delegate Edyta said...

Edyta has attended:
Excel Advanced course

Excel advance

How can I export information from Sage line 50 into excel?

Tue 25 Sep 2007, 11:57 Trainer Anthony said...

RE: Excel advance

Hi Edyta. I believe there is a File-Send Contents facility in Sage to do this, although it might be a bit messy. What you basically need to do is export the Sage file in "CSV" format and then open that in Excel. The following weblink should give you a few more pointers:

http://www.accountingweb.co.uk/cgi-bin/item.cgi?id=131694

Hope this helps,

Anthony

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel consultants - Excel advance

Excel advance

RE: Excel advance

Excel articles

Excel tip:

Use shortcut keys to select rows or columns