Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2003

Thu 2 Jun 2011, 11:14 Delegate Dionne said...

Dionne has attended:
Excel Advanced course

Excel

Can anybody please provide me with some information on books that have excel exercises in them. I want to undertake some more practice on Vlook ups and If functions.

Thu 2 Jun 2011, 13:13 Trainer Anthony said...

RE: Excel

Hi Dionne, thanks for your query. The easiest way to practice those functions are simply to build some dummy data of your own and dive in, but if you need something more formal try this:

http://www.excelexercises.com/

Hope this helps,

Anthony

Training courses

98.7 % recommend us

More live stats...

Training information:

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

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Sorting List Subtotals