Forum home » Delegate support and help forum » Microsoft Excel Training and help » Access 2003
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access 2003
Resolved · Low Priority · Version 2003
Reply Tue 17 Feb 2009, 16:49Delegate Toby said...
Toby has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Introduction course
Excel Intermediate course
Access 2003
How do you use the consolidation function?
For upcoming training course dates see: Pricing & availability
RE: Access 2003
Hello Toby
Thank you for your question.
To use Consolidate:
1. Select the sheet you want to create the summary/consolidation of data on, and select the cell that will represent the starting point for the summary when it appears.
2. Go to Data - Consolidate.
3. Use the Reference box to select the cells (including any headings) from each sheet you want to include in the summary, clicking the Add button once you have selected a range from each sheet.
4. Check the All Reference box, to see if you have selected all the cell ranges you wish to include in the summary.
5. Tick the check boxes to use labels from top row and left column. Tick the Create links to source data option if you want the summary figures to update.
6. Click OK.
I hope this helps.
Amanda
Reply Wed 18 Feb 2009, 16:03Delegate Toby said...
RE: Access 2003
Thx and yesterday was really useful!
Any chance you could mail the template for the expense form or tell me where it came from the ones on my PC are different...
Cheers,
T
RE: Access 2003
Hi Toby
Great, I'm glad you found the training useful.
I've attached an Excel file created from the in-built Expenses Statement template that come with the version of Excel I have, I hope this is what you are referring to, if not, let me know.
Kind regards
Amanda
Attached files...
ExpenseStatement.xlsWed 25 Feb 2009: Automatically marked as resolved.
|