Mark's Excel Pages (Work in progress)

Available Pages

• Teacher's Friend© Excel Easy Marker and Grader (EMG)
  (An Excel 2000 file/program for teachers to record/display/analyse/grade multiple classes' marks)
• Named Ranges Tutorial
  (Mainly Mathematical Examples)
• VBA Programming Tutorial
  (Mainly Mathematical Examples)
• Worksheet Function Example Files that I've done & found useful!
  (Mainly Mathematical Examples)
• VBA Example Files & Code that I've done & found useful!
  (Mainly Mathematical Examples)
• Code Transferability Tutorial
  (or... how to save your code/Userforms/etc from established Excel files into your "Personal.xls" file for use within any other Excel worksheet.)
• Advanced VBA Tutorials (New resource 17/07/08)
  (Both Excel and Mathematical Examples all given as a lecture course at the TSM 2007 in Oundle School)
  

Links
Excel Experts Pages - See http://www.mvps.org/links.html first!

• Aaron Blood
• Chip Pearson
• David McRitchie
• John F. Larcher
• John Walkenbach
• Stephen Bullen
• Rodney Powell
• Erlandsen Data Consulting
• Rob Bovey Apps Pro
• Frank Isaacs
• Dave Hawley
• Andy Pope
  
• Daily Dose of Excel Some of the kings of Excel chip in to this very informative and humorous site! Lots of code examples given and questions answered.
  

Other very informative Excel Pages covering all aspects

• Mathtools.net > Basic > VBA > Excel
• Mathtools.net > Learning > Books and Tutorials > Excel
• Alan's Excel Page
• Allexperts Excel Q&A
• Controlling File Access
• Matthias Kawski Excel for Maths
• Rob Bruce
• Rodney Carr's Home Page
• Tushar Mehta Main Page
• VBA Tutor
• Excel Business Tools
  Purpose built Excel templates for financial analysis and
  business decision making. (Plus a good set of Excel links)
• Peter Noneley Excel Function Dictionary
• The Excel Logic Page
• OZGrid.com
• VBUsers.com
• Russell Proctor
  Lots of Tutorials on basic, intermediate and advanced Spreadsheet problems, Macros, VBA and Addins together with some Word Macros.
  Be More Productive with Better Excel and Word Solutions for all Microsoft Office users.
• Pivot Tables
  This is Afalina Co., Ltd's Excel site whose primary product is Pivot Table AutoFormat XL but contains many other very useful XL Add-ins and Tools. This is an Excel add-in that allows creating your own collection of autoformats. Home site is at ablebits.com
• Excel User
  Site devoted to business users of Excel. The site contains lots of Excel related articles, latest news and has an excellent "Excel Help Portal" containing links and articles suitable for all levels and interests. Articles can also be submitted to site for review and possible inclusion.
• Excel & Outlook add-ins - Office-Addins.com
  A wide range of add-ins & tools for Excel, Outlook, and other MS Office applications.
  

Mathematical and spreadsheet problems put into Excel - a must for budding VBA programmers, teachers and maths buffs alike.

• Nico Sterk

A very comprehensive Excel/Mathematics links site for Spreadsheets in Education, etc

• Erich Neuwirth

Probably the best Excel Index page on the net

• John F. Raffensperger