excel training courses - Excel

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

Resolved · Low Priority · Version Standard

Excel

Louise has attended:
Excel Introduction course
Outlook Introduction course
Word Intermediate course

by - delegate Louise [3 posts] (2007 Aug 1 Wed, 12:57) Reply

how do you insert new rows?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: excel

by - trainer Amanda diamond contributer [1199 posts] (2007 Aug 1 Wed, 15:54) Reply

Hi Louise

Thanks for your question.

You can insert new rows in a spreadsheet by selecting the row below where you want your new row to appear; then right-click and select Insert from the shortcut menu.

Amanda

· Interesting Lifestyle Applications for Microsoft Excel
· How Small Businesses Profit from Outside Excel Training
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Microsoft Excel Training - Numerical excellence for all
· Do You Really Need Excel VBA 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