Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training seminar - How to I upload information?

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training seminar - How to I upload information?

Resolved · Low Priority · Version Standard

Reply Tue 15 May 2007, 12:40Delegate Kerrie said...

Kerrie has attended:
Excel Intermediate course
Excel Advanced course

How to I upload information?

How do I upload information from an external source?

For upcoming training course dates see: Pricing & availability

Reply Tue 15 May 2007, 14:04Trainer Amanda said...

RE: How to I upload information?

Hi Kerrie

Thanks for your question.

Are you referring to importing data into Excel? If so, go to the Data - Import External Data command for options.

This allows you to import data from databases or off a web page.

Amanda

Excel articles

· How To Create A Simple Currency Convertor In Excel 2010
· Advanced level training: Microsoft Excel and the Web
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Employing Cell References in Excel
· How To Protect Your Work In Excel 2010

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips