Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Spread Sheet

	98.1 % recommend us
	More live stats...

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

Training information:

Excel Spread Sheet

Resolved · Urgent Priority · Version 2007

Reply Wed 1 Sep 2010, 14:48Delegate Jermaine said...

Jermaine has attended:
Excel Intermediate course
Excel Advanced course

Excel Spread Sheet

Hi,

I want to be able to have a excel spreadsheet which allows me to enter a project code from a list of projects which then works out which is the correct company. then i would like the spreadsheet to add up all the various companies and overheads.

For upcoming training course dates see: Pricing & availability

Reply Fri 3 Sep 2010, 09:32Trainer Jacob said...

RE: Excel Spread Sheet

Hi Jermaine

Thanks for your post. Yes we can most likely assist with building this spreadsheet for you however it beyond the means of this forum.

If you are interested in progressing this we would ask you for working files and a bullet list of objectives which will enable us to get back to you with a scope of work, durations and related costs.

Kind regards

Jacob

Excel articles

· Charting Your Success With Excel 2007
· Tips From Excel's 'Rarely Used' File
· How To Learn From Your Excel Mistakes
· Discover How To Use Fill In Excel
· How To Link Between Spreadsheets In Excel

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

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips