Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Database calculations automated

	98.1 % recommend us
	More live stats...

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

Training information:

Database calculations automated

Resolved · High Priority · Version 2007

Reply Mon 8 Aug 2011, 12:18Delegate Ian said...

Ian has attended:
Excel Advanced course

Database calculations automated

I am looking to set up a database that can will automatically calculate some figures when a new data set is uploaded. At present, this is being done manually.

Every year a list of athletes is generated where they are assigned to one of 32 sports across two different levels (lets call then a or b).

I would like review these against the previous years intake to generate figures on:

a) the % on the b list which are new, i.e. they were not on the b list last year
b) the % on the b list that are still there from the previous year
c) the % on the b list that are no longer there as they have been promoted to the a list
c) the % from the previous year that are no longer there as they have been relegated / released from the b list

This needs to be done across a number of sports, and thus needs to allow me to separate out accordingly.

For upcoming training course dates see: Pricing & availability

Reply Wed 10 Aug 2011, 09:29Trainer Mark said...

RE: Database calculations automated

Hello Ian,

Thank you for your question.

Could you please send me a sample sheet with some detail on it. This would make it easier to work out the formula and code.
This sample sheet would not have to contain all your data just a sample of layout and data type.

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Reply Thu 11 Aug 2011, 08:49Delegate Ian said...

RE: Database calculations automated

Happy to send something through - can I email this to you? If so, is there anyway we could set up a call to talk through it?

Reply Fri 12 Aug 2011, 09:07Trainer Mark said...

RE: Database calculations automated

Hello Ian

You can send the sample through to mm unfortunately as we are training we can only work with posts during breaks.

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Thu 18 Aug 2011: Automatically marked as resolved.

Excel articles

· Creating Tables Automatically In Excel 2010
· Microsoft Excel Training - Numerical excellence for all
· Why Excel Has More Cloud Coverage
· Do Bright Sparks Use Sparklines?
· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom

Please browse our web site to find out more about
microsoft excel course london and other Microsoft training courses.

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips