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

excel training uk - excel advanced

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training uk - Excel Advanced

excel training uk - Excel Advanced

ResolvedVersion Standard

Ashraful has attended:
Excel Advanced course

Excel Advanced

Is there an easy way of importing txt files that allow all the numbers to be used with formulas if currency is included into excel?

RE: Excel Advanced

Dear Ashraful

Thank you for attending our Excel Adv. course. I hope you benefited from the course.

Your question about importing text files is not uncommon. As far as I know if you import a text file the values are automatically imported as currency as far as you have entered the

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.