How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Link Tutorials
Excel External References
An external reference (also called link) is a reference to a cell or range of cells in another Excel workbook.
Long Data Entries with AutoCorrect
AutoCorrect is Excel's attempt to save you time when doing data entry in a spreadsheet. It anticipates what you enter and, if necessary, corrects it or converts it into special types of data such as live hyperlinks and smart tags
Create a List of Workbook Hyperlinks
Use a bit of Excel VBA macro code to create a list of hyperlinked Excel workbook names on any Excel worksheet.
Styles in Microsoft Excel
This short tutorial explains about working with styles in Microsoft Excel. Follow the below link for more details.
Working with Graphics in Microsoft Excel
This short tutorial explains about working with graphics in Microsoft Excel. Follow the below link for more details.
Paste Special in Excel
The Paste Special command has a number of useful tools built into it. Besides allowing you to Paste values, it also allows you to transpose lists (columns to rows or rows to columns), multiply, add, skip blanks and paste links.
External Links in Excel
Excel is often used to link multiple spreadsheets. However, the risks associated with handling these links is often misunderstood. This will show you a feature in Excel which allows you to identify your external links, change the source if necessary and break links.
The Auditing Toolbar is one if Excel's best kept secrets. It allows you to visualize the cells used in any formula. In particular is allows you to view what cells are being used by a particular formula, what other cells are relying on the cell you have specified, follow links to other spreadsheets and more recent versions of Excel include some error checking capabilities.
HYPERLINKS in Excel
Learn how to use hyperlinks to navigate through a spreadsheet or to other electronic documents. Easier (and safer) than using visual basic and macros to set up the navigation.