[Year 12 IPM] U4O1 hints

[Meadows, Roslyn M]

Mark Kelly wrote:
 
"Please especially enjoy the nested VLOOKUP formulas... I think they're
cool!  :-)"

Whatever turns you on Mark! :-)
 
Don't you just love edumail - the first email Mark sent turned up at 2.06, the second (part 2) turned up at 2.05 - I knew they had upgraded edumail - but it now has the ability to alter the fourth dimension!
 
Cheers
 
Ros Meadows
Bentleigh SC
9579 1044
meadows.roslyn.m at edumail.vic.gov.au
 
"Furious activity is no substitute for understanding." H. H. Williams 

________________________________

From: ipm-bounces at edulists.com.au on behalf of Mark Kelly
Sent: Tue 7/19/2005 1:53 PM
To: IPM List
Subject: [Year 12 IPM] U4O1 hints



Hi All...

Attached is a dummy task showing how mail merge can produce
sophisticated printed output from an Excel solution (e.g. payslips!)

It's *way* over the top with the formulas, but shows how much complex
decision-making can be done in Excel and just pulled into Word for
printed output.

Please especially enjoy the nested VLOOKUP formulas... I think they're
cool!  :-)

Note the way numbers can be formatted in Word to avoid currency figures
with 8 decimal places!

Attached:

complexmerge.doc (the form letter)
complexmerge.xls (data file)
MERGE-WordXP-v4.doc (a tute on how to do advanced mail merge in Word XP)

Have fun!

--
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria Australia
Phone +613 95780844  Fax +613 95789253
http://www.mckinnonsc.vic.edu.au
IPM Lecture notes: http://vceit.com
Moderator: IPM Mailing List

I'm often spick, but never span.
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IPM Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc 



Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 5797 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20050719/5ccaaea1/attachment.bin