The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course london - Named cells

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

excel training course london - Named cells

Resolved · Low Priority · Version Standard

ReplyMon 18 Jun 2007, 14:13Delegate Fiona said...

Named cells

Please can you give me examples of when using named cell
would be useful ?

For upcoming training course dates see: Pricing & availability

ReplyMon 18 Jun 2007, 16:07Trainer Richard said...

RE: Named cells

If you were using a range of cells in a formula, then it is useful.

Or if you have multipl eranges that you refer to often

Or if you use data validation for different pages.

Excel articles

· Tips to Facilitate Printing of Excel worksheets
· Simple Ways To Customise Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· So what's new in Excel 2007?
· Save time with Microsoft Excel

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips

Managing And Understanding Tasks In Project

In order to manage how you input tasks (and how Project assigns units of duration or resources to them), you first have to understand the kinds of tasks Project works with, and how it uses algorithms to then further change different elements of the project.

» Article: Advanced ms project

HI! I created a cylindrical timeline diagram. Is it possible to rotate it from horizontal to vertical layout (90 degrees)?

thanks
Gosia

» Forum post: Visio

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions