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 » Profit and loss

	98.1 % recommend us
	More live stats...

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

Training information:

Profit and loss

Resolved · Low Priority · Version 2007

Reply Mon 29 Nov 2010, 16:32Delegate Charlie said...

Charlie has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Profit and loss

how do you do one

For upcoming training course dates see: Pricing & availability

Reply Tue 30 Nov 2010, 11:04Trainer Nafeesa said...

RE: profit and loss

Hi Charlie,

Thank you for your question.

Please see the link below for a full explanation on the creation of a profit & loss spreadsheet.

http://www.ehow.com/how_5224764_build-profit-loss-statement-excel.html

The link below provides templates of various profit & loss spreadsheets that you can download an use,

http://office.microsoft.com/en-us/templates/results.aspx?qu=profit+and+loss&origin=CT010117232

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.

Regards,

Nafeesa

Microsoft Office Specialist Trainer

Reply Tue 30 Nov 2010, 11:04Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Tue 7 Dec 2010: Automatically marked as resolved.

Excel articles

· Experience The Power Of PowerPivot
· Fun Things I've Done With Excel
· Make Things Easier In Excel With Lists
· Tap the Power of Recorded Macros with MS Excel Courses
· The Importance of Data Backups

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

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips