excel learn london - excel

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel learn london - Excel

excel learn london - Excel

resolvedResolved · Low Priority · Version Standard

Cindy has attended:
Excel Intermediate course
Excel Introduction course
Visio Introduction course
Visio Advanced course
Excel Advanced course

Excel

Can I use the Average function in a 3d formula? I get error messages.

RE: Excel

Hi Cindy

Thank you for your question.

You should be able to use the average function in a 3D formula. Using the example we covered today (in the Yearly Sales sheet):

1. Select cell B5 on Creating 3D formulas sheet.
2. Enter the Average function into the cell .
3. Make sure the formula says =average() with your cursor sitting between the brackets.
4. Click on the North sheet, hold down Shift, and keep holding Shift while you click on the West sheet.
5. Let go of the Shift key and click on cell B5 on the North sheet.
6. Press Enter to complete the formula.

I hope this helps.
Amanda

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

View all Excel hints and tips


Server loaded in 0.12 secs.