creating d formulas
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating 3d formulas

Creating 3d formulas

resolvedResolved · Low Priority · Version 2010

replyReply Wed 14 Dec 2011, 16:54Delegate Germaine said...

Germaine has attended:
Excel Intermediate course

Creating 3d formulas

helpful hints to practice?

For upcoming training course dates see: Pricing & availability

replyReply Tue 20 Dec 2011, 16:30Trainer Andrew said...

RE: creating 3d formulas

Hi Germaine,

Thank you for your question - the main thing to ensure when working with 3D formulas is that the data in your sheets is laid out identically. In other words the values you want to total across the sheets are stored in the same respective cells, regardless of the sheet they are on

I hope this helps - do let me know if you have any further questions.

Kind regards,
Andrew

Tue 27 Dec 2011: Automatically marked as resolved.

 

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

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard