Microsoft Excel

Probably the most widely used member of the Office family after Word, Excel is the standard in manipulating and presenting numerical data.

As with most other sections on this site, the pages for Excel are split into three main sections:

  • Tips / Tricks - Short snippets of information allowing you to become more productive in creating the documents you want.
  • Tutorials - Longer, full blown articles with detailed instructions on performing bigger tasks using Excel.
  • VBA Tutorials - Visual Basic for Applications tutorials, for those that want to do a little more and 'get down and dirty'.

We hope you find the information you are looking for at our site, but if there is something you need to know that's not listed, please contact us and we will add it to our list of proposed articles.

Tips and Tricks

Excel Glossary - An explanation of some common Excel terms and phrases.
Keyboard Shortcuts - Quick and easy ways to navigate your away around your workbooks.
Longer Undo Lists - How to increase the number of steps in the 'Undo' list.
Handling Dates - Easy ways to use dates in your spreadsheet.
Info Function - Report system information from your Workbook.
Accented Characters - Easily use foreign vowels in your Workbook.

Tutorials

Cell References - The differences between Relative and Absolute cell references explained.
Cell Naming - Navigating your worksheet using cell names and references.
Cell Protection - A guide to securing your Workbook and keeping prying eyes out!
Graphical Comment Boxes - Add pictures or graphical backgrounds to your user prompts.

VBA Tutorials

Learning About Macros & VBA - Part one of a complete guide to getting started on automating your spreadsheet
Learning About Macros & VBA - Part two - modifying your macro and an introduction to VBA syntax.
Learning About Macros & VBA - Part three - adding a command button to run your macros.
VBA Toolbox - Snippets of code to enhance your VBA macros.
Finding User Name - Using VBA to find the name of the currently logged in user.