advanced excel courses - two more work sheets
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 » advanced excel courses - Two or more work sheets

advanced excel courses - Two or more work sheets

resolvedResolved · Low Priority · Version Standard

replyReply Thu 31 Jan 2008, 12:57Delegate Darren said...

Darren has attended:
Excel Intermediate course

Two or more work sheets

Please could you supply more information on split work sheets and the formulas for totalling years of account etc.

For upcoming training course dates see: Pricing & availability

replyReply Sun 10 Feb 2008, 11:09Trainer Stephen said...

RE: Two or more work sheets

Hi Darren

Thank you for your question

When you say split worksheets do you mean split panes?

If so then a split pane simply allows you to break the window into up to 4 different views, each showing a different section of a worksheet. To do this click on Window-Split, and then go to the required ranges in each window.

As to the second part of your question could you please clarify your requirements, so I can be more specific in my answer

Regards

Stephen

 

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

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