financial excel course london - Open sheet

The UK's most regular instructor-led training courses.
Training information: financial excel course london · Excel-courses-london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Open sheet

Rosa has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Rosa [2 posts] (2007 Mar 20 Tue, 09:35) Reply

how do i make sure the spreadsheet opens at the first sheet?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: open sheet

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 20 Tue, 10:20) Reply

Hi Rosa,

To open a spreadsheet at the first sheet you must be in the first sheet when you save and close the spreadsheet. The computer will open the spreadsheet on the tab/sheet you last closed it on.

Enjoy your training and I hope that helped

Tracy

· Database Tips from an Excel Training Course
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Tips to Facilitate Printing of Excel worksheets
· How Small Businesses Profit from Outside Excel Training

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips