1. Computing

Excel Tips, Tools and Templates

Microsoft Excel contains a number of tools, features, and shortcuts that, while they may not be used all that often, can really simplify working with spreadsheets. Here you will find tips and tutorials on using features such macros, freeze panes, protecting worksheets, and templates that can help to make using Excel as straightforward and as painless as possible.
  1. Excel Shortcut Keys
  2. Excel Tips (25)
  3. Excel Templates (5)

Protect Data in Excel Pt. 1
One of Excel's security features is the Protect Data option. What it does is allow you to lock up all or parts of a spreadsheet to prevent accidental or intentional changes by users. Part 1 covers locking/unlocking specific cells in your spreadsheet.

Protect Data in Excel Pt. 2
One of Excel's security features is the Protect Data option. What it does is allow you to lock up all or parts of a spreadsheet to prevent accidental or intentional changes by users.Step two involves applying the Protect Sheet option. Until step 2 is completed, all data is vulnerable to change.

Excel Macro Tutorial
A macro is a series of commands that carry out a specific task in Excel. To save time when carrying out common operations you can create a macro using the macro recorder that can be run whenever you need to perform the task.

Using Excel's Goal Seek Feature
Excel's Goal Seek feature allows you to alter data in formulas to get different results. Goal Seek can be useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.

Excel Freeze Panes Step by Step Tutorial
To avoid the problem of having the headings at the top or down the side of the sheet disappear when you scroll use Excel's freeze panes feature. This tutorial shows you how to "freeze" those sections of the screen containing titles so that they remain visible at all times.

Excel Split Screen Options
Split Screen options in Excel include using the split box or the split icon on the ribbon. This tutorial includes step by step examples of using both methods to split the screen into multiple panes in Excel.

Excel Hyperlink and Bookmark Step by Step Tutorial
This tutorial covers how to add hyperlinks and bookmarks to an Excel worksheet. The tutorial includes a step by step example of how to add hyperlinks and bookmarks in Excel.

Excel 2003 Macro Tutorial
A macro is a series of commands that carry out a specific task in Excel. To save time when carrying out common operations you can create a macro using the macro recorder that can be run whenever you need to perform the task. This tutorial covers how to create simple macros in Excel 2003 using the macro recorder.

Goal seeking AV Tutorial
Goal Seeking is a useful Excel command for asking "what if" type questions by varying the data in a formula to achieve different results. This site has a very clear and straightforward Audio Visual tutorial that takes you through a step by step example of using Goal Seeking.

Delete Columns in Excel
This tutorial shows you how, quickly delete columns in Excel worksheets.

Excel Paste Link
Using paste link in Excel to have data automatically update in the destination cell(s) when the source data is changed.

©2014 About.com. All rights reserved.