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.
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.
This step by step tutorial covers how to create a simple macro in Excel using the macro recorder.
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
Excel's freeze panes feature keeps headings across the top and down the left side of the sheet from disappearing when you scroll. 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 Freeze Pane Feature
When working with large spreadsheets, the headings at the top of the page and down the side of the sheet disappear when you scroll too far to the right. To avoid this problem, 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 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.