Samantha has attended:
Excel Intermediate course
Creating effective profit & loss spreadsheets and spreadsheets t
How do I create a spreadsheet that will show what money was received, what was spent, total sales and value of stock to work out the monthly profit?
I currently have a spreadsheet in use that shows the students target grade and their actual grades and I would like to be able to insert both of these into a mail merge (at the same time on the same document), how do I do this?
RE: Creating effective profit & loss spreadsheets and spreadshee
Hi Samantha
Thanks for getting in touch. There's dozens of ways to lay this out depending on what is logical to you. I've attached a Microsoft template, and a very basic one that I've created to give you some ideas.
With regards to your mail merge, this is quite possible but there's quite a few stages in the process. None of them a re tricky but there's a bit of setting up to do. Here's a Microsoft guide on the subject:
http://support.microsoft.com/kb/294683
If you need further help with this, just let me know.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
GF Profit Loss.xlsx
