Tutorial

1

Excel

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.

Tutorials

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
     
     
     
     
     
     
     
     
     
     
     

 

Exams
 
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
     
     

 

worm

p

 

1

1

bookworm

 

access
Pens
audacity
Corel
Dreamweaver
Excel
Filemaker
Fireworks
Flash
Illustrator
misc
InDesign
Inspiration
Pages
Paintshop
Photoshop
PowerPoint
Soundbooth
Tech
Word
Digital
PJF

 

how to

More Helpful Links (Some may no longer work)

Resources

Microsoft Office Training

MS Online Brochure Templates
MS Online Creating Company Letterhead  

HP Letterhead Templates

Sample Style Guide

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
 
 

email

Email Peter Faulks

clown

Page updated 6th May 2014