About these tutorials

These tutorials have been created from various Internet sites and have been modified by myself, and in some instances have been reworked or completely re-written to suit my classes. There is an abundance of on line tutorials and most are very useful, however I have had to modify these for high school students and simplify or removed parts of advanced sessions; if students are keen enough they will progress by looking at the links provided. Therefore you should treat these as introductory or beginning tutorials. The easiest start at 100 and progress in difficulty through that range. Where possible I have included links to sites and apologies for any that I might have missed.

Documents in MS Word and MS Excel

Title	Suitable For	Solutions or Files
MXL000 Introduction.doc	Read first How to start with Excel Cells, rows and columns explained	Excel Quick Reference, Microsoft Excel 2004 for Mac Cheat Sheet
MXL000 Introduction (Version 2007)	How to start with Excel Cells, rows and columns explained	MXL000 Introduction S
MXL118 Excel Introduction (Older versions)		MXL129 Data entry in Excel (older versions)
MXL001 Enter text Gnomes	a basic workbook using text and easy formulas	MXL001 Exercise 01 surname
		MXL001 Enter text Gnomes S
MXL002 Text & Merge Sports	a basic workbook using text and easy formulas	MXL002 Exercise 02 surname
		MXL002 Text & Merge Sports S
MXL003 Text & Merge Shares	add text, formulas, formatting, column width and insert rows	MXL003 Exercise 03 surname
		MXL003 Text & Merge Shares S
MXL004 Text & Merge Survey	add text, formulas, formatting, sorting cell height and insert rows	MXL004 Exercise 04 surname
		MXL004 Text & Merge Survey S
MXL005 Absolute Cells	Difference between relative and absolute cells
MXL006 Bodmas Formula	Using brackets for calculations
MXL007 Bike shop IF Sales	and names using &	MXL007 Bike shop IF Sales S
MXL008 Payroll	explains mathematical functions	MXL008 Payroll S
MXL009 Auto fill	use of autofill function	MXL009 Autofill S
MXL010 Ampersand	Basic Introduction	MXL010 Ampersand S
MXL011 Car loan PMT	uses PMT (PMT function returns the payment amount for a loan based on an interest rate and a constant payment  schedule) to calculate loans	MXL011 Car loan PMT S
MXL012 Maths		MXL012 Maths S
MXL013 CountIf	Use Define Name and CountIf	MXL013 CountIf S
MXL014 Ageing
MXL015 Perpetual-calendar
MXL017 Excel Simple Vlookup	Look up postcodes	Instructions on sheet
MXL116 Timeline Excel		MXL116 Excel constructing timelines
MXL117 Budget Intro
MXL118 Vlookup Silly Story	Using V lookup to create a story	Answer is in the questions example of Vlookup

 

	Tests & Exams
MXL016 Test 1 Country Club	A computer based test using Excel to calculate income and expenditure	MXL016 Test 1 Country Club S
MXL100 Excel Test Paper	A written exam for Excel	MXL100 Excel Test Paper S
	Excel solutions for test MXL100	MXL100 Excel Exam S
MXL119 Excel Big Words Q	Using Excel as a database	MXL119 Excel Big Words S
		My_Big_Words
MXL120 Student Budget Test Q	Create a Student Budget (Test after MXL117)	MXL120 Student Budget Test S

 

 

 

Access		Adobe Pens	Audacity	Corel	Dreamweaver	Excel	Filemaker	Fireworks	Flash	Illustrator	Miscellaneous
In Design		Inspiration	Pages	Paint Shop Pro	Photoshop	PowerPoint	Soundbooth	Tech Process	Word	Digital Design	Back To Index

 

More Helpful Links (Some may no longer work)

Resources

Microsoft Office Training

MS Online Brochure Templates
MS Online Creating Company Letterhead  

Office Training from Microsoft

	Office 2003	Office 2007	Office 2010
1	Access 2003	Access 2007	Access 2010
2	Excel 2003	Communicator 2007	Excel 2010
3	FrontPage 2003	Excel 2007	OneNote 2010
4	InfoPath 2003	Live Meeting 2007	Outlook 2010
5	OneNote 2003	OneNote 2007	PowerPoint 2010
6	Outlook 2003	Outlook 2007	Project 2010
7	PowerPoint 2003	PowerPoint 2007	SharePoint 2010
8	Project 2003	Project 2007	SharePoint Workspace 2010
9	Publisher 2003	Publisher 2007	Visio 2010
10	Visio 2003	SharePoint Server 2007	Word 2010
11	Word 2003	Visio 2007
12		Word 2007
Download all training
Download Office 2010 training Download Office 2007 training Download Office 2003 training

Training Sessions

Various training sessions from Microsoft Office for 2007 or 2003 can be located below.  For areas that students are not confident in, please visit this site and watch the videos and demos.

• Admin Toolbox Document Design click through all sections, answer all the questions and print/save important information on document design you feel you may need to refer back to
• Admin Toolbox Sample Document Templates look through these templates to make yourself aware of business industry standard and feel free to use these as templates to be modified for your own needs

• http://office.microsoft.com/en-us/training/FX100565001033.aspx
• MS Online Video Format Painter watch and learn
• MS Online Video Table of Contents
• MS Online Video Creating labels
• MS Online Video Watermarks
• MS Online Video Headers and Footers
• MS Online Video Adding music to Power Point Presentations
• MS Online Video Power Point Templates
• MS Online Video Power Point Presentations
• MS Online video Putting Power Point Presentations onto CD
• MS Online Video Power Point Templates 2
• MS Online Video Power Point - Create Handouts with Your Presentation
• MS Online video Create Your Own Template Video
• Business Letter Tips  
• MS Online Business Letter Templates
• MS Online Tutorial Envelopes
• Create a design template tutorial Select appropriate software (beg: MS Word)
• MS Excel Weekly Time Sheet Template
• Writing Business Letters   
• Business Letters
• Reports
• Report Writing Current Business Practice
• Video on Format Painter

 

Email Peter Faulks

Page updated 6th May 2014